新聞動態

INNOVACAR Authorized Detailer 18-19/9/2023

: on 10 十月 2023; 點擊數: 125; Comment (0) Hits: 125

INNOVACAR Authorized Detailer 18,19-9-2023

意大利美容品牌INNOVACAR一連兩日在洪水橋舉行美容証書課程，本司引入最新自我修服鍍膜，特別邀請意大利INNOVACAR總技術總監作培訓，完成後更可獲証書認証，產品及施工商都可以得到保証！

INNOVACAR Open Training Day 17-9-2023

: on 10 十月 2023; 點擊數: 121; Comment (0) Hits: 121

意大利 INNOVACAR頂級汽車美容產品技術總監來港舉行車主用家Open Training Day

16-17/9/2023 中山美食兩天團

: on 10 十月 2023; 點擊數: 122; Comment (0) Hits: 122

德泰有限公司-「識德有著數」一直以來注重與客戶之間的關係，務求達至「以樂會友」，並希望能夠促進業界同業互相交流、增進友誼

與我們聯繫

香港新界沙田火炭山尾街43-47號環球工業中心1307-1308室
電話: (852) 2699-1282
傳真: (852) 2699-0708

電郵: Email住址會使用灌水程式保護機制。你需要啟動Javascript才能觀看它

Joomla! 除錯主控台

連線階段 (Session)

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

側寫資訊

時間

記憶體

時間: 14.81 ms / 14.81 ms 記憶體: 0.550 MB / 0.93 MB Application: afterLoad

時間: 52.39 ms / 67.20 ms 記憶體: 3.390 MB / 4.32 MB Application: JD-Framework-Before-Load

時間: 6.05 ms / 73.25 ms 記憶體: 0.037 MB / 4.36 MB Application: JD-Framework-After-Load

時間: 12.04 ms / 85.28 ms 記憶體: 0.992 MB / 5.35 MB Application: afterInitialise

時間: 26.81 ms / 112.09 ms 記憶體: 1.196 MB / 6.55 MB Application: afterRoute

時間: 5.50 ms / 117.59 ms 記憶體: 0.198 MB / 6.75 MB Application: beforeRenderComponent com_content

時間: 10.83 ms / 128.43 ms 記憶體: 0.730 MB / 7.48 MB Application: Start JAccess::getAssetRules Old (1)

時間: 1.16 ms / 129.58 ms 記憶體: 0.033 MB / 7.51 MB Application: Finish JAccess::getAssetRules Old (1)

時間: 0.03 ms / 129.62 ms 記憶體: 0.000 MB / 7.50 MB Application: New JAccess Preloading Process(com_content.category)

時間: 0.59 ms / 130.20 ms 記憶體: 0.069 MB / 7.57 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

時間: 1.37 ms / 131.58 ms 記憶體: 0.106 MB / 7.68 MB Application: After preloadPermissions (com_content.category)

時間: 0.01 ms / 131.59 ms 記憶體: 0.001 MB / 7.68 MB Application: End New JAccess Preloading Process(com_content.category)

時間: 0.01 ms / 131.60 ms 記憶體: 0.001 MB / 7.68 MB Application: Start JAccess::getAssetRules New (com_content.category.8)

時間: 0.04 ms / 131.65 ms 記憶體: 0.007 MB / 7.69 MB Application: Finish JAccess::getAssetRules New (com_content.category.8)

時間: 5.94 ms / 137.58 ms 記憶體: 0.254 MB / 7.94 MB Application: Start JAccess::preload(components)

時間: 2.11 ms / 139.69 ms 記憶體: 0.206 MB / 8.15 MB Application: Finish JAccess::preload(components)

時間: 86.49 ms / 226.19 ms 記憶體: 2.917 MB / 11.07 MB Application: afterRenderComponent com_content

時間: 7.11 ms / 233.30 ms 記憶體: 0.240 MB / 11.31 MB Application: afterDispatch

時間: 13.13 ms / 246.43 ms 記憶體: 0.301 MB / 11.61 MB Application: beforeRenderModule mod_articles_single (與我們聯繫)

時間: 13.96 ms / 260.39 ms 記憶體: 0.902 MB / 12.51 MB Application: afterRenderModule mod_articles_single (與我們聯繫)

時間: 0.04 ms / 260.44 ms 記憶體: 0.000 MB / 12.48 MB Application: beforeRenderModule mod_menu (footer link)

時間: 4.20 ms / 264.64 ms 記憶體: 0.048 MB / 12.53 MB Application: afterRenderModule mod_menu (footer link)

時間: 0.04 ms / 264.68 ms 記憶體: 0.000 MB / 12.53 MB Application: beforeRenderModule mod_menu (Follow us)

時間: 3.23 ms / 267.92 ms 記憶體: 0.038 MB / 12.56 MB Application: afterRenderModule mod_menu (Follow us)

時間: 0.04 ms / 267.96 ms 記憶體: 0.000 MB / 12.56 MB Application: beforeRenderModule mod_acymailing (Join our newsletter)

時間: 10.38 ms / 278.34 ms 記憶體: 0.692 MB / 13.26 MB Application: afterRenderModule mod_acymailing (Join our newsletter)

時間: 0.08 ms / 278.42 ms 記憶體: 0.000 MB / 13.25 MB Application: beforeRenderModule mod_superfish_menu (主菜单)

時間: 6.39 ms / 284.81 ms 記憶體: 0.048 MB / 13.29 MB Application: afterRenderModule mod_superfish_menu (主菜单)

時間: 0.06 ms / 284.88 ms 記憶體: 0.000 MB / 13.29 MB Application: beforeRenderModule mod_languages (语言切换器)

時間: 4.46 ms / 289.34 ms 記憶體: 0.028 MB / 13.32 MB Application: afterRenderModule mod_languages (语言切换器)

時間: 5.75 ms / 295.08 ms 記憶體: 0.154 MB / 13.47 MB Application: afterRender

資料庫查詢總計: 33.95 ms

記憶體使用量

資料庫查詢

53 查詢記錄 33.95 ms

查詢時間: 0.34 ms 查詢記憶體: 0.024 MB 記憶體於查詢: 2.608 MB 前回傳的列: 0

SELECT `data`

  FROM `dt_session`

  WHERE `session_id` = 'h2ien0lipvffcc7jo7h6laqolt'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_session	const	PRIMARY	PRIMARY	575	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.06 ms
preparing	0.01 ms
executing	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	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	與下面行一樣的呼叫
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

查詢時間: 0.28 ms 最後的查詢: 3.26 ms 之後查詢記憶體: 0.021 MB 記憶體於查詢: 2.743 MB 前回傳的列: 0

SELECT `session_id`

  FROM `dt_session`

  WHERE `session_id` = 'h2ien0lipvffcc7jo7h6laqolt' 
  LIMIT 1

說明

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

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	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	檔案與行號
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

查詢時間: 0.85 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.003 MB 記憶體於查詢: 2.748 MB 前

INSERT INTO `dt_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('h2ien0lipvffcc7jo7h6laqolt', 0, 1, '1701615738', 0, '')

說明

EXPLAIN 無法被使用於查詢: INSERT INTO `dt_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('h2ien0lipvffcc7jo7h6laqolt', 0, 1, '1701615738', 0, '')

側寫

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.00 ms
After opening tables	0.01 ms
init	0.01 ms
update	0.08 ms
end	0.01 ms
query end	0.60 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

查詢時間: 0.58 ms 最後的查詢: 3.17 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 2.974 MB 前回傳的列: 35

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

  FROM `dt_extensions`

  WHERE `type` = 'component'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_extensions	ref	extension	extension	62	const	35	Using index condition

側寫

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

呼叫堆疊

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

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

查詢時間: 0.36 ms 最後的查詢: 1.72 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 3.096 MB 前回傳的列: 2

SELECT b.id

  FROM dt_usergroups AS a

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

  WHERE a.id = 9

說明

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

側寫

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.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.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:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.22 ms 最後的查詢: 0.76 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 3.142 MB 前回傳的列: 5

SELECT id, rules

  FROM `dt_viewlevels`

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.66 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 3.151 MB 前回傳的列: 65

SELECT folder AS type, element AS name, params

  FROM dt_extensions

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

  ORDER BY ordering

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_extensions	ref	extension	extension	62	const	87	Using index condition; Using where; 使用filesort

側寫

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
Sorting result	0.30 ms
Sending data	0.09 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	檔案與行號
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.65 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 3.211 MB 前回傳的列: 2

SELECT *

  FROM dt_languages

  WHERE published=1

  ORDER BY ordering ASC

說明

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

側寫

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.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 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	檔案與行號
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/joomla/language/helper.php:85
4	JLanguageHelper::detectLanguage()	JROOT/libraries/cms/application/site.php:648
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.43 ms 最後的查詢: 25.43 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 4.544 MB 前回傳的列: 2

SELECT element

  FROM dt_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

說明

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

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.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.05 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	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.79 ms 最後的查詢: 6.15 ms 之後查詢記憶體: 0.053 MB 記憶體於查詢: 4.958 MB 前回傳的列: 34

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

  LEFT JOIN dt_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	41	Using index condition; Using where; 使用filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	tecstar_jm8.m.component_id	1	Using 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.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.22 ms
Sending data	0.18 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:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.80 ms 最後的查詢: 13.98 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 6.013 MB 前回傳的列: 2

SHOW FULL COLUMNS 
  FROM `dt_komento_configs`

說明

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

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.29 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.02 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.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 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.01 ms

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/cms/router/site.php:738
6	JRouterSite->getComponentRouter()	JROOT/libraries/cms/router/site.php:123
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM dt_komento_configs

  WHERE `component` = 'com_komento'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	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.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/cms/router/site.php:738
6	JRouterSite->getComponentRouter()	JROOT/libraries/cms/router/site.php:123
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

  FROM `dt_extensions`

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

說明

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

側寫

Status	Duration
starting	0.07 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.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 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:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.95 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.005 MB 記憶體於查詢: 6.573 MB 前

UPDATE `dt_extensions`

  SET `params` = '{\"mediaversion\":\"3a57891dd1b72c2a682f427ff41ce2cf\"}'

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

說明

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

側寫

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.00 ms
After opening tables	0.01 ms
init	0.06 ms
updating	0.06 ms
end	0.01 ms
query end	0.68 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

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

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

查詢時間: 0.42 ms 最後的查詢: 2.19 ms 之後查詢記憶體: 0.021 MB 記憶體於查詢: 6.726 MB 前回傳的列: 4

SELECT id, home, template, s.params

  FROM dt_template_styles as s

  LEFT JOIN dt_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	tecstar_jm8.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.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.05 ms
preparing	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
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.72 ms 最後的查詢: 10.47 ms 之後查詢記憶體: 0.032 MB 記憶體於查詢: 7.440 MB 前回傳的列: 8

SHOW FULL COLUMNS 
  FROM `dt_assets`

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.27 ms 最後的查詢: 0.13 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 7.469 MB 前回傳的列: 1

SELECT *

  FROM dt_assets

  WHERE `id` = '1'

說明

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

側寫

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.00 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.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:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 7.477 MB 前回傳的列: 1

SELECT a.rules

  FROM dt_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	Using union(PRIMARY,idx_asset_name); 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.00 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 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:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.44 ms 最後的查詢: 0.89 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 7.506 MB 前回傳的列: 109

SELECT a.id, a.parent_id

  FROM dt_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	211	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.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.43 ms 最後的查詢: 0.85 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 7.585 MB 前回傳的列: 109

SELECT a.id, a.name, a.rules

  FROM dt_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	211	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.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 2.51 ms 最後的查詢: 1.84 ms 之後查詢記憶體: 0.037 MB 記憶體於查詢: 7.752 MB 前回傳的列: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

  FROM dt_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN dt_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('zh-TW','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  LEFT JOIN `dt_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'zh-TW')

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=8

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; 使用filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	27	Using where
1	PRIMARY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	tecstar_jm8.c.id	2	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	tecstar_jm8.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	27	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.05 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.12 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.08 ms
statistics	0.37 ms
preparing	0.06 ms
executing	0.01 ms
Copying to tmp table	0.53 ms
Copying to tmp table	0.07 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.10 ms
Sorting result	0.01 ms
Sending data	0.02 ms
removing tmp table	0.01 ms
Sending data	0.37 ms
Sorting result	0.04 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.47 ms 最後的查詢: 1.90 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 7.939 MB 前回傳的列: 35

SELECT element

  FROM dt_extensions

  WHERE type = 'component' 
  AND enabled = '1'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_extensions	ref	extension	extension	62	const	35	Using index condition; Using where

側寫

Status	Duration
starting	0.05 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.04 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.03 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.74 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 7.955 MB 前回傳的列: 35

SELECT a.name, a.rules

  FROM dt_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomdownloads','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

說明

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

側寫

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.04 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.35 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	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 3.76 ms 最後的查詢: 0.86 ms 之後查詢記憶體: 0.040 MB 記憶體於查詢: 8.152 MB 前回傳的列: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM dt_content AS a

  LEFT JOIN dt_categories AS c 
  ON c.id = a.catid

  LEFT JOIN dt_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN dt_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN dt_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN dt_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.catid = 8 OR a.catid IN (
SELECT sub.id

  FROM dt_categories as sub

  INNER JOIN dt_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 8)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-03 15:02:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-03 15:02:18') 
  AND a.language in ('zh-TW','*')

  ORDER BY  c.lft,  a.ordering,  a.created   
  LIMIT 3

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	27	Using where; Using temporary; 使用filesort
1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	tecstar_jm8.c.id	2	Using index condition; Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	tecstar_jm8.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	tecstar_jm8.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	tecstar_jm8.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	tecstar_jm8.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	tecstar_jm8.c.id	5	Using where
3	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
3	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	20	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	27	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.33 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.12 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.06 ms
statistics	0.09 ms
preparing	0.06 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.01 ms
Copying to tmp table	0.53 ms
Copying to tmp table	0.20 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	0.08 ms
Sorting result	0.01 ms
Sending data	0.02 ms
removing tmp table	0.01 ms
Sending data	0.61 ms
executing	0.01 ms
Sending data	0.58 ms
Sorting result	0.08 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 1.48 ms 最後的查詢: 1.54 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 8.320 MB 前回傳的列: 1

SELECT COUNT(*)

  FROM dt_content AS a

  LEFT JOIN dt_categories AS c 
  ON c.id = a.catid

  LEFT JOIN dt_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN dt_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN dt_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN dt_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.catid = 8 OR a.catid IN (
SELECT sub.id

  FROM dt_categories as sub

  INNER JOIN dt_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 8)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-03 15:02:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-03 15:02:18') 
  AND a.language in ('zh-TW','*')

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	27	Using where
1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	tecstar_jm8.c.id	2	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	tecstar_jm8.c.id	5	Using where
3	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
3	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	20	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	27	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 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.06 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.06 ms
statistics	0.09 ms
preparing	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.20 ms
executing	0.01 ms
Copying to tmp table	0.01 ms
Copying to tmp table	0.06 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.09 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
removing tmp table	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:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 1.45 ms 最後的查詢: 2.16 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 8.718 MB 前回傳的列: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `dt_contentitem_tag_map` AS m 

  INNER JOIN `dt_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 8 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	tecstar_jm8.m.tag_id	1	Using where

側寫

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.82 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.18 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.16 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:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 1.60 ms 最後的查詢: 14.56 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 9.276 MB 前回傳的列: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM dt_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN dt_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('zh-TW','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=8

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; 使用filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	27	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	tecstar_jm8.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	27	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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.10 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.05 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Copying to tmp table	0.38 ms
Copying to tmp table	0.03 ms
executing	0.01 ms
Copying to tmp table	0.01 ms
Copying to tmp table	0.06 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.13 ms
Sorting result	0.03 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
17	ContentHelperRoute::getArticleRoute()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:48
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.30 ms 最後的查詢: 9.48 ms 之後查詢記憶體: 0.037 MB 記憶體於查詢: 9.516 MB 前回傳的列: 1

SELECT *

  FROM dt_komento_configs

  WHERE `component` = 'com_content'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	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.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.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:1453
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
19	JTable->load()	JROOT/components/com_komento/helpers/helper.php:202
18	Komento::getConfig()	JROOT/components/com_komento/helpers/helper.php:697
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `dt_content` AS a 
  LEFT JOIN `dt_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `dt_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `dt_categories` AS parent 
  ON parent.id = c.parent_id 
  WHERE a.id = '78'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

側寫

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.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.01 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:1650
21	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/komento_plugins/com_content.php:54
18	KomentoComcontent->load()	JROOT/components/com_komento/helpers/helper.php:743
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.58 ms 最後的查詢: 1.47 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 9.666 MB 前回傳的列: 0

SELECT `id` 
  FROM `dt_komento_mailq` 
  WHERE `status` = '0' 
  ORDER BY `created` ASC 
  LIMIT 0, 5

說明

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

側寫

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.35 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.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
22	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
21	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
20	KomentoSql->__call()	JROOT/components/com_komento/classes/mailqueue.php:49
19	KomentoMailQueue->send()	JROOT/components/com_komento/classes/mailqueue.php:24
18	KomentoMailQueue->sendOnPageLoad()	JROOT/components/com_komento/helpers/helper.php:848
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.84 ms 最後的查詢: 2.21 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 9.737 MB 前回傳的列: 1

SELECT `rules` 
  FROM `dt_komento_acl` 
  WHERE `cid` = '9' 
  AND `type` = 'usergroup' 
  AND `component` = 'com_content' 
  ORDER BY `id` ASC

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_acl	index	komento_acl_content_type	PRIMARY	8	NULL	10	Using where

側寫

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	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.01 ms

呼叫堆疊

#	Caller	檔案與行號
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
25	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
24	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
23	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
22	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
21	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:133
20	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:246
19	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:31
18	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:858
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.28 ms 最後的查詢: 1.02 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 9.754 MB 前回傳的列: 0

SELECT `rules` 
  FROM `dt_komento_acl` 
  WHERE `cid` = '0' 
  AND `type` = 'user' 
  AND `component` = 'com_content' 
  ORDER BY `id` ASC

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_acl	ref	komento_acl_content_type	komento_acl_content_type	767	const	1	Using index condition; Using where

側寫

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.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	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	檔案與行號
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
25	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
24	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
23	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
22	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
21	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:137
20	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:246
19	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:31
18	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:858
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.92 ms 最後的查詢: 26.12 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 11.046 MB 前回傳的列: 1

SELECT COUNT(1) 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '78' 
  AND `published` = '1'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using where; Using index

側寫

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.44 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.21 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
18	KomentoModelComments->getCount()	JROOT/components/com_komento/helpers/helper.php:869
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 11.058 MB 前回傳的列: 1

SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '78' 
  AND `published` = '1' 
  AND `ratings` !='' 
  ORDER BY `created` ASC 
  LIMIT 0,10

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where

側寫

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.00 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
21	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:108
18	KomentoModelComments->getOverallRatings()	JROOT/components/com_komento/helpers/helper.php:872
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.39 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 11.069 MB 前回傳的列: 0

SELECT * 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '78' 
  AND `published` = '1' 
  AND `parent_id` = '0' 
  ORDER BY `created` DESC 
  LIMIT 0,3

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments,komento_backend	komento_module_comments	776	const,const,const	1	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.00 ms
After opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:146
18	KomentoModelComments->getComments()	JROOT/components/com_komento/helpers/helper.php:901
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.36 ms 最後的查詢: 2.75 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 11.084 MB 前回傳的列: 1

SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `dt_content` AS a 
  LEFT JOIN `dt_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `dt_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `dt_categories` AS parent 
  ON parent.id = c.parent_id 
  WHERE a.id = '73'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.08 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
21	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/komento_plugins/com_content.php:54
18	KomentoComcontent->load()	JROOT/components/com_komento/helpers/helper.php:743
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.27 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 11.097 MB 前回傳的列: 1

SELECT COUNT(1) 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '73' 
  AND `published` = '1'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using where; 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.00 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
18	KomentoModelComments->getCount()	JROOT/components/com_komento/helpers/helper.php:869
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.28 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 11.108 MB 前回傳的列: 1

SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '73' 
  AND `published` = '1' 
  AND `ratings` !='' 
  ORDER BY `created` ASC 
  LIMIT 0,10

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; 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.00 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
21	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:108
18	KomentoModelComments->getOverallRatings()	JROOT/components/com_komento/helpers/helper.php:872
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 11.119 MB 前回傳的列: 0

SELECT * 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '73' 
  AND `published` = '1' 
  AND `parent_id` = '0' 
  ORDER BY `created` DESC 
  LIMIT 0,3

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments,komento_backend	komento_module_comments	776	const,const,const	1	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.00 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
Sorting result	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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:146
18	KomentoModelComments->getComments()	JROOT/components/com_komento/helpers/helper.php:901
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.39 ms 最後的查詢: 2.04 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 11.131 MB 前回傳的列: 1

SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `dt_content` AS a 
  LEFT JOIN `dt_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `dt_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `dt_categories` AS parent 
  ON parent.id = c.parent_id 
  WHERE a.id = '72'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

側寫

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	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.03 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
21	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/komento_plugins/com_content.php:54
18	KomentoComcontent->load()	JROOT/components/com_komento/helpers/helper.php:743
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.25 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 11.145 MB 前回傳的列: 1

SELECT COUNT(1) 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '72' 
  AND `published` = '1'

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using where; Using index

側寫

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.00 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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
18	KomentoModelComments->getCount()	JROOT/components/com_komento/helpers/helper.php:869
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.25 ms 最後的查詢: 0.08 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 11.156 MB 前回傳的列: 1

SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '72' 
  AND `published` = '1' 
  AND `ratings` !='' 
  ORDER BY `created` ASC 
  LIMIT 0,10

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	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.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.02 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.00 ms

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
21	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:108
18	KomentoModelComments->getOverallRatings()	JROOT/components/com_komento/helpers/helper.php:872
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.29 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.039 MB 記憶體於查詢: 11.167 MB 前回傳的列: 0

SELECT * 
  FROM `dt_komento_comments` 
  WHERE `component` = 'com_content' 
  AND `cid` = '72' 
  AND `published` = '1' 
  AND `parent_id` = '0' 
  ORDER BY `created` DESC 
  LIMIT 0,3

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments,komento_backend	komento_module_comments	776	const,const,const	1	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.00 ms
Table lock	0.00 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
Sorting result	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	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
20	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
19	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:146
18	KomentoModelComments->getComments()	JROOT/components/com_komento/helpers/helper.php:901
17	Komento::commentify()	JROOT/templates/theme2062/html/com_content/category/blog_item.php:152
16	include JROOT/templates/theme2062/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/theme2062/html/com_content/category/blog.php:80
14	include JROOT/templates/theme2062/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.36 ms 最後的查詢: 0.68 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 11.071 MB 前回傳的列: 3

SELECT language,id

  FROM `dt_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	42	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.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 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	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.33 ms 最後的查詢: 1.06 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 11.183 MB 前回傳的列: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `dt_menu` AS `c`

  INNER JOIN `dt_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `dt_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `dt_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 112

說明

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

側寫

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.01 ms
executing	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	檔案與行號
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.31 ms 最後的查詢: 1.69 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 11.210 MB 前回傳的列: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`

  FROM `dt_categories` AS `c`

  INNER JOIN `dt_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item'

  INNER JOIN `dt_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `dt_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

  WHERE c.id = 8 
  AND c.extension = 'com_content'

說明

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

側寫

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	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	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:102
10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:43
9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:58
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:729
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.28 ms 最後的查詢: 4.59 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 11.383 MB 前回傳的列: 1

SELECT template 
  FROM dt_template_styles 
  WHERE client_id = 1 
  AND home = 1

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	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.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/templates/theme2062/includes/includes.php:21
8	include_once JROOT/templates/theme2062/includes/includes.php	JROOT/templates/theme2062/index.php:4
7	require JROOT/templates/theme2062/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 1.22 ms 最後的查詢: 1.18 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 11.479 MB 前回傳的列: 9

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

  FROM dt_modules AS m

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

  LEFT JOIN dt_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-12-03 15:02:18') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-03 15:02:18') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 112 OR mm.menuid <= 0) 
  AND m.language IN ('zh-TW','*')

  ORDER BY m.position, m.ordering

說明

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

側寫

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 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.04 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.07 ms
executing	0.01 ms
Sorting result	0.39 ms
Sending data	0.26 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:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
9	JDocumentHtml->countModules()	JROOT/templates/theme2062/includes/includes.php:81
8	include_once JROOT/templates/theme2062/includes/includes.php	JROOT/templates/theme2062/index.php:4
7	require JROOT/templates/theme2062/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.87 ms 最後的查詢: 11.40 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 11.689 MB 前回傳的列: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM dt_content AS a

  LEFT JOIN dt_categories AS c 
  on c.id = a.catid

  LEFT JOIN dt_users AS u 
  on u.id = a.created_by

  LEFT JOIN dt_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN dt_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 40 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-03 15:02:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-03 15:02:18')

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	27	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.06 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.07 ms
Sorting result	0.02 ms
Sending data	0.01 ms
removing tmp table	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.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 1.45 ms 最後的查詢: 0.18 ms 之後查詢記憶體: 0.036 MB 記憶體於查詢: 11.721 MB 前回傳的列: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM dt_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN dt_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('zh-TW','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=24

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; 使用filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	27	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	tecstar_jm8.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; 使用filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	27	Using where; Using index; Using join buffer (flat, BNL join)

側寫

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.08 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.05 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Copying to tmp table	0.42 ms
Copying to tmp table	0.03 ms
executing	0.01 ms
Copying to tmp table	0.01 ms
Copying to tmp table	0.06 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.11 ms
Sorting result	0.02 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.24 ms 最後的查詢: 0.15 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 11.730 MB 前回傳的列: 1

SELECT alias

  FROM dt_content

  WHERE id=40

說明

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

側寫

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

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
17	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.35 ms 最後的查詢: 22.03 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 13.057 MB 前回傳的列: 75

SELECT * 
  FROM dt_acymailing_config

說明

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

側寫

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.00 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.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:343
12	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:739
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

查詢時間: 0.25 ms 最後的查詢: 3.15 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 13.298 MB 前回傳的列: 1

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

說明

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dt_acymailing_list	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	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.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

呼叫堆疊

#	Caller	檔案與行號
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:29
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:117
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

選擇表格:

3 × SELECT a.id, a.title, a.alias, a.catid, a.created_by, a.created_by_alias, a.hits, c.title AS category_title, c.alias AS category_alias, u.name AS author, parent.id AS parent_id, parent.alias AS parent_alias 
  FROM `dt_content` AS a 
  LEFT JOIN `dt_categories` AS c 
  ON c.id = a.catid 
  LEFT JOIN `dt_users` AS u 
  ON u.id = a.created_by 
  LEFT JOIN `dt_categories` AS parent 
  ON parent.id = c.parent_id

3 × SELECT COUNT(1) 
  FROM `dt_komento_comments`

3 × SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
  FROM `dt_komento_comments`

3 × SELECT * 
  FROM `dt_komento_comments`

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM dt_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT `rules` 
  FROM `dt_komento_acl`

2 × SELECT * 
  FROM dt_komento_configs

2 × SELECT element 
  FROM dt_extensions

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

1 × SELECT template 
  FROM dt_template_styles

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
  FROM `dt_categories` AS `c` 
  INNER JOIN `dt_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item' 
  INNER JOIN `dt_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `dt_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `dt_menu` AS `c` 
  INNER JOIN `dt_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `dt_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `dt_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `dt_menu`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM dt_content AS a 
  LEFT JOIN dt_categories AS c 
  on c.id = a.catid 
  LEFT JOIN dt_users AS u 
  on u.id = a.created_by 
  LEFT JOIN dt_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN dt_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT alias 
  FROM dt_content
```

1 × SELECT * 
  FROM dt_acymailing_confi

1 × SELECT `id` 
  FROM `dt_komento_mailq`

1 × SELECT `data` 
  FROM `dt_session`

1 × SELECT COUNT(*) 
  FROM dt_content AS a 
  LEFT JOIN dt_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN dt_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN dt_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN dt_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN dt_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `dt_contentitem_tag_map` AS m  
  INNER JOIN `dt_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT `session_id` 
  FROM `dt_session`

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM dt_content AS a 
  LEFT JOIN dt_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN dt_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN dt_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN dt_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN dt_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.name, a.rules 
  FROM dt_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM dt_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM dt_categories AS cat JOIN dt_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.name, a.rules 
  FROM dt_assets AS a

1 × SELECT a.id, a.parent_id 
  FROM dt_assets AS a

1 × SELECT a.rules 
  FROM dt_assets AS a

```
1 × SELECT * 
  FROM dt_assets
```

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

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 dt_menu AS m 
  LEFT JOIN dt_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM dt_languages
```

1 × SELECT folder AS type, element AS name, params 
  FROM dt_extensions

1 × SELECT id, rules 
  FROM `dt_viewlevels

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

1 × SELECT * 
  FROM dt_acymailing_list

其他表格:

1 × INSERT INTO `dt_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('h2ien0lipvffcc7jo7h6laqolt', 0, 1, '1701615738', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `dt_komento_configs

1 × UPDATE `dt_extensions` 
  SET `params` = '{\"mediaversion\":\"3a57891dd1b72c2a682f427ff41ce2cf\"}'

1 × SHOW FULL COLUMNS 
  FROM `dt_assets