{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1790845735,
                "last": 1790845735,
                "now": 1790845735
            },
            "client": {
                "forwarded": "216.73.217.103"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__findCount": {
        "Listing": {
            "f6a211532c587b5609aac460b6cb7023": "22"
        }
    }
}

Time

Memory

34 Queries Logged 4.80 ms

1. Query Time: 0.09 ms Query memory: 0.023 MB Memory before query: 1.014 MB Rows returned: 0

   SELECT `data`
   
     FROM `i8xqe_session`
   
     WHERE `session_id` = 'b776a0dd162face6715fa579e10872bc'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	i8xqe_session	const	PRIMARY	PRIMARY	194	const	1	100.00

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.00 ms
   Executing	0.00 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.05 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 1.028 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `i8xqe_session`
   
     WHERE `session_id` = 'b776a0dd162face6715fa579e10872bc' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	i8xqe_session	const	PRIMARY	PRIMARY	194	const	1	100.00

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.00 ms
   Optimizing	0.00 ms
   Statistics	0.00 ms
   Preparing	0.00 ms
   Executing	0.00 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.004 MB Memory before query: 1.033 MB

   INSERT INTO `i8xqe_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('b776a0dd162face6715fa579e10872bc', 1, 1790845735, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `i8xqe_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('b776a0dd162face6715fa579e10872bc', 1, 1790845735, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.01 ms
   Update	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.02 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 0.12 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 1.065 MB Rows returned: 38

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `i8xqe_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	i8xqe_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.05 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.05 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.092 MB Rows returned: 5

   SELECT id, rules
   
     FROM `i8xqe_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	i8xqe_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.00 ms
   Optimizing	0.00 ms
   Statistics	0.00 ms
   Preparing	0.00 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 1.104 MB Rows returned: 2

   SELECT b.id
   
     FROM i8xqe_usergroups AS a
   
     LEFT JOIN i8xqe_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.030 MB Memory before query: 1.125 MB Rows returned: 91

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM i8xqe_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	i8xqe_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	228	49.56	Using where; Using filesort

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.00 ms
   Sorting result	0.00 ms
   Executing	0.00 ms
   Sending data	0.00 ms
   Creating sort index	0.09 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 0.15 ms After last query: 1.47 ms Query memory: 0.101 MB Memory before query: 1.629 MB Rows returned: 39

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM i8xqe_menu AS m
   
     LEFT JOIN i8xqe_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	70	64.29	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.m.component_id	1	100.00	Using where

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Sorting result	0.00 ms
   Executing	0.00 ms
   Sending data	0.00 ms
   Creating sort index	0.07 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:48
   8	plgSystemJreviews_sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.07 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 1.809 MB Rows returned: 1

   SELECT *
   
     FROM i8xqe_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	i8xqe_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.00 ms
   Statistics	0.00 ms
   Preparing	0.01 ms
   Sorting result	0.00 ms
   Executing	0.00 ms
   Sending data	0.00 ms
   Creating sort index	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   10	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:109
   9	JReviewsRouter->__construct()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:50
   8	plgSystemJreviews_sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 0.08 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 1.899 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `i8xqe_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/crisp/crisp.php:53
    8	plgSystemCrisp->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.07 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 1.892 MB

    UPDATE `i8xqe_extensions`
    
      SET `params` = '{\"mediaversion\":\"0d8a61460309d9c47a9237d59c9ef815\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    checking permissions	0.00 ms
    After opening tables	0.00 ms
    init for update	0.00 ms
    init	0.00 ms
    Updating main table	0.00 ms
    init	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    init for update	0.01 ms
    Updating	0.01 ms
    End of update loop	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/crisp/crisp.php:53
    8	plgSystemCrisp->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.10 ms After last query: 0.54 ms Query memory: 0.050 MB Memory before query: 2.007 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM i8xqe_template_styles as s
    
      LEFT JOIN i8xqe_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	100.00	Using index condition; Using where
    1	SIMPLE	s	ref	idx_template	idx_template	202	stage_un1_stage.e.element	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.03 ms After last query: 1.07 ms Query memory: 0.006 MB Memory before query: 2.763 MB

    
      SET SQL_BIG_SELECTS=1

    Explain

    EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

    Profile

    Status	Duration
    Starting	0.01 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    10	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:91
    8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.16 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 2.769 MB Rows returned: 1

    SHOW TABLES LIKE '%_jreviews_config'

    Explain

    EXPLAIN not possible on query: SHOW TABLES LIKE '%_jreviews_config'

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Filling schema table	0.00 ms
    checking permissions	0.09 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    11	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    10	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:40
    9	JReviews\Models\ConfigurationModel::tableCreated()	JROOT/components/com_jreviews/jreviews/framework.php:93
    8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 0.07 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 2.775 MB Rows returned: 1

    SELECT value 
      FROM i8xqe_jreviews_config 
      WHERE id = 'cms_secret'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_config	const	PRIMARY	PRIMARY	767	const	1	100.00

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:98
    8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 0.08 ms After last query: 0.48 ms Query memory: 0.022 MB Memory before query: 3.214 MB Rows returned: 0

    SELECT name 
      FROM i8xqe_jreviews_addons 
      WHERE state = 1 
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_addons	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    10	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:174
    8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 0.12 ms After last query: 2.73 ms Query memory: 0.033 MB Memory before query: 5.202 MB Rows returned: 11

    SELECT Field.fieldid AS `Field.fieldid`,
    Field.name AS `Field.name`,
    Field.title AS `Field.title`,
    Field.type AS `Field.type`,
    Field.required AS `Field.required`,
    Field.access AS `Field.access`,
    Field.access_view AS `Field.access_view`,
    Field.options AS `Field.options`,
    Field.showtitle AS `Field.showtitle`,
    Field.description AS `Field.description`,
    Field.groupid AS `Field.groupid`,
    Field.location AS `Field.location`,
    Field.size AS `Field.size`,
    Field.maxlength AS `Field.maxlength`,
    Field.cols AS `Field.cols`,
    Field.rows AS `Field.rows`,
    Field.contentview AS `Field.contentview`,
    Field.ordering AS `Field.ordering`,
    Field.listview AS `Field.listview`,
    Field.compareview AS `Field.compareview`,
    Field.listsort AS `Field.listsort`,
    Field.search AS `Field.search`,
    Field.published AS `Field.published`,
    Field.control_field AS `Field.control_field`,
    Field.control_value AS `Field.control_value`
     
      FROM i8xqe_jreviews_fields AS `Field`
     
      WHERE 1 = 1 
      AND ( 
       Field.location = 'content'
       
      AND Field.published = 1
       
      AND Field.search = 1
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Field	ALL	search,entry_published,list_published	NO INDEX KEY COULD BE USED	NULL	NULL	11	100.00	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    16	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    15	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/models/field.php:1905
    12	FieldModel->getFieldNames()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:476
    11	ListingsRepositoryComponent->buildFieldsParamsArray()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1065
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 0.06 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 5.210 MB Rows returned: 1

    SELECT
                        name, type
                    
      FROM
                        i8xqe_jreviews_fields
                    
      WHERE
                        name IN ('jr_productiontype')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_fields	const	name	name	152	const	1	100.00

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    15	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    14	S2Model->query()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:682
    13	ListingsRepositoryComponent->processFieldsConditions()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:336
    12	ListingsRepositoryComponent->advancedSearch()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:268
    11	ListingsRepositoryComponent->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1148
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 0.09 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 5.222 MB Rows returned: 1

    SELECT
                        Category.id
                    
      FROM
                        i8xqe_categories AS Category,
                        i8xqe_categories AS ParentCategory
                    
      WHERE
                        Category.published >= 0
                        
      AND Category.extension = "com_content"
                        
      AND Category.access IN ( 1,5)
                        
      AND Category.lft BETWEEN ParentCategory.lft 
      AND ParentCategory.rgt
                        
      AND ParentCategory.id = 93

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ParentCategory	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	Category	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	1	13.33	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    17	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    16	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:419
    15	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:281
    14	EverywhereComContentModel->addCategoryFiltering()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:225
    13	ListingsRepositoryComponent->prepareQueryData()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:166
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 0.07 ms After last query: 0.01 ms Query memory: 0.025 MB Memory before query: 5.231 MB Rows returned: 2

    SELECT id 
      FROM i8xqe_jreviews_categories 
      WHERE `option` = "com_content"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_categories	ref	option	option	152	const	2	100.00	Using where; Using index

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    17	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    16	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:427
    15	EverywhereComContentModel->getCatIdsFromParentCatId()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:281
    14	EverywhereComContentModel->addCategoryFiltering()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:225
    13	ListingsRepositoryComponent->prepareQueryData()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:166
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 0.58 ms After last query: 0.12 ms Query memory: 0.080 MB Memory before query: 5.252 MB Rows returned: 22

    SELECT Listing.id AS `Listing.listing_id`,
    Listing.alias AS `Listing.slug`,
    Listing.title AS `Listing.title`,
    Listing.introtext AS `Listing.summary`,
    Listing.fulltext AS `Listing.description`,
    Listing.images AS `Listing.images`,
    Listing.hits AS `Listing.hits`,
    Listing.catid AS `Listing.cat_id`,
    Listing.created_by AS `Listing.user_id`,
    Listing.created_by_alias AS `Listing.author_alias`,
    Listing.created AS `Listing.created`,
    Listing.modified AS `Listing.modified`,
    Listing.access AS `Listing.access`,
    Listing.state AS `Listing.state`,
    Listing.publish_up AS `Listing.publish_up`,
    Listing.publish_down AS `Listing.publish_down`,
    Listing.metakey AS `Listing.metakey`,
    Listing.metadesc AS `Listing.metadesc`,
    'com_content' AS `Listing.extension`,
    Field.featured AS `Listing.featured`,
    JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
    Category.id AS `Category.cat_id`,
    Category.title AS `Category.title`,
    Category.alias AS `Category.slug`,
    Category.params AS `Category.params`,
    Directory.id AS `Directory.dir_id`,
    Directory.desc AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    User.id AS `User.user_id`,
    User.name AS `User.name`,
    User.username AS `User.username`,
    User.email AS `User.email`,
    User.block AS `User.block`,
    Claim.approved AS `Claim.approved`,
    Totals.user_rating AS `Review.user_rating`,
    Totals.user_rating_count AS `Review.user_rating_count`,
    Totals.user_criteria_rating AS `Review.user_criteria_rating`,
    Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
    Totals.user_comment_count AS `Review.user_review_count`,
    Totals.editor_rating AS `Review.editor_rating`,
    Totals.editor_rating_count AS `Review.editor_rating_count`,
    Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
    Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
    Totals.editor_comment_count AS `Review.editor_review_count`,
    Totals.media_count AS `Listing.media_count`,
    Totals.video_count AS `Listing.video_count`,
    Totals.photo_count AS `Listing.photo_count`,
    Totals.audio_count AS `Listing.audio_count`,
    Totals.attachment_count AS `Listing.attachment_count`,
    (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
    (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
    (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
    (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
    (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
    Totals.media_count_user AS `Listing.media_count_user`,
    Totals.video_count_user AS `Listing.video_count_user`,
    Totals.photo_count_user AS `Listing.photo_count_user`,
    Totals.audio_count_user AS `Listing.audio_count_user`,
    Totals.attachment_count_user AS `Listing.attachment_count_user`
     
      FROM i8xqe_content AS Listing
    
      LEFT JOIN i8xqe_jreviews_listing_totals AS Totals 
      ON Totals.listing_id = Listing.id 
      AND Totals.extension = 'com_content'
    
      LEFT JOIN i8xqe_jreviews_content AS Field 
      ON Field.contentid = Listing.id
    
      LEFT JOIN i8xqe_jreviews_categories AS JreviewsCategory 
      ON JreviewsCategory.id = Listing.catid 
      AND JreviewsCategory.`option` = 'com_content'
    
      LEFT JOIN i8xqe_categories AS Category 
      ON Category.id = Listing.catid 
      AND Category.extension = 'com_content'
    
      LEFT JOIN i8xqe_jreviews_directories AS Directory 
      ON Directory.id = JreviewsCategory.dirid
    
      LEFT JOIN i8xqe_users AS User 
      ON User.id = Listing.created_by
    
      LEFT JOIN i8xqe_jreviews_claims AS Claim 
      ON Claim.listing_id = Listing.id 
      AND Claim.user_id = Listing.created_by 
      AND Claim.approved = 1
     
      WHERE 1 = 1 
      AND ( 
        (Field.jr_productiontype = '*bring-em-
      on*')
       
      AND Listing.catid IN (93)
       
      AND Listing.state = 1
       
      AND Listing.access IN ( 1,5)
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2026-10-01 21:00:00" )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2026-09-30 21:00:00" )
     )
     
      ORDER BY Listing.ordering
     
      LIMIT 50

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	ref	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	idx_catid	4	const	44	98.31	Using where; Using filesort
    1	SIMPLE	Totals	eq_ref	PRIMARY	PRIMARY	156	stage_un1_stage.Listing.id,const	1	100.00	Using where
    1	SIMPLE	JreviewsCategory	const	PRIMARY,option	PRIMARY	156	const,const	1	100.00	Using where
    1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Listing.id	1	100.00	Using where
    1	SIMPLE	Category	const	PRIMARY,cat_idx	PRIMARY	4	const	1	13.33	Using where
    1	SIMPLE	Directory	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.JreviewsCategory.dirid	1	100.00	Using where
    1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Listing.created_by	1	100.00	Using where
    1	SIMPLE	Claim	ref	listing_id,user_id,approved	listing_id	4	stage_un1_stage.Listing.id	1	100.00	Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.27 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    16	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    15	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.08 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 5.549 MB Rows returned: 1

    SELECT
                        groupid
                    
      FROM i8xqe_jreviews_groups
                    
      WHERE
                        groupid IN (2)
                        
      AND type = 'content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_groups	const	PRIMARY,type	PRIMARY	4	const	1	100.00

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    20	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    19	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:632
    18	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:898
    17	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    16	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 0.15 ms After last query: 0.01 ms Query memory: 0.027 MB Memory before query: 5.561 MB Rows returned: 5

    SELECT
                    Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`,
                    Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`,
                    Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`,
                    Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`,
                    Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`,
                    Field.published As `Field.published`, Field.ordering AS `Field.ordering`,
                    `
      Group`.groupid AS `
      Group.group_id`, `
      Group`.title AS `
      Group.title`, `
      Group`.name AS `
      Group.name`, `
      Group`.showtitle AS `
      Group.showTitle`, `
      Group`.ordering AS `
      Group.ordering`
             
      FROM
                i8xqe_jreviews_fields AS Field
             
      LEFT JOIN
                i8xqe_jreviews_groups AS `
      Group` 
      ON `
      Group`.groupid = Field.groupid
             
      WHERE
                Field.published = 1
                
      AND Field.location = 'content'
                
      AND Field.groupid IN ( 2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Field	ref	groupid,entry_published,list_published	groupid	4	const	5	100.00	Using where
    1	SIMPLE	Group	const	PRIMARY	PRIMARY	4	const	1	100.00

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    18	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:929
    17	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    16	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.09 ms After last query: 0.02 ms Query memory: 0.028 MB Memory before query: 5.583 MB Rows returned: 22

    SELECT
                                Listing.contentid AS element_id,jr_artistwebsite,jr_productiontype,jr_defininggear,jr_defininggearcustom,jr_defininggeartext
                            
      FROM
                                i8xqe_jreviews_content AS Listing
                            
      WHERE
                                Listing.contentid IN (435,447,440,439,438,446,441,359,358,360,361,362,363,364,365,366,367,368,369,370,371,354)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	range	PRIMARY	PRIMARY	4	NULL	22	100.00	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    18	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1014
    17	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    16	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 0.11 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 5.607 MB Rows returned: 1

    SELECT
                            *
                        
      FROM
                            i8xqe_jreviews_fieldoptions
                        
      WHERE
                            fieldid IN ( '12')
                            
      AND
                            value IN ( 'bring-em-
      on')
                        
      ORDER
                            BY ordering ASC ,optionid ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_fieldoptions	ref	fieldid,field_value	field_value	767	const	1	1.44	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    18	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1115
    17	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    16	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.26 ms After last query: 0.14 ms Query memory: 0.055 MB Memory before query: 5.695 MB Rows returned: 9

    SELECT Listing.id AS `Listing.listing_id`,
    Listing.alias AS `Listing.slug`,
    Listing.title AS `Listing.title`,
    Listing.introtext AS `Listing.summary`,
    Listing.fulltext AS `Listing.description`,
    Listing.images AS `Listing.images`,
    Listing.hits AS `Listing.hits`,
    Listing.catid AS `Listing.cat_id`,
    Listing.created_by AS `Listing.user_id`,
    Listing.created_by_alias AS `Listing.author_alias`,
    Listing.created AS `Listing.created`,
    Listing.modified AS `Listing.modified`,
    Listing.access AS `Listing.access`,
    Listing.state AS `Listing.state`,
    Listing.publish_up AS `Listing.publish_up`,
    Listing.publish_down AS `Listing.publish_down`,
    Listing.metakey AS `Listing.metakey`,
    Listing.metadesc AS `Listing.metadesc`,
    'com_content' AS `Listing.extension`,
    Field.featured AS `Listing.featured`,
    JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
    Category.id AS `Category.cat_id`,
    Category.title AS `Category.title`,
    Category.alias AS `Category.slug`,
    Category.params AS `Category.params`,
    Directory.id AS `Directory.dir_id`,
    Directory.desc AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    User.id AS `User.user_id`,
    User.name AS `User.name`,
    User.username AS `User.username`,
    User.email AS `User.email`,
    User.block AS `User.block`,
    Claim.approved AS `Claim.approved`,
    Totals.user_rating AS `Review.user_rating`,
    Totals.user_rating_count AS `Review.user_rating_count`,
    Totals.user_criteria_rating AS `Review.user_criteria_rating`,
    Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
    Totals.user_comment_count AS `Review.user_review_count`,
    Totals.editor_rating AS `Review.editor_rating`,
    Totals.editor_rating_count AS `Review.editor_rating_count`,
    Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
    Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
    Totals.editor_comment_count AS `Review.editor_review_count`,
    Totals.media_count AS `Listing.media_count`,
    Totals.video_count AS `Listing.video_count`,
    Totals.photo_count AS `Listing.photo_count`,
    Totals.audio_count AS `Listing.audio_count`,
    Totals.attachment_count AS `Listing.attachment_count`,
    (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`,
    (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`,
    (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`,
    (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`,
    (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`,
    Totals.media_count_user AS `Listing.media_count_user`,
    Totals.video_count_user AS `Listing.video_count_user`,
    Totals.photo_count_user AS `Listing.photo_count_user`,
    Totals.audio_count_user AS `Listing.audio_count_user`,
    Totals.attachment_count_user AS `Listing.attachment_count_user`
     
      FROM i8xqe_content AS Listing
    
      LEFT JOIN i8xqe_jreviews_listing_totals AS Totals 
      ON Totals.listing_id = Listing.id 
      AND Totals.extension = 'com_content'
    
      LEFT JOIN i8xqe_jreviews_content AS Field 
      ON Field.contentid = Listing.id
    
      LEFT JOIN i8xqe_jreviews_categories AS JreviewsCategory 
      ON JreviewsCategory.id = Listing.catid 
      AND JreviewsCategory.`option` = 'com_content'
    
      LEFT JOIN i8xqe_categories AS Category 
      ON Category.id = Listing.catid 
      AND Category.extension = 'com_content'
    
      LEFT JOIN i8xqe_jreviews_directories AS Directory 
      ON Directory.id = JreviewsCategory.dirid
    
      LEFT JOIN i8xqe_users AS User 
      ON User.id = Listing.created_by
    
      LEFT JOIN i8xqe_jreviews_claims AS Claim 
      ON Claim.listing_id = Listing.id 
      AND Claim.user_id = Listing.created_by 
      AND Claim.approved = 1
     
      WHERE 1 = 1 
      AND ( 
       Listing.id IN (303,190,391,321,420,434,383,250,388)
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	range	PRIMARY	PRIMARY	4	NULL	9	100.00	Using where
    1	SIMPLE	Totals	eq_ref	PRIMARY	PRIMARY	156	stage_un1_stage.Listing.id,const	1	100.00	Using where
    1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Listing.id	1	100.00	Using where
    1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	stage_un1_stage.Listing.catid,const	1	100.00	Using where
    1	SIMPLE	Category	eq_ref	PRIMARY,cat_idx	PRIMARY	4	stage_un1_stage.Listing.catid	1	13.33	Using where
    1	SIMPLE	Directory	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.JreviewsCategory.dirid	1	100.00	Using where
    1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Listing.created_by	1	100.00	Using where
    1	SIMPLE	Claim	ref	listing_id,user_id,approved	listing_id	4	stage_un1_stage.Listing.id	1	100.00	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    23	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    22	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    21	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    20	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:1640
    19	EverywhereComContentModel->getListingById()	JROOT/components/com_jreviews/jreviews/models/field.php:2924
    18	FieldModel->getRelatedListings()	JROOT/components/com_jreviews/jreviews/models/field.php:1260
    17	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    16	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 0.18 ms After last query: 0.47 ms Query memory: 0.033 MB Memory before query: 5.873 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `i8xqe_categories` AS `s`
    
      INNER JOIN `i8xqe_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 90
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	9	95.56	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    34	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    33	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    32	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
    31	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    30	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
    29	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2515
    28	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1036
    27	JReviewsRouter->buildRule()	Same as call in the line below.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    20	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1164
    19	cmsFramework::route()	JROOT/components/com_jreviews/jreviews/models/field.php:2934
    18	FieldModel->getRelatedListings()	JROOT/components/com_jreviews/jreviews/models/field.php:1260
    17	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    16	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 0.10 ms After last query: 0.59 ms Query memory: 0.025 MB Memory before query: 6.066 MB Rows returned: 0

    SELECT
                    content_id AS listing_id, count(*) AS favored 
      FROM i8xqe_jreviews_favorites AS Favorite
    		    
      WHERE
                    Favorite.content_id IN (435,447,440,439,438,446,441,359,358,360,361,362,363,364,365,366,367,368,369,370,371,354)
    		    
      GROUP BY
                    listing_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Favorite	index	user_favorite	user_favorite	8	NULL	1	100.00	Using where; Using index; Using temporary; Using filesort

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Creating tmp table	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.00 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    18	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/favorite.php:91
    16	FavoriteModel->addFavorite()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:690
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 0.54 ms After last query: 0.11 ms Query memory: 0.081 MB Memory before query: 6.127 MB Rows returned: 46

    SELECT
    						tmp.media_id,
    						tmp.listing_id,
    						tmp.review_id,
    						tmp.media_type,
    						tmp.media_function,
    						tmp.likes_rank,
    						tmp.main_media,
    						media.likes_up,
    						media.likes_total,
    						media.created,
    						media.listing_id,
    						media.review_id,
    						media.user_id,
    						media.filename,
    						media.file_extension,
    						media.rel_path,
    						media.title,
    						media.description,
    						media.duration,
    						media.media_info,
    						media.metadata,
    						media.embed,
    						media.published,
    						media.approved,
    						media.access,
    						media.views,
    						media.filesize,
    						media.extension
    					
      FROM (
    						SELECT
    						    media_id,
    						    listing_id,
    						    review_id,
    							media_type,
    							media_function,
    							main_media,
    							views,
    							likes_rank,
    							created,
    							ordering,
    						    
      CASE
    						      WHEN @id != listing_id 
      AND media_type = 'photo'  THEN @photo := 1
    						      ELSE IF(media_type = 'photo' ,@photo := @photo + 1,NULL)
    						    END AS photo_rank,
    						    
      CASE
    						      WHEN @id != listing_id 
      AND media_type = 'video'  THEN @video := 1
    						      ELSE IF(media_type = 'video' ,@video := @video + 1,NULL)
    						    END AS video_rank,
    						    
      CASE
    						      WHEN @id != listing_id 
      AND media_type = 'attachment' THEN @attachment := 1
    						      ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL)
    						    END AS attachment_rank,
    						    
      CASE
    						      WHEN @id != listing_id 
      AND media_type = 'audio' THEN @audio := 1
    						      ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL)
    						    END AS audio_rank,
    						    @id := listing_id
    						
      FROM (
    							SELECT
    								media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views
    							
      FROM
    								i8xqe_jreviews_media
    							
      WHERE
    
    								listing_id IN (435,447,440,439,438,446,441,359,358,360,361,362,363,364,365,366,367,368,369,370,371,354)
    
    								
      AND published = 1 
      AND approved = 1
    
    								
      AND access IN (1,5)
    
    								
      AND extension = 'com_content'
    
    
    						) mtmp
      						JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r
    						
      ORDER BY
    							main_media DESC, listing_id, media_type, created DESC
    					) tmp
    
    					JOIN
    						i8xqe_jreviews_media AS media 
      ON media.media_id = tmp.media_id
    
    					
      WHERE
    						(tmp.photo_rank BETWEEN 1 
      AND 6) OR
    						(tmp.video_rank BETWEEN 1 
      AND 6) OR
    						(tmp.attachment_rank > 0) OR
    						(tmp.audio_rank > 0)
    
    					
      ORDER BY
    						tmp.main_media DESC, tmp.listing_id, tmp.media_type, tmp.created DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	46	100.00	Using where; Using filesort
    1	PRIMARY	media	eq_ref	PRIMARY	PRIMARY	4	tmp.media_id	1	100.00
    2	DERIVED	<derived4>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00
    2	DERIVED	i8xqe_jreviews_media	ALL	listing	NO INDEX KEY COULD BE USED	NULL	NULL	304	15.13	Using where; Using filesort
    4	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	No tables used

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.06 ms
    Optimizing	0.01 ms
    Optimizing	0.01 ms
    Optimizing	0.00 ms
    Executing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.19 ms
    Creating sort index	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    19	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    18	S2Model->query()	JROOT/templates/jreviews_overrides/models/media.php:1538
    17	MediaModel->addMediaDetail()	JROOT/templates/jreviews_overrides/models/media.php:1155
    16	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:714
    15	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    14	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    13	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:175
    12	ListingsRepositoryComponent->many()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:416
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 0.17 ms After last query: 0.75 ms Query memory: 0.023 MB Memory before query: 6.326 MB Rows returned: 1

    SELECT COUNT(*)
     
      FROM i8xqe_content AS Listing
    
      LEFT JOIN i8xqe_jreviews_content AS Field 
      ON Field.contentid = Listing.id
     
      WHERE 1 = 1 
      AND ( 
        (Field.jr_productiontype = '*bring-em-
      on*')
       
      AND Listing.catid IN (93)
       
      AND Listing.state = 1
       
      AND Listing.access IN ( 1,5)
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2026-10-01 21:00:00" )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2026-09-30 21:00:00" )
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	range	PRIMARY,idx_access,idx_state,idx_catid,jr_listing_count	jr_listing_count	14	NULL	44	98.31	Using where; Using index
    1	SIMPLE	Field	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Listing.id	1	100.00	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    14	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:291
    13	S2ModelCore->findCount()	JROOT/components/com_jreviews/jreviews/repositories/base_repository.php:297
    12	BaseRepository->count()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:443
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 0.08 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 6.334 MB Rows returned: 1

    SELECT Directory.id AS `Directory.dir_id`,
    Directory.desc AS `Directory.title`,
    Directory.title AS `Directory.name`,
    Directory.title AS `Directory.slug`,
    Directory.tmpl_suffix AS `Directory.tmpl_suffix`
     
      FROM i8xqe_jreviews_directories AS Directory
     
      WHERE 1 = 1 
      AND ( 
       Directory.id = 2
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Directory	const	PRIMARY	PRIMARY	4	const	1	100.00

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    15	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    14	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    13	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    12	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:469
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

32. Query Time: 0.38 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 6.465 MB Rows returned: 5

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM i8xqe_modules AS m
    
      LEFT JOIN i8xqe_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN i8xqe_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-01 09:08:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-01 09:08:55') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 2918 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	170	54.71	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	stage_un1_stage.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	stage_un1_stage.m.id	2	100.00	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.26 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    24	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    23	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    22	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    21	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    20	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:44
    19	JreviewsHelper->loadModulePosition()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_header.thtml:60
    18	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_header.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    17	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:333
    16	MyView->renderControllerView()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_tableview_productions.thtml:45
    15	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_tableview_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    14	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    13	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    12	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:696
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

33. Query Time: 0.07 ms After last query: 0.04 ms Query memory: 0.029 MB Memory before query: 6.479 MB Rows returned: 2

    SELECT
                    id
                
      FROM
                    i8xqe_jreviews_categories
                
      WHERE
                    `option` = 'com_content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_categories	ref	option	option	152	const	2	100.00	Using where; Using index

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:139
    24	JReviewsPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    23	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    22	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:369
    21	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    20	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:44
    19	JreviewsHelper->loadModulePosition()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_header.thtml:60
    18	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_header.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    17	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:333
    16	MyView->renderControllerView()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_tableview_productions.thtml:45
    15	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_tableview_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    14	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    13	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    12	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:696
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

34. Query Time: 0.19 ms After last query: 0.19 ms Query memory: 0.033 MB Memory before query: 6.494 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `i8xqe_categories` AS `s`
    
      INNER JOIN `i8xqe_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 93
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	9	100.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    34	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    33	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    32	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
    31	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    30	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
    29	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2515
    28	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1036
    27	JReviewsRouter->buildRule()	Same as call in the line below.
    26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    20	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1164
    19	cmsFramework::route()	JROOT/components/com_s2framework/s2framework/libs/view/helpers/html.php:151
    18	HtmlHelper->sefLink()	JROOT/components/com_s2framework/s2framework/libs/view/helpers/html.php:137
    17	HtmlHelper->link()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:571
    16	RoutesHelper->content()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_tableview_productions.thtml:86
    15	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/listings_tableview_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    14	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    13	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    12	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:696
    11	CategoriesController->listings()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:1158
    10	CategoriesController->search()	JROOT/components/com_jreviews/jreviews/controllers/categories_controller.php:838
    9	CategoriesController->custom()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---