{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1769104425,
                "last": 1769104425,
                "now": 1769104425
            },
            "token": "WfqGUSM4UnPi4DkJTffBS8AuJdBDYHDF"
        },
        "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
        },
        "js_id_currency_orig": "2",
        "js_id_currency": "2",
        "js_history_sel_lang": "en-GB",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB"
        ]
    }
}

Time

Memory

56 Queries Logged 159.36 ms

1. Query Time: 2.03 ms Query memory: 0.020 MB Memory before query: 1.246 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jdcfn_session`
   
     WHERE `session_id` = X'74706a31363636363067707470757475307035307063616a6b72' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.17 ms
   checking permissions	0.05 ms
   Opening tables	0.07 ms
   After opening tables	0.11 ms
   System lock	0.05 ms
   Table lock	0.04 ms
   After table lock	0.05 ms
   init	0.07 ms
   optimizing	0.07 ms
   statistics	0.15 ms
   preparing	0.04 ms
   executing	0.10 ms
   end	0.05 ms
   query end	0.05 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   updating status	0.11 ms
   cleaning up	0.05 ms

   Call Stack

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

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

   ---

2. Query Time: 1.81 ms After last query: 0.18 ms Query memory: 0.004 MB Memory before query: 1.252 MB

   INSERT INTO `jdcfn_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'74706a31363636363067707470757475307035307063616a6b72', 1, 1769104425, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `jdcfn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'74706a31363636363067707470757475307035307063616a6b72', 1, 1769104425, 0, '', 0)

   Profile

   Status	Duration
   starting	0.12 ms
   checking permissions	0.05 ms
   Opening tables	0.10 ms
   After opening tables	0.05 ms
   System lock	0.04 ms
   Table lock	0.04 ms
   After table lock	0.05 ms
   init	0.06 ms
   update	0.18 ms
   Waiting for query cache lock	0.04 ms
   update	0.04 ms
   end	0.04 ms
   query end	0.15 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   updating status	0.11 ms
   cleaning up	0.08 ms

   Call Stack

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

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

   ---

3. Query Time: 2.90 ms After last query: 0.82 ms Query memory: 0.024 MB Memory before query: 1.349 MB Rows returned: 34

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

   Profile

   Status	Duration
   starting	0.13 ms
   checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.04 ms
   System lock	0.04 ms
   Table lock	0.04 ms
   After table lock	0.04 ms
   init	0.08 ms
   optimizing	0.12 ms
   statistics	0.17 ms
   preparing	0.09 ms
   executing	0.04 ms
   Sending data	0.72 ms
   end	0.05 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   updating status	0.14 ms
   cleaning up	0.05 ms

   Call Stack

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

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

   ---

4. Query Time: 1.77 ms After last query: 0.89 ms Query memory: 0.021 MB Memory before query: 1.377 MB Rows returned: 5

   SELECT id, rules
   
     FROM `jdcfn_viewlevels`

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

5. Query Time: 2.09 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 1.389 MB Rows returned: 2

   SELECT b.id
   
     FROM jdcfn_usergroups AS a
   
     LEFT JOIN jdcfn_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.14 ms
   checking permissions	0.04 ms
   checking permissions	0.04 ms
   Opening tables	0.06 ms
   After opening tables	0.05 ms
   System lock	0.04 ms
   Table lock	0.04 ms
   After table lock	0.04 ms
   init	0.07 ms
   optimizing	0.07 ms
   statistics	0.24 ms
   preparing	0.08 ms
   executing	0.04 ms
   Sending data	0.10 ms
   end	0.05 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   updating status	0.11 ms
   cleaning up	0.05 ms

   Call Stack

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

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

   ---

6. Query Time: 5.27 ms After last query: 0.23 ms Query memory: 0.030 MB Memory before query: 1.411 MB Rows returned: 90

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

   Explain

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

   Profile

   Status	Duration
   starting	0.15 ms
   checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.04 ms
   System lock	0.04 ms
   Table lock	0.04 ms
   After table lock	0.04 ms
   init	0.13 ms
   optimizing	0.08 ms
   statistics	0.14 ms
   preparing	0.10 ms
   executing	0.04 ms
   Sorting result	1.70 ms
   Sending data	1.36 ms
   end	0.05 ms
   query end	0.05 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   updating status	0.14 ms
   cleaning up	0.05 ms

   Call Stack

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

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

   ---

7. Query Time: 1.92 ms After last query: 7.83 ms Query memory: 0.022 MB Memory before query: 1.902 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.10 ms
   checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.04 ms
   System lock	0.04 ms
   Table lock	0.08 ms
   After table lock	0.05 ms
   init	0.06 ms
   optimizing	0.06 ms
   statistics	0.12 ms
   preparing	0.06 ms
   executing	0.04 ms
   Sending data	0.06 ms
   end	0.04 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   updating status	0.11 ms
   cleaning up	0.05 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:667
   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.]

   ---

8. Query Time: 1.78 ms After last query: 0.61 ms Query memory: 0.021 MB Memory before query: 1.926 MB Rows returned: 0

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

   Explain

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

   Profile

   Status	Duration
   starting	0.11 ms
   checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.04 ms
   System lock	0.04 ms
   Table lock	0.04 ms
   After table lock	0.04 ms
   init	0.07 ms
   optimizing	0.06 ms
   statistics	0.06 ms
   preparing	0.06 ms
   executing	0.04 ms
   Sending data	0.10 ms
   end	0.05 ms
   query end	0.09 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   updating status	0.10 ms
   cleaning up	0.05 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:667
   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: 1.88 ms After last query: 24.61 ms Query memory: 0.022 MB Memory before query: 2.541 MB Rows returned: 0

   SELECT *
   
     FROM `jdcfn_admintools_ipautoban`
   
     WHERE `ip` = '216.73.216.88'

   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.10 ms
   checking permissions	0.05 ms
   Opening tables	0.06 ms
   After opening tables	0.04 ms
   System lock	0.04 ms
   Table lock	0.04 ms
   After table lock	0.09 ms
   init	0.07 ms
   optimizing	0.06 ms
   statistics	0.11 ms
   preparing	0.04 ms
   executing	0.06 ms
   end	0.04 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   updating status	0.10 ms
   cleaning up	0.05 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:668
   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: 2.19 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 2.546 MB Rows returned: 235

    SELECT `ip`
    
      FROM `jdcfn_admintools_ipblock`

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.05 ms
    optimizing	0.09 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.04 ms
    Sending data	0.43 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.04 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:668
    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: 3.31 ms After last query: 0.54 ms Query memory: 0.021 MB Memory before query: 2.553 MB Rows returned: 0

    SELECT `id`
    
      FROM `jdcfn_users`
    
      WHERE (`lastvisitDate` = '0000-00-00 00:00:00' OR `lastvisitDate` IS NULL) 
      AND `registerDate` <= DATE_SUB(NOW(), INTERVAL 7 DAY) 
      AND `activation` != '' 
      LIMIT 5

    Explain

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

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.05 ms
    init	0.09 ms
    optimizing	0.08 ms
    statistics	0.07 ms
    preparing	0.07 ms
    executing	0.09 ms
    Sending data	1.56 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/deleteinactive.php:69
    10	AtsystemFeatureDeleteinactive->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:668
    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: 1.91 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 2.558 MB Rows returned: 5
    Duplicate queries: #14  #15  #16  #17

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

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.08 ms
    After table lock	0.05 ms
    init	0.07 ms
    optimizing	0.05 ms
    statistics	0.14 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.15 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 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:668
    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: 1.94 ms After last query: 0.93 ms Query memory: 0.021 MB Memory before query: 2.569 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `jdcfn_admintools_redirects`
    
      WHERE ((`dest` = 'shopping-cart/view') OR (`dest` = 'shopping-cart/view') OR ('shopping-cart/view' 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	jdcfn_admintools_redirects	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.05 ms
    init	0.12 ms
    optimizing	0.07 ms
    statistics	0.07 ms
    preparing	0.07 ms
    executing	0.04 ms
    Sorting result	0.09 ms
    Sending data	0.07 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 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:668
    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: 1.90 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 2.574 MB Rows returned: 5
    Duplicate queries: #12  #15  #16  #17

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.09 ms
    init	0.07 ms
    optimizing	0.05 ms
    statistics	0.13 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.15 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 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/sessionoptimiser.php:35
    10	AtsystemFeatureSessionoptimiser->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:668
    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: 2.22 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 2.581 MB Rows returned: 5
    Duplicate queries: #12  #14  #16  #17

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

    Explain

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

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.05 ms
    statistics	0.14 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.15 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    updating status	0.11 ms
    cleaning up	0.05 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/cachecleaner.php:37
    10	AtsystemFeatureCachecleaner->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:668
    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: 1.95 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 2.588 MB Rows returned: 5
    Duplicate queries: #12  #14  #15  #17

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.05 ms
    statistics	0.13 ms
    preparing	0.06 ms
    executing	0.06 ms
    Sending data	0.20 ms
    end	0.05 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 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/cacheexpire.php:36
    10	AtsystemFeatureCacheexpire->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:668
    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: 1.91 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 2.597 MB Rows returned: 5
    Duplicate queries: #12  #14  #15  #16

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.05 ms
    statistics	0.13 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.19 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 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/cleantemp.php:37
    10	AtsystemFeatureCleantemp->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:668
    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: 1.96 ms After last query: 5.59 ms Query memory: 0.023 MB Memory before query: 2.908 MB Rows returned: 38

    SELECT *
    
      FROM jdcfn_rsform_config

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.08 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.04 ms
    Sending data	0.25 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
    11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
    9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26
    8	plgSystemRsformdeletesubmissions->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:668
    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: 3.99 ms After last query: 2.01 ms Query memory: 0.048 MB Memory before query: 3.025 MB Rows returned: 26

    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 jdcfn_menu AS m
    
      LEFT JOIN jdcfn_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	32	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	zeolite.m.component_id	1	Using where

    Profile

    Status	Duration
    starting	0.20 ms
    checking permissions	0.09 ms
    checking permissions	0.05 ms
    Opening tables	0.07 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.11 ms
    optimizing	0.08 ms
    statistics	0.15 ms
    preparing	0.10 ms
    executing	0.04 ms
    Sorting result	0.64 ms
    Sending data	1.09 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.08 ms
    freeing items	0.05 ms
    updating status	0.05 ms
    cleaning up	0.23 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 12.18 ms After last query: 5.03 ms Query memory: 0.047 MB Memory before query: 3.387 MB Rows returned: 140

    SHOW FULL COLUMNS 
      FROM `jdcfn_jshopping_config`

    Explain

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

    Profile

    Status	Duration
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.09 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.09 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.11 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.11 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.09 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    closing tables	0.05 ms
    executing	0.04 ms
    Sending data	0.72 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.04 ms
    removing tmp table	0.32 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.14 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:14
    15	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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: 2.96 ms After last query: 1.05 ms Query memory: 0.103 MB Memory before query: 3.590 MB Rows returned: 1

    SELECT *
    
      FROM jdcfn_jshopping_config
    
      WHERE `id` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_jshopping_config	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.23 ms
    optimizing	0.10 ms
    statistics	0.28 ms
    preparing	0.11 ms
    executing	0.05 ms
    Sending data	0.50 ms
    end	0.05 ms
    query end	0.06 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    updating status	0.08 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:30
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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: 3.54 ms After last query: 0.63 ms Query memory: 0.027 MB Memory before query: 3.588 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `jdcfn_jshopping_currencies`

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.63 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.04 ms
    Filling schema table	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    checking permissions	0.09 ms
    checking permissions	0.23 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    closing tables	0.05 ms
    executing	0.04 ms
    Sending data	0.14 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.04 ms
    removing tmp table	0.31 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
    19	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:328
    18	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:548
    16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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: 2.12 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 3.607 MB Rows returned: 1

    SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
      FROM `jdcfn_jshopping_currencies` 
      WHERE currency_publish = '1' 
      ORDER BY currency_ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_jshopping_currencies	ref	currency_publish	currency_publish	1	const	1	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.06 ms
    statistics	0.13 ms
    preparing	0.07 ms
    executing	0.09 ms
    Sorting result	0.14 ms
    Sending data	0.10 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
    17	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:549
    16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1546
    11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:210
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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: 2.06 ms After last query: 0.58 ms Query memory: 0.023 MB Memory before query: 3.616 MB Rows returned: 15

    select product_id as id, `alias_en-GB` as alias 
      from jdcfn_jshopping_products 
      where `alias_en-GB`!=''

    Explain

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

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.08 ms
    optimizing	0.06 ms
    statistics	0.07 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.20 ms
    end	0.05 ms
    query end	0.08 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.10 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:276
    14	JSFactory::getAliasProduct()	JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:42
    13	plgJshoppingRouterJshopping_product_seo->onBeforeParseRoute()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/router.php:216
    10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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: 2.45 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 3.628 MB Rows returned: 1

    SELECT *
    
      FROM `jdcfn_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_jshopping') 
      AND `view` IN('') 
      AND `task` IN('','view','.view') 
      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	jdcfn_admintools_wafblacklists	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using temporary; Using filesort

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.11 ms
    optimizing	0.08 ms
    statistics	0.11 ms
    preparing	0.07 ms
    executing	0.04 ms
    Creating tmp table	0.13 ms
    Copying to tmp table	0.16 ms
    Sorting result	0.07 ms
    Sending data	0.08 ms
    end	0.04 ms
    removing tmp table	0.05 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.15 ms
    cleaning up	0.05 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:1190
    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: 2.46 ms After last query: 0.95 ms Query memory: 0.022 MB Memory before query: 3.638 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	zeolite.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.07 ms
    After opening tables	0.09 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.09 ms
    optimizing	0.09 ms
    statistics	0.23 ms
    preparing	0.09 ms
    executing	0.04 ms
    Sending data	0.31 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
    10	jsn_template_framework_class_loader()	Same as call in the line below.
    9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
    8	PlgSystemJSNTPLFramework->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:1190
    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: 1.96 ms After last query: 0.49 ms Query memory: 0.022 MB Memory before query: 3.667 MB Rows returned: 1

    SELECT manifest_cache
    
      FROM jdcfn_extensions
    
      WHERE element LIKE 'jsn_time_pro'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	Using index condition

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.11 ms
    optimizing	0.05 ms
    statistics	0.16 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.14 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
    12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
    11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
    10	jsn_template_framework_class_loader()	Same as call in the line below.
    9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
    8	PlgSystemJSNTPLFramework->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:1190
    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: 2.08 ms After last query: 4.43 ms Query memory: 0.021 MB Memory before query: 3.755 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM jdcfn_extensions
    
      WHERE type = 'component' 
      AND element = 'com_sh404sef'

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.06 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.07 ms
    statistics	0.20 ms
    preparing	0.07 ms
    executing	0.05 ms
    Sending data	0.15 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
    10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
    9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
    8	PlgSystemJSNTPLFramework->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:1190
    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.]

    ---

29. Query Time: 2.00 ms After last query: 0.42 ms Query memory: 0.022 MB Memory before query: 3.781 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.11 ms
    statistics	0.21 ms
    preparing	0.07 ms
    executing	0.04 ms
    Sending data	0.14 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 2.07 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 3.771 MB

    UPDATE `jdcfn_extensions`
    
      SET `params` = '{\"mediaversion\":\"09294d11eeb116ca3ed5f4d6389e07cf\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.05 ms
    Opening tables	0.10 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.22 ms
    Updating	0.19 ms
    end	0.05 ms
    Waiting for query cache lock	0.04 ms
    end	0.05 ms
    query end	0.14 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    updating status	0.15 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 2.00 ms After last query: 0.69 ms Query memory: 0.019 MB Memory before query: 3.795 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.09 ms
    optimizing	0.10 ms
    statistics	0.06 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sorting result	0.10 ms
    Sending data	0.14 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 1.79 ms After last query: 2.39 ms Query memory: 0.021 MB Memory before query: 3.825 MB Rows returned: 1

    select * 
      from jdcfn_jshopping_languages

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.09 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.06 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.04 ms
    Sending data	0.11 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.10 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:281
    8	installNewLanguages()	JROOT/components/com_jshopping/loadparams.php:32
    7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
    6	require_once JROOT/components/com_jshopping/jshopping.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.]

    ---

33. Query Time: 3.38 ms After last query: 18.44 ms Query memory: 0.026 MB Memory before query: 3.977 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `jdcfn_jshopping_config_seo`

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.05 ms
    Opening tables	0.57 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.18 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.04 ms
    Filling schema table	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    checking permissions	0.10 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    closing tables	0.05 ms
    executing	0.08 ms
    Sending data	0.14 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.04 ms
    removing tmp table	0.27 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/seo.php:14
    12	jshopSeo->__construct()	JROOT/libraries/src/Table/Table.php:328
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    10	JSFactory::getTable()	JROOT/components/com_jshopping/helpers/metadata.php:47
    9	JshopHelpersMetadata::cart()	JROOT/components/com_jshopping/controllers/cart.php:82
    8	JshoppingControllerCart->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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.]

    ---

34. Query Time: 2.00 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.994 MB Rows returned: 1

    SELECT id, alias, `title_en-GB` as title, `keyword_en-GB` as keyword, `description_en-GB` as description 
      FROM `jdcfn_jshopping_config_seo` 
      where alias='cart'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_jshopping_config_seo	ref	alias	alias	194	const	1	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_jshopping/tables/seo.php:22
    10	jshopSeo->loadData()	JROOT/components/com_jshopping/helpers/metadata.php:48
    9	JshopHelpersMetadata::cart()	JROOT/components/com_jshopping/controllers/cart.php:82
    8	JshoppingControllerCart->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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.]

    ---

35. Query Time: 2.82 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 4.001 MB Rows returned: 6

    select id,link 
      from jdcfn_menu 
      where `type`='component' 
      and published=1 
      and link like '%option=com_jshopping%' 
      and client_id=0 
      and (language='*' or language='en-GB') 
      and access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	33	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.05 ms
    Opening tables	0.10 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.10 ms
    optimizing	0.09 ms
    statistics	0.21 ms
    preparing	0.09 ms
    executing	0.04 ms
    Sending data	0.79 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:130
    14	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
    13	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
    12	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:387
    11	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:379
    10	getThisURLMainPageShop()	JROOT/components/com_jshopping/helpers/metadata.php:49
    9	JshopHelpersMetadata::cart()	JROOT/components/com_jshopping/controllers/cart.php:82
    8	JshoppingControllerCart->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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.]

    ---

36. Query Time: 3.39 ms After last query: 20.25 ms Query memory: 0.025 MB Memory before query: 4.191 MB Rows returned: 4

    SHOW FULL COLUMNS 
      FROM `jdcfn_jshopping_config_statictext`

    Explain

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

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.05 ms
    Opening tables	0.57 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.17 ms
    preparing	0.05 ms
    executing	0.04 ms
    Filling schema table	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    checking permissions	0.10 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    closing tables	0.05 ms
    executing	0.04 ms
    Sending data	0.13 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.08 ms
    removing tmp table	0.27 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/statictext.php:15
    12	jshopStaticText->__construct()	JROOT/libraries/src/Table/Table.php:328
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
    10	JSFactory::getTable()	JROOT/components/com_jshopping/models/cartpreview.php:67
    9	jshopCartPreview->getCartStaticText()	JROOT/components/com_jshopping/controllers/cart.php:91
    8	JshoppingControllerCart->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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.]

    ---

37. Query Time: 1.91 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 4.204 MB Rows returned: 1

    SELECT id, alias, `text_en-GB` as text 
      FROM `jdcfn_jshopping_config_statictext` 
      where alias='cart'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_jshopping_config_statictext	ref	alias	alias	194	const	1	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_jshopping/tables/statictext.php:23
    10	jshopStaticText->loadData()	JROOT/components/com_jshopping/models/cartpreview.php:68
    9	jshopCartPreview->getCartStaticText()	JROOT/components/com_jshopping/controllers/cart.php:91
    8	JshoppingControllerCart->view()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
    6	require_once JROOT/components/com_jshopping/jshopping.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.]

    ---

38. Query Time: 5.10 ms After last query: 52.36 ms Query memory: 0.025 MB Memory before query: 4.621 MB Rows returned: 14

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jdcfn_modules AS m
    
      LEFT JOIN jdcfn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jdcfn_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-01-22 17:53:45') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-01-22 17:53:45') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 144 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	29	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	zeolite.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	zeolite.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.26 ms
    checking permissions	0.05 ms
    checking permissions	0.08 ms
    checking permissions	0.04 ms
    Opening tables	0.08 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.14 ms
    optimizing	0.14 ms
    statistics	0.23 ms
    preparing	0.20 ms
    executing	0.05 ms
    Sorting result	0.61 ms
    Sending data	1.48 ms
    end	0.05 ms
    query end	0.05 ms
    closing tables	0.06 ms
    freeing items	0.06 ms
    updating status	0.14 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
    13	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
    12	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
    11	JModuleHelper::getModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:168
    10	JSNTplUtils->countModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:498
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_time_pro/index.php:18
    7	require JROOT/templates/jsn_time_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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: 2.63 ms After last query: 2.63 ms Query memory: 0.023 MB Memory before query: 4.674 MB Rows returned: 0

    SELECT m.id
    
      FROM jdcfn_modules AS m
    
      INNER JOIN jdcfn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_k2_%' 
      AND (mm.menuid < 0 
      AND mm.menuid = -144) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-full", "promo-
      left", "promo", "promo-right", "content-top", "content-top-below", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-mid", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	38	Using where
    1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	zeolite.m.id,const	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.24 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.28 ms
    optimizing	0.12 ms
    statistics	0.19 ms
    preparing	0.11 ms
    executing	0.04 ms
    Sending data	0.31 ms
    end	0.05 ms
    query end	0.09 ms
    closing tables	0.06 ms
    freeing items	0.06 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:737
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
    12	JSNTplUtils->checkK2()	JROOT/templates/jsn_time_pro/template_custom.php:23
    11	include_once JROOT/templates/jsn_time_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_time_pro/index.php:18
    7	require JROOT/templates/jsn_time_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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: 3.02 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 4.682 MB Rows returned: 0

    SELECT m.id
    
      FROM jdcfn_modules AS m
    
      INNER JOIN jdcfn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_k2_%' 
      AND (mm.menuid = 144 OR mm.menuid = 0 OR (mm.menuid < 0 
      AND mm.menuid != -144)) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-full", "promo-
      left", "promo", "promo-right", "content-top", "content-top-below", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-mid", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
    
      GROUP BY m.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	38	Using where; Using temporary; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	zeolite.m.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.25 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.23 ms
    optimizing	0.17 ms
    statistics	0.22 ms
    preparing	0.13 ms
    executing	0.04 ms
    Creating tmp table	0.09 ms
    Copying to tmp table	0.30 ms
    Sorting result	0.11 ms
    Sending data	0.06 ms
    end	0.04 ms
    removing tmp table	0.05 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:758
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
    12	JSNTplUtils->checkK2()	JROOT/templates/jsn_time_pro/template_custom.php:23
    11	include_once JROOT/templates/jsn_time_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_time_pro/index.php:18
    7	require JROOT/templates/jsn_time_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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: 2.61 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 4.689 MB Rows returned: 0

    SELECT m.id
    
      FROM jdcfn_modules AS m
    
      INNER JOIN jdcfn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_virtuemart_%' 
      AND (mm.menuid < 0 
      AND mm.menuid = -144) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-full", "promo-
      left", "promo", "promo-right", "content-top", "content-top-below", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-mid", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	38	Using where
    1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	zeolite.m.id,const	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.23 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.05 ms
    init	0.27 ms
    optimizing	0.11 ms
    statistics	0.18 ms
    preparing	0.11 ms
    executing	0.04 ms
    Sending data	0.29 ms
    end	0.05 ms
    query end	0.08 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:737
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:787
    12	JSNTplUtils->checkVM()	JROOT/templates/jsn_time_pro/template_custom.php:29
    11	include_once JROOT/templates/jsn_time_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_time_pro/index.php:18
    7	require JROOT/templates/jsn_time_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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: 3.00 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 4.698 MB Rows returned: 0

    SELECT m.id
    
      FROM jdcfn_modules AS m
    
      INNER JOIN jdcfn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_virtuemart_%' 
      AND (mm.menuid = 144 OR mm.menuid = 0 OR (mm.menuid < 0 
      AND mm.menuid != -144)) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-full", "promo-
      left", "promo", "promo-right", "content-top", "content-top-below", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-mid", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
    
      GROUP BY m.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	38	Using where; Using temporary; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	zeolite.m.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.25 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.23 ms
    optimizing	0.17 ms
    statistics	0.22 ms
    preparing	0.13 ms
    executing	0.04 ms
    Creating tmp table	0.08 ms
    Copying to tmp table	0.30 ms
    Sorting result	0.06 ms
    Sending data	0.05 ms
    end	0.09 ms
    removing tmp table	0.05 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:758
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:787
    12	JSNTplUtils->checkVM()	JROOT/templates/jsn_time_pro/template_custom.php:29
    11	include_once JROOT/templates/jsn_time_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_time_pro/index.php:18
    7	require JROOT/templates/jsn_time_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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: 4.24 ms After last query: 4.09 ms Query memory: 0.027 MB Memory before query: 4.744 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `jdcfn_jshopping_categories`

    Explain

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.57 ms
    After opening tables	0.05 ms
    System lock	0.16 ms
    Table lock	0.04 ms
    After table lock	0.05 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.04 ms
    Filling schema table	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.05 ms
    checking permissions	0.10 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.10 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    closing tables	0.05 ms
    executing	0.04 ms
    Sending data	0.22 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.04 ms
    removing tmp table	0.28 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
    12	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:39
    10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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: 2.41 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 4.774 MB Rows returned: 5

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `jdcfn_jshopping_categories`
                       
      WHERE category_parent_id = '0'  
      AND category_publish = '1'  
      AND access IN (1,1,5)
                       
      ORDER BY ordering asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_jshopping_categories	ALL	category_parent_id,category_publish,access,category_publish_2	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.05 ms
    System lock	0.09 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.09 ms
    optimizing	0.07 ms
    statistics	0.22 ms
    preparing	0.07 ms
    executing	0.04 ms
    Sorting result	0.15 ms
    Sending data	0.19 ms
    end	0.09 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/category.php:34
    14	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:123
    13	jshopCategory->getSisterCategories()	JROOT/modules/mod_jshopping_categories/helper.php:36
    12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
    11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
    10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

45. Query Time: 1.81 ms After last query: 0.35 ms Query memory: 0.028 MB Memory before query: 4.788 MB Rows returned: 12

    select category_id as id, `alias_en-GB` as alias 
      from jdcfn_jshopping_categories 
      where `alias_en-GB`!=''

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:242
    24	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:58
    23	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_jshopping/lib/functions.php:479
    15	SEFLink()	JROOT/components/com_jshopping/tables/category.php:36
    14	jshopCategory->getSubCategories()	JROOT/components/com_jshopping/tables/category.php:123
    13	jshopCategory->getSisterCategories()	JROOT/modules/mod_jshopping_categories/helper.php:36
    12	jShopCategoriesHelper::getTreeCats()	JROOT/modules/mod_jshopping_categories/helper.php:47
    11	jShopCategoriesHelper::getCatsArray()	JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php:42
    10	include JROOT/modules/mod_jshopping_categories/mod_jshopping_categories.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

46. Query Time: 4.12 ms After last query: 2.89 ms Query memory: 0.029 MB Memory before query: 4.834 MB Rows returned: 34

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jdcfn_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_installer','com_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_wrapper')

    Explain

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

    Profile

    Status	Duration
    starting	0.20 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.24 ms
    optimizing	0.12 ms
    statistics	0.52 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	1.52 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
    15	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

47. Query Time: 6.42 ms After last query: 0.64 ms Query memory: 0.025 MB Memory before query: 4.953 MB Rows returned: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM jdcfn_content AS a
    
      LEFT JOIN jdcfn_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jdcfn_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jdcfn_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jdcfn_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jdcfn_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (14) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-22 17:53:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-22 17:53:45')
    
      ORDER BY  RAND()  ASC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; Using filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	9	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	zeolite.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	zeolite.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	zeolite.a.id	1	Using where

    Profile

    Status	Duration
    starting	0.56 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.10 ms
    After opening tables	0.05 ms
    System lock	0.05 ms
    Table lock	0.08 ms
    After table lock	0.05 ms
    init	0.28 ms
    optimizing	0.17 ms
    statistics	0.38 ms
    preparing	0.20 ms
    executing	0.05 ms
    Creating tmp table	0.91 ms
    Copying to tmp table	1.17 ms
    Sorting result	0.17 ms
    Sending data	0.21 ms
    end	0.06 ms
    removing tmp table	0.31 ms
    end	0.10 ms
    query end	0.06 ms
    closing tables	0.08 ms
    freeing items	0.08 ms
    updating status	0.13 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

48. Query Time: 3.12 ms After last query: 0.90 ms Query memory: 0.028 MB Memory before query: 4.981 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jdcfn_categories` AS `s`
    
      INNER JOIN `jdcfn_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 14
    
      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	Using filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	19	Using where

    Profile

    Status	Duration
    starting	0.32 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.07 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.21 ms
    optimizing	0.12 ms
    statistics	0.37 ms
    preparing	0.10 ms
    executing	0.04 ms
    Sorting result	0.20 ms
    Sending data	0.30 ms
    end	0.05 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    updating status	0.13 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

49. Query Time: 5.35 ms After last query: 1.76 ms Query memory: 0.027 MB Memory before query: 5.035 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 jdcfn_fields AS a
    
      LEFT JOIN `jdcfn_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jdcfn_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jdcfn_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jdcfn_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jdcfn_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.40 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.11 ms
    After opening tables	0.05 ms
    System lock	0.05 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.23 ms
    optimizing	0.14 ms
    statistics	0.37 ms
    preparing	0.14 ms
    executing	0.04 ms
    Creating tmp table	0.86 ms
    Copying to tmp table	0.14 ms
    Sorting result	0.07 ms
    Sending data	0.15 ms
    end	0.10 ms
    removing tmp table	0.26 ms
    end	0.05 ms
    query end	0.05 ms
    closing tables	0.06 ms
    freeing items	0.06 ms
    updating status	0.13 ms
    cleaning up	0.05 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:194
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:123
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

50. Query Time: 4.70 ms After last query: 1.37 ms Query memory: 0.026 MB Memory before query: 5.049 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 jdcfn_fields AS a
    
      LEFT JOIN `jdcfn_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jdcfn_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jdcfn_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jdcfn_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jdcfn_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jdcfn_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (14,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.41 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.11 ms
    After opening tables	0.05 ms
    System lock	0.05 ms
    Table lock	0.04 ms
    After table lock	0.05 ms
    init	0.24 ms
    optimizing	0.15 ms
    statistics	0.38 ms
    preparing	0.16 ms
    executing	0.04 ms
    Creating tmp table	0.83 ms
    Copying to tmp table	0.14 ms
    Sorting result	0.07 ms
    Sending data	0.14 ms
    end	0.10 ms
    removing tmp table	0.25 ms
    end	0.05 ms
    query end	0.05 ms
    closing tables	0.07 ms
    freeing items	0.07 ms
    updating status	0.12 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

51. Query Time: 1.97 ms After last query: 7.68 ms Query memory: 0.023 MB Memory before query: 5.404 MB Rows returned: 2

    SELECT lft, rgt
    
      FROM jdcfn_menu
    
      WHERE id = 150 OR id = 139

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_time_pro/html/mod_menu/default.php:61
    11	require JROOT/templates/jsn_time_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

52. Query Time: 1.87 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 5.411 MB Rows returned: 2

    SELECT lft, rgt
    
      FROM jdcfn_menu
    
      WHERE id = 150 OR id = 147

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_time_pro/html/mod_menu/default.php:61
    11	require JROOT/templates/jsn_time_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

53. Query Time: 2.55 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 5.418 MB Rows returned: 2

    SELECT lft, rgt
    
      FROM jdcfn_menu
    
      WHERE id = 150 OR id = 148

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.07 ms
    optimizing	0.12 ms
    statistics	0.11 ms
    preparing	0.07 ms
    executing	0.04 ms
    Sending data	0.67 ms
    end	0.10 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_time_pro/html/mod_menu/default.php:61
    11	require JROOT/templates/jsn_time_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

54. Query Time: 1.85 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 5.424 MB Rows returned: 2

    SELECT lft, rgt
    
      FROM jdcfn_menu
    
      WHERE id = 150 OR id = 149

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.05 ms
    Opening tables	0.06 ms
    After opening tables	0.04 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.04 ms
    init	0.06 ms
    optimizing	0.06 ms
    statistics	0.10 ms
    preparing	0.06 ms
    executing	0.09 ms
    Sending data	0.12 ms
    end	0.05 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_time_pro/html/mod_menu/default.php:61
    11	require JROOT/templates/jsn_time_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

55. Query Time: 1.84 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 5.431 MB Rows returned: 2

    SELECT lft, rgt
    
      FROM jdcfn_menu
    
      WHERE id = 150 OR id = 151

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jdcfn_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_time_pro/html/mod_menu/default.php:61
    11	require JROOT/templates/jsn_time_pro/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
    9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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.]

    ---

56. Query Time: 2.87 ms After last query: 4527.01 ms Query memory: 0.021 MB Memory before query: 5.475 MB Rows returned: 1

    SELECT `value`
    
      FROM `jdcfn_admintools_storage`
    
      WHERE `key` = 'criticalfiles'

    Explain

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

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.05 ms
    Opening tables	0.07 ms
    After opening tables	0.05 ms
    System lock	0.04 ms
    Table lock	0.04 ms
    After table lock	0.05 ms
    init	0.08 ms
    optimizing	0.07 ms
    statistics	0.23 ms
    preparing	0.07 ms
    executing	0.04 ms
    Sending data	0.07 ms
    end	0.04 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    updating status	0.13 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/admintools/feature/criticalfiles.php:204
    10	AtsystemFeatureCriticalfiles->load()	JROOT/plugins/system/admintools/feature/criticalfiles.php:32
    9	AtsystemFeatureCriticalfiles->onAfterRender()	JROOT/plugins/system/admintools/admintools/main.php:308
    8	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:187
    7	plgSystemAdmintools->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---