查詢時間: 0.16 ms 查詢記憶體: 0.024 MB 記憶體於查詢: 2.098 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 |
查詢時間: 0.25 ms 最後的查詢: 0.17 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 2.112 MB 前
UPDATE iyc_rsform_config
SET `SettingValue`='1786255609'
WHERE `SettingName`='deleteafter.last_run'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | iyc_rsform_config | NULL | range | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using where |
不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)
| # | Caller | 檔案與行號 |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 10 | JFalangDatabase->execute() | JROOT/administrator/components/com_rsform/helpers/config.php:90 |
| 9 | RSFormProConfig->set() | JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:37 |
| 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 |
查詢時間: 0.05 ms 最後的查詢: 0.04 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 2.117 MB 前 回傳的列: 0
SELECT `FormId`,`DeleteSubmissionsAfter`
FROM `iyc_rsform_forms`
WHERE `DeleteSubmissionsAfter` > '0'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | iyc_rsform_forms | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)
| # | Caller | 檔案與行號 |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 11 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 9 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:47 |
| 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 |
查詢時間: 0.07 ms 最後的查詢: 0.30 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 2.143 MB 前 回傳的列: 1
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 |
查詢時間: 0.06 ms 最後的查詢: 0.20 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 2.169 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 |
查詢時間: 8.45 ms 最後的查詢: 0.14 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 2.163 MB 前
UPDATE `iyc_extensions`
SET `params` = '{\"mediaversion\":\"b5263874f811be6a0cb0e1c266eb847c\"}'
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 |
查詢時間: 0.88 ms 最後的查詢: 0.54 ms 之後 查詢記憶體: 0.082 MB 記憶體於查詢: 2.213 MB 前 回傳的列: 68
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 |
查詢時間: 0.19 ms 最後的查詢: 5.04 ms 之後 查詢記憶體: 0.081 MB 記憶體於查詢: 3.138 MB 前 回傳的列: 68
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 |
查詢時間: 0.37 ms 最後的查詢: 0.62 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.131 MB 前 回傳的列: 1
SELECT `query`
FROM iyc_eb_urls
WHERE md5_key = 'af142be5df08b51c3533430b8a3ff842'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | iyc_eb_urls | NULL | ref | idx_md5_key | idx_md5_key | 99 | const | 1 | 100.00 | NULL |
不使用 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/plugins/system/falangdriver/falang_database.php:416 |
| 12 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 11 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 10 | JFalangDatabase->loadResult() | JROOT/components/com_eventbooking/router.php:429 |
| 9 | EventbookingRouter->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php: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 |
查詢時間: 0.48 ms 最後的查詢: 0.24 ms 之後 查詢記憶體: 0.038 MB 記憶體於查詢: 3.142 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 |
查詢時間: 0.18 ms 最後的查詢: 1.56 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 3.227 MB 前 回傳的列: 0
SELECT i.*
FROM iyc_invoices_invoices as i
WHERE i.is_recurrent = 1
AND rec_nextdate = "2026-08-09"
| 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 |
查詢時間: 0.08 ms 最後的查詢: 1.09 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.273 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 |
查詢時間: 0.17 ms 最後的查詢: 2.85 ms 之後 查詢記憶體: 0.050 MB 記憶體於查詢: 3.590 MB 前 回傳的列: 242
SELECT `config_key`,`config_value`
FROM iyc_eb_configs
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | iyc_eb_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 242 | 100.00 | NULL |
不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)
| # | Caller | 檔案與行號 |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 12 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 10 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:39 |
| 9 | RADConfig->__construct() | JROOT/components/com_eventbooking/helper/helper.php:115 |
| 8 | EventbookingHelper::getConfig() | JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:66 |
| 7 | require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php | JROOT/components/com_eventbooking/eventbooking.php:14 |
| 6 | require_once JROOT/components/com_eventbooking/eventbooking.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 |
查詢時間: 0.09 ms 最後的查詢: 0.61 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.661 MB 前 回傳的列: 1
SELECT *
FROM iyc_eb_themes
WHERE published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | iyc_eb_themes | NULL | system | idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
不使用 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/components/com_eventbooking/helper/helper.php:269 |
| 9 | EventbookingHelper::getDefaultTheme() | JROOT/components/com_eventbooking/controller/controller.php:99 |
| 8 | EventbookingController->display() | JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273 |
| 7 | RADController->execute() | JROOT/components/com_eventbooking/eventbooking.php:22 |
| 6 | require_once JROOT/components/com_eventbooking/eventbooking.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 |
查詢時間: 0.15 ms 最後的查詢: 1.31 ms 之後 查詢記憶體: 0.027 MB 記憶體於查詢: 3.690 MB 前 回傳的列: 69
SELECT `message_key`,`message`
FROM iyc_eb_messages
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | iyc_eb_messages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 69 | 100.00 | NULL |
不使用 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/administrator/components/com_eventbooking/libraries/rad/config/config.php:39 |
| 12 | RADConfig->__construct() | JROOT/components/com_eventbooking/helper/helper.php:346 |
| 11 | EventbookingHelper::getMessages() | JROOT/components/com_eventbooking/view/invite/html.php:35 |
| 10 | EventbookingViewInviteHtml->display() | JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308 |
| 9 | RADController->display() | JROOT/components/com_eventbooking/controller/controller.php:107 |
| 8 | EventbookingController->display() | JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273 |
| 7 | RADController->execute() | JROOT/components/com_eventbooking/eventbooking.php:22 |
| 6 | require_once JROOT/components/com_eventbooking/eventbooking.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 |
查詢時間: 1.15 ms 最後的查詢: 1.72 ms 之後 查詢記憶體: 0.092 MB 記憶體於查詢: 3.800 MB 前 回傳的列: 1
SELECT a.*, IFNULL(SUM(b.number_registrants), 0) AS total_registrants,DATEDIFF(event_date, '2026-08-09 14:06:49') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-08-09 14:06:49') AS event_start_minutes,DATEDIFF('2026-08-09 14:06:49', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, registration_start_date, '2026-08-09 14:06:49') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-08-09 14:06:49') AS cut_off_minutes,DATEDIFF(early_bird_discount_date, '2026-08-09 14:06:49') AS date_diff
FROM iyc_eb_events AS a
LEFT JOIN iyc_eb_registrants AS b
ON (a.id = b.event_id
AND b.group_id=0
AND (b.published = 1 OR (b.payment_method LIKE "os_offline%"
AND b.published NOT IN (2,3))))
WHERE a.id=208
GROUP BY a.id| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | ref | nice_eb_registrants_FKIndex1,idx_published | nice_eb_registrants_FKIndex1 | 5 | const | 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/plugins/system/falangdriver/falang_database.php:416 |
| 12 | JFalangDatabase->loadObject() | JROOT/components/com_eventbooking/helper/database.php:82 |
| 11 | EventbookingHelperDatabase::getEvent() | JROOT/components/com_eventbooking/view/invite/html.php:58 |
| 10 | EventbookingViewInviteHtml->display() | JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308 |
| 9 | RADController->display() | JROOT/components/com_eventbooking/controller/controller.php:107 |
| 8 | EventbookingController->display() | JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273 |
| 7 | RADController->execute() | JROOT/components/com_eventbooking/eventbooking.php:22 |
| 6 | require_once JROOT/components/com_eventbooking/eventbooking.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 |
查詢時間: 0.12 ms 最後的查詢: 1.14 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 3.821 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 |
查詢時間: 0.07 ms 最後的查詢: 0.42 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 3.835 MB 前 回傳的列: 1
SELECT *
FROM `iyc_template_styles`
WHERE `client_id` = 0
AND `id` = '10'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | iyc_template_styles | NULL | const | PRIMARY,idx_client_id,idx_client_id_home | PRIMARY | 4 | const | 1 | 100.00 | NULL |
不使用 SHOW PROFILE (有可能是因為超過 100 個查詢)
| # | Caller | 檔案與行號 |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 11 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 9 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 8 | JFalangDatabase->loadObject() | JROOT/plugins/system/helix3/helix3.php:85 |
| 7 | plgSystemHelix3->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 |
查詢時間: 2.66 ms 最後的查詢: 1.41 ms 之後 查詢記憶體: 0.020 MB 記憶體於查詢: 3.905 MB 前 回傳的列: 1
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 |
查詢時間: 0.06 ms 最後的查詢: 0.13 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 3.910 MB 前 回傳的列: 1
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 |
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
2 × select last_check_date
from iyc_guru_config
1 × SELECT *
FROM iyc_rsform_confi
1 × SELECT `FormId`,`DeleteSubmissionsAfter`
FROM `iyc_rsform_forms`
1 × SELECT `template`
FROM `iyc_template_styles`
1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `iyc_extensions`
1 × SELECT `query`
FROM iyc_eb_urls
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 i.*
FROM iyc_invoices_invoices as i
1 × SELECT *
FROM iyc_languages
1 × SELECT `config_key`,`config_value`
FROM iyc_eb_config
1 × SELECT *
FROM iyc_eb_themes
1 × SELECT `message_key`,`message`
FROM iyc_eb_message
1 × SELECT a.*, IFNULL(SUM(b.number_registrants), 0) AS total_registrants,DATEDIFF(event_date, '2026-08-09 14:06:49') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2026-08-09 14:06:49') AS event_start_minutes,DATEDIFF('2026-08-09 14:06:49', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, registration_start_date, '2026-08-09 14:06:49') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2026-08-09 14:06:49') AS cut_off_minutes,DATEDIFF(early_bird_discount_date, '2026-08-09 14:06:49') AS date_diff
FROM iyc_eb_events AS a
LEFT JOIN iyc_eb_registrants AS b
ON (a.id = b.event_id
AND b.group_id=0
AND (b.published = 1 OR (b.payment_method LIKE "os_offline%"
AND b.published NOT IN (2,3))))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_template_styles`