Insights for Working Virtually

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1568747439,
                "last": 1568747439,
                "now": 1568747439
            },
            "client": {
                "forwarded": "18.204.2.53"
            },
            "token": "XbNNb3IXf6xmJuW7XjdKet2LrIUMwGS9"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            }
        },
        "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
        }
    },
    "__easycalccheckplus": {
        "redirect_url": null,
        "ecc_loaded": null
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Time

Memory

101 Queries Logged 55.56 ms

1. Query Time: 0.34 ms Query memory: 0.027 MB Memory before query: 3.563 MB Rows returned: 0

   SELECT `data`
   
     FROM `cc9y5_session`
   
     WHERE `session_id` = 'dbms42988jrjj024n38brcelo0'

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.26 ms After last query: 1.68 ms Query memory: 0.023 MB Memory before query: 3.669 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `cc9y5_session`
   
     WHERE `session_id` = 'dbms42988jrjj024n38brcelo0' 
     LIMIT 1

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 3.08 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 3.676 MB

   INSERT INTO `cc9y5_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('dbms42988jrjj024n38brcelo0', 1, 1568747439, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `cc9y5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('dbms42988jrjj024n38brcelo0', 1, 1568747439, 0, '', 0)

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After opening tables	0.00 ms
   init	0.01 ms
   update	0.09 ms
   end	0.01 ms
   query end	2.83 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

4. Query Time: 0.30 ms After last query: 8.17 ms Query memory: 0.025 MB Memory before query: 4.282 MB Rows returned: 11

   SELECT id, rules
   
     FROM `cc9y5_viewlevels`

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

5. Query Time: 0.41 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 4.299 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

   Profile

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

   Call Stack

   #	Caller	File and line number
   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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.32 ms After last query: 7.91 ms Query memory: 0.027 MB Memory before query: 5.111 MB Rows returned: 22

   SELECT `path`
   
     FROM cc9y5_rsfirewall_ignored
   
     WHERE `type`='ignore_folder' OR `type`='ignore_file'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 5.121 MB Rows returned: 0

   SELECT `file`
   
     FROM cc9y5_rsfirewall_hashes
   
     WHERE `type`='protect'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.28 ms After last query: 0.08 ms Query memory: 0.031 MB Memory before query: 5.128 MB Rows returned: 52

   SELECT *
   
     FROM cc9y5_rsfirewall_configuration

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 1.00 ms After last query: 6.07 ms Query memory: 0.032 MB Memory before query: 5.551 MB Rows returned: 10

   SHOW FULL COLUMNS 
     FROM `cc9y5_rsfirewall_logs`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
   11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
   10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
   9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
   8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.49 ms After last query: 10.24 ms Query memory: 0.026 MB Memory before query: 6.367 MB Rows returned: 0
    Duplicate queries: #11

    SELECT `manifest_cache`
    
      FROM `cc9y5_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_admintools'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
    12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
    11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
    10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
    9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:818
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.42 ms After last query: 6.16 ms Query memory: 0.026 MB Memory before query: 6.670 MB Rows returned: 0
    Duplicate queries: #10

    SELECT `manifest_cache`
    
      FROM `cc9y5_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_admintools'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
    12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
    11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
    10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
    9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:818
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.22 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 6.689 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc9y5_admintools_storage	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
    12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
    11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
    10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
    9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:836
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.21 ms After last query: 1.65 ms Query memory: 0.026 MB Memory before query: 6.816 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:554
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:465
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:848
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.45 ms After last query: 119.85 ms Query memory: 0.027 MB Memory before query: 30.494 MB Rows returned: 1
    Duplicate queries: #15

    SELECT template
    
      FROM cc9y5_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.27 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 30.504 MB Rows returned: 1
    Duplicate queries: #14

    SELECT template
    
      FROM cc9y5_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.31 ms After last query: 4.91 ms Query memory: 0.025 MB Memory before query: 30.817 MB Rows returned: 2

    SELECT extension, file, type
    
      FROM cc9y5_rokcommon_configs
    
      ORDER BY priority

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.34 ms After last query: 16.14 ms Query memory: 0.024 MB Memory before query: 31.893 MB Rows returned: 1

    SELECT `enabled`
    
      FROM `cc9y5_extensions`
    
      WHERE `element` = 'com_akeeba' 
      AND `type` = 'component'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
    7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
    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:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.62 ms After last query: 21.88 ms Query memory: 0.026 MB Memory before query: 32.707 MB Rows returned: 1

    SHOW VARIABLES LIKE "collation_database"

    Explain

    EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
    11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:715
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    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:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.21 ms After last query: 1.32 ms Query memory: 0.026 MB Memory before query: 32.794 MB Rows returned: 0

    SELECT *
    
      FROM `cc9y5_admintools_ipautoban`
    
      WHERE `ip` = '18.204.2.53'

    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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    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:715
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    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:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.23 ms After last query: 0.85 ms Query memory: 0.025 MB Memory before query: 32.814 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `cc9y5_admintools_redirects`
    
      WHERE ((`dest` = 'insights.html') OR (`dest` = 'insights.html?start=45') OR ('insights.html?start=45' 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	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:715
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    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:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 1.05 ms After last query: 0.59 ms Query memory: 0.033 MB Memory before query: 32.838 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `cc9y5_extensions`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

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

    SELECT `extension_id`
    
      FROM `cc9y5_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.030 MB Memory before query: 32.890 MB Rows returned: 1
    Duplicate queries: #25

    SELECT *
    
      FROM cc9y5_extensions
    
      WHERE `extension_id` = '10179'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.29 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 32.897 MB Rows returned: 1

    SELECT `extension_id`
    
      FROM `cc9y5_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.28 ms After last query: 0.12 ms Query memory: 0.030 MB Memory before query: 32.904 MB Rows returned: 1
    Duplicate queries: #23

    SELECT *
    
      FROM cc9y5_extensions
    
      WHERE `extension_id` = '10179'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.25 ms After last query: 21.58 ms Query memory: 0.024 MB Memory before query: 33.181 MB Rows returned: 1

    SELECT `lastupdate`
    
      FROM `cc9y5_ak_storage`
    
      WHERE `tag` = 'akeebaupdatecheck_lastrun'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc9y5_ak_storage	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:81
    8	plgSystemAkeebaupdatecheck->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.36 ms After last query: 28.25 ms Query memory: 0.025 MB Memory before query: 35.190 MB Rows returned: 0

    SELECT *
    
      FROM cc9y5_rsfirewall_hashes
    
      WHERE (`type`='3.9.11' OR `type`='protect') 
      AND `flag`!='C'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1026
    8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.20 ms After last query: 0.47 ms Query memory: 0.025 MB Memory before query: 35.217 MB Rows returned: 0

    SELECT *
    
      FROM cc9y5_rsfirewall_snapshots
    
      WHERE `type`='protect'

    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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
    9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1049
    8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 35.225 MB Rows returned: 0

    SELECT `ip`,`reason`
    
      FROM cc9y5_rsfirewall_lists
    
      WHERE (`ip`='18.204.2.53' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='1' 
      AND `published`='1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
    9	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1085
    8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 35.232 MB Rows returned: 0

    SELECT `ip`,`reason`
    
      FROM cc9y5_rsfirewall_lists
    
      WHERE (`ip`='18.204.2.53' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='0' 
      AND `published`='1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
    9	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1089
    8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.22 ms After last query: 0.42 ms Query memory: 0.027 MB Memory before query: 35.240 MB Rows returned: 0

    SELECT *
    
      FROM cc9y5_rsfirewall_exceptions
    
      WHERE `published`='1'

    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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:682
    9	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1142
    8	plgSystemRSFirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.39 ms After last query: 0.39 ms Query memory: 0.028 MB Memory before query: 35.248 MB Rows returned: 1

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:87
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:715
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:145
    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:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 1.61 ms After last query: 7.07 ms Query memory: 0.037 MB Memory before query: 35.786 MB Rows returned: 52

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cc9y5_assets`
    
      WHERE `name` IN ('root.1','com_aclmanager','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_fst','com_installer','com_jce','com_jch_optimize','com_jmap','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_roksprocket','com_rsfirewall','com_search','com_slideshowck','com_swmenupro','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:56
    9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
    8	plgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 2.41 ms After last query: 1.59 ms Query memory: 0.009 MB Memory before query: 35.860 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.07 ms
    updating	0.07 ms
    end	0.01 ms
    query end	2.11 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cachecleaner/cachecleaner.php:60
    9	plgSystemCacheCleaner->getHelper()	JROOT/plugins/system/cachecleaner/cachecleaner.php:30
    8	plgSystemCacheCleaner->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.38 ms After last query: 11.09 ms Query memory: 0.107 MB Memory before query: 36.827 MB Rows returned: 2

    SELECT *
    
      FROM cc9y5_easyblog_configs
    
      WHERE `name` = 'config'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:418
    9	EB::config()	JROOT/administrator/components/com_easyblog/includes/utils.php:51
    8	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2979
    7	EB::ajax()	JROOT/components/com_easyblog/easyblog.php:21
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.21 ms After last query: 9.09 ms Query memory: 0.009 MB Memory before query: 37.455 MB

    DELETE 
      FROM `cc9y5_easyblog_mailq` 
      WHERE `status`='1' 
      AND DATEDIFF(NOW(), `created`) >='7'

    Explain

    EXPLAIN not possible on query: DELETE FROM `cc9y5_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.04 ms
    updating	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:39
    10	EasyBlogModelMailer->cleanup()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:38
    9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
    8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.23 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 37.464 MB Rows returned: 0

    SELECT `id` 
      FROM `cc9y5_easyblog_mailq` 
      WHERE `status`='0' 
      ORDER BY `created` ASC 
      LIMIT 5

    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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:65
    10	EasyBlogModelMailer->getPendingEmails()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:41
    9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
    8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.48 ms After last query: 7.18 ms Query memory: 0.040 MB Memory before query: 38.503 MB Rows returned: 0

    SELECT * 
      FROM `cc9y5_easyblog_post` 
      WHERE `publish_up`<='2019-09-17 19:10:39' 
      AND `published`='2' 
      AND `state`='0' 
      ORDER BY `id` 
      LIMIT 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc9y5_easyblog_post	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_blogger_list	1	const	1	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After opening tables	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 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_easyblog/includes/utils.php:235
    11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:271
    10	EasyBlogModelBlogs->getScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:54
    9	EasyBlogScheduler->publish()	JROOT/components/com_easyblog/services/maintenance.php:22
    8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.98 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 38.521 MB

    UPDATE `cc9y5_easyblog_post` 
      SET `published` = '0' 
      WHERE `publish_down` > `publish_up` 
      AND `publish_down` <= '2019-09-17 19:10:39' 
      AND `publish_down` != '0000-00-00 00:00:00' 
      AND `published` = '1' 
      AND `state` = '0'

    Explain

    EXPLAIN not possible on query: UPDATE `cc9y5_easyblog_post` SET `published` = '0' WHERE `publish_down` > `publish_up` AND `publish_down` <= '2019-09-17 19:10:39' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After opening tables	0.00 ms
    init	0.12 ms
    Searching rows for update	0.68 ms
    updating	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:316
    10	EasyBlogModelBlogs->unpublishScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:34
    9	EasyBlogScheduler->unpublish()	JROOT/components/com_easyblog/services/maintenance.php:25
    8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.21 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 38.538 MB Rows returned: 0

    SELECT * 
      FROM `cc9y5_easyblog_uploader_tmp` 
      WHERE `created` <= DATE_SUB('2019-09-17 19:10:39' , INTERVAL 120 MINUTE)

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:95
    9	EasyBlogScheduler->removeTmpFiles()	JROOT/components/com_easyblog/services/maintenance.php:28
    8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.39 ms After last query: 0.17 ms Query memory: 0.008 MB Memory before query: 38.546 MB

    delete a, b 
      from `cc9y5_easyblog_post` as a	
      inner join `cc9y5_easyblog_revisions` as b 
      on a.`id` = b.`post_id` 
      where a.`published` = '9' 
      and a.`created` <= DATE_SUB('2019-09-17 19:10:39', INTERVAL 3 DAY)

    Explain

    EXPLAIN not possible on query: delete a, b from `cc9y5_easyblog_post` as a inner join `cc9y5_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2019-09-17 19:10:39', INTERVAL 3 DAY)

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    11	JDatabase->query()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:132
    9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:32
    8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.94 ms After last query: 0.91 ms Query memory: 0.047 MB Memory before query: 38.623 MB Rows returned: 23

    SELECT * 
      FROM `cc9y5_menu` 
      WHERE `published`='1' 
      AND `link` LIKE 'index.php?option=com_easyblog%'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:235
    13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:61
    12	EasyBlogModelMenu->getAssociatedMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:80
    11	EBR::getMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:365
    10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4277
    9	EB::_()	JROOT/components/com_easyblog/services/weblog.php:27
    8	require_once JROOT/components/com_easyblog/services/weblog.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4229
    7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:33
    6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.58 ms After last query: 1.47 ms Query memory: 0.038 MB Memory before query: 38.736 MB Rows returned: 40