「2026港澳台大學生網信企業實習計劃」

2026港澳台大學生內地網信企業實習計劃接受報名了

? 想親身走進內地頂級科技企業，探索前沿技術的奧妙？機會又來了！由中國互聯網發展基金會與國際青年文化交流中心(香港)等聯合主辦，攜手多家內地龍頭網信企業，為你提供高新領域實習崗位。這是一個絕對不能錯過的提升專業技能、拓展優質人脈的黃金機會！
機會一瞬即逝，快啲報名啦！

計劃詳情
?日期： 2026年7月3日(五)-20日(一)
? 地點：北京

?企業：（排名不分先後）螞蟻、抖音、小米、美團、聯想等

?計劃內容：於北京各家大企業實習，周末進行豐富配套活動，包括中華優秀傳統文化體驗、前沿科技探索觀摩、企業高校參訪

?對象：18-25歲的大專院校在讀學生（參加者須持有香港永久性居民身份證或香港居民身份證）

? 費用：$1,000元(含香港來回交通及住宿)

?報名：https://forms.office.com/r/QwMw8htiWu
?截止日期：6月27日（六）

查詢：陳先生6717 0277 / Email住址會使用灌水程式保護機制。你需要啟動Javascript才能觀看它

此分類更多內容： « 「2026漓舟馭風·香港大專生廣西體育實習計劃」正式開始報名啦！！！

Joomla! 除錯主控台

連線階段 (Session)

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1785175801,
                "last": 1785175801,
                "now": 1785175801
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "a3b6c940481a90e98faa25f792478d43a7ef0a32": {
                    "link": "https://www.iycea.org.hk/news/item/26-%E3%80%8C2026%E6%B8%AF%E6%BE%B3%E5%8F%B0%E5%A4%A7%E5%AD%B8%E7%94%9F%E7%B6%B2%E4%BF%A1%E4%BC%81%E6%A5%AD%E5%AF%A6%E7%BF%92%E8%A8%88%E5%8A%83%E3%80%8D",
                    "expiry": 1785175801
                }
            }
        }
    }
}

側寫資訊

時間

記憶體

時間: 1.17 ms / 1.17 ms 記憶體: 0.435 MB / 0.76 MB Application: afterLoad

時間: 36.77 ms / 37.94 ms 記憶體: 1.672 MB / 2.43 MB Application: afterInitialise

時間: 7.71 ms / 45.65 ms 記憶體: 0.843 MB / 3.27 MB Application: afterRoute

時間: 0.62 ms / 46.27 ms 記憶體: 0.129 MB / 3.40 MB Application: beforeRenderComponent com_k2

時間: 0.05 ms / 46.32 ms 記憶體: 0.018 MB / 3.42 MB Application: Before Access::preloadComponents (all components)

時間: 0.33 ms / 46.65 ms 記憶體: 0.070 MB / 3.49 MB Application: After Access::preloadComponents (all components)

時間: 0.02 ms / 46.68 ms 記憶體: -0.002 MB / 3.49 MB Application: Before Access::getAssetRules (id:149 name:com_k2)

時間: 0.11 ms / 46.78 ms 記憶體: 0.008 MB / 3.50 MB Application: After Access::getAssetRules (id:149 name:com_k2)

時間: 34.70 ms / 81.48 ms 記憶體: 1.104 MB / 4.60 MB Application: afterRenderComponent com_k2

時間: 0.79 ms / 82.27 ms 記憶體: 0.020 MB / 4.62 MB Application: afterDispatch

時間: 72.08 ms / 154.35 ms 記憶體: 0.302 MB / 4.92 MB Application: beforeRenderModule mod_menu (Main Menu)

時間: 1.37 ms / 155.72 ms 記憶體: 0.059 MB / 4.98 MB Application: afterRenderModule mod_menu (Main Menu)

時間: 0.16 ms / 155.88 ms 記憶體: 0.004 MB / 4.99 MB Application: beforeRenderModule mod_sppagebuilder (Footer)

時間: 10.60 ms / 166.48 ms 記憶體: 1.827 MB / 6.81 MB Application: beforeRenderModule mod_custom (Footer - 國際青年文化交流中心)

時間: 0.63 ms / 167.10 ms 記憶體: 0.005 MB / 6.82 MB Application: afterRenderModule mod_custom (Footer - 國際青年文化交流中心)

時間: 1.70 ms / 168.81 ms 記憶體: 0.040 MB / 6.86 MB Application: beforeRenderModule mod_menu (Footer - 認識國際青年文化交流中心)

時間: 0.43 ms / 169.24 ms 記憶體: 0.020 MB / 6.88 MB Application: afterRenderModule mod_menu (Footer - 認識國際青年文化交流中心)

時間: 0.55 ms / 169.79 ms 記憶體: 0.012 MB / 6.89 MB Application: beforeRenderModule mod_menu (Footer - 加入國際青年文化交流中心)

時間: 0.17 ms / 169.97 ms 記憶體: 0.008 MB / 6.90 MB Application: afterRenderModule mod_menu (Footer - 加入國際青年文化交流中心)

時間: 0.70 ms / 170.66 ms 記憶體: -0.005 MB / 6.89 MB Application: beforeRenderModule mod_acymailing (Footer - 訂閱中心通訊)

時間: 4.24 ms / 174.90 ms 記憶體: 0.411 MB / 7.30 MB Application: afterRenderModule mod_acymailing (Footer - 訂閱中心通訊)

時間: 0.51 ms / 175.41 ms 記憶體: -0.195 MB / 7.11 MB Application: afterRenderModule mod_sppagebuilder (Footer)

時間: 2.20 ms / 177.61 ms 記憶體: 0.052 MB / 7.16 MB Application: afterRender

資料庫查詢總計: 37.76 ms

記憶體使用量

資料庫查詢

84 查詢記錄 37.76 ms

30 重覆被找到!

4 重覆: #2 #61 #62 #74

2 重覆: #5 #6

2 重覆: #19 #20

4 重覆: #27 #28 #49 #50

2 重覆: #32 #52

2 重覆: #33 #34

2 重覆: #39 #45

2 重覆: #53 #54

2 重覆: #57 #58

3 重覆: #64 #66 #68

3 重覆: #65 #67 #69

2 重覆: #82 #83

查詢時間: 0.68 ms 查詢記憶體: 0.024 MB 記憶體於查詢: 2.097 MB 前回傳的列: 22

SELECT *

  FROM iyc_rsform_config

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.09 ms 最後的查詢: 0.40 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 2.131 MB 前回傳的列: 1

重覆查詢: #61 #62 #74

SELECT `template`

  FROM `iyc_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	12.50	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
10	JFalangDatabase->loadObject()	JROOT/plugins/system/helix3/helix3.php:242
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:47
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.45 ms 最後的查詢: 0.20 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 2.157 MB 前回傳的列: 1

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

  FROM `iyc_extensions`

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

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	與下面行一樣的呼叫
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/invoices/invoices.php:17
8	PlgSystemInvoices->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 7.29 ms 最後的查詢: 0.13 ms 之後查詢記憶體: 0.006 MB 記憶體於查詢: 2.151 MB 前

UPDATE `iyc_extensions`

  SET `params` = '{\"mediaversion\":\"9ee2de6dfaa29665a53901ac57e5f51c\"}'

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

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/invoices/invoices.php:17
8	PlgSystemInvoices->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.15 ms 最後的查詢: 0.55 ms 之後查詢記憶體: 0.082 MB 記憶體於查詢: 2.201 MB 前回傳的列: 68

重覆查詢: #6

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

  LEFT JOIN iyc_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	215	3.53	Using where; 使用filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.m.component_id	1	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/falangdriver/falangdriver.php:68
8	plgSystemFalangdriver->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.13 ms 最後的查詢: 4.48 ms 之後查詢記憶體: 0.081 MB 記憶體於查詢: 3.126 MB 前回傳的列: 68

重覆查詢: #5

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

  LEFT JOIN iyc_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	215	3.53	Using where; 使用filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.m.component_id	1	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	與下面行一樣的呼叫
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:370
11	plgSystemFalangdriver->parseRule()	與下面行一樣的呼叫
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.10 ms 最後的查詢: 0.65 ms 之後查詢記憶體: 0.038 MB 記憶體於查詢: 3.129 MB 前回傳的列: 6

SELECT id, home, template, s.params

  FROM iyc_template_styles as s

  LEFT JOIN iyc_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	62	const	8	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	iycea_www.e.element	1	75.00	Using index condition; Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:348
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.10 ms 最後的查詢: 1.34 ms 之後查詢記憶體: 0.022 MB 記憶體於查詢: 3.206 MB 前回傳的列: 0

SELECT i.* 
  FROM iyc_invoices_invoices as i  
  WHERE i.is_recurrent = 1 
  AND rec_nextdate = "2026-07-28"

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
10	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_invoices/models/invoice.php:439
9	InvoicesModelInvoice->create_recurring()	JROOT/plugins/system/recurring/recurring.php:42
8	plgSystemRecurring->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.07 ms 最後的查詢: 0.84 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 3.254 MB 前回傳的列: 1

SELECT *

  FROM iyc_languages

  WHERE published=1

  ORDER BY ordering ASC

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:248
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:392
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.11 ms 最後的查詢: 1.32 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 3.426 MB 前回傳的列: 52

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

  FROM `iyc_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventbooking','com_eventgallery','com_falang','com_fields','com_finder','com_gsd','com_guru','com_installer','com_invoices','com_jaextmanager','com_jce','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	176	30.68	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.81 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 3.600 MB 前回傳的列: 3

SELECT id 
  FROM iyc_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_categories	NULL	ref	idx_access,idx_category,idx_published,idx_trash	idx_published	2	const	3	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
13	JFalangDatabase->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.46 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 3.609 MB 前回傳的列: 1

SELECT * 
  FROM iyc_k2_items 
  WHERE id=26 
  LIMIT 0, 1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.53 ms 最後的查詢: 0.20 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 3.633 MB 前回傳的列: 14

SHOW FULL COLUMNS 
  FROM `iyc_k2_categories`

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.07 ms 最後的查詢: 0.16 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 3.657 MB 前回傳的列: 1

SELECT * 
  FROM iyc_k2_categories 
  WHERE id = '3'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.28 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 3.681 MB 前回傳的列: 3

SELECT id, name, parent 
  FROM iyc_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5) 
  ORDER BY parent

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_categories	NULL	ALL	idx_access,idx_category,idx_published,idx_trash	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; 使用filesort

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:928
15	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:261
14	K2HelperRoute::findMenuItem()	JROOT/components/com_k2/helpers/route.php:56
13	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.24 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 3.690 MB 前回傳的列: 0

SELECT joomlatablename,tablepkID 
  FROM `iyc_falang_tableinfo`

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
24	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
23	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
22	FalangManager::getInstance()	JROOT/plugins/system/falangdriver/falangdriver.php:246
21	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.06 ms 之後查詢記憶體: 0.029 MB 記憶體於查詢: 3.704 MB 前回傳的列: 2

SELECT * 
  FROM iyc_languages 
  ORDER BY ordering

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	使用filesort

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
24	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
23	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
22	FalangManager::getInstance()	JROOT/plugins/system/falangdriver/falangdriver.php:246
21	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.38 ms 最後的查詢: 0.11 ms 之後查詢記憶體: 0.032 MB 記憶體於查詢: 3.724 MB 前回傳的列: 14

SHOW FULL COLUMNS 
  FROM `iyc_languages`

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
32	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
31	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
29	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
26	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
25	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
24	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
23	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
22	FalangManager::getInstance()	JROOT/plugins/system/falangdriver/falangdriver.php:246
21	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.15 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 3.759 MB 前回傳的列: 0

重覆查詢: #20

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 26 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
24	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
23	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
22	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
21	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.16 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 3.773 MB 前回傳的列: 0

重覆查詢: #19

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 26 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
24	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
23	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
22	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
21	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.28 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 3.840 MB 前回傳的列: 0

SELECT tag.*
            
  FROM iyc_k2_tags AS tag
            JOIN iyc_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 26
            
  ORDER BY xref.id ASC

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tag	NULL	ref	PRIMARY,idx_published	idx_published	2	const	1	100.00	Using temporary; 使用filesort
1	SIMPLE	xref	NULL	ref	idx_tagID,idx_itemID	idx_tagID	4	iycea_www.tag.id	1	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/item.php:1194
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:104
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.54 ms 最後的查詢: 0.11 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 3.850 MB 前回傳的列: 0

SELECT * 
  FROM iyc_k2_attachments 
  WHERE itemID=26

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/item.php:1422
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:156
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM iyc_k2_rating 
  WHERE itemID = 26

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:907
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:951
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:161
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.44 ms 最後的查詢: 0.26 ms 之後查詢記憶體: 0.030 MB 記憶體於查詢: 3.874 MB 前回傳的列: 17

SHOW FULL COLUMNS 
  FROM `iyc_users`

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 3.906 MB 前回傳的列: 1

SELECT *

  FROM `iyc_users`

  WHERE `id` = 58

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
18	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.20 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 3.920 MB 前回傳的列: 1

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

  FROM `iyc_usergroups` AS g

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

  WHERE `m`.`user_id` = 58

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.m.group_id	1	100.00	NULL

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:459
18	JFalangDatabase->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.39 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 4.002 MB 前回傳的列: 0

重覆查詢: #28 #49 #50

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM iyc_k2_users 
  WHERE userID=58

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:1674
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 4.012 MB 前回傳的列: 0

重覆查詢: #27 #49 #50

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM iyc_k2_users 
  WHERE userID=58

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
14	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:1674
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:205
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.05 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 4.021 MB 前回傳的列: 1

SELECT COUNT(*) 
  FROM iyc_k2_comments 
  WHERE itemID=26 
  AND published=1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_comments	NULL	ref	idx_countComments,idx_itemID,idx_latestComments,idx_published	idx_countComments	8	const,const	1	100.00	Using index

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
14	JFalangDatabase->loadResult()	JROOT/components/com_k2/models/item.php:1461
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.20 ms 最後的查詢: 1.10 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.064 MB 前回傳的列: 0

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

  FROM iyc_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:589
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.93 ms 最後的查詢: 0.68 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.104 MB 前回傳的列: 0

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

  FROM iyc_fields AS a

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

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

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

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

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

  LEFT JOIN `iyc_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (3,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; 使用filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	21	iycea_www.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	iycea_www.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	iycea_www.a.id	1	100.00	Using where; Using index; Distinct

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:660
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.07 ms 最後的查詢: 0.57 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.201 MB 前回傳的列: 1

重覆查詢: #52

SELECT enabled 
  FROM iyc_extensions 
  WHERE element = 'com_sppagebuilder' 
  AND type = 'component'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
19	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
18	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
17	JFalangDatabase->loadResult()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:99
16	plgK2Sppagebuilder->isSppagebuilderEnabled()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:84
15	plgK2Sppagebuilder->onK2PrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:785
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.41 ms 最後的查詢: 0.11 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.220 MB 前回傳的列: 0

重覆查詢: #34

SELECT *

  FROM `iyc_sppagebuilder`

  WHERE `extension` = 'com_k2' 
  AND `extension_view` = 'item' 
  AND `view_id` = '26' 
  AND `active` = 1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291
17	SppagebuilderHelper::getPageContent()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248
16	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:87
15	plgK2Sppagebuilder->onK2PrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:785
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.231 MB 前回傳的列: 0

重覆查詢: #33

SELECT *

  FROM `iyc_sppagebuilder`

  WHERE `extension` = 'com_k2' 
  AND `extension_view` = 'item' 
  AND `view_id` = '26' 
  AND `active` = 1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291
17	SppagebuilderHelper::getPageContent()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248
16	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:89
15	plgK2Sppagebuilder->onK2PrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:785
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.47 ms 最後的查詢: 0.19 ms 之後查詢記憶體: 0.034 MB 記憶體於查詢: 4.246 MB 前回傳的列: 36

SHOW FULL COLUMNS 
  FROM `iyc_k2_items`

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:832
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 9.48 ms 最後的查詢: 0.40 ms 之後查詢記憶體: 0.007 MB 記憶體於查詢: 4.293 MB 前

UPDATE iyc_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '26'

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	iyc_k2_items	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/src/Table/Table.php:1264
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:833
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.34 ms 最後的查詢: 0.24 ms 之後查詢記憶體: 0.023 MB 記憶體於查詢: 4.297 MB 前回傳的列: 0

SELECT * 
  FROM iyc_k2_comments 
  WHERE itemID=26 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_comments	NULL	ref	idx_countComments,idx_itemID,idx_latestComments,idx_published	idx_countComments	8	const,const	1	100.00	Using index condition; 使用filesort

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/item.php:1443
12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:227
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 2.19 ms 最後的查詢: 0.29 ms 之後查詢記憶體: 0.057 MB 記憶體於查詢: 4.306 MB 前回傳的列: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM iyc_k2_items AS i
            
  LEFT JOIN iyc_k2_categories c 
  ON c.id = i.catid
            
  WHERE i.id != 26
                
  AND i.published = 1
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-07-27 18:10:01')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-07-27 18:10:01') 
  AND i.access IN(1,1,5) 
  AND i.trash = 0
            
  AND i.created_by = 58
            
  AND i.created_by_alias=''
            
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0
            
  ORDER BY i.created DESC 
  LIMIT 0, 5

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	index	PRIMARY,idx_access,idx_catid,idx_created_by,idx_item,idx_published,idx_publish_down,idx_publish_up,idx_trash	idx_created	5	NULL	7	3.85	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access,idx_category,idx_published,idx_trash	PRIMARY	4	iycea_www.i.catid	1	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:563
12	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:266
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.39 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.359 MB 前回傳的列: 0

重覆查詢: #45

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 25 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
20	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:269
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.20 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.372 MB 前回傳的列: 0

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 24 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
20	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:269
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.16 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.385 MB 前回傳的列: 0

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 23 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
20	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:269
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.398 MB 前回傳的列: 0

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 21 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
20	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:269
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.13 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.411 MB 前回傳的列: 0

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 20 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
24	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
23	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
22	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
21	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
20	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:269
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.35 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 4.422 MB 前回傳的列: 1

SELECT *
            
  FROM iyc_k2_items
            
  WHERE id < 26
                
  AND catid = 3
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-07-27 18:10:01')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-07-27 18:10:01')
                
  AND access IN (1,1,5)
                
            
  ORDER BY id DESC 
  LIMIT 0, 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_items	NULL	range	PRIMARY,idx_access,idx_catid,idx_item,idx_published,idx_publish_down,idx_publish_up,idx_trash	PRIMARY	4	NULL	25	3.85	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:1597
12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:290
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.26 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 4.443 MB 前回傳的列: 0

重覆查詢: #39

SELECT fc.value

  FROM iyc_falang_content fc

  WHERE fc.reference_id = 25 
  AND fc.language_id = -1 
  AND fc.reference_field = 'alias' 
  AND fc.published = 1 
  AND fc.reference_table = 'k2_items'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
25	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
24	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
23	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
22	JFalangDatabase->loadResult()	JROOT/plugins/system/falangdriver/falangdriver.php:263
21	plgSystemFalangdriver->buildRule()	與下面行一樣的呼叫
20	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
19	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
17	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT tag.*
            
  FROM iyc_k2_tags AS tag
            JOIN iyc_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 25
            
  ORDER BY xref.id ASC

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tag	NULL	ref	PRIMARY,idx_published	idx_published	2	const	1	100.00	Using temporary; 使用filesort
1	SIMPLE	xref	NULL	ref	idx_tagID,idx_itemID	idx_tagID	4	iycea_www.tag.id	1	100.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/item.php:1194
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:104
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.14 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 4.518 MB 前回傳的列: 0

SELECT * 
  FROM iyc_k2_attachments 
  WHERE itemID=25

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/components/com_k2/models/item.php:1422
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:156
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM iyc_k2_rating 
  WHERE itemID = 25

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:907
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:951
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:161
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.15 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 4.536 MB 前回傳的列: 0

重覆查詢: #27 #28 #50

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM iyc_k2_users 
  WHERE userID=58

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:1674
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.06 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 4.545 MB 前回傳的列: 0

重覆查詢: #27 #28 #49

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM iyc_k2_users 
  WHERE userID=58

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
14	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:1674
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:205
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.03 ms 最後的查詢: 0.05 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 4.554 MB 前回傳的列: 1

SELECT COUNT(*) 
  FROM iyc_k2_comments 
  WHERE itemID=25 
  AND published=1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_comments	NULL	ref	idx_countComments,idx_itemID,idx_latestComments,idx_published	idx_countComments	8	const,const	1	100.00	Using index

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
14	JFalangDatabase->loadResult()	JROOT/components/com_k2/models/item.php:1461
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.49 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.542 MB 前回傳的列: 1

重覆查詢: #32

SELECT enabled 
  FROM iyc_extensions 
  WHERE element = 'com_sppagebuilder' 
  AND type = 'component'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
19	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
18	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
17	JFalangDatabase->loadResult()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:99
16	plgK2Sppagebuilder->isSppagebuilderEnabled()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:84
15	plgK2Sppagebuilder->onK2PrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:785
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:293
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.36 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.554 MB 前回傳的列: 0

重覆查詢: #54

SELECT *

  FROM `iyc_sppagebuilder`

  WHERE `extension` = 'com_k2' 
  AND `extension_view` = 'item' 
  AND `view_id` = '25' 
  AND `active` = 1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291
17	SppagebuilderHelper::getPageContent()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248
16	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:87
15	plgK2Sppagebuilder->onK2PrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:785
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:293
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.26 ms 最後的查詢: 0.09 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.564 MB 前回傳的列: 0

重覆查詢: #53

SELECT *

  FROM `iyc_sppagebuilder`

  WHERE `extension` = 'com_k2' 
  AND `extension_view` = 'item' 
  AND `view_id` = '25' 
  AND `active` = 1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:291
17	SppagebuilderHelper::getPageContent()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:248
16	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/k2/sppagebuilder/sppagebuilder.php:89
15	plgK2Sppagebuilder->onK2PrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:785
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:293
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.46 ms 最後的查詢: 0.14 ms 之後查詢記憶體: 0.024 MB 記憶體於查詢: 4.580 MB 前回傳的列: 0

SELECT *
            
  FROM iyc_k2_items
            
  WHERE id > 26
                
  AND catid = 3
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-07-27 18:10:01')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-07-27 18:10:01')
                
  AND access IN (1,1,5)
                
            
  ORDER BY id ASC 
  LIMIT 0, 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_k2_items	NULL	range	PRIMARY,idx_access,idx_catid,idx_item,idx_published,idx_publish_down,idx_publish_up,idx_trash	PRIMARY	4	NULL	1	5.00	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/components/com_k2/models/item.php:1656
12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:331
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.10 ms 最後的查詢: 1.42 ms 之後查詢記憶體: 0.021 MB 記憶體於查詢: 4.607 MB 前回傳的列: 0

SELECT folder.*

  FROM `iyc_eventgallery_folder` AS folder

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

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

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	file	NULL	ALL	file,index_folder	NO INDEX KEY COULD BE USED	NULL	NULL	50	10.00	Using where; Not exists; Using join buffer (Block Nested Loop)

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

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

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

查詢時間: 0.18 ms 最後的查詢: 67.74 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 4.771 MB 前回傳的列: 1

重覆查詢: #58

select `seo` 
  from iyc_guru_config

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/components/com_guru/router.php:24
21	guruBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/helix3/core/classes/menu.php:124
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:44
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:840
11	Helix3::loadMegaMenu()	JROOT/templates/flex/features/menu.php:36
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:247
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:301
8	Helix3::generatelayout()	JROOT/templates/flex/index.php:238
7	require JROOT/templates/flex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.16 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 4.781 MB 前回傳的列: 1

重覆查詢: #57

select `seo` 
  from iyc_guru_config

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:178
22	JFalangDatabase->loadColumn()	JROOT/components/com_guru/router.php:25
21	guruBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/helix3/core/classes/menu.php:124
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:44
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:840
11	Helix3::loadMegaMenu()	JROOT/templates/flex/features/menu.php:36
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:247
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:301
8	Helix3::generatelayout()	JROOT/templates/flex/index.php:238
7	require JROOT/templates/flex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 1.51 ms 最後的查詢: 0.85 ms 之後查詢記憶體: 0.067 MB 記憶體於查詢: 4.908 MB 前回傳的列: 21

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

  FROM iyc_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-27 18:10:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-27 18:10:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 290 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	68	1.47	Using where; 使用filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	iycea_www.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	iycea_www.m.id	1	40.00	Using where; Using index

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	與下面行一樣的呼叫
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:542
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:500
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:316
8	Helix3::generatelayout()	JROOT/templates/flex/index.php:238
7	require JROOT/templates/flex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.17 ms 最後的查詢: 4.06 ms 之後查詢記憶體: 0.056 MB 記憶體於查詢: 5.024 MB 前回傳的列: 1

SELECT *

  FROM `iyc_sppagebuilder`

  WHERE `extension` = 'mod_sppagebuilder' 
  AND `extension_view` = 'module' 
  AND `view_id` = '144'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
13	JFalangDatabase->loadObject()	JROOT/modules/mod_sppagebuilder/helper.php:40
12	ModSPagebuilderHelper::pageBuilderData()	JROOT/modules/mod_sppagebuilder/helper.php:16
11	ModSPagebuilderHelper::getData()	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:15
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.22 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 5.049 MB 前回傳的列: 1

重覆查詢: #2 #62 #74

SELECT `template`

  FROM `iyc_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	12.50	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:669
14	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:164
13	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:770
12	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/templates/flex/html/mod_sppagebuilder/default.php:11
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.07 ms 最後的查詢: 1.48 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 5.295 MB 前回傳的列: 1

重覆查詢: #2 #61 #74

SELECT `template`

  FROM `iyc_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	12.50	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
15	JFalangDatabase->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
14	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.07 ms 最後的查詢: 0.71 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 5.424 MB 前回傳的列: 1

SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id

  FROM (
SELECT id,title,level,published,parent_id,lft,rgt

  FROM iyc_tags

  WHERE `published` = '1') AS a

  LEFT JOIN `iyc_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`level` != '0'

  ORDER BY a.lft ASC

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_tags	NULL	ref	tag_idx	tag_idx	1	const	2	50.00	Using index condition; Using where; Using temporary; 使用filesort
1	SIMPLE	b	NULL	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Range checked for each record (index map: 0x10); Distinct

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:194
15	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:163
14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

重覆查詢: #66 #68

SELECT a.enabled

  FROM `iyc_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.11 ms 最後的查詢: 0.06 ms 之後查詢記憶體: 0.031 MB 記憶體於查詢: 5.449 MB 前回傳的列: 3

重覆查詢: #67 #69

SELECT m.* 
  FROM iyc_k2_categories m 
  WHERE trash = 0 
  ORDER BY parent, ordering

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_trash	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; 使用filesort

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:553
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.27 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 5.472 MB 前回傳的列: 1

重覆查詢: #64 #68

SELECT a.enabled

  FROM `iyc_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.07 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 5.482 MB 前回傳的列: 3

重覆查詢: #65 #69

SELECT m.* 
  FROM iyc_k2_categories m 
  WHERE trash = 0 
  ORDER BY parent, ordering

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_trash	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; 使用filesort

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:553
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
14	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.21 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 5.519 MB 前回傳的列: 1

重覆查詢: #64 #66

SELECT a.enabled

  FROM `iyc_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
14	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.06 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 5.528 MB 前回傳的列: 3

重覆查詢: #65 #67

SELECT m.* 
  FROM iyc_k2_categories m 
  WHERE trash = 0 
  ORDER BY parent, ordering

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_trash	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; 使用filesort

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:553
15	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
14	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.56 ms 最後的查詢: 2.11 ms 之後查詢記憶體: 0.026 MB 記憶體於查詢: 6.216 MB 前回傳的列: 2

SELECT a.enabled

  FROM `iyc_extensions` AS `a`

  WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	element_clientid,element_folder_clientid	element_clientid	302	NULL	2	100.00	Using index condition

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470
15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.27 ms 最後的查詢: 0.10 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 6.229 MB 前回傳的列: 2

SELECT `e`.`manifest_cache`

  FROM `iyc_extensions` AS `e`

  WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	range	element_clientid,element_folder_clientid	element_clientid	302	NULL	2	100.00	Using index condition

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
19	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
18	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
17	JFalangDatabase->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:529
16	SpPgaeBuilderBase::getExtensionVersion()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:475
15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.04 ms 最後的查詢: 0.08 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 6.240 MB 前回傳的列: 0

SELECT `id`,`name`

  FROM `iyc_acym_list`

  WHERE `active` = '1'

  ORDER BY name DESC

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:492
15	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
14	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
13	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.24 ms 最後的查詢: 2.48 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 6.802 MB 前回傳的列: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM iyc_modules AS m

  WHERE m.published = 1 
  AND m.id = 145 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-27 18:10:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-27 18:10:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:127
15	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:31
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.07 ms 最後的查詢: 1.03 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 6.820 MB 前回傳的列: 1

重覆查詢: #2 #61 #62

SELECT `template`

  FROM `iyc_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	iyc_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	12.50	Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
16	JFalangDatabase->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
15	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
14	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:207
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:309
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.28 ms 最後的查詢: 0.97 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 6.847 MB 前回傳的列: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM iyc_modules AS m

  WHERE m.published = 1 
  AND m.id = 146 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-27 18:10:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-27 18:10:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:127
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:31
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
14	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:309
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.24 ms 最後的查詢: 0.74 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 6.879 MB 前回傳的列: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM iyc_modules AS m

  WHERE m.published = 1 
  AND m.id = 147 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-27 18:10:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-27 18:10:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:127
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:31
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
14	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
13	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:309
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.26 ms 最後的查詢: 0.61 ms 之後查詢記憶體: 0.025 MB 記憶體於查詢: 6.882 MB 前回傳的列: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM iyc_modules AS m

  WHERE m.published = 1 
  AND m.id = 148 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-27 18:10:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-27 18:10:01') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
16	JFalangDatabase->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:127
15	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:31
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM iyc_acymailing_config

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
22	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
21	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
20	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
19	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
18	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
17	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
16	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:51
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.11 ms 最後的查詢: 2.72 ms 之後查詢記憶體: 0.027 MB 記憶體於查詢: 7.268 MB 前回傳的列: 1

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

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
18	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
17	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:148
16	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:51
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.06 ms 最後的查詢: 0.21 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 7.287 MB 前回傳的列: 3

SELECT * 
  FROM `iyc_acymailing_fields` as a 
  WHERE a.`published` = 1 
  AND (a.access = 'all' OR a.access LIKE ('%,9,%')) 
  ORDER BY a.`ordering` ASC

說明

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	orderingindex	orderingindex	1	const	2	55.56	Using index condition; Using where

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
18	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:85
17	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:244
16	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:51
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.05 ms 最後的查詢: 0.11 ms 之後查詢記憶體: 0.028 MB 記憶體於查詢: 7.304 MB 前回傳的列: 3

SELECT * 
  FROM `iyc_acymailing_fields`

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
18	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:100
17	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:244
16	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:51
14	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:463
13	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:313
12	AddonParser::viewAddons()	JROOT/templates/flex/html/mod_sppagebuilder/default.php:29
11	require JROOT/templates/flex/html/mod_sppagebuilder/default.php	JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:18
10	include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

查詢時間: 0.17 ms 最後的查詢: 2.53 ms 之後查詢記憶體: 0.020 MB 記憶體於查詢: 7.152 MB 前回傳的列: 1

重覆查詢: #83

select last_check_date 
  from iyc_guru_config 
  where id=1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
10	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
9	JFalangDatabase->execute()	JROOT/components/com_guru/helpers/cronjobs.php:366
8	guru_cronjobs()	JROOT/plugins/system/gurucron/gurucron.php:27
7	plgSystemGuruCron->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

重覆查詢: #82

select last_check_date 
  from iyc_guru_config 
  where id=1

說明

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

側寫

不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)

呼叫堆疊

#	Caller	檔案與行號
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
11	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
10	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
9	JFalangDatabase->loadResult()	JROOT/components/com_guru/helpers/cronjobs.php:367
8	guru_cronjobs()	JROOT/plugins/system/gurucron/gurucron.php:27
7	plgSystemGuruCron->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

選擇表格:

8 × SELECT fc.value 
  FROM iyc_falang_content fc

5 × SELECT * 
  FROM `iyc_sppagebuilder`

4 × SELECT `template` 
  FROM `iyc_template_styles`

4 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM iyc_k2_users

4 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM iyc_modules AS m

4 × SELECT a.enabled 
  FROM `iyc_extensions` AS `a`

3 × SELECT m.* 
  FROM iyc_k2_categories m

2 × SELECT tag.*             
  FROM iyc_k2_tags AS tag             JOIN iyc_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

2 × SELECT enabled 
  FROM iyc_extensions

2 × select `seo` 
  from iyc_guru_confi

2 × SELECT COUNT(*) 
  FROM iyc_k2_comments

```
2 × SELECT * 
  FROM iyc_k2_rating
```

2 × SELECT * 
  FROM iyc_k2_attachments

2 × select last_check_date 
  from iyc_guru_config

```
2 × SELECT * 
  FROM iyc_languages
```

2 × SELECT *             
  FROM iyc_k2_items

2 × 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 iyc_menu AS m 
  LEFT JOIN iyc_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `e`.`manifest_cache` 
  FROM `iyc_extensions` AS `e`

1 × SELECT `id`,`name` 
  FROM `iyc_acym_list`

1 × SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id 
  FROM ( SELECT id,title,level,published,parent_id,lft,rgt 
  FROM iyc_tags

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

1 × SELECT * 
  FROM iyc_acymailing_confi

1 × SELECT * 
  FROM iyc_acymailing_list

1 × SELECT * 
  FROM `iyc_acymailing_fields` as a

1 × SELECT * 
  FROM `iyc_acymailing_fields

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

```
1 × SELECT * 
  FROM iyc_rsform_confi
```

1 × SELECT i.*, c.alias AS categoryalias             
  FROM iyc_k2_items AS i             
  LEFT JOIN iyc_k2_categories c 
  ON c.id = i.catid

```
1 × SELECT * 
  FROM iyc_k2_comments
```

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

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

```
1 × SELECT * 
  FROM `iyc_users`
```

1 × SELECT joomlatablename,tablepkID 
  FROM `iyc_falang_tableinfo

1 × SELECT id, name, parent 
  FROM iyc_k2_categories

1 × SELECT * 
  FROM iyc_k2_categories

```
1 × SELECT * 
  FROM iyc_k2_items
```

1 × SELECT id 
  FROM iyc_k2_categories

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

1 × SELECT i.* 
  FROM iyc_invoices_invoices as i

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

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `iyc_extensions`

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

其他表格:

1 × UPDATE `iyc_extensions` 
  SET `params` = '{\"mediaversion\":\"9ee2de6dfaa29665a53901ac57e5f51c\"}'

1 × SHOW FULL COLUMNS 
  FROM `iyc_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `iyc_languages

1 × SHOW FULL COLUMNS 
  FROM `iyc_users

1 × SHOW FULL COLUMNS 
  FROM `iyc_k2_items

1 × UPDATE iyc_k2_items 
  SET `hits` = (`hits` + 1)