Календарний план
Новини
- 30 листопада керівництво Вінницької територіальної організації ВФСТ "Колос" відвідала Немирівську територіальну громаду,
- 27 листопада 2020 року у Гніванській міській раді відбулася зустріч представників Вінницької територіальної організації ВФСТ " Колос", міської ради та спортивної громадськості Гніванської територіальної громади
- керівництво Вінницької територіальної організації ВФСТ "Колос" 4 грудня відвідали с. Глухівці Козятинського району.
- 10 грудня 2020року керівництво Вінницької територіальної організації ВФСТ "Колос" в рамках реалізації проекту "Програма фізичного оздоровлення населення в громадах: досвід країн Вишеградської четвірки для України" відвідали Барську територіальну громаду.
- 17 грудня відбулась ХІІ конференція Вінницької територіальної організації ВФСТ «Колос»
Вітаємо !!!
15.09 - Носкова Катерина Яківна, інженер- економіст ВО ДЮСШ "Колос"
21.09 - Турков Олег Олександрович, юрист ВТО ВФСТ "Колос"
23.09 - Грязон Наталя Володимирівна , фахівець ВТО ВІСТ "Колос"
24.09 - Любченко Микола Іванович, голова Липовецької РО ВФСТ "Колос"
Випадкове фото
План заходів
Організації
Консоль налагодження Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1618858988,
"last": 1618858988,
"now": 1618858988
},
"client": {
"forwarded": "3.238.88.35"
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 44.18 ms / 44.18 ms Memory: 0.645 MB / 1.09 MB Application: afterLoad
Time: 125.47 ms / 169.66 ms Memory: 1.262 MB / 2.35 MB Application: afterInitialise
Time: 31.37 ms / 201.03 ms Memory: 0.319 MB / 2.67 MB Application: afterRoute
Time: 11.97 ms / 213.00 ms Memory: 0.065 MB / 2.73 MB Application: beforeRenderComponent com_content
Time: 12.14 ms / 225.13 ms Memory: 0.118 MB / 2.85 MB Application: Before Access::preloadComponents (all components)
Time: 3.32 ms / 228.45 ms Memory: 0.055 MB / 2.91 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 228.50 ms Memory: -0.003 MB / 2.90 MB Application: Before Access::preloadPermissions (com_content)
Time: 13.29 ms / 241.79 ms Memory: 1.352 MB / 4.26 MB Application: After Access::preloadPermissions (com_content)
Time: 0.08 ms / 241.87 ms Memory: -0.065 MB / 4.19 MB Application: Before Access::getAssetRules (id:812 name:com_content.article.752)
Time: 1.18 ms / 243.05 ms Memory: 0.010 MB / 4.20 MB Application: After Access::getAssetRules (id:812 name:com_content.article.752)
Time: 76.76 ms / 319.80 ms Memory: 0.543 MB / 4.74 MB Application: afterRenderComponent com_content
Time: 8.97 ms / 328.77 ms Memory: 0.081 MB / 4.82 MB Application: afterDispatch
Time: 9.17 ms / 337.94 ms Memory: 0.079 MB / 4.90 MB Application: beforeRenderModule mod_menu (Меню користувача)
Time: 2.62 ms / 340.56 ms Memory: 0.018 MB / 4.92 MB Application: afterRenderModule mod_menu (Меню користувача)
Time: 0.05 ms / 340.61 ms Memory: 0.003 MB / 4.93 MB Application: beforeRenderModule mod_articles_category (Календарний план)
Time: 5.65 ms / 346.26 ms Memory: 0.080 MB / 5.01 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.09 ms / 346.35 ms Memory: 0.007 MB / 5.01 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 21.26 ms / 367.61 ms Memory: 0.546 MB / 5.56 MB Application: afterRenderModule mod_articles_category (Календарний план)
Time: 0.08 ms / 367.69 ms Memory: -0.267 MB / 5.29 MB Application: beforeRenderModule mod_mvsocialbuttons (Соціальні мережі)
Time: 1.79 ms / 369.48 ms Memory: 0.010 MB / 5.30 MB Application: afterRenderModule mod_mvsocialbuttons (Соціальні мережі)
Time: 0.04 ms / 369.52 ms Memory: -0.006 MB / 5.30 MB Application: beforeRenderModule mod_articles_latest (Новини)
Time: 100.93 ms / 470.45 ms Memory: 0.190 MB / 5.49 MB Application: afterRenderModule mod_articles_latest (Новини)
Time: 0.08 ms / 470.53 ms Memory: -0.093 MB / 5.39 MB Application: beforeRenderModule mod_custom ( Вітаємо !!!)
Time: 0.89 ms / 471.42 ms Memory: 0.006 MB / 5.40 MB Application: afterRenderModule mod_custom ( Вітаємо !!!)
Time: 0.04 ms / 471.46 ms Memory: -0.001 MB / 5.40 MB Application: beforeRenderModule mod_random_image (Випадкове фото)
Time: 5.04 ms / 476.50 ms Memory: 0.101 MB / 5.50 MB Application: afterRenderModule mod_random_image (Випадкове фото)
Time: 0.08 ms / 476.58 ms Memory: -0.095 MB / 5.40 MB Application: beforeRenderModule mod_custom (План заходів)
Time: 0.10 ms / 476.69 ms Memory: 0.003 MB / 5.41 MB Application: afterRenderModule mod_custom (План заходів)
Time: 0.03 ms / 476.72 ms Memory: -0.001 MB / 5.41 MB Application: beforeRenderModule mod_custom (Організації)
Time: 0.08 ms / 476.79 ms Memory: 0.003 MB / 5.41 MB Application: afterRenderModule mod_custom (Організації)
Time: 0.08 ms / 476.87 ms Memory: 0.000 MB / 5.41 MB Application: beforeRenderModule mod_custom (Флешка спорцмены)
Time: 0.08 ms / 476.95 ms Memory: 0.002 MB / 5.41 MB Application: afterRenderModule mod_custom (Флешка спорцмены)
Time: 0.14 ms / 477.09 ms Memory: 0.016 MB / 5.43 MB Application: beforeRenderModule mod_image_show_gk4 (Главная флешка)
Time: 4.86 ms / 481.96 ms Memory: 0.105 MB / 5.53 MB Application: afterRenderModule mod_image_show_gk4 (Главная флешка)
Time: 0.24 ms / 482.19 ms Memory: -0.098 MB / 5.44 MB Application: beforeRenderModule mod_breadcrumbs (Навигатор сайта)
Time: 1.99 ms / 484.18 ms Memory: 0.013 MB / 5.45 MB Application: afterRenderModule mod_breadcrumbs (Навигатор сайта)
Time: 0.09 ms / 484.27 ms Memory: -0.005 MB / 5.44 MB Application: beforeRenderModule mod_menu (Главное меню)
Time: 5.19 ms / 489.47 ms Memory: 0.132 MB / 5.58 MB Application: afterRenderModule mod_menu (Главное меню)
Time: 4.05 ms / 493.52 ms Memory: 0.086 MB / 5.66 MB Application: afterRender
Database queries total: 181.67 ms
6.00 MB (6,291,584 Bytes)
24 запитів для зареєстрованих користувачів 181.67 ms
- Query Time: 1.26 ms Query memory: 0.023 MB Memory before query: 1.581 MB Rows returned: 0
SELECT `data`
FROM `vin_session`
WHERE `session_id` = X'3339303031373339653937386361653434353932353834383832306434353731'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_session const PRIMARY PRIMARY 194 const 1 Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.82 ms preparing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 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:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:51 - Query Time: 0.67 ms After last query: 3.30 ms Query memory: 0.020 MB Memory before query: 1.660 MB Rows returned: 0
SELECT `session_id`
FROM `vin_session`
WHERE `session_id` = X'3339303031373339653937386361653434353932353834383832306434353731'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 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.31 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:806 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:51 - Query Time: 1.36 ms After last query: 0.15 ms Query memory: 0.004 MB Memory before query: 1.665 MB
INSERT INTO `vin_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3339303031373339653937386361653434353932353834383832306434353731', 1, 1618858988, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `vin_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3339303031373339653937386361653434353932353834383832306434353731', 1, 1618858988, 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms update 1.04 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:806 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:51 - Query Time: 2.55 ms After last query: 8.05 ms Query memory: 0.040 MB Memory before query: 1.702 MB Rows returned: 37
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vin_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_extensions ref extension extension 82 const 37 Using index condition; Using where Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.68 ms preparing 0.04 ms executing 0.01 ms Sending data 1.26 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 4.98 ms After last query: 8.17 ms Query memory: 0.021 MB Memory before query: 1.799 MB Rows returned: 3
SELECT id, rules
FROM `vin_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Status Duration starting 0.13 ms checking permissions 0.09 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.09 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 1.11 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.10 ms cleaning up 0.03 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 2.13 ms After last query: 0.41 ms Query memory: 0.021 MB Memory before query: 1.811 MB Rows returned: 1
SELECT b.id
FROM vin_usergroups AS a
LEFT JOIN vin_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 8 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.08 ms init 0.04 ms optimizing 0.04 ms statistics 1.36 ms preparing 0.05 ms executing 0.02 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.91 ms After last query: 2.14 ms Query memory: 0.030 MB Memory before query: 1.833 MB Rows returned: 83
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vin_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_extensions ref extension extension 82 const 105 Using index condition; Using where; Using filesort Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sorting result 1.26 ms Sending data 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 2.33 ms After last query: 43.70 ms Query memory: 0.064 MB Memory before query: 2.380 MB Rows returned: 20
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 vin_menu AS m
LEFT JOIN vin_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 32 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.m.component_id 1 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.59 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.98 ms Sending data 0.22 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 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:395 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:65 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:511 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1119 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.21 ms After last query: 23.77 ms Query memory: 0.023 MB Memory before query: 2.689 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vin_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.58 ms preparing 0.03 ms executing 0.01 ms Sending data 0.23 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.89 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 2.680 MB
UPDATE `vin_extensions`
SET `params` = '{\"mediaversion\":\"30347c00dc7c1db10a525f0ef7e7ee53\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `vin_extensions` SET `params` = '{\"mediaversion\":\"30347c00dc7c1db10a525f0ef7e7ee53\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.07 ms Updating 0.29 ms end 0.02 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.26 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 0.95 ms After last query: 5.43 ms Query memory: 0.020 MB Memory before query: 2.715 MB Rows returned: 2
SELECT *
FROM vin_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.49 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.71 ms After last query: 0.34 ms Query memory: 0.019 MB Memory before query: 2.729 MB Rows returned: 8
SELECT id, home, template, s.params
FROM vin_template_styles as s
LEFT JOIN vin_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 11 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 vinkolos-vn-ua.s.template,const 1 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.94 ms preparing 0.04 ms executing 0.01 ms Sending data 0.36 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 2.95 ms After last query: 12.60 ms Query memory: 0.027 MB Memory before query: 2.857 MB Rows returned: 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `vin_assets`
WHERE `name` IN ('root.1','com_actionlogs','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_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_assets range idx_asset_name idx_asset_name 202 NULL 38 Using index condition Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.07 ms optimizing 0.02 ms statistics 0.21 ms preparing 0.03 ms executing 0.01 ms Sending data 2.21 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 10.89 ms After last query: 0.30 ms Query memory: 0.321 MB Memory before query: 2.905 MB Rows returned: 1564
SELECT `id`,`name`,`rules`,`parent_id`
FROM `vin_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE vin_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 1650 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.97 ms preparing 0.03 ms executing 0.01 ms Sending data 9.43 ms end 0.03 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.28 ms After last query: 5.02 ms Query memory: 0.031 MB Memory before query: 4.267 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `vin_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `vin_content`Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.26 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.03 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.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.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.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms closing tables 0.01 ms executing 0.01 ms Sending data 0.08 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.10 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 14.80 ms After last query: 6.22 ms Query memory: 0.005 MB Memory before query: 4.318 MB
UPDATE vin_content
SET `hits` = (`hits` + 1)
WHERE `id` = '752'EXPLAIN not possible on query: UPDATE vin_content SET `hits` = (`hits` + 1) WHERE `id` = '752'Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 14.24 ms end 0.03 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.22 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 2.53 ms After last query: 3.20 ms Query memory: 0.024 MB Memory before query: 4.345 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM vin_content AS a
INNER JOIN vin_categories AS c
on c.id = a.catid
LEFT JOIN vin_users AS u
on u.id = a.created_by
LEFT JOIN vin_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vin_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 752
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-19 19:03:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-19 19:03:08')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.12 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 Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms After table lock 0.02 ms init 0.06 ms optimizing 0.04 ms statistics 1.86 ms preparing 0.03 ms executing 0.02 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.91 ms After last query: 4.28 ms Query memory: 0.028 MB Memory before query: 4.446 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `vin_categories` AS `s`
INNER JOIN `vin_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 15
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort 1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 20 Using index condition; Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 1.14 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.24 ms Sending data 0.09 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 # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 1.78 ms After last query: 1.39 ms Query memory: 0.022 MB Memory before query: 4.469 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `vin_contentitem_tag_map` AS m
INNER JOIN `vin_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 752
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 vinkolos-vn-ua.m.tag_id 1 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.85 ms preparing 0.03 ms executing 0.02 ms Sending data 0.54 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 # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 4.48 ms After last query: 15.88 ms Query memory: 0.025 MB Memory before query: 4.609 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM vin_fields AS a
LEFT JOIN `vin_languages` AS l
ON l.lang_code = a.language
LEFT JOIN vin_users AS uc
ON uc.id=a.checked_out
LEFT JOIN vin_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN vin_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN vin_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `vin_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (15,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 vinkolos-vn-ua.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.id 1 Using where; Using index; Distinct Status Duration starting 0.14 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 Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.06 ms optimizing 0.04 ms statistics 3.08 ms preparing 0.15 ms executing 0.01 ms Creating tmp table 0.37 ms Copying to tmp table 0.07 ms Sorting result 0.06 ms Sending data 0.06 ms end 0.01 ms removing tmp table 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 3.17 ms After last query: 29.69 ms Query memory: 0.064 MB Memory before query: 4.867 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vin_modules AS m
LEFT JOIN vin_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vin_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-19 19:03:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-19 19:03:08')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 16 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 vinkolos-vn-ua.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 vinkolos-vn-ua.m.module,const 1 Using index condition; Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms optimizing 0.04 ms statistics 0.61 ms preparing 0.06 ms executing 0.01 ms Sorting result 0.53 ms Sending data 1.44 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/new/functions.php:4 8 require JROOT/templates/new/functions.php JROOT/templates/new/index.php:9 7 require JROOT/templates/new/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1076 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 9.62 ms After last query: 11.35 ms Query memory: 0.401 MB Memory before query: 5.012 MB Rows returned: 2
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM vin_content AS a
LEFT JOIN vin_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN vin_categories AS c
ON c.id = a.catid
LEFT JOIN vin_users AS ua
ON ua.id = a.created_by
LEFT JOIN vin_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vin_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vin_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (24)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-19 19:03:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-19 19:03:08')
ORDER BY a.title ASC
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 Using filesort 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 3 Using intersect(idx_catid,idx_state); Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.id 1 Using where 1 SIMPLE fp eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.id 1 Using where Status Duration starting 0.23 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 Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.10 ms optimizing 0.05 ms statistics 2.27 ms preparing 0.13 ms executing 0.01 ms Sorting result 1.29 ms Sending data 5.07 ms end 0.03 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/modules/mod_articles_category/helper.php:224 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:557 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 8.63 ms After last query: 0.97 ms Query memory: 0.608 MB Memory before query: 5.284 MB Rows returned: 4
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `vin_categories` AS `s`
INNER JOIN `vin_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 24
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 20 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.09 ms optimizing 0.04 ms statistics 0.13 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.01 ms Sending data 7.89 ms end 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 16 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 15 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_category/helper.php:260 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:557 11 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54 - Query Time: 97.66 ms After last query: 5.26 ms Query memory: 0.058 MB Memory before query: 5.391 MB Rows returned: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM vin_content AS a
LEFT JOIN vin_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN vin_categories AS c
ON c.id = a.catid
LEFT JOIN vin_users AS ua
ON ua.id = a.created_by
LEFT JOIN vin_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vin_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vin_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (15)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-19 19:03:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-19 19:03:08')
ORDER BY a.created DESC
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 Using filesort 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_state,idx_catid,idx_access 1,4,4 NULL 383 Using intersect(idx_state,idx_catid,idx_access); Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.id 1 Using where 1 SIMPLE fp eq_ref PRIMARY PRIMARY 4 vinkolos-vn-ua.a.id 1 Using where Status Duration starting 0.18 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 Opening tables 0.34 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.02 ms init 0.09 ms optimizing 0.04 ms statistics 0.43 ms preparing 0.06 ms executing 0.01 ms Sorting result 95.18 ms Sending data 1.01 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms updating status 0.85 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:123 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1090 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:54
20 типи запитів: зареєстрований, відсортований за знайденим
SELECT таблиць:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vin_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `vin_assets`2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `vin_categories` AS `s`
INNER JOIN `vin_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM vin_content AS a
LEFT JOIN vin_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN vin_categories AS c
ON c.id = a.catid
LEFT JOIN vin_users AS ua
ON ua.id = a.created_by
LEFT JOIN vin_users AS uam
ON uam.id = a.modified_by
LEFT JOIN vin_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vin_content_rating AS v
ON a.id = v.content_id1 × SELECT `data`
FROM `vin_session`1 × SELECT `session_id`
FROM `vin_session`1 × SELECT id, rules
FROM `vin_viewlevels1 × SELECT b.id
FROM vin_usergroups AS a
LEFT JOIN vin_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vin_extensions1 × 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 vin_menu AS m
LEFT JOIN vin_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM vin_languages1 × SELECT id, home, template, s.params
FROM vin_template_styles as s
LEFT JOIN vin_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM vin_content AS a
INNER JOIN vin_categories AS c
on c.id = a.catid
LEFT JOIN vin_users AS u
on u.id = a.created_by
LEFT JOIN vin_categories as parent
ON parent.id = c.parent_id
LEFT JOIN vin_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `vin_contentitem_tag_map` AS m
INNER JOIN `vin_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM vin_fields AS a
LEFT JOIN `vin_languages` AS l
ON l.lang_code = a.language
LEFT JOIN vin_users AS uc
ON uc.id=a.checked_out
LEFT JOIN vin_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN vin_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN vin_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `vin_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vin_modules AS m
LEFT JOIN vin_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vin_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Інші таблиці:
1 × INSERT INTO `vin_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3339303031373339653937386361653434353932353834383832306434353731', 1, 1618858988, 0, '', 01 × UPDATE `vin_extensions`
SET `params` = '{\"mediaversion\":\"30347c00dc7c1db10a525f0ef7e7ee53\"}'1 × SHOW FULL COLUMNS
FROM `vin_content1 × UPDATE vin_content
SET `hits` = (`hits` + 1)