Астана қаласы әкімдігінің №32 «Балдәурен» балабақшасы МҚКК
Біз туралы
- Басты бет
- Біз туралы
Астана қаласы әкімдігінің №32 «Балдәурен» балабақшасы МҚКК, Қазақстан Республикасы
Дизайн және сайтты әзірлеу: Webmarka
Жаңалықтарға жазылу
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1770111443,
"last": 1770111443,
"now": 1770111443
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 19.79 ms / 19.79 ms Memory: 0.047 MB / 0.38 MB Application: afterLoad
Time: 126.87 ms / 146.66 ms Memory: 1.348 MB / 1.73 MB Application: afterInitialise
Time: 14.30 ms / 160.96 ms Memory: 0.100 MB / 1.83 MB Application: Before JAccess::preloadComponents (all components)
Time: 0.74 ms / 161.70 ms Memory: 0.058 MB / 1.89 MB Application: After JAccess::preloadComponents (all components)
Time: 0.05 ms / 161.75 ms Memory: 0.000 MB / 1.88 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)
Time: 0.86 ms / 162.62 ms Memory: 0.007 MB / 1.89 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)
Time: 1.16 ms / 163.77 ms Memory: 0.000 MB / 1.89 MB Application: afterRoute
Time: 15.37 ms / 179.15 ms Memory: 0.270 MB / 2.16 MB Application: beforeRenderComponent com_content
Time: 92.89 ms / 272.04 ms Memory: 0.625 MB / 2.78 MB Application: afterRenderComponent com_content
Time: 12.81 ms / 284.85 ms Memory: 0.058 MB / 2.84 MB Application: afterDispatch
Time: 398.27 ms / 683.11 ms Memory: 0.683 MB / 3.53 MB Application: beforeRenderModule mod_menu (Off Canvas Menu (2))
Time: 1.70 ms / 684.82 ms Memory: 0.010 MB / 3.54 MB Application: afterRenderModule mod_menu (Off Canvas Menu (2))
Time: 0.05 ms / 684.87 ms Memory: 0.000 MB / 3.53 MB Application: beforeRenderModule mod_search (Поиск (2))
Time: 1.84 ms / 686.70 ms Memory: 0.015 MB / 3.55 MB Application: afterRenderModule mod_search (Поиск (2))
Time: 0.09 ms / 686.79 ms Memory: 0.000 MB / 3.55 MB Application: beforeRenderModule mod_acymailing (Жаңалықтарға жазылу)
Time: 10.48 ms / 697.28 ms Memory: 0.315 MB / 3.86 MB Application: afterRenderModule mod_acymailing (Жаңалықтарға жазылу)
Time: 0.12 ms / 697.40 ms Memory: 0.000 MB / 3.84 MB Application: beforeRenderModule mod_menu (Біз туралы)
Time: 4.67 ms / 702.07 ms Memory: 0.031 MB / 3.88 MB Application: afterRenderModule mod_menu (Біз туралы)
Time: 0.07 ms / 702.14 ms Memory: 0.000 MB / 3.87 MB Application: beforeRenderModule mod_custom (Bottom-1 (2))
Time: 1.63 ms / 703.77 ms Memory: 0.006 MB / 3.88 MB Application: afterRenderModule mod_custom (Bottom-1 (2))
Time: 0.08 ms / 703.85 ms Memory: 0.000 MB / 3.88 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs (2))
Time: 2.81 ms / 706.66 ms Memory: 0.010 MB / 3.89 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs (2))
Time: 0.13 ms / 706.79 ms Memory: 0.000 MB / 3.88 MB Application: beforeRenderModule mod_languages (Language Switcher)
Time: 12.93 ms / 719.73 ms Memory: 0.157 MB / 4.04 MB Application: afterRenderModule mod_languages (Language Switcher)
Time: 0.09 ms / 719.82 ms Memory: 0.000 MB / 4.04 MB Application: beforeRenderModule mod_custom (Хидер (копия) (2))
Time: 0.67 ms / 720.49 ms Memory: 0.003 MB / 4.04 MB Application: afterRenderModule mod_custom (Хидер (копия) (2))
Time: 4.24 ms / 724.73 ms Memory: 0.057 MB / 4.10 MB Application: afterRender
Database queries total: 94.91 ms
4.80 MB (5,033,432 Bytes)
39 SQL-запросов зафиксировано 94.91 ms
- Query Time: 0.83 ms Query memory: 0.003 MB Memory before query: 0.652 MB
DELETE
FROM `x0xmp_session`
WHERE `time` < '1770102443'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_session range time time 45 NULL 1 100.00 Using where Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms init for update 0.01 ms init 0.07 ms Deleting from main table 0.01 ms init 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms init for update 0.11 ms Updating 0.06 ms End of update loop 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:818 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:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 0.87 ms After last query: 1.81 ms Query memory: 0.019 MB Memory before query: 0.667 MB Rows returned: 0
SELECT `session_id`
FROM `x0xmp_session`
WHERE `session_id` = '68c12abfa076bd91c613823ebe631de0'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_session const PRIMARY PRIMARY 575 const 1 100.00 Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.04 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.00 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:827 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:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 31.56 ms After last query: 0.17 ms Query memory: 0.003 MB Memory before query: 0.672 MB
INSERT INTO `x0xmp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('68c12abfa076bd91c613823ebe631de0', 1, '1770111443', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `x0xmp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('68c12abfa076bd91c613823ebe631de0', 1, '1770111443', 0, '', 0)Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.04 ms Update 0.16 ms Waiting for query cache lock 0.01 ms Update 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 30.70 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:216 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:827 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:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Query Time: 1.76 ms After last query: 2.71 ms Query memory: 0.024 MB Memory before query: 0.693 MB Rows returned: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x0xmp_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_extensions ref extension extension 62 const 43 100.00 Using index condition Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.10 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.05 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.14 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.56 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:452 8 JComponentHelper::{closure}() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:460 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:111 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:593 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 3.09 ms Query memory: 0.021 MB Memory before query: 0.722 MB Rows returned: 0
SELECT b.id
FROM x0xmp_usergroups AS a
LEFT JOIN x0xmp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13id 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.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms Sending cached result to clien 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:978 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:1047 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:293 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 0.727 MB Rows returned: 5
SELECT id, rules
FROM `x0xmp_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms Sending cached result to clien 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1486 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:1064 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:293 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.42 ms After last query: 0.27 ms Query memory: 0.030 MB Memory before query: 0.754 MB Rows returned: 98
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM x0xmp_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 255 49.02 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.09 ms Optimizing 0.07 ms Statistics 0.14 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.22 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:311 8 JPluginHelper::{closure}() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/plugin/helper.php:316 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 35.93 ms Query memory: 0.021 MB Memory before query: 1.261 MB Rows returned: 2
SELECT *
FROM x0xmp_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 Using where; Using filesort Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms Sending cached result to clien 0.04 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:148 8 JLanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:98 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:682 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.13 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 1.271 MB Rows returned: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `x0xmp_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_extensions ref extension extension 62 const 6 100.00 Using index condition; Using where Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.07 ms Optimizing 0.07 ms Statistics 0.15 ms Preparing 0.08 ms Executing 0.01 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.06 ms Waiting for query cache lock 0.00 ms Updating status 0.00 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:207 8 JLanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:109 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:682 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.22 ms After last query: 13.07 ms Query memory: 0.023 MB Memory before query: 1.338 MB Rows returned: 1
SELECT COUNT(`extension_id`)
FROM `x0xmp_extensions`
WHERE `element` = 'com_advancedmodules'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where; Using index Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.19 ms Preparing 0.11 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/libraries/cms/component/helper.php:95 14 JComponentHelper::isInstalled() JROOT/libraries/regularlabs/src/Parameters.php:136 13 RegularLabs\Library\Parameters->getComponentParams() JROOT/plugins/system/advancedmodules/src/Params.php:29 12 RegularLabs\Plugin\System\AdvancedModules\Params::get() JROOT/plugins/system/advancedmodules/src/Helper.php:22 11 RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterInitialise() Same as call in the line below. 10 call_user_func_array() JROOT/plugins/system/advancedmodules/src/Plugin.php:97 9 RegularLabs\Plugin\System\AdvancedModules\Plugin->run() JROOT/plugins/system/advancedmodules/advancedmodules.php:59 8 PlgSystemAdvancedModules->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 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:683 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.82 ms After last query: 4.14 ms Query memory: 0.140 MB Memory before query: 1.380 MB Rows returned: 61
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 x0xmp_menu AS m
LEFT JOIN x0xmp_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 ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 116 61.21 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 baldauren32_db.m.component_id 1 100.00 Using where Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.18 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.05 ms table lock 0.02 ms Waiting for query cache lock 0.04 ms init 0.09 ms Optimizing 0.07 ms Statistics 0.16 ms Preparing 0.07 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.52 ms Waiting for query cache lock 0.01 ms Creating sort index 0.19 ms Waiting for query cache lock 0.01 ms Creating sort index 0.18 ms Waiting for query cache lock 0.01 ms Creating sort index 0.17 ms Waiting for query cache lock 0.01 ms Creating sort index 0.16 ms Waiting for query cache lock 0.01 ms Creating sort index 0.20 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.05 ms Reset for next command 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 21 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:88 20 JMenuSite->{closure}() JROOT/libraries/joomla/cache/controller/callback.php:169 19 JCacheControllerCallback->get() JROOT/libraries/cms/menu/site.php:96 18 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 17 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 16 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:129 15 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:443 14 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 13 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:59 12 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:198 11 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:548 10 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:402 9 JApplicationSite::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 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:683 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 19.53 ms Query memory: 0.028 MB Memory before query: 1.831 MB Rows returned: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `x0xmp_assets`
WHERE `name` IN ('com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_authorlist','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_unitegallery','com_uniterevolution2','com_users','com_wrapper') OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_assets index_merge idx_asset_name,idx_parent_id idx_asset_name,idx_parent_id 152,4 NULL 43 100.00 Using sort_union(idx_asset_name,idx_parent_id); Using where Status Duration Starting 0.05 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms Sending cached result to clien 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:427 17 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:211 16 JAccess::preload() JROOT/libraries/joomla/access/access.php:529 15 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 14 JAccess::check() JROOT/libraries/joomla/user/user.php:393 13 JUser->authorise() JROOT/plugins/system/advancedmodules/src/Document.php:28 12 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/src/Helper.php:32 11 RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute() Same as call in the line below. 10 call_user_func_array() JROOT/plugins/system/advancedmodules/src/Plugin.php:97 9 RegularLabs\Plugin\System\AdvancedModules\Plugin->run() JROOT/plugins/system/advancedmodules/advancedmodules.php:64 8 PlgSystemAdvancedModules->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 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:1151 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:795 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.24 ms After last query: 2.61 ms Query memory: 0.022 MB Memory before query: 1.907 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x0xmp_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using index condition Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.19 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.02 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 13 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 12 JLibraryHelper::{closure}() JROOT/libraries/joomla/cache/controller/callback.php:169 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:174 10 JLibraryHelper::loadLibrary() JROOT/libraries/cms/library/helper.php:42 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:89 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:270 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:760 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 5.41 ms After last query: 0.34 ms Query memory: 0.005 MB Memory before query: 1.897 MB
UPDATE `x0xmp_extensions`
SET `params` = '{\"mediaversion\":\"b25932b7a3de7a8aba89fcb284c85d14\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_extensions range element_clientid,element_folder_clientid,extension extension 364 NULL 1 100.00 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms checking permissions 0.01 ms After opening tables 0.00 ms init for update 0.01 ms init 0.02 ms Updating main table 0.01 ms init 0.01 ms System lock 0.01 ms table lock 0.00 ms init 0.00 ms init for update 0.09 ms Updating 0.11 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.07 ms End of update loop 0.00 ms Query end 0.00 ms Commit 4.56 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:116 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:321 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:280 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:760 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.56 ms After last query: 2.45 ms Query memory: 0.050 MB Memory before query: 2.001 MB Rows returned: 6
SELECT id, home, template, s.params
FROM x0xmp_template_styles as s
LEFT JOIN x0xmp_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 e ref element_clientid,element_folder_clientid,extension extension 62 const 5 100.00 Using index condition; Using where 1 SIMPLE s ref idx_template idx_template 152 baldauren32_db.e.element 1 100.00 Using index condition; Using where Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.15 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.04 ms init 0.09 ms Optimizing 0.12 ms Statistics 0.21 ms Preparing 0.10 ms Executing 0.01 ms Sending data 0.24 ms Waiting for query cache lock 0.01 ms Sending data 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.00 ms Waiting for query cache lock 0.00 ms Updating status 0.03 ms Waiting for query cache lock 0.00 ms Updating status 0.00 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:485 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.91 ms After last query: 17.66 ms Query memory: 0.051 MB Memory before query: 2.254 MB Rows returned: 21
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=108
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.05 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.37 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.24 ms Optimizing 0.12 ms Statistics 0.40 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.09 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.90 ms Waiting for query cache lock 0.01 ms Creating sort index 0.17 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.01 ms Waiting for query cache lock 0.00 ms Updating status 0.02 ms Waiting for query cache lock 0.00 ms Updating status 0.00 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 14 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 13 JCategories->get() JROOT/components/com_content/models/categories.php:115 12 ContentModelCategories->getItems() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/libraries/legacy/view/categories.php:55 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.38 ms After last query: 30.97 ms Query memory: 0.030 MB Memory before query: 2.478 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=133
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.36 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms Waiting for query cache lock 0.05 ms init 0.24 ms Optimizing 0.12 ms Statistics 0.36 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.40 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.36 ms After last query: 0.65 ms Query memory: 0.030 MB Memory before query: 2.506 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=109
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.24 ms Optimizing 0.12 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.08 ms Creating sort index 0.42 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.25 ms After last query: 0.49 ms Query memory: 0.030 MB Memory before query: 2.527 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=110
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.33 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.27 ms Optimizing 0.12 ms Statistics 0.34 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.42 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.37 ms After last query: 0.50 ms Query memory: 0.031 MB Memory before query: 2.545 MB Rows returned: 6
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=111
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.34 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.23 ms Optimizing 0.15 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.47 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.31 ms After last query: 1.99 ms Query memory: 0.030 MB Memory before query: 2.582 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=117
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.23 ms Optimizing 0.11 ms Statistics 0.34 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.43 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.32 ms After last query: 0.53 ms Query memory: 0.030 MB Memory before query: 2.602 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=115
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.27 ms Optimizing 0.12 ms Statistics 0.34 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.41 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.32 ms After last query: 0.59 ms Query memory: 0.030 MB Memory before query: 2.621 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=116
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.34 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.27 ms Optimizing 0.12 ms Statistics 0.34 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.40 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.35 ms After last query: 0.58 ms Query memory: 0.030 MB Memory before query: 2.639 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=131
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.23 ms Optimizing 0.14 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.44 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.03 ms Reset for next command 0.02 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.33 ms After last query: 0.62 ms Query memory: 0.030 MB Memory before query: 2.660 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=118
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.34 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.23 ms Optimizing 0.15 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.42 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.39 ms After last query: 0.62 ms Query memory: 0.030 MB Memory before query: 2.680 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=121
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.34 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.23 ms Optimizing 0.11 ms Statistics 0.39 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.47 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.05 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.33 ms After last query: 0.69 ms Query memory: 0.030 MB Memory before query: 2.701 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=123
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.23 ms Optimizing 0.15 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.41 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.04 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.68 ms Query memory: 0.030 MB Memory before query: 2.720 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=127
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms Sending cached result to clien 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.39 ms After last query: 0.59 ms Query memory: 0.030 MB Memory before query: 2.740 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=129
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.24 ms Optimizing 0.16 ms Statistics 0.35 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.47 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.01 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.02 ms Reset for next command 0.02 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.38 ms After last query: 0.76 ms Query memory: 0.030 MB Memory before query: 2.762 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=135
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.05 ms init 0.28 ms Optimizing 0.12 ms Statistics 0.35 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.47 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Waiting for query cache lock 0.01 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.01 ms Storing result in query cache 0.04 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 2.17 ms After last query: 0.74 ms Query memory: 0.030 MB Memory before query: 2.783 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=140
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.03 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.35 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.09 ms init 0.24 ms Optimizing 0.12 ms Statistics 0.35 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.32 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.01 ms Waiting for query cache lock 0.00 ms Updating status 0.05 ms Waiting for query cache lock 0.01 ms Updating status 0.00 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.28 ms After last query: 0.64 ms Query memory: 0.030 MB Memory before query: 2.802 MB Rows returned: 3
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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=152
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.02 ms Waiting for query cache lock 0.00 ms starting 0.00 ms Checking query cache for query 0.20 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.13 ms Optimizing 0.06 ms Statistics 0.20 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.21 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.01 ms Waiting for query cache lock 0.00 ms Updating status 0.68 ms Waiting for query cache lock 0.01 ms Updating status 0.00 ms Storing result in query cache 0.01 ms Reset for next command 0.01 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 26 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 25 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 24 JCategories->get() JROOT/components/com_content/router.php:70 23 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 22 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 21 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 20 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 19 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 18 JRouter->build() JROOT/libraries/cms/router/site.php:149 17 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 16 JRoute::_() JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php:41 15 include JROOT/templates/shaper_kidzy/html/com_content/categories/default_items.php JROOT/libraries/legacy/view/legacy.php:694 14 JViewLegacy->loadTemplate() JROOT/templates/shaper_kidzy/html/com_content/categories/default.php:22 13 include JROOT/templates/shaper_kidzy/html/com_content/categories/default.php JROOT/libraries/legacy/view/legacy.php:694 12 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 11 JViewLegacy->display() JROOT/libraries/legacy/view/categories.php:96 10 JViewCategories->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.15 ms After last query: 0.89 ms Query memory: 0.022 MB Memory before query: 2.791 MB Rows returned: 3
SELECT language,id
FROM `x0xmp_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_menu ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 116 62.07 Using where Status Duration Starting 0.01 ms Waiting for query cache lock 0.00 ms starting 0.00 ms Checking query cache for query 0.01 ms checking privileges on cached 0.00 ms checking permissions 0.01 ms Sending cached result to clien 0.01 ms Updating status 0.00 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/multilang.php:106 8 JLanguageMultilang::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:709 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 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/site.php:196 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 0.78 ms Query memory: 0.021 MB Memory before query: 2.804 MB Rows returned: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `x0xmp_menu` AS `c`
INNER JOIN `x0xmp_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `x0xmp_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `x0xmp_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 649id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 1 SIMPLE a2 ref idx_key idx_key 96 const 2 100.00 Using index 1 SIMPLE c2 eq_ref PRIMARY PRIMARY 4 baldauren32_db.a2.id 1 100.00 Status Duration Starting 0.02 ms Waiting for query cache lock 0.00 ms starting 0.00 ms Checking query cache for query 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.02 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.16 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Waiting for query cache lock 0.00 ms Updating status 0.02 ms Waiting for query cache lock 0.00 ms Updating status 0.00 ms Storing result in query cache 0.04 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/associations.php:101 9 JLanguageAssociations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:314 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:726 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 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/site.php:196 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.86 ms After last query: 2.37 ms Query memory: 0.022 MB Memory before query: 2.812 MB Rows returned: 2
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `x0xmp_categories` AS `c`
INNER JOIN `x0xmp_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_categories.item'
INNER JOIN `x0xmp_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `x0xmp_categories` AS `c2`
ON a2.id = c2.`id`
AND c2.extension = 'com_content'
WHERE c.id = 108
AND c.extension = 'com_content'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 1 SIMPLE a2 ref idx_key idx_key 96 const 2 100.00 Using index 1 SIMPLE c2 eq_ref PRIMARY,cat_idx PRIMARY 4 baldauren32_db.a2.id 1 61.62 Using where Status Duration Starting 0.02 ms Waiting for query cache lock 0.00 ms starting 0.00 ms Checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.21 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.00 ms Waiting for query cache lock 0.00 ms Updating status 0.62 ms Waiting for query cache lock 0.01 ms Updating status 0.00 ms Storing result in query cache 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/language/associations.php:101 11 JLanguageAssociations::getAssociations() JROOT/administrator/components/com_categories/helpers/categories.php:113 10 CategoriesHelper::getAssociations() JROOT/administrator/components/com_categories/helpers/association.php:43 9 CategoryHelperAssociation::getCategoryAssociations() JROOT/components/com_content/helpers/association.php:58 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:741 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 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/site.php:196 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.30 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 2.826 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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) 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)
AND c.published = 1
AND s.id=79
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 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 99 59.60 Using where; Using filesort Status Duration Starting 0.01 ms Waiting for query cache lock 0.00 ms starting 0.00 ms Checking query cache for query 0.20 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.03 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.18 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.20 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.00 ms Waiting for query cache lock 0.00 ms Updating status 0.03 ms Waiting for query cache lock 0.00 ms Updating status 0.02 ms Storing result in query cache 0.03 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 17 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 16 JCategories->get() JROOT/components/com_content/router.php:70 15 ContentRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:117 14 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 13 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 12 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 11 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 10 JRouter->build() JROOT/libraries/cms/router/site.php:149 9 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 8 JRoute::_() JROOT/plugins/system/languagefilter/languagefilter.php:768 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 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/site.php:196 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 1.40 ms After last query: 67.07 ms Query memory: 0.060 MB Memory before query: 3.224 MB Rows returned: 17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM x0xmp_modules AS m
LEFT JOIN x0xmp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN x0xmp_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1)
AND m.client_id = 0
AND m.language IN ('kz-KZ','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 57 39.61 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 baldauren32_db.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE am eq_ref PRIMARY PRIMARY 4 baldauren32_db.m.id 1 100.00 Using where Status Duration Starting 0.02 ms Waiting for query cache lock 0.00 ms starting 0.00 ms Checking query cache for query 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms Waiting for query cache lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.40 ms Waiting for query cache lock 0.01 ms Creating sort index 0.26 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.00 ms Waiting for query cache lock 0.00 ms Updating status 0.02 ms Waiting for query cache lock 0.00 ms Updating status 0.00 ms Storing result in query cache 0.00 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406 17 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123 16 PlgSystemAdvancedModuleHelper->onPrepareModuleList() JROOT/libraries/joomla/event/dispatcher.php:165 15 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 14 JApplicationBase->triggerEvent() JROOT/libraries/cms/module/helper.php:355 13 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 12 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:576 11 JDocumentHtml->countModules() JROOT/plugins/system/helix3/core/helix3.php:512 10 Helix3::countModules() JROOT/plugins/system/helix3/core/helix3.php:459 9 Helix3::rowColumns() JROOT/plugins/system/helix3/core/helix3.php:268 8 Helix3::generatelayout() JROOT/templates/shaper_kidzy/index.php:184 7 require JROOT/templates/shaper_kidzy/index.php JROOT/libraries/joomla/document/html.php:653 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:715 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:530 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1098 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 341.53 ms Query memory: 0.029 MB Memory before query: 3.591 MB Rows returned: 87
SELECT *
FROM x0xmp_acymailing_configid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_acymailing_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 87 100.00 Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms Sending cached result to clien 0.04 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:474 15 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:815 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1112 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 6.49 ms Query memory: 0.023 MB Memory before query: 3.868 MB Rows returned: 1
SELECT *
FROM x0xmp_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE x0xmp_acymailing_list ref typeorderingindex,typeuseridindex typeorderingindex 1 const 1 100.00 Using index condition; Using where Status Duration Starting 0.04 ms Waiting for query cache lock 0.01 ms starting 0.01 ms Checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms Sending cached result to clien 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:474 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/list.php:30 11 listClass->getLists() JROOT/modules/mod_acymailing/mod_acymailing.php:148 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1112 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49
21 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
18 × 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 x0xmp_categories as c
LEFT JOIN x0xmp_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('kz-KZ','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `x0xmp_extensions`1 × SELECT `session_id`
FROM `x0xmp_session`1 × SELECT *
FROM x0xmp_acymailing_confi1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM x0xmp_modules AS m
LEFT JOIN x0xmp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN x0xmp_advancedmodules as am
ON am.moduleid = m.id1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `x0xmp_categories` AS `c`
INNER JOIN `x0xmp_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_categories.item'
INNER JOIN `x0xmp_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `x0xmp_categories` AS `c2`
ON a2.id = c2.`id`
AND c2.extension = 'com_content'1 × SELECT `c2`.`language`,`c2`.`id`
FROM `x0xmp_menu` AS `c`
INNER JOIN `x0xmp_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `x0xmp_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `x0xmp_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT language,id
FROM `x0xmp_menu`1 × SELECT id, home, template, s.params
FROM x0xmp_template_styles as s
LEFT JOIN x0xmp_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `x0xmp_assets`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 x0xmp_menu AS m
LEFT JOIN x0xmp_extensions AS e
ON m.component_id = e.extension_id1 × SELECT COUNT(`extension_id`)
FROM `x0xmp_extensions`1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `x0xmp_extensions`1 × SELECT *
FROM x0xmp_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM x0xmp_extensions1 × SELECT id, rules
FROM `x0xmp_viewlevels1 × SELECT b.id
FROM x0xmp_usergroups AS a
LEFT JOIN x0xmp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM x0xmp_acymailing_list
Прочие SQL-запросы:
1 × DELETE
FROM `x0xmp_session`1 × INSERT INTO `x0xmp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('68c12abfa076bd91c613823ebe631de0', 1, '1770111443', 0, '', 01 × UPDATE `x0xmp_extensions`
SET `params` = '{\"mediaversion\":\"b25932b7a3de7a8aba89fcb284c85d14\"}'