اشکال یابی جوملا

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686106975,
                "last": 1686106975,
                "now": 1686106975
            },
            "token": "CMrwlkmxfjz6nzzuObiytleTDf44FjOC"
        },
        "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
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedcategoryid": 42
    }
}

Time

Memory

70 پرس و جو ثبت شده 45.67 ms

1. Query Time: 0.36 ms Query memory: 0.018 MB Memory before query: 0.929 MB Rows returned: 0

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

   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.06 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 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: 4.82 ms After last query: 4.02 ms Query memory: 0.008 MB Memory before query: 0.995 MB

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

   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.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.05 ms
   updating	0.11 ms
   end	0.01 ms
   query end	4.48 ms
   closing tables	0.02 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.15 ms After last query: 0.17 ms Query memory: 0.012 MB Memory before query: 1.006 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `azvca_session`
   
     WHERE `session_id` = 'rfbjof3icpjk575s7n9qrh5nn4' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.01 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: 7.58 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 1.021 MB

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

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.05 ms
   end	0.00 ms
   query end	7.41 ms
   closing tables	0.01 ms
   freeing items	0.01 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: 0.47 ms After last query: 4.05 ms Query memory: 0.024 MB Memory before query: 1.078 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.05 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.20 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:1689
   9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

6. Query Time: 0.29 ms After last query: 2.58 ms Query memory: 0.015 MB Memory before query: 1.189 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.06 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.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.19 ms After last query: 1.06 ms Query memory: 0.014 MB Memory before query: 1.209 MB Rows returned: 3

   SELECT id, rules
   
     FROM `azvca_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.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: 0.75 ms After last query: 0.12 ms Query memory: 0.016 MB Memory before query: 1.227 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.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.51 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
   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.24 ms After last query: 30.16 ms Query memory: 0.013 MB Memory before query: 2.171 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.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.30 ms After last query: 15.54 ms Query memory: 0.023 MB Memory before query: 2.516 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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 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:1650
    16	JDatabaseDriver->loadObject()	Same as call in the line below.
    15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    13	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    8	JFactory::getDocument()	JROOT/plugins/system/wishlists/wishlists.php:23
    7	plgSystemWishlists->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

11. Query Time: 10.35 ms After last query: 0.22 ms Query memory: 0.016 MB Memory before query: 2.522 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.04 ms
    updating	0.05 ms
    end	0.01 ms
    query end	10.12 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/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.29 ms After last query: 72.17 ms Query memory: 0.017 MB Memory before query: 3.540 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.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/protection.php:111
    11	SecuritycheckprosModelProtection->load()	JROOT/administrator/components/com_securitycheckpro/models/protection.php:76
    10	SecuritycheckprosModelProtection->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1312
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

13. Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.013 MB Memory before query: 3.557 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.07 ms
    init	0.01 ms
    System lock	0.03 ms
    updating	0.01 ms
    end	0.02 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
    11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1849
    10	plgSystemSecuritycheckpro->forbid_new_admins()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1333
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

14. Query Time: 0.21 ms After last query: 2.14 ms Query memory: 0.018 MB Memory before query: 3.615 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.02 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.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/geoblock.php:73
    11	SecuritycheckprosModelGeoblock->load()	JROOT/administrator/components/com_securitycheckpro/models/geoblock.php:38
    10	SecuritycheckprosModelGeoblock->getValue()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1343
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

15. Query Time: 0.23 ms After last query: 0.11 ms Query memory: 0.014 MB Memory before query: 3.630 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.07 ms
    init	0.02 ms
    System lock	0.02 ms
    updating	0.01 ms
    end	0.02 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/plugins/system/securitycheckpro/securitycheckpro.php:666
    11	plgSystemSecuritycheckpro->pasar_a_historico()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:701
    10	plgSystemSecuritycheckpro->acciones_lista_negra_dinamica()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1403
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

16. Query Time: 0.15 ms After last query: 0.07 ms Query memory: 0.017 MB Memory before query: 3.645 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 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.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

17. Query Time: 1.07 ms After last query: 3.66 ms Query memory: 0.043 MB Memory before query: 3.723 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.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.67 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:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    21	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    20	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    19	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    18	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    17	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    16	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    15	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    14	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    13	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    12	JApplicationSite::getRouter()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1461
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

18. Query Time: 0.51 ms After last query: 51.76 ms Query memory: 0.042 MB Memory before query: 4.832 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `azvca_assets`

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.11 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
    Opening tables	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    27	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    26	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    25	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    24	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    23	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    22	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    21	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    20	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

19. Query Time: 0.21 ms After last query: 1.48 ms Query memory: 0.035 MB Memory before query: 4.902 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.02 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.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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    25	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    24	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    23	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    22	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    21	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    20	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

20. Query Time: 0.24 ms After last query: 0.20 ms Query memory: 0.031 MB Memory before query: 4.932 MB Rows returned: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.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.06 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    24	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    23	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    22	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    21	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    20	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

21. Query Time: 0.29 ms After last query: 1.20 ms Query memory: 0.034 MB Memory before query: 4.975 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.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.00 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:413
    25	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    24	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    23	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    22	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    21	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    20	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

22. Query Time: 0.68 ms After last query: 0.23 ms Query memory: 0.034 MB Memory before query: 5.018 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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.04 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.14 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.30 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 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:1494
    26	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    25	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    24	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    23	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    22	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:529
    21	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
    20	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:754
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

23. Query Time: 0.95 ms After last query: 3.40 ms Query memory: 0.028 MB Memory before query: 5.491 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.02 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.76 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:477
    20	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:757
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

24. Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 5.519 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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:801
    19	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:756
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

25. Query Time: 0.51 ms After last query: 1.01 ms Query memory: 0.035 MB Memory before query: 5.603 MB Rows returned: 12

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.24 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1037
    20	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:737
    19	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:759
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:324
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

26. Query Time: 0.22 ms After last query: 0.33 ms Query memory: 0.026 MB Memory before query: 5.696 MB Rows returned: 0
    Duplicate queries: #30  #46

    SELECT `virtuemart_category_id`
    				
      FROM  `azvca_virtuemart_categories_fa_ir`
    				
      WHERE `slug` = ''

    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.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    20	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:883
    19	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:954
    18	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:643
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

27. Query Time: 0.21 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 5.721 MB Rows returned: 1
    Duplicate queries: #31  #47

    SELECT p.`virtuemart_product_id`  
      FROM `azvca_virtuemart_products_fa_ir` AS `p`  
      WHERE `slug` = "lm-408"

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	p	NULL	const	slug	slug	576	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    19	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:969
    18	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:643
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

28. Query Time: 0.23 ms After last query: 0.16 ms Query memory: 0.018 MB Memory before query: 5.729 MB Rows returned: 1
    Duplicate queries: #29  #32  #33

    SELECT COUNT(*) 
      from `azvca_securitycheckpro_db` 
      WHERE (vuln_type = 'com_virtuemart')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:229
    12	plgSystemSecuritycheckpro->check_extension_vulnerable()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:275
    11	plgSystemSecuritycheckpro->cleanQuery()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:808
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

29. Query Time: 0.22 ms After last query: 0.21 ms Query memory: 0.018 MB Memory before query: 5.747 MB Rows returned: 1
    Duplicate queries: #28  #32  #33

    SELECT COUNT(*) 
      from `azvca_securitycheckpro_db` 
      WHERE (vuln_type = 'com_virtuemart')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:229
    12	plgSystemSecuritycheckpro->check_extension_vulnerable()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:583
    11	plgSystemSecuritycheckpro->second_level()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:823
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

30. Query Time: 0.14 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 5.775 MB Rows returned: 0
    Duplicate queries: #26  #46

    SELECT `virtuemart_category_id`
    				
      FROM  `azvca_virtuemart_categories_fa_ir`
    				
      WHERE `slug` = ''

    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.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    20	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:883
    19	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:954
    18	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:643
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

31. Query Time: 0.16 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 5.800 MB Rows returned: 1
    Duplicate queries: #27  #47

    SELECT p.`virtuemart_product_id`  
      FROM `azvca_virtuemart_products_fa_ir` AS `p`  
      WHERE `slug` = "lm-408"

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	p	NULL	const	slug	slug	576	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    19	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:969
    18	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:643
    17	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    16	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    15	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    14	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    13	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    12	JRouterSite->parse()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1462
    11	plgSystemSecuritycheckpro->get_component()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:806
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

32. Query Time: 0.20 ms After last query: 0.11 ms Query memory: 0.018 MB Memory before query: 5.813 MB Rows returned: 1
    Duplicate queries: #28  #29  #33

    SELECT COUNT(*) 
      from `azvca_securitycheckpro_db` 
      WHERE (vuln_type = 'com_virtuemart')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:229
    12	plgSystemSecuritycheckpro->check_extension_vulnerable()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:275
    11	plgSystemSecuritycheckpro->cleanQuery()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:808
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

33. Query Time: 0.16 ms After last query: 0.13 ms Query memory: 0.018 MB Memory before query: 5.831 MB Rows returned: 1
    Duplicate queries: #28  #29  #32

    SELECT COUNT(*) 
      from `azvca_securitycheckpro_db` 
      WHERE (vuln_type = 'com_virtuemart')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:229
    12	plgSystemSecuritycheckpro->check_extension_vulnerable()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:583
    11	plgSystemSecuritycheckpro->second_level()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:823
    10	plgSystemSecuritycheckpro->acciones_no_listas()	JROOT/plugins/system/securitycheckpro/securitycheckpro.php:1436
    9	plgSystemSecuritycheckpro->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

34. Query Time: 0.21 ms After last query: 5.02 ms Query memory: 0.017 MB Memory before query: 5.885 MB Rows returned: 1
    Duplicate queries: #38

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

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

    ---

35. Query Time: 0.18 ms After last query: 0.13 ms Query memory: 0.017 MB Memory before query: 5.902 MB Rows returned: 1
    Duplicate queries: #39

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

36. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.017 MB Memory before query: 5.919 MB Rows returned: 1
    Duplicate queries: #40

    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.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:152
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

37. Query Time: 0.13 ms After last query: 0.10 ms Query memory: 0.017 MB Memory before query: 5.933 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

38. Query Time: 0.14 ms After last query: 0.14 ms Query memory: 0.018 MB Memory before query: 5.955 MB Rows returned: 1
    Duplicate queries: #34

    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.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

39. Query Time: 0.18 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 5.973 MB Rows returned: 1
    Duplicate queries: #35

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

40. Query Time: 0.17 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 5.991 MB Rows returned: 1
    Duplicate queries: #36

    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.00 ms

    Call Stack

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

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

    ---

41. Query Time: 0.15 ms After last query: 0.08 ms Query memory: 0.016 MB Memory before query: 6.005 MB Rows returned: 1

    SELECT `last_task`
    
      FROM `azvca_securitycheckpro_file_manager`

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.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/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:102
    10	plgSystemSecuritycheckpro_cron->check_timestamp()	JROOT/plugins/system/securitycheckpro_cron/securitycheckpro_cron.php:165
    9	plgSystemSecuritycheckpro_cron->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

42. Query Time: 0.13 ms After last query: 0.10 ms Query memory: 0.016 MB Memory before query: 6.020 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.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

43. Query Time: 1.18 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 6.025 MB Rows returned: 352
    Duplicate queries: #48  #70

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

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

    Call Stack

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

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

    ---

44. Query Time: 0.32 ms After last query: 0.32 ms Query memory: 0.015 MB Memory before query: 6.106 MB Rows returned: 0

    SELECT file_id 
      from azvca_jdownloads_files 
      WHERE published = 1 
      AND use_timeframe = 1 
      AND publish_to != '0000-00-00 00:00:00' 
      AND publish_to <= '2023-06-07 07:32:55'

    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.03 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.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

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

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

    ---

45. Query Time: 0.17 ms After last query: 0.07 ms Query memory: 0.015 MB Memory before query: 6.120 MB Rows returned: 0

    SELECT file_id 
      from azvca_jdownloads_files 
      WHERE published = 0 
      AND use_timeframe = 1 
      AND publish_from != '0000-00-00 00:00:00' 
      AND publish_from <= '2023-06-07 07:32:55'

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

46. Query Time: 0.25 ms After last query: 53.14 ms Query memory: 0.019 MB Memory before query: 6.798 MB Rows returned: 0
    Duplicate queries: #26  #30

    SELECT `virtuemart_category_id`
    				
      FROM  `azvca_virtuemart_categories_fa_ir`
    				
      WHERE `slug` = ''

    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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:883
    12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:954
    11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:643
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    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.]

    ---

47. Query Time: 0.18 ms After last query: 0.10 ms Query memory: 0.017 MB Memory before query: 6.816 MB Rows returned: 1
    Duplicate queries: #27  #31

    SELECT p.`virtuemart_product_id`  
      FROM `azvca_virtuemart_products_fa_ir` AS `p`  
      WHERE `slug` = "lm-408"

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	p	NULL	const	slug	slug	576	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.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:969
    11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:643
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    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.]

    ---

48. Query Time: 1.21 ms After last query: 0.37 ms Query memory: 0.021 MB Memory before query: 6.844 MB Rows returned: 352
    Duplicate queries: #43  #70

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

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

    Call Stack

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

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

    ---

49. Query Time: 0.37 ms After last query: 0.50 ms Query memory: 0.018 MB Memory before query: 6.867 MB Rows returned: 12

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.11 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    11	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
    10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    9	plgSystemT3->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

50. Query Time: 0.36 ms After last query: 18.55 ms Query memory: 0.022 MB Memory before query: 7.211 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:315
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
    10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
    9	plgSystemK2->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

51. Query Time: 0.38 ms After last query: 44.55 ms Query memory: 0.028 MB Memory before query: 8.021 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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 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:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:119
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:169
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:120
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1069
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

52. Query Time: 0.14 ms After last query: 0.19 ms Query memory: 0.031 MB Memory before query: 8.081 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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:694
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:913
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:124
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:169
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:120
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1069
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

53. Query Time: 0.36 ms After last query: 1.60 ms Query memory: 0.031 MB Memory before query: 8.138 MB Rows returned: 1

    SELECT `azvca_virtuemart_products`.* ,`azvca_virtuemart_products_fa_ir`.*  
      FROM `azvca_virtuemart_products` 
      INNER JOIN `azvca_virtuemart_products_fa_ir` using (`virtuemart_product_id`) 
      WHERE `azvca_virtuemart_products`.`virtuemart_product_id` = "91"

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:694
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1096
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

54. Query Time: 0.30 ms After last query: 1.70 ms Query memory: 0.019 MB Memory before query: 8.254 MB Rows returned: 1

    SELECT `virtuemart_media_id` 
      FROM `azvca_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "91" 
      ORDER BY `ordering`

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:122
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1101
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

55. Query Time: 0.19 ms After last query: 0.12 ms Query memory: 0.019 MB Memory before query: 8.272 MB Rows returned: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `azvca_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "91"

    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.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/product.php:1334
    12	VirtueMartModelProduct->getProductShoppergroups()	JROOT/administrator/components/com_virtuemart/models/product.php:1104
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

56. Query Time: 0.31 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 8.294 MB Rows returned: 0

    SELECT * 
      FROM `azvca_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "91"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2023-06-07 03:02:55" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-06-07 03:02:55" ) ) 
      ORDER BY `product_price` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_virtuemart_product_prices	NULL	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	50.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 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:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:951
    13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:971
    12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1125
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

57. Query Time: 0.23 ms After last query: 0.77 ms Query memory: 0.019 MB Memory before query: 8.357 MB Rows returned: 1

    SELECT `virtuemart_manufacturer_id` 
      FROM `azvca_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "91"

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	azvca_virtuemart_product_manufacturers	NULL	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

    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.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:122
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1128
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

58. Query Time: 0.41 ms After last query: 0.79 ms Query memory: 0.023 MB Memory before query: 8.425 MB Rows returned: 1

    SELECT `azvca_virtuemart_manufacturers`.* ,`azvca_virtuemart_manufacturers_fa_ir`.*  
      FROM `azvca_virtuemart_manufacturers` 
      INNER JOIN `azvca_virtuemart_manufacturers_fa_ir` using (`virtuemart_manufacturer_id`) 
      WHERE `azvca_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "11"

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 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.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:694
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1133
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

59. Query Time: 0.21 ms After last query: 0.19 ms Query memory: 0.020 MB Memory before query: 8.445 MB Rows returned: 1

    SELECT * 
      FROM `azvca_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 91

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.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:1494
    13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1307
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1144
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:770
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:91
    9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:219
    8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:118
    6	require_once JROOT/components/com_virtuemart/virtuemart.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.]

    ---

60. Query Time: 0.28 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 8.475 MB Rows returned: 1