{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702231355,
                "last": 1702231355,
                "now": 1702231355
            },
            "token": "AsVWhoGl0Yy5gWAJ7fp0WM95AFh1XZ85"
        },
        "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

56 پرس و جو ثبت شده 34090.23 ms

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

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

   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.06 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 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.17 ms After last query: 1.94 ms Query memory: 0.003 MB Memory before query: 2.600 MB

   DELETE 
   
     FROM `azvca_session`
   
     WHERE `time` < '1702225955'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	azvca_session	NULL	range	time	time	59	const	1	100.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   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: 0.13 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 2.605 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `azvca_session`
   
     WHERE `session_id` = 'b645c88037715e64816d6f17b9845e7f' 
     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.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 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
   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.]

   ---

4. Query Time: 33921.19 ms After last query: 0.06 ms Query memory: 0.003 MB Memory before query: 2.609 MB

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

   Explain

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

   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
   update	0.05 ms
   end	0.01 ms
   query end	33920.97 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   cleaning up	0.01 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.]

   ---

5. Query Time: 96.59 ms After last query: 3.43 ms Query memory: 0.059 MB Memory before query: 2.771 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.03 ms
   checking permissions	0.01 ms
   Opening tables	96.00 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.25 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

6. Query Time: 1.99 ms After last query: 1.93 ms Query memory: 0.022 MB Memory before query: 3.001 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.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.16 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 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.]

   ---

7. Query Time: 0.29 ms After last query: 0.88 ms Query memory: 0.022 MB Memory before query: 3.047 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.04 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.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 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.]

   ---

8. Query Time: 1.19 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 3.055 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.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.86 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 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.]

   ---

9. Query Time: 0.34 ms After last query: 27.47 ms Query memory: 0.022 MB Memory before query: 5.033 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.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 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.]

   ---

10. Query Time: 0.41 ms After last query: 11.98 ms Query memory: 0.025 MB Memory before query: 5.827 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.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

11. Query Time: 20.65 ms After last query: 0.20 ms Query memory: 0.006 MB Memory before query: 5.818 MB

    UPDATE `azvca_extensions`
    
      SET `params` = '{\"mediaversion\":\"6ea50834dee07d00a1e3783629bfb036\"}'
    
      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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.06 ms
    updating	0.06 ms
    end	0.01 ms
    query end	20.34 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

12. Query Time: 0.37 ms After last query: 95.86 ms Query memory: 0.023 MB Memory before query: 8.523 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.06 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

13. Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 8.527 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.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.02 ms
    updating	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

14. Query Time: 0.16 ms After last query: 1.05 ms Query memory: 0.023 MB Memory before query: 8.645 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.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
    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.01 ms

    Call Stack

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

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

    ---

15. Query Time: 0.17 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 8.648 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.02 ms
    updating	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

16. Query Time: 0.14 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 8.654 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

17. Query Time: 0.18 ms After last query: 2.55 ms Query memory: 0.023 MB Memory before query: 8.893 MB Rows returned: 1
    Duplicate queries: #21

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

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

    ---

18. Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 8.900 MB Rows returned: 1
    Duplicate queries: #22

    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.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.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

19. Query Time: 0.12 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.906 MB Rows returned: 1
    Duplicate queries: #23

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

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

    ---

20. Query Time: 0.10 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.910 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.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

21. Query Time: 0.12 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 8.918 MB Rows returned: 1
    Duplicate queries: #17

    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.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.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/filemanager.php:199
    11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

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

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

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.01 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.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/filemanager.php:207
    11	SecuritycheckprosModelFileManager->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    10	JModelLegacy::getInstance()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:94
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

23. Query Time: 0.14 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.931 MB Rows returned: 1
    Duplicate queries: #19

    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.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.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

24. Query Time: 0.15 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 8.935 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.02 ms
    checking permissions	0.01 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.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:1728
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102
    9	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    8	plgSystemSecuritycheckpro_cron->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

25. Query Time: 0.11 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 8.940 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.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.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

26. Query Time: 1.20 ms After last query: 0.12 ms Query memory: 0.041 MB Memory before query: 8.939 MB Rows returned: 352
    Duplicate queries: #30  #56

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

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

    Call Stack

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

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

    ---

27. Query Time: 0.29 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 8.984 MB Rows returned: 0

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

    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.01 ms
    Opening tables	0.06 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.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

28. Query Time: 0.15 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 8.989 MB Rows returned: 0

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

    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.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.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

29. Query Time: 1.20 ms After last query: 69.37 ms Query memory: 0.058 MB Memory before query: 10.687 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.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.03 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.01 ms
    Sending data	0.02 ms
    Creating sort index	0.66 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/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.]

    ---

30. Query Time: 6.03 ms After last query: 37.72 ms Query memory: 0.041 MB Memory before query: 13.350 MB Rows returned: 352
    Duplicate queries: #26  #56

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

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

    Call Stack

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

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

    ---

31. Query Time: 0.63 ms After last query: 0.38 ms Query memory: 0.056 MB Memory before query: 13.359 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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

32. Query Time: 0.42 ms After last query: 19.90 ms Query memory: 0.028 MB Memory before query: 14.044 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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

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

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

    ---

33. Query Time: 0.57 ms After last query: 99.45 ms Query memory: 0.038 MB Memory before query: 16.847 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.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

34. Query Time: 0.23 ms After last query: 0.15 ms Query memory: 0.032 MB Memory before query: 16.881 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.01 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.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

35. Query Time: 0.28 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 16.892 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.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.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

36. Query Time: 0.40 ms After last query: 0.90 ms Query memory: 0.033 MB Memory before query: 16.922 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

37. Query Time: 1.08 ms After last query: 0.16 ms Query memory: 0.034 MB Memory before query: 16.942 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.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.21 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.58 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

38. Query Time: 1.43 ms After last query: 2.60 ms Query memory: 0.029 MB Memory before query: 17.314 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.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    checking permissions	1.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

39. Query Time: 0.81 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 17.325 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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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.]

    ---

40. Query Time: 1.10 ms After last query: 4.16 ms Query memory: 0.039 MB Memory before query: 17.522 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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.27 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

41. Query Time: 0.79 ms After last query: 1.61 ms Query memory: 0.034 MB Memory before query: 17.662 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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 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
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

42. Query Time: 4.84 ms After last query: 3.88 ms Query memory: 0.033 MB Memory before query: 17.898 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.08 ms
    checking permissions	0.01 ms
    Opening tables	0.15 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

43. Query Time: 0.31 ms After last query: 0.18 ms Query memory: 0.034 MB Memory before query: 17.930 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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 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
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

44. Query Time: 0.71 ms After last query: 2.81 ms Query memory: 0.043 MB Memory before query: 17.951 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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.36 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

45. Query Time: 2.12 ms After last query: 17.58 ms Query memory: 0.025 MB Memory before query: 18.830 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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.13 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
    12	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    11	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
    10	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:368
    9	RSFormProHelper::readConfig()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:20
    8	plgSystemRSFPRegistration->canRun()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:629
    7	plgSystemRSFPRegistration->onAfterDispatch()	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.]

    ---

46. Query Time: 3.42 ms After last query: 10.16 ms Query memory: 0.031 MB Memory before query: 19.273 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-12-10 18:03:09') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-10 18:03:09') 
      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.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.48 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.76 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

47. Query Time: 0.65 ms After last query: 27.80 ms Query memory: 0.032 MB Memory before query: 19.814 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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

48. Query Time: 4.44 ms After last query: 3.98 ms Query memory: 0.028 MB Memory before query: 20.135 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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.15 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

49. Query Time: 0.42 ms After last query: 5.11 ms Query memory: 0.036 MB Memory before query: 20.215 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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    22	JDatabaseDriver->loadResult()	JROOT/components/com_easydiscuss/helpers/db.php:139
    21	EasyDiscussDbJoomla30->__call()	JROOT/components/com_easydiscuss/helpers/db.php:44
    20	DiscussDBHelper->__call()	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.]

    ---

50. Query Time: 3.99 ms After last query: 14.47 ms Query memory: 0.023 MB Memory before query: 20.648 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.06 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.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.23 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

51. Query Time: 0.52 ms After last query: 11.26 ms Query memory: 0.033 MB Memory before query: 20.810 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-12-10 18:03:09" )
    		                        
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-12-10 18:03:09" )
    										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.09 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

52. Query Time: 0.32 ms After last query: 3.23 ms Query memory: 0.033 MB Memory before query: 21.080 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-12-10 18:03:09" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-12-10 18:03:09" )

    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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

53. Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.033 MB Memory before query: 21.089 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-12-10 18:03:09" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-12-10 18:03:09" )

    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.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

54. Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.033 MB Memory before query: 21.097 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-12-10 18:03:09" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-12-10 18:03:09" )

    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.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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.]

    ---

55. Query Time: 4.34 ms After last query: 41.71 ms Query memory: 0.025 MB Memory before query: 22.441 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.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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.]

    ---

56. Query Time: 1.66 ms After last query: 7.71 ms Query memory: 0.041 MB Memory before query: 22.576 MB Rows returned: 352
    Duplicate queries: #26  #30

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:253
    7	plgSystemjdownloads->onAfterRender()	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.]

    ---