Последнии новости
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1555869719,
"last": 1555869719,
"now": 1555869719
},
"client": {
"forwarded": "3.95.63.218"
}
},
"registry": {
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
SELECT `data`
FROM `fvb85_session`
WHERE `session_id` = 'u7ksfiqm716g1c4kn2m4hs2eu7'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_session | const | PRIMARY | PRIMARY | 766 | const | 1 |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.18 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 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 |
SELECT `session_id`
FROM `fvb85_session`
WHERE `session_id` = 'u7ksfiqm716g1c4kn2m4hs2eu7'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 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 |
INSERT INTO `fvb85_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('u7ksfiqm716g1c4kn2m4hs2eu7', 1, '1555869719', 0, '', 0)
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| update | 0.53 ms |
| end | 0.00 ms |
| query end | 15.36 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 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 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `fvb85_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_extensions | ref | extension | extension | 82 | const | 35 | Using index condition |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.13 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.40 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 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 |
SELECT id, rules
FROM `fvb85_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_viewlevels | ALL | NULL | Индекс не используется | NULL | NULL | 5 |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 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:310 |
| 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 |
SELECT b.id
FROM fvb85_usergroups AS a
LEFT JOIN fvb85_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| 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 | 3 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.19 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 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:310 |
| 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 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM fvb85_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_extensions | ref | extension | extension | 82 | const | 89 | Using index condition; Using where; Используется filesort |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.32 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 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:348 |
| 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 |
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 fvb85_menu AS m
LEFT JOIN fvb85_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 | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 3 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | predatores.m.component_id | 1 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.12 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.08 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Так же, как вызов в строке ниже. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:374 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:488 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1070 |
| 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 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `fvb85_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.14 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 19 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 18 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Так же, как вызов в строке ниже. |
| 17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 15 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 14 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 13 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:460 |
| 9 | plgSystemK2->onAfterRoute() | Так же, как вызов в строке ниже. |
| 8 | call_user_func_array() | 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 |
UPDATE `fvb85_extensions`
SET `params` = '{\"mediaversion\":\"28782ef5834513c31a7036ea19e94b90\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.03 ms |
| Updating | 0.09 ms |
| end | 0.00 ms |
| query end | 1.09 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 14 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 13 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 12 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 11 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 10 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:460 |
| 9 | plgSystemK2->onAfterRoute() | Так же, как вызов в строке ниже. |
| 8 | call_user_func_array() | 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 |
SELECT *
FROM fvb85_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_languages | ALL | NULL | Индекс не используется | NULL | NULL | 2 | Using where; Используется filesort |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.11 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 13 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 12 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:274 |
| 11 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:55 |
| 10 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:478 |
| 9 | plgSystemK2->onAfterRoute() | Так же, как вызов в строке ниже. |
| 8 | call_user_func_array() | 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 |
SELECT id, home, template, s.params
FROM fvb85_template_styles as s
LEFT JOIN fvb85_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 | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | Индекс не используется | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.16 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 20 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
| 19 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
| 18 | Joomla\CMS\HTML\HTMLHelper::script() | Так же, как вызов в строке ниже. |
| 17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
| 14 | JHtmlJquery::framework() | Так же, как вызов в строке ниже. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:82 |
| 10 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:478 |
| 9 | plgSystemK2->onAfterRoute() | Так же, как вызов в строке ниже. |
| 8 | call_user_func_array() | 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 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `fvb85_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_assets | ALL | idx_asset_name | Индекс не используется | NULL | NULL | 82 | Using where |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.18 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 11 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 10 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 9 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 8 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 7 | Joomla\CMS\User\User->authorise() | JROOT/components/com_k2/k2.php:16 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT id
FROM fvb85_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_categories | ref | access,category,published,trash | category | 2 | const | 2 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.28 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:274 |
| 12 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/itemlist/view.html.php:29 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT id, name
FROM fvb85_k2_tags
WHERE name = 'Фрадков Михаил Ефимович'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_tags | ALL | NULL | Индекс не используется | NULL | NULL | 12244 | Using where |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 3.82 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/views/itemlist/view.html.php:282 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT id
FROM fvb85_k2_tags
WHERE name='Фрадков Михаил Ефимович'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_tags | ALL | NULL | Индекс не используется | NULL | NULL | 12244 | Using where |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.21 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 13 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/itemlist.php:228 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND i.id IN (SELECT itemID
FROM fvb85_k2_tags_xref
WHERE tagID=1281)
ORDER BY i.id DESC
LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | c | ref | PRIMARY,access,category,published,trash | published | 2 | const | 1 | Using where; Using temporary; Используется filesort |
| 1 | PRIMARY | <subquery2> | ALL | distinct_key | Индекс не используется | NULL | NULL | 3 | |
| 1 | PRIMARY | i | eq_ref | PRIMARY,access,catid,item,published,publish_down,publish_up,trash | PRIMARY | 4 | predatores.fvb85_k2_tags_xref.itemID | 1 | Using where |
| 2 | MATERIALIZED | fvb85_k2_tags_xref | ref | tagID,itemID | tagID | 4 | const | 3 |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 3.43 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Creating tmp table | 0.17 ms |
| Copying to tmp table | 0.98 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.50 ms |
| end | 0.01 ms |
| removing tmp table | 0.05 ms |
| end | 0.00 ms |
| removing tmp table | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:360 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:387 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT COUNT(*)
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
LEFT JOIN fvb85_k2_tags_xref tags_xref
ON tags_xref.itemID = i.id
LEFT JOIN fvb85_k2_tags tags
ON tags.id = tags_xref.tagID
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND (tags.name) = 'Фрадков Михаил Ефимович'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,access,category,published,trash | category | 2 | const | 2 | Using where; Using index |
| 1 | SIMPLE | i | ref | PRIMARY,access,catid,item,published,publish_down,publish_up,trash | catid | 4 | predatores.c.id | 628 | Using index condition; Using where |
| 1 | SIMPLE | tags_xref | ref | tagID,itemID | itemID | 4 | predatores.i.id | 2 | |
| 1 | SIMPLE | tags | eq_ref | PRIMARY | PRIMARY | 4 | predatores.tags_xref.tagID | 1 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 185.54 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 13 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/itemlist.php:598 |
| 12 | K2ModelItemlist->getTotal() | JROOT/components/com_k2/views/itemlist/view.html.php:415 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SHOW FULL COLUMNS
FROM `fvb85_k2_categories`
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.13 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| closing tables | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.04 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 15 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 14 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:36 |
| 13 | TableK2Category->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 12 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/views/itemlist/view.html.php:460 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT *
FROM fvb85_k2_categories
WHERE id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 16 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 15 | K2ModelItem->prepareItem() | Так же, как вызов в строке ниже. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:464 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT COUNT(*)
FROM fvb85_k2_comments
WHERE itemID=1357
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_comments | ref | countComments,itemID,latestComments,published | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.23 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 15 | K2ModelItem->prepareItem() | Так же, как вызов в строке ниже. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:464 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
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
FROM fvb85_fields AS a
LEFT JOIN `fvb85_languages` AS l
ON l.lang_code = a.language
LEFT JOIN fvb85_users AS uc
ON uc.id=a.checked_out
LEFT JOIN fvb85_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN fvb85_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN fvb85_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `fvb85_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (1,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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 | predatores.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | predatores.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | predatores.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | predatores.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | predatores.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | predatores.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.21 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 16 | PlgSystemFields->onContentPrepare() | Так же, как вызов в строке ниже. |
| 15 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:738 |
| 12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:473 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT COUNT(*)
FROM fvb85_k2_comments
WHERE itemID=1297
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_comments | ref | countComments,itemID,latestComments,published | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 15 | K2ModelItem->prepareItem() | Так же, как вызов в строке ниже. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:464 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT COUNT(*)
FROM fvb85_k2_comments
WHERE itemID=1015
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | fvb85_k2_comments | ref | countComments,itemID,latestComments,published | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 15 | K2ModelItem->prepareItem() | Так же, как вызов в строке ниже. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:464 |
| 11 | K2ViewItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:50 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.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 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fvb85_modules AS m
LEFT JOIN fvb85_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fvb85_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 <= '2019-04-21 18:01:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-04-21 18:01:59')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 126 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 | 14 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | predatores.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | predatores.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.21 ms |
| Sending data | 0.37 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | Так же, как вызов в строке ниже. |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
| 10 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
| 9 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 8 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND i.featured = 1
ORDER BY i.id DESC
LIMIT 0, 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,access,category,published,trash | published | 2 | const | 1 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | i | ref | access,catid,featured,item,published,publish_down,publish_up,trash | catid | 4 | predatores.c.id | 628 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 3.27 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Creating tmp table | 0.23 ms |
| Copying to tmp table | 286.08 ms |
| Sorting result | 2.29 ms |
| Sending data | 0.28 ms |
| end | 0.01 ms |
| removing tmp table | 1.99 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_content/helper.php:286 |
| 11 | modK2ContentHelper::getItems() | JROOT/modules/mod_k2_content/mod_k2_content.php:70 |
| 10 | include JROOT/modules/mod_k2_content/mod_k2_content.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT i.id
FROM fvb85_k2_items as i
LEFT JOIN fvb85_k2_categories c
ON c.id = i.catid
WHERE i.published=1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND i.trash=0
AND i.access IN(1,1,5)
AND c.published=1
AND c.trash=0
AND c.access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,access,category,published,trash | category | 2 | const | 2 | Using where; Using index |
| 1 | SIMPLE | i | ref | access,catid,item,published,publish_down,publish_up,trash | catid | 4 | predatores.c.id | 628 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 2.79 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 73.42 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 12 | JDatabaseDriver->loadColumn() | JROOT/modules/mod_k2_tools/helper.php:320 |
| 11 | modK2ToolsHelper::tagCloud() | JROOT/modules/mod_k2_tools/mod_k2_tools.php:91 |
| 10 | include JROOT/modules/mod_k2_tools/mod_k2_tools.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT tag.name, tag.id
FROM fvb85_k2_tags as tag
LEFT JOIN fvb85_k2_tags_xref AS xref
ON xref.tagID = tag.id
WHERE xref.itemID IN (588,589,590,591,592,593,594,600,609,613,615,618,620,625,630,633,636,639,640,642,643,645,646,647,650,651,654,656,657,658,659,662,663,664,666,667,669,670,671,674,675,676,677,678,680,681,682,685,691,692,695,696,698,699,702,703,706,708,711,715,719,729,731,733,740,746,749,750,753,754,756,762,765,773,775,777,791,799,800,801,806,811,812,813,817,823,824,826,834,866,867,873,877,879,880,881,882,884,886,895,911,913,915,917,920,922,928,930,932,933,934,935,942,943,944,945,947,948,949,950,952,954,955,956,958,960,963,970,972,976,977,978,979,982,992,993,1001,1003,1004,1005,1007,1008,1009,1010,1011,1015,1020,1021,1028,1031,1032,1034,1038,1052,1054,1060,1064,1067,1070,1075,1077,1079,1080,1081,1083,1084,1086,1088,1090,1091,1092,1093,1095,1096,1098,1099,1104,1105,1107,1109,1111,1113,1114,1116,1118,1119,1122,1123,1125,1126,1129,1130,1131,1132,1133,1134,1136,1137,1138,1141,1144,1145,1146,1147,1148,1149,1151,1153,1154,1155,1157,1158,1159,1162,1163,1164,1167,1170,1172,1175,1177,1178,1179,1181,1182,1183,1185,1186,1188,1189,1190,1191,1193,1195,1197,1198,1199,1201,1204,1205,1211,1218,1234,1245,1247,1248,1249,1250,1251,1252,1256,1260,1262,1266,1278,1287,1290,1294,1297,1304,1305,1310,1316,1319,1322,1324,1325,1327,1329,1330,1332,1336,1338,1340,1341,1342,1344,1345,1346,1347,1348,1349,1350,1351,1353,1356,1357,1361,1363,1365,1366,1367,1369,1372,1373,1375,1376,1377,1378,1380,1381,1382,1383,1384,1385,1386,1388,1389,1391,1392,1394,1398,1399,1400,1402,1404,1407,1408,1409,1410,1411,1412,1413,1414,1416,1419,1420,1432,1441,1442,1444,1445,1449,1450,1453,1455,1456,1458,1460,1473,1499,1510,1519,1525,1527,1538,1539,1540,1542,1543,1544,1545,1546,1547,1548,1551,1552,1553,1556,1557,1558,1559,1560,1563,1565,1566,1567,1570,1571,1573,1577,1578,1585,1602,1603,1604,1630,1633,1634,1636,1637,1638,1639,1644,1654,1656,1671,1677,1682,1686,1687,1693,1697,1699,1702,1703,1705,1707,1709,1717,1718,1722,1725,1731,1736,1742,1747,1749,1752,1755,1757,1758,1760,1761,1762,1764,1765,1766,1767,1768,1769,1770,1771,1772,1774,1776,1778,1779,1781,1785,1790,1791,1792,1796,1801,1807,1814,1817,1820,1822,1828,1833,1834,1842,1844,1845,1846,1847,1850,1851,1854,1857,1858,1865,1870,1871,1873,1884,1886,1893,1894,1895,1896,1897,1901,1902,1914,1915,1918,1921,1922,1930,1933,1935,1941,1943,1945,1949,1950,1952,1955,1956,1959,1968,1970,1983,1992,2002,2011,2012,2013,2016,2017,2021,2030,2032,2036,2038,2039,2040,2041,2042,2044,2046,2052,2058,2060,2062,2063,2066,2068,2069,2071,2072,2074,2076,2079,2081,2084,2085,2087,2088,2093,2094,2095,2097,2098,2099,2100,2101,2103,2104,2105,2107,2108,2109,2111,2112,2114,2115,2116,2119,2120,2122,2124,2125,2126,2127,2128,2130,2131,2133,2134,2135,2136,2137,2140,2142,2143,2144,2145,2146,2152,2153,2155,2156,2159,2161,2165,2168,2169,2172,2173,2175,2176,2178,2182,2185,2187,2194,2196,2197,2198,2199,2201,2202,2205,2206,2207,2208,2209,2210,2211,2212,2213,2215,2216,2217,2218,2219,2220,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2240,2241,2242,2243,2244,2246,2247,2248,2249,2251,2252,2253,2255,2256,2257,2258,2259,2260,2261,2263,2264,2266,2267,2268,2270,2271,2273,2274,2275,2276,2277,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2291,2292,2293,2295,2297,2299,2300,2301,2302,2303,2304,2305,2307,2308,2309,2310,2311,2312,2313,2314,2316,2318,2319,2320,2321,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2335,2337,2339,2342,2343,2344,2345,2346,2347,2349,2350,2351,2352,2354,2355,2356,2357,2358,2359,2360,2361,2363,2364,2367,2368,2369,2370,2371,2372,2374,2376,2377,2378,2380,2381,2382,2385,2386,2387,2388,2390,2391,2392,2393,2394,2396,2397,2399,2400,2402,2403,2404,2406,2407,2408,2409,2411,2412,2414,2415,2416,2418,2420,2421,2422,2423,2425,2427,2428,2431,2433,2434,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2445,2447,2449,2451,2453,2454,2456,2457,2458,2460,2462,2463,2465,2466,2468,2469,2470,2471,2472,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2487,2489,2490,2491,2492,2495,2496,2498,2500,2501,2503,2506,2510,2511,2512,2513,2516,2519,2520,2521,2522,2527,2528,2530,2531,2532,2533,2535,2537,2541,2545,2548,2549,2552,2553,2554,2555,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2615,2616,2617,2623,2624,2626,2627,2628,2629,2633,2634,2636,2638,2639,2647,2649,2650,2651,2652,2654,2655,2657,2658,2659,2662,2667,2669,2674,2683,2687,2688,2692,2696,2699,2700,2701,2702,2705,2712,2715,2717,2718,2720,2723,2729,2732,2736,2739,2740,2744,2745,2746,2749,2752,2754,2756,2759,2762,2763,2764,2765,2766,2767,2772,2773,2774,2775,2777,2778,2779,2780,2782,2783,2784,2785,2788,2789,2790,2793,2794,2796,2797,2798,2800,2802,2803,2805,2806,2807,2810,2815,2819,2823,2824,2825,2830,2834,2835,2836,2838,2839,2841,2842,2849,2851,2852,2854,2861,2873,2876,2877,2880,2883,2886,2895,2897,2904,2906,2907,2909,2911,2912,2913,2915,2917,2918,2919,2920,2921,2923,2925,2926,2928,2930,2932,2935,2936,2937,2938,2939,2940,2941,2943,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2958,2962,2963,2964,2967,2968,2973,2976,2981,2982,2983,2985,2993,2995,2998,3004,3005,3006,3007,3008,3012,3014,3019,3022,3025,3028,3029,3034,3036,3038,3039,3059,3062,3072,3091,3094,3099,3101,3102,3103,3106,3107,3108,3109,3110,3112,3115,3127,3129,3136,3139,3142,3144,3153,3155,3160,3162,3164,3167,3169,3170,3174,3175,3176,3181,3183,3187,3199,3200,3214,3226,3230,3233,3234,3242,3243,3244,3245,3246,3248,3262,3267,3276,3278,3289,3295,3299,3300,3301,3303,3304,3305,3306,3307,3308,3309,3310,3311,3312,3313,3314,3315,3318,3319,3323,3325,3327,3329,3330,3331,3333,3336,3338,3342,3343,3348,3351,3353,3356,3368,3370,3372,3373,3377,3384,3385,3389,3397,3398,3409,3410,3411,3414,3415,3417,3418,3419,3421,3432,3434,3438,3446,3449,3453,3455,3457,3458,3461,3477,3478,3492,3493,3494,3495,3496,3498,3505,3506,3507,3508,3509,3510,3511,3513,3514,3515,3517,3518,3521,3523,3524,3525,3526,3527,3528,3529,3532,3533,3534,3535,3536,3538,3539,3541,3543,3544,3545,3546,3548,3550,3552,3554,3556,3558,3559,3561,3562,3563,3564,3565,3566,3568,3569,3570,3571,3573,3574,3575,3577,3580,3581,3583,3584,3585,3587,3588,3589,3590,3592,3593,3594,3596,3597,3599,3600,3601,3603,3604,3605,3607,3608,3609,3610,3612,3613,3614,3615,3616,3617,3618,3620,3621,3623,3624,3625,3626,3627,3628,3629,3633,3634,3635,3637,3639,3640,3644,3645,3646,3647,3650,3651,3652,3654,3655,3656,3657,3658,3661,3663,3666,3668,3669,3671,3679,3681,3683,3684,3686,3689,3692,3694,3697,3704,3709,3711,3719,3720,3721,3724,3725,3726,3732,3738,3741,3742,3743,3745,3758,3762,3765,3767,3770,3771,3772,3773,3775,3776,3777,3778,3779,3781,3783,3784,3786,3787,3789,3790,3791,3792,3794,3795,3796,3797,3798,3801,3802,3804,3805,3806,3807,3809,3811,3812,3813,3815,3817,3819,3822,3825,3826,3828,3832,3833,3836,3838,3840,3842,3844,3845,3849,3850,3851,3852,3853,3854,3855,3858,3860,3861,3862,3864,3865,3866,3868,3870,3872,3873,3874,3875,3877,3881,3884,3886,3889,3890,3891,3893,3894,3895,3897,3899,3900,3902,3903,3904,3905,3907,3909,3911,3912,3914,3915,3916,3917,3919,3920,3921,3922,3923,3925,3929,3932,3933,3934,3937,3940,3943,3955,3956,3964,3965,3969,3972,3975,3983,3984,3989,3996,4000,4001,4004,4008,4009,4014,4017,4022,4023,4025,4026,4027,4028,4044,4063,4066,4068,4069,4070,4074,4075,4077,4078,4079,4081,4082,4083,4084,4089,4092,4096,4097,4098,4101,4113,4122,4124,4125,4126,4129,4130,4132,4134,4136,4138,4150,4151,4154,4155,4160,4162,4165,4167,4168,4172,4176,4181,4187,4195,4196,4208,4217,4226,4227,4236,4243,4247,4248,4249,4250,4251,4253,4254,4255,4259,4261,4267,4273,4290,4293,4294,4296,4297,4299,4301,4302,4305,4311,4313,4321,4322,4327,4329,4331,4333,4334,4337,4342,4345,4346,4348,4356,4357,4360,4361,4364,4368,4369,4377,4378,4382,4383,4384,4387,4390,4391,4392,4395,4396,4398,4399,4401,4407,4412,4413,4415,4416,4418,4420,4421,4423,4425,4427,4429,4435,4437,4438,4439,4440,4441,4445,4448,4449,4458,4459,4460,4469,4475,4476,4477,4478,4481,4486,4491,4496,4509,4515,4522,4526,4527,4528,4529,4532,4541,4552,4555,4557,4560,4561,4567,4569,4571,4572,4573,4575,4578,4580,4583,4585,4586,4589,4590,4592,4594,4595,4596,4597,4599,4601,4602,4603,4607,4608,4614,4615,4616,4617,4625,4628,4635,4653,4663,4664,4669,4671,4673,4675,4677,4680,4681,4682,4684,4685,4693,4694,4697,4698,4699,4700,4701,4705,4709,4710,4714,4717,4718,4721,4724,4727,4730,4731,4732,4733,4734,4736,4737,4738,4740,4742,4744,4745,4746,4750,4755,4767,4769,4776,4777,4778,4779,4781,4783,4794,4799,4800,4802,4804,4817,4823,4825,4830,4831,4856,4857,4861,4863,4864,4865,4866,4871,4872,4873,4874,4878,4879,4882,4884,4885,4886,4887,4888,4892,4893,4897,4898,4899,4902,4904,4908,4910,4916,4917,4918,4921,4924,4926,4928,4930,4931,4933,4935,4937,4939,4941,4944,4952,4953,4954,4956,4957,4958,4967,4968,4970,4971,4972,4976,4979,4982,4990,4992,4999,5001,5003,5006,5007,5008,5010,5014,5017,5019,5020,5023,5025,5026,5028,5030,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5043,5044,5048,5049,5050,5051,5054,5056,5059,5072,5092,5101,5102,5105,5108,5109,5123,5145,5153,5167,5168,5170,5172,5174,5176,5177,5178,5180,5181,5183,5190,5191,5192,5193,5195,5196,5203,5205,5206,5209,5211,5212,5213,5214,5216,5218,5232,5235,5239,5242,5250,5252,5253,5254,5255,5256,5257,5259,5262,5266,5271,5274,5276,5278,5279,5283,5286,5290,5295,5298,5301,5304,5308,5311,5312,5313,5314,5315,5316,5317,5318,5319,5321,5322,5324,5325,5326,5331,5336,5338,5343,5344,5345,5346,5347,5348,5349,5351,5352,5353,5354,5356,5358,5359,5360,5361,5362,5364,5366,5368,5369,5371,5372,5373,5374,5375,5376,5377,5378,5380,5381,5382,5383,5384,5385,5386,5388,5389,5390,5391,5392,5394,5396,5398,5399,5400,5401,5402,5404,5405,5407,5409,5411,5413,5415,5416,5418,5419,5420,5421,5423,5424,5425,5426,5428,5429,5430,5432,5433,5434,5435,5436,5437,5438,5439,5440,5441,5442,5443,5445,5446,5449,5450,5451,5452,5453,5455,5456,5457,5458,5460,5462,5463,5464,5465,5467,5468,5469,5470,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5482,5483,5485,5486,5488,5489,5491,5492,5493,5494,5495,5497,5498,5499,5500,5501,5504,5505,5506,5508,5511,5513,5514,5515,5517,5519,5520,5521,5523,5524,5526,5528,5529,5530,5531,5533,5535,5538,5541,5542,5543,5544,5546,5548,5551,5552,5553,5556,5557,5561,5567,5572,5574,5577,5583,5589,5593,5598,5602,5606,5611,5613,5617,5622,5623,5625,5627,5629,5631,5632,5633,5634,5635,5637,5642,5644,5645,5650,5653,5657,5658,5659,5662,5663,5664,5667,5670,5672,5675,5676,5677,5678,5680,5681,5684,5685,5689,5691,5693,5694,5696,5698,5699,5700,5701,5703,5705,5706,5708,5709,5711,5712,5713,5716,5718,5719,5721,5724,5725,5726,5728,5729,5730,5731,5732,5734,5736,5737,5738,5740,5741,5743,5744,5745,5746,5747,5749,5750,5751,5752,5753,5754,5755,5757,5758,5759,5760,5761,5762,5763,5765,5766,5767,5768,5769,5770,5771,5772,5773,5774,5775,5776,5777,5778,5779,5780,5781,5782,5783,5784,5785,5786,5787,5788,5789,5790,5792,5793,5794,5795,5796,5797,5798,5799,5800,5801,5803,5804,5805,5806,5807,5808,5810,5811,5812,5813,5814,5815,5816,5817,5818,5819,5820,5821,5822,5823,5824,5826,5827,5828,5829,5830,5831,5832,5833,5834,5835,5836,5837,5838,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5851,5852,5853,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5871,5872,5874,5875,5876,5877,5878,5879,5880,5881,5883,5884,5885,5887,5888,5889,5890,5891,5892,5894,5895,5896,5898,5899,5900,5901,5902,5903,5904,5905,5906,5907,5908,5910,5913,5914,5916,5918,5919,5920,5922,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5935,5936,5937,5938,5939,5940,5942,5943,5945,5946,5947,5949,5950,5951,5952,5953,5955,5956,5958,5959,5960,5961,5963,5964,5966,5967,5968,5969,5970,5971,5973,5974,5975,5977,5978,5979,5981,5983,5984,5986,5987,5988,5989,5990,5991,5992,5993,5995,5996,5998,5999,6000,6001,6003,6004,6005,6006,6007,6009,6010,6011,6013,6015,6016,6017,6018,6019,6022,6026,6027,6030,6032,6033,6034,6035,6037,6038,6040,6041,6042,6043,6044,6045,6046,6047,6048,6049,6050,6051,6052,6053,6054,6055,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6071,6072,6073,6074,6075,6076,6077,6078,6079,6080,6081,6082,6083,6084,6085,6086,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6100,6102,6104,6105,6107,6108,6109,6111,6112,6114,6116,6117,6120,6121,6122,6123,6124,6125,6126,6127,6129,6130,6132,6133,6134,6136,6138,6140,6145,6146,6149,6151,6152,6153,6156,6160,6162,6165,6168,6171,6172,6173,6174,6175,6176,6178,6181,6183,6184,6185,6189,6190,6191,6192,6193,6195,6196,6200,6201,6202,6203,6206,6209,6212,6213,6217,6218,6223,6224,6225,6229,6233,6240,6241,6247,6250,6254,6256,6260,6263,6269,6270,6273,6277,6279,6280,6282,6283,6284,6286,6287,6289,6290,6291,6292,6296,6300,6301,6302,6304,6305,6307,6308,6309,6310,6311,6312,6314,6315,6316,6317,6319,6321,6322,6323,6324,6326,6328,6329,6330,6331,6332,6333,6335,6339,6342,6343,6345,6346,6347,6348,6349,6353,6354,6355,6357,6358,6360,6361,6364,6366,6367,6369,6370,6372,6373,6374,6376,6377,6378,6379,6380,6381,6383,6384,6387,6389,6393,6394,6395,6397,6401,6404,6407,6409,6411,6412,6413,6414,6415,6416,6417,6418,6420,6421,6423,6424,6425,6426,6428,6429,6430,6434,6435,6436,6437,6438,6440,6441,6442,6443,6445,6447,6448,6449,6450,6451,6452,6453,6454,6455,6456,6457,6458,6459,6460,6461,6463,6464,6465,6466,6467,6468,6470,6471,6472,6473,6475,6476,6478,6479,6480,6481,6482,6483,6484,6485,6486,6487,6488,6489,6490,6492,6493,6495,6496,6497,6499,6500,6501,6502,6503,6505,6506,6509,6510,6511,6515,6516,6517,6519,6525,6526,6528,6531,6533,6537,6538,6540,6542,6548,6550,6554,6555,6556,6558,6572,6576,6579,6580,6581,6582,6583,6585,6589,6595,6597,6599,6601,6604,6620,6621,6629,6634,6638,6639,6645,6646,6648,6649,6650,6652,6653,6654,6655,6656,6657,6658,6659,6660,6661,6662,6663,6664,6665,6666,6667,6670,6671,6673,6676,6677,6681,6682,6683,6684,6685,6686,6687,6696,6698,6699,6701,6706,6707,6708,6709,6710,6711,6712,6715,6719,6720,6721,6723,6724,6725,6726,6727,6728,6729,6730,6731,6732,6733,6734,6735,6736,6737,6739,6740,6741,6742,6743,6744,6745,6747,6748,6750,6751,6752,6753,6754,6755,6757,6758,6759,6760,6761,6762,6763,6764,6765,6766,6767,6768,6769,6770,6771,6772,6774,6775,6776,6777,6778,6779,6780,6781,6783,6784,6785,6786,6788,6789,6790,6791,6792,6793,6794,6795,6796,6797,6798,6799,6801,6802,6803,6804,6805,6806,6807,6808,6809,6811,6812,6813,6814,6816,6817,6818,6819,6820,6821,6822,6823,6824,6825,6826,6827,6828,6829,6830,6831,6832,6833,6834,6835,6836,6838,6839,6840,6841,6842,6843,6844,6845,6846,6847,6848,6849,6851,6852,6853,6854,6856,6857,6858,6859,6861,6864,6865,6866,6867,6869,6870,6871,6872,6873,6874,6875,6876,6877,6880,6881,6882,6883,6884,6885,6887,6888,6891,6893,6894,6895,6897,6898,6899,6900,6903,6904,6906,6907,6909,6910,6911,6914,6915,6916,6917,6918,6919,6921,6922,6925,6926,6927,6928,6931,6932,6934,6935,6938,6939,6941,6942,6944,6945,6946,6949,6950,6954,6956,6958,6959,6960,6962,6963,6964,6965,6966,6967,6968,6971,6972,6974,6976,6978,6980,6985,6989,6990,6991,6994,6996,6998,6999,7001,7002,7003,7006,7010,7016,7019,7020,7021,7025,7026,7027,7029,7031,7032,7033,7036,7037,7038,7039,7040,7041,7042,7044,7045,7046,7047,7048,7049,7050,7051,7052,7053,7054,7055,7056,7057,7058,7059,7060,7061,7062,7063,7064,7065,7066,7067,7069,7070,7071,7072,7073,7074,7075,7076,7077,7078,7079,7080,7081,7082,7083,7084,7085,7086,7087,7088,7089,7091,7092,7093,7094,7096,7097,7098,7101,7102,7103,7104,7105,7106,7107,7108,7109,7110,7111,7113,7114,7117,7119,7120,7122,7123,7124,7125,7126,7127,7128,7130,7131,7132,7133,7134,7136,7137,7138,7139,7141,7142,7143,7145,7147,7148,7149,7151,7152,7153,7154,7155,7156,7157,7158,7160,7161,7162,7163,7164,7165,7167,7168,7170,7171,7173,7174,7175,7177,7178,7179,7180,7181,7182,7183,7185,7187,7188,7189,7191,7192,7193,7194,7195,7196,7197,7198,7199,7201,7202,7203,7204,7205,7206,7208,7209,7210,7211,7212,7213,7214,7215,7217,7218,7219,7220,7221,7223,7224,7225,7226,7227,7228,7229,7230,7231,7232,7234,7235,7236,7238,7239,7240,7241,7242,7243,7244,7245,7246,7247,7248,7249,7250,7251,7252,7253,7254,7255,7256,7257,7259,7260,7261,7263,7264,7268,7269,7270,7271,7273,7274,7275,7277,7279,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7292,7293,7294,7296,7298,7300,7301,7303,7304,7305,7306,7307,7308,7309,7311,7313,7315,7317,7319,7320,7321,7322,7325,7327,7330,7332,7334,7337,7340,7342,7344,7345,7346,7347,7349,7351,7352,7354,7357,7360,7362,7366,7369,7372,7373,7376,7377,7379,7382,7384,7386,7388,7389,7390,7392,7395,7398,7400,7401,7403,7405,7406,7407,7409,7412,7413,7417,7420,7423,7424,7425,7426,7427,7428,7429,7430,7431,7433,7434,7435,7436,7437,7438,7439,7441,7442,7443,7444,7446,7447,7448,7450,7451,7452,7453,7454,7455,7456,7457,7459,7460,7462,7463,7465,7466,7467,7469,7470,7471,7473,7474,7475,7476,7477,7479,7480,7481,7483,7484,7486,7487,7488,7489,7490,7491,7492,7493,7495,7497,7498,7499,7501,7502,7503,7504,7506,7507,7508,7509,7510,7511,7513,7514,7516,7517,7518,7519,7520,7521,7522,7523,7524,7525,7526,7527,7528,7529,7531,7532,7533,7535,7536,7537,7538,7539,7541,7542,7543,7545,7546,7547,7548,7549,7550,7551,7552,7553,7554,7556,7557,7558,7560,7561,7562,7564,7565,7566,7567,7568,7569,7570,7571,7572,7573,7574,7575,7576,7577,7578,7579,7580,7581,7583,7584,7585,7586,7587,7589,7590,7591,7592,7593,7594,7595,7596,7597,7598,7599,7600,7601,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7617,7619,7620,7621,7622,7624,7625,7626,7627,7628,7629,7630,7631,7632,7633,7634,7635,7636,7637,7638,7639,7640,7641,7642,7643,7644,7645,7646,7647,7648,7649,7650,7651,7653,7654,7655,7656,7658,7659,7662,7663,7664,7665,7667,7669,7670,7671,7672,7673,7674,7675,7676,7677,7679,7680,7681,7683,7684,7685,7688,7690,7693,7695,7696,7697,7698,7701,7703,7704,7705,7706,7709,7710,7711,7714,7716,7717,7720,7721,7724,7725,7726,7727,7728,7730,7731,7732,7733,7734,7735,7736,7737,7741,7743,7746,7749,7750,7751,7752,7753,7755,7756,7757,7758,7759,7761,7762,7763,7764,7766,7767,7768,7770,7772,7773,7774,7775,7777,7778,7779,7781,7784,7786,7787,7791,7792,7793,7795,7797,7798,7799,7802,7803,7804,7807,7808,7810,7812,7818,7820,7826,7827,7833,7835,7837,7838,7839,7840,7841,7846,7849,7850,7853,7856,7857,7859,7862,7863,7864,7865,7866,7867,7868,7870,7871,7874,7876,7878,7880,7884,7885,7887,7888,7890,7891,7893,7895,7896,7898,7900,7902,7905,7911,7915,7917,7919,7921,7924,7925,7927,7932,7936,7940,7942,7943,7946,7947,7950,7954,7956,7958,7960,7962,7964,7966,7967,7969,7970,7971,7972,7973,7974,7975,7977,7978,7979,7981,7982,7983,7984,7985,7986,7987,7988,7989,7991,7993,7994,7995,7996,7997,7998,7999,8000,8002,8003,8004,8005,8006,8007,8008,8010,8011,8012,8013,8014,8015,8016,8017,8019,8020,8021,8023,8024,8025,8026,8027,8028,8029,8030,8031,8032,8033,8034,8035,8036,8037,8038,8039,8041,8042,8043,8044,8045,8046,8047,8048,8049,8050,8052,8053,8054,8055,8056,8058,8059,8060,8061,8062,8063,8064,8065,8066,8067,8068,8070,8071,8072,8073,8074,8075,8076,8077,8078,8079,8081,8082,8083,8084,8085,8086,8087,8088,8089,8090,8092,8093,8095,8097,8098,8099,8100,8102,8103,8104,8106,8107,8108,8109,8110,8111,8113,8114,8116,8118,8119,8120,8121,8122,8123,8124,8125,8126,8128,8130,8131,8132,8133,8134,8135,8136,8137,8139,8140,8142,8143,8145,8148,8149,8150,8151,8152,8154,8156,8157,8160,8162,8164,8165,8167,8168,8169,8170,8171,8173,8174,8176,8177,8178,8179,8180,8181,8182,8183,8185,8186,8187,8188,8189,8191,8192,8193,8194,8195,8196,8197,8198,8199,8201,8202,8203,8204,8205,8207,8208,8210,8211,8212,8213,8215,8216,8217,8218,8219,8221,8222,8224,8225,8226,8227,8229,8230,8231,8233,8234,8235,8236,8237,8238,8239,8241,8242,8243,8244,8245,8246,8247,8248,8249,8250,8252,8253,8254,8256,8257,8258,8259,8260,8261,8262,8263,8264,8266,8267,8268,8270,8271,8272,8274,8275,8276,8277,8278,8279,8280,8281,8283,8284,8285,8287,8288,8290,8291,8292,8293,8295,8296,8298,8299,8300,8301,8303,8304,8305,8307,8308,8309,8310,8311,8312,8313,8314,8316,8317,8318,8319,8321,8322,8323,8324,8325,8326,8327,8328,8330,8331,8333,8334,8335,8336,8337,8338,8339,8340,8341,8342,8343,8344,8345,8346,8347,8349,8350,8351,8352,8353,8354,8355,8356,8357,8358,8359,8360,8361,8362,8363,8364,8365,8366,8367,8368,8369,8370,8371,8372,8373,8374,8375,8376,8377,8378,8379,8380,8381,8382,8383,8384,8385,8386,8387,8388,8389,8390,8391,8392,8393,8394,8395,8396,8397,8398,8399,8400,8401,8402,8403,8404,8405,8406,8408,8409,8410,8411,8412,8413,8414,8415,8416,8417,8419,8420,8422,8423,8425,8427,8429,8430,8431,8432,8434,8435,8437,8438,8439,8441,8442,8444,8445,8447,8448,8450,8452,8454,8456,8457,8460,8461,8463,8464,8466,8469,8470,8471,8473,8474,8476,8477,8480,8481,8483,8484,8487,8488,8491,8493,8494,8497,8498,8500,8501,8502,8503,8504,8505,8508,8510,8512,8513,8515,8516,8519,8522,8523,8525,8526,8527,8529,8530,8531,8532,8534,8535,8536,8537,8538,8540,8541,8542,8543,8544,8545,8546,8547,8548,8549,8550,8551,8553,8554,8555,8556,8557,8558,8559,8560,8561,8562,8563,8564,8565,8566,8567,8568,8569,8570,8571,8572,8573,8574,8575,8576,8578,8579,8580,8581,8583,8584,8585,8586,8587,8588,8589,8590,8591,8592,8593,8594,8595,8596,8597,8598,8599,8600,8601,8602,8603,8604,8605,8606,8607,8608,8610,8611,8612,8613,8614,8615,8616,8617,8618,8619,8620,8622,8623,8624,8625,8626,8627,8628,8629,8630,8631,8632,8633,8634,8636,8637,8638,8639,8640,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8655,8656,8658,8659,8660,8661,8662,8663,8664,8665,8666,8667,8668,8669,8671,8672,8673,8674,8675,8677,8678,8679,8680,8681,8682,8684,8685,8686,8687,8688,8690,8691,8692,8693,8694,8695,8696,8697,8698,8699,8701,8703,8704,8705,8706,8708,8709,8710,8711,8712,8713,8715,8716,8717,8719,8720,8721,8724,8725,8726,8727,8728,8729,8730,8732,8734,8735,8736,8737,8738,8739,8741,8743,8744,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754,8755,8757,8758,8759,8760,8761,8762,8763,8764,8765,8766,8767,8769,8770,8771,8773,8774,8775,8776,8777,8778,8779,8780,8781,8782,8783,8785,8786,8788,8789,8790,8791,8792,8793,8795,8796,8797,8798,8799,8800,8801,8803,8804,8806,8807,8809,8810,8811,8812,8814,8815,8816,8817,8818,8819,8820,8822,8823,8824,8825,8826,8827,8828,8829,8831,8832,8834,8835,8836,8837,8838,8839,8840,8841,8842,8843,8844,8845,8846,8847,8848,8849,8850,8851,8853,8854,8856,8857,8858,8859,8861,8862,8863,8864,8865,8866,8867,8868,8869,8870,8871,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8884,8885,8887,8888,8889,8890,8891,8892,8893,8894,8895,8896,8897,8898,8900,8901,8902,8903,8904,8905,8906,8907,8908,8910,8911,8912,8913,8914,8915,8916,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8928,8929,8930,8932,8933,8934,8935,8936,8937,8938,8939,8940,8941,8942,8943,8944,8946,8948,8949,8951,8953,8954,8955,8958,8960,8961,8965,8968,8970,8971,8972,8973,8975,8976,8983,8984,8988,8989,8992,8993,8994,8995,8999,9000,9002,9006,9007,9009,9010,9015,9016,9017,9018,9019,9022,9024,9025,9026,9027,9028,9033,9034,9036,9041,9043,9045,9046,9049,9052,9054,9055,9056,9058,9059,9060,9061,9063,9065,9070,9071,9076,9077,9078,9079,9080,9085,9086,9088,9090,9091,9096,9099,9101,9104,9107,9111,9113,9114,9115,9116,9120,9121,9122,9123,9129,9131,9135,9136,9139,9143,9144,9145,9147,9153,9155,9156,9159,9161,9162,9164,9167,9171,9173,9174,9175,9176,9178,9180,9182,9184,9185,9187,9189,9192,9194,9200,9201,9202,9206,9207,9212,9213,9218,9221,9224,9228,9229,9232,9234,9235,9237,9238,9239,9243,9245,9247,9250,9251,9252,9256,9257,9260,9262,9264,9266,9268,9270,9273,9274,9276,9278,9279,9286,9287,9289,9291,9296,9299,9304,9310,9316,9317,9318,9319,9322,9324,9325,9327,9328,9332,9334,9336,9337,9338,9339,9341,9342,9343,9344,9346,9347,9348,9349,9350,9353,9354,9355,9357,9358,9359,9360,9361,9362,9363,9365,9366,9367,9368,9370,9371,9372,9373,9374,9375,9376,9377,9378,9379,9381,9382,9383,9385,9386,9387,9388,9389,9390,9392,9393,9394,9395,9396,9397,9398,9399,9400,9401,9403,9404,9406,9407,9408,9410,9411,9412,9413,9414,9416,9417,9418,9419,9420,9421,9422,9423,9424,9425,9426,9427,9429,9430,9431,9432,9433,9434,9435,9436,9437,9438,9440,9441,9442,9443,9444,9445,9446,9448,9449,9450,9452,9453,9454,9455,9456,9458,9459,9460,9461,9462,9464,9465,9466,9467,9468,9469,9470,9471,9472,9473,9474,9476,9477,9478,9479,9480,9481,9482,9485,9486,9487,9488,9489,9490,9492,9493,9495,9496,9497,9499,9500,9501,9503,9505,9506,9507,9509,9510,9511,9513,9514,9516,9517,9518,9520,9521,9523,9524,9525,9526,9527,9529,9530,9532,9533,9534,9536,9537,9538,9540,9541,9543,9544,9546,9547,9549,9550,9551,9552,9554,9555,9556,9557,9559,9560,9562,9564,9565,9566,9567,9568,9569,9570,9571,9573,9574,9576,9578,9579,9582,9583,9585,9586,9589,9590,9593,9594,9597,9598,9600,9601,9603,9604,9606,9607,9609,9610,9613,9615,9616,9618,9619,9622,9623,9625,9626,9628,9629,9631,9632,9633,9634,9635,9636,9637,9638,9639,9641,9642,9643,9644,9645,9646,9647,9648,9649,9650,9651,9652,9653,9654,9656,9657,9658,9659,9660,9661,9662,9663,9664,9665,9666,9667,9668,9669,9670,9671,9672,9673,9674,9675,9676,9677,9678,9679,9680,9682,9683,9684,9685,9686,9687,9688,9689,9690,9691,9693,9694,9695,9696,9698,9699,9700,9701,9702,9703,9704,9705,9706,9708,9709,9710,9711,9712,9713,9714,9715,9716,9717,9718,9719,9720,9722,9723,9724,9726,9727,9728,9729,9730,9731,9732,9733,9734,9735,9736,9737,9738,9741,9742,9743,9744,9745,9746,9747,9748,9749,9750,9751,9752,9753,9754,9755,9756,9757,9758,9759,9760,9761,9762,9763,9764,9766,9767,9769,9771,9772,9773,9774,9775,9776,9777,9778,9779,9780,9781,9783,9784,9786,9787,9788,9789,9790,9791,9792,9793,9794,9795,9796,9798,9799,9800,9801,9802,9803,9804,9805,9806,9807,9809,9810,9812,9813,9814,9815,9816,9818,9820,9821,9822,9823,9824,9825,9827,9828,9830,9831,9832,9834,9836,9837,9838,9839,9840,9841,9842,9843,9844,9845,9847,9848,9849,9850,9851,9853,9854,9855,9856,9857,9858,9859,9860,9862,9863,9865,9866,9867,9869,9870,9871,9872,9873,9874,9875,9876,9877,9878,9879,9881,9882,9883,9884,9885,9886,9887,9888,9889,9891,9892,9895,9896,9898,9899,9900,9901,9902,9903,9905,9906,9907,9908,9911,9912,9913,9914,9915,9916,9917,9918,9921,9922,9923,9924,9925,9926,9927,9928,9929,9930,9931,9932,9933,9934,9935,9936,9938,9939,9941,9942,9943,9944,9945,9946,9947,9948,9949,9950,9951,9953,9954,9955,9956,9957,9958,9959,9960,9961,9963,9964,9965,9966,9967,9968,9969,9970,9972,9973,9974,9975,9977,9978,9979,9980,9981,9982,9983,9985,9986,9987,9988,9990,9991,9992,9994,9995,9997,9998,9999,10000,10001,10002,10003,10004,10005,10006,10007,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10024,10025,10026,10027,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10040,10041,10042,10043,10044,10045,10046,10047,10049,10050,10051,10052,10053,10055,10056,10057,10059,10060,10061,10062,10063,10065,10067,10068,10069,10071,10073,10075,10077,10082,10084,10085,10087,10088,10089,10091,10096,10097,10098,10099,10100,10102,10103,10106,10108,10110,10112,10113,10114,10115,10117,10119,10122,10123,10125,10127,10129,10132,10136,10138,10141,10142,10143,10144,10146,10149,10152,10153,10156,10160,10163,10167,10169,10170,10171,10172,10173,10174,10177,10179,10183,10184,10186,10190,10191,10193,10195,10196,10197,10199,10201,10202,10204,10205,10206,10207,10208,10210,10211,10214,10217,10220,10223,10225,10227,10230,10234,10236,10239,10242,10247,10248,10252,10254,10255,10256,10259,10260,10261,10263,10264,10266,10268,10269,10274,10276,10280,10282,10283,10289,10292,10294,10298,10300,10304,10305,10310,10312,10317,10318,10320,10323,10325,10326,10327,10331,10333,10334,10336,10340,10341,10343,10347,10348,10353,10355,10356,10357,10363,10364,10366,10369,10370,10374,10375,10376,10381,10382,10387,10389,10394,10395,10400,10401,10403,10404,10406,10408,10410,10415,10417,10420,10422,10425,10427,10430,10432,10434,10435,10436,10437,10438,10439,10440,10441,10442,10443,10444,10445,10446,10447,10449,10450,10452,10453,10454,10455,10456,10457,10458,10459,10460,10461,10462,10463,10464,10465,10466,10467,10468,10469,10470,10471,10472,10474,10475,10476,10477,10478,10479,10480,10481,10482,10483,10484,10485,10487,10488,10489,10490,10491,10492,10493,10494,10495,10496,10497,10498,10499,10500,10501,10502,10503,10504,10506,10507,10508,10509,10510,10511,10512,10513,10515,10516,10517,10518,10520,10521,10522,10524,10525,10526,10527,10529,10530,10531,10532,10533,10534,10535,10536,10537,10538,10539,10540,10541,10542,10543,10545,10546,10547,10548,10549,10550,10551,10552,10553,10554,10555,10569,10570,10571,10572,10576,10580,10581,10583,10584,10586,10588,10592,10593,10595,10599,10600,10602,10605,10609,10610,10616,10617,10621,10623,10625,10626,10627,10631,10632,10633,10636,10638,10642,10644,10645,10649,10652,10653,10654,10655,10656,10657,10661,10662,10663,10664,10665,10666,10676,10680,10681,10682,10683,10685,10688,10689,10690,10691,10694,10695,10723,10724,10728,10733,10736,10737,10739,10740,10741,10742,10743,10746,10748,10749,10750,10751,10753,10756,10757,10760,10766,10769,10776,10780,10785,10791,10796,10799,10800,10802,10805,10810,10811,10815,10816,10820,10825,10827,10828,10833,10835,10839,10840,10841,10842,10843,10844,10846,10847,10850,10853,10855,10857,10858,10859,10860,10861,10863,10865,10867,10870,10871,10874,10876,10878,10879,10882,10883,10884,10886,10888,10889,10891,10894,10896,10899,10904,10905,10912,10913,10915,10916,10917,10918,10921,10922,10923,10924,10925,10926,10927,10928,10929,10930,10931,10933,10934,10936,10937,10938,10939,10940,10941,10942,10943,10944,10949,10953,10955,10958,10960,10961,10964,10968,10969,10972,10976,10977,10979,10981,10983,10984,10985,10986,10990,10991,10992,10993,10997,11001,11003,11004,11005,11007,11013,11014,11016,11017,11018,11019,11020,11021,11022,11023,11024,11025,11026,11027,11044,11045,11046,11047,11048,11049,11050,11051,11052,11053,11076,11077,11082,11083,11084,11085,11086,11087,11088,11089,11090,11091,11092,11093,11094,11095,11096,11097,11098,11099,11100,11101,11103,11104,11105,11106,11107,11108,11109,11110,11112,11114,11117,11118,11119,11120,11121,11123,11124,11128,11129,11131,11133,11134,11137,11138,11140,11141,11142,11144,11147,11150,11153,11154,11155,11156,11157,11158,11159,11160,11161,11162,11163,11165,11167,11169,11171,11172,11173,11175,11176,11177,11178,11180,11181,11182,11183,11184,11185,11186,11187,11188,11189,11190,11191,11192,11193,11194,11196,11197,11198,11199,11200,11201,11202,11203,11204,11205,11206,11207,11208,11209,11210,11211,11212,11213,11214,11215,11216,11218,11219,11220,11222,11223,11224,11225,11226,11227,11230,11232,11233,11234,11235,11237,11238,11242,11243,11244,11246,11248,11249,11250,11251,11252,11253,11254,11255,11256,11257,11258,11259,11260,11261,11263,11264,11266,11267,11268,11273,11274,11278,11279,11280,11282,11283,11284,11285,11287,11288,11289,11290,11291,11292,11294,11295,11297,11298,11299,11300,11302,11303,11304,11307,11308,11309,11312,11314,11318,11319,11320,11321,11322,11324,11326,11327,11328,11330,11333,11334,11336,11337,11340,11341,11342,11344,11345,11346,11347,11348,11351,11352,11354,11355,11357,11358,11360,11361,11362,11363,11366,11369,11371,11372,11374,11377,11379,11383,11385,11389,11390,11391,11393,11394,11395,11396,11400,11402,11406,11408,11409,11411,11412,11413,11414,11415,11416,11417,11420,11422,11424,11429,11430,11433,11436,11438,11441,11444,11447,11449,11452,11455,11458,11460,11461,11464,11465,11467,11468,11469,11471,11472,11474,11475,11477,11479,11480,11481,11483,11484,11485,11487,11488,11489,11490,11491,11492,11493,11496,11497,11499,11500,11501,11502,11503,11506,11507,11508,11509,11510,11511,11512,11513,11514,11515,11516,11517,11520,11521,11522,11523,11526,11527,11529,11530,11531,11532,11533,11534,11535,11536,11537,11538,11539,11540,11541,11542,11543,11544,11545,11546,11547,11548,11549,11550,11553,11554,11558,11559,11560,11561,11563,11564,11565,11566,11568,11569,11571,11572,11574,11575,11580,11581,11582,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11608,11610,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11640,11643,11644,11647,11648,11653,11654,11658,11659,11661,11664,11665,11669,11670,11674,11675,11676,11678,11681,11682,11688,11694,11695,11696,11700,11701,11702,11704,11708,11709,11712,11714,11715,11719,11720,11721,11727,11729,11731,11732,11736,11737,11739,11741,11743,11744,11745,11746,11747,11749,11750,11751,11752,11753,11754,11755,11756,11758,11759,11762,11763,11766,11767,11768,11769,11770,11772,11773,11775,11778,11779,11781,11782,11783,11784,11785,11786,11787,11789,11790,11791,11792,11793,11794,11795,11798,11799,11800,11801,11802,11803,11805,11806,11807,11809,11810,11811,11812,11813,11814,11815,11816,11817,11820,11821,11822,11823,11825,11826,11827,11828,11829,11831,11832,11833,11834,11835,11836,11840,11841,11846,11849,11850,11852,11853,11854,11855,11858,11860,11861,11862,11863,11866,11867,11868,11869,11871,11872,11874,11875,11877,11879,11880,11881,11883,11884,11886,11887,11888,11891,11892,11893,11894,11895,11896,11897,11898,11899,11900,11901,11902,11903,11904,11905,11906,11907,11908,11909,11911,11912,11913,11914,11915,11916,11917,11919,11920,11921,11922,11923,11924,11926,11927,11928,11930,11931,11933,11934,11936,11937,11938,11940,11941,11942,11943,11944,11945,11946,11947,11948,11949,11950,11951,11952,11953,11954,11955,11956,11957,11958,11959,11960,11961,11962,11963,11964,11965,11966,11967,11968,11969,11970,11971,11972,11973,11974,11975,11976,11977,11978,11979,11980,11981,11982,11983,11984,11985,11986,11987,11988,11989,11990,11991,11992,11993,11994,11995,11997,11998,12000,12001,12002,12003,12005,12006,12007,12008,12009,12010,12012,12014,12015,12016,12017,12018,12019,12020,12021,12022,12023,12025,12026,12027,12028,12029,12031,12032,12033,12034,12035,12036,12037,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12051,12052,12053,12054,12055,12056,12057,12058,12059,12061,12062,12064,12065,12066,12067,12068,12069,12070,12071,12072,12073,12074,12076,12077,12078,12079,12081,12082,12083,12084,12085,12087,12088,12089,12090,12092,12093,12096,12099,12100,12105,12106,12108,12110,12112,12113,12116,12117,12121,12123,12125,12128,12130,12131,12132,12134,12136,12137,12139,12140,12141,12144,12145,12146,12147,12148,12149,12152,12153,12154,12155,12156,12157,12159,12161,12163,12164,12166,12167,12168,12169,12171,12172,12173,12174,12176,12177,12178,12179,12181,12182,12184,12186,12188,12190,12191,12193,12195,12197,12198,12200,12201,12204,12205,12207,12209,12210,12211,12212,12213,12214,12216,12217,12219,12221,12222,12224,12226,12227,12228,12230,12231,12232,12233,12234,12235,12236,12237,12238,12239,12240,12241,12242,12243,12244,12245,12246,12247,12248,12249,12250,12251,12252,12253,12254,12255,12256,12257,12260,12261,12264,12266,12267,12268,12269,12270,12271,12272,12273,12274,12275,12276,12277,12278,12279,12280,12281,12282,12283,12284,12286,12287,12288,12289,12290,12291,12292,12293,12294,12295,12296,12297,12298,12299,12301,12303,12304,12305,12307,12308,12309,12310,12311,12312,12313,12314,12315,12316,12317,12318,12319,12320,12321,12322,12323,12326,12327,12329,12333,12334,12335,12336,12337,12339,12340,12346,12347,12348,12349,12351,12352,12353,12354,12355,12357,12358,12359,12360,12361,12362,12364,12365,12366,12367,12368,12369,12371,12372,12373,12379,12380,12381,12382,12384,12385,12387,12388,12391,12392,12393,12394,12396,12397,12398,12400,12401,12403,12404,12405,12407,12408,12409,12410,12411,12414,12416,12418,12420,12422,12423,12424,12425,12427,12428,12429,12430,12431,12432,12433,12434,12435,12436,12437,12438,12439,12440,12441,12442,12443,12444,12445,12447,12448,12449,12450,12452,12454,12455,12456,12457,12458,12459,12461,12463,12464,12465,12466,12468,12469,12470,12471,12472,12475,12476,12477,12479,12480,12483,12484,12487,12490,12491,12492,12493,12495,12496,12497,12500,12501,12502,12505,12506,12507,12511,12512,12513,12516,12518,12520,12521,12522,12523,12524,12526,12527,12528,12529,12530,12531,12532,12534,12535,12538,12539,12541,12542,12543,12544,12545,12547,12548,12549,12550,12551,12553,12554,12556,12557,12558,12559,12560,12561,12562,12563,12564,12565,12566,12568,12569,12571,12572)
AND tag.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | xref | ALL | tagID,itemID | Индекс не используется | NULL | NULL | 31937 | Using where |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | predatores.xref.tagID | 1 | Using where |
| Status | Duration |
|---|---|
| starting | 0.97 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.45 ms |
| optimizing | 0.31 ms |
| statistics | 17.50 ms |
| preparing | 0.28 ms |
| executing | 0.00 ms |
| Sending data | 21.75 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.11 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_tools/helper.php:333 |
| 11 | modK2ToolsHelper::tagCloud() | JROOT/modules/mod_k2_tools/mod_k2_tools.php:91 |
| 10 | include JROOT/modules/mod_k2_tools/mod_k2_tools.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
ORDER BY i.id DESC
LIMIT 0, 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,access,category,published,trash | published | 2 | const | 1 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | i | ref | access,catid,item,published,publish_down,publish_up,trash | catid | 4 | predatores.c.id | 628 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Creating tmp table | 0.22 ms |
| Copying to tmp table | 571.36 ms |
| Sorting result | 11.97 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| removing tmp table | 10.57 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_content/helper.php:286 |
| 11 | modK2ContentHelper::getItems() | JROOT/modules/mod_k2_content/mod_k2_content.php:70 |
| 10 | include JROOT/modules/mod_k2_content/mod_k2_content.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND i.featured = 1
ORDER BY i.id DESC
LIMIT 0, 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,access,category,published,trash | published | 2 | const | 1 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | i | ref | access,catid,featured,item,published,publish_down,publish_up,trash | catid | 4 | predatores.c.id | 628 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 3.29 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Creating tmp table | 0.23 ms |
| Copying to tmp table | 290.77 ms |
| Sorting result | 2.69 ms |
| Sending data | 0.26 ms |
| end | 0.01 ms |
| removing tmp table | 2.31 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_content/helper.php:286 |
| 11 | modK2ContentHelper::getItems() | JROOT/modules/mod_k2_content/mod_k2_content.php:70 |
| 10 | include JROOT/modules/mod_k2_content/mod_k2_content.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND i.catid IN(1)
ORDER BY i.id DESC
LIMIT 0, 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | const | PRIMARY,access,category,published,trash | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | i | index | access,catid,item,published,publish_down,publish_up,trash | PRIMARY | 4 | NULL | 8 | Using where |
| Status | Duration |
|---|---|
| starting | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 3.11 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.00 ms |
| Sending data | 0.10 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_content/helper.php:286 |
| 11 | modK2ContentHelper::getItems() | JROOT/modules/mod_k2_content/mod_k2_content.php:70 |
| 10 | include JROOT/modules/mod_k2_content/mod_k2_content.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-04-21 18:01:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-04-21 18:01:59' )
AND i.featured = 1
ORDER BY i.id DESC
LIMIT 0, 4
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | c | ref | PRIMARY,access,category,published,trash | published | 2 | const | 1 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | i | ref | access,catid,featured,item,published,publish_down,publish_up,trash | catid | 4 | predatores.c.id | 628 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| After table lock | 0.00 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.49 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Creating tmp table | 0.22 ms |
| Copying to tmp table | 320.50 ms |
| Sorting result | 2.51 ms |
| Sending data | 0.26 ms |
| end | 0.01 ms |
| removing tmp table | 2.23 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_content/helper.php:286 |
| 11 | modK2ContentHelper::getItems() | JROOT/modules/mod_k2_content/mod_k2_content.php:70 |
| 10 | include JROOT/modules/mod_k2_content/mod_k2_content.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 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 |
5 × SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
3 × SELECT COUNT(*)
FROM fvb85_k2_comments
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `fvb85_extensions`
1 × SELECT *
FROM fvb85_k2_categories
1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories AS c
ON c.id = i.catid
1 × SELECT COUNT(*)
FROM fvb85_k2_items as i RIGHT JOIN fvb85_k2_categories c
ON c.id = i.catid
LEFT JOIN fvb85_k2_tags_xref tags_xref
ON tags_xref.itemID = i.id
LEFT JOIN fvb85_k2_tags tags
ON tags.id = tags_xref.tagID
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fvb85_modules AS m
LEFT JOIN fvb85_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fvb85_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT tag.name, tag.id
FROM fvb85_k2_tags as tag
LEFT JOIN fvb85_k2_tags_xref AS xref
ON xref.tagID = tag.id
1 × SELECT i.id
FROM fvb85_k2_items as i
LEFT JOIN fvb85_k2_categories c
ON c.id = i.catid
1 × SELECT id
FROM fvb85_k2_tags
1 × 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
FROM fvb85_fields AS a
LEFT JOIN `fvb85_languages` AS l
ON l.lang_code = a.language
LEFT JOIN fvb85_users AS uc
ON uc.id=a.checked_out
LEFT JOIN fvb85_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN fvb85_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN fvb85_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `fvb85_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT id
FROM fvb85_k2_categories
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM fvb85_extensions
1 × SELECT b.id
FROM fvb85_usergroups AS a
LEFT JOIN fvb85_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `fvb85_viewlevels
1 × SELECT `session_id`
FROM `fvb85_session`
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 fvb85_menu AS m
LEFT JOIN fvb85_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM fvb85_languages
1 × SELECT `data`
FROM `fvb85_session`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `fvb85_assets`
1 × SELECT id, home, template, s.params
FROM fvb85_template_styles as s
LEFT JOIN fvb85_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT id, name
FROM fvb85_k2_tags
1 × SHOW FULL COLUMNS
FROM `fvb85_k2_categories
1 × UPDATE `fvb85_extensions`
SET `params` = '{\"mediaversion\":\"28782ef5834513c31a7036ea19e94b90\"}'
1 × INSERT INTO `fvb85_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('u7ksfiqm716g1c4kn2m4hs2eu7', 1, '1555869719', 0, '', 0