Время запроса: 1.14 ms Память запроса: 0.023 MB. Память перед запросом: 1.032 MB Возвращено строк: 0
SELECT `data`
FROM `tr1hf_session`
WHERE `session_id` = X'6534316436323333666263653938376662643636613833326530396633333636'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.04 ms |
| Init | 0.04 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Executing | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.04 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Такой же, как вызов в строке ниже |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 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:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 1.04 ms После последнего запроса: 2.71 ms Память запроса: 0.020 MB. Память перед запросом: 1.046 MB Возвращено строк: 0
SELECT `session_id`
FROM `tr1hf_session`
WHERE `session_id` = X'6534316436323333666263653938376662643636613833326530396633333636'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Executing | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 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:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 1.07 ms После последнего запроса: 0.15 ms Память запроса: 0.004 MB. Память перед запросом: 1.051 MB
INSERT INTO `tr1hf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6534316436323333666263653938376662643636613833326530396633333636', 1, 1715056642, 0, '', 0)
EXPLAIN недоступен для: INSERT INTO `tr1hf_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6534316436323333666263653938376662643636613833326530396633333636', 1, 1715056642, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init for update | 0.04 ms |
| Update | 0.15 ms |
| Waiting for query cache lock | 0.03 ms |
| Update | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.11 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 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:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Время запроса: 1.02 ms После последнего запроса: 7.48 ms Память запроса: 0.021 MB. Память перед запросом: 1.182 MB Возвращено строк: 3
SELECT id, rules
FROM `tr1hf_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_viewlevels | ALL | NULL | INDEX KEY не используется | NULL | NULL | 3 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.03 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.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.04 ms После последнего запроса: 0.14 ms Память запроса: 0.021 MB. Память перед запросом: 1.194 MB Возвращено строк: 1
SELECT b.id
FROM tr1hf_usergroups AS a
LEFT JOIN tr1hf_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.08 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.02 ms |
| Init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.97 ms После последнего запроса: 27.82 ms Память запроса: 0.022 MB. Память перед запросом: 1.675 MB Возвращено строк: 1
SELECT `value`
FROM `tr1hf_admintools_storage`
WHERE `key` = 'cparams'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_admintools_storage | const | PRIMARY | PRIMARY | 402 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.03 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.05 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_admintools/Helper/Storage.php:122 |
| 12 | Akeeba\AdminTools\Admin\Helper\Storage->load() | JROOT/administrator/components/com_admintools/Helper/Storage.php:37 |
| 11 | Akeeba\AdminTools\Admin\Helper\Storage->__construct() | JROOT/administrator/components/com_admintools/Helper/Storage.php:49 |
| 10 | Akeeba\AdminTools\Admin\Helper\Storage::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:409 |
| 9 | plgSystemAdmintools->loadComponentParameters() | JROOT/plugins/system/admintools/admintools/main.php:892 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.71 ms После последнего запроса: 0.38 ms Память запроса: 0.021 MB. Память перед запросом: 1.683 MB Возвращено строк: 0
SELECT *
FROM `tr1hf_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_admintools_wafexceptions | ALL | NULL | INDEX KEY не используется | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.02 ms |
| Init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/admintools/admintools/main.php:729 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT/plugins/system/admintools/admintools/main.php:640 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT/plugins/system/admintools/admintools/main.php:901 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.49 ms После последнего запроса: 51.72 ms Память запроса: 0.021 MB. Память перед запросом: 3.180 MB Возвращено строк: 0
SELECT `source`,`keepurlparams`
FROM `tr1hf_admintools_redirects`
WHERE ((`dest` = 'index.php/deyatelnost/dopolnitelnoe-obrazovanie/1416-kruglyj-stol-uchrezhdenij-dopolnitelnogo-obrazovaniya-detej-georgievskogo-gorodskogo-okruga') OR (`dest` = 'index.php/deyatelnost/dopolnitelnoe-obrazovanie/1416-kruglyj-stol-uchrezhdenij-dopolnitelnogo-obrazovaniya-detej-georgievskogo-gorodskogo-okruga') OR ('index.php/deyatelnost/dopolnitelnoe-obrazovanie/1416-kruglyj-stol-uchrezhdenij-dopolnitelnogo-obrazovaniya-detej-georgievskogo-gorodskogo-okruga' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_admintools_redirects | ALL | NULL | INDEX KEY не используется | NULL | NULL | 1 | Using where; Используется сортировка файлов |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Checking permissions | 0.06 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.05 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.03 ms |
| Executing | 0.03 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1773 |
| 11 | JDatabaseDriver->loadRow() | JROOT/plugins/system/admintools/feature/urlredir.php:91 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:144 |
| 8 | plgSystemAdmintools->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:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.77 ms После последнего запроса: 26.19 ms Память запроса: 0.022 MB. Память перед запросом: 4.612 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 `tr1hf_categories` AS `s`
INNER JOIN `tr1hf_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 = 1416
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | INDEX KEY не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.19 ms |
| After opening tables | 0.06 ms |
| System lock | 0.03 ms |
| Table lock | 0.03 ms |
| Init | 0.11 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.10 ms |
| Preparing | 0.03 ms |
| Executing | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 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:438 |
| 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:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.07 ms После последнего запроса: 0.09 ms Память запроса: 0.021 MB. Память перед запросом: 4.617 MB Возвращено строк: 1
SELECT `alias`,`catid`
FROM `tr1hf_content`
WHERE `id` = 1416
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.02 ms |
| Init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 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:438 |
| 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:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.28 ms После последнего запроса: 4.29 ms Память запроса: 0.005 MB. Память перед запросом: 4.629 MB
UPDATE `tr1hf_extensions`
SET `params` = '{\"mediaversion\":\"4d3059e0baf43169f1fab6ccde9e6ce9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN недоступен для: UPDATE `tr1hf_extensions`
SET `params` = '{\"mediaversion\":\"4d3059e0baf43169f1fab6ccde9e6ce9\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.02 ms |
| Init for update | 0.14 ms |
| Updating | 0.10 ms |
| End of update loop | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.09 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.93 ms После последнего запроса: 10.03 ms Память запроса: 0.027 MB. Память перед запросом: 4.814 MB Возвращено строк: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tr1hf_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sige','com_smartslider3','com_tags','com_templates','com_users','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_assets | range | idx_asset_name | idx_asset_name | 152 | NULL | 41 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.13 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.23 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.42 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.12 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 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:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 12.58 ms После последнего запроса: 0.18 ms Память запроса: 0.598 MB. Память перед запросом: 4.864 MB Возвращено строк: 3339
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tr1hf_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | tr1hf_assets | ALL | idx_asset_name,idx_parent_id | INDEX KEY не используется | NULL | NULL | 5802 | Using where |
| 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.02 ms |
| Table lock | 0.03 ms |
| Init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.13 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 11.54 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 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:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.51 ms После последнего запроса: 7.10 ms Память запроса: 0.031 MB. Память перед запросом: 7.546 MB Возвращено строк: 31
SHOW FULL COLUMNS
FROM `tr1hf_content`
EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `tr1hf_content`
| Status | Duration |
|---|
| Starting | 0.06 ms |
| Checking permissions | 0.03 ms |
| Closing tables | 0.03 ms |
| Opening tables | 0.68 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| Checking permissions | 0.23 ms |
| Closing tables | 0.11 ms |
| Executing | 0.02 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Removing tmp table | 0.22 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 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:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.12 ms После последнего запроса: 4.07 ms Память запроса: 0.005 MB. Память перед запросом: 7.603 MB
UPDATE tr1hf_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1416'
EXPLAIN недоступен для: UPDATE tr1hf_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1416'
| Status | Duration |
|---|
| Starting | 0.08 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.02 ms |
| Init for update | 0.07 ms |
| Updating | 0.10 ms |
| End of update loop | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.07 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
| 10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 1.89 ms После последнего запроса: 12.19 ms Память запроса: 0.039 MB. Память перед запросом: 7.651 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 tr1hf_content AS a
INNER JOIN tr1hf_categories AS c
on c.id = a.catid
LEFT JOIN tr1hf_users AS u
on u.id = a.created_by
LEFT JOIN tr1hf_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tr1hf_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 1416
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-07 04:37:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-07 04:37:22')
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.22 ms |
| Checking permissions | 0.04 ms |
| Opening tables | 0.13 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.02 ms |
| Init | 0.09 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.20 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.14 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 13 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.15 ms После последнего запроса: 4.75 ms Память запроса: 0.045 MB. Память перед запросом: 7.752 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 `tr1hf_categories` AS `s`
INNER JOIN `tr1hf_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 = 41
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 | INDEX KEY не используется | NULL | NULL | 183 | Using where; Используется сортировка файлов |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.02 ms |
| Init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.14 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.60 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 21 | ContentRouter->getCategorySegment() | Такой же, как вызов в строке ниже |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.11 ms После последнего запроса: 1.54 ms Память запроса: 0.023 MB. Память перед запросом: 7.804 MB Возвращено строк: 1
SELECT `m`.`tag_id`,`t`.*
FROM `tr1hf_contentitem_tag_map` AS m
INNER JOIN `tr1hf_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1416
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 | ALL | PRIMARY,tag_idx,idx_access | INDEX KEY не используется | NULL | NULL | 3 | Using where |
| 1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | georggorono.t.id | 550 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| Table lock | 0.02 ms |
| Init | 0.08 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.69 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 3.35 ms После последнего запроса: 15.71 ms Память запроса: 0.025 MB. Память перед запросом: 7.968 MB Возвращено строк: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM tr1hf_fields AS a
LEFT JOIN `tr1hf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tr1hf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tr1hf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tr1hf_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tr1hf_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tr1hf_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 (41,0,45,10))
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; Using temporary; Используется сортировка файлов |
| 1 | SIMPLE | l | ALL | NULL | INDEX KEY не используется | NULL | NULL | 2 | Using where; Using join buffer (flat, BNL join) |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | georggorono.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | georggorono.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | georggorono.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | georggorono.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | georggorono.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.23 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| Table lock | 0.02 ms |
| Init | 0.11 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.20 ms |
| Preparing | 0.08 ms |
| Creating tmp table | 0.16 ms |
| Sorting result | 0.12 ms |
| Executing | 0.02 ms |
| Sending data | 0.82 ms |
| Creating sort index | 0.07 ms |
| Removing tmp table | 0.24 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.02 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 14 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 13 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 12 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 11 | ContentViewArticle->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 2.32 ms После последнего запроса: 50.84 ms Память запроса: 0.025 MB. Память перед запросом: 8.154 MB Возвращено строк: 13
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM tr1hf_modules AS m
LEFT JOIN tr1hf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN tr1hf_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 <= '2024-05-07 04:37:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-07 04:37:22')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 122 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 | 17 | Using index condition; Using where; Используется сортировка файлов |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | georggorono.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | georggorono.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Checking permissions | 0.03 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| Table lock | 0.03 ms |
| Init | 0.07 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.15 ms |
| Preparing | 0.10 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.64 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Closing tables | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.03 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | Такой же, как вызов в строке ниже |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 11 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 10 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/oo1head1/library/Artx/Page.php:43 |
| 8 | ArtxPage->containsModules() | JROOT/templates/oo1head1/index.php:108 |
| 7 | require JROOT/templates/oo1head1/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `tr1hf_categories` AS `s`
INNER JOIN `tr1hf_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 `id`,`name`,`rules`,`parent_id`
FROM `tr1hf_assets`
1 × SELECT `data`
FROM `tr1hf_session`
1 × SELECT `session_id`
FROM `tr1hf_session`
1 × SELECT id, rules
FROM `tr1hf_viewlevels
1 × SELECT b.id
FROM tr1hf_usergroups AS a
LEFT JOIN tr1hf_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `value`
FROM `tr1hf_admintools_storage`
1 × SELECT *
FROM `tr1hf_admintools_wafexceptions`
1 × SELECT `source`,`keepurlparams`
FROM `tr1hf_admintools_redirects`
1 × SELECT `alias`,`catid`
FROM `tr1hf_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 tr1hf_content AS a
INNER JOIN tr1hf_categories AS c
on c.id = a.catid
LEFT JOIN tr1hf_users AS u
on u.id = a.created_by
LEFT JOIN tr1hf_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tr1hf_content_rating AS v
ON a.id = v.content_id
1 × SELECT `m`.`tag_id`,`t`.*
FROM `tr1hf_contentitem_tag_map` AS m
INNER JOIN `tr1hf_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM tr1hf_fields AS a
LEFT JOIN `tr1hf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tr1hf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tr1hf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tr1hf_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tr1hf_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tr1hf_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM tr1hf_modules AS m
LEFT JOIN tr1hf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN tr1hf_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
20 апреля 2018 года на базе муниципального учреждения дополнительного образования Дома детского творчества (директор Лойко И.А.) состоялся окружной круглый стол «Креативность педагога как фактор повышения качества образования в учреждении дополнительного образования детей».Организаторами выступили методисты МУДО ДДТ Куренева И.А. и Щербакова А.С., участниками стали педагогические работники учреждений дополнительного образования Георгиевского городского округа (МБУ ДО "ДЮСШ ГГО", МБУ ДО ЦДО, МУДО ДДТ). Целью мероприятия являлось обеспечение современного качества дополнительного образования, повышение профессиональной компетентности педагогических работников, создание условий для творческой самореализации и сотрудничества, распространение эффективных педагогических технологий, инновационных форм и методик работы.
Выступления участников круглого стола охватили широкий спектр заявленной темы. Были рассмотрены проблемы и организация творческого поиска педагогов, развитие креативности как условие инновационной деятельности учреждений дополнительного образования, внедрение современных педагогических технологий в процесс обучения. Педагог дополнительного образования МУДО ДДТ Солдатова А.Ф. провела мастер-класс «Новый взгляд», на которомучастниками мероприятия были изготовлены оригинальные картины на холстах.
