The Best Beauty Salon 優美按摩美容纖體中心

Joomla! 除錯主控台

連線階段 (Session)

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1783463189,
                "last": 1783463189,
                "now": 1783463191
            },
            "token": "OIP920l4aijBcc9S5ta70iHFfGzREch8"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__com_awocoupon": {
        "site": {
            "virtuemart_use_injection_mode": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmcartlastVendorId": 1,
        "vmlastvisitedcategoryid": 100,
        "vmlastvisitedproductids": [
            704
        ]
    }
}

側寫資訊

時間

記憶體

時間: 17.70 ms / 17.70 ms 記憶體: 1.695 MB / 2.04 MB Application: afterLoad

時間: 52.18 ms / 69.88 ms 記憶體: 4.353 MB / 6.40 MB Application: afterInitialise

時間: 49.41 ms / 119.29 ms 記憶體: 4.948 MB / 11.34 MB Application: Before Access::preloadComponents (all components)

時間: 1.46 ms / 120.75 ms 記憶體: 0.065 MB / 11.41 MB Application: After Access::preloadComponents (all components)

時間: 0.03 ms / 120.78 ms 記憶體: -0.003 MB / 11.40 MB Application: Before Access::getAssetRules (id:1 name:root.1)

時間: 0.52 ms / 121.30 ms 記憶體: 0.026 MB / 11.43 MB Application: After Access::getAssetRules (id:1 name:root.1)

時間: 0.03 ms / 121.33 ms 記憶體: 0.000 MB / 11.43 MB Application: Before Access::getAssetRules (id:71 name:com_virtuemart)

時間: 0.01 ms / 121.35 ms 記憶體: 0.002 MB / 11.43 MB Application: After Access::getAssetRules (id:71 name:com_virtuemart)

時間: 146.08 ms / 267.43 ms 記憶體: 6.314 MB / 17.75 MB Application: afterRoute

時間: 0.91 ms / 268.34 ms 記憶體: 0.004 MB / 17.75 MB Application: beforeRenderComponent com_virtuemart

時間: 100.39 ms / 368.73 ms 記憶體: 6.886 MB / 24.64 MB Application: afterRenderComponent com_virtuemart

時間: 4.08 ms / 372.81 ms 記憶體: 0.136 MB / 24.77 MB Application: afterDispatch

時間: 14.06 ms / 386.87 ms 記憶體: 0.680 MB / 25.45 MB Application: beforeRenderModule mod_custom (Footer)

時間: 18.76 ms / 405.63 ms 記憶體: 1.143 MB / 26.60 MB Application: beforeRenderModule mod_acym (Subscribe Form)

時間: 4.72 ms / 410.35 ms 記憶體: 0.342 MB / 26.94 MB Application: afterRenderModule mod_acym (Subscribe Form)

時間: 0.50 ms / 410.84 ms 記憶體: -0.054 MB / 26.88 MB Application: afterRenderModule mod_custom (Footer)

時間: 0.06 ms / 410.90 ms 記憶體: 0.003 MB / 26.89 MB Application: beforeRenderModule mod_aworewards_points (AwoRewards Points)

時間: 1.04 ms / 411.94 ms 記憶體: 0.015 MB / 26.90 MB Application: afterRenderModule mod_aworewards_points (AwoRewards Points)

時間: 0.05 ms / 411.99 ms 記憶體: -0.000 MB / 26.90 MB Application: beforeRenderModule mod_custom (Social Media Click Icon)

時間: 0.41 ms / 412.40 ms 記憶體: 0.004 MB / 26.91 MB Application: afterRenderModule mod_custom (Social Media Click Icon)

時間: 0.03 ms / 412.43 ms 記憶體: -0.001 MB / 26.91 MB Application: beforeRenderModule mod_jxtc_lightbox (WEchat QR)

時間: 0.70 ms / 413.13 ms 記憶體: 0.013 MB / 26.92 MB Application: afterRenderModule mod_jxtc_lightbox (WEchat QR)

時間: 0.06 ms / 413.19 ms 記憶體: -0.001 MB / 26.92 MB Application: beforeRenderModule mod_custom (網上訂購即享8折,訂滿1980再折)

時間: 0.22 ms / 413.41 ms 記憶體: 0.003 MB / 26.92 MB Application: afterRenderModule mod_custom (網上訂購即享8折,訂滿1980再折)

時間: 0.03 ms / 413.45 ms 記憶體: 0.000 MB / 26.92 MB Application: beforeRenderModule mod_virtuemart_search (產品搜尋 Virtuemart)

時間: 2.98 ms / 416.42 ms 記憶體: 0.112 MB / 27.03 MB Application: afterRenderModule mod_virtuemart_search (產品搜尋 Virtuemart)

時間: 0.07 ms / 416.49 ms 記憶體: -0.002 MB / 27.03 MB Application: beforeRenderModule mod_custom (logo)

時間: 0.24 ms / 416.72 ms 記憶體: 0.003 MB / 27.03 MB Application: afterRenderModule mod_custom (logo)

時間: 0.04 ms / 416.77 ms 記憶體: 0.004 MB / 27.04 MB Application: beforeRenderModule mod_sclogin (會員登入)

時間: 3.59 ms / 420.36 ms 記憶體: 0.154 MB / 27.19 MB Application: afterRenderModule mod_sclogin (會員登入)

時間: 0.04 ms / 420.40 ms 記憶體: -0.009 MB / 27.18 MB Application: beforeRenderModule mod_menu (Main Menu)

時間: 7.54 ms / 427.94 ms 記憶體: 0.253 MB / 27.44 MB Application: afterRenderModule mod_menu (Main Menu)

時間: 6.53 ms / 434.47 ms 記憶體: 0.209 MB / 27.65 MB Application: afterRender

資料庫查詢總計: 94.42 ms

記憶體使用量

資料庫查詢

82 查詢記錄 94.42 ms

2 重覆被找到!

2 重覆: #19 #82

查詢時間: 0.44 ms 查詢記憶體: 0.026 MB 記憶體於查詢: 3.573 MB 前回傳的列: 1

SELECT `data`

  FROM `b1h4c_session`

  WHERE `session_id` = X'3566633938636539393565656235353965343930663466623030396661623337'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_session	const	PRIMARY	PRIMARY	194	const	1

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

查詢時間: 0.73 ms 最後的查詢: 3.44 ms 之後查詢記憶體: 0.044 MB 記憶體於查詢: 3.940 MB 前回傳的列: 65

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `b1h4c_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

說明

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

側寫

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.28 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	與下面行一樣的呼叫
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.32 ms 最後的查詢: 2.36 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 4.159 MB 前回傳的列: 3

SELECT id, rules

  FROM `b1h4c_viewlevels`

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 4.171 MB 前回傳的列: 1

SELECT b.id

  FROM b1h4c_usergroups AS a

  LEFT JOIN b1h4c_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

說明

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	Using where; Using index

側寫

Status	Duration
starting	0.03 ms
checking permissions	0.01 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.19 ms 最後的查詢: 0.61 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 4.237 MB 前回傳的列: 129

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM b1h4c_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

說明

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

側寫

Status	Duration
starting	0.04 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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sorting result	0.53 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	與下面行一樣的呼叫
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 2.44 ms 最後的查詢: 27.25 ms 之後查詢記憶體: 0.692 MB 記憶體於查詢: 6.578 MB 前回傳的列: 197

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 b1h4c_menu AS m

  LEFT JOIN b1h4c_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	295	Using index condition; Using where; 使用filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	thebest1_25896q.m.component_id	1	Using where

側寫

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.90 ms
Sending data	1.00 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	與下面行一樣的呼叫
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.38 ms 最後的查詢: 40.42 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 11.085 MB 前回傳的列: 1

SHOW TABLES LIKE "b1h4c_virtuemart_configs"

說明

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

側寫

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Filling schema table	0.01 ms
checking permissions	0.82 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:727
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:580
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:415
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.41 ms 最後的查詢: 0.54 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 11.131 MB 前回傳的列: 1

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

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:455
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.47 ms 最後的查詢: 1.24 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 11.249 MB 前回傳的列: 1

SELECT *

  FROM b1h4c_languages

  WHERE published=1

  ORDER BY ordering ASC

說明

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

側寫

Status	Duration
starting	0.03 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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:98
14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:62
13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:476
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.19 ms 最後的查詢: 0.61 ms 之後查詢記憶體: 0.032 MB 記憶體於查詢: 11.348 MB 前回傳的列: 46

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `b1h4c_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_admin','com_admirorgallery','com_ajax','com_allvideoshare','com_associations','com_awocoupon','com_aworewards','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_fields','com_finder','com_flexicontact','com_installer','com_jce','com_jcrawler','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_phocafont','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	391	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.07 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.62 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:477
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:947
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.56 ms 最後的查詢: 1.80 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 11.442 MB 前回傳的列: 6

SELECT id, home, template, s.params

  FROM b1h4c_template_styles as s

  LEFT JOIN b1h4c_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,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	thebest1_25896q.s.template,const	1	Using index condition; Using where

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:852
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:970
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.48 ms 最後的查詢: 0.37 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 11.471 MB 前回傳的列: 2

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

說明

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

側寫

Status	Duration
starting	0.04 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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	1.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1405
14	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:920
13	vmrouterHelper->setRoutingQuery()	JROOT/components/com_virtuemart/router.php:898
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:970
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:374
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.34 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 11.481 MB 前回傳的列: 1

SELECT l.virtuemart_vendor_id  
  FROM `b1h4c_virtuemart_vendors_zh_tw` as l  
  WHERE l.slug = "the-best-beauty-salon"

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1333
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1303
11	vmrouterHelper->getVendorId()	JROOT/components/com_virtuemart/router.php:518
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.44 ms 最後的查詢: 4.52 ms 之後查詢記憶體: 0.035 MB 記憶體於查詢: 11.844 MB 前回傳的列: 79

SELECT id,name,is_json,value 
  FROM b1h4c_aworewards_config

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_aworewards/helper/class-aworewards-helper-database.php:25
12	AwoRewards_Helper_Database->get_objectlist()	JROOT/administrator/components/com_aworewards/aworewards/library/class-aworewards-library-param.php:31
11	AwoRewards_Library_Param->__construct()	JROOT/administrator/components/com_aworewards/aworewards/library/class-aworewards-library-helper.php:498
10	AwoRewards_Library_Helper->new_class()	JROOT/administrator/components/com_aworewards/helper/aworewards.php:66
9	AwoRewards->init()	JROOT/plugins/system/aworewards/aworewards.php:37
8	plgSystemAwoRewards->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.41 ms 最後的查詢: 10.67 ms 之後查詢記憶體: 0.037 MB 記憶體於查詢: 12.878 MB 前回傳的列: 91

SELECT id,name,is_json,value 
  FROM b1h4c_awocoupon_config

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_awocoupon/helper/class-awocoupon-helper-database.php:25
17	AwoCoupon_Helper_Database->get_objectlist()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-param.php:31
16	Awocoupon_Library_Param->__construct()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-helper.php:460
15	AwoCoupon_Library_Helper->new_class()	JROOT/administrator/components/com_awocoupon/helper/awocoupon.php:73
14	AwoCoupon->init()	JROOT/administrator/components/com_aworewards/helper/class-aworewards-helper-helper.php:77
13	AwoRewards_Helper_Helper->is_awocoupon_installed()	JROOT/administrator/components/com_aworewards/aworewards/library/class-aworewards-library-reward.php:47
12	AwoRewards_Library_Reward->__construct()	JROOT/administrator/components/com_aworewards/helper/estore/virtuemart/class-aworewards-helper-estore-virtuemart-reward.php:21
11	Aworewards_Helper_Estore_Virtuemart_Reward->__construct()	JROOT/administrator/components/com_aworewards/aworewards/library/class-aworewards-library-helper.php:498
10	AwoRewards_Library_Helper->new_class()	JROOT/administrator/components/com_aworewards/helper/aworewards.php:82
9	AwoRewards->init()	JROOT/plugins/system/aworewards/aworewards.php:37
8	plgSystemAwoRewards->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.87 ms 最後的查詢: 14.86 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 14.349 MB 前回傳的列: 1

SHOW FULL COLUMNS 
  FROM b1h4c_awocoupon LIKE "coupon_code"

說明

EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM b1h4c_awocoupon LIKE "coupon_code"

側寫

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.31 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_awocoupon/helper/class-awocoupon-helper-database.php:32
19	AwoCoupon_Helper_Database->get_object()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-coupon.php:330
18	AwoCoupon_Library_Coupon->is_case_sensitive()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-discount.php:84
17	AwoCoupon_Library_Discount->__construct()	JROOT/administrator/components/com_awocoupon/helper/estore/virtuemart/class-awocoupon-helper-estore-virtuemart-discount.php:39
16	AwoCoupon_Helper_Estore_Virtuemart_Discount->__construct()	JROOT/administrator/components/com_awocoupon/awocoupon/library/class-awocoupon-library-helper.php:460
15	AwoCoupon_Library_Helper->new_class()	JROOT/administrator/components/com_awocoupon/helper/awocoupon.php:91
14	AwoCoupon->init()	JROOT/administrator/components/com_aworewards/helper/class-aworewards-helper-helper.php:77
13	AwoRewards_Helper_Helper->is_awocoupon_installed()	JROOT/administrator/components/com_aworewards/aworewards/library/class-aworewards-library-reward.php:47
12	AwoRewards_Library_Reward->__construct()	JROOT/administrator/components/com_aworewards/helper/estore/virtuemart/class-aworewards-helper-estore-virtuemart-reward.php:21
11	Aworewards_Helper_Estore_Virtuemart_Reward->__construct()	JROOT/administrator/components/com_aworewards/aworewards/library/class-aworewards-library-helper.php:498
10	AwoRewards_Library_Helper->new_class()	JROOT/administrator/components/com_aworewards/helper/aworewards.php:82
9	AwoRewards->init()	JROOT/plugins/system/aworewards/aworewards.php:37
8	plgSystemAwoRewards->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.42 ms 最後的查詢: 10.25 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 15.365 MB 前回傳的列: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `b1h4c_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

說明

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

側寫

Status	Duration
starting	0.04 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	與下面行一樣的呼叫
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/aworewards/aworewards.php:85
9	plgSystemAwoRewards->check_cron()	JROOT/plugins/system/aworewards/aworewards.php:40
8	plgSystemAwoRewards->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 7.96 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.006 MB 記憶體於查詢: 15.359 MB 前

UPDATE `b1h4c_extensions`

  SET `params` = '{\"mediaversion\":\"24f874919004cbd001d0f48359eb88bb\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.06 ms
updating	0.06 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	7.60 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/aworewards/aworewards.php:85
9	plgSystemAwoRewards->check_cron()	JROOT/plugins/system/aworewards/aworewards.php:40
8	plgSystemAwoRewards->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.81 ms 最後的查詢: 2.55 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 15.526 MB 前回傳的列: 238

重覆查詢: #82

SHOW TABLES

說明

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

側寫

Status	Duration
starting	0.03 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
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Filling schema table	0.01 ms
checking permissions	1.25 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:120
10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.43 ms 最後的查詢: 0.72 ms 之後查詢記憶體: 0.032 MB 記憶體於查詢: 15.561 MB 前回傳的列: 119

SELECT * 
  FROM b1h4c_acym_configuration

說明

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

側寫

Status	Duration
starting	0.02 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
14	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:15
13	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:35
12	acym_config()	JROOT/administrator/components/com_acym/libraries/object.php:14
11	AcyMailing\Libraries\acymObject->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:62
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.33 ms 最後的查詢: 0.15 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 15.635 MB 前回傳的列: 2

SELECT * 
  FROM b1h4c_acym_plugin

說明

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

側寫

Status	Duration
starting	0.02 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
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:62
11	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:63
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 2.44 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 15.893 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'amazon'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/amazon/plugin.php:13
11	plgAcymAmazon->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 0.75 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 15.976 MB 前回傳的列: 1

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'article'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/article/plugin.php:13
11	plgAcymArticle->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.35 ms 最後的查詢: 0.04 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 15.983 MB 前回傳的列: 31

SHOW COLUMNS 
  FROM b1h4c_content

說明

EXPLAIN 無法被使用於查詢: SHOW COLUMNS FROM b1h4c_content

側寫

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:70
14	acym_loadResultArray()	JROOT/administrator/components/com_acym/helpers/global/query.php:15
13	acym_getColumns()	JROOT/administrator/components/com_acym/dynamics/article/plugin.php:81
12	plgAcymArticle->initElementOptionsCustomView()	JROOT/administrator/components/com_acym/dynamics/article/plugin.php:31
11	plgAcymArticle->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.36 ms 最後的查詢: 0.94 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.095 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'birthday'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
13	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
12	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
11	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.43 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.139 MB 前回傳的列: 1

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'createuser'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/createuser/plugin.php:9
11	plgAcymcreateuser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 40.33 ms 最後的查詢: 0.04 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 16.146 MB 前回傳的列: 8

SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`, COUNT(ugm.user_id) AS nbusers 
        
  FROM b1h4c_usergroups AS `groups` 
        
  LEFT JOIN b1h4c_user_usergroup_map ugm 
  ON `groups`.id = ugm.group_id 
        
  GROUP BY `groups`.id

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	groups	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using temporary; 使用filesort
1	SIMPLE	ugm	index	NULL	PRIMARY	8	NULL	22904	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	39.78 ms
Sorting result	0.04 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/user.php:44
12	acym_getGroups()	JROOT/administrator/components/com_acym/dynamics/createuser/plugin.php:12
11	plgAcymcreateuser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.64 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.178 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'elasticemail'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.05 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/elasticemail/plugin.php:12
11	plgAcymElasticemail->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.80 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.219 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'mailgun'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/mailgun/plugin.php:16
11	plgAcymMailgun->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.51 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.248 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'online'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.03 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.02 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/online/plugin.php:9
11	plgAcymOnline->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.35 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.269 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'override'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/override/plugin.php:21
11	plgAcymOverride->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 0.22 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.286 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'phpmail'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/phpmail/plugin.php:12
11	plgAcymPhpmail->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.36 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 16.324 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'postmark'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/postmark/plugin.php:13
11	plgAcymPostmark->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.20 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.342 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'qmail'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/qmail/plugin.php:12
11	plgAcymQmail->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 0.43 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.439 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'sendgrid'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendgrid/plugin.php:13
11	plgAcymSendgrid->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.33 ms 最後的查詢: 0.43 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.480 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'sendinblue'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:22
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 1.27 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 16.600 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'luecredentials'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
15	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
14	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
13	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
12	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:34
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 16.610 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'lueintegration'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
15	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
14	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
13	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
12	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:37
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.32 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 16.621 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'luetransactional'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
15	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
14	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
13	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
12	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:38
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 16.631 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'luelist'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
15	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
14	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
13	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
12	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:39
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.12 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 16.642 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'lueusers'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
16	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
15	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
14	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
13	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/users.php:11
12	SendinblueUsers->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:40
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 16.653 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'luesender'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
15	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
14	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
13	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
12	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:41
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 0.12 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 16.663 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'luecampaign'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
16	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
15	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
14	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/sendinblue.php:12
13	SendinblueClass->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/campaign.php:12
12	SendinblueCampaign->__construct()	JROOT/administrator/components/com_acym/dynamics/sendinblue/plugin.php:42
11	plgAcymSendinblue->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.25 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.684 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'sendmail'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/sendmail/plugin.php:12
11	plgAcymSendmail->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 0.35 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.715 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'smtp'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/smtp/plugin.php:12
11	plgAcymSmtp->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.54 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.765 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'statistics'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
13	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
12	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
11	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 1.62 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 16.916 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'subscriber'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/subscriber/plugin.php:32
11	plgAcymSubscriber->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 1.76 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 17.087 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'subscription'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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.02 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/subscription/plugin.php:26
11	plgAcymSubscription->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.63 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 17.152 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'time'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	0.02 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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/time/plugin.php:9
11	plgAcymTime->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.36 ms 最後的查詢: 1.09 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 17.261 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'user'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
14	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
13	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
12	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/dynamics/user/plugin.php:14
11	plgAcymUser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.35 ms 最後的查詢: 0.90 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 17.336 MB 前回傳的列: 0

SELECT settings 
  FROM b1h4c_acym_plugin 
  WHERE folder_name = 'managetext'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

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

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:57
13	acym_loadResult()	JROOT/administrator/components/com_acym/classes/plugin.php:31
12	AcyMailing\Classes\PluginClass->getSettings()	JROOT/administrator/components/com_acym/libraries/plugin.php:78
11	AcyMailing\Libraries\acymPlugin->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:91
10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:14
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:291
8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.38 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 17.339 MB 前回傳的列: 1

SELECT manifest_cache

  FROM b1h4c_extensions

  WHERE element LIKE 'jsn_epic_pro'

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.45 ms 最後的查詢: 16.12 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 17.742 MB 前回傳的列: 1

SELECT COUNT(*)

  FROM b1h4c_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

說明

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

側寫

Status	Duration
starting	0.04 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
After opening tables	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
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/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.98 ms 最後的查詢: 13.82 ms 之後查詢記憶體: 0.131 MB 記憶體於查詢: 18.725 MB 前回傳的列: 1

SELECT `b1h4c_virtuemart_vendors`.* ,`b1h4c_virtuemart_vendors_zh_tw`.*  
  FROM `b1h4c_virtuemart_vendors` 
  INNER JOIN `b1h4c_virtuemart_vendors_zh_tw` 
  ON `b1h4c_virtuemart_vendors`.`virtuemart_vendor_id` = `b1h4c_virtuemart_vendors_zh_tw`.`virtuemart_vendor_id`  
  WHERE `b1h4c_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

說明

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

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.52 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:84
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/vendor/view.html.php:65
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.39 ms 最後的查詢: 0.87 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 18.885 MB 前回傳的列: 1

SELECT `virtuemart_media_id` 
  FROM `b1h4c_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	b1h4c_virtuemart_vendor_medias	system	virtuemart_vendor_id	NO INDEX KEY COULD BE USED	NULL	NULL	1

側寫

Status	Duration
starting	0.07 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:95
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/vendor/view.html.php:65
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.40 ms 最後的查詢: 1.31 ms 之後查詢記憶體: 0.032 MB 記憶體於查詢: 18.998 MB 前回傳的列: 1

SELECT `b1h4c_virtuemart_medias`.*  
  FROM `b1h4c_virtuemart_medias`  
  WHERE `b1h4c_virtuemart_medias`.`virtuemart_media_id` = "22"

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:484
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/vendor/view.html.php:66
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 3.23 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 19.224 MB 前回傳的列: 1

SELECT l.slug  
  FROM `b1h4c_virtuemart_vendors_zh_tw` as l  
  WHERE l.virtuemart_vendor_id = "1"

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1333
19	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1298
18	vmrouterHelper->getVendorName()	JROOT/components/com_virtuemart/router.php:307
17	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/vendor/view.html.php:123
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.35 ms 最後的查詢: 3.19 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 19.492 MB 前回傳的列: 2

SELECT `virtuemart_user_id` 
  FROM `b1h4c_virtuemart_vmusers` 
  WHERE `virtuemart_vendor_id`=1

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_virtuemart_vmusers	ref	virtuemart_vendor_id	virtuemart_vendor_id	4	const	2	Using index

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/vendor.php:159
15	VirtueMartModelVendor::getUserIdByVendorId()	JROOT/administrator/components/com_virtuemart/models/vendor.php:500
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.44 ms 最後的查詢: 2.70 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 19.740 MB 前回傳的列: 1

SELECT `virtuemart_userinfo_id` 
  FROM `b1h4c_virtuemart_userinfos` 
  WHERE `virtuemart_user_id` = "801" 
  AND `address_type`="BT"

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_virtuemart_userinfos	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	138	Using where

側寫

Status	Duration
starting	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
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/user.php:1311
15	VirtueMartModelUser->getBTuserinfo_id()	JROOT/administrator/components/com_virtuemart/models/vendor.php:502
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.49 ms 最後的查詢: 2.78 ms 之後查詢記憶體: 0.040 MB 記憶體於查詢: 19.943 MB 前回傳的列: 32

SHOW FULL COLUMNS  
  FROM `b1h4c_virtuemart_userfields`

說明

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

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.02 ms
Opening tables	0.30 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:688
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:211
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559
16	VmModel::getModel()	JROOT/administrator/components/com_virtuemart/models/user.php:1322
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.60 ms 最後的查詢: 0.15 ms 之後查詢記憶體: 0.048 MB 記憶體於查詢: 20.004 MB 前回傳的列: 14

SELECT * 
  FROM `b1h4c_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

說明

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

側寫

Status	Duration
starting	0.04 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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.12 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:485
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/administrator/components/com_virtuemart/models/user.php:1323
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.52 ms 最後的查詢: 52.38 ms 之後查詢記憶體: 0.035 MB 記憶體於查詢: 23.220 MB 前回傳的列: 28

SHOW FULL COLUMNS  
  FROM `b1h4c_virtuemart_userinfos`

說明

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

側寫

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:688
20	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userinfos.php:67
19	TableUserinfos->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:211
18	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
17	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
16	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/models/user.php:1345
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 23.276 MB 前回傳的列: 1

SELECT `b1h4c_virtuemart_userinfos`.*  
  FROM `b1h4c_virtuemart_userinfos`  
  WHERE `b1h4c_virtuemart_userinfos`.`virtuemart_userinfo_id` = "1"

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_virtuemart_userinfos	const	PRIMARY,idx_userinfo_virtuemart_user_id	PRIMARY	4	const	1

側寫

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

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/user.php:1346
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.10 ms 最後的查詢: 1.91 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 23.480 MB 前回傳的列: 16

SHOW FULL COLUMNS 
  FROM `b1h4c_users`

說明

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

側寫

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.23 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/administrator/components/com_virtuemart/models/user.php:1348
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.037 MB 記憶體於查詢: 23.531 MB 前回傳的列: 1

SELECT *

  FROM `b1h4c_users`

  WHERE `id` = 801

說明

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

側寫

Status	Duration
starting	0.03 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/administrator/components/com_virtuemart/models/user.php:1348
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.44 ms 最後的查詢: 3.21 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 24.286 MB 前回傳的列: 1

SELECT `g`.`id`,`g`.`title`

  FROM `b1h4c_usergroups` AS g

  INNER JOIN `b1h4c_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 801

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	thebest1_25896q.m.group_id	1

側寫

Status	Duration
starting	0.04 ms
checking permissions	0.01 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/administrator/components/com_virtuemart/models/user.php:1348
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.43 ms 最後的查詢: 0.19 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 24.312 MB 前回傳的列: 3

SELECT `fieldtitle`, `fieldvalue` 
  FROM `b1h4c_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 10 
  ORDER BY `ordering`

說明

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

側寫

Status	Duration
starting	0.04 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1053
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/administrator/components/com_virtuemart/models/user.php:1441
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.41 ms 最後的查詢: 2.70 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 24.470 MB 前回傳的列: 1

SELECT *  
  FROM `b1h4c_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY ordering, country_name ASC

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.02 ms
Sorting result	0.04 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:869
19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:142
18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:145
17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:855
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/administrator/components/com_virtuemart/models/user.php:1441
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.34 ms 最後的查詢: 0.18 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 24.488 MB 前回傳的列: 1

SELECT `b1h4c_virtuemart_countries`.*  
  FROM `b1h4c_virtuemart_countries`  
  WHERE `b1h4c_virtuemart_countries`.`virtuemart_country_id` = "96"

說明

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

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/userfields.php:863
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/administrator/components/com_virtuemart/models/user.php:1441
15	VirtueMartModelUser->getUserInfoInUserFields()	JROOT/administrator/components/com_virtuemart/models/vendor.php:507
14	VirtueMartModelVendor->getVendorAddressFields()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:316
13	shopFunctionsF::renderVendorAddress()	JROOT/components/com_virtuemart/views/vendor/tmpl/details.php:35
12	include JROOT/components/com_virtuemart/views/vendor/tmpl/details.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:52
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.40 ms 最後的查詢: 0.77 ms 之後查詢記憶體: 0.032 MB 記憶體於查詢: 24.582 MB 前回傳的列: 1

SELECT * 
  FROM `b1h4c_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	b1h4c_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	1	Using where

側寫

Status	Duration
starting	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.02 ms
After opening tables	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
16	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
15	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:186
14	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
13	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:177
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:69
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:59
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.34 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.033 MB 記憶體於查詢: 24.609 MB 前回傳的列: 1

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

說明

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

側寫

Status	Duration
starting	0.03 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
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061
19	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024
18	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
17	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
16	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
15	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:186
14	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
13	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:177
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:69
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:59
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.56 ms 最後的查詢: 0.25 ms 之後查詢記憶體: 0.042 MB 記憶體於查詢: 24.630 MB 前回傳的列: 7

SELECT * 
  FROM `b1h4c_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	b1h4c_virtuemart_userfields	ref	published,shipment	shipment	1	const	7	Using where; 使用filesort

側寫

Status	Duration
starting	0.04 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
After opening tables	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.03 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
16	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
15	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:491
14	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:386
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:232
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:69
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:59
10	VmView->display()	JROOT/components/com_virtuemart/views/vendor/view.html.php:132
9	VirtuemartViewVendor->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:115
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.43 ms 最後的查詢: 0.87 ms 之後查詢記憶體: 0.033 MB 記憶體於查詢: 24.654 MB 前回傳的列: 0

SELECT folder.*

  FROM `b1h4c_eventgallery_folder` AS folder

  LEFT JOIN `b1h4c_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

  WHERE file.file IS NULL 
  AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	folder	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	file	ref	file,index_folder	file	377	thebest1_25896q.folder.folder	12	Using where; Not exists

側寫

Status	Duration
starting	0.04 ms
checking permissions	0.01 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.02 ms
After opening tables	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/picasaupdater/picasaupdater.php:78
7	plgSystemPicasaupdater->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.66 ms 最後的查詢: 7.09 ms 之後查詢記憶體: 0.307 MB 記憶體於查詢: 25.113 MB 前回傳的列: 556

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM b1h4c_modules AS m

  LEFT JOIN b1h4c_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN b1h4c_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 <= '2026-07-07 22:26:31') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-07 22:26:31') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	30	Using index condition; Using where; 使用filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	thebest1_25896q.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	thebest1_25896q.m.id	14	Using where; Using index

側寫

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
After opening tables	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.22 ms
Sending data	0.93 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:498
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/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 4.98 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 25.391 MB 前回傳的列: 0

SELECT m.id

  FROM b1h4c_modules AS m

  INNER JOIN b1h4c_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 = 0) 
  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	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

側寫

Status	Duration
starting	0.06 ms
checking permissions	0.01 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
After opening tables	0.01 ms
init	0.05 ms
optimizing	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:737
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
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:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
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/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.62 ms 最後的查詢: 0.06 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 25.399 MB 前回傳的列: 0

SELECT m.id

  FROM b1h4c_modules AS m

  INNER JOIN b1h4c_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 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != 0)) 
  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	ref	PRIMARY,published,newsfeeds	published	1	const	40	Using where; Using temporary; 使用filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	thebest1_25896q.m.id	14	Using where; Using index

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	0.08 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:758
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
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:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
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/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.35 ms 最後的查詢: 18.03 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 26.527 MB 前回傳的列: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM b1h4c_fields AS a

  LEFT JOIN `b1h4c_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN b1h4c_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN b1h4c_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN b1h4c_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN b1h4c_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; 使用filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	thebest1_25896q.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	thebest1_25896q.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	thebest1_25896q.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	thebest1_25896q.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	thebest1_25896q.a.group_id	1	Using where

側寫

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.01 ms
Copying to tmp table	0.46 ms
Copying to tmp table	0.04 ms
Sorting result	0.02 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	與下面行一樣的呼叫
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.39 ms 最後的查詢: 4.50 ms 之後查詢記憶體: 0.033 MB 記憶體於查詢: 26.908 MB 前回傳的列: 2

SELECT * 
  FROM b1h4c_acym_list 
  WHERE type = 'standard'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_list	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
23	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:502
22	AcyMailing\Classes\ListClass->getAllWithoutManagement()	JROOT/modules/mod_acym/mod_acym.php:37
21	include JROOT/modules/mod_acym/mod_acym.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
18	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
17	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	與下面行一樣的呼叫
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.41 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 26.924 MB 前回傳的列: 2

SELECT * 
  FROM b1h4c_acym_field 
  WHERE `id` IN(1,2) 
  ORDER BY `ordering` ASC

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_field	range	PRIMARY	PRIMARY	4	NULL	2	Using where; 使用filesort

側寫

Status	Duration
starting	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.02 ms
After opening tables	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:31
23	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/field.php:46
22	AcyMailing\Classes\FieldClass->getFieldsByID()	JROOT/modules/mod_acym/mod_acym.php:40
21	include JROOT/modules/mod_acym/mod_acym.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
20	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
19	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
18	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
17	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	與下面行一樣的呼叫
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.34 ms 最後的查詢: 3.33 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 26.937 MB 前回傳的列: 1

SELECT link 
  from b1h4c_menu 
  WHERE id='417'

說明

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

側寫

Status	Duration
starting	0.03 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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/modules/mod_jxtc_lightbox/mod_jxtc_lightbox.php:53
10	include JROOT/modules/mod_jxtc_lightbox/mod_jxtc_lightbox.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.51 ms 最後的查詢: 17.81 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 27.632 MB 前回傳的列: 1

SELECT `value` 
  FROM b1h4c_acym_configuration 
  WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b1h4c_acym_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	119	Using where

側寫

Status	Duration
starting	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
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 ms

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/acymtriggers/acymtriggers.php:148
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:141
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.79 ms 最後的查詢: 0.05 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 27.637 MB 前回傳的列: 238

重覆查詢: #19

SHOW TABLES

說明

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

側寫

Status	Duration
starting	0.03 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
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	1.24 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:120
10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:185
8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:141
7	plgSystemAcymtriggers->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

51 查詢種類已記錄，由呈現記錄儲存。

選擇表格:

28 × SELECT settings 
  FROM b1h4c_acym_plugin

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `b1h4c_extensions`

2 × SELECT * 
  FROM `b1h4c_virtuemart_userfields`

2 × SELECT m.id 
  FROM b1h4c_modules AS m 
  INNER JOIN b1h4c_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT *  
  FROM `b1h4c_virtuemart_countries`

1 × SELECT `virtuemart_user_id` 
  FROM `b1h4c_virtuemart_vmusers`

1 × SELECT `virtuemart_userinfo_id` 
  FROM `b1h4c_virtuemart_userinfos`

1 × SELECT `b1h4c_virtuemart_userinfos`.*  
  FROM `b1h4c_virtuemart_userinfos`

```
1 × SELECT * 
  FROM `b1h4c_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `b1h4c_usergroups` AS g 
  INNER JOIN `b1h4c_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `b1h4c_virtuemart_userfield_values`

1 × SELECT `data` 
  FROM `b1h4c_session`

1 × SELECT l.slug  
  FROM `b1h4c_virtuemart_vendors_zh_tw` as l

1 × SELECT * 
  FROM `b1h4c_virtuemart_shoppergroups`

1 × SELECT `b1h4c_virtuemart_shoppergroups`.*  
  FROM `b1h4c_virtuemart_shoppergroups`

1 × SELECT folder.* 
  FROM `b1h4c_eventgallery_folder` AS folder 
  LEFT JOIN `b1h4c_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM b1h4c_modules AS m 
  LEFT JOIN b1h4c_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN b1h4c_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM b1h4c_fields AS a 
  LEFT JOIN `b1h4c_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN b1h4c_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN b1h4c_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN b1h4c_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN b1h4c_fields_groups AS g 
  ON g.id = a.group_id

```
1 × SELECT * 
  FROM b1h4c_acym_list
```
```
1 × SELECT * 
  FROM b1h4c_acym_field
```
```
1 × SELECT link 
  from b1h4c_menu
```

1 × SELECT `b1h4c_virtuemart_countries`.*  
  FROM `b1h4c_virtuemart_countries`

1 × SELECT `virtuemart_media_id` 
  FROM `b1h4c_virtuemart_vendor_medias`

1 × SELECT `b1h4c_virtuemart_medias`.*  
  FROM `b1h4c_virtuemart_medias`

1 × SELECT id, home, template, s.params 
  FROM b1h4c_template_styles as s 
  LEFT JOIN b1h4c_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT id, rules 
  FROM `b1h4c_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM b1h4c_extensions

1 × 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 b1h4c_menu AS m 
  LEFT JOIN b1h4c_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `config` 
  FROM `b1h4c_virtuemart_configs`

```
1 × SELECT * 
  FROM b1h4c_languages
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `b1h4c_assets`

```
1 × SELECT * 
  FROM `b1h4c_menu`
```

1 × SELECT `b1h4c_virtuemart_vendors`.* ,`b1h4c_virtuemart_vendors_zh_tw`.*  
  FROM `b1h4c_virtuemart_vendors` 
  INNER JOIN `b1h4c_virtuemart_vendors_zh_tw` 
  ON `b1h4c_virtuemart_vendors`.`virtuemart_vendor_id` = `b1h4c_virtuemart_vendors_zh_tw`.`virtuemart_vendor_id`

1 × SELECT l.virtuemart_vendor_id  
  FROM `b1h4c_virtuemart_vendors_zh_tw` as l

1 × SELECT id,name,is_json,value 
  FROM b1h4c_aworewards_confi

1 × SELECT id,name,is_json,value 
  FROM b1h4c_awocoupon_confi

1 × SELECT * 
  FROM b1h4c_acym_configuratio

```
1 × SELECT * 
  FROM b1h4c_acym_plugi
```

1 × SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`, COUNT(ugm.user_id) AS nbusers          
  FROM b1h4c_usergroups AS `groups`          
  LEFT JOIN b1h4c_user_usergroup_map ugm 
  ON `groups`.id = ugm.group_id          
  GROUP BY `groups`.i

1 × SELECT manifest_cache 
  FROM b1h4c_extensions

1 × SELECT COUNT(*) 
  FROM b1h4c_extensions

1 × SELECT `value` 
  FROM b1h4c_acym_configuration

其他表格:

```
2 × SHOW TABLE
```

1 × SHOW TABLES LIKE "b1h4c_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM b1h4c_awocoupon LIKE "coupon_code

1 × UPDATE `b1h4c_extensions` 
  SET `params` = '{\"mediaversion\":\"24f874919004cbd001d0f48359eb88bb\"}'

```
1 × SHOW COLUMNS 
  FROM b1h4c_conten
```

1 × SHOW FULL COLUMNS  
  FROM `b1h4c_virtuemart_userfields

1 × SHOW FULL COLUMNS  
  FROM `b1h4c_virtuemart_userinfos

1 × SHOW FULL COLUMNS 
  FROM `b1h4c_users