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

Time

Memory

55 پرس و جو ثبت شده 23.68 ms

1. Query Time: 0.27 ms Query memory: 0.018 MB Memory before query: 0.926 MB Rows returned: 0

   SELECT `data`
   
     FROM `azvca_session`
   
     WHERE `session_id` = 'thpuk0d3r165cdph3bpmhjdtt3'

   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.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 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
   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.13 ms After last query: 3.94 ms Query memory: 0.012 MB Memory before query: 0.993 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `azvca_session`
   
     WHERE `session_id` = 'thpuk0d3r165cdph3bpmhjdtt3' 
     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.00 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.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: 3.41 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 1.008 MB

   INSERT INTO `azvca_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('thpuk0d3r165cdph3bpmhjdtt3', 0, 1, '1686106632', 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `azvca_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('thpuk0d3r165cdph3bpmhjdtt3', 0, 1, '1686106632', 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	3.21 ms
   closing tables	0.02 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.30 ms After last query: 3.72 ms Query memory: 0.024 MB Memory before query: 1.067 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.02 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.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.12 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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   8	call_user_func_array()	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.26 ms After last query: 2.45 ms Query memory: 0.015 MB Memory before query: 1.178 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.01 ms
   checking permissions	0.00 ms
   Opening tables	0.06 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.01 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.18 ms After last query: 0.96 ms Query memory: 0.014 MB Memory before query: 1.198 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.02 ms
   checking permissions	0.00 ms
   Opening tables	0.04 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.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
   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.66 ms After last query: 0.10 ms Query memory: 0.016 MB Memory before query: 1.215 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.02 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.42 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
   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.28 ms After last query: 28.49 ms Query memory: 0.013 MB Memory before query: 2.160 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.04 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.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 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: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.27 ms After last query: 14.36 ms Query memory: 0.023 MB Memory before query: 2.506 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.04 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.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 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
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   16	JDatabaseDriver->loadObject()	Same as call in the line below.
   15	call_user_func_array()	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: 2.15 ms After last query: 0.19 ms Query memory: 0.016 MB Memory before query: 2.511 MB

    UPDATE `azvca_extensions`
    
      SET `params` = '{\"mediaversion\":\"13eeabbbbde195ea1fd0753fba969f68\"}'
    
      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.03 ms
    updating	0.04 ms
    end	0.01 ms
    query end	1.90 ms
    closing tables	0.02 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.28 ms After last query: 67.81 ms Query memory: 0.017 MB Memory before query: 3.529 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.06 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:111
    11	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:76
    10	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1312
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.16 ms After last query: 0.15 ms Query memory: 0.013 MB Memory before query: 3.546 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.02 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
    11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1849
    10	plgSystemSecuritycheckpro->forbid_new_admins()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1333
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.14 ms After last query: 2.00 ms Query memory: 0.018 MB Memory before query: 3.603 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:73
    11	SecuritycheckprosModelGeoblock->load()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:38
    10	SecuritycheckprosModelGeoblock->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1343
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.20 ms After last query: 0.08 ms Query memory: 0.014 MB Memory before query: 3.618 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.00 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.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:666
    11	plgSystemSecuritycheckpro->pasar_a_historico()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:701
    10	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1403
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.20 ms After last query: 0.07 ms Query memory: 0.017 MB Memory before query: 3.634 MB Rows returned: 1

    SELECT COUNT(*) 
      from `azvca_securitycheckpro_dynamic_blacklist` 
      WHERE (`ip` = '44.192.79.149' 
      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.03 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:641
    11	plgSystemSecuritycheckpro->chequear_ip_en_lista_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:703
    10	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1403
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.22 ms After last query: 4.47 ms Query memory: 0.017 MB Memory before query: 3.690 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.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.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
    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:152
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.24 ms After last query: 0.11 ms Query memory: 0.017 MB Memory before query: 3.707 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.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.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
    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:152
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.18 ms After last query: 0.11 ms Query memory: 0.017 MB Memory before query: 3.724 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.03 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:215
    11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:152
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.08 ms After last query: 0.09 ms Query memory: 0.017 MB Memory before query: 3.738 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.01 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
    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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:111
    11	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:76
    10	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:160
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.15 ms After last query: 0.13 ms Query memory: 0.018 MB Memory before query: 3.760 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.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:199
    12	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    11	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.14 ms After last query: 0.08 ms Query memory: 0.018 MB Memory before query: 3.778 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.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.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:207
    12	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    11	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.14 ms After last query: 0.07 ms Query memory: 0.018 MB Memory before query: 3.796 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.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.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_securitycheckpro/models/filemanager.php:215
    12	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    11	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.16 ms After last query: 0.07 ms Query memory: 0.016 MB Memory before query: 3.810 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.05 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102
    10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.05 ms Query memory: 0.016 MB Memory before query: 3.825 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:123
    10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.15 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 3.829 MB Rows returned: 352
    Duplicate queries: #29  #55

    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.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.81 ms
    Sending data	0.10 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.28 ms After last query: 0.30 ms Query memory: 0.015 MB Memory before query: 3.911 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-06-07 07:27:12'

    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.04 ms
    checking permissions	0.00 ms
    Opening tables	0.05 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.03 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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.06 ms Query memory: 0.015 MB Memory before query: 3.924 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-06-07 07:27:12'

    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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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.82 ms After last query: 50.86 ms Query memory: 0.035 MB Memory before query: 4.673 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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    Creating sort index	0.36 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.21 ms After last query: 37.01 ms Query memory: 0.022 MB Memory before query: 5.563 MB Rows returned: 352
    Duplicate queries: #25  #55

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 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.83 ms
    Sending data	0.10 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
    9	plgSystemjdownloads->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	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.40 ms After last query: 0.47 ms Query memory: 0.018 MB Memory before query: 5.587 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.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.11 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    11	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
    10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    9	plgSystemT3->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	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: 17.91 ms Query memory: 0.023 MB Memory before query: 5.940 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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.05 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.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:315
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
    10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
    9	plgSystemK2->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	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.47 ms After last query: 55.16 ms Query memory: 0.045 MB Memory before query: 6.780 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `azvca_assets`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    30	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    29	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    28	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    27	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    26	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    25	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    24	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    23	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    22	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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: 0.18 ms After last query: 0.21 ms Query memory: 0.039 MB Memory before query: 6.846 MB Rows returned: 1

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

    Explain

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

    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.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    28	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    27	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    26	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    25	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    24	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    23	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    22	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.16 ms After last query: 0.18 ms Query memory: 0.035 MB Memory before query: 6.879 MB Rows returned: 1

    SELECT a.rules
    
      FROM azvca_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); 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.04 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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    26	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    25	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    24	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    23	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    22	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.25 ms After last query: 1.10 ms Query memory: 0.038 MB Memory before query: 6.926 MB Rows returned: 53

    SELECT element
    
      FROM azvca_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    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	10.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.09 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    28	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    27	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    26	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    25	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    24	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    23	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    22	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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: 0.68 ms After last query: 0.20 ms Query memory: 0.038 MB Memory before query: 6.973 MB Rows returned: 52

    SELECT a.name, a.rules
    
      FROM azvca_assets AS a
    
      WHERE (a.name IN ('com_acymailing','com_admin','com_aimysitemap','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_comparelist','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easydiscuss','com_finder','com_installer','com_jantivirus','com_jce','com_jdownloads','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend_installer','com_opt4wl72','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_securitycheckpro','com_sigpro','com_smartslider2','com_tags','com_templates','com_uniterevolution2','com_universal_ajax_live_search','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_widgetkit','com_wishlists','com_wrapper') OR a.name = 'root.1')

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.29 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    28	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    27	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    26	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    25	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    24	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    23	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    22	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.88 ms After last query: 3.39 ms Query memory: 0.032 MB Memory before query: 7.450 MB Rows returned: 1

    SHOW TABLES LIKE "azvca_virtuemart_configs"

    Explain

    EXPLAIN not possible on query: SHOW TABLES LIKE "azvca_virtuemart_configs"

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 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.69 ms
    Sending data	0.01 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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    23	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:477
    22	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:757
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.21 ms After last query: 0.10 ms Query memory: 0.030 MB Memory before query: 7.481 MB Rows returned: 1

    SELECT `config` 
      FROM `azvca_virtuemart_configs` 
      WHERE `virtuemart_config_id` = "1";

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_virtuemart_configs	NULL	system	PRIMARY	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.05 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:801
    21	VmConfig::loadConfig()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:168
    20	VmTable->setTranslatable()	JROOT/administrator/components/com_virtuemart/tables/products.php:119
    19	TableProducts->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:422
    17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:384
    16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:591
    15	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/product.php:55
    14	VirtueMartModelProduct->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:543
    13	VmModel::getModel()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:79
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.41 ms After last query: 3.80 ms Query memory: 0.032 MB Memory before query: 7.731 MB Rows returned: 1

    SELECT *  
      FROM `azvca_virtuemart_currencies` AS c
    			, `azvca_virtuemart_vendors` AS v
    			
      WHERE v.virtuemart_vendor_id = 1
    			
      AND   v.vendor_currency = c.virtuemart_currency_id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	v	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	2	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.02 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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:269
    15	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:49
    14	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:100
    13	CurrencyDisplay::getInstance()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:113
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.16 ms After last query: 1.82 ms Query memory: 0.029 MB Memory before query: 7.848 MB Rows returned: 1

    SELECT `azvca_virtuemart_currencies`.*  
      FROM `azvca_virtuemart_currencies`  
      WHERE `azvca_virtuemart_currencies`.`virtuemart_currency_id` = "70"

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_virtuemart_currencies	NULL	const	PRIMARY	PRIMARY	2	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.01 ms
    statistics	0.01 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:694
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:913
    14	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:116
    13	CurrencyDisplay::getInstance()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:113
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.32 ms After last query: 4.58 ms Query memory: 0.031 MB Memory before query: 8.049 MB Rows returned: 1

    SELECT * 
      FROM `azvca_virtuemart_shoppergroups` 
      WHERE `default` = "2" 
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
      AND `published`="1"

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	1	50.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.02 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.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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:119
    18	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
    17	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:169
    16	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:120
    15	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:174
    14	CurrencyDisplay->setPriceArray()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:135
    13	CurrencyDisplay::getInstance()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:113
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.22 ms After last query: 0.17 ms Query memory: 0.035 MB Memory before query: 8.113 MB Rows returned: 1

    SELECT `azvca_virtuemart_shoppergroups`.*  
      FROM `azvca_virtuemart_shoppergroups`  
      WHERE `azvca_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

    Explain

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

    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.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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:694
    21	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:913
    20	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    19	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:124
    18	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
    17	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:169
    16	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:120
    15	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:174
    14	CurrencyDisplay->setPriceArray()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:135
    13	CurrencyDisplay::getInstance()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:113
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.40 ms After last query: 1.57 ms Query memory: 0.038 MB Memory before query: 8.170 MB Rows returned: 12

    SELECT * 
      FROM `azvca_menu`  
      where `link` like "index.php?option=com_virtuemart%" 
      and client_id=0 
      and published=1 
      and (language="*" or language = "fa-IR"  )

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	75	0.52	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.19 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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1037
    22	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:737
    21	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:759
    20	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:26
    19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    13	JRoute::_()	JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php:143
    12	include JROOT/templates/t3_bs3_blank/html/com_wishlists/wishlists/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    10	JViewLegacy->display()	JROOT/components/com_wishlists/views/wishlists/view.html.php:26
    9	WishlistsViewWishlists->display()	JROOT/libraries/legacy/controller/legacy.php:664
    8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_wishlists/wishlists.php:15
    6	require_once JROOT/components/com_wishlists/wishlists.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.27 ms After last query: 14.64 ms Query memory: 0.022 MB Memory before query: 8.453 MB Rows returned: 14

    SELECT *
    
      FROM azvca_rsform_config

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.06 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.04 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
    13	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    12	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
    11	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:368
    10	RSFormProHelper::readConfig()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:20
    9	plgSystemRSFPRegistration->canRun()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:629
    8	plgSystemRSFPRegistration->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    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.82 ms After last query: 10.52 ms Query memory: 0.026 MB Memory before query: 8.639 MB Rows returned: 13

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM azvca_modules AS m
    
      LEFT JOIN azvca_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN azvca_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-07 02:57:12') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-07 02:57:12') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 350 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	42	1.60	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	boardsca_newdb.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	boardsca_newdb.m.id	2	40.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
    15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
    14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
    13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:637
    12	T3Template->checkSpotlight()	JROOT/templates/t3_bs3_blank/tpls/blocks/topheader.php:15
    11	include JROOT/templates/t3_bs3_blank/tpls/blocks/topheader.php	JROOT/plugins/system/t3/includes/core/template.php:176
    10	T3Template->loadBlock()	JROOT/templates/t3_bs3_blank/tpls/default.php:70
    9	include JROOT/templates/t3_bs3_blank/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
    8	T3Template->loadLayout()	JROOT/templates/t3_bs3_blank/index.php:34
    7	require JROOT/templates/t3_bs3_blank/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    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.32 ms After last query: 18.44 ms Query memory: 0.023 MB Memory before query: 9.162 MB Rows returned: 119

    SELECT * 
      FROM azvca_acymailing_config

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.06 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.06 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:352
    12	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:753
    11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

47. Query Time: 0.24 ms After last query: 4.42 ms Query memory: 0.022 MB Memory before query: 9.325 MB Rows returned: 1

    SELECT * 
      FROM azvca_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.02 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.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:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:29
    11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:117
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

48. Query Time: 0.28 ms After last query: 5.98 ms Query memory: 0.043 MB Memory before query: 9.490 MB Rows returned: 1

    SELECT `params` 
      FROM `azvca_discuss_configs` 
      WHERE `name`='config'

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.06 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.04 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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    26	JDatabaseDriver->loadResult()	Same as call in the line below.
    25	call_user_func_array()	JROOT/components/com_easydiscuss/helpers/db.php:139
    24	EasyDiscussDbJoomla30->__call()	Same as call in the line below.
    23	EasyDiscussDbJoomla30->loadResult()	Same as call in the line below.
    22	call_user_func_array()	JROOT/components/com_easydiscuss/helpers/db.php:44
    21	DiscussDBHelper->__call()	JROOT/components/com_easydiscuss/helpers/helper.php:701
    20	DiscussDBHelper->loadResult()	JROOT/components/com_easydiscuss/helpers/helper.php:701
    19	DiscussHelper::getConfig()	JROOT/components/com_easydiscuss/router.php:23
    18	EasyDiscussBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/modules/mod_menu/helper.php:118
    11	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

49. Query Time: 0.45 ms After last query: 14.28 ms Query memory: 0.017 MB Memory before query: 9.715 MB Rows returned: 1

    SELECT extension_id, name 
      FROM azvca_extensions 
      WHERE type = 'plugin' 
      AND folder = 'search' 
      AND enabled =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.27	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.13 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1799
    11	JDatabaseDriver->loadRowList()	JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php:241
    10	include JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

50. Query Time: 0.32 ms After last query: 10.79 ms Query memory: 0.032 MB Memory before query: 9.778 MB Rows returned: 0

    SELECT * 
      FROM azvca_virtuemart_calcs 
      WHERE
    		                    `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
    		                     
      AND `published`="1"
    		                     
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    		                     
      AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-06-07 02:57:12" )
    		                        
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-06-07 02:57:12" )
    										OR `for_override` = "1" )

    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	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:149
    16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:101
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:115
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1445
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1544
    12	VirtueMartCart->prepareCartData()	JROOT/plugins/system/vm2_cart/vm2_cart.php:61
    11	plgSystemVM2_Cart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:63
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

51. Query Time: 0.25 ms After last query: 4.22 ms Query memory: 0.030 MB Memory before query: 9.894 MB Rows returned: 0

    SELECT * 
      FROM azvca_virtuemart_calcs 
      WHERE
                    `calc_kind`="DBTaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-06-07 02:57:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-06-07 02:57:12" )

    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	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 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
    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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1260
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:724
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1449
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1544
    12	VirtueMartCart->prepareCartData()	JROOT/plugins/system/vm2_cart/vm2_cart.php:61
    11	plgSystemVM2_Cart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:63
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

52. Query Time: 0.21 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 9.918 MB Rows returned: 0

    SELECT * 
      FROM azvca_virtuemart_calcs 
      WHERE
                    `calc_kind`="TaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-06-07 02:57:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-06-07 02:57:12" )

    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	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1260
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:725
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1449
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1544
    12	VirtueMartCart->prepareCartData()	JROOT/plugins/system/vm2_cart/vm2_cart.php:61
    11	plgSystemVM2_Cart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:63
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

53. Query Time: 0.24 ms After last query: 0.09 ms Query memory: 0.029 MB Memory before query: 9.940 MB Rows returned: 0

    SELECT * 
      FROM azvca_virtuemart_calcs 
      WHERE
                    `calc_kind`="DATaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-06-07 02:57:12" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-06-07 02:57:12" )

    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	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1260
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:726
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1449
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1544
    12	VirtueMartCart->prepareCartData()	JROOT/plugins/system/vm2_cart/vm2_cart.php:61
    11	plgSystemVM2_Cart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:63
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

54. Query Time: 0.26 ms After last query: 40.21 ms Query memory: 0.020 MB Memory before query: 10.868 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM azvca_modules AS m
    
      WHERE m.id = 104 
      AND m.published = 1 
      AND m.access IN (1,1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 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.01 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:327
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:299
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:254
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:229
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:182
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:89
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

55. Query Time: 1.13 ms After last query: 7.01 ms Query memory: 0.020 MB Memory before query: 10.988 MB Rows returned: 352
    Duplicate queries: #25  #29

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 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.10 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	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
    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:253
    8	plgSystemjdownloads->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---