№39 «Хиуаз» балабақшасында қараша айының 18.11-20.11.2019 күндері арасында балабақша барлық топтары есеп беру бақылау оқу қызметін өткізді.
Есеп беру, оқу қызметі
Joomla! Debug консолі
{
"__default": {
"session": {
"counter": 3,
"timer": {
"start": 1764996574,
"last": 1764996575,
"now": 1764996575
}
},
"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
},
"plg_system_languagefilter": {
"language": "kk-KZ"
}
}
}
Уақыт
Жад
Уақыт: 20.06 ms / 20.06 ms Жад: 0.401 MB / 0.75 MB Application: afterLoad
Уақыт: 58.13 ms / 78.18 ms Жад: 0.998 MB / 1.75 MB Application: afterInitialise
Уақыт: 12.96 ms / 91.14 ms Жад: 0.175 MB / 1.92 MB Application: afterRoute
Уақыт: 5.02 ms / 96.16 ms Жад: 0.055 MB / 1.98 MB Application: beforeRenderComponent com_content
Уақыт: 5.51 ms / 101.67 ms Жад: 0.128 MB / 2.10 MB Application: Before Access::preloadComponents (all components)
Уақыт: 1.18 ms / 102.86 ms Жад: 0.053 MB / 2.16 MB Application: After Access::preloadComponents (all components)
Уақыт: 0.04 ms / 102.90 ms Жад: 0.000 MB / 2.15 MB Application: Before Access::preloadPermissions (com_content)
Уақыт: 0.86 ms / 103.75 ms Жад: 0.060 MB / 2.21 MB Application: After Access::preloadPermissions (com_content)
Уақыт: 0.02 ms / 103.77 ms Жад: 0.000 MB / 2.21 MB Application: Before Access::getAssetRules (id:98 name:com_content.article.15)
Уақыт: 0.72 ms / 104.50 ms Жад: 0.008 MB / 2.22 MB Application: After Access::getAssetRules (id:98 name:com_content.article.15)
Уақыт: 63.86 ms / 168.35 ms Жад: 0.236 MB / 2.46 MB Application: afterRenderComponent com_content
Уақыт: 4.02 ms / 172.38 ms Жад: 0.095 MB / 2.55 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Уақыт: 0.03 ms / 172.41 ms Жад: 0.002 MB / 2.55 MB Application: After Access::getAssetRules (id:8 name:com_content)
Уақыт: 7.95 ms / 180.36 ms Жад: 0.014 MB / 2.57 MB Application: afterDispatch
Уақыт: 8.31 ms / 188.66 ms Жад: 0.051 MB / 2.62 MB Application: beforeRenderModule mod_custom (Footer adress kaz)
Уақыт: 2.87 ms / 191.53 ms Жад: 0.015 MB / 2.63 MB Application: afterRenderModule mod_custom (Footer adress kaz)
Уақыт: 0.10 ms / 191.63 ms Жад: 0.000 MB / 2.63 MB Application: beforeRenderModule mod_custom (Banners kaz)
Уақыт: 1.51 ms / 193.14 ms Жад: 0.004 MB / 2.64 MB Application: afterRenderModule mod_custom (Banners kaz)
Уақыт: 0.09 ms / 193.23 ms Жад: 0.000 MB / 2.63 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Уақыт: 3.71 ms / 196.93 ms Жад: 0.011 MB / 2.65 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Уақыт: 0.10 ms / 197.04 ms Жад: 0.000 MB / 2.64 MB Application: beforeRenderModule mod_menu (Main menu kk-KZ)
Уақыт: 17.71 ms / 214.74 ms Жад: 0.089 MB / 2.73 MB Application: afterRenderModule mod_menu (Main menu kk-KZ)
Уақыт: 0.09 ms / 214.83 ms Жад: 0.000 MB / 2.73 MB Application: beforeRenderModule mod_languages (Language Switcher)
Уақыт: 7.17 ms / 222.01 ms Жад: 0.027 MB / 2.75 MB Application: afterRenderModule mod_languages (Language Switcher)
Уақыт: 0.07 ms / 222.08 ms Жад: 0.000 MB / 2.75 MB Application: beforeRenderModule mod_custom (Adress top kaz)
Уақыт: 0.91 ms / 222.99 ms Жад: 0.003 MB / 2.75 MB Application: afterRenderModule mod_custom (Adress top kaz)
Уақыт: 0.06 ms / 223.05 ms Жад: 0.000 MB / 2.75 MB Application: beforeRenderModule mod_custom (Логотип каз)
Уақыт: 0.89 ms / 223.95 ms Жад: 0.003 MB / 2.76 MB Application: afterRenderModule mod_custom (Логотип каз)
Уақыт: 2.42 ms / 226.36 ms Жад: 0.052 MB / 2.81 MB Application: afterRender
Дерекқор сұраулары барлығы: 24.24 ms
3.19 MB (3 342 456 Байттар)
25 сұраулар тіркелген 24.24 ms
- Сұрау уақыты: 0.95 ms Сұрау жады: 0.023 MB Сұрау алдындағы жады: 1.032 MB Жолдар қайтарылды: 1
SELECT `data`
FROM `v275d_session`
WHERE `session_id` = X'3736623661396533383264306631653630656230383965666564613237626231'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.14 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.07 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 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.06 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Төмендегі жолда қоңырау шалу сияқты. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Сұрау уақыты: 1.44 ms Соңғы сұраудан кейін: 5.68 ms Сұрау жады: 0.024 MB Сұрау алдындағы жады: 1.077 MB Жолдар қайтарылды: 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `v275d_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_extensions ref extension extension 82 const 36 Using index condition; Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.07 ms Optimizing 0.07 ms Statistics 0.17 ms Preparing 0.08 ms Executing 0.01 ms Sending data 0.47 ms End of update loop 0.02 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Төмендегі жолда қоңырау шалу сияқты. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.54 ms Соңғы сұраудан кейін: 2.47 ms Сұрау жады: 0.021 MB Сұрау алдындағы жады: 1.103 MB Жолдар қайтарылды: 5
SELECT id, rules
FROM `v275d_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_viewlevels ALL NULL ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 5 Status Duration Starting 0.05 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 init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 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.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 # Қоңырау шалушы Файл және жол нөмірі 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.66 ms Соңғы сұраудан кейін: 0.09 ms Сұрау жады: 0.021 MB Сұрау алдындағы жады: 1.115 MB Жолдар қайтарылды: 2
SELECT b.id
FROM v275d_usergroups AS a
LEFT JOIN v275d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.07 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 init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.03 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.72 ms Соңғы сұраудан кейін: 0.38 ms Сұрау жады: 0.030 MB Сұрау алдындағы жады: 1.137 MB Жолдар қайтарылды: 85
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM v275d_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_extensions ALL extension ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 208 Using where; Файлдар пайдалану Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.91 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.02 ms Query end 0.09 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Төмендегі жолда қоңырау шалу сияқты. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.73 ms Соңғы сұраудан кейін: 10.28 ms Сұрау жады: 0.021 MB Сұрау алдындағы жады: 1.565 MB Жолдар қайтарылды: 3
SELECT *
FROM v275d_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_languages ALL NULL ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 3 Using where; Файлдар пайдалану Status Duration Starting 0.08 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 0.05 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.13 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.61 ms Соңғы сұраудан кейін: 0.12 ms Сұрау жады: 0.021 MB Сұрау алдындағы жады: 1.574 MB Жолдар қайтарылды: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `v275d_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_extensions ref extension extension 82 const 6 Using index condition; Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.08 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.03 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.32 ms Соңғы сұраудан кейін: 7.66 ms Сұрау жады: 0.054 MB Сұрау алдындағы жады: 1.644 MB Жолдар қайтарылды: 28
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 v275d_menu AS m
LEFT JOIN v275d_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 Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 28 Using index condition; Using where; Файлдар пайдалану 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 edutrade_sad39.kz.m.component_id 1 Using where Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.59 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.03 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.03 ms # Қоңырау шалушы Файл және жол нөмірі 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Төмендегі жолда қоңырау шалу сияқты. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 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/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.31 ms Соңғы сұраудан кейін: 11.76 ms Сұрау жады: 0.024 MB Сұрау алдындағы жады: 1.898 MB Жолдар қайтарылды: 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 `v275d_categories` AS `s`
INNER JOIN `v275d_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('kk-KZ','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_left_right,idx_language cat_idx 203 NULL 3 Using index condition; Using where; Файлдар пайдалану Status Duration Starting 0.24 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 init 0.10 ms Optimizing 0.05 ms Statistics 0.22 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 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.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.03 ms # Қоңырау шалушы Файл және жол нөмірі 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:165 12 ContentRouter->getCategoryId() Төмендегі жолда қоңырау шалу сияқты. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:93 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.55 ms Соңғы сұраудан кейін: 0.48 ms Сұрау жады: 0.022 MB Сұрау алдындағы жады: 1.916 MB Жолдар қайтарылды: 1
SELECT `id`
FROM `v275d_content`
WHERE alias = 'esep-beru-o-u-yzmet'
AND catid = '8'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_content ref idx_catid,idx_alias idx_alias 766 const 1 Using where Status Duration Starting 0.05 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 init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.07 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:225 12 ContentRouter->getArticleId() Төмендегі жолда қоңырау шалу сияқты. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.55 ms Соңғы сұраудан кейін: 0.57 ms Сұрау жады: 0.022 MB Сұрау алдындағы жады: 1.939 MB Жолдар қайтарылды: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `v275d_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 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.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Төмендегі жолда қоңырау шалу сияқты. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.69 ms Соңғы сұраудан кейін: 0.14 ms Сұрау жады: 0.005 MB Сұрау алдындағы жады: 1.930 MB
UPDATE `v275d_extensions`
SET `params` = '{\"mediaversion\":\"52a31651deb9ab0b289df1e8bb2e56f1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN сұрау кезінде мүмкін емес: UPDATE `v275d_extensions` SET `params` = '{\"mediaversion\":\"52a31651deb9ab0b289df1e8bb2e56f1\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init for update 0.09 ms Updating 0.12 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.14 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.76 ms Соңғы сұраудан кейін: 1.77 ms Сұрау жады: 0.019 MB Сұрау алдындағы жады: 1.971 MB Жолдар қайтарылды: 3
SELECT id, home, template, s.params
FROM v275d_template_styles as s
LEFT JOIN v275d_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 Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 edutrade_sad39.kz.s.template,const 1 Using index condition; Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 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.05 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.01 ms Соңғы сұраудан кейін: 6.24 ms Сұрау жады: 0.028 MB Сұрау алдындағы жады: 2.107 MB Жолдар қайтарылды: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `v275d_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','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_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_assets ALL idx_asset_name ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 140 Using where Status Duration Starting 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 init 0.06 ms Optimizing 0.02 ms Statistics 0.16 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.33 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.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 14 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.69 ms Соңғы сұраудан кейін: 0.19 ms Сұрау жады: 0.030 MB Сұрау алдындағы жады: 2.153 MB Жолдар қайтарылды: 64
SELECT `id`,`name`,`rules`,`parent_id`
FROM `v275d_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_assets ALL idx_asset_name,idx_parent_id ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 140 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.23 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 14 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.10 ms Соңғы сұраудан кейін: 0.99 ms Сұрау жады: 0.023 MB Сұрау алдындағы жады: 2.226 MB Жолдар қайтарылды: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM v275d_content AS a
INNER JOIN v275d_categories AS c
on c.id = a.catid
LEFT JOIN v275d_users AS u
on u.id = a.created_by
LEFT JOIN v275d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN v275d_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 15
AND c.published > 0
AND a.language in ('kk-KZ','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-06 04:49:36')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-06 04:49:36')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.27 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.10 ms Optimizing 0.07 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 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.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Қоңырау шалушы Файл және жол нөмірі 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.93 ms Соңғы сұраудан кейін: 2.36 ms Сұрау жады: 0.028 MB Сұрау алдындағы жады: 2.261 MB Жолдар қайтарылды: 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 `v275d_categories` AS `s`
INNER JOIN `v275d_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('kk-KZ','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 7 Using where; Файлдар пайдалану Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Төмендегі жолда қоңырау шалу сияқты. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.73 ms Соңғы сұраудан кейін: 1.92 ms Сұрау жады: 0.022 MB Сұрау алдындағы жады: 2.285 MB Жолдар қайтарылды: 0
SELECT `m`.`tag_id`,`t`.*
FROM `v275d_contentitem_tag_map` AS m
INNER JOIN `v275d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 15
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 edutrade_sad39.kz.m.tag_id 1 Using where Status Duration Starting 0.07 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 init 0.05 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.05 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.03 ms Query end 0.01 ms Starting cleanup 0.07 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.02 ms # Қоңырау шалушы Файл және жол нөмірі 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 2.48 ms Соңғы сұраудан кейін: 8.38 ms Сұрау жады: 0.025 MB Сұрау алдындағы жады: 2.406 MB Жолдар қайтарылды: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM v275d_fields AS a
LEFT JOIN `v275d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN v275d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN v275d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN v275d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN v275d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `v275d_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Файлдар пайдалану 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 edutrade_sad39.kz.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 edutrade_sad39.kz.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 edutrade_sad39.kz.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 edutrade_sad39.kz.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 edutrade_sad39.kz.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 edutrade_sad39.kz.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.21 ms checking permissions 0.02 ms Opening tables 0.11 ms After opening tables 0.04 ms System lock 0.02 ms table lock 0.01 ms init 0.11 ms Optimizing 0.08 ms Statistics 0.23 ms Preparing 0.08 ms Creating tmp table 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.85 ms Creating sort index 0.08 ms Removing tmp table 0.19 ms Creating sort index 0.02 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Қоңырау шалушы Файл және жол нөмірі 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.83 ms Соңғы сұраудан кейін: 45.98 ms Сұрау жады: 0.021 MB Сұрау алдындағы жады: 2.523 MB Жолдар қайтарылды: 3
SELECT language,id
FROM `v275d_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_menu ALL idx_client_id_parent_id_alias_language ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL 54 Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.11 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.04 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 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/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.53 ms Соңғы сұраудан кейін: 0.35 ms Сұрау жады: 0.024 MB Сұрау алдындағы жады: 2.532 MB Жолдар қайтарылды: 1Қайталанатын сұраулар: #22
SELECT `alias`
FROM `v275d_content`
WHERE id = '15'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Төмендегі жолда қоңырау шалу сияқты. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 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/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.51 ms Соңғы сұраудан кейін: 0.14 ms Сұрау жады: 0.025 MB Сұрау алдындағы жады: 2.541 MB Жолдар қайтарылды: 1Қайталанатын сұраулар: #21
SELECT `alias`
FROM `v275d_content`
WHERE id = '15'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE v275d_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.01 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.03 ms Reset for next command 0.01 ms # Қоңырау шалушы Файл және жол нөмірі 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 18 ContentRouter->getArticleSegment() Төмендегі жолда қоңырау шалу сияқты. 17 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 16 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246 15 Joomla\CMS\Component\Router\Rules\StandardRules->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 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/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 0.89 ms Соңғы сұраудан кейін: 1.69 ms Сұрау жады: 0.021 MB Сұрау алдындағы жады: 2.557 MB Жолдар қайтарылды: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `v275d_content` AS `c`
INNER JOIN `v275d_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `v275d_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `v275d_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `v275d_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 15
AND c2.access IN (1,1,5)
AND c2.language != 'kk-KZ'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2025-12-06 04:49:36')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2025-12-06 04:49:36')
AND c2.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL ИНДЕКСТЕЛЕРДІҢ НЕГІЗГІ НЕМЕСЕ ҚОЛДАНЫЛМАЙДЫ NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.08 ms Statistics 0.14 ms Preparing 0.01 ms Executing 0.02 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.04 ms Reset for next command 0.06 ms # Қоңырау шалушы Файл және жол нөмірі 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 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/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.63 ms Соңғы сұраудан кейін: 9.06 ms Сұрау жады: 0.024 MB Сұрау алдындағы жады: 2.602 MB Жолдар қайтарылды: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM v275d_modules AS m
LEFT JOIN v275d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN v275d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-06 04:49:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:49:36')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 120 OR mm.menuid <= 0)
AND m.language IN ('kk-KZ','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 15 Using index condition; Using where; Файлдар пайдалану 1 SIMPLE mm ref PRIMARY PRIMARY 4 edutrade_sad39.kz.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 edutrade_sad39.kz.m.module,const 1 Using index condition; Using where Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.09 ms Optimizing 0.07 ms Statistics 0.17 ms Preparing 0.10 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.52 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.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.03 ms # Қоңырау шалушы Файл және жол нөмірі 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Төмендегі жолда қоңырау шалу сияқты. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/sad/index.php:103 7 require JROOT/templates/sad/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Сұрау уақыты: 1.08 ms Соңғы сұраудан кейін: 32.52 ms Сұрау жады: 0.023 MB Сұрау алдындағы жады: 2.756 MB Жолдар қайтарылды: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `v275d_menu` AS `c`
INNER JOIN `v275d_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `v275d_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `v275d_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 120id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE a const PRIMARY,idx_key PRIMARY 206 const,const 1 1 SIMPLE a2 ref idx_key idx_key 128 const 2 Using index 1 SIMPLE c2 eq_ref PRIMARY PRIMARY 4 edutrade_sad39.kz.a2.id 1 Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.06 ms Statistics 0.20 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.05 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.04 ms # Қоңырау шалушы Файл және жол нөмірі 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 13 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 12 MenusHelper::getAssociations() JROOT/modules/mod_languages/helper.php:58 11 ModLanguagesHelper::getList() JROOT/modules/mod_languages/mod_languages.php:17 10 include JROOT/modules/mod_languages/mod_languages.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
21 сұраныс түрлері тіркелген, келіп түскен сұрыпталған.
SELECT кестелері:
$ d & # 215; SELECT `id`,`name`,`rules`,`parent_id`
FROM `v275d_assets`$ d & # 215; SELECT `alias`
FROM `v275d_content`$ d & # 215; 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 `v275d_categories` AS `s`
INNER JOIN `v275d_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('kk-KZ','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)$ d & # 215; SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `v275d_extensions`$ d & # 215; SELECT `data`
FROM `v275d_session`$ d & # 215; SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM v275d_modules AS m
LEFT JOIN v275d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN v275d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id$ d & # 215; SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `v275d_content` AS `c`
INNER JOIN `v275d_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `v275d_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `v275d_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `v275d_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'$ d & # 215; SELECT language,id
FROM `v275d_menu`$ d & # 215; SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM v275d_fields AS a
LEFT JOIN `v275d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN v275d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN v275d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN v275d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN v275d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `v275d_fields_categories` AS fc
ON fc.field_id = a.id$ d & # 215; SELECT `m`.`tag_id`,`t`.*
FROM `v275d_contentitem_tag_map` AS m
INNER JOIN `v275d_tags` AS t
ON `m`.`tag_id` = `t`.`id`$ d & # 215; SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM v275d_content AS a
INNER JOIN v275d_categories AS c
on c.id = a.catid
LEFT JOIN v275d_users AS u
on u.id = a.created_by
LEFT JOIN v275d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN v275d_content_rating AS v
ON a.id = v.content_id$ d & # 215; SELECT id, home, template, s.params
FROM v275d_template_styles as s
LEFT JOIN v275d_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id$ d & # 215; SELECT `id`
FROM `v275d_content`$ d & # 215; 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 v275d_menu AS m
LEFT JOIN v275d_extensions AS e
ON m.component_id = e.extension_id$ d & # 215; SELECT `element`,`name`,`client_id`,`extension_id`
FROM `v275d_extensions`$ d & # 215; SELECT *
FROM v275d_languages$ d & # 215; SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM v275d_extensions$ d & # 215; SELECT b.id
FROM v275d_usergroups AS a
LEFT JOIN v275d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt$ d & # 215; SELECT id, rules
FROM `v275d_viewlevels$ d & # 215; SELECT `c2`.`language`,`c2`.`id`
FROM `v275d_menu` AS `c`
INNER JOIN `v275d_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `v275d_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `v275d_menu` AS `c2`
ON a2.id = c2.`id`
Басқа кестелер:
$ d & # 215; UPDATE `v275d_extensions`
SET `params` = '{\"mediaversion\":\"52a31651deb9ab0b289df1e8bb2e56f1\"}'