Время запроса: 0.68 ms Память запроса: 0.023 MB Память до запроса: 3.748 MB Выбрано строк: 0
SELECT `data`
FROM `k93kd_session`
WHERE `session_id` = '7cce05c4848fae240107d878ee21328d'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
Status | Duration |
---|
Starting | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.06 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.01 ms |
Waiting for query cache lock | 0.03 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.02 ms |
Executing | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
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:755 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.49 ms После последнего запроса: 1.19 ms Память запроса: 0.020 MB Память до запроса: 3.843 MB Выбрано строк: 0
SELECT `session_id`
FROM `k93kd_session`
WHERE `session_id` = '7cce05c4848fae240107d878ee21328d'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.04 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 |
Waiting for query cache lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.39 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.90 ms После последнего запроса: 0.08 ms Память запроса: 0.004 MB Память до запроса: 3.848 MB
INSERT INTO `k93kd_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('7cce05c4848fae240107d878ee21328d', 1, '1610864399', 0, '', 0)
EXPLAIN не доступен для запроса: INSERT INTO `k93kd_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('7cce05c4848fae240107d878ee21328d', 1, '1610864399', 0, '', 0)
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 for update | 0.02 ms |
Update | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
Update | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.11 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
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:343 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.90 ms После последнего запроса: 2.66 ms Память запроса: 0.042 MB Память до запроса: 4.119 MB Выбрано строк: 51
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k93kd_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_extensions | ref | extension | extension | 82 | const | 51 | Using index condition |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 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 |
Waiting for query cache lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Preparing | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.23 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 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.08 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 |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:423 |
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:431 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
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:596 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.15 ms После последнего запроса: 2.24 ms Память запроса: 0.022 MB Память до запроса: 4.322 MB Выбрано строк: 29
SELECT id, rules
FROM `k93kd_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_viewlevels | ALL | NULL | Индекс не используется | NULL | NULL | 29 | |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 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.02 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.09 ms Память запроса: 0.021 MB Память до запроса: 4.344 MB Выбрано строк: 1
SELECT b.id
FROM k93kd_usergroups AS a
LEFT JOIN k93kd_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | 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 | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.02 ms |
Checking query cache for query | 0.02 ms |
Checking privileges on cached | 0.01 ms |
Checking permissions | 0.01 ms |
Sending cached result to clien | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.57 ms После последнего запроса: 0.64 ms Память запроса: 0.051 MB Память до запроса: 4.416 MB Выбрано строк: 154
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM k93kd_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_extensions | ref | extension | extension | 82 | const | 195 | Using index condition; Using where; Используется filesort |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 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 |
Waiting for query cache lock | 0.50 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.83 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.39 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.31 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.32 ms |
Reset for next command | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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:606 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.83 ms После последнего запроса: 20.63 ms Память запроса: 0.020 MB Память до запроса: 6.666 MB Выбрано строк: 1
SELECT `enabled`
FROM `k93kd_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.06 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.07 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.02 ms |
Waiting for query cache lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.03 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.02 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.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:80 |
7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
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:622 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.94 ms После последнего запроса: 24.05 ms Память запроса: 0.270 MB Память до запроса: 8.762 MB Выбрано строк: 124
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 k93kd_menu AS m
LEFT JOIN k93kd_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.lft
id | 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 | 139 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 0.56 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.08 ms |
Waiting for query cache lock | 0.07 ms |
Creating sort index | 0.07 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.50 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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:374 |
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:488 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jlnodoubles/jlnodoubles.php:193 |
8 | plgSystemJlnodoubles->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:623 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.72 ms После последнего запроса: 19.18 ms Память запроса: 0.022 MB Память до запроса: 10.964 MB Выбрано строк: 0
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 `k93kd_categories` AS `s`
INNER JOIN `k93kd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) 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)
AND c.published = 1
AND s.id = 506
ORDER BY c.lft
id | 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.04 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.02 ms |
Checking query cache for query | 0.13 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.03 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.05 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.15 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:312 |
12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
10 | ContentRouterRulesLegacy->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:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.69 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB Память до запроса: 10.969 MB Выбрано строк: 1
SELECT `alias`,`catid`
FROM `k93kd_content`
WHERE `id` = 506
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.02 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 |
Waiting for query cache lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 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 |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.11 ms |
Updating status | 0.08 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.06 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
10 | ContentRouterRulesLegacy->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:1071 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.74 ms После последнего запроса: 0.40 ms Память запроса: 0.024 MB Память до запроса: 11.009 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k93kd_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.12 ms |
Init | 0.01 ms |
Checking query cache for query | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.08 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.02 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 |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.02 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 |
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Так же, как вызов в строке ниже. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 |
8 | plgSystemDJjQueryMonster->onAfterRoute() | 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:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.11 ms После последнего запроса: 0.15 ms Память запроса: 0.006 MB Память до запроса: 11.001 MB
UPDATE `k93kd_extensions`
SET `params` = '{\"mediaversion\":\"0e2599e0989b6d4928a30235a2c80811\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN не доступен для запроса: UPDATE `k93kd_extensions`
SET `params` = '{\"mediaversion\":\"0e2599e0989b6d4928a30235a2c80811\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.03 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 for update | 0.06 ms |
Updating | 0.06 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.52 ms |
End of update loop | 0.18 ms |
Query end | 0.01 ms |
Commit | 0.06 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 |
8 | plgSystemDJjQueryMonster->onAfterRoute() | 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:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.35 ms После последнего запроса: 2.06 ms Память запроса: 0.084 MB Память до запроса: 11.175 MB Выбрано строк: 8
SELECT id, home, template, s.params
FROM k93kd_template_styles as s
LEFT JOIN k93kd_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 = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 6 | Using index condition; Using where |
1 | SIMPLE | s | ref | idx_template | idx_template | 202 | skrapikr_bsoft117.e.element | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.46 ms |
Init | 0.02 ms |
Checking query cache for query | 0.06 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.02 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.15 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:917 |
9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:210 |
8 | plgSystemEF4_JMFramework->onAfterRoute() | 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:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.00 ms После последнего запроса: 10.07 ms Память запроса: 0.021 MB Память до запроса: 11.989 MB Выбрано строк: 1
SELECT `id`, `alias`, `catid`, `language`
FROM k93kd_content
WHERE `id` = 506
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.05 ms |
Waiting for query cache lock | 0.14 ms |
Init | 0.01 ms |
Checking query cache for query | 0.08 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.02 ms |
Waiting for query cache lock | 0.07 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.05 ms |
Updating status | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.36 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
10 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jlnodoubles/helpers/com_content.php:36 |
9 | JLNodoubles_com_content_helper->go() | JROOT/plugins/system/jlnodoubles/jlnodoubles.php:137 |
8 | plgSystemJlnodoubles->onAfterRoute() | 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:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 0.45 ms Память запроса: 0.027 MB Память до запроса: 12.014 MB Выбрано строк: 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 `k93kd_categories` AS `s`
INNER JOIN `k93kd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) 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)
AND c.published = 1
AND s.id = 52
ORDER BY c.lft
id | 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 | Индекс не используется | NULL | NULL | 44 | Using where; Используется filesort |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.06 ms |
Init | 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.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:312 |
20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
19 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
18 | ContentRouter->getCategorySegment() | Так же, как вызов в строке ниже. |
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/MenuRules.php:111 |
15 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
14 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
13 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
12 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
11 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
10 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/jlnodoubles/helpers/com_content.php:61 |
9 | JLNodoubles_com_content_helper->go() | JROOT/plugins/system/jlnodoubles/jlnodoubles.php:137 |
8 | plgSystemJlnodoubles->onAfterRoute() | 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:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 2.89 ms Память запроса: 0.032 MB Память до запроса: 12.190 MB Выбрано строк: 91
SELECT *
FROM `k93kd_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_jcomments_settings | ref | PRIMARY | PRIMARY | 214 | const,const | 91 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Init | 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.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
14 | JCommentsCfg::_load() | Так же, как вызов в строке ниже. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
11 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->onAfterRoute() | 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:1080 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 43.16 ms Память запроса: 0.020 MB Память до запроса: 16.884 MB Выбрано строк: 2
SELECT *
FROM k93kd_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_languages | ALL | NULL | Индекс не используется | NULL | NULL | 2 | Using where; Используется filesort |
Status | Duration |
---|
Starting | 0.05 ms |
Waiting for query cache lock | 0.02 ms |
Init | 0.02 ms |
Checking query cache for query | 0.03 ms |
Checking privileges on cached | 0.02 ms |
Checking permissions | 0.02 ms |
Sending cached result to clien | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.25 ms После последнего запроса: 2.17 ms Память запроса: 0.029 MB Память до запроса: 17.009 MB Выбрано строк: 50
SELECT `id`,`name`,`rules`,`parent_id`
FROM `k93kd_assets`
WHERE `name` IN ('root.1','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_bdthemes_shortcodes','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_djmediatools','com_djtabs','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_joomlycallback','com_jsecure','com_jsecurelite','com_jshopping','com_jsn','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_regularlabsmanager','com_rstbox','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 51 | Using index condition |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.07 ms |
Init | 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.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:248 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.36 ms После последнего запроса: 1.03 ms Память запроса: 0.031 MB Память до запроса: 17.131 MB Выбрано строк: 30
SHOW FULL COLUMNS
FROM `k93kd_content`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `k93kd_content`
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.02 ms |
Closing tables | 0.02 ms |
Opening tables | 0.31 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
Checking permissions | 0.24 ms |
Closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.02 ms |
Removing tmp table | 0.09 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:250 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.86 ms После последнего запроса: 2.78 ms Память запроса: 0.038 MB Память до запроса: 17.426 MB Выбрано строк: 1
SELECT *
FROM k93kd_content
WHERE `id` = '506'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.06 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.02 ms |
Waiting for query cache lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.04 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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 | 1.03 ms |
Waiting for query cache lock | 0.03 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.05 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
10 | Joomla\CMS\Table\Table->load() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.02 ms После последнего запроса: 0.10 ms Память запроса: 0.005 MB Память до запроса: 17.446 MB
UPDATE k93kd_content
SET `hits` = (`hits` + 1)
WHERE `id` = '506'
EXPLAIN не доступен для запроса: UPDATE k93kd_content
SET `hits` = (`hits` + 1)
WHERE `id` = '506'
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init for update | 0.08 ms |
Updating | 0.16 ms |
End of update loop | 0.02 ms |
Waiting for query cache lock | 0.02 ms |
End of update loop | 0.30 ms |
Query end | 0.04 ms |
Commit | 0.09 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1242 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:252 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.51 ms После последнего запроса: 1.51 ms Память запроса: 0.038 MB Память до запроса: 17.567 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 k93kd_content AS a
INNER JOIN k93kd_categories AS c
on c.id = a.catid
LEFT JOIN k93kd_users AS u
on u.id = a.created_by
LEFT JOIN k93kd_categories as parent
ON parent.id = c.parent_id
LEFT JOIN k93kd_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 506
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 06:19:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 06:19:59')
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 | 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.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.24 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
Init | 0.11 ms |
Optimizing | 0.07 ms |
Statistics | 0.19 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.07 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.22 ms |
Updating status | 0.08 ms |
Waiting for query cache lock | 0.03 ms |
Updating status | 0.02 ms |
Storing result in query cache | 0.22 ms |
Reset for next command | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:148 |
12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.31 ms После последнего запроса: 1.39 ms Память запроса: 0.022 MB Память до запроса: 17.677 MB Выбрано строк: 1
SELECT `m`.`tag_id`,`t`.*
FROM `k93kd_contentitem_tag_map` AS m
INNER JOIN `k93kd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 506
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | t | ref | PRIMARY,tag_idx,idx_access | tag_idx | 1 | const | 16 | Using index condition |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | skrapikr_bsoft117.t.id | 3 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.15 ms |
Init | 0.02 ms |
Checking query cache for query | 0.08 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.02 ms |
Waiting for query cache lock | 0.14 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.11 ms |
Preparing | 0.06 ms |
Executing | 0.01 ms |
Sending data | 0.27 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 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.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.89 ms После последнего запроса: 6.03 ms Память запроса: 0.023 MB Память до запроса: 18.145 MB Выбрано строк: 1
SELECT enabled
FROM k93kd_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.03 ms |
Waiting for query cache lock | 0.03 ms |
Init | 0.02 ms |
Checking query cache for query | 0.07 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Waiting for query cache lock | 0.04 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.04 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.03 ms |
Waiting for query cache lock | 0.02 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.37 ms |
Reset for next command | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
15 | JDatabaseDriver->loadResult() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:137 |
14 | PlgContentSppagebuilder->isSppagebuilderEnabled() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:26 |
13 | PlgContentSppagebuilder->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
12 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
11 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_content/views/article/view.html.php:192 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.26 ms После последнего запроса: 11.76 ms Память запроса: 0.025 MB Память до запроса: 19.106 MB Выбрано строк: 0
SELECT 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 k93kd_fields AS a
LEFT JOIN `k93kd_languages` AS l
ON l.lang_code = a.language
LEFT JOIN k93kd_users AS uc
ON uc.id=a.checked_out
LEFT JOIN k93kd_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN k93kd_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN k93kd_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `k93kd_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 (52,0,44))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | 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; Используется filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | skrapikr_bsoft117.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.06 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.02 ms |
Checking query cache for query | 0.02 ms |
Checking privileges on cached | 0.01 ms |
Checking permissions | 0.03 ms |
Sending cached result to clien | 0.03 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
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:327 |
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:479 |
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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.23 ms После последнего запроса: 4.88 ms Память запроса: 0.024 MB Память до запроса: 19.453 MB Выбрано строк: 1
SELECT a.id
FROM k93kd_sppagebuilder_integrations as a
WHERE `component` = 'com_content'
AND `state` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | Индекс не используется | NULL | NULL | 1 | Using where |
Status | Duration |
---|
Starting | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.03 ms |
Checking query cache for query | 0.02 ms |
Checking privileges on cached | 0.02 ms |
Checking permissions | 0.02 ms |
Sending cached result to clien | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
16 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:236 |
15 | SppagebuilderHelper::getIntegration() | JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:128 |
14 | SppagebuilderHelper::onIntegrationPrepareContent() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:86 |
13 | PlgContentSppagebuilder->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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.58 ms После последнего запроса: 0.06 ms Память запроса: 0.024 MB Память до запроса: 19.462 MB Выбрано строк: 0
SELECT `text`
FROM `k93kd_sppagebuilder`
WHERE `extension` = 'com_content'
AND `extension_view` = 'article'
AND `view_id` = '506'
AND `active` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_sppagebuilder | ALL | NULL | Индекс не используется | NULL | NULL | 80 | Using where |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.09 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Waiting for query cache lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.04 ms |
Preparing | 0.07 ms |
Executing | 0.02 ms |
Sending data | 0.21 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.03 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.61 ms |
Waiting for query cache lock | 0.03 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.59 ms |
Reset for next command | 0.02 ms |
# | Вызывающий объект | Файл и номер строки |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:167 |
15 | SppagebuilderHelper::getPageContent() | JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:132 |
14 | SppagebuilderHelper::onIntegrationPrepareContent() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:86 |
13 | PlgContentSppagebuilder->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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 4.40 ms После последнего запроса: 1.59 ms Память запроса: 0.179 MB Память до запроса: 19.572 MB Выбрано строк: 84
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM k93kd_modules AS m
LEFT JOIN k93kd_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN k93kd_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 <= '2021-01-17 06:19:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-17 06:19:59')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 365 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 138 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | skrapikr_bsoft117.m.module,const | 1 | Using index condition; Using where |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.m.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.03 ms |
Waiting for query cache lock | 0.59 ms |
Init | 0.02 ms |
Checking query cache for query | 0.13 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.06 ms |
Optimizing | 0.07 ms |
Statistics | 0.10 ms |
Preparing | 0.06 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 1.97 ms |
Waiting for query cache lock | 0.03 ms |
Creating sort index | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.86 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.03 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | Так же, как вызов в строке ниже. |
19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
17 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
16 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
15 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/plugins/content/loadmodule/loadmodule.php:168 |
14 | PlgContentLoadmodule->_loadmod() | JROOT/plugins/content/loadmodule/loadmodule.php:113 |
13 | PlgContentLoadmodule->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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 1.98 ms Память запроса: 0.029 MB Память до запроса: 19.686 MB Выбрано строк: 0
SELECT 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 k93kd_fields AS a
LEFT JOIN `k93kd_languages` AS l
ON l.lang_code = a.language
LEFT JOIN k93kd_users AS uc
ON uc.id=a.checked_out
LEFT JOIN k93kd_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN k93kd_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN k93kd_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `k93kd_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (52,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | 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; Используется filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | skrapikr_bsoft117.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | skrapikr_bsoft117.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Init | 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.02 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
28 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
27 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
26 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
25 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
24 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
23 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
22 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
21 | JHtmlContent::prepare() | Так же, как вызов в строке ниже. |
20 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
19 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
18 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
17 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
16 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
15 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/plugins/content/loadmodule/loadmodule.php:183 |
14 | PlgContentLoadmodule->_loadmod() | JROOT/plugins/content/loadmodule/loadmodule.php:113 |
13 | PlgContentLoadmodule->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:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 5.77 ms Память запроса: 0.025 MB Память до запроса: 20.128 MB Выбрано строк: 1
SELECT COUNT(*)
FROM `k93kd_jcomments_blacklist`
WHERE `ip` = '18.234.247.75'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_jcomments_blacklist | ref | idx_ip | idx_ip | 119 | const | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.04 ms |
Waiting for query cache lock | 0.02 ms |
Init | 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.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
19 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/classes/security.php:141 |
18 | JCommentsSecurity::checkBlacklist() | JROOT/components/com_jcomments/classes/acl.php:76 |
17 | JCommentsACL->JCommentsACL() | JROOT/components/com_jcomments/classes/factory.php:274 |
16 | JCommentsFactory::getACL() | JROOT/components/com_jcomments/jcomments.php:188 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:282 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:339 |
13 | plgContentJComments->onContentAfterDisplay() | 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:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.05 ms После последнего запроса: 0.56 ms Память запроса: 0.027 MB Память до запроса: 20.192 MB Выбрано строк: 1
SELECT *
FROM `k93kd_jcomments_objects`
WHERE `object_id` = '506'
AND `object_group` = 'com_content'
AND `lang` = 'ru-RU'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_jcomments_objects | ref | idx_object | idx_object | 833 | const,const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.05 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.41 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.06 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
23 | JDatabaseDriver->loadObject() | JROOT/components/com_jcomments/models/object.php:28 |
22 | JCommentsModelObject::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:116 |
21 | JCommentsObjectHelper::fetchObjectInfo() | Так же, как вызов в строке ниже. |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/helpers/object.php:158 |
18 | JCommentsObjectHelper::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:46 |
17 | JCommentsObjectHelper::getLink() | JROOT/components/com_jcomments/classes/factory.php:255 |
16 | JCommentsFactory::getTemplate() | JROOT/components/com_jcomments/jcomments.php:192 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:282 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:339 |
13 | plgContentJComments->onContentAfterDisplay() | 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:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.52 ms После последнего запроса: 0.25 ms Память запроса: 0.026 MB Память до запроса: 20.189 MB Выбрано строк: 1
SELECT count(*)
FROM k93kd_jcomments AS c
WHERE c.object_id = 506
AND c.object_group = 'com_content'
AND c.published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 8 | Using where; Using index |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.03 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.02 ms |
Waiting for query cache lock | 0.02 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.03 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.51 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/models/jcomments.php:35 |
17 | JCommentsModel::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:1300 |
16 | JComments::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:222 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:282 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:339 |
13 | plgContentJComments->onContentAfterDisplay() | 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:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.25 ms После последнего запроса: 0.14 ms Память запроса: 0.029 MB Память до запроса: 20.203 MB Выбрано строк: 8
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, v.value as voted
,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM k93kd_jcomments AS c
LEFT JOIN k93kd_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '18.234.247.75'
WHERE c.object_id = 506
AND c.object_group = 'com_content'
AND c.published = 1
ORDER BY threadDate DESC, c.date ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 8 | Using index condition; Using where; Используется filesort |
1 | SIMPLE | v | ref | idx_comment,idx_user | idx_comment | 8 | skrapikr_bsoft117.c.id,const | 1 | Using where |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 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 |
Waiting for query cache lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.24 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 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.10 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.21 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/models/jcomments.php:80 |
17 | JCommentsModel::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:789 |
16 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:267 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:282 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:339 |
13 | plgContentJComments->onContentAfterDisplay() | 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:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.54 ms После последнего запроса: 1.58 ms Память запроса: 0.026 MB Память до запроса: 20.353 MB Выбрано строк: 1
SELECT id as userid, avatar
FROM k93kd_jsn_users
WHERE id in (131)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_jsn_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 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 |
Waiting for query cache lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 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 |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.04 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.03 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.08 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/plugins/jcomments/avatar/avatar.php:417 |
20 | plgJCommentsAvatar->onPrepareAvatars() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/components/com_jcomments/helpers/event.php:45 |
17 | JCommentsEventHelper::trigger() | JROOT/components/com_jcomments/jcomments.php:819 |
16 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:267 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:282 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:339 |
13 | plgContentJComments->onContentAfterDisplay() | 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:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.44 ms После последнего запроса: 0.25 ms Память запроса: 0.028 MB Память до запроса: 20.370 MB Выбрано строк: 1
SELECT a.username
FROM k93kd_users AS a
WHERE a.id = 131
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.03 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 |
Waiting for query cache lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 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 |
Closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 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.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
28 | JDatabaseDriver->loadResult() | JROOT/components/com_jsn/router.php:61 |
27 | JsnBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
26 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
25 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
24 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
23 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
22 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
21 | Joomla\CMS\Router\Route::_() | JROOT/plugins/jcomments/avatar/avatar.php:423 |
20 | plgJCommentsAvatar->onPrepareAvatars() | JROOT/libraries/joomla/event/event.php:70 |
19 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
18 | JEventDispatcher->trigger() | JROOT/components/com_jcomments/helpers/event.php:45 |
17 | JCommentsEventHelper::trigger() | JROOT/components/com_jcomments/jcomments.php:819 |
16 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:267 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:282 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:339 |
13 | plgContentJComments->onContentAfterDisplay() | 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:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
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:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.21 ms После последнего запроса: 59.46 ms Память запроса: 0.020 MB Память до запроса: 21.029 MB Выбрано строк: 0
select b.*
from k93kd_rstbox b
where b.published = 1
AND b.testmode=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | b | ALL | NULL | Индекс не используется | NULL | NULL | 30 | Using where |
Status | Duration |
---|
Starting | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
Init | 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.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
9 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rstbox/helpers/helper.php:283 |
8 | EBHelper::getBoxes() | JROOT/plugins/system/rstbox/rstbox.php:78 |
7 | PlgSystemRstBox->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:195 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.20 ms После последнего запроса: 6.81 ms Память запроса: 0.021 MB Память до запроса: 21.335 MB Выбрано строк: 11
SELECT id
FROM k93kd_template_styles
ORDER BY id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | k93kd_template_styles | index | NULL | PRIMARY | 4 | NULL | 11 | Using index |
Status | Duration |
---|
Starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.02 ms |
Checking privileges on cached | 0.01 ms |
Checking permissions | 0.03 ms |
Sending cached result to clien | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:314 |
9 | JMFTemplate->setup() | JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126 |
8 | JMFTemplate->__construct() | JROOT/templates/jm-cleaning-company/index.php:18 |
7 | require JROOT/templates/jm-cleaning-company/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 54.54 ms Память запроса: 0.025 MB Память до запроса: 23.251 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 `k93kd_categories` AS `s`
INNER JOIN `k93kd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) 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)
AND c.published = 1
AND s.id = 63
ORDER BY c.lft
id | 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 | Индекс не используется | NULL | NULL | 44 | Using where; Используется filesort |
Status | Duration |
---|
Starting | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
Init | 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.02 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:312 |
18 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
17 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
16 | ContentRouter->getCategorySegment() | Так же, как вызов в строке ниже. |
15 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
14 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
13 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
12 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
11 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
10 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
9 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->onAfterRender() | 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/CMSApplication.php:1047 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.27 ms Память запроса: 0.026 MB Память до запроса: 23.340 MB Выбрано строк: 4
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 `k93kd_categories` AS `s`
INNER JOIN `k93kd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) 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)
AND c.published = 1
AND s.id = 57
ORDER BY c.lft
id | 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 | Индекс не используется | NULL | NULL | 44 | Using where; Используется filesort |
Status | Duration |
---|
Starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Init | 0.01 ms |
Checking query cache for query | 0.02 ms |
Checking privileges on cached | 0.01 ms |
Checking permissions | 0.01 ms |
Sending cached result to clien | 0.01 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Вызывающий объект | Файл и номер строки |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:312 |
18 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
17 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
16 | ContentRouter->getCategorySegment() | Так же, как вызов в строке ниже. |
15 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
14 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
13 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
12 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
11 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
10 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
9 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
7 | PlgSystemSef->onAfterRender() | 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/CMSApplication.php:1047 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
4 × 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 `k93kd_categories` AS `s`
INNER JOIN `k93kd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k93kd_extensions`
2 × SELECT 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 k93kd_fields AS a
LEFT JOIN `k93kd_languages` AS l
ON l.lang_code = a.language
LEFT JOIN k93kd_users AS uc
ON uc.id=a.checked_out
LEFT JOIN k93kd_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN k93kd_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN k93kd_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `k93kd_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT `data`
FROM `k93kd_session`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `k93kd_contentitem_tag_map` AS m
INNER JOIN `k93kd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × select b.*
from k93kd_rstbox b
1 × SELECT a.username
FROM k93kd_users AS a
1 × SELECT id as userid, avatar
FROM k93kd_jsn_users
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM k93kd_jcomments AS c
LEFT JOIN k93kd_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '18.234.247.75'
1 × SELECT count(*)
FROM k93kd_jcomments AS c
1 × SELECT *
FROM `k93kd_jcomments_objects`
1 × SELECT COUNT(*)
FROM `k93kd_jcomments_blacklist`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM k93kd_modules AS m
LEFT JOIN k93kd_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN k93kd_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `text`
FROM `k93kd_sppagebuilder`
1 × SELECT a.id
FROM k93kd_sppagebuilder_integrations as a
1 × SELECT enabled
FROM k93kd_extensions
1 × SELECT *
FROM k93kd_content
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 k93kd_content AS a
INNER JOIN k93kd_categories AS c
on c.id = a.catid
LEFT JOIN k93kd_users AS u
on u.id = a.created_by
LEFT JOIN k93kd_categories as parent
ON parent.id = c.parent_id
LEFT JOIN k93kd_content_rating AS v
ON a.id = v.content_id
1 × SELECT `session_id`
FROM `k93kd_session`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `k93kd_assets`
1 × SELECT *
FROM k93kd_languages
1 × SELECT *
FROM `k93kd_jcomments_settings`
1 × SELECT `id`, `alias`, `catid`, `language`
FROM k93kd_content
1 × SELECT id, home, template, s.params
FROM k93kd_template_styles as s
LEFT JOIN k93kd_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `alias`,`catid`
FROM `k93kd_content`
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 k93kd_menu AS m
LEFT JOIN k93kd_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `enabled`
FROM `k93kd_extensions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM k93kd_extensions
1 × SELECT b.id
FROM k93kd_usergroups AS a
LEFT JOIN k93kd_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `k93kd_viewlevels
1 × SELECT id
FROM k93kd_template_styles
Комментарии
Добрый день, Ася.
Если период еще не закрыт, т.е. не рассчитана полностью зарплата и страховые взносы, то надо просто исправить дату о[censored]ния отпуска в первоначальном документе, НЕ создавая новый документ исправлением.
Спасибо за познавательную статью!
Очень все доходчиво написано.
Но вот нет ни слова, ни примера, как после всех этих расчетов выплаты делать.
Получается, что ЗУП 3.1 выплачивает кусок БЛ за счет сторнированных отпускных и оставшийся кусок, если поставить выплату "Отпуск".
Хотя по факту:
-отпускные выплачены в полном размере в прошлом месяце;
-ЗП пропорционально дням отпуска и БЛ начислена;
-БЛ должен быть выплачен в полном объеме.
Подскажите, что с этим делать?
Спасибо.
Наталья, добрый день. Справка 2-НДФЛ будет заполнена следующим образом:
Месяц Код дохода Сумма
Июль 2012 15667,92
Август 2012 8704,40
Август 2300 10762,80
RSS лента комментариев этой записи