Forgotten your password?

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1634758521,
                "last": 1634758521,
                "now": 1634758521
            },
            "token": "KGSspGcp5Tga9nqPbngGt27NHJVCFQOr"
        },
        "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
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Time

Memory

86 Queries Logged 230.88 ms

1. Query Time: 0.30 ms Query memory: 0.023 MB Memory before query: 1.526 MB Rows returned: 0

   SELECT `data`
   
     FROM `etn_session`
   
     WHERE `session_id` = X'3075657034666c76653071336865676264683170366666386b36'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	etn_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   starting	0.03 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.00 ms
   After table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:854
   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:414
   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.38 ms After last query: 3.27 ms Query memory: 0.020 MB Memory before query: 1.542 MB Rows returned: 0
   Duplicate queries: #82

   SELECT `session_id`
   
     FROM `etn_session`
   
     WHERE `session_id` = X'3075657034666c76653071336865676264683170366666386b36' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	etn_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   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.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	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:856
   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:414
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.93 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 1.548 MB

   INSERT INTO `etn_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3075657034666c76653071336865676264683170366666386b36', 1, 1634758521, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `etn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3075657034666c76653071336865676264683170366666386b36', 1, 1634758521, 0, '', 0)

   Profile

   Status	Duration
   starting	0.03 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
   After table lock	0.00 ms
   init	0.01 ms
   update	0.07 ms
   end	0.01 ms
   query end	0.58 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	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:856
   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:414
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.67 ms After last query: 8.14 ms Query memory: 0.073 MB Memory before query: 1.647 MB Rows returned: 53

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `etn_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	etn_extensions	ref	extension	extension	82	const	56	Using index condition; Using where

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After table lock	0.00 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.33 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 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.]

   ---

5. Query Time: 0.40 ms After last query: 6.54 ms Query memory: 0.021 MB Memory before query: 1.719 MB Rows returned: 13

   SELECT id, rules
   
     FROM `etn_viewlevels`

   Explain

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

   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.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.00 ms
   updating status	0.01 ms
   cleaning up	0.00 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.]

   ---

6. Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.735 MB Rows returned: 2

   SELECT b.id
   
     FROM etn_usergroups AS a
   
     LEFT JOIN etn_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	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	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
   After table lock	0.00 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 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.]

   ---

7. Query Time: 1.94 ms After last query: 1.98 ms Query memory: 0.051 MB Memory before query: 1.757 MB Rows returned: 160

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	etn_extensions	ref	extension	extension	82	const	242	Using index condition; Using where; Using filesort

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After table lock	0.00 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sorting result	0.79 ms
   Sending data	0.74 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 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.]

   ---

8. Query Time: 0.46 ms After last query: 41.59 ms Query memory: 0.022 MB Memory before query: 2.423 MB Rows returned: 1

   SELECT `value`
   
     FROM `etn_admintools_storage`
   
     WHERE `key` = 'cparams'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	etn_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

   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
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
   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: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: 0.40 ms After last query: 6.43 ms Query memory: 0.021 MB Memory before query: 2.458 MB Rows returned: 0

   SELECT *
   
     FROM `etn_admintools_wafexceptions`
   
     WHERE NOT(`option` LIKE 'com_%')

   Explain

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

   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.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
   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: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.43 ms After last query: 69.10 ms Query memory: 0.026 MB Memory before query: 2.937 MB Rows returned: 93

    SELECT `config_key`,`config_value`
    
      FROM etn_osmembership_configs

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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
    After 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.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:41
    10	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:61
    9	OSMembershipHelper::getConfig()	JROOT/administrator/components/com_osmembership/loader.php:80
    8	require_once JROOT/administrator/components/com_osmembership/loader.php	JROOT/plugins/system/membershippro/membershippro.php:55
    7	plgSystemMembershipPro->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
    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: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: 0.50 ms After last query: 51.63 ms Query memory: 0.024 MB Memory before query: 3.602 MB Rows returned: 1

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

    Explain

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

    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.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.04 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/improved_ajax_login/improved_ajax_login.php:21
    7	require_once JROOT/plugins/system/improved_ajax_login/improved_ajax_login.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
    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: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: 0.91 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 3.595 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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.00 ms
    After table lock	0.00 ms
    init	0.08 ms
    Updating	0.07 ms
    end	0.01 ms
    query end	0.58 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/improved_ajax_login/improved_ajax_login.php:21
    7	require_once JROOT/plugins/system/improved_ajax_login/improved_ajax_login.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
    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: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: 0.32 ms After last query: 78.72 ms Query memory: 0.021 MB Memory before query: 4.226 MB Rows returned: 0

    SELECT *
    
      FROM `etn_admintools_ipautoban`
    
      WHERE `ip` = '34.231.243.21'

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->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:696
    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: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.27 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.231 MB Rows returned: 3

    SELECT `ip`
    
      FROM `etn_admintools_ipblock`

    Explain

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

    Profile

    Status	Duration
    starting	0.02 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
    After table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
    11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
    10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->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:696
    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: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.28 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 4.238 MB Rows returned: 1

    SELECT *
    
      FROM `etn_admintools_storage`
    
      WHERE `key` LIKE 'timestamp_%'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	1	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
    12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
    11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
    10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->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:696
    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: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.31 ms After last query: 1.10 ms Query memory: 0.021 MB Memory before query: 4.250 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `etn_admintools_redirects`
    
      WHERE ((`dest` = 'lost-password.html') OR (`dest` = 'lost-password.html') OR ('lost-password.html' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->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:696
    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: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: 26.18 ms Query memory: 0.023 MB Memory before query: 4.502 MB Rows returned: 1

    SELECT *
    
      FROM etn_languages
    
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:219
    12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:171
    11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:85
    10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:101
    9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
    8	plgSystemSh404sef->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:696
    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: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: 0.99 ms After last query: 3.19 ms Query memory: 0.069 MB Memory before query: 4.542 MB Rows returned: 31

    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 etn_menu AS m
    
      LEFT JOIN etn_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	37	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.m.component_id	1	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 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
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.15 ms
    Sending data	0.47 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    19	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    16	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    15	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    14	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    13	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
    12	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    11	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:131
    10	Sh404sefClassPageinfo->loadHomepages()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103
    9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:103
    8	plgSystemSh404sef->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:696
    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: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: 0.44 ms After last query: 23.07 ms Query memory: 0.038 MB Memory before query: 4.870 MB Rows returned: 1

    SELECT `params` 
      FROM etn_extensions 
      WHERE `element`='com_sh404sef' 
      AND `type`='component';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.04 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.00 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
    14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
    13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
    12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
    11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:671
    10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
    9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:126
    8	plgSystemSh404sef->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:696
    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: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: 0.37 ms After last query: 100.25 ms Query memory: 0.024 MB Memory before query: 5.636 MB Rows returned: 0

    SELECT * 
      FROM `etn_sh404sef_aliases` 
      WHERE `state` = 1 
      and (`alias` = 'lost-password.html') 
      order by `ordering` asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_sh404sef_aliases	ref	state,alias	alias	573	const	1	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:222
    15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
    14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
    13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
    12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:706
    11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
    10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
    7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
    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.]

    ---

21. Query Time: 0.32 ms After last query: 0.93 ms Query memory: 0.025 MB Memory before query: 5.648 MB Rows returned: 0

    SELECT * 
      FROM etn_sh404sef_aliases 
      WHERE state = 1 
      and (type = 1 or type = 2);

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_sh404sef_aliases	ref	type,state	state	1	const	2	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
    18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
    17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
    16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:287
    15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:117
    14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:87
    13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
    12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:706
    11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:295
    10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
    7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
    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.]

    ---

22. Query Time: 0.30 ms After last query: 0.35 ms Query memory: 0.025 MB Memory before query: 5.661 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.02 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
    After table lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    17	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:2067
    16	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:2035
    15	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1978
    14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1439
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
    11	Sh404sefClassRouterInternal->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:597
    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:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
    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.]

    ---

23. Query Time: 0.34 ms After last query: 4.88 ms Query memory: 0.025 MB Memory before query: 5.746 MB Rows returned: 1

    SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
      FROM etn_sh404sef_urls 
      WHERE `oldurl`='lost-password.html' 
      ORDER BY `rank`;

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_sh404sef_urls	ref	oldurl	oldurl	573	const	1	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
    18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
    17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
    16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
    15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1992
    14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1439
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
    11	Sh404sefClassRouterInternal->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:597
    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:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
    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.]

    ---

24. Query Time: 0.31 ms After last query: 1.12 ms Query memory: 0.008 MB Memory before query: 5.759 MB

    UPDATE `etn_sh404sef_urls` 
      SET `cpt`=1368, `last_hit`='2021-10-20 19:35:22' 
      WHERE `id`='15' 
      AND `rank`=0;

    Explain

    EXPLAIN not possible on query: UPDATE `etn_sh404sef_urls` SET `cpt`=1368, `last_hit`='2021-10-20 19:35:22' WHERE `id`='15' AND `rank`=0;

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.04 ms
    Updating	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
    17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
    16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
    15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
    14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1458
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2664
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:457
    11	Sh404sefClassRouterInternal->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:597
    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:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
    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.]

    ---

25. Query Time: 0.41 ms After last query: 6.94 ms Query memory: 0.021 MB Memory before query: 5.785 MB Rows returned: 2

    SELECT *
    
      FROM `etn_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_users') 
      AND `view` IN('','reset') 
      AND `task` IN('','reset.') 
      AND `enabled` = '1'
    
      GROUP BY `query`
    
      ORDER BY `query` ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Creating tmp table	0.03 ms
    Copying to tmp table	0.04 ms
    Sorting result	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:92
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
    8	plgSystemAdmintools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
    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.]

    ---

26. Query Time: 0.52 ms After last query: 5.10 ms Query memory: 0.022 MB Memory before query: 5.864 MB Rows returned: 11

    SELECT id, home, template, s.params
    
      FROM etn_template_styles as s
    
      LEFT JOIN etn_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	Using index condition; Using where
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	mclgloba_etndev.e.element	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
    9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
    8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
    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.]

    ---

27. Query Time: 0.39 ms After last query: 52.35 ms Query memory: 0.023 MB Memory before query: 6.390 MB Rows returned: 7

    SELECT s.id, s.template, s.home, s.title AS long_title, s.params
    
      FROM etn_template_styles AS s
    
      WHERE s.client_id = 0 
      AND s.template = 'rt_callisto'
    
      ORDER BY s.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	index	idx_template,idx_client_id,idx_client_id_home	PRIMARY	4	NULL	13	Using where

    Profile

    Status	Duration
    starting	0.04 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
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
    14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
    13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:304
    12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
    11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
    10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
    9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
    8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
    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.]

    ---

28. Query Time: 1.19 ms After last query: 36.32 ms Query memory: 0.027 MB Memory before query: 6.702 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 etn_fields AS a
    
      LEFT JOIN `etn_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN etn_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN etn_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN etn_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN etn_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.reset_request' 
      AND a.access IN (1,1,5,8,12,14) 
      AND (a.group_id = 0 OR g.access IN (1,1,5,8,12,14)) 
      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	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	mclgloba_etndev.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.a.group_id	1	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 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.00 ms
    After table lock	0.01 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.01 ms
    Creating tmp table	0.35 ms
    Copying to tmp table	0.04 ms
    Sorting result	0.02 ms
    Sending data	0.06 ms
    end	0.01 ms
    removing tmp table	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/reset.php:112
    13	UsersModelReset->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/reset.php:37
    11	UsersModelReset->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/reset/view.html.php:55
    9	UsersViewReset->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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.]

    ---

29. Query Time: 0.46 ms After last query: 89.95 ms Query memory: 0.029 MB Memory before query: 7.471 MB Rows returned: 0

    SELECT `oldurl`, `dateadd` 
      FROM etn_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_users&Itemid=101&lang=en&task=reset.request';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    30	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    29	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    28	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    27	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:779
    26	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:816
    25	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1538
    24	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1230
    23	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2675
    22	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1084
    21	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/rt_callisto/html/com_users/reset/default.php:33
    12	include JROOT/templates/rt_callisto/html/com_users/reset/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_users/views/reset/view.html.php:72
    9	UsersViewReset->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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.]

    ---

30. Query Time: 1.18 ms After last query: 30.29 ms Query memory: 0.027 MB Memory before query: 7.663 MB Rows returned: 54

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `etn_assets`
    
      WHERE `name` IN ('root.1','com_aclmanager','com_actionlogs','com_acymailing','com_admin','com_admintools','com_aglossary','com_ajax','com_akeeba','com_akquickicons','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_gantry5','com_improved_ajax_login','com_installer','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_osmembership','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_regularlabsmanager','com_rstbox','com_search','com_sh404sef','com_sptransfer','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_assets	range	idx_asset_name	idx_asset_name	202	NULL	54	Using index condition

    Profile

    Status	Duration
    starting	0.09 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.00 ms
    After table lock	0.01 ms
    init	0.09 ms
    optimizing	0.02 ms
    statistics	0.24 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.53 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    9	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:34
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:68
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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.]

    ---

31. Query Time: 0.26 ms After last query: 1.68 ms Query memory: 0.020 MB Memory before query: 7.732 MB Rows returned: 0

    SELECT `id`
    
      FROM `etn_rstbox`
    
      WHERE `published` = 1 
      AND `testmode` = 0

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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
    After table lock	0.00 ms
    init	0.01 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:68
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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.]

    ---

32. Query Time: 1.21 ms After last query: 14.53 ms Query memory: 0.033 MB Memory before query: 7.835 MB Rows returned: 41

    SHOW FULL COLUMNS 
      FROM `etn_sh404sef_metas`

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.26 ms
    After opening tables	0.01 ms
    System lock	0.04 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.09 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:138
    14	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:320
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:37
    12	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
    11	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:118
    10	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:190
    9	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:390
    8	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:304
    7	plgSystemSh404sef->onAfterDispatch()	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/SiteApplication.php:199
    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.]

    ---

33. Query Time: 0.37 ms After last query: 1.84 ms Query memory: 0.025 MB Memory before query: 7.900 MB Rows returned: 0

    SELECT * 
      FROM etn_sh404sef_metas 
      WHERE `newurl`='index.php?option=com_users&Itemid=101&lang=en&view=reset';

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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
    After table lock	0.00 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:38
    12	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
    11	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:118
    10	Sh404sefHelperMetadata::getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:190
    9	Sh404sefHelperMetadata::getFinalizedCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:390
    8	Sh404sefHelperMetadata::insertMetaData()	JROOT/plugins/system/sh404sef/sh404sef.php:304
    7	plgSystemSh404sef->onAfterDispatch()	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/SiteApplication.php:199
    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.]

    ---

34. Query Time: 2.41 ms After last query: 127.00 ms Query memory: 0.109 MB Memory before query: 8.986 MB Rows returned: 50

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM etn_modules AS m
    
      LEFT JOIN etn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN etn_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 <= '2021-10-20 19:35:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-10-20 19:35:22') 
      AND m.access IN (1,1,5,8,12,14) 
      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	ref	PRIMARY,published,newsfeeds	published	1	const	78	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	mclgloba_etndev.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	mclgloba_etndev.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.00 ms
    After table lock	0.01 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.53 ms
    Sending data	1.28 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    51	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    48	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    47	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    46	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
    45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    43	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    41	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    38	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    35	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

35. Query Time: 0.41 ms After last query: 60.06 ms Query memory: 0.038 MB Memory before query: 9.602 MB Rows returned: 0
    Duplicate queries: #48  #52  #55  #58  #60  #64  #66  #68  #70  #72  #75

    SELECT *
    
      FROM etn_banners
    
      WHERE '2021-10-20 19:35:22' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible 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.00 ms
    After table lock	0.01 ms
    init	0.05 ms
    optimizing	0.03 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    51	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    50	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    49	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    48	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    47	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    46	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    43	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    41	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    38	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    35	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

36. Query Time: 0.93 ms After last query: 1.81 ms Query memory: 0.039 MB Memory before query: 9.635 MB Rows returned: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM etn_banners as a
    
      LEFT JOIN etn_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-10-20 19:35:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-10-20 19:35:22') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (27)
    
      ORDER BY a.sticky DESC, RAND()  
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	4	Using where; Using temporary; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.a.cid	1

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.00 ms
    Creating tmp table	0.24 ms
    Copying to tmp table	0.10 ms
    Sorting result	0.03 ms
    Sending data	0.02 ms
    end	0.01 ms
    removing tmp table	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    54	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    53	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
    52	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    51	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    50	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    49	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    48	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    47	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    46	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    43	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    41	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    38	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    35	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

37. Query Time: 0.83 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 9.663 MB

    UPDATE etn_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (1641)

    Explain

    EXPLAIN not possible on query: UPDATE etn_banners SET impmade = (impmade + 1) WHERE id IN (1641)

    Profile

    Status	Duration
    starting	0.02 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
    After table lock	0.00 ms
    init	0.03 ms
    Updating	0.05 ms
    end	0.01 ms
    query end	0.55 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    52	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:266
    51	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    50	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    49	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    48	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    47	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    46	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    43	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    41	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    38	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    35	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

38. Query Time: 0.35 ms After last query: 1.53 ms Query memory: 0.050 MB Memory before query: 9.685 MB Rows returned: 1

    SELECT `oldurl`, `dateadd` 
      FROM etn_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_banners&id=1641&lang=en&task=click';

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	etn_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

    Profile

    Status	Duration
    starting	0.02 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.00 ms
    After table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    69	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    68	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    67	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    66	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    65	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:779
    64	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:816
    63	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1538
    62	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1230
    61	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2675
    60	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1084
    59	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
    58	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    57	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    56	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    55	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    54	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    53	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    52	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    51	Joomla\CMS\Router\Route::_()	JROOT/templates/rt_callisto/html/mod_banners/default.php:23
    50	require JROOT/templates/rt_callisto/html/mod_banners/default.php	JROOT/modules/mod_banners/mod_banners.php:23
    49	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    48	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    47	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    46	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    45	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    43	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    41	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    38	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    35	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

39. Query Time: 21.84 ms After last query: 8.36 ms Query memory: 0.074 MB Memory before query: 9.794 MB Rows returned: 9

    SELECT a.id, a.title, a.alias, a.catid AS category_id, a.access, a.featured, a.language,(SELECT GROUP_CONCAT(fv.field_id SEPARATOR '::') AS cf_id 
      FROM etn_fields_values AS fv 
      WHERE fv.item_id = a.id 
      GROUP BY fv.item_id) AS cf_ids,(SELECT GROUP_CONCAT(f.`name` SEPARATOR '::') AS cf_name 
      FROM etn_fields_values AS fv 
      LEFT JOIN etn_fields AS f 
      ON f.id = fv.field_id 
      WHERE fv.item_id = a.id 
      GROUP BY fv.item_id) AS cf_names,(SELECT GROUP_CONCAT(fv.`value` SEPARATOR '::') AS cf_value 
      FROM etn_fields_values AS fv 
      WHERE fv.item_id = a.id 
      GROUP BY fv.item_id) AS cf_values, a.created AS date, a.introtext, a.fulltext, a.images
    
      FROM etn_content AS a
    
      LEFT JOIN etn_categories AS c 
      ON c.id = a.catid
    
      WHERE (a.catid = 10 OR a.catid = 11 OR a.catid = 320 OR a.catid = 313 OR a.catid = 301 OR a.catid = 314 OR a.catid = 315) 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5,8,12,14) 
      AND a.access IN (1,5,8,12,14) 
      AND a.featured = 0 
      AND a.publish_up <= '2021-10-20 19:35:22' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-10-20 19:35:22')
    
      ORDER BY date DESC 
      LIMIT 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	5215	Using index condition; Using where; Using filesort
    1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	mclgloba_etndev.a.catid	1	Using where
    4	DEPENDENT SUBQUERY	fv	ALL	idx_item_id	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort
    3	DEPENDENT SUBQUERY	fv	ALL	idx_item_id	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort
    3	DEPENDENT SUBQUERY	f	eq_ref	PRIMARY	PRIMARY	4	mclgloba_etndev.fv.field_id	1
    2	DEPENDENT SUBQUERY	fv	ALL	idx_item_id	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using filesort

    Profile

    Status	Duration
    Sending data	0.07 ms
    removing tmp table	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    executing	0.02 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.05 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.04 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    removing tmp table	0.00 ms
    end	0.00 ms
    removing tmp table	0.00 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    57	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_raxo_allmode/helper.php:499
    56	ModRaxoAllmodeHelper::getList()	Same as call in the line below.
    55	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    54	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    53	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    52	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    42	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

40. Query Time: 0.72 ms After last query: 2.88 ms Query memory: 0.051 MB Memory before query: 9.876 MB Rows returned: 3

    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 `etn_categories` AS `s`
    
      INNER JOIN `etn_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,8,12,14) 
      AND c.published = 1 
      AND s.id = 301
    
      ORDER BY c.lft

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 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
    After table lock	0.01 ms
    init	0.05 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    70	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    69	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    68	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    67	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    66	ContentRouter->getCategorySegment()	Same as call in the line below.
    65	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    64	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    63	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    62	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    61	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    60	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    59	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    58	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    57	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:583
    56	ModRaxoAllmodeHelper::getList()	Same as call in the line below.
    55	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    54	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    53	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    52	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    42	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

41. Query Time: 0.60 ms After last query: 1.83 ms Query memory: 0.051 MB Memory before query: 9.935 MB Rows returned: 3

    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 `etn_categories` AS `s`
    
      INNER JOIN `etn_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,8,12,14) 
      AND c.published = 1 
      AND s.id = 314
    
      ORDER BY c.lft

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	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
    After table lock	0.00 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    70	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    69	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    68	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    67	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    66	ContentRouter->getCategorySegment()	Same as call in the line below.
    65	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    64	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    63	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    62	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    61	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    60	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    59	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    58	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    57	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:583
    56	ModRaxoAllmodeHelper::getList()	Same as call in the line below.
    55	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    54	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    53	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    52	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    42	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

42. Query Time: 0.60 ms After last query: 0.71 ms Query memory: 0.051 MB Memory before query: 9.978 MB Rows returned: 3

    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 `etn_categories` AS `s`
    
      INNER JOIN `etn_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,8,12,14) 
      AND c.published = 1 
      AND s.id = 320
    
      ORDER BY c.lft

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	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
    After table lock	0.00 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    70	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    69	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    68	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    67	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    66	ContentRouter->getCategorySegment()	Same as call in the line below.
    65	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    64	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    63	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    62	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    61	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    60	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    59	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    58	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    57	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:583
    56	ModRaxoAllmodeHelper::getList()	Same as call in the line below.
    55	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    54	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    53	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    52	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    42	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

43. Query Time: 0.60 ms After last query: 0.61 ms Query memory: 0.051 MB Memory before query: 10.027 MB Rows returned: 3

    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 `etn_categories` AS `s`
    
      INNER JOIN `etn_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,8,12,14) 
      AND c.published = 1 
      AND s.id = 10
    
      ORDER BY c.lft

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	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
    After table lock	0.00 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    70	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    69	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    68	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    67	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    66	ContentRouter->getCategorySegment()	Same as call in the line below.
    65	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    64	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    63	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    62	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    61	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    60	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    59	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    58	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    57	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:583
    56	ModRaxoAllmodeHelper::getList()	Same as call in the line below.
    55	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    54	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    53	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    52	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
    49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
    48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
    47	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:43
    46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
    45	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_callisto/twig/9b/9bbf4c880bf0b273ec537154d89441e6b142e7e9ee12e6295b41b3dbd8e63352.php:73
    44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    42	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/14/142d51549c0944d395989619926ff8d4e69c4a0e17c98c012b70e57936a9a44a.php:35
    41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/73/73ee62ce8d426b0b7d43f645bb7bbc780cb70534df9472522bcfe37fb4d4a010.php:53
    38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
    31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
    30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
    29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_callisto/twig/69/69aaff79b71ab49c7abf8414c33416bdfb1e27086cdbc230007203065097ef17.php:47
    20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/8a/8acfb40d56e3555e83c81a205ddf4e4ae8a05d68158bdaa0148e58472d8ed1c1.php:35
    17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_callisto/twig/67/67771810a72dd737bf641e8756b67264ba35183342d751e7482e277e4b2c5bb0.php:35
    14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
    12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
    11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_callisto/index.php:23
    7	require JROOT/templates/rt_callisto/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
    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.]

    ---

44. Query Time: 0.58 ms After last query: 1.05 ms Query memory: 0.051 MB Memory before query: 10.074 MB Rows returned: 3

    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 `etn_categories` AS `s`
    
      INNER JOIN `etn_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,8,12,14) 
      AND c.published = 1 
      AND s.id = 11
    
      ORDER BY c.lft