Despite Everything – Trails

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1790848082,
                "last": 1790848082,
                "now": 1790848082
            },
            "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
        }
    },
    "__jreviews": {
        "user": null,
        "gid": null
    }
}

Time

Memory

64 Queries Logged 7.72 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` = '6beef4b3efc27200e983fc72898b94f8'

   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.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.00 ms
   Optimizing	0.00 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.09 ms Query memory: 0.020 MB Memory before query: 1.028 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `i8xqe_session`
   
     WHERE `session_id` = '6beef4b3efc27200e983fc72898b94f8' 
     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.07 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 
   ('6beef4b3efc27200e983fc72898b94f8', 1, 1790848082, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `i8xqe_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6beef4b3efc27200e983fc72898b94f8', 1, 1790848082, 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.00 ms
   Update	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 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.14 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.00 ms
   Optimizing	0.01 ms
   Statistics	0.01 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
   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.06 ms After last query: 0.13 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.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
   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.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.00 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.18 ms After last query: 0.04 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.10 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.21 ms After last query: 1.65 ms Query memory: 0.101 MB Memory before query: 1.630 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.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.01 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
   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.13 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.00 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.05 ms Query memory: 0.024 MB Memory before query: 1.900 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.09 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 1.892 MB

    UPDATE `i8xqe_extensions`
    
      SET `params` = '{\"mediaversion\":\"f262b8e42db7c5c53017b185a4ffbd9f\"}'
    
      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.02 ms
    End of update loop	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 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.09 ms After last query: 0.58 ms Query memory: 0.022 MB Memory before query: 1.997 MB Rows returned: 1

    SELECT
                            id
                        
      FROM
                            i8xqe_content
                        
      WHERE
                            catid = 93 
      AND alias = 'despite-everything-trails'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_content	ref	idx_catid,idx_alias,jr_listing_count	idx_alias	766	const	1	14.92	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.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2201
    12	JReviewsRouter->addBackID()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1413
    11	JReviewsRouter->parseRule()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
    8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
    7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.13 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 2.019 MB Rows returned: 0

    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 = 366
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.03 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.01 ms
    Preparing	0.00 ms
    Executing	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:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
    14	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    13	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/components/com_content/router.php:270
    12	contentParseRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1443
    11	JReviewsRouter->parseRule()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
    8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
    7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.06 ms After last query: 0.01 ms Query memory: 0.023 MB Memory before query: 2.026 MB Rows returned: 1

    SELECT `alias`,`catid`
    
      FROM `i8xqe_content`
    
      WHERE `id` = 366

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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:1656
    15	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
    14	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    13	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/components/com_content/router.php:270
    12	contentParseRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1443
    11	JReviewsRouter->parseRule()	Same as call in the line below.
    10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
    8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
    7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.13 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 2.032 MB Rows returned: 7

    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 `c`
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	207	NULL	9	100.00	Using index condition; 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.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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.05 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.071 MB Rows returned: 0

    SELECT `alias`,`catid`
    
      FROM `i8xqe_content`
    
      WHERE `id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    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
    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.01 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:1656
    11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.24 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 2.075 MB Rows returned: 117

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    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.15 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.02 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/joomla/database/driver/mysqli.php:502
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jreviews_articleoverrides/jreviews_articleoverrides.php:41
    8	PlgSystemJreviews_articleoverrides->onAfterRoute()	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:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.01 ms Query memory: 0.020 MB Memory before query: 2.095 MB Rows returned: 2

    SELECT id 
      from i8xqe_jreviews_categories

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_categories	index	NULL	criteriaid	4	NULL	2	100.00	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.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:1544
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jreviews_articleoverrides/jreviews_articleoverrides.php:48
    8	PlgSystemJreviews_articleoverrides->onAfterRoute()	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:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    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.11 ms After last query: 0.22 ms Query memory: 0.050 MB Memory before query: 2.175 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.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.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.]

    ---

20. Query Time: 0.15 ms After last query: 0.77 ms Query memory: 0.027 MB Memory before query: 2.448 MB Rows returned: 38

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `i8xqe_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_crisplivechat','com_fields','com_finder','com_installer','com_joomlaupdate','com_jreviews','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	374	10.43	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.02 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.06 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:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.12 ms After last query: 0.05 ms Query memory: 0.034 MB Memory before query: 2.497 MB Rows returned: 83

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `i8xqe_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	374	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.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.06 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:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.23 ms After last query: 0.13 ms Query memory: 0.031 MB Memory before query: 2.591 MB Rows returned: 31

    SHOW FULL COLUMNS 
      FROM `i8xqe_content`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `i8xqe_content`

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 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
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    checking permissions	0.04 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.03 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:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.08 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 2.641 MB Rows returned: 1

    SELECT *
    
      FROM i8xqe_content
    
      WHERE `id` = '366'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_content	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.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.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:1459
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.10 ms After last query: 0.03 ms Query memory: 0.005 MB Memory before query: 2.648 MB

    UPDATE i8xqe_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '366'

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 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.03 ms
    End of update loop	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 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/src/Table/Table.php:1245
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.18 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 2.673 MB Rows returned: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM i8xqe_content AS a
    
      INNER JOIN i8xqe_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN i8xqe_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN i8xqe_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN i8xqe_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 366 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-01 09:48:02') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-01 09:48:02') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,jr_listing_count	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	1	100.00	Unique row not found

    Profile

    Status	Duration
    Starting	0.03 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.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	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.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.15 ms After last query: 0.41 ms Query memory: 0.022 MB Memory before query: 2.776 MB Rows returned: 1

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `i8xqe_contentitem_tag_map` AS m 
    
      INNER JOIN `i8xqe_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 366 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	tag_idx	5	NULL	4	100.00	Using index condition
    1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	42	33.33	Using where; Using join buffer (flat, BNL join)

    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.02 ms
    Preparing	0.02 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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:180
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.28 ms Query memory: 0.025 MB Memory before query: 2.824 MB Rows returned: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM i8xqe_fields AS a
    
      LEFT JOIN `i8xqe_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN i8xqe_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN i8xqe_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN i8xqe_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN i8xqe_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `i8xqe_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (93,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	stage_un1_stage.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.a.checked_out	1	100.00
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	stage_un1_stage.a.id	1	100.00	Using where

    Profile

    Status	Duration
    Starting	0.03 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
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.09 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 2.876 MB Rows returned: 1

    SELECT catid 
      FROM i8xqe_content 
      WHERE id = 366

    Explain

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

    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.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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:271
    16	plgContentJreviews->articleinJReviewsCategory()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:255
    15	plgContentJreviews->checkJreviewsCategory()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:31
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.08 ms After last query: 0.01 ms Query memory: 0.024 MB Memory before query: 2.885 MB Rows returned: 1

    SELECT
                        count(*)
                    
      FROM
                        i8xqe_jreviews_categories AS Category
                    
      WHERE
                        Category.option = 'com_content'
                        
      AND
                        Category.id = 93

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Category	const	PRIMARY,option	PRIMARY	156	const,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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:287
    16	plgContentJreviews->articleinJReviewsCategory()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:255
    15	plgContentJreviews->checkJreviewsCategory()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:31
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.04 ms After last query: 1.16 ms Query memory: 0.009 MB Memory before query: 3.411 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.01 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    16	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:91
    15	require_once JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:33
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.20 ms After last query: 0.01 ms Query memory: 0.025 MB Memory before query: 3.420 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.11 ms
    Executing	0.00 ms
    Sending data	0.01 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    18	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    17	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:40
    16	JReviews\Models\ConfigurationModel::tableCreated()	JROOT/components/com_jreviews/jreviews/framework.php:93
    15	require_once JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:33
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.08 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 3.429 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.01 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    16	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:98
    15	require_once JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:33
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.13 ms After last query: 0.84 ms Query memory: 0.026 MB Memory before query: 3.877 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.03 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
    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
    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/framework.php:174
    15	require_once JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:33
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.12 ms After last query: 6.78 ms Query memory: 0.012 MB Memory before query: 5.873 MB

    INSERT INTO i8xqe_jreviews_config ( id, value ) 
      VALUES ('ranks_rebuild_last','1790848082') 
      ON DUPLICATE KEY UPDATE value = 
      VALUES(value)

    Explain

    EXPLAIN not possible on query: INSERT INTO i8xqe_jreviews_config ( id, value ) VALUES ('ranks_rebuild_last','1790848082') ON DUPLICATE KEY UPDATE value = VALUES(value)

    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 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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    27	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    26	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:82
    25	JReviews\Models\ConfigurationModel->store()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:763
    24	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:58
    23	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:107
    22	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

35. Query Time: 0.15 ms After last query: 0.18 ms Query memory: 0.068 MB Memory before query: 5.884 MB Rows returned: 430
    Duplicate queries: #40

    SELECT
                        *
                    
      FROM
                        i8xqe_jreviews_config AS `Config`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	430	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.08 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
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    30	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    29	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:54
    28	JReviews\Models\ConfigurationModel->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:687
    27	JReviews\Services\Configuration->getSettings()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:559
    26	JReviews\Services\Configuration->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:803
    25	JReviews\Services\Configuration->clearCacheConfig()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:765
    24	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:58
    23	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:107
    22	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

36. Query Time: 0.17 ms After last query: 0.59 ms Query memory: 0.011 MB Memory before query: 5.902 MB

    DELETE
                
      FROM
                    i8xqe_jreviews_reviewer_ranks
                
      WHERE
                    user_id = 0
                    OR user_id NOT IN (
                        SELECT
                            userid
                        
      FROM
                            i8xqe_jreviews_comments
                        
      WHERE
                            published = 1
                    )
                    OR user_id NOT IN (
                        SELECT id 
      FROM i8xqe_users 
      WHERE block = 0
                    )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	i8xqe_jreviews_reviewer_ranks	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    3	DEPENDENT SUBQUERY	i8xqe_users	eq_ref	PRIMARY,idx_block	idx_block	5	const,func	1	100.00	Using index
    2	DEPENDENT SUBQUERY	i8xqe_jreviews_comments	index_subquery	listing,created,modified,userid,published,votes_helpful,votes,posts,media_count,video_count,photo_count,audio_count,attachment_count,published_user_author	userid	5	func,const	1	100.00	Using index; 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
    init for update	0.00 ms
    init	0.02 ms
    Deleting from 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
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.02 ms
    Preparing	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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    25	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1183
    23	ReviewModel->rebuildRanksTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:113
    22	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

37. Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.011 MB Memory before query: 5.916 MB

    INSERT INTO
                    i8xqe_jreviews_reviewer_ranks (user_id, reviews, votes_percent_helpful, votes_total)
                    (
                        SELECT
                            userid AS user_id,
                            COUNT(*) AS reviews,
                            (IF(SUM(vote_total)>0,SUM(vote_helpful)/SUM(vote_total),0)) AS votes_percent_helpful,
                            SUM(vote_total) AS votes_total
                        
      FROM
                            i8xqe_jreviews_comments AS Review
                        RIGHT JOIN
                            i8xqe_users AS User 
      ON User.id = Review.userid 
      AND User.block = 0
                        
      WHERE
                            userid > 0
                            
      AND published = 1
                            
                        
      GROUP BY
                            userid
                        
      ORDER BY
                            NULL
                    )
                
      ON DUPLICATE KEY UPDATE
                    reviews = 
      VALUES(reviews),
                    votes_percent_helpful = 
      VALUES(votes_percent_helpful),
                    votes_total = 
      VALUES(votes_total);

    Explain

    EXPLAIN not possible on query: INSERT INTO i8xqe_jreviews_reviewer_ranks (user_id, reviews, votes_percent_helpful, votes_total) ( SELECT userid AS user_id, COUNT(*) AS reviews, (IF(SUM(vote_total)>0,SUM(vote_helpful)/SUM(vote_total),0)) AS votes_percent_helpful, SUM(vote_total) AS votes_total FROM i8xqe_jreviews_comments AS Review RIGHT JOIN i8xqe_users AS User ON User.id = Review.userid AND User.block = 0 WHERE userid > 0 AND published = 1 GROUP BY userid ORDER BY NULL ) ON DUPLICATE KEY UPDATE reviews = VALUES(reviews), votes_percent_helpful = VALUES(votes_percent_helpful), votes_total = VALUES(votes_total);

    Profile

    Status	Duration
    Starting	0.03 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.02 ms
    Preparing	0.01 ms
    Sorting result	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/database.php:33
    25	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1233
    23	ReviewModel->rebuildRanksTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:113
    22	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

38. Query Time: 0.14 ms After last query: 0.02 ms Query memory: 0.011 MB Memory before query: 5.928 MB

    INSERT INTO
                    i8xqe_jreviews_reviewer_ranks (user_id, rank)
                    (
                        SELECT
                            user_id,
                            @curRank := @curRank + 1 AS rank
                        
      FROM
                            i8xqe_jreviews_reviewer_ranks, (SELECT @curRank := 0) r
                        
      ORDER BY
                            reviews DESC, votes_percent_helpful DESC
                    )
                
      ON DUPLICATE KEY UPDATE
                        rank = 
      VALUES(rank);

    Explain

    EXPLAIN not possible on query: INSERT INTO i8xqe_jreviews_reviewer_ranks (user_id, rank) ( SELECT user_id, @curRank := @curRank + 1 AS rank FROM i8xqe_jreviews_reviewer_ranks, (SELECT @curRank := 0) r ORDER BY reviews DESC, votes_percent_helpful DESC ) ON DUPLICATE KEY UPDATE rank = VALUES(rank);

    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.02 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Optimizing	0.00 ms
    Executing	0.01 ms
    Statistics	0.00 ms
    Preparing	0.00 ms
    Creating tmp table	0.01 ms
    Sorting result	0.00 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Removing tmp table	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
    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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    25	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:1235
    23	ReviewModel->rebuildRanksTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:113
    22	CronFunctionsComponent->rebuildRankTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:46
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

39. Query Time: 0.07 ms After last query: 0.02 ms Query memory: 0.012 MB Memory before query: 5.939 MB

    INSERT INTO i8xqe_jreviews_config ( id, value ) 
      VALUES ('media_likes_rebuild_last','1790848082') 
      ON DUPLICATE KEY UPDATE value = 
      VALUES(value)

    Explain

    EXPLAIN not possible on query: INSERT INTO i8xqe_jreviews_config ( id, value ) VALUES ('media_likes_rebuild_last','1790848082') ON DUPLICATE KEY UPDATE value = VALUES(value)

    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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    27	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    26	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:82
    25	JReviews\Models\ConfigurationModel->store()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:763
    24	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:58
    23	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:119
    22	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

40. Query Time: 0.14 ms After last query: 0.10 ms Query memory: 0.068 MB Memory before query: 5.950 MB Rows returned: 430
    Duplicate queries: #35

    SELECT
                        *
                    
      FROM
                        i8xqe_jreviews_config AS `Config`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	430	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.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
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    30	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    29	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/configuration.php:54
    28	JReviews\Models\ConfigurationModel->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:687
    27	JReviews\Services\Configuration->getSettings()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:559
    26	JReviews\Services\Configuration->load()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:803
    25	JReviews\Services\Configuration->clearCacheConfig()	JROOT/components/com_jreviews/jreviews/services/configuration/configuration.php:765
    24	JReviews\Services\Configuration->store()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:58
    23	CronFunctionsComponent->run()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:119
    22	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

41. Query Time: 0.17 ms After last query: 0.31 ms Query memory: 0.011 MB Memory before query: 5.982 MB

    INSERT INTO
    				i8xqe_jreviews_media (media_id, likes_up, likes_total)
    				(SELECT
    					media_id AS media_id,
    					SUM(IF(vote = 1, 1, 0)) AS likes_up,
    					COUNT(*) AS likes_total
    				
      FROM i8xqe_jreviews_media_likes
    				
    				
      GROUP BY media_id
    				
      ORDER BY NULL
    				)
    			
      ON DUPLICATE KEY UPDATE
    				likes_up = 
      VALUES(likes_up),
    				likes_total = 
      VALUES(likes_total);

    Explain

    EXPLAIN not possible on query: INSERT INTO i8xqe_jreviews_media (media_id, likes_up, likes_total) (SELECT media_id AS media_id, SUM(IF(vote = 1, 1, 0)) AS likes_up, COUNT(*) AS likes_total FROM i8xqe_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_up = VALUES(likes_up), likes_total = VALUES(likes_total);

    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.00 ms
    Statistics	0.00 ms
    Preparing	0.00 ms
    Creating tmp table	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    Removing tmp table	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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    25	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:177
    23	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:125
    22	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

42. Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.027 MB Memory before query: 5.994 MB Rows returned: 1

    SELECT @max_likes := MAX(likes_total) 
      FROM i8xqe_jreviews_media;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_media	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	304	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.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.06 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/database.php:33
    25	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:181
    23	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:125
    22	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

43. Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.011 MB Memory before query: 6.005 MB

    INSERT INTO
    					i8xqe_jreviews_media (media_id, likes_rank)
    					(SELECT
    						media_id AS media_id,
    						(SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank
    					
      FROM
    						i8xqe_jreviews_media_likes
    					
      GROUP BY
    						media_id
    					
      ORDER BY
    						NULL
    					)
    				
      ON DUPLICATE KEY UPDATE
    						likes_rank = 
      VALUES(likes_rank);

    Explain

    EXPLAIN not possible on query: INSERT INTO i8xqe_jreviews_media (media_id, likes_rank) (SELECT media_id AS media_id, (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank FROM i8xqe_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_rank = VALUES(likes_rank);

    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.00 ms
    Preparing	0.00 ms
    Creating tmp table	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Removing tmp table	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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    25	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/media_like.php:183
    23	MediaLikeModel->updateCount()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:125
    22	CronFunctionsComponent->rebuildMediaLikesTable()	JROOT/components/com_jreviews/jreviews/plugins/cron_functions.php:49
    21	CronFunctionsComponent->startup()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:138
    20	S2Controller->__initComponents()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:562
    19	MyController->_initPlugins()	JROOT/components/com_jreviews/jreviews/controllers/my_controller.php:231
    18	MyController->beforeFilter()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:43
    17	ComContentController->beforeFilter()	JROOT/components/com_s2framework/s2framework/dispatcher.php:329
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

44. Query Time: 0.08 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 6.034 MB Rows returned: 1

    SELECT
                    count(*)
                
      FROM
                    i8xqe_jreviews_categories AS JreviewCategory
                
      WHERE
                    JreviewCategory.id = 93
                    
      AND
                    JreviewCategory.option = 'com_content'
                    
      AND
                    JreviewCategory.criteriaid > 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	JreviewCategory	const	PRIMARY,criteriaid,option	PRIMARY	156	const,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:1734
    20	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:64
    18	CategoryModel->isJreviewsCategory()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:130
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

45. Query Time: 0.28 ms After last query: 0.15 ms Query memory: 0.044 MB Memory before query: 6.056 MB Rows returned: 1

    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 = 366)
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	Totals	const	PRIMARY	PRIMARY	156	const,const	1	100.00
    1	SIMPLE	Field	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	JreviewsCategory	const	PRIMARY,option	PRIMARY	156	const,const	1	100.00
    1	SIMPLE	Category	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00
    1	SIMPLE	Directory	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	User	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	Claim	ref	listing_id,user_id,approved	listing_id	4	const	1	100.00	Using where

    Profile

    Status	Duration
    Starting	0.05 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.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 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.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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    22	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    21	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

46. Query Time: 0.06 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 6.085 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.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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    26	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    25	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:632
    24	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:898
    23	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    22	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

47. Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.029 MB Memory before query: 6.100 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.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.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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:929
    23	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    22	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

48. Query Time: 0.06 ms After last query: 0.02 ms Query memory: 0.027 MB Memory before query: 6.123 MB Rows returned: 1

    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 (366)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	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.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/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1014
    23	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    22	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

49. Query Time: 0.09 ms After last query: 0.01 ms Query memory: 0.027 MB Memory before query: 6.138 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.00 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.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/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    24	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:1115
    23	FieldModel->getFieldsArray()	JROOT/components/com_jreviews/jreviews/models/field.php:810
    22	FieldModel->addFields()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:675
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

50. Query Time: 0.06 ms After last query: 0.04 ms Query memory: 0.027 MB Memory before query: 6.146 MB Rows returned: 0

    SELECT
                    content_id AS listing_id, count(*) AS favored 
      FROM i8xqe_jreviews_favorites AS Favorite
    		    
      WHERE
                    Favorite.content_id IN (366)
    		    
      GROUP BY
                    listing_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Favorite	ref	user_favorite	user_favorite	4	const	1	100.00	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.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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    24	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    23	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/favorite.php:91
    22	FavoriteModel->addFavorite()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:690
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

51. Query Time: 0.30 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 6.174 MB Rows returned: 2

    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 (366)
    
    								
      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  >= 0) OR
    						(tmp.video_rank  >= 0) 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	2	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	ref	listing	listing	306	const,const	2	100.00	Using index condition; 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.04 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.02 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.03 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
    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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    25	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    24	S2Model->query()	JROOT/templates/jreviews_overrides/models/media.php:1538
    23	MediaModel->addMediaDetail()	JROOT/templates/jreviews_overrides/models/media.php:1155
    22	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:714
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

52. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 6.193 MB Rows returned: 0

    SELECT
                    rating_range, count(*) AS count
                
      FROM
                    (SELECT
                        
      CASE WHEN ROUND(rating,1) > 0 
      AND rating < 1.5 THEN 1
                             WHEN ROUND(rating,1) >= 1.5 
      AND ROUND(rating,1) < 2.5 THEN 2
                             WHEN ROUND(rating,1) >= 2.5 
      AND ROUND(rating,1) < 3.5 THEN 3
                             WHEN ROUND(rating,1) >= 3.5 
      AND ROUND(rating,1) < 4.5 THEN 4
                             WHEN ROUND(rating,1) >= 4.5 THEN 5
                        END as rating_range
                    
      FROM
                        i8xqe_jreviews_comments
                    
      WHERE
                    pid = 366
                     
      AND published = 1
                     
      AND mode = 'com_content'
                     
      AND rating > 0
                     
      AND author = 0
                    ) AS  ReviewRange
                
      GROUP BY
                    rating_range

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_comments	ref	listing_id,extension,listing,published,published_user_author	listing_id	4	const	1	100.00	Using where; Using temporary; Using filesort

    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.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 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
    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.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    24	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:64
    23	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/review.php:299
    22	ReviewModel->getReviewRatingCounts()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:755
    21	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    20	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:170
    19	S2ModelCore->findRow()	JROOT/components/com_jreviews/jreviews/repositories/listings_repository.php:158
    18	ListingsRepositoryComponent->one()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:166
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

53. Query Time: 0.06 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 6.194 MB Rows returned: 1

    SELECT
                    path
                
      FROM
                    i8xqe_categories
                
      WHERE
                    id IN (93)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_categories	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.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/cms_compat/joomla/models/category.php:708
    18	CategoryModel->findParents()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:287
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

54. Query Time: 0.28 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 6.208 MB Rows returned: 1

    SELECT
                    ParentCategory.id AS `Category.cat_id`,
                    ParentCategory.lft AS `Category.lft`,
                    ParentCategory.title AS `Category.title`,
                    IF(JreviewsCategory.page_title <> '',JreviewsCategory.page_title,ParentCategory.title) AS `Category.title_seo`,
                    JreviewsCategory.title_override AS `Category.title_override`,
                    ParentCategory.alias AS `Category.slug`,
                    ParentCategory.level AS `Category.level`,
                    ParentCategory.published AS `Category.published`,
                    ParentCategory.access AS `Category.access`,
                    ParentCategory.params AS `Category.params`,
                    ParentCategory.parent_id AS `Category.parent_id`,
                    ParentCategory.metadesc AS `Category.metadesc`,
                    ParentCategory.metakey AS `Category.metakey`,
                    IF(ParentCategory.metadesc <> '' 
      AND JreviewsCategory.desc_override =1,ParentCategory.metadesc,ParentCategory.description) AS `Category.description`,
                    JreviewsCategory.criteriaid AS `ListingType.listing_type_id`,
                    JreviewsCategory.tmpl AS `Category.tmpl`,
                    JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
                    JreviewsCategory.dirid AS `Directory.dir_id`,
                    Directory.title AS `Directory.slug`
                
      FROM
                    i8xqe_categories AS ParentCategory
                
      INNER JOIN
                    i8xqe_jreviews_categories AS JreviewsCategory 
      ON JreviewsCategory.id = ParentCategory.id 
      AND JreviewsCategory.`option` = 'com_content'
                
      LEFT JOIN
                    i8xqe_jreviews_directories AS Directory 
      ON JreviewsCategory.dirid = Directory.id
                
      WHERE
                    ParentCategory.path IN ( 'productions')
                
      ORDER BY
                    ParentCategory.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ParentCategory	ref	PRIMARY,idx_path	idx_path	402	const	1	100.00	Using where; Using filesort
    1	SIMPLE	JreviewsCategory	eq_ref	PRIMARY,option	PRIMARY	156	stage_un1_stage.ParentCategory.id,const	1	100.00	Using where
    1	SIMPLE	Directory	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.JreviewsCategory.dirid	1	100.00

    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.17 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
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    19	S2Model->query()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/category.php:768
    18	CategoryModel->findParents()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:287
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

55. Query Time: 0.22 ms After last query: 0.51 ms Query memory: 0.027 MB Memory before query: 6.240 MB Rows returned: 0

    SELECT Review.id AS `Review.review_id`,
    Review.pid AS `Review.listing_id`,
    Review.mode AS `Review.extension`,
    Review.created AS `Review.created`,
    Review.modified AS `Review.modified`,
    Review.userid AS `Review.user_id`,
    User.id AS `User.user_id`,
    
      CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`,
    
      CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`,
    User.block AS `User.block`,
    Review.email AS `User.email`,
    Review.ipaddress AS `User.ipaddress`,
    Rank.rank AS `User.review_rank`,
    Rank.reviews AS `User.review_count`,
    Review.title AS `Review.title`,
    Review.comments AS `Review.comments`,
    Review.posts AS `Review.posts`,
    Review.author AS `Review.editor`,
    Review.published AS `Review.published`,
    IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`,
    Review.vote_helpful AS `Vote.yes`,
    (Review.vote_total - Review.vote_helpful) AS `Vote.no`,
    (Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`,
    Review.owner_reply_text AS `Review.owner_reply_text`,
    Review.owner_reply_approved AS `Review.owner_reply_approved`,
    Review.owner_reply_created AS `Review.owner_reply_created`,
    Review.media_count AS `Review.media_count`,
    Review.video_count AS `Review.video_count`,
    Review.photo_count AS `Review.photo_count`,
    Review.audio_count AS `Review.audio_count`,
    Review.attachment_count AS `Review.attachment_count`,
    Review.listing_type_id AS `ListingType.listing_type_id`,
    Review.owner_reply_approved As `Review.owner_reply_approved`,
    Review.owner_reply_text As `Review.owner_reply_text`
     
      FROM i8xqe_jreviews_comments AS Review
    
      LEFT JOIN i8xqe_users AS User 
      ON Review.userid = User.id
    
      LEFT JOIN i8xqe_jreviews_reviewer_ranks AS Rank 
      ON Review.userid = Rank.user_id
    
      LEFT JOIN i8xqe_content AS Listing 
      ON Listing.id = Review.pid
    
      LEFT JOIN i8xqe_jreviews_listing_totals AS Totals 
      ON Totals.listing_id = Review.pid 
      AND Totals.extension = 'com_content'
    
      LEFT JOIN i8xqe_jreviews_categories AS JreviewsCategory 
      ON JreviewsCategory.id = Listing.catid 
      AND JreviewsCategory.`option` = 'com_content'
     
      WHERE 1 = 1 
      AND ( 
       Review.pid = 366
       
      AND Review.mode = 'com_content'
       
      AND Review.published = 1
       
      AND Review.author = 0
       
      AND JreviewsCategory.option = 'com_content'
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Listing	const	PRIMARY,idx_catid,jr_listing_count	PRIMARY	4	const	1	100.00
    1	SIMPLE	JreviewsCategory	const	PRIMARY,option	PRIMARY	156	const,const	1	100.00
    1	SIMPLE	Review	range	listing_id,extension,listing,published,published_user_author	listing	158	NULL	1	100.00	Using where
    1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Review.userid	1	100.00
    1	SIMPLE	Rank	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Review.userid	1	100.00

    Profile

    Status	Duration
    Starting	0.04 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 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
    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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    21	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    20	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    19	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    18	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:371
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

56. Query Time: 0.06 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 6.243 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    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
    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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    21	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    20	S2Model->query()	JROOT/components/com_jreviews/jreviews/models/field.php:632
    19	FieldModel->getFieldGroupIdsByListingTypeIds()	JROOT/components/com_jreviews/jreviews/models/field.php:1475
    18	FieldModel->getFieldsArrayNew()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:383
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

57. Query Time: 0.07 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 6.260 MB Rows returned: 1

    SELECT COUNT(*)
     
      FROM i8xqe_jreviews_comments AS Review
     
      WHERE 1 = 1 
      AND ( 
       Review.pid = 366
       
      AND Review.mode = 'com_content'
       
      AND Review.published >= 0
       
      AND Review.ipaddress = '216.73.217.103'
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Review	ref	listing_id,extension,listing,published,published_user_author	listing_id	4	const	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.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    21	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:291
    20	S2ModelCore->findCount()	JROOT/components/com_jreviews/jreviews/repositories/reviews_repository.php:957
    19	ReviewsRepositoryComponent->getReviewCount()	JROOT/components/com_jreviews/jreviews/repositories/reviews_repository.php:920
    18	ReviewsRepositoryComponent->addUsersReviewCountsToListing()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:393
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

58. Query Time: 0.06 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 6.272 MB Rows returned: 1

    SELECT COUNT(*)
     
      FROM i8xqe_jreviews_comments AS Review
     
      WHERE 1 = 1 
      AND ( 
       Review.pid = 366
       
      AND Review.mode = 'com_content'
       
      AND Review.published >= 0
       
      AND Review.author = 0
       
      AND Review.userid = 0
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Review	ref	listing_id,extension,listing,userid,published,published_user_author	listing_id	4	const	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.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    21	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:291
    20	S2ModelCore->findCount()	JROOT/components/com_jreviews/jreviews/repositories/reviews_repository.php:957
    19	ReviewsRepositoryComponent->getReviewCount()	JROOT/components/com_jreviews/jreviews/repositories/reviews_repository.php:922
    18	ReviewsRepositoryComponent->addUsersReviewCountsToListing()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:393
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

59. Query Time: 0.06 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 6.282 MB Rows returned: 1

    SELECT COUNT(*)
     
      FROM i8xqe_jreviews_comments AS Review
     
      WHERE 1 = 1 
      AND ( 
       Review.pid = 366
       
      AND Review.mode = 'com_content'
       
      AND Review.published >= 0
       
      AND Review.author = 1
       
      AND Review.userid = 0
     )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Review	ref	listing_id,extension,listing,userid,published,published_user_author	listing_id	4	const	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.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    21	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:291
    20	S2ModelCore->findCount()	JROOT/components/com_jreviews/jreviews/repositories/reviews_repository.php:957
    19	ReviewsRepositoryComponent->getReviewCount()	JROOT/components/com_jreviews/jreviews/repositories/reviews_repository.php:924
    18	ReviewsRepositoryComponent->addUsersReviewCountsToListing()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:393
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

60. Query Time: 0.41 ms After last query: 1.35 ms Query memory: 0.029 MB Memory before query: 6.476 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:48:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-01 09:48:02') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 2916 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.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.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    27	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    26	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    25	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    24	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    23	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:44
    22	JreviewsHelper->loadModulePosition()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml:67
    21	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    20	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    19	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    18	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:405
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

61. Query Time: 0.06 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 6.483 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.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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:139
    27	JReviewsPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    26	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    25	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:369
    24	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    23	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:44
    22	JreviewsHelper->loadModulePosition()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml:67
    21	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    20	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    19	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    18	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:405
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

62. Query Time: 0.05 ms After last query: 0.01 ms Query memory: 0.029 MB Memory before query: 6.497 MB Rows returned: 1

    SELECT
                    catid
                
      FROM
                    i8xqe_content
                
      WHERE
                    id = 366

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_content	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.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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    28	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:157
    27	JReviewsPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    26	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    25	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:369
    24	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    23	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jreviews/jreviews/views/helpers/jreviews.php:44
    22	JreviewsHelper->loadModulePosition()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml:67
    21	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    20	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    19	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    18	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:405
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

63. Query Time: 0.05 ms After last query: 0.72 ms Query memory: 0.033 MB Memory before query: 6.557 MB Rows returned: 1

    SELECT
                                    catid
                                
      FROM
                                    i8xqe_content
                                
      WHERE
                                    id = 366

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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
    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
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    36	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:985
    35	JReviewsRouter->buildRule()	Same as call in the line below.
    34	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    33	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    32	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    31	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    30	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    29	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    28	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1212
    27	cmsFramework::route()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:804
    26	RoutesHelper->listing()	JROOT/components/com_jreviews/jreviews/views/helpers/custom_fields.php:124
    25	CustomFieldsHelper->setReviewClick2SearchUrl()	JROOT/components/com_jreviews/jreviews/views/themes/default/reviews/user_reviews.thtml:49
    24	include JROOT/components/com_jreviews/jreviews/views/themes/default/reviews/user_reviews.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    23	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:333
    22	MyView->renderControllerView()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml:125
    21	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    20	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    19	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    18	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:405
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---

64. Query Time: 0.05 ms After last query: 0.04 ms Query memory: 0.034 MB Memory before query: 6.592 MB Rows returned: 1

    SELECT alias
    
      FROM i8xqe_content
    
      WHERE id=366

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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
    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
    41	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    40	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    39	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    38	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
    37	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2515
    36	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:995
    35	JReviewsRouter->buildRule()	Same as call in the line below.
    34	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    33	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    32	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    31	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    30	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    29	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    28	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1212
    27	cmsFramework::route()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/views/helpers/routes.php:804
    26	RoutesHelper->listing()	JROOT/components/com_jreviews/jreviews/views/helpers/custom_fields.php:124
    25	CustomFieldsHelper->setReviewClick2SearchUrl()	JROOT/components/com_jreviews/jreviews/views/themes/default/reviews/user_reviews.thtml:49
    24	include JROOT/components/com_jreviews/jreviews/views/themes/default/reviews/user_reviews.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    23	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:333
    22	MyView->renderControllerView()	JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml:125
    21	include JROOT/templates/jreviews_overrides/views/themes/unreal/listings/detail_productions.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    20	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    19	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    18	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/com_content_controller.php:405
    17	ComContentController->com_content_view()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    16	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:110
    15	plgContentJreviews->processDetailPage()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/includes/plugins/jreviews.php:72
    14	plgContentJreviews->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jreviews_articleoverrides/views/view.html.php:190
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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.]

    ---