Tarek Amer School
Tarek Amer
School
Tarek Amer school is a comprehensive Language , Computing and Soft skills school located in Baranovichi Belarus. With more than 19 years of experience and wide range of courses. Tarek Amer school is your career development partner and your guide to success in your professional life.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1656106961,
"last": 1656106961,
"now": 1656106961
}
},
"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": [
"9"
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 16.41 ms / 16.41 ms Memory: 0.173 MB / 0.40 MB Application: afterLoad
Time: 306.01 ms / 322.42 ms Memory: 1.662 MB / 2.06 MB Application: afterInitialise
Time: 44.84 ms / 367.26 ms Memory: 1.129 MB / 3.19 MB Application: afterRoute
Time: 4.24 ms / 371.50 ms Memory: 0.075 MB / 3.27 MB Application: beforeRenderComponent com_content
Time: 618.61 ms / 990.11 ms Memory: 1.152 MB / 4.42 MB Application: afterRenderComponent com_content
Time: 1.02 ms / 991.13 ms Memory: 0.020 MB / 4.44 MB Application: afterDispatch
Time: 13.56 ms / 1004.69 ms Memory: 0.133 MB / 4.57 MB Application: beforeRenderModule mod_joombig_video_slider_vertical (Video Album on HomePage)
Time: 87.78 ms / 1092.47 ms Memory: 0.060 MB / 4.63 MB Application: afterRenderModule mod_joombig_video_slider_vertical (Video Album on HomePage)
Time: 0.26 ms / 1092.73 ms Memory: 0.000 MB / 4.60 MB Application: beforeRenderModule mod_jbmenu (FooterMenu)
Time: 23.11 ms / 1115.84 ms Memory: 0.052 MB / 4.65 MB Application: afterRenderModule mod_jbmenu (FooterMenu)
Time: 0.24 ms / 1116.08 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_fblikebox (Facebook Like Box - Live)
Time: 21.43 ms / 1137.51 ms Memory: 0.040 MB / 4.69 MB Application: afterRenderModule mod_fblikebox (Facebook Like Box - Live)
Time: 0.13 ms / 1137.64 ms Memory: 0.000 MB / 4.68 MB Application: beforeRenderModule mod_custom (Translation)
Time: 10.11 ms / 1147.76 ms Memory: 0.010 MB / 4.69 MB Application: afterRenderModule mod_custom (Translation)
Time: 0.24 ms / 1148.00 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_custom (Welcome to School Custom P8 HomePage)
Time: 0.30 ms / 1148.30 ms Memory: 0.007 MB / 4.69 MB Application: afterRenderModule mod_custom (Welcome to School Custom P8 HomePage)
Time: 0.09 ms / 1148.39 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_ext_vk_community (EXT Vk Community)
Time: 10.68 ms / 1159.07 ms Memory: 0.015 MB / 4.71 MB Application: afterRenderModule mod_ext_vk_community (EXT Vk Community)
Time: 0.30 ms / 1159.37 ms Memory: 0.003 MB / 4.71 MB Application: beforeRenderModule mod_ariimageslider (New HomePage Banner Slide Image)
Time: 169.02 ms / 1328.39 ms Memory: 0.200 MB / 4.91 MB Application: afterRenderModule mod_ariimageslider (New HomePage Banner Slide Image)
Time: 0.24 ms / 1328.63 ms Memory: 0.000 MB / 4.86 MB Application: beforeRenderModule mod_jbmenu (JB DropDown Menu)
Time: 29.17 ms / 1357.80 ms Memory: 0.216 MB / 5.08 MB Application: afterRenderModule mod_jbmenu (JB DropDown Menu)
Time: 0.13 ms / 1357.93 ms Memory: 0.000 MB / 5.07 MB Application: beforeRenderModule mod_languages (عربي)
Time: 24.24 ms / 1382.17 ms Memory: 0.042 MB / 5.11 MB Application: afterRenderModule mod_languages (عربي)
Time: 0.16 ms / 1382.34 ms Memory: 0.000 MB / 5.11 MB Application: beforeRenderModule mod_creativesocialwidget (Creative Social Widget)
Time: 22.11 ms / 1404.44 ms Memory: 0.069 MB / 5.18 MB Application: afterRenderModule mod_creativesocialwidget (Creative Social Widget)
Time: 0.13 ms / 1404.57 ms Memory: 0.000 MB / 5.16 MB Application: beforeRenderModule mod_search (Search main page)
Time: 21.61 ms / 1426.18 ms Memory: 0.029 MB / 5.19 MB Application: afterRenderModule mod_search (Search main page)
Time: 15.23 ms / 1441.42 ms Memory: 0.112 MB / 5.30 MB Application: afterRender
Database queries total: 241.55 ms
5.91 MB (6,196,960 Bytes)
37 Queries Logged 241.55 ms
- Query Time: 1.03 ms Query memory: 0.017 MB Memory before query: 0.874 MB Rows returned: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '7ovfavifgn6m7qhv0i3897npq5'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.30 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.16 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 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:258 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:748 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.58 ms After last query: 1.20 ms Query memory: 0.008 MB Memory before query: 0.936 MB
DELETE
FROM `jos_session`
WHERE `time` < '1656106061'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session range time time 59 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.23 ms updating 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:765 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.55 ms After last query: 0.16 ms Query memory: 0.010 MB Memory before query: 0.948 MB Rows returned: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '7ovfavifgn6m7qhv0i3897npq5'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.10 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.01 ms query end 0.02 ms closing tables 0.13 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.35 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 0.960 MB
INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
VALUES ('7ovfavifgn6m7qhv0i3897npq5', 0, '1656106961')EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('7ovfavifgn6m7qhv0i3897npq5', 0, '1656106961')Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:208 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.62 ms After last query: 1.37 ms Query memory: 0.012 MB Memory before query: 1.039 MB Rows returned: 46Duplicate queries: #37
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 46 100.00 Using index condition Status Duration starting 0.07 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.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.25 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.05 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 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:584 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 0.90 ms Query memory: 0.013 MB Memory before query: 1.110 MB Rows returned: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.03 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:354 8 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:423 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 0.23 ms Query memory: 0.011 MB Memory before query: 1.129 MB Rows returned: 5
SELECT id, rules
FROM `jos_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.06 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.01 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1497 8 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:440 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.91 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 1.148 MB Rows returned: 69
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 72 100.00 Using index condition; Using where; Using filesort Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.44 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 5.53 ms After last query: 29.32 ms Query memory: 0.013 MB Memory before query: 1.754 MB Rows returned: 1
SELECT count(*)
FROM `jos_cwgears_schedule`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Select tables optimized away Status Duration starting 0.11 ms checking permissions 0.01 ms Opening tables 5.08 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.04 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:74 9 plgSystemCwgears->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.17 ms Query memory: 0.013 MB Memory before query: 1.768 MB Rows returned: 1
SELECT count(*)
FROM `jos_cwgears_schedule`
WHERE time + '3600'<'1656106961'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.11 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.21 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.24 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:96 9 plgSystemCwgears->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.23 ms After last query: 0.14 ms Query memory: 0.012 MB Memory before query: 1.782 MB
DELETE
FROM `jos_cwgears`
WHERE time + '3600'<'1656106961'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_cwgears ALL NULL NO INDEX KEY COULD BE USED NULL NULL 0 100.00 Using where Status Duration starting 0.20 ms checking permissions 0.12 ms Opening tables 1.67 ms init 0.02 ms System lock 0.03 ms updating 0.01 ms end 0.05 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.22 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/plugins/system/cwgears/cwgears.php:107 9 plgSystemCwgears->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.13 ms Query memory: 0.012 MB Memory before query: 1.794 MB
UPDATE `jos_cwgears_schedule`
SET time = '1656106961'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_cwgears_schedule ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms updating 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 1.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/plugins/system/cwgears/cwgears.php:114 9 plgSystemCwgears->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 175.79 ms After last query: 0.93 ms Query memory: 0.014 MB Memory before query: 1.843 MB Rows returned: 0
SELECT timestamp
FROM jos_zt_visitor_counter
WHERE ipaddress = '44.201.96.43'
AND useragent LIKE "%other%"
ORDER BY timestamp DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_zt_visitor_counter index NULL timestamp 4 NULL 1 2275300.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 1.72 ms init 0.03 ms System lock 0.04 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.06 ms executing 0.01 ms Sending data 173.45 ms end 0.03 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 11 JDatabaseDriver->loadResult() JROOT/plugins/system/zt_visitor_counter/helper.php:65 10 plgZTVisitorCounterHelper::getLastVisit() JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42 9 plgSystemZT_Visitor_Counter->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.96 ms After last query: 0.36 ms Query memory: 0.014 MB Memory before query: 1.859 MB
INSERT INTO `jos_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`)
VALUES (null, '1656107861', 1 , 1 , '44.201.96.43', 'other')EXPLAIN not possible on query: INSERT INTO `jos_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) VALUES (null, '1656107861', 1 , 1 , '44.201.96.43', 'other')Status Duration starting 0.33 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms update 0.35 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 11 JDatabase->query() JROOT/plugins/system/zt_visitor_counter/helper.php:31 10 plgZTVisitorCounterHelper::addVisits() JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:46 9 plgSystemZT_Visitor_Counter->onAfterInitialise() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:663 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 4.14 ms After last query: 87.58 ms Query memory: 0.020 MB Memory before query: 2.116 MB Rows returned: 87
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 jos_menu AS m
LEFT JOIN jos_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 139 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 i674919_jos8.m.component_id 1 100.00 Using where Status Duration starting 0.29 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.04 ms init 0.07 ms System lock 0.01 ms optimizing 0.13 ms statistics 0.14 ms preparing 0.04 ms Sorting result 0.17 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 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:133 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:435 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:196 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:531 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1097 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 7.15 ms Query memory: 0.022 MB Memory before query: 3.077 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.03 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 18 JDatabaseDriver->loadObject() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 16 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 15 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 14 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 13 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:123 9 plgSystemCwgears->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.81 ms Query memory: 0.018 MB Memory before query: 3.099 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"4f45fa73320b7eefd73f59ab1c2c531a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.15 ms updating 0.16 ms end 0.01 ms query end 0.03 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 14 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 13 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 12 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 11 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 10 JFactory::getDocument() JROOT/plugins/system/cwgears/cwgears.php:123 9 plgSystemCwgears->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 0.67 ms Query memory: 0.014 MB Memory before query: 3.177 MB Rows returned: 1
SELECT count(*)
FROM `jos_extensions`
WHERE `element` = 'cwgears'
AND `extension_id` = ''id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.05 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 11 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:832 10 plgSystemCwgears->updateDownloadKeySub() JROOT/plugins/system/cwgears/cwgears.php:130 9 plgSystemCwgears->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.68 ms After last query: 0.82 ms Query memory: 0.009 MB Memory before query: 3.226 MB Rows returned: 2
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Using where; Using filesort Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 1.11 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.05 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.14 ms end 0.03 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.72 ms After last query: 0.56 ms Query memory: 0.008 MB Memory before query: 3.250 MB Rows returned: 1
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 i674919_jos8.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 84.61 ms Query memory: 0.019 MB Memory before query: 3.400 MB Rows returned: 1
SELECT a.rules
FROM jos_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.18 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 executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.10 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 13 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:384 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:439 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.02 ms After last query: 0.53 ms Query memory: 0.020 MB Memory before query: 3.429 MB Rows returned: 2
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 11 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.44 ms preparing 0.03 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.33 ms Creating sort index 0.19 ms end 0.01 ms removing tmp table 0.34 ms end 0.13 ms query end 0.01 ms closing tables 0.11 ms freeing items 0.06 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 15 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 14 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 13 JAccess::check() JROOT/libraries/joomla/user/user.php:393 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:439 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 3.68 ms After last query: 15.62 ms Query memory: 0.020 MB Memory before query: 3.480 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `jos_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_content`Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.46 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 1.87 ms checking permissions 0.07 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.16 ms checking permissions 0.01 ms checking permissions 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.14 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.09 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.05 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/libraries/legacy/table/content.php:31 11 JTableContent->__construct() JROOT/libraries/joomla/table/table.php:305 10 JTable::getInstance() JROOT/components/com_content/models/article.php:264 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 66.71 ms Query memory: 0.015 MB Memory before query: 3.620 MB Rows returned: 1
SELECT *
FROM jos_content
WHERE `id` = '41'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_content const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.17 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1456 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:728 10 JTable->load() JROOT/components/com_content/models/article.php:265 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.83 ms After last query: 0.28 ms Query memory: 0.014 MB Memory before query: 3.635 MB
UPDATE jos_content
SET `hits` = (`hits` + 1)
WHERE `id` = '41'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_content range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.18 ms updating 0.29 ms end 0.01 ms query end 0.03 ms closing tables 0.08 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1249 10 JTable->hit() JROOT/components/com_content/models/article.php:266 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 5.58 ms After last query: 11.60 ms Query memory: 0.018 MB Memory before query: 3.701 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
on c.id = a.catid
LEFT JOIN jos_users AS u
on u.id = a.created_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 41
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-06-24 21:42:42')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-06-24 21:42:42')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a const PRIMARY,idx_state PRIMARY 4 const 1 100.00 NULL 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY u const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY parent const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY v const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 const 2 100.00 Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 1 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias idx_left_right 8 NULL 24 100.00 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.34 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 3.82 ms init 0.10 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.02 ms statistics 0.23 ms preparing 0.04 ms executing 0.08 ms Sending data 0.03 ms executing 0.01 ms Sending data 0.08 ms Creating sort index 0.27 ms removing tmp table 0.03 ms Creating sort index 0.03 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.05 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:159 12 ContentModelArticle->getItem() JROOT/libraries/legacy/view/legacy.php:401 11 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 7.36 ms After last query: 17.91 ms Query memory: 0.019 MB Memory before query: 3.812 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN jos_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
AND s.id=17
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 24 87.50 Using where 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 i674919_jos8.c.id 4 100.00 Using where; Not exists; Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias idx_left_right 8 NULL 24 100.00 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.25 ms checking permissions 0.01 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.49 ms preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.03 ms statistics 0.25 ms preparing 0.04 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.05 ms Sending data 0.05 ms executing 0.01 ms Sending data 0.09 ms Creating sort index 0.24 ms removing tmp table 0.01 ms Creating sort index 0.32 ms Creating sort index 0.11 ms end 0.02 ms removing tmp table 4.63 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 14 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 13 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 12 JCategories->get() JROOT/components/com_content/helpers/route.php:44 11 ContentHelperRoute::getArticleRoute() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 3.80 ms After last query: 13.18 ms Query memory: 0.016 MB Memory before query: 3.879 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 41
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 i674919_jos8.m.tag_id 1 100.00 Using where Status Duration starting 0.20 ms checking permissions 0.04 ms checking permissions 0.01 ms Opening tables 2.79 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.27 ms preparing 0.03 ms executing 0.02 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.36 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 11 JHelperTags->getItemTags() JROOT/components/com_content/views/article/view.html.php:156 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 5.60 ms After last query: 15.45 ms Query memory: 0.021 MB Memory before query: 3.910 MB
CREATE TABLE IF NOT EXISTS `jos_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `jos_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Status Duration starting 0.22 ms checking permissions 0.01 ms Opening tables 5.22 ms After create 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 16 JDatabase->query() JROOT/plugins/content/powrshortcodes/powrshortcodes.php:44 15 PowrHelper->get_powr_token() JROOT/plugins/content/powrshortcodes/powrshortcodes.php:21 14 PowrHelper->__construct() JROOT/plugins/content/powrshortcodes/powrshortcodes.php:91 13 require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php JROOT/libraries/cms/plugin/helper.php:230 12 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 11 JPluginHelper::importPlugin() JROOT/components/com_content/views/article/view.html.php:160 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 3.932 MB Rows returned: 1
SELECT value
FROM jos_powr
WHERE data_type = 'powr_token'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_powr const PRIMARY PRIMARY 152 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1456 16 JDatabaseDriver->loadAssoc() JROOT/plugins/content/powrshortcodes/powrshortcodes.php:49 15 PowrHelper->get_powr_token() JROOT/plugins/content/powrshortcodes/powrshortcodes.php:21 14 PowrHelper->__construct() JROOT/plugins/content/powrshortcodes/powrshortcodes.php:91 13 require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php JROOT/libraries/cms/plugin/helper.php:230 12 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 11 JPluginHelper::importPlugin() JROOT/components/com_content/views/article/view.html.php:160 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.23 ms After last query: 373.33 ms Query memory: 0.016 MB Memory before query: 4.477 MB Rows returned: 17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2022-06-24 21:42:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-06-24 21:42:42')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 38 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 i674919_jos8.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 i674919_jos8.m.id 3 100.00 Using where; Using index Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.13 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.32 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 1.22 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/module/helper.php:409 11 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:352 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/protostar/index.php:60 7 require JROOT/templates/protostar/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 375.96 ms Query memory: 0.018 MB Memory before query: 5.106 MB Rows returned: 2
SELECT element
FROM jos_extensions
WHERE type = 'language'
AND client_id = 0
AND enabled = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 4 100.00 Using index condition; Using where Status Duration starting 0.17 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.03 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/multilang.php:90 12 JLanguageMultilang::getSiteLangs() JROOT/modules/mod_languages/helper.php:76 11 ModLanguagesHelper::getList() JROOT/modules/mod_languages/mod_languages.php:18 10 include JROOT/modules/mod_languages/mod_languages.php JROOT/libraries/cms/module/helper.php:190 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:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.90 ms After last query: 17.21 ms Query memory: 0.016 MB Memory before query: 5.131 MB Rows returned: 1
SELECT *
FROM `jos_creativesocialwidget_blocks`
WHERE id = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_creativesocialwidget_blocks system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL Status Duration starting 0.22 ms checking permissions 0.01 ms Opening tables 2.08 ms init 0.03 ms System lock 0.11 ms optimizing 0.01 ms statistics 0.21 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.32 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1456 11 JDatabaseDriver->loadAssoc() JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.php:27 10 include JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.php JROOT/libraries/cms/module/helper.php:190 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:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 4.10 ms After last query: 0.19 ms Query memory: 0.015 MB Memory before query: 5.164 MB Rows returned: 6
SELECT sp.id id_link, sp.id_type id_type, sp.name link_name, sp.link link_url, sp.target target, sa.name type_name, sa.url type_url
FROM `jos_creativesocialwidget_items` sp JOIN `jos_creativesocialwidget_link_types` sa
ON sa.id = sp.id_type
WHERE sp.published = '1'
AND sp.id_share = '1'
ORDER BY sp.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp ref id_share,id_user id_share 4 const 13 100.00 Using where; Using filesort 1 SIMPLE sa eq_ref PRIMARY PRIMARY 4 i674919_jos8.sp.id_type 1 100.00 NULL Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.43 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.12 ms Sorting result 0.12 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.73 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.57 ms cleaning up 0.55 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1497 11 JDatabaseDriver->loadAssocList() JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.php:179 10 include JROOT/modules/mod_creativesocialwidget/mod_creativesocialwidget.php JROOT/libraries/cms/module/helper.php:190 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:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 22.67 ms Query memory: 0.019 MB Memory before query: 5.186 MB Rows returned: 0
SELECT uikit
FROM `jos_cwgears`
WHERE url = 'http://www.acornsoftware.net/school-en/'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.43 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:48 14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:347 13 plgSystemCwgears->onBeforeCompileHead() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 9 JApplicationBase->triggerEvent() JROOT/libraries/joomla/document/renderer/html/head.php:58 8 JDocumentRendererHtmlHead->fetchHead() JROOT/libraries/joomla/document/renderer/html/head.php:34 7 JDocumentRendererHtmlHead->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 0.27 ms Query memory: 0.019 MB Memory before query: 5.206 MB Rows returned: 0
SELECT uikit_plus
FROM `jos_cwgears`
WHERE url = 'http://www.acornsoftware.net/school-en/'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.10 ms checking permissions 0.05 ms Opening tables 0.02 ms init 0.18 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 1.26 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:48 14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:356 13 plgSystemCwgears->onBeforeCompileHead() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 9 JApplicationBase->triggerEvent() JROOT/libraries/joomla/document/renderer/html/head.php:58 8 JDocumentRendererHtmlHead->fetchHead() JROOT/libraries/joomla/document/renderer/html/head.php:34 7 JDocumentRendererHtmlHead->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 6.68 ms Query memory: 0.017 MB Memory before query: 5.309 MB Rows returned: 46Duplicate queries: #5
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 46 100.00 Using index condition Status Duration starting 0.10 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.40 ms preparing 0.02 ms executing 0.01 ms Sending data 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 12 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 11 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 10 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 9 JComponentHelper::getParams() JROOT/plugins/system/cwfacebookjs/cwfacebookjs.php:68 8 plgSystemCwfacebookjs->onAfterRender() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 4 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1074 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49
35 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions1 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT value
FROM jos_powr1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
on c.id = a.catid
LEFT JOIN jos_users AS u
on u.id = a.created_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT *
FROM jos_content1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT element
FROM jos_extensions1 × SELECT uikit_plus
FROM `jos_cwgears`1 × SELECT uikit
FROM `jos_cwgears`1 × SELECT sp.id id_link, sp.id_type id_type, sp.name link_name, sp.link link_url, sp.target target, sa.name type_name, sa.url type_url
FROM `jos_creativesocialwidget_items` sp JOIN `jos_creativesocialwidget_link_types` sa
ON sa.id = sp.id_type1 × SELECT *
FROM `jos_creativesocialwidget_blocks`1 × SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT folder AS type, element AS name, params
FROM jos_extensions1 × SELECT count(*)
FROM `jos_cwgears_schedule1 × SELECT id, rules
FROM `jos_viewlevels1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `jos_session`1 × SELECT count(*)
FROM `jos_cwgears_schedule`1 × SELECT timestamp
FROM jos_zt_visitor_counter1 × SELECT `data`
FROM `jos_session`1 × SELECT *
FROM jos_languages1 × SELECT count(*)
FROM `jos_extensions`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT a.rules
FROM jos_assets AS a
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `jos_content1 × UPDATE jos_content
SET `hits` = (`hits` + 1)1 × CREATE TABLE IF NOT EXISTS `jos_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"4f45fa73320b7eefd73f59ab1c2c531a\"}'1 × INSERT INTO `jos_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`)
VALUES (null, '1656107861', 1 , 1 , '44.201.96.43', 'other'1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
VALUES ('7ovfavifgn6m7qhv0i3897npq5', 0, '1656106961'1 × DELETE
FROM `jos_cwgears`1 × UPDATE `jos_cwgears_schedule`
SET time = '16561069611 × DELETE
FROM `jos_session`