ค้นหา
จูมล่าดีบัคคอนโซล
{ "__default": { "session": { "counter": 1, "timer": { "start": 1734784237, "last": 1734784237, "now": 1734784237 } }, "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 } } }
Time
หน่วยความจำ
Time: 19.17 ms / 19.17 ms หน่วยความจำ: 0.739 MB / 0.96 MB Application: afterLoad
Time: 65.15 ms / 84.32 ms หน่วยความจำ: 3.982 MB / 4.94 MB Application: afterInitialise
Time: 13.88 ms / 98.20 ms หน่วยความจำ: 1.215 MB / 6.16 MB Application: afterRoute
Time: 10.43 ms / 108.63 ms หน่วยความจำ: 0.334 MB / 6.49 MB Application: beforeRenderComponent com_search
Time: 105.47 ms / 214.09 ms หน่วยความจำ: 1.755 MB / 8.24 MB Application: afterRenderComponent com_search
Time: 2.87 ms / 216.97 ms หน่วยความจำ: 0.007 MB / 8.25 MB Application: afterDispatch
Time: 6.58 ms / 223.55 ms หน่วยความจำ: 0.186 MB / 8.44 MB Application: beforeRenderModule mod_banners (Logo Footer)
Time: 14.66 ms / 238.21 ms หน่วยความจำ: 0.347 MB / 8.78 MB Application: afterRenderModule mod_banners (Logo Footer)
Time: 0.16 ms / 238.37 ms หน่วยความจำ: 0.000 MB / 8.77 MB Application: beforeRenderModule mod_custom (footer)
Time: 1.37 ms / 239.74 ms หน่วยความจำ: 0.012 MB / 8.78 MB Application: afterRenderModule mod_custom (footer)
Time: 0.23 ms / 239.97 ms หน่วยความจำ: 0.000 MB / 8.78 MB Application: beforeRenderModule mod_menu (responsive_nav)
Time: 17.75 ms / 257.72 ms หน่วยความจำ: 0.252 MB / 9.03 MB Application: afterRenderModule mod_menu (responsive_nav)
Time: 0.27 ms / 257.98 ms หน่วยความจำ: 0.000 MB / 9.02 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 12.62 ms / 270.60 ms หน่วยความจำ: 0.019 MB / 9.04 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.23 ms / 270.83 ms หน่วยความจำ: 0.000 MB / 9.04 MB Application: beforeRenderModule mod_banners (Logo header)
Time: 10.14 ms / 280.97 ms หน่วยความจำ: 0.070 MB / 9.11 MB Application: afterRenderModule mod_banners (Logo header)
Time: 0.22 ms / 281.20 ms หน่วยความจำ: 0.000 MB / 9.10 MB Application: beforeRenderModule mod_custom (header-email)
Time: 0.66 ms / 281.85 ms หน่วยความจำ: 0.007 MB / 9.10 MB Application: afterRenderModule mod_custom (header-email)
Time: 0.13 ms / 281.98 ms หน่วยความจำ: 0.000 MB / 9.10 MB Application: beforeRenderModule mod_custom (header-tel)
Time: 0.52 ms / 282.50 ms หน่วยความจำ: 0.007 MB / 9.11 MB Application: afterRenderModule mod_custom (header-tel)
Time: 3.70 ms / 286.20 ms หน่วยความจำ: 0.081 MB / 9.19 MB Application: afterRender
Database queries total: 33.23 ms
9.51 MB (9,972,448 Bytes)
20 Queries Logged 33.23 ms
- Query Time: 0.47 ms Query memory: 0.018 MB Memory before query: 2.999 MB Rows returned: 0
SELECT `data`
FROM `sp_session`
WHERE `session_id` = 'qdt7n698640pd0kn1c5nrini45'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:259 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:773 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.41 ms After last query: 3.28 ms Query memory: 0.008 MB Memory before query: 3.206 MB
DELETE
FROM `sp_session`
WHERE `time` < '1734775237'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE sp_session NULL range time time 59 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.07 ms updating 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:790 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.21 ms After last query: 0.16 ms Query memory: 0.012 MB Memory before query: 3.218 MB Rows returned: 0
SELECT `session_id`
FROM `sp_session`
WHERE `session_id` = 'qdt7n698640pd0kn1c5nrini45'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 8.22 ms After last query: 0.14 ms Query memory: 0.009 MB Memory before query: 3.234 MB
INSERT INTO `sp_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('qdt7n698640pd0kn1c5nrini45', 0, 1, '1734784237', 0, '')EXPLAIN not possible on query: INSERT INTO `sp_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('qdt7n698640pd0kn1c5nrini45', 0, 1, '1734784237', 0, '')Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 3.69 ms end 0.01 ms query end 4.32 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:212 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.73 ms After last query: 4.23 ms Query memory: 0.017 MB Memory before query: 3.488 MB Rows returned: 31
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sp_extensions`
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_extensions NULL ref extension extension 82 const 31 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.16 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 2.19 ms Query memory: 0.015 MB Memory before query: 3.687 MB Rows returned: 2
SELECT b.id
FROM sp_usergroups AS a
LEFT JOIN sp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:835 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.87 ms Query memory: 0.015 MB Memory before query: 3.763 MB Rows returned: 5
SELECT id, rules
FROM `sp_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 0.17 ms Query memory: 0.013 MB Memory before query: 3.782 MB Rows returned: 42
SELECT folder AS type, element AS name, params
FROM sp_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_extensions NULL ref extension extension 82 const 58 0.66 Using index condition; Using where; Using filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 7 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.23 ms After last query: 18.20 ms Query memory: 0.032 MB Memory before query: 5.175 MB Rows returned: 49
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sp_menu AS m
LEFT JOIN sp_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 54 10.00 Using index condition; Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 spsling_new.m.component_id 1 100.00 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.59 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:145 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:439 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:57 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:197 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:535 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1115 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 10.51 ms Query memory: 0.019 MB Memory before query: 6.204 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sp_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 13 JDatabaseDriver->loadObject() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 10 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:977 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 4.05 ms After last query: 0.28 ms Query memory: 0.012 MB Memory before query: 6.207 MB
UPDATE `sp_extensions`
SET `params` = '{\"mediaversion\":\"b33cf221c7b4d5ffd8026260d90c45a3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE sp_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.07 ms updating 0.07 ms end 0.01 ms query end 3.63 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:977 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 2.91 ms Query memory: 0.014 MB Memory before query: 6.455 MB Rows returned: 2
SELECT *
FROM sp_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where; Using filesort Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 0.46 ms Query memory: 0.010 MB Memory before query: 6.478 MB Rows returned: 3
SELECT id, home, template, s.params
FROM sp_template_styles as s
LEFT JOIN sp_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 5 20.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 spsling_new.s.template,const 1 4.64 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 4 JApplicationSite->getTemplate() JROOT/libraries/cms/application/site.php:165 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.30 ms After last query: 111.78 ms Query memory: 0.021 MB Memory before query: 8.390 MB Rows returned: 7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sp_modules AS m
LEFT JOIN sp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-21 12:30:37')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-21 12:30:37')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 140 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 20 2.70 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 spsling_new.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 spsling_new.m.id 1 40.00 Using where; Using index Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.40 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 12 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:425 11 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:361 10 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 9 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:501 8 JDocumentHtml->countModules() JROOT/templates/spsling/index.php:59 7 require JROOT/templates/spsling/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 4.96 ms Query memory: 0.025 MB Memory before query: 8.538 MB Rows returned: 0Duplicate queries: #18
SELECT *
FROM sp_banners
WHERE '2024-12-21 12:30:37' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)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 Impossible WHERE Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 2.76 ms Query memory: 0.024 MB Memory before query: 8.737 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sp_banners as a
LEFT JOIN sp_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-21 12:30:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-21 12:30:37')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (10)
ORDER BY a.sticky DESC,a.ordering
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_banner_catid idx_banner_catid 4 const 1 7.14 Using index condition; Using where; Using filesort 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 spsling_new.a.cid 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:310 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:183 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:205 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 5.79 ms After last query: 0.37 ms Query memory: 0.016 MB Memory before query: 8.766 MB
UPDATE sp_banners
SET impmade = (impmade + 1)
WHERE id IN (2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE sp_banners NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.04 ms updating 0.07 ms end 0.01 ms query end 5.29 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:246 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 35.55 ms Query memory: 0.026 MB Memory before query: 9.065 MB Rows returned: 0Duplicate queries: #15
SELECT *
FROM sp_banners
WHERE '2024-12-21 12:30:37' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)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 Impossible WHERE Status Duration starting 0.15 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 9.088 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sp_banners as a
LEFT JOIN sp_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-21 12:30:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-21 12:30:37')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (9)
ORDER BY a.sticky DESC,a.ordering
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_banner_catid idx_banner_catid 4 const 1 7.14 Using index condition; Using where; Using filesort 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 spsling_new.a.cid 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:310 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:183 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:205 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 5.89 ms After last query: 0.33 ms Query memory: 0.016 MB Memory before query: 9.116 MB
UPDATE sp_banners
SET impmade = (impmade + 1)
WHERE id IN (1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE sp_banners NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.03 ms updating 0.06 ms end 0.01 ms query end 5.50 ms closing tables 0.05 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:246 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:199 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49
16 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT *
FROM sp_banners2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `sp_extensions`2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sp_banners as a
LEFT JOIN sp_banner_clients AS cl
ON cl.id = a.cid1 × SELECT id, home, template, s.params
FROM sp_template_styles as s
LEFT JOIN sp_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sp_modules AS m
LEFT JOIN sp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM sp_languages1 × SELECT folder AS type, element AS name, params
FROM sp_extensions1 × SELECT `session_id`
FROM `sp_session`1 × SELECT b.id
FROM sp_usergroups AS a
LEFT JOIN sp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `sp_viewlevels1 × SELECT `data`
FROM `sp_session`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sp_menu AS m
LEFT JOIN sp_extensions AS e
ON m.component_id = e.extension_id
OTHER Tables:
2 × UPDATE sp_banners
SET impmade = (impmade + 1)1 × UPDATE `sp_extensions`
SET `params` = '{\"mediaversion\":\"b33cf221c7b4d5ffd8026260d90c45a3\"}'1 × INSERT INTO `sp_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('qdt7n698640pd0kn1c5nrini45', 0, 1, '1734784237', 0, ''1 × DELETE
FROM `sp_session`