{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713411918,
                "last": 1713411918,
                "now": 1713411918
            }
        },
        "registry": {
            "com_virtuemart": {
                "category": {
                    "filter_order": "`p`.created_on"
                }
            }
        },
        "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,
        "vmlastvisitedItemid": 197,
        "vmlastvisitedcategoryid": 9,
        "vmlastvisitedmanuid": 0
    }
}

時間

記憶體

70 查詢記錄 29.88 ms

1. 查詢時間: 0.68 ms 查詢記憶體: 0.023 MB 記憶體於查詢: 2.565 MB 前 回傳的列: 0

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = '112t67nalb6uhu282l87hjek69'

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1

   側寫

   Status	Duration
   Starting	0.05 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	0.04 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.19 ms
   Preparing	0.02 ms
   Executing	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.01 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.01 ms

   呼叫堆疊

   #	Caller	檔案與行號
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	與下面行一樣的呼叫
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
   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:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

2. 查詢時間: 0.54 ms 最後的查詢: 1.77 ms 之後 查詢記憶體: 0.019 MB 記憶體於查詢: 2.646 MB 前 回傳的列: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = '112t67nalb6uhu282l87hjek69' 
     LIMIT 1

   說明

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

   側寫

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Checking query cache for query	0.06 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.02 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   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:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

3. 查詢時間: 1.10 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.003 MB 記憶體於查詢: 2.650 MB 前

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('112t67nalb6uhu282l87hjek69', 1, '1713411918', 0, '', 0)

   說明

   EXPLAIN 無法被使用於查詢: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('112t67nalb6uhu282l87hjek69', 1, '1713411918', 0, '', 0)

   側寫

   Status	Duration
   Starting	0.06 ms
   Checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init for update	0.03 ms
   Update	0.15 ms
   Waiting for query cache lock	0.01 ms
   Update	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.59 ms
   Closing tables	0.02 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   呼叫堆疊

   #	Caller	檔案與行號
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
   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:412
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

4. 查詢時間: 0.20 ms 最後的查詢: 2.68 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 2.821 MB 前 回傳的列: 42

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

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	42	Using index condition

   側寫

   Status	Duration
   Starting	0.05 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.01 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.02 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
   8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

5. 查詢時間: 0.09 ms 最後的查詢: 2.29 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 3.059 MB 前 回傳的列: 2

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

   說明

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

   側寫

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.01 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

6. 查詢時間: 0.08 ms 最後的查詢: 0.54 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 3.105 MB 前 回傳的列: 5

   SELECT id, rules
   
     FROM `jos_viewlevels`

   說明

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

   側寫

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

7. 查詢時間: 0.10 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 3.132 MB 前 回傳的列: 95

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

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	128	Using index condition; Using where; 使用filesort

   側寫

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
   8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

8. 查詢時間: 0.11 ms 最後的查詢: 9.22 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 4.383 MB 前 回傳的列: 2

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

   說明

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; 使用filesort

   側寫

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.02 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
   8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
   7	PlgSystemLanguageFilter->__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:682
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

9. 查詢時間: 0.09 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 4.392 MB 前 回傳的列: 4

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `jos_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   說明

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

   側寫

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	0.01 ms
   Checking privileges on cached	0.00 ms
   Checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   呼叫堆疊

   #	Caller	檔案與行號
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
   8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
   7	PlgSystemLanguageFilter->__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:682
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

   [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

   ---

10. 查詢時間: 0.20 ms 最後的查詢: 7.45 ms 之後 查詢記憶體: 0.104 MB 記憶體於查詢: 5.114 MB 前 回傳的列: 49

    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 jos_menu AS m
    
      LEFT JOIN jos_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

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	Using index condition; Using where; 使用filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sedia_jos1.m.component_id	1	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.01 ms
    Checking privileges on cached	0.00 ms
    Checking permissions	0.01 ms
    Sending cached result to clien	0.03 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
    15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
    14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
    12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
    11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
    10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
    9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
    8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

11. 查詢時間: 0.83 ms 最後的查詢: 12.52 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 6.500 MB 前 回傳的列: 3

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	sedia_jos1.s.template,const	1	Using index condition; Using where

    側寫

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    Init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.16 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
    11	JApplicationSite->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
    10	jsn_template_framework_class_loader()	與下面行一樣的呼叫
    9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
    8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

12. 查詢時間: 0.30 ms 最後的查詢: 0.36 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 6.529 MB 前 回傳的列: 1

    SELECT manifest_cache
    
      FROM jos_extensions
    
      WHERE element LIKE 'jsn_epic_pro'

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	Using index condition

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
    12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
    11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
    10	jsn_template_framework_class_loader()	與下面行一樣的呼叫
    9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
    8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

13. 查詢時間: 0.34 ms 最後的查詢: 10.30 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 6.868 MB 前 回傳的列: 1

    SELECT COUNT(*)
    
      FROM jos_extensions
    
      WHERE type = 'component' 
      AND element = 'com_sh404sef'

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166
    10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
    9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
    8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

14. 查詢時間: 0.36 ms 最後的查詢: 0.56 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 6.912 MB 前 回傳的列: 1

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

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

15. 查詢時間: 0.80 ms 最後的查詢: 0.16 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 6.902 MB 前

    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"6c3e90fd3442db513b886790fed40c5a\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    說明

    EXPLAIN 無法被使用於查詢: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"6c3e90fd3442db513b886790fed40c5a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    側寫

    Status	Duration
    Starting	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init for update	0.06 ms
    Updating	0.08 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.41 ms
    Closing tables	0.02 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

16. 查詢時間: 0.55 ms 最後的查詢: 10.43 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 8.399 MB 前 回傳的列: 1

    SHOW TABLES LIKE "jos_virtuemart_configs"

    說明

    EXPLAIN 無法被使用於查詢: SHOW TABLES LIKE "jos_virtuemart_configs"

    側寫

    Status	Duration
    Starting	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Checking permissions	0.18 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:700
    9	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:562
    8	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:946
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

17. 查詢時間: 0.32 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 8.406 MB 前 回傳的列: 1

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

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:994
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

18. 查詢時間: 0.82 ms 最後的查詢: 0.39 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 8.462 MB 前 回傳的列: 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` IN ('com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_formmaker','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_redirect','com_search','com_sitemapgenerator','com_smartslider3','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vmwishlist','com_wrapper') OR `parent_id` = 0

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	104	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.30 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    14	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    13	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    12	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    11	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1354
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:644
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1016
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

19. 查詢時間: 0.91 ms 最後的查詢: 15.78 ms 之後 查詢記憶體: 0.050 MB 記憶體於查詢: 9.781 MB 前 回傳的列: 20

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and client_id=0 
      and published=1 
      and (language="*" or language = "zh-TW" ) 
      AND ( access="1" OR access="5" )  
      ORDER BY `language` DESC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	50	Using index condition; Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.31 ms
    Waiting for query cache lock	0.01 ms
    Creating sort index	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1204
    20	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:802
    19	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:830
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    17	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    11	JRoute::_()	JROOT/components/com_virtuemart/views/category/view.html.php:520
    10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:129
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

20. 查詢時間: 0.53 ms 最後的查詢: 7.55 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 10.550 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_zh_tw`.*  
      FROM `jos_virtuemart_categories` 
      INNER JOIN `jos_virtuemart_categories_zh_tw` using (`virtuemart_category_id`) 
      WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "9"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:71
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:173
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

21. 查詢時間: 0.31 ms 最後的查詢: 0.76 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 10.614 MB 前 回傳的列: 1

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "9" 
      ORDER BY `ordering`

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	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.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:74
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:173
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

22. 查詢時間: 0.29 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 10.621 MB 前 回傳的列: 0

    SELECT `category_child_id`
    			
      FROM `jos_virtuemart_category_categories`
    			
      WHERE `category_parent_id` = 9

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_category_categories	ref	category_parent_id	category_parent_id	4	const	1	Using index

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:700
    11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:94
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:173
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

23. 查詢時間: 0.60 ms 最後的查詢: 0.03 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 10.628 MB 前 回傳的列: 1

    SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total
    			
      FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`
    			
      WHERE `jos_virtuemart_products`.`virtuemart_vendor_id` = "1"
    			
      AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 9
    			
      AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
    			
      AND `jos_virtuemart_products`.`published` = "1"

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_categories	index	virtuemart_product_id	virtuemart_product_id	8	NULL	290	Using where; Using index
    1	SIMPLE	jos_virtuemart_products	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	sedia_jos1.jos_virtuemart_product_categories.virtuemart_product_id	1	Using where

    側寫

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.05 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:430
    11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:101
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:173
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

24. 查詢時間: 0.85 ms 最後的查詢: 1.05 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 10.729 MB 前 回傳的列: 0

    SELECT c.* 
      FROM jos_virtuemart_customs  as c 
      INNER JOIN jos_virtuemart_product_customfields as pc 
      on (c.virtuemart_custom_id=pc.virtuemart_custom_id)
    
      INNER JOIN jos_virtuemart_product_categories as cat 
      ON (pc.virtuemart_product_id=cat.virtuemart_product_id) 
      WHERE virtuemart_category_id="9" 
      and searchable="1" 
      and (field_type="S" or field_type="P") 
      GROUP BY c.virtuemart_custom_id

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	PRIMARY,field_type,searchable	searchable	1	const	1	Using where; Using temporary; 使用filesort
    1	SIMPLE	pc	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_custom_id	4	sedia_jos1.c.virtuemart_custom_id	16	Using index condition
    1	SIMPLE	cat	eq_ref	virtuemart_product_id	virtuemart_product_id	8	sedia_jos1.pc.virtuemart_product_id,const	1	Using where; Using index

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.24 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:548
    10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:213
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

25. 查詢時間: 0.39 ms 最後的查詢: 2.54 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.046 MB 前 回傳的列: 1

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

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:428
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

26. 查詢時間: 0.23 ms 最後的查詢: 0.10 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 11.073 MB 前 回傳的列: 1

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

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:998
    16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:428
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

27. 查詢時間: 0.53 ms 最後的查詢: 1.00 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 11.137 MB 前 回傳的列: 3

    SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
    		
      FROM `jos_virtuemart_products` as p  
     
      LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `jos_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
     
      WHERE ( `pc`.`virtuemart_category_id` = 9 
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
     
      group by p.`virtuemart_product_id` 
     
      ORDER BY p.`created_on` ASC, p.`virtuemart_product_id` ASC 
      LIMIT 0, 24

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ps	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; 使用filesort
    1	SIMPLE	pc	index	virtuemart_product_id	virtuemart_product_id	8	NULL	290	Using where; Using index
    1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	sedia_jos1.pc.virtuemart_product_id	1	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.10 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:717
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

28. 查詢時間: 0.14 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 11.144 MB 前 回傳的列: 1

    SELECT FOUND_ROWS()

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	No tables used

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:856
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:717
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

29. 查詢時間: 0.72 ms 最後的查詢: 4.05 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.310 MB 前 回傳的列: 0

    SELECT DISTINCT IFNULL(l.`mf_name`,ld.mf_name) as mf_name,IFNULL(l.`virtuemart_manufacturer_id`,ld.`virtuemart_manufacturer_id`) as virtuemart_manufacturer_id
    
      FROM `jos_virtuemart_manufacturers_en_gb` as ld
    
      LEFT JOIN `jos_virtuemart_manufacturers_zh_tw` as l using (`virtuemart_manufacturer_id`) 
      INNER JOIN `jos_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`) 
      INNER JOIN `jos_virtuemart_products` as p 
      ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`  
      INNER JOIN `jos_virtuemart_product_categories` as c 
      ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`  
      WHERE p.`published` =1 
      AND c.`virtuemart_category_id` =9 
      ORDER BY `mf_name`

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.30 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:238
    13	VirtueMartModelManufacturer::getManufacturersOfProductsInCategory()	JROOT/libraries/joomla/cache/controller/callback.php:169
    12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
    11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/product.php:2584
    10	VirtueMartModelProduct->getOrderByList()	JROOT/components/com_virtuemart/views/category/view.html.php:257
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

30. 查詢時間: 0.39 ms 最後的查詢: 1.18 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.322 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_zh_tw`.*  
      FROM `jos_virtuemart_products` 
      INNER JOIN `jos_virtuemart_products_zh_tw` using (`virtuemart_product_id`) 
      WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "74"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1344
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

31. 查詢時間: 0.33 ms 最後的查詢: 0.31 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.346 MB 前 回傳的列: 3

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "74" 
      ORDER BY `ordering`

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	3	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	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.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1349
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

32. 查詢時間: 0.20 ms 最後的查詢: 0.24 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.370 MB 前 回傳的列: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `jos_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "74"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1352
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

33. 查詢時間: 0.47 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 11.383 MB 前 回傳的列: 1

    SELECT * 
      FROM `jos_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "74"  
      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` <= "2024-04-18 03:45:18" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-18 03:45:18" ) ) 
      ORDER BY `product_price` DESC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1148
    14	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
    13	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1367
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

34. 查詢時間: 0.21 ms 最後的查詢: 0.28 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.405 MB 前 回傳的列: 0

    SELECT `virtuemart_manufacturer_id` 
      FROM `jos_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "74"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1371
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

35. 查詢時間: 0.34 ms 最後的查詢: 0.03 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.412 MB 前 回傳的列: 1

    SELECT * 
      FROM `jos_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 74

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	1

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.01 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.02 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1610
    14	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1587
    13	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1387
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

36. 查詢時間: 0.40 ms 最後的查詢: 1.96 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 11.605 MB 前 回傳的列: 1

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
    		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
    		
      FROM `jos_virtuemart_customs` AS c 
      LEFT JOIN `jos_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (74) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	sedia_jos1.field.virtuemart_custom_id	1	Using index condition; Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
    13	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2512
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

37. 查詢時間: 0.41 ms 最後的查詢: 0.99 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 11.794 MB 前 回傳的列: 1

    SELECT *  
      FROM `jos_virtuemart_currencies` AS c
    			
      LEFT JOIN `jos_virtuemart_vendors` AS v 
      ON  c.virtuemart_currency_id = v.vendor_currency
    			
      WHERE v.virtuemart_vendor_id = "1"

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	system	PRIMARY,vendor_currency	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
    17	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    16	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
    15	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

38. 查詢時間: 0.32 ms 最後的查詢: 0.88 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 11.866 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_currencies`.*  
      FROM `jos_virtuemart_currencies`  
      WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "61"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:998
    16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
    15	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

39. 查詢時間: 0.72 ms 最後的查詢: 4.97 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 12.377 MB 前 回傳的列: 31

    SHOW FULL COLUMNS  
      FROM `jos_virtuemart_userfields`

    說明

    EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `jos_virtuemart_userfields`

    側寫

    Status	Duration
    Starting	0.03 ms
    Checking permissions	0.01 ms
    Closing tables	0.00 ms
    Opening tables	0.19 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    Checking permissions	0.13 ms
    Closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.07 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:661
    24	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
    23	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:218
    22	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:430
    21	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:392
    20	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:598
    19	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
    18	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:550
    17	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
    16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

40. 查詢時間: 0.47 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.033 MB 記憶體於查詢: 12.415 MB 前 回傳的列: 11

    SELECT * 
      FROM `jos_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `account`=1 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
      ORDER BY ordering

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_userfields	ref	published,account	account	1	const	18	Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.11 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
    18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:493
    17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
    16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

41. 查詢時間: 0.25 ms 最後的查詢: 0.16 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 12.450 MB 前 回傳的列: 2

    SELECT `fieldtitle`, `fieldvalue` 
      FROM `jos_virtuemart_userfield_values` 
      WHERE `virtuemart_userfield_id` = 23 
      ORDER BY `ordering`

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 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.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
    18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1020
    17	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
    16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

42. 查詢時間: 0.45 ms 最後的查詢: 0.90 ms 之後 查詢記憶體: 0.033 MB 記憶體於查詢: 12.540 MB 前 回傳的列: 9

    SELECT * 
      FROM `jos_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `shipment`=1 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
      ORDER BY ordering

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_userfields	ref	published,shipment	shipment	1	const	9	Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
    18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:499
    17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
    16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

43. 查詢時間: 0.41 ms 最後的查詢: 0.81 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 12.702 MB 前 回傳的列: 0

    SELECT c.* 
      FROM jos_virtuemart_calcs as c 
      LEFT JOIN jos_virtuemart_calc_shoppergroups as cs 
      ON cs.virtuemart_calc_id=c.virtuemart_calc_id 
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-04-18 03:45:18" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-18 03:45:18" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
    15	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
    14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

44. 查詢時間: 0.40 ms 最後的查詢: 0.16 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.731 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_zh_tw`.*  
      FROM `jos_virtuemart_products` 
      INNER JOIN `jos_virtuemart_products_zh_tw` using (`virtuemart_product_id`) 
      WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "206"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.06 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1344
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

45. 查詢時間: 0.26 ms 最後的查詢: 0.11 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.743 MB 前 回傳的列: 3

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "206" 
      ORDER BY `ordering`

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	2	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1349
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

46. 查詢時間: 0.21 ms 最後的查詢: 0.06 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.754 MB 前 回傳的列: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `jos_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "206"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1352
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

47. 查詢時間: 0.33 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.758 MB 前 回傳的列: 1

    SELECT * 
      FROM `jos_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "206"  
      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` <= "2024-04-18 03:45:18" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-18 03:45:18" ) ) 
      ORDER BY `product_price` DESC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1148
    14	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
    13	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1367
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

48. 查詢時間: 0.20 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.767 MB 前 回傳的列: 0

    SELECT `virtuemart_manufacturer_id` 
      FROM `jos_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "206"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1371
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

49. 查詢時間: 0.27 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.774 MB 前 回傳的列: 1

    SELECT * 
      FROM `jos_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 206

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	1

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1610
    14	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1587
    13	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1387
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

50. 查詢時間: 0.41 ms 最後的查詢: 0.14 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.799 MB 前 回傳的列: 0

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
    		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
    		
      FROM `jos_virtuemart_customs` AS c 
      LEFT JOIN `jos_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (206) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	sedia_jos1.field.virtuemart_custom_id	1	Using index condition; Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
    13	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2512
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

51. 查詢時間: 0.34 ms 最後的查詢: 0.15 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.825 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_zh_tw`.*  
      FROM `jos_virtuemart_products` 
      INNER JOIN `jos_virtuemart_products_zh_tw` using (`virtuemart_product_id`) 
      WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "207"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1344
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

52. 查詢時間: 0.20 ms 最後的查詢: 0.10 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.836 MB 前 回傳的列: 3

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "207" 
      ORDER BY `ordering`

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	2	Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 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.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1349
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

53. 查詢時間: 0.20 ms 最後的查詢: 0.05 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.847 MB 前 回傳的列: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `jos_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "207"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.01 ms
    Checking query cache for query	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1352
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

54. 查詢時間: 0.38 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.852 MB 前 回傳的列: 1

    SELECT * 
      FROM `jos_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "207"  
      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` <= "2024-04-18 03:45:18" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-18 03:45:18" ) ) 
      ORDER BY `product_price` DESC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; 使用filesort

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.04 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1148
    14	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
    13	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1367
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

55. 查詢時間: 0.15 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.861 MB 前 回傳的列: 0

    SELECT `virtuemart_manufacturer_id` 
      FROM `jos_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "207"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1371
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

56. 查詢時間: 0.29 ms 最後的查詢: 0.03 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 12.867 MB 前 回傳的列: 1

    SELECT * 
      FROM `jos_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 207

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	2

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1610
    14	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1587
    13	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1387
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

57. 查詢時間: 0.42 ms 最後的查詢: 0.15 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 12.892 MB 前 回傳的列: 6

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
    		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
    		
      FROM `jos_virtuemart_customs` AS c 
      LEFT JOIN `jos_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (207) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	7	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	sedia_jos1.field.virtuemart_custom_id	1	Using index condition; Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
    13	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2512
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1743
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:258
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

58. 查詢時間: 0.31 ms 最後的查詢: 1.27 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 13.019 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "434"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1163
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:259
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

59. 查詢時間: 0.26 ms 最後的查詢: 0.40 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 13.039 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "437"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1163
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:259
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

60. 查詢時間: 0.29 ms 最後的查詢: 0.15 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 13.051 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "441"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1163
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:259
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

61. 查詢時間: 0.36 ms 最後的查詢: 3.40 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 13.365 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "19"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.02 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1163
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:315
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

62. 查詢時間: 0.60 ms 最後的查詢: 0.58 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 13.397 MB 前 回傳的列: 0

    SELECT c.*, IFNULL(l.category_name,ld.category_name) as category_name, IFNULL(l.category_description,ld.category_description) as category_description, IFNULL(l.metadesc,ld.metadesc) as metadesc, IFNULL(l.metakey,ld.metakey) as metakey, IFNULL(l.customtitle,ld.customtitle) as customtitle, IFNULL(l.slug,ld.slug) as slug 
      FROM `jos_virtuemart_categories` as c 
      LEFT JOIN `jos_virtuemart_categories_en_gb` as ld 
      ON ld.`virtuemart_category_id` = c.`virtuemart_category_id`  
      LEFT JOIN `jos_virtuemart_categories_zh_tw` as l 
      ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
      LEFT JOIN `jos_virtuemart_category_categories` as cx 
      on c.`virtuemart_category_id` = cx.`category_child_id`  
      WHERE cx.`category_parent_id` = 9  
      AND c.`virtuemart_vendor_id` = 1 
      AND c.`published` = 1  
      ORDER BY c.published ASC

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cx	ref	category_parent_id,category_child_id	category_parent_id	4	const	1	Using index
    1	SIMPLE	c	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	sedia_jos1.cx.category_child_id	1	Using where
    1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	sedia_jos1.cx.category_child_id	1
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	sedia_jos1.cx.category_child_id	1

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.10 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.05 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:249
    13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:169
    12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:41
    11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:168
    10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/category/view.html.php:320
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

63. 查詢時間: 0.58 ms 最後的查詢: 0.31 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 13.403 MB 前 回傳的列: 1

    SELECT `jos_virtuemart_vendors`.* ,`jos_virtuemart_vendors_zh_tw`.*  
      FROM `jos_virtuemart_vendors` 
      INNER JOIN `jos_virtuemart_vendors_zh_tw` using (`virtuemart_vendor_id`) 
      WHERE `jos_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.10 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:86
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:379
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

64. 查詢時間: 0.26 ms 最後的查詢: 0.33 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 13.433 MB 前 回傳的列: 0

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_vendor_medias` 
      WHERE `virtuemart_vendor_id` = "1" 
      ORDER BY `ordering`

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.03 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:97
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:379
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:394
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
    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:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

65. 查詢時間: 0.76 ms 最後的查詢: 69.84 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 13.664 MB 前 回傳的列: 3

    SELECT language,id
    
      FROM `jos_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	50	Using where

    側寫

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.18 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:709
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

66. 查詢時間: 0.48 ms 最後的查詢: 1.07 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 13.723 MB 前 回傳的列: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `jos_menu` AS `c`
    
      INNER JOIN `jos_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `jos_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `jos_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 197

    說明

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

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.05 ms
    Checking permissions	0.01 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:726
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

67. 查詢時間: 1.63 ms 最後的查詢: 7.98 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 14.306 MB 前 回傳的列: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-18 03:45:18') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 03:45:18') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 197 OR mm.menuid <= 0) 
      AND m.language IN ('zh-TW','*')
    
      ORDER BY m.position, m.ordering

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	42	Using where; 使用filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sedia_jos1.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	sedia_jos1.m.module,const	1	Using index condition; Using where

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.44 ms
    Preparing	0.07 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.57 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.07 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
    13	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
    12	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
    11	JModuleHelper::getModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:168
    10	JSNTplUtils->countModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:493
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
    7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

68. 查詢時間: 0.51 ms 最後的查詢: 6.21 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 14.573 MB 前 回傳的列: 0

    SELECT m.id
    
      FROM jos_modules AS m
    
      INNER JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_k2_%' 
      AND (mm.menuid < 0 
      AND mm.menuid = -197) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
      left", "promo", "promo-right", "content-top", "content-top-below", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	42	Using where
    1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	sedia_jos1.m.id,const	1	Using index

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
    12	JSNTplUtils->checkK2()	JROOT/templates/jsn_epic_pro/template_custom.php:46
    11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:997
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:737
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
    7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

69. 查詢時間: 0.50 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 14.581 MB 前 回傳的列: 0

    SELECT m.id
    
      FROM jos_modules AS m
    
      INNER JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_k2_%' 
      AND (mm.menuid = 197 OR mm.menuid = 0 OR (mm.menuid < 0 
      AND mm.menuid != -197)) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
      left", "promo", "promo-right", "content-top", "content-top-below", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
    
      GROUP BY m.id

    說明

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	index	PRIMARY,published,newsfeeds	PRIMARY	4	NULL	42	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sedia_jos1.m.id	1	Using where; Using index

    側寫

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.01 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
    12	JSNTplUtils->checkK2()	JROOT/templates/jsn_epic_pro/template_custom.php:46
    11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:997
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:737
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
    7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---

70. 查詢時間: 0.93 ms 最後的查詢: 23.81 ms 之後 查詢記憶體: 0.032 MB 記憶體於查詢: 15.400 MB 前 回傳的列: 152

    SELECT * 
      FROM jos_acymailing_config

    說明

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

    側寫

    Status	Duration
    Starting	0.04 ms
    Waiting for query cache lock	0.00 ms
    Init	0.00 ms
    Checking query cache for query	0.06 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    Init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.33 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    呼叫堆疊

    #	Caller	檔案與行號
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:468
    9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1238
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

    ---