Planet Of Zeus - live at "Parnassos" Literary Society: VIDEOS

{
    "__default": {
        "session": {
            "counter": 8,
            "timer": {
                "start": 1790851073,
                "last": 1790851077,
                "now": 1790851077
            },
            "client": {
                "forwarded": "216.73.217.103"
            },
            "token": "2e0CiloIqwl14EMAWO5xh9nQUVOSDCat"
        },
        "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": {
        "MediaView415": true,
        "MediaView229": true,
        "MediaView419": true,
        "MediaView411": true
    }
}

Time

Memory

23 Queries Logged 3.09 ms

1. Query Time: 0.10 ms Query memory: 0.023 MB Memory before query: 1.017 MB Rows returned: 1

   SELECT `data`
   
     FROM `i8xqe_session`
   
     WHERE `session_id` = '428f724eb0ade3b0a2e0a7a6d3bec880'

   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.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
   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.13 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 1.063 MB Rows returned: 38

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.00 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 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.]

   ---

3. Query Time: 0.06 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.090 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.]

   ---

4. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 1.102 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.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

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

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

   ---

5. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.030 MB Memory before query: 1.123 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.]

   ---

6. Query Time: 0.17 ms After last query: 1.41 ms Query memory: 0.101 MB Memory before query: 1.628 MB Rows returned: 39

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.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.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.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.]

   ---

7. Query Time: 0.07 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.806 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.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
   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.]

   ---

8. Query Time: 0.07 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 1.834 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.01 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.]

   ---

9. Query Time: 0.08 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 1.827 MB

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

10. Query Time: 0.07 ms After last query: 0.52 ms Query memory: 0.022 MB Memory before query: 1.996 MB Rows returned: 1

    SELECT
                    count(*)
                
      FROM
                    i8xqe_jreviews_categories
                
      WHERE
                    id = 93 
      AND `option` = 'com_content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i8xqe_jreviews_categories	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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2605
    12	JReviewsRouter->isJReviewsCategory()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1342
    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.]

    ---

11. Query Time: 0.10 ms After last query: 0.19 ms Query memory: 0.050 MB Memory before query: 2.061 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.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

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

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

    ---

12. Query Time: 0.03 ms After last query: 0.92 ms Query memory: 0.006 MB Memory before query: 2.817 MB

    
      SET SQL_BIG_SELECTS=1

    Explain

    EXPLAIN not possible on query: SET SQL_BIG_SELECTS=1

    Profile

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

    Call Stack

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

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

    ---

13. Query Time: 0.15 ms After last query: 0.01 ms Query memory: 0.022 MB Memory before query: 2.823 MB Rows returned: 1

    SHOW TABLES LIKE '%_jreviews_config'

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

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

    SELECT value 
      FROM i8xqe_jreviews_config 
      WHERE id = 'cms_secret'

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:98
    8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.06 ms After last query: 0.48 ms Query memory: 0.022 MB Memory before query: 3.272 MB Rows returned: 0

    SELECT name 
      FROM i8xqe_jreviews_addons 
      WHERE state = 1 
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    10	JDatabaseDriver->loadColumn()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    9	S2Model->query()	JROOT/components/com_jreviews/jreviews/framework.php:174
    8	require JROOT/components/com_jreviews/jreviews/framework.php	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:16
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.34 ms After last query: 2.57 ms Query memory: 0.022 MB Memory before query: 5.217 MB Rows returned: 1

    SELECT
    				listing_id, review_id, extension, Listing.created_by AS owner_id
    			
      FROM
    				i8xqe_jreviews_media AS Media
    			
      LEFT JOIN
    				i8xqe_content AS Listing 
      ON Listing.id = Media.listing_id
    			
      WHERE
    				media_id = 411

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Media	const	PRIMARY	PRIMARY	4	const	1	100.00
    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.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.27 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    12	JDatabaseDriver->loadAssoc()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    11	S2Model->query()	JROOT/templates/jreviews_overrides/models/media.php:1148
    10	MediaModel->getListingInfo()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:750
    9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.11 ms After last query: 0.02 ms Query memory: 0.007 MB Memory before query: 5.226 MB

    UPDATE
                        i8xqe_jreviews_media AS Media
                    
      SET
                        views = views + 1
                    
      WHERE
                        media_id = 411

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Media	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.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.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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    11	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:513
    10	S2ModelCore->views()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:771
    9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.19 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 5.240 MB Rows returned: 1

    SELECT Media.media_id AS `Media.media_id`,
    Media.media_type AS `Media.media_type`,
    IF ( Media.media_type = "video" 
      AND Media.embed != "",Media.embed,Media.media_type) AS `Media.drive`,
    Media.media_function AS `Media.media_function`,
    Media.listing_id AS `Media.listing_id`,
    Media.extension AS `Media.extension`,
    Media.review_id AS `Media.review_id`,
    Media.name AS `Media.name`,
    Media.filename AS `Media.filename`,
    Media.file_extension AS `Media.file_extension`,
    Media.rel_path AS `Media.rel_path`,
    Media.media_info AS `Media.media_info`,
    Media.metadata AS `Media.metadata`,
    Media.embed AS `Media.embed`,
    Media.title AS `Media.title`,
    Media.description AS `Media.description`,
    Media.duration AS `Media.duration`,
    Media.filesize AS `Media.filesize`,
    Media.created AS `Media.created`,
    Media.modified AS `Media.modified`,
    Media.approved AS `Media.approved`,
    Media.published AS `Media.published`,
    Media.access AS `Media.access`,
    INET_NTOA(Media.ipaddress) AS `Media.ipaddress`,
    Media.views AS `Media.views`,
    Media.main_media AS `Media.main_media`,
    Media.likes_up AS `Media.likes_up`,
    Media.likes_total AS `Media.likes_total`,
    Media.likes_rank AS `Media.likes_rank`,
    Media.ordering AS `Media.ordering`,
    Media.user_id AS `Media.user_id`,
    Media.user_id AS `User.user_id`,
    User.name AS `User.name`,
    User.username AS `User.username`,
    User.block AS `User.block`,
    IF(User.email <> "", User.email, Media.email) AS `User.email`
     
      FROM i8xqe_jreviews_media AS Media
    
      LEFT JOIN i8xqe_users AS User 
      ON Media.user_id = User.id
     
      WHERE 1 = 1 
      AND ( 
       Media.listing_id = 440
       
      AND Media.media_type = "video"
       
      AND Media.extension = 'com_content'
       
      AND Media.published = 1
       
      AND Media.approved = 1
     )
     
      ORDER BY `Media.created` DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Media	ref	count,listing	listing	306	const,const	2	1.32	Using index condition; Using where; Using filesort
    1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	4	stage_un1_stage.Media.user_id	1	100.00	Using where

    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.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
    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:1500
    13	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    12	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:822
    9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.24 ms After last query: 0.08 ms Query memory: 0.043 MB Memory before query: 5.277 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 IN (440)
     )

    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.02 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.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:1500
    19	JDatabaseDriver->loadAssocList()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/model_joomla.php:68
    18	S2Model->query()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:428
    17	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    16	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:187
    15	EverywhereComponent->runEverywhereModels()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:220
    14	EverywhereComponent->plgAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
    13	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:106
    12	MyModel->plgAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:448
    11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:822
    9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.10 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 5.311 MB Rows returned: 1

    SELECT
    						media.media_id,
    						media.media_type,
    						media.media_function,
    						media.likes_rank,
    						media.likes_up,
    						media.likes_total,
    						media.created,
    						media.main_media,
    						media.listing_id,
    						media.review_id,
    						media.user_id,
    						media.filename,
    						media.file_extension,
    						media.rel_path,
    						media.title,
    						media.description,
    						media.media_info,
    						media.metadata,
    						media.embed,
    						media.published,
    						media.approved,
    						media.access,
    						media.views,
    						media.filesize,
    						media.extension
    					
      FROM
    						i8xqe_jreviews_media AS media
    					
      WHERE
    
    						listing_id IN (440)
    
    						
      AND published = 1 
      AND approved = 1
    
    						
      AND access IN (1,5)
    
    						
      AND main_media = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	media	ref	listing	listing	4	const	2	100.00	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.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
    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/templates/jreviews_overrides/models/media.php:1538
    20	MediaModel->addMediaDetail()	JROOT/templates/jreviews_overrides/models/media.php:1155
    19	MediaModel->addMedia()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/models/everywhere/everywhere_com_content.php:714
    18	EverywhereComContentModel->afterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:452
    17	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    16	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:187
    15	EverywhereComponent->runEverywhereModels()	JROOT/components/com_jreviews/jreviews/controllers/components/everywhere.php:220
    14	EverywhereComponent->plgAfterFind()	JROOT/components/com_jreviews/jreviews/models/my_model.php:175
    13	MyModel->notifyObservers()	JROOT/components/com_jreviews/jreviews/models/my_model.php:106
    12	MyModel->plgAfterFind()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:448
    11	S2ModelCore->find()	JROOT/components/com_s2framework/s2framework/libs/model/model.php:134
    10	S2ModelCore->findAll()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:822
    9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.18 ms After last query: 0.60 ms Query memory: 0.031 MB Memory before query: 5.406 MB Rows returned: 2

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.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.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.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:1695
    30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:173
    27	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    26	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_content/router.php:249
    25	contentBuildRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:2515
    24	JReviewsRouter->getArticleRoute()	JROOT/plugins/system/jreviews_sef/joomla_380/router.php:1036
    23	JReviewsRouter->buildRule()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    21	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_s2framework/s2framework/libs/cms_compat/joomla/framework_joomla.php:1164
    15	cmsFramework::route()	JROOT/components/com_s2framework/s2framework/libs/view/helpers/html.php:151
    14	HtmlHelper->sefLink()	JROOT/components/com_jreviews/jreviews/views/themes/default/media/video_gallery.thtml:106
    13	include JROOT/components/com_jreviews/jreviews/views/themes/default/media/video_gallery.thtml	JROOT/components/com_s2framework/s2framework/libs/view/view.php:419
    12	MyView->_render()	JROOT/components/com_s2framework/s2framework/libs/view/view.php:196
    11	MyView->render()	JROOT/components/com_s2framework/s2framework/libs/controller/controller.php:236
    10	S2Controller->render()	JROOT/components/com_jreviews/jreviews/controllers/media_controller.php:879
    9	MediaController->videoGallery()	JROOT/components/com_s2framework/s2framework/dispatcher.php:340
    8	S2Dispatcher->dispatch()	JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php:200
    7	require JROOT/components/com_jreviews/jreviews/cms_compat/joomla/bootloader.php	JROOT/components/com_jreviews/jreviews.php:17
    6	require_once JROOT/components/com_jreviews/jreviews.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.44 ms After last query: 7.95 ms Query memory: 0.025 MB Memory before query: 5.692 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 10:37:57') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-01 10:37:57') 
      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.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.02 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	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/ModuleHelper.php:432
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:514
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:461
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:269
    8	Helix3::generatelayout()	JROOT/templates/flex/index.php:233
    7	require JROOT/templates/flex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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.07 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 5.694 MB Rows returned: 2

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jreviews_sef/joomla_380/jreviews_sef.php:139
    16	JReviewsPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    15	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    14	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:369
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:514
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:461
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:269
    8	Helix3::generatelayout()	JROOT/templates/flex/index.php:233
    7	require JROOT/templates/flex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `i8xqe_extensions`

2. 1 × SELECT `data` 
     FROM `i8xqe_session`

3. 1 × 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

4. 1 × 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)

5. 1 × SELECT       media.media_id,       media.media_type,       media.media_function,       media.likes_rank,       media.likes_up,       media.likes_total,       media.created,       media.main_media,       media.listing_id,       media.review_id,       media.user_id,       media.filename,       media.file_extension,       media.rel_path,       media.title,       media.description,       media.media_info,       media.metadata,       media.embed,       media.published,       media.approved,       media.access,       media.views,       media.filesize,       media.extension      
     FROM       i8xqe_jreviews_media AS media

6. 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

7. 1 × SELECT Media.media_id AS `Media.media_id`, Media.media_type AS `Media.media_type`, IF ( Media.media_type = "video" 
     AND Media.embed != "",Media.embed,Media.media_type) AS `Media.drive`, Media.media_function AS `Media.media_function`, Media.listing_id AS `Media.listing_id`, Media.extension AS `Media.extension`, Media.review_id AS `Media.review_id`, Media.name AS `Media.name`, Media.filename AS `Media.filename`, Media.file_extension AS `Media.file_extension`, Media.rel_path AS `Media.rel_path`, Media.media_info AS `Media.media_info`, Media.metadata AS `Media.metadata`, Media.embed AS `Media.embed`, Media.title AS `Media.title`, Media.description AS `Media.description`, Media.duration AS `Media.duration`, Media.filesize AS `Media.filesize`, Media.created AS `Media.created`, Media.modified AS `Media.modified`, Media.approved AS `Media.approved`, Media.published AS `Media.published`, Media.access AS `Media.access`, INET_NTOA(Media.ipaddress) AS `Media.ipaddress`, Media.views AS `Media.views`, Media.main_media AS `Media.main_media`, Media.likes_up AS `Media.likes_up`, Media.likes_total AS `Media.likes_total`, Media.likes_rank AS `Media.likes_rank`, Media.ordering AS `Media.ordering`, Media.user_id AS `Media.user_id`, Media.user_id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.block AS `User.block`, IF(User.email <> "", User.email, Media.email) AS `User.email`  
     FROM i8xqe_jreviews_media AS Media 
     LEFT JOIN i8xqe_users AS User 
     ON Media.user_id = User.id

8. 1 × SELECT     listing_id, review_id, extension, Listing.created_by AS owner_id    
     FROM     i8xqe_jreviews_media AS Media    
     LEFT JOIN     i8xqe_content AS Listing 
     ON Listing.id = Media.listing_id

9. 1 × SELECT name 
     FROM i8xqe_jreviews_addons

10. 1 × SELECT value 
      FROM i8xqe_jreviews_config

11. 1 × 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

12. 1 × SELECT                 count(*)             
      FROM                 i8xqe_jreviews_categories

13. 1 × SELECT * 
      FROM i8xqe_languages

14. 1 × 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

15. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM i8xqe_extensions

16. 1 × SELECT b.id 
      FROM i8xqe_usergroups AS a 
      LEFT JOIN i8xqe_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

17. 1 × SELECT id, rules 
      FROM `i8xqe_viewlevels

18. 1 × SELECT                 id             
      FROM                 i8xqe_jreviews_categories

OTHER Tables:

1. 1 × UPDATE `i8xqe_extensions` 
     SET `params` = '{\"mediaversion\":\"2d75418e5282bd7756931d47ee9bbf0e\"}'

2. 1 × 
     SET SQL_BIG_SELECTS=

3. 1 × SHOW TABLES LIKE '%_jreviews_config

4. 1 × UPDATE                     i8xqe_jreviews_media AS Media                 
     SET                     views = views + 1