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": 1653402633,
"last": 1653402633,
"now": 1653402633
}
},
"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: 4.23 ms / 4.23 ms Memory: 0.172 MB / 0.40 MB Application: afterLoad
Time: 196.64 ms / 200.87 ms Memory: 1.637 MB / 2.03 MB Application: afterInitialise
Time: 12.47 ms / 213.34 ms Memory: 1.128 MB / 3.16 MB Application: afterRoute
Time: 2.82 ms / 216.16 ms Memory: 0.075 MB / 3.24 MB Application: beforeRenderComponent com_content
Time: 26.52 ms / 242.68 ms Memory: 1.138 MB / 4.37 MB Application: afterRenderComponent com_content
Time: 0.91 ms / 243.59 ms Memory: 0.020 MB / 4.39 MB Application: afterDispatch
Time: 3.93 ms / 247.51 ms Memory: 0.133 MB / 4.53 MB Application: beforeRenderModule mod_joombig_video_slider_vertical (Video Album on HomePage)
Time: 2.02 ms / 249.54 ms Memory: 0.057 MB / 4.58 MB Application: afterRenderModule mod_joombig_video_slider_vertical (Video Album on HomePage)
Time: 0.09 ms / 249.62 ms Memory: 0.000 MB / 4.55 MB Application: beforeRenderModule mod_jbmenu (FooterMenu)
Time: 4.05 ms / 253.68 ms Memory: 0.050 MB / 4.60 MB Application: afterRenderModule mod_jbmenu (FooterMenu)
Time: 0.14 ms / 253.82 ms Memory: 0.000 MB / 4.60 MB Application: beforeRenderModule mod_fblikebox (Facebook Like Box - Live)
Time: 0.73 ms / 254.55 ms Memory: 0.039 MB / 4.64 MB Application: afterRenderModule mod_fblikebox (Facebook Like Box - Live)
Time: 0.07 ms / 254.62 ms Memory: 0.000 MB / 4.63 MB Application: beforeRenderModule mod_custom (Translation)
Time: 0.51 ms / 255.13 ms Memory: 0.009 MB / 4.64 MB Application: afterRenderModule mod_custom (Translation)
Time: 0.17 ms / 255.30 ms Memory: 0.000 MB / 4.64 MB Application: beforeRenderModule mod_custom (Welcome to School Custom P8 HomePage)
Time: 0.28 ms / 255.58 ms Memory: 0.007 MB / 4.65 MB Application: afterRenderModule mod_custom (Welcome to School Custom P8 HomePage)
Time: 0.07 ms / 255.65 ms Memory: 0.000 MB / 4.64 MB Application: beforeRenderModule mod_ext_vk_community (EXT Vk Community)
Time: 0.56 ms / 256.21 ms Memory: 0.014 MB / 4.66 MB Application: afterRenderModule mod_ext_vk_community (EXT Vk Community)
Time: 0.16 ms / 256.38 ms Memory: 0.003 MB / 4.66 MB Application: beforeRenderModule mod_ariimageslider (New HomePage Banner Slide Image)
Time: 4.40 ms / 260.78 ms Memory: 0.194 MB / 4.85 MB Application: afterRenderModule mod_ariimageslider (New HomePage Banner Slide Image)
Time: 0.15 ms / 260.93 ms Memory: 0.000 MB / 4.81 MB Application: beforeRenderModule mod_jbmenu (JB DropDown Menu)
Time: 19.95 ms / 280.87 ms Memory: 0.215 MB / 5.02 MB Application: afterRenderModule mod_jbmenu (JB DropDown Menu)
Time: 0.09 ms / 280.96 ms Memory: 0.000 MB / 5.02 MB Application: beforeRenderModule mod_languages (عربي)
Time: 2.05 ms / 283.01 ms Memory: 0.041 MB / 5.06 MB Application: afterRenderModule mod_languages (عربي)
Time: 0.11 ms / 283.12 ms Memory: 0.000 MB / 5.05 MB Application: beforeRenderModule mod_creativesocialwidget (Creative Social Widget)
Time: 1.74 ms / 284.86 ms Memory: 0.067 MB / 5.12 MB Application: afterRenderModule mod_creativesocialwidget (Creative Social Widget)
Time: 0.09 ms / 284.95 ms Memory: 0.000 MB / 5.10 MB Application: beforeRenderModule mod_search (Search main page)
Time: 1.35 ms / 286.29 ms Memory: 0.028 MB / 5.13 MB Application: afterRenderModule mod_search (Search main page)
Time: 8.12 ms / 294.41 ms Memory: 0.113 MB / 5.24 MB Application: afterRender
Database queries total: 188.43 ms
5.83 MB (6,109,696 Bytes)
35 Queries Logged 188.43 ms
- Query Time: 1.24 ms Query memory: 0.017 MB Memory before query: 0.870 MB Rows returned: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '59uab0n9oqbh9lb4drf060v2g5'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.36 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.38 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: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.74 ms After last query: 1.24 ms Query memory: 0.008 MB Memory before query: 0.932 MB
DELETE
FROM `jos_session`
WHERE `time` < '1653401733'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.09 ms Opening tables 0.01 ms init 0.01 ms System lock 0.07 ms updating 0.35 ms end 0.01 ms query end 0.03 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.38 ms After last query: 0.16 ms Query memory: 0.010 MB Memory before query: 0.944 MB Rows returned: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '59uab0n9oqbh9lb4drf060v2g5'
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.14 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.05 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.31 ms After last query: 0.17 ms Query memory: 0.009 MB Memory before query: 0.957 MB
INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
VALUES ('59uab0n9oqbh9lb4drf060v2g5', 0, '1653402633')EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('59uab0n9oqbh9lb4drf060v2g5', 0, '1653402633')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.08 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/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.69 ms After last query: 1.38 ms Query memory: 0.012 MB Memory before query: 1.035 MB Rows returned: 46Duplicate queries: #35
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.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 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 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.47 ms After last query: 0.91 ms Query memory: 0.013 MB Memory before query: 1.106 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.09 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.14 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.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.35 ms After last query: 0.24 ms Query memory: 0.011 MB Memory before query: 1.125 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.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 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.86 ms After last query: 0.22 ms Query memory: 0.009 MB Memory before query: 1.145 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.13 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.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.07 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: 0.35 ms After last query: 8.71 ms Query memory: 0.013 MB Memory before query: 1.750 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.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms executing 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.11 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.48 ms After last query: 0.14 ms Query memory: 0.013 MB Memory before query: 1.765 MB Rows returned: 1
SELECT count(*)
FROM `jos_cwgears_schedule`
WHERE time + '3600'<'1653402633'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.08 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.02 ms preparing 0.04 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.09 ms freeing items 0.06 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: 163.32 ms After last query: 0.89 ms Query memory: 0.014 MB Memory before query: 1.814 MB Rows returned: 0
SELECT timestamp
FROM jos_zt_visitor_counter
WHERE ipaddress = '3.239.129.91'
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 2276100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.01 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.11 ms executing 0.01 ms Sending data 162.76 ms end 0.03 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 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.54 ms After last query: 0.37 ms Query memory: 0.014 MB Memory before query: 1.830 MB
INSERT INTO `jos_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`)
VALUES (null, '1653403533', 1 , 1 , '3.239.129.91', 'other')EXPLAIN not possible on query: INSERT INTO `jos_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) VALUES (null, '1653403533', 1 , 1 , '3.239.129.91', 'other')Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.26 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: 1.89 ms After last query: 3.10 ms Query memory: 0.020 MB Memory before query: 2.087 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.25 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.20 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.11 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.07 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.63 ms After last query: 6.65 ms Query memory: 0.022 MB Memory before query: 3.048 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.10 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.22 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.06 ms cleaning up 0.01 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.46 ms After last query: 0.82 ms Query memory: 0.018 MB Memory before query: 3.070 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"5bc1a53113d8da53950221ee4a02767d\"}'
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.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.06 ms updating 0.15 ms end 0.01 ms query end 0.03 ms closing tables 0.01 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.34 ms After last query: 0.67 ms Query memory: 0.014 MB Memory before query: 3.148 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.01 ms init 0.02 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.05 ms cleaning up 0.16 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: 0.63 ms After last query: 0.85 ms Query memory: 0.009 MB Memory before query: 3.197 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 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.31 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/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.46 ms After last query: 0.58 ms Query memory: 0.008 MB Memory before query: 3.221 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.12 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.06 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.04 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.33 ms After last query: 2.45 ms Query memory: 0.019 MB Memory before query: 3.370 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.08 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.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 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.26 ms After last query: 0.52 ms Query memory: 0.020 MB Memory before query: 3.399 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.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.29 ms preparing 0.03 ms Creating tmp table 0.93 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.29 ms Creating sort index 0.17 ms end 0.01 ms removing tmp table 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 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: 1.35 ms After last query: 0.58 ms Query memory: 0.020 MB Memory before query: 3.449 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.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 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 0.10 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.12 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.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.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.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.07 ms closing tables 0.01 ms freeing items 0.06 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/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.36 ms After last query: 1.82 ms Query memory: 0.015 MB Memory before query: 3.587 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.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 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.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.34 ms After last query: 0.25 ms Query memory: 0.014 MB Memory before query: 3.602 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.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.06 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 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: 1.33 ms After last query: 0.97 ms Query memory: 0.018 MB Memory before query: 3.668 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-05-24 14:30:33')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-24 14:30:33')
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.23 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 0.12 ms init 0.11 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.02 ms statistics 0.26 ms preparing 0.02 ms executing 0.08 ms Sending data 0.03 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.02 ms removing tmp table 0.01 ms Creating sort index 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.03 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: 1.91 ms After last query: 1.51 ms Query memory: 0.019 MB Memory before query: 3.778 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.18 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.02 ms statistics 0.16 ms preparing 0.04 ms Creating tmp table 0.10 ms Sorting result 0.01 ms executing 0.04 ms Sending data 0.04 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.16 ms removing tmp table 0.03 ms Creating sort index 0.30 ms Creating sort index 0.07 ms end 0.04 ms removing tmp table 0.14 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.08 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: 0.57 ms After last query: 1.63 ms Query memory: 0.016 MB Memory before query: 3.844 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.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 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.06 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: 0.84 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 3.875 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.11 ms checking permissions 0.01 ms Opening tables 0.61 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.28 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 3.897 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.06 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.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 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: 1.75 ms After last query: 8.74 ms Query memory: 0.016 MB Memory before query: 4.433 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-05-24 14:30:33')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-24 14:30:33')
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.18 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 1.04 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.66 ms After last query: 35.79 ms Query memory: 0.018 MB Memory before query: 5.049 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.11 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.25 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.09 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: 0.36 ms After last query: 1.10 ms Query memory: 0.015 MB Memory before query: 5.073 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.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.03 ms preparing 0.01 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.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/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: 0.62 ms After last query: 0.17 ms Query memory: 0.015 MB Memory before query: 5.105 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.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.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.23 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: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.35 ms After last query: 1.97 ms Query memory: 0.019 MB Memory before query: 5.127 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.07 ms checking permissions 0.09 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 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 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.23 ms After last query: 0.14 ms Query memory: 0.019 MB Memory before query: 5.147 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.06 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.01 ms executing 0.01 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 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: 0.76 ms After last query: 1.51 ms Query memory: 0.017 MB Memory before query: 5.249 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.13 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.08 ms preparing 0.01 ms executing 0.01 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.11 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: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
33 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 × 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 × SHOW FULL COLUMNS
FROM `jos_content1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"5bc1a53113d8da53950221ee4a02767d\"}'1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
VALUES ('59uab0n9oqbh9lb4drf060v2g5', 0, '1653402633'1 × INSERT INTO `jos_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`)
VALUES (null, '1653403533', 1 , 1 , '3.239.129.91', 'other'1 × DELETE
FROM `jos_session`