Հարցման ժամանակը՝ 0.15 ms Հիշողություն հարցումով՝ 0.013 MB, հիշողություն հարցումից առաջ՝ 4.383 MB Ստացված տողեր՝ 0
SELECT `session_id`
FROM `adora_session`
WHERE `session_id` = 'itf1hr8pnndmkbuoh2j555hc17'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| 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.03 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 |
| # | Caller | File and line number |
|---|
| 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 |
Հարցման ժամանակը՝ 57.61 ms Վերջին հարցումից հետո՝ 0.10 ms Հիշողություն հարցումով՝ 0.010 MB, հիշողություն հարցումից առաջ՝ 4.400 MB
INSERT INTO `adora_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('itf1hr8pnndmkbuoh2j555hc17', 1, '1537833714', 0, '', 0)
INSERT INTO `adora_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('itf1hr8pnndmkbuoh2j555hc17', 1, '1537833714', 0, '', 0) հարցման համար EXPLAIN-ը անհայտ է։
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.04 ms |
| end | 0.00 ms |
| query end | 57.46 ms |
| closing tables | 0.02 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 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:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Հարցման ժամանակը՝ 0.26 ms Վերջին հարցումից հետո՝ 2.16 ms Հիշողություն հարցումով՝ 0.028 MB, հիշողություն հարցումից առաջ՝ 4.728 MB Ստացված տողեր՝ 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adora_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_extensions | ref | extension | extension | 82 | const | 36 | 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.00 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 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}() | 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:431 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:596 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Հարցման ժամանակը՝ 0.14 ms Վերջին հարցումից հետո՝ 1.91 ms Հիշողություն հարցումով՝ 0.015 MB, հիշողություն հարցումից առաջ՝ 5.042 MB Ստացված տողեր՝ 5
SELECT id, rules
FROM `adora_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_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.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 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 |
| # | Caller | File and line number |
|---|
| 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 |
Հարցման ժամանակը՝ 0.13 ms Վերջին հարցումից հետո՝ 0.09 ms Հիշողություն հարցումով՝ 0.016 MB, հիշողություն հարցումից առաջ՝ 5.066 MB Ստացված տողեր՝ 2
SELECT b.id
FROM adora_usergroups AS a
LEFT JOIN adora_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.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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 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 |
Հարցման ժամանակը՝ 0.46 ms Վերջին հարցումից հետո՝ 0.48 ms Հիշողություն հարցումով՝ 0.018 MB, հիշողություն հարցումից առաջ՝ 5.161 MB Ստացված տողեր՝ 73
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM adora_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 | adora_extensions | ref | extension | extension | 82 | const | 90 | Using index condition; Using where; Օգտագործվում է filesort-ը |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.17 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 |
| # | Caller | File and line number |
|---|
| 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}() | 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: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 |
Հարցման ժամանակը՝ 0.43 ms Վերջին հարցումից հետո՝ 17.48 ms Հիշողություն հարցումով՝ 0.033 MB, հիշողություն հարցումից առաջ՝ 7.314 MB Ստացված տողեր՝ 28
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM adora_menu AS m
LEFT JOIN adora_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 31 | Using index condition; Using where; Օգտագործվում է filesort-ը |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.m.component_id | 1 | 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.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.08 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 |
| # | Caller | File and line number |
|---|
| 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}() | 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: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 |
Հարցման ժամանակը՝ 0.15 ms Վերջին հարցումից հետո՝ 7.11 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 8.304 MB Ստացված տողեր՝ 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adora_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| 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.03 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 |
| # | Caller | File and line number |
|---|
| 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}() | Same as call in the line below. |
| 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:388 |
| 9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
| 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 |
Հարցման ժամանակը՝ 10.94 ms Վերջին հարցումից հետո՝ 0.14 ms Հիշողություն հարցումով՝ 0.018 MB, հիշողություն հարցումից առաջ՝ 8.312 MB
UPDATE `adora_extensions`
SET `params` = '{\"mediaversion\":\"a2f5e9fb3740af4566dd653864fc8f7a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
UPDATE `adora_extensions`
SET `params` = '{\"mediaversion\":\"a2f5e9fb3740af4566dd653864fc8f7a\"}'
WHERE `type` = 'library' AND `element` = 'joomla' հարցման համար EXPLAIN-ը անհայտ է։
| 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.03 ms |
| Updating | 0.10 ms |
| end | 0.00 ms |
| query end | 10.72 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 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:388 |
| 9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
| 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 |
Հարցման ժամանակը՝ 0.17 ms Վերջին հարցումից հետո՝ 3.46 ms Հիշողություն հարցումով՝ 0.023 MB, հիշողություն հարցումից առաջ՝ 8.895 MB Ստացված տողեր՝ 2
SELECT *
FROM adora_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_languages | ALL | NULL | Ցուցակագիրը չի օգտագործվում | NULL | NULL | 2 | Using where; Օգտագործվում է filesort-ը |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.02 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 |
| # | Caller | File and line number |
|---|
| 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:243 |
| 11 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:53 |
| 10 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:404 |
| 9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
| 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 |
Հարցման ժամանակը՝ 0.18 ms Վերջին հարցումից հետո՝ 2.03 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 9.287 MB Ստացված տողեր՝ 4
SELECT id, home, template, s.params
FROM adora_template_styles as s
LEFT JOIN adora_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 | s | ALL | idx_template | Ցուցակագիրը չի օգտագործվում | NULL | NULL | 6 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | alikonline_armHyDB.s.template,const | 1 | Using index condition; Using where |
| 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.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 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 |
| # | Caller | File and line number |
|---|
| 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() | Same as call in the line below. |
| 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() | Same as call in the line below. |
| 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:71 |
| 10 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:404 |
| 9 | plgSystemK2->onAfterRoute() | Same as call in the line below. |
| 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 |
Հարցման ժամանակը՝ 0.39 ms Վերջին հարցումից հետո՝ 2.35 ms Հիշողություն հարցումով՝ 0.020 MB, հիշողություն հարցումից առաջ՝ 9.398 MB Ստացված տողեր՝ 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `adora_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_k2ajaxsearch','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_sigpro','com_sppolls','com_tags','com_templates','com_users','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_assets | ALL | idx_asset_name | Ցուցակագիրը չի օգտագործվում | NULL | NULL | 120 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.00 ms |
| executing | 0.00 ms |
| Sending data | 0.14 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 |
| # | Caller | File and line number |
|---|
| 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 |
Հարցման ժամանակը՝ 0.17 ms Վերջին հարցումից հետո՝ 8.44 ms Հիշողություն հարցումով՝ 0.020 MB, հիշողություն հարցումից առաջ՝ 11.082 MB Ստացված տողեր՝ 45
SELECT id
FROM adora_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 | adora_k2_categories | range | category,published,access,trash | category | 8 | NULL | 46 | Using where; 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.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 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 |
| # | Caller | File and line number |
|---|
| 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:28 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 9.29 ms Վերջին հարցումից հետո՝ 1.60 ms Հիշողություն հարցումով՝ 0.047 MB, հիշողություն հարցումից առաջ՝ 11.228 MB Ստացված տողեր՝ 10
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM adora_k2_items as i RIGHT JOIN adora_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 <= '2018-09-25 00:01:54' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-09-25 00:01:54' )
AND MONTH(i.created) = 4
AND YEAR(i.created)=2018
AND DAY(i.created) = 17
ORDER BY i.created DESC
LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | index | item,catid | created | 8 | NULL | 10 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | alikonline_armHyDB.i.catid | 1 | 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.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.00 ms |
| Sending data | 9.05 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:322 |
| 12 | K2ModelItemlist->getData() | JROOT/components/com_k2/views/itemlist/view.html.php:353 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 133.95 ms Վերջին հարցումից հետո՝ 0.44 ms Հիշողություն հարցումով՝ 0.019 MB, հիշողություն հարցումից առաջ՝ 11.430 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_items as i RIGHT JOIN adora_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 <= '2018-09-25 00:01:54' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-09-25 00:01:54' )
AND MONTH(i.created) = 4
AND YEAR(i.created)=2018
AND DAY(i.created) = 17
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | range | item,catid | item | 10 | NULL | 49659 | Using index condition; Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | alikonline_armHyDB.i.catid | 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.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 133.62 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 |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 13 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/itemlist.php:521 |
| 12 | K2ModelItemlist->getTotal() | JROOT/components/com_k2/views/itemlist/view.html.php:375 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.46 ms Վերջին հարցումից հետո՝ 1.58 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 11.687 MB Ստացված տողեր՝ 14
SHOW FULL COLUMNS
FROM `adora_k2_categories`
SHOW FULL COLUMNS FROM `adora_k2_categories` հարցման համար EXPLAIN-ը անհայտ է։
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.17 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.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.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 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 |
| closing tables | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 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 |
| # | Caller | File and line number |
|---|
| 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:417 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.18 ms Վերջին հարցումից հետո՝ 0.67 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 11.788 MB Ստացված տողեր՝ 1
SELECT *
FROM adora_k2_categories
WHERE id = '13'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_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.02 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 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 |
| # | Caller | File and line number |
|---|
| 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:65 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.15 ms Վերջին հարցումից հետո՝ 1.91 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 11.995 MB Ստացված տողեր՝ 1
SELECT *
FROM adora_k2_categories
WHERE id = '2'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 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:85 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.31 ms Վերջին հարցումից հետո՝ 1.26 ms Հիշողություն հարցումով՝ 0.037 MB, հիշողություն հարցումից առաջ՝ 12.163 MB Ստացված տողեր՝ 16
SHOW FULL COLUMNS
FROM `adora_users`
SHOW FULL COLUMNS FROM `adora_users` հարցման համար EXPLAIN-ը անհայտ է։
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.09 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.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| Opening tables | 0.00 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| closing tables | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
| 25 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 24 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 23 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:40 |
| 22 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 21 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
| 20 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:880 |
| 19 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 18 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 17 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 16 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:211 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.17 ms Վերջին հարցումից հետո՝ 0.17 ms Հիշողություն հարցումով՝ 0.032 MB, հիշողություն հարցումից առաջ՝ 12.233 MB Ստացված տողեր՝ 1
SELECT *
FROM `adora_users`
WHERE `id` = 431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.02 ms |
| statistics | 0.03 ms |
| preparing | 0.00 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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
| 21 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:86 |
| 20 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
| 19 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 18 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 17 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 16 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:211 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.16 ms Վերջին հարցումից հետո՝ 2.50 ms Հիշողություն հարցումով՝ 0.029 MB, հիշողություն հարցումից առաջ՝ 13.176 MB Ստացված տողեր՝ 1
SELECT `g`.`id`,`g`.`title`
FROM `adora_usergroups` AS g
INNER JOIN `adora_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.m.group_id | 1 | |
| 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.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 |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 21 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:111 |
| 20 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
| 19 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 18 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 17 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 16 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:211 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 1.65 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 13.432 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| 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.00 ms |
| statistics | 0.01 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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.09 ms Վերջին հարցումից հետո՝ 0.22 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 13.456 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.12 ms Վերջին հարցումից հետո՝ 0.08 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 13.480 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_comments
WHERE itemID=46362
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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 |
| 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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.29 ms Վերջին հարցումից հետո՝ 9.09 ms Հիշողություն հարցումով՝ 0.035 MB, հիշողություն հարցումից առաջ՝ 14.790 MB Ստացված տողեր՝ 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM adora_fields AS a
LEFT JOIN `adora_languages` AS l
ON l.lang_code = a.language
LEFT JOIN adora_users AS uc
ON uc.id=a.checked_out
LEFT JOIN adora_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN adora_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN adora_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `adora_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 (13,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 | alikonline_armHyDB.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.id | 1 | Using where; Using index |
| 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 |
| 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.04 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.02 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 |
| # | Caller | File and line number |
|---|
| 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() | Same as call in the line below. |
| 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:635 |
| 12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:428 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.12 ms Վերջին հարցումից հետո՝ 5.34 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 15.510 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 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.00 ms |
| statistics | 0.02 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.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 0.22 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 15.533 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.12 ms Վերջին հարցումից հետո՝ 0.07 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 15.557 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_comments
WHERE itemID=46361
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,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.02 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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.12 ms Վերջին հարցումից հետո՝ 3.72 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 15.663 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 0.18 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 15.686 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.10 ms Վերջին հարցումից հետո՝ 0.06 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 15.710 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_comments
WHERE itemID=46360
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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 |
| 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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.14 ms Վերջին հարցումից հետո՝ 3.22 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 15.800 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.02 ms |
| executing | 0.00 ms |
| Sending data | 0.01 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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.09 ms Վերջին հարցումից հետո՝ 0.18 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 15.824 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.08 ms Վերջին հարցումից հետո՝ 0.07 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 15.848 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_comments
WHERE itemID=46359
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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 |
| 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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.13 ms Վերջին հարցումից հետո՝ 1.95 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 15.839 MB Ստացված տողեր՝ 1
SELECT *
FROM adora_k2_categories
WHERE id = '10'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 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.00 ms |
| statistics | 0.02 ms |
| preparing | 0.00 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 |
| # | Caller | File and line number |
|---|
| 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:65 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 1.47 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 15.968 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 0.18 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 15.991 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.10 ms Վերջին հարցումից հետո՝ 0.06 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 16.015 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_comments
WHERE itemID=46357
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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 |
| 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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.27 ms Վերջին հարցումից հետո՝ 1.73 ms Հիշողություն հարցումով՝ 0.035 MB, հիշողություն հարցումից առաջ՝ 15.989 MB Ստացված տողեր՝ 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM adora_fields AS a
LEFT JOIN `adora_languages` AS l
ON l.lang_code = a.language
LEFT JOIN adora_users AS uc
ON uc.id=a.checked_out
LEFT JOIN adora_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN adora_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN adora_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `adora_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 (10,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 | alikonline_armHyDB.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | alikonline_armHyDB.a.id | 1 | Using where; Using index |
| 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 |
| 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 | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.01 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 |
| # | Caller | File and line number |
|---|
| 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() | Same as call in the line below. |
| 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:635 |
| 12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/itemlist/view.html.php:428 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 2.04 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 16.136 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.10 ms Վերջին հարցումից հետո՝ 0.18 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 16.159 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.10 ms Վերջին հարցումից հետո՝ 0.08 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 16.183 MB Ստացված տողեր՝ 1
SELECT COUNT(*)
FROM adora_k2_comments
WHERE itemID=46356
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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 |
| 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.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
| 16 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.12 ms Վերջին հարցումից հետո՝ 2.16 ms Հիշողություն հարցումով՝ 0.027 MB, հիշողություն հարցումից առաջ՝ 16.174 MB Ստացված տողեր՝ 1
SELECT *
FROM adora_k2_categories
WHERE id = '27'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.02 ms |
| preparing | 0.00 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 |
| # | Caller | File and line number |
|---|
| 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:65 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 1.24 ms Հիշողություն հարցումով՝ 0.025 MB, հիշողություն հարցումից առաջ՝ 16.298 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.12 ms Վերջին հարցումից հետո՝ 0.19 ms Հիշողություն հարցումով՝ 0.026 MB, հիշողություն հարցումից առաջ՝ 16.321 MB Ստացված տողեր՝ 0
SELECT id, gender, description, image, url, `
group`, plugins
FROM adora_k2_users
WHERE userID=431
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adora_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.00 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.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 |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 18 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
| 17 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:45 |
| 16 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:215 |
| 15 | K2ModelItem->prepareItem() | 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/Cache/Controller/CallbackController.php:45 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/components/com_k2/views/itemlist/view.html.php:421 |
| 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:19 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/itemlist.php:45 |
| 8 | K2ControllerItemlist->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
| 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 |
Հարցման ժամանակը՝ 0.11 ms Վերջին հարցումից հետո՝ 0.07 ms Հիշողություն հարցումով՝ 0.024 MB, հիշողություն հարցումից առաջ՝ 16.345 MB Ստացված տողեր՝ 1
