{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702226358,
                "last": 1702226358,
                "now": 1702226358
            },
            "token": "uKAWwqftNRdxZ8HyglngoqCXam3YDKNO"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "jd_allowed_create_categories": []
    }
}

Time

Memory

93 پرس و جو ثبت شده 60.84 ms

1. Query Time: 0.27 ms Query memory: 0.024 MB Memory before query: 2.465 MB Rows returned: 0

   SELECT `data`
   
     FROM `azvca_session`
   
     WHERE `session_id` = '6a366439d63d0d83f5246552e72a51a8'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	azvca_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.13 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

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

   ---

2. Query Time: 0.14 ms After last query: 1.95 ms Query memory: 0.021 MB Memory before query: 2.600 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `azvca_session`
   
     WHERE `session_id` = '6a366439d63d0d83f5246552e72a51a8' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	azvca_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

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

   ---

3. Query Time: 13.41 ms After last query: 0.08 ms Query memory: 0.003 MB Memory before query: 2.605 MB

   INSERT INTO `azvca_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('6a366439d63d0d83f5246552e72a51a8', 0, 1, '1702226358', 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `azvca_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('6a366439d63d0d83f5246552e72a51a8', 0, 1, '1702226358', 0, '')

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.04 ms
   end	0.00 ms
   query end	13.23 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

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

   ---

4. Query Time: 0.48 ms After last query: 2.24 ms Query memory: 0.059 MB Memory before query: 2.768 MB Rows returned: 54

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `azvca_extensions`
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	azvca_extensions	NULL	ref	extension	extension	82	const	54	100.00	NULL

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.13 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.15 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

5. Query Time: 0.36 ms After last query: 1.27 ms Query memory: 0.022 MB Memory before query: 2.998 MB Rows returned: 1

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

6. Query Time: 0.19 ms After last query: 0.54 ms Query memory: 0.022 MB Memory before query: 3.044 MB Rows returned: 3

   SELECT id, rules
   
     FROM `azvca_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

7. Query Time: 0.68 ms After last query: 0.07 ms Query memory: 0.034 MB Memory before query: 3.052 MB Rows returned: 135

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	azvca_extensions	NULL	ref	extension	extension	82	const	201	0.40	Using index condition; Using where; Using filesort

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.47 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

8. Query Time: 0.21 ms After last query: 15.86 ms Query memory: 0.022 MB Memory before query: 5.029 MB Rows returned: 1

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	azvca_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

9. Query Time: 0.22 ms After last query: 7.59 ms Query memory: 0.025 MB Memory before query: 5.824 MB Rows returned: 1

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	azvca_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   15	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
   14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   13	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   8	JFactory::getDocument()	JROOT/plugins/system/wishlists/wishlists.php:23
   7	plgSystemWishlists->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

10. Query Time: 12.39 ms After last query: 0.12 ms Query memory: 0.006 MB Memory before query: 5.815 MB

    UPDATE `azvca_extensions`
    
      SET `params` = '{\"mediaversion\":\"216feae7d3521bdaa744c5d9ace62589\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	azvca_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.04 ms
    updating	0.04 ms
    end	0.01 ms
    query end	12.15 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    8	JFactory::getDocument()	JROOT/plugins/system/wishlists/wishlists.php:23
    7	plgSystemWishlists->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

11. Query Time: 0.26 ms After last query: 46.76 ms Query memory: 0.023 MB Memory before query: 8.520 MB Rows returned: 1

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'pro_plugin'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:111
    10	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:76
    9	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1312
    8	plgSystemSecuritycheckpro->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

12. Query Time: 0.20 ms After last query: 0.08 ms Query memory: 0.005 MB Memory before query: 8.524 MB

    DELETE 
      from `azvca_securitycheckpro_users_control` 
      WHERE id='1'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	DELETE	azvca_securitycheckpro_users_control	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    updating	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1849
    9	plgSystemSecuritycheckpro->forbid_new_admins()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1333
    8	plgSystemSecuritycheckpro->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

13. Query Time: 0.13 ms After last query: 0.93 ms Query memory: 0.023 MB Memory before query: 8.642 MB Rows returned: 0

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'geoblock'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:73
    10	SecuritycheckprosModelGeoblock->load()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:38
    9	SecuritycheckprosModelGeoblock->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1343
    8	plgSystemSecuritycheckpro->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

14. Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.005 MB Memory before query: 8.646 MB

    DELETE 
      FROM `azvca_securitycheckpro_dynamic_blacklist` 
      WHERE (DATE_ADD(`timeattempt`, INTERVAL 600 SECOND)) < NOW();

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	DELETE	azvca_securitycheckpro_dynamic_blacklist	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	100.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    updating	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:666
    10	plgSystemSecuritycheckpro->pasar_a_historico()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:701
    9	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1403
    8	plgSystemSecuritycheckpro->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

15. Query Time: 0.12 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 8.651 MB Rows returned: 1

    SELECT COUNT(*) 
      from `azvca_securitycheckpro_dynamic_blacklist` 
      WHERE (`ip` = '18.205.26.39' 
      AND `counter` >= 5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:641
    10	plgSystemSecuritycheckpro->chequear_ip_en_lista_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:703
    9	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1403
    8	plgSystemSecuritycheckpro->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

16. Query Time: 0.14 ms After last query: 2.37 ms Query memory: 0.023 MB Memory before query: 8.888 MB Rows returned: 1
    Duplicate queries: #20

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'filemanager_resume'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199
    10	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    9	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

17. Query Time: 0.14 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.896 MB Rows returned: 1
    Duplicate queries: #21

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'fileintegrity_resume'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207
    10	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    9	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

18. Query Time: 0.14 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.903 MB Rows returned: 1
    Duplicate queries: #22

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'malwarescan_resume'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215
    10	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    9	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

19. Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.907 MB Rows returned: 0

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'cron_plugin'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:111
    10	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:76
    9	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:160
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

20. Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.915 MB Rows returned: 1
    Duplicate queries: #16

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'filemanager_resume'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199
    11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

21. Query Time: 0.13 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.921 MB Rows returned: 1
    Duplicate queries: #17

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'fileintegrity_resume'

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207
    11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

22. Query Time: 0.12 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.928 MB Rows returned: 1
    Duplicate queries: #18

    SELECT `storage_value`
    
      FROM `azvca_securitycheckpro_storage`
    
      WHERE `storage_key` = 'malwarescan_resume'

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215
    11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

23. Query Time: 0.15 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 8.932 MB Rows returned: 1

    SELECT `last_task`
    
      FROM `azvca_securitycheckpro_file_manager`

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_securitycheckpro_file_manager	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

24. Query Time: 0.08 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 8.937 MB Rows returned: 1

    SELECT `last_check`
    
      FROM `azvca_securitycheckpro_file_manager`

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_securitycheckpro_file_manager	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:123
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

25. Query Time: 1.07 ms After last query: 0.08 ms Query memory: 0.041 MB Memory before query: 8.936 MB Rows returned: 352
    Duplicate queries: #29  #93

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    checking permissions	0.82 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

26. Query Time: 0.32 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 8.981 MB Rows returned: 0

    SELECT file_id 
      from azvca_jdownloads_files 
      WHERE published = 1 
      AND use_timeframe = 1 
      AND publish_to != '0000-00-00 00:00:00' 
      AND publish_to <= '2023-12-10 16:39:18'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_jdownloads_files	NULL	ALL	idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	16	6.25	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

27. Query Time: 0.12 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 8.986 MB Rows returned: 0

    SELECT file_id 
      from azvca_jdownloads_files 
      WHERE published = 0 
      AND use_timeframe = 1 
      AND publish_from != '0000-00-00 00:00:00' 
      AND publish_from <= '2023-12-10 16:39:18'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_jdownloads_files	NULL	ref	idx_published	idx_published	1	const	1	6.25	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

28. Query Time: 0.90 ms After last query: 30.01 ms Query memory: 0.058 MB Memory before query: 10.684 MB Rows returned: 64

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	104	3.33	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	boardsca_newdb.m.component_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.16 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.43 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

29. Query Time: 1.13 ms After last query: 20.86 ms Query memory: 0.041 MB Memory before query: 13.347 MB Rows returned: 352
    Duplicate queries: #25  #93

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    checking permissions	0.82 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
    8	plgSystemjdownloads->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

30. Query Time: 0.41 ms After last query: 0.21 ms Query memory: 0.056 MB Memory before query: 13.356 MB Rows returned: 12

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	boardsca_newdb.e.element	6	10.00	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    10	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

31. Query Time: 0.29 ms After last query: 9.56 ms Query memory: 0.028 MB Memory before query: 14.041 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    12	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    11	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:315
    10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
    9	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

32. Query Time: 0.54 ms After last query: 10.49 ms Query memory: 0.086 MB Memory before query: 15.060 MB Rows returned: 268

    SELECT setting_name, setting_value 
      FROM azvca_jdownloads_config

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_jdownloads_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	268	100.00	NULL

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.14 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.26 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:37
    7	JDHelper::buildjlistConfig()	JROOT/components/com_jdownloads/jdownloads.php:28
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

33. Query Time: 1.22 ms After last query: 7.96 ms Query memory: 0.026 MB Memory before query: 15.424 MB Rows returned: 9
    Duplicate queries: #63

    SELECT group_id, importance, id
    
      FROM azvca_jdownloads_usergroups_limits
    
      ORDER BY importance

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.50 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.54 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    12	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:89
    11	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/categories/view.html.php:40
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

34. Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.074 MB Memory before query: 15.436 MB Rows returned: 1
    Duplicate queries: #64

    SELECT * 
      FROM azvca_jdownloads_usergroups_limits 
      WHERE group_id IN (1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_jdownloads_usergroups_limits	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:113
    11	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/categories/view.html.php:40
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

35. Query Time: 0.08 ms After last query: 0.59 ms Query memory: 0.007 MB Memory before query: 15.535 MB

    
      SET SESSION SQL_BIG_SELECTS = 1

    Explain

    EXPLAIN not possible on query: SET SESSION SQL_BIG_SELECTS = 1

    Profile

    Status	Duration
    starting	0.02 ms
    Opening tables	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/components/com_jdownloads/helpers/categories.php:217
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

36. Query Time: 4.84 ms After last query: 0.08 ms Query memory: 0.044 MB Memory before query: 15.549 MB Rows returned: 8

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid
    
      FROM azvca_jdownloads_categories as c
    
      LEFT JOIN `azvca_jdownloads_files` AS files 
      ON files.`cat_id` = c.id 
      AND files.published = 1
    
      LEFT JOIN azvca_users AS u 
      on u.id = files.created_id
    
      LEFT JOIN azvca_users AS u2 
      on u2.id = files.modified_id
    
      LEFT JOIN (SELECT id, link, access, published 
      from azvca_menu 
      GROUP BY link) AS menu 
      on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id) 
      AND menu.published = 1 
      AND menu.access IN (1,1)
    
      WHERE c.access IN (1,1) 
      AND c.published = 1
    
      GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots,
                           c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id
    
      ORDER BY c.lft ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where; Using temporary; Using filesort
    1	PRIMARY	files	NULL	ref	idx_cat_id,idx_published	idx_cat_id	4	boardsca_newdb.c.id	2	100.00	Using where
    1	PRIMARY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	boardsca_newdb.files.created_id	1	100.00	NULL
    1	PRIMARY	u2	NULL	eq_ref	PRIMARY	PRIMARY	4	boardsca_newdb.files.modified_id	1	100.00	NULL
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	209	100.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	azvca_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	209	100.00	Using temporary; Using filesort

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.38 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    statistics	0.40 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.47 ms
    executing	0.00 ms
    Sending data	0.31 ms
    Creating sort index	2.73 ms
    Creating sort index	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/categories.php:329
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

37. Query Time: 0.30 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 15.626 MB Rows returned: 4

    SELECT cat.id
    
      FROM azvca_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 1 
      AND 8 
      AND cat.published = 1 
      AND cat.access IN (1,1)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	index	idx_access,idx_left_right	PRIMARY	4	NULL	8	12.50	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:365
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

38. Query Time: 0.32 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 15.633 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM azvca_jdownloads_files as files
    
      WHERE files.cat_id IN (2,6,7,8) 
      AND files.published = 1 
      AND files.access IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	files	NULL	ALL	idx_cat_id,idx_access,idx_published	NO INDEX KEY COULD BE USED	NULL	NULL	16	75.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.18 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:381
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

39. Query Time: 0.19 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 15.641 MB Rows returned: 1

    SELECT cat.id
    
      FROM azvca_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 2 
      AND 3 
      AND cat.published = 1 
      AND cat.access IN (1,1)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	12.50	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:365
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

40. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 15.647 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM azvca_jdownloads_files as files
    
      WHERE files.cat_id IN (6) 
      AND files.published = 1 
      AND files.access IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	files	NULL	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	1	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:381
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

41. Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 15.655 MB Rows returned: 1

    SELECT cat.id
    
      FROM azvca_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 4 
      AND 5 
      AND cat.published = 1 
      AND cat.access IN (1,1)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	12.50	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:365
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

42. Query Time: 0.13 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 15.662 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM azvca_jdownloads_files as files
    
      WHERE files.cat_id IN (7) 
      AND files.published = 1 
      AND files.access IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	files	NULL	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	5	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:381
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

43. Query Time: 0.18 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 15.670 MB Rows returned: 1

    SELECT cat.id
    
      FROM azvca_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 6 
      AND 7 
      AND cat.published = 1 
      AND cat.access IN (1,1)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	12.50	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:365
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

44. Query Time: 0.16 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 15.677 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM azvca_jdownloads_files as files
    
      WHERE files.cat_id IN (8) 
      AND files.published = 1 
      AND files.access IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	files	NULL	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	5	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:381
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

45. Query Time: 0.16 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 15.684 MB Rows returned: 1

    SELECT cat.id
    
      FROM azvca_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 9 
      AND 10 
      AND cat.published = 1 
      AND cat.access IN (1,1)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	12.50	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:365
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:179
    13	JDCategories->get()	JROOT/components/com_jdownloads/models/categories.php:188
    12	JdownloadsModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_jdownloads/views/categories/view.html.php:45
    10	jdownloadsViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_jdownloads/controller.php:75
    8	jdownloadsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

46. Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 15.691 MB Rows returned: 1