{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733212530,
                "last": 1733212530,
                "now": 1733212530
            },
            "token": "SPmqaWWPDYj4834oK0BQZZS0gf59LQsL"
        },
        "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
        }
    }
}

Time

Memory

22 Queries Logged 152.37 ms

1. Query Time: 0.75 ms Query memory: 0.020 MB Memory before query: 0.753 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ekx30_session`
   
     WHERE `session_id` = X'7467303469666875717569653973726c6b6c71346b3466303934' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ekx30_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	499	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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: 38.84 ms After last query: 0.15 ms Query memory: 0.003 MB Memory before query: 0.758 MB

   INSERT INTO `ekx30_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'7467303469666875717569653973726c6b6c71346b3466303934', 1, 1733212530, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ekx30_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7467303469666875717569653973726c6b6c71346b3466303934', 1, 1733212530, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.02 ms
   Update	0.10 ms
   Waiting for query cache lock	0.00 ms
   Update	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	38.46 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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: 1.57 ms After last query: 1.84 ms Query memory: 0.038 MB Memory before query: 0.786 MB Rows returned: 68

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ekx30_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	356	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   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:225
   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.27 ms After last query: 1.88 ms Query memory: 0.020 MB Memory before query: 0.797 MB Rows returned: 5

   SELECT id, rules
   
     FROM `ekx30_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   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:318
   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:225
   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.42 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 0.807 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
   1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   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:318
   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:225
   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: 2.07 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 0.827 MB Rows returned: 144

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   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:356
   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:225
   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: 3.24 ms After last query: 19.47 ms Query memory: 0.024 MB Memory before query: 1.179 MB Rows returned: 7

   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 ekx30_menu AS m
   
     LEFT JOIN ekx30_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	Extra
   1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	5	Using index condition; Using where; Using temporary; Using filesort
   1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	356	Using where; Using join buffer (flat, BNL join)

   Profile

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

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{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/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
   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:225
   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: 1.24 ms After last query: 9.27 ms Query memory: 0.022 MB Memory before query: 1.246 MB Rows returned: 2

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	ekx30_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	356	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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:225
   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: 8.14 ms After last query: 0.25 ms Query memory: 0.004 MB Memory before query: 1.236 MB

   UPDATE `ekx30_extensions`
   
     SET `params` = '{\"mediaversion\":\"b9601084739a3b20ad826acf2f2abd19\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN not possible on query: UPDATE `ekx30_extensions` SET `params` = '{\"mediaversion\":\"b9601084739a3b20ad826acf2f2abd19\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.04 ms
   Updating	1.46 ms
   End of update loop	0.01 ms
   Waiting for query cache lock	0.00 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	6.37 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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:225
   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.44 ms After last query: 1.61 ms Query memory: 0.019 MB Memory before query: 1.253 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    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:225
    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: 1.19 ms After last query: 0.36 ms Query memory: 0.018 MB Memory before query: 1.265 MB Rows returned: 6

    SELECT id, home, template, s.params
    
      FROM ekx30_template_styles as s
    
      LEFT JOIN ekx30_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	Extra
    1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	356	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    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:225
    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: 2.02 ms After last query: 7.50 ms Query memory: 0.027 MB Memory before query: 1.313 MB Rows returned: 136

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ekx30_assets	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	591	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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: 59.55 ms After last query: 2.08 ms Query memory: 0.054 MB Memory before query: 1.390 MB Rows returned: 4

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM ekx30_content AS a
    
      INNER JOIN ekx30_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN ekx30_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ekx30_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ekx30_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ekx30_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ekx30_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-03 07:55:30') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-03 07:55:30')
    
      ORDER BY c.lft, a.featured DESC, fp.ordering,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using temporary; Using filesort
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	172	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	ua	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	uam	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	v	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.61 ms After last query: 1.57 ms Query memory: 0.022 MB Memory before query: 1.455 MB Rows returned: 0
    Duplicate queries: #15  #16  #17

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	t	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.36 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 1.472 MB Rows returned: 0
    Duplicate queries: #14  #16  #17

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	t	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.37 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 1.489 MB Rows returned: 0
    Duplicate queries: #14  #15  #17

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	t	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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.34 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 1.506 MB Rows returned: 0
    Duplicate queries: #14  #15  #16

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	t	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 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.03 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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: 22.46 ms After last query: 0.95 ms Query memory: 0.022 MB Memory before query: 1.504 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM ekx30_content AS a
    
      INNER JOIN ekx30_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN ekx30_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ekx30_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ekx30_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ekx30_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ekx30_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-03 07:55:30') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-03 07:55:30')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	172	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	ua	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	uam	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	v	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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: 2.47 ms After last query: 4.00 ms Query memory: 0.025 MB Memory before query: 1.520 MB Rows returned: 32

    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 `ekx30_categories` AS `s`
    
      INNER JOIN `ekx30_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) 
      AND c.published = 1 
      AND s.id = 2
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using temporary; Using filesort
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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: 1.36 ms After last query: 0.63 ms Query memory: 0.024 MB Memory before query: 1.599 MB Rows returned: 0

    SELECT DISTINCT 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 ekx30_fields AS a
    
      LEFT JOIN `ekx30_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ekx30_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ekx30_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ekx30_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ekx30_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `ekx30_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 (2,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      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	Extra
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	uc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	ag	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	ua	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	g	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	fc	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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: 1.97 ms After last query: 2.75 ms Query memory: 0.025 MB Memory before query: 1.632 MB Rows returned: 8

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ekx30_modules AS m
    
      LEFT JOIN ekx30_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ekx30_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 <= '2024-12-03 07:55:30') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-03 07:55:30') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where; Using temporary; Using filesort
    1	SIMPLE	mm	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	25	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	356	Using where; Using join buffer (incremental, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:169
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    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:225
    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: 2.69 ms After last query: 61.47 ms Query memory: 0.025 MB Memory before query: 1.854 MB Rows returned: 32

    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 `ekx30_categories` AS `s`
    
      INNER JOIN `ekx30_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) 
      AND c.published = 1 
      AND s.id = 15
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using temporary; Using filesort
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    17	ContentRouter->getCategorySegment()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    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:231
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 4 × SELECT `m`.`tag_id`,`t`.* 
     FROM `ekx30_contentitem_tag_map` AS m  
     INNER JOIN `ekx30_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

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

3. 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 `ekx30_categories` AS `s` 
     INNER JOIN `ekx30_categories` AS `c` 
     ON (s.lft <= c.lft 
     AND c.lft < s.rgt) OR (c.lft < s.lft 
     AND s.rgt < c.rgt)

4. 1 × SELECT `session_id` 
     FROM `ekx30_session`

5. 1 × SELECT id, rules 
     FROM `ekx30_viewlevels

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

7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM ekx30_extensions

8. 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 ekx30_menu AS m 
     LEFT JOIN ekx30_extensions AS e 
     ON m.component_id = e.extension_id

9. 1 × SELECT * 
     FROM ekx30_languages

10. 1 × SELECT id, home, template, s.params 
      FROM ekx30_template_styles as s 
      LEFT JOIN ekx30_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

11. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `ekx30_assets`

12. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
      FROM ekx30_content AS a 
      INNER JOIN ekx30_content_frontpage AS fp 
      ON fp.content_id = a.id 
      LEFT JOIN ekx30_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN ekx30_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN ekx30_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN ekx30_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN ekx30_content_rating AS v 
      ON a.id = v.content_id

13. 1 × SELECT COUNT(*) 
      FROM ekx30_content AS a 
      INNER JOIN ekx30_content_frontpage AS fp 
      ON fp.content_id = a.id 
      LEFT JOIN ekx30_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN ekx30_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN ekx30_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN ekx30_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN ekx30_content_rating AS v 
      ON a.id = v.content_id

14. 1 × SELECT DISTINCT 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 ekx30_fields AS a 
      LEFT JOIN `ekx30_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN ekx30_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN ekx30_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN ekx30_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN ekx30_fields_groups AS g 
      ON g.id = a.group_id 
      LEFT JOIN `ekx30_fields_categories` AS fc 
      ON fc.field_id = a.id

15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM ekx30_modules AS m 
      LEFT JOIN ekx30_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN ekx30_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

OTHER Tables:

1. 1 × INSERT INTO `ekx30_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'7467303469666875717569653973726c6b6c71346b3466303934', 1, 1733212530, 0, '', 0

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