Query Time: 1.09 ms Query memory: 0.023 MB Memory before query: 1.013 MB Rows returned: 0
SELECT `data`
FROM `ag_session`
WHERE `session_id` = '4abb6132c945c8e6b2740f51c61e0c5c'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
Starting | 0.13 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.09 ms |
Table lock | 0.03 ms |
Init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
End of update loop | 0.03 ms |
Query end | 0.04 ms |
Commit | 0.03 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.06 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.93 ms After last query: 0.38 ms Query memory: 0.020 MB Memory before query: 1.028 MB Rows returned: 0
SELECT `session_id`
FROM `ag_session`
WHERE `session_id` = '4abb6132c945c8e6b2740f51c61e0c5c'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Executing | 0.03 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.08 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.51 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 1.033 MB
INSERT INTO `ag_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('4abb6132c945c8e6b2740f51c61e0c5c', 1, 1615127680, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `ag_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('4abb6132c945c8e6b2740f51c61e0c5c', 1, 1615127680, 0, '', 0)
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init for update | 0.05 ms |
Update | 0.14 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.47 ms |
Closing tables | 0.09 ms |
Unlocking tables | 0.07 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.12 ms |
Reset for next command | 0.05 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:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.76 ms After last query: 0.61 ms Query memory: 0.040 MB Memory before query: 1.064 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ag_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_extensions | ref | extension | extension | 82 | const | 40 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.12 ms |
Preparing | 0.08 ms |
Executing | 0.02 ms |
Sending data | 0.66 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.05 ms |
Freeing items | 0.03 ms |
Updating status | 0.07 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.12 ms After last query: 0.58 ms Query memory: 0.021 MB Memory before query: 1.102 MB Rows returned: 5
SELECT id, rules
FROM `ag_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | |
Status | Duration |
---|
Starting | 0.10 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.15 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.04 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.21 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.114 MB Rows returned: 2
SELECT b.id
FROM ag_usergroups AS a
LEFT JOIN ag_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 | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 9 | Using where; Using index |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Unlocking tables | 0.06 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.09 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.10 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.89 ms After last query: 0.19 ms Query memory: 0.030 MB Memory before query: 1.135 MB Rows returned: 99
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ag_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 | ag_extensions | ref | extension | extension | 82 | const | 121 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
Starting | 0.14 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.10 ms |
Preparing | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.03 ms |
Sending data | 0.03 ms |
Creating sort index | 1.69 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.10 ms |
Reset for next command | 0.07 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.05 ms After last query: 8.26 ms Query memory: 0.080 MB Memory before query: 1.592 MB Rows returned: 75
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 ag_menu AS m
LEFT JOIN ag_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 | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 78 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.21 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.08 ms |
Optimizing | 0.06 ms |
Statistics | 0.12 ms |
Preparing | 0.06 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 1.57 ms |
End of update loop | 0.03 ms |
Query end | 0.04 ms |
Commit | 0.03 ms |
Closing tables | 0.07 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.08 ms |
Reset for next command | 0.06 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
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:375 |
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:491 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1073 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.26 ms After last query: 3.32 ms Query memory: 0.025 MB Memory before query: 1.939 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ag_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.07 ms |
Optimizing | 0.09 ms |
Statistics | 0.13 ms |
Preparing | 0.07 ms |
Executing | 0.03 ms |
Sending data | 0.11 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:388 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.59 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 1.932 MB
UPDATE `ag_extensions`
SET `params` = '{\"mediaversion\":\"28b0571621319f0a145baf6c9e8e743c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `ag_extensions`
SET `params` = '{\"mediaversion\":\"28b0571621319f0a145baf6c9e8e743c\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init for update | 0.14 ms |
Updating | 0.13 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.49 ms |
Closing tables | 0.06 ms |
Unlocking tables | 0.06 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.11 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:388 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.22 ms After last query: 2.07 ms Query memory: 0.022 MB Memory before query: 2.053 MB Rows returned: 1
SELECT *
FROM ag_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
Status | Duration |
---|
Starting | 0.09 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.04 ms |
Preparing | 0.04 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.13 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.11 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
12 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
11 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/components/com_k2/helpers/utilities.php:243 |
10 | K2HelperUtilities::getParams() | JROOT/administrator/components/com_k2/helpers/html.php:53 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:404 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.54 ms After last query: 1.15 ms Query memory: 0.026 MB Memory before query: 2.071 MB Rows returned: 7
SELECT id, home, template, s.params
FROM ag_template_styles as s
LEFT JOIN ag_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.13 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.12 ms |
Preparing | 0.11 ms |
Executing | 0.02 ms |
Sending data | 0.24 ms |
End of update loop | 0.03 ms |
Query end | 0.07 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
19 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
18 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
17 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
13 | JHtmlJquery::framework() | Same as call in the line below. |
12 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
11 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
10 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:71 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:404 |
8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.28 ms After last query: 3.51 ms Query memory: 0.025 MB Memory before query: 2.138 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ag_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_azurapagebuilder','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_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 129 | Using where |
Status | Duration |
---|
Starting | 0.19 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.15 ms |
Optimizing | 0.05 ms |
Statistics | 0.32 ms |
Preparing | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.66 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.11 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.42 ms After last query: 2.84 ms Query memory: 0.023 MB Memory before query: 2.302 MB Rows returned: 11
SELECT id
FROM ag_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 | ag_k2_categories | ref | category,published,access,trash | category | 2 | const | 12 | Using where; Using index |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.14 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.10 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.08 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.11 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:274 |
12 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/item/view.html.php:35 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.16 ms After last query: 0.15 ms Query memory: 0.038 MB Memory before query: 2.309 MB Rows returned: 1
SELECT *
FROM ag_k2_items
WHERE id=64
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_items | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.08 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.04 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.11 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:33 |
12 | K2ModelItem->getData() | JROOT/components/com_k2/views/item/view.html.php:42 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.02 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 2.334 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `ag_k2_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ag_k2_categories`
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.02 ms |
Closing tables | 0.02 ms |
Opening tables | 0.59 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
Checking permissions | 0.18 ms |
Closing tables | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.11 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Removing tmp table | 0.22 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.08 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:36 |
14 | TableK2Category->__construct() | JROOT/libraries/src/Table/Table.php:312 |
13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/models/item.php:64 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.22 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 2.359 MB Rows returned: 1
SELECT *
FROM ag_k2_categories
WHERE id = '10'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.04 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.05 ms |
Preparing | 0.04 ms |
Executing | 0.09 ms |
Sending data | 0.07 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.11 ms |
Reset for next command | 0.08 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
13 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.28 ms After last query: 1.85 ms Query memory: 0.023 MB Memory before query: 2.431 MB Rows returned: 2
SELECT tag.*
FROM ag_k2_tags AS tag
JOIN ag_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 64
ORDER BY xref.id ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 2 | Using where |
1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | defotobar_be_fotobar.xref.tagID | 1 | Using where |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
Init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.13 ms |
Preparing | 0.08 ms |
Sorting result | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.12 ms |
End of update loop | 0.03 ms |
Query end | 0.04 ms |
Commit | 0.03 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1174 |
13 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:98 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.37 ms After last query: 5.77 ms Query memory: 0.029 MB Memory before query: 2.449 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `ag_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ag_users`
Status | Duration |
---|
Starting | 0.09 ms |
Checking permissions | 0.03 ms |
Closing tables | 0.02 ms |
Opening tables | 0.65 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
Checking permissions | 0.26 ms |
Closing tables | 0.03 ms |
Executing | 0.03 ms |
Sending data | 0.15 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
Closing tables | 0.02 ms |
Removing tmp table | 0.27 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.10 ms |
Reset for next command | 0.07 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
21 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
20 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:40 |
19 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:312 |
18 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
17 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:880 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:211 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.07 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 2.478 MB Rows returned: 1
SELECT *
FROM `ag_users`
WHERE `id` = 15
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.08 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.04 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.05 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:86 |
17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:211 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.08 ms After last query: 0.38 ms Query memory: 0.025 MB Memory before query: 2.490 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `ag_usergroups` AS g
INNER JOIN `ag_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 15
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 | defotobar_be_fotobar.m.group_id | 1 | |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.10 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.09 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.09 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
18 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:111 |
17 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
16 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
15 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
14 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
13 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:211 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.20 ms After last query: 1.43 ms Query memory: 0.023 MB Memory before query: 2.497 MB Rows returned: 1
SELECT id, gender, description, image, url, `
group`, plugins
FROM ag_k2_users
WHERE userID=15
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_users | ref | userID | userID | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
Init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.10 ms |
Preparing | 0.07 ms |
Executing | 0.03 ms |
Sending data | 0.14 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.06 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.08 ms |
Reset for next command | 0.06 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
14 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1550 |
13 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:214 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.52 ms After last query: 0.31 ms Query memory: 0.023 MB Memory before query: 2.506 MB Rows returned: 1
SELECT COUNT(*)
FROM ag_k2_comments
WHERE itemID=64
AND published=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 486 | Using index |
Status | Duration |
---|
Starting | 0.09 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
Init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.25 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.40 ms |
End of update loop | 0.07 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.06 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
14 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
13 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
12 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:50 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.49 ms After last query: 2.98 ms Query memory: 0.026 MB Memory before query: 2.616 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ag_fields AS a
LEFT JOIN `ag_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ag_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ag_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ag_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ag_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ag_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
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; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | defotobar_be_fotobar.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.27 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.10 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.11 ms |
Optimizing | 0.09 ms |
Statistics | 0.12 ms |
Preparing | 0.09 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.07 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.03 ms |
Updating status | 0.07 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
19 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
18 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
17 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
16 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
15 | PlgSystemFields->onContentPrepare() | 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:634 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:53 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.80 ms After last query: 2.90 ms Query memory: 0.024 MB Memory before query: 2.750 MB Rows returned: 1
SELECT *
FROM `ag_azurapagebuilder_likes`
WHERE `pageID` = 64
AND `option` = 'com_k2'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_azurapagebuilder_likes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | Using where |
Status | Duration |
---|
Starting | 0.07 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.12 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.02 ms |
Updating status | 0.06 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_azurapagebuilder/helpers/elementparser.php:1841 |
16 | AzuraShortcode::getK2PostLikes() | JROOT/plugins/k2/azurak2builder/azurak2builder.php:146 |
15 | plgK2AzuraK2Builder->onK2PrepareContent() | 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:751 |
12 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:53 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.85 ms After last query: 1.74 ms Query memory: 0.033 MB Memory before query: 2.784 MB Rows returned: 36
SHOW FULL COLUMNS
FROM `ag_k2_items`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ag_k2_items`
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.02 ms |
Closing tables | 0.02 ms |
Opening tables | 0.43 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Filling schema table | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
Checking permissions | 0.28 ms |
Closing tables | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.14 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
Closing tables | 0.02 ms |
Removing tmp table | 0.17 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.07 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2item.php:58 |
14 | TableK2Item->__construct() | JROOT/libraries/src/Table/Table.php:312 |
13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/models/item.php:797 |
12 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:117 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.18 ms After last query: 0.22 ms Query memory: 0.006 MB Memory before query: 2.829 MB
UPDATE ag_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '64'
EXPLAIN not possible on query: UPDATE ag_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '64'
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init for update | 0.08 ms |
Updating | 0.16 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.34 ms |
Closing tables | 0.05 ms |
Unlocking tables | 0.03 ms |
Closing tables | 0.06 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.03 ms |
Updating status | 0.11 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1242 |
13 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_k2/models/item.php:798 |
12 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:117 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 17.14 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 2.833 MB Rows returned: 10
SELECT *
FROM ag_k2_comments
WHERE itemID=64
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_comments | ref | itemID,published,latestComments,countComments | itemID | 4 | const | 486 | Using where; Using filesort |
Status | Duration |
---|
Starting | 0.09 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.05 ms |
Statistics | 0.29 ms |
Preparing | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 15.79 ms |
End of update loop | 0.05 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
Closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.06 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1420 |
12 | K2ModelItem->getItemComments() | JROOT/components/com_k2/views/item/view.html.php:205 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 1.64 ms Query memory: 0.023 MB Memory before query: 2.853 MB Rows returned: 14
SELECT itemID
FROM ag_k2_tags_xref
WHERE tagID IN (2,6)
AND itemID!=64
GROUP BY itemID
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_tags_xref | range | tagID,itemID | tagID | 4 | NULL | 19 | Using index condition; Using where; Using temporary; Using filesort |
Status | Duration |
---|
Starting | 0.08 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.07 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
13 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:818 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.00 ms After last query: 0.12 ms Query memory: 0.040 MB Memory before query: 2.862 MB Rows returned: 3
SELECT i.*, c.alias as categoryalias
FROM ag_k2_items as i
LEFT JOIN ag_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-03-07 14:34:40' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-03-07 14:34:40' )
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.id) IN (51,55,57,67,69,71,78,80,82,85,92,94,98,103)
ORDER BY i.created DESC
LIMIT 0, 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i | index | PRIMARY,item,catid | created | 5 | NULL | 16 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | defotobar_be_fotobar.i.catid | 1 | Using where |
Status | Duration |
---|
Starting | 0.09 ms |
Checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.11 ms |
Preparing | 0.07 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.23 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:858 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.51 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 2.897 MB Rows returned: 1
SELECT *
FROM ag_k2_categories
WHERE id = '11'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.03 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
15 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
14 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:868 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.79 ms After last query: 3.35 ms Query memory: 0.023 MB Memory before query: 2.968 MB Rows returned: 1
SELECT COUNT(*)
FROM ag_k2_comments
WHERE itemID=103
AND published=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 469 | Using index |
Status | Duration |
---|
Starting | 0.05 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.11 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.20 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.05 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:868 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.84 ms After last query: 0.51 ms Query memory: 0.027 MB Memory before query: 2.963 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ag_fields AS a
LEFT JOIN `ag_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ag_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ag_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ag_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ag_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ag_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (11,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; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | defotobar_be_fotobar.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
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:333 |
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:135 |
17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:569 |
13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:869 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.71 ms After last query: 0.63 ms Query memory: 0.026 MB Memory before query: 2.976 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ag_fields AS a
LEFT JOIN `ag_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ag_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ag_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ag_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ag_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ag_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (11,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; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | defotobar_be_fotobar.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.11 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:387 |
17 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:307 |
16 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:641 |
13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:869 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 0.30 ms Query memory: 0.023 MB Memory before query: 2.987 MB Rows returned: 1
SELECT *
FROM ag_k2_categories
WHERE id = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
15 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
14 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:65 |
13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:868 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.75 ms After last query: 2.75 ms Query memory: 0.023 MB Memory before query: 3.057 MB Rows returned: 1
SELECT COUNT(*)
FROM ag_k2_comments
WHERE itemID=98
AND published=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 5590 | Using index |
Status | Duration |
---|
Starting | 0.04 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.28 ms |
Preparing | 0.04 ms |
Executing | 0.01 ms |
Sending data | 1.85 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:868 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 0.35 ms Query memory: 0.026 MB Memory before query: 3.045 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ag_fields AS a
LEFT JOIN `ag_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ag_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ag_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ag_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ag_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ag_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (1,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | defotobar_be_fotobar.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.13 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.06 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
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:333 |
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:135 |
17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:569 |
13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:869 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.72 ms After last query: 0.40 ms Query memory: 0.026 MB Memory before query: 3.057 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ag_fields AS a
LEFT JOIN `ag_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ag_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ag_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ag_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ag_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ag_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (1,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | defotobar_be_fotobar.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.a.id | 1 | Using where; Using index |
Status | Duration |
---|
Starting | 0.12 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:387 |
17 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:307 |
16 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:641 |
13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:869 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.65 ms After last query: 5.12 ms Query memory: 0.023 MB Memory before query: 3.125 MB Rows returned: 1
SELECT COUNT(*)
FROM ag_k2_comments
WHERE itemID=94
AND published=1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 137 | Using index |
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1438 |
14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:230 |
13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:868 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:255 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.65 ms After last query: 0.55 ms Query memory: 0.022 MB Memory before query: 3.109 MB Rows returned: 0
SELECT *
FROM ag_k2_items
WHERE id != 64
AND catid=10
AND ordering > 25
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-03-07 14:34:40' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-03-07 14:34:40' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_items | range | PRIMARY,item,catid,ordering | ordering | 4 | NULL | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.10 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1532 |
12 | K2ModelItem->getNextItem() | JROOT/components/com_k2/views/item/view.html.php:268 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 3.116 MB Rows returned: 1
SELECT *
FROM ag_k2_items
WHERE id != 64
AND catid=10
AND ordering < 25
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-03-07 14:34:40' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-03-07 14:34:40' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_k2_items | ref | PRIMARY,item,catid,ordering | catid | 4 | const | 24 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.18 ms |
End of update loop | 0.04 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1495 |
12 | K2ModelItem->getPreviousItem() | JROOT/components/com_k2/views/item/view.html.php:300 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 6.69 ms Query memory: 0.025 MB Memory before query: 3.190 MB Rows returned: 1
SELECT *
FROM `ag_azurapagebuilder_likes`
WHERE `pageID` = 64
AND `option` = 'com_k2'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_azurapagebuilder_likes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | Using where |
Status | Duration |
---|
Starting | 0.06 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.06 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_azurapagebuilder/helpers/elementparser.php:1841 |
16 | AzuraShortcode::getK2PostLikes() | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php:483 |
15 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php:55 |
14 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_k2/views/item/view.html.php:521 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.46 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 3.215 MB Rows returned: 0
SELECT *
FROM `ag_azurapagebuilder_likes`
WHERE `pageID` = 103
AND `option` = 'com_k2'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_azurapagebuilder_likes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.04 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_azurapagebuilder/helpers/elementparser.php:1841 |
16 | AzuraShortcode::getK2PostLikes() | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php:641 |
15 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php:55 |
14 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_k2/views/item/view.html.php:521 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.42 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 3.224 MB Rows returned: 0
SELECT *
FROM `ag_azurapagebuilder_likes`
WHERE `pageID` = 98
AND `option` = 'com_k2'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_azurapagebuilder_likes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_azurapagebuilder/helpers/elementparser.php:1841 |
16 | AzuraShortcode::getK2PostLikes() | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php:641 |
15 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php:55 |
14 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_k2/views/item/view.html.php:521 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.41 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 3.234 MB Rows returned: 0
SELECT *
FROM `ag_azurapagebuilder_likes`
WHERE `pageID` = 94
AND `option` = 'com_k2'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | ag_azurapagebuilder_likes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | Using where |
Status | Duration |
---|
Starting | 0.03 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.01 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
17 | JDatabaseDriver->loadObject() | JROOT/components/com_azurapagebuilder/helpers/elementparser.php:1841 |
16 | AzuraShortcode::getK2PostLikes() | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php:641 |
15 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item-simple.php | JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php:55 |
14 | include JROOT/templates/oyster/html/com_k2/templates/version-3-portfolio/item.php | JROOT/libraries/src/MVC/View/HtmlView.php:697 |
13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_k2/views/item/view.html.php:521 |
11 | K2ViewItem->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/item.php:74 |
8 | K2ControllerItem->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:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.05 ms After last query: 4.57 ms Query memory: 0.049 MB Memory before query: 3.402 MB Rows returned: 38
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ag_modules AS m
LEFT JOIN ag_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ag_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-03-07 14:34:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-07 14:34:40')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 203 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using index condition; Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | defotobar_be_fotobar.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | defotobar_be_fotobar.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.15 ms |
Checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
Init | 0.06 ms |
Optimizing | 0.06 ms |
Statistics | 0.09 ms |
Preparing | 0.07 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.84 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.08 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
16 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
13 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
12 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
11 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
10 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/oyster/layout/header/default.php:48 |
9 | require_once JROOT/templates/oyster/layout/header/default.php | JROOT/templates/oyster/layout/header.php:77 |
8 | require_once JROOT/templates/oyster/layout/header.php | JROOT/templates/oyster/index.php:179 |
7 | require JROOT/templates/oyster/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × SELECT *
FROM `ag_azurapagebuilder_likes`
5 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ag_fields AS a
LEFT JOIN `ag_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ag_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ag_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ag_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ag_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ag_fields_categories` AS fc
ON fc.field_id = a.id
4 × SELECT COUNT(*)
FROM ag_k2_comments
3 × SELECT *
FROM ag_k2_categories
3 × SELECT *
FROM ag_k2_items
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ag_extensions`
1 × SELECT *
FROM `ag_users`
1 × SELECT i.*, c.alias as categoryalias
FROM ag_k2_items as i
LEFT JOIN ag_k2_categories c
ON c.id = i.catid
1 × SELECT itemID
FROM ag_k2_tags_xref
1 × SELECT *
FROM ag_k2_comments
1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM ag_k2_users
1 × SELECT `g`.`id`,`g`.`title`
FROM `ag_usergroups` AS g
INNER JOIN `ag_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT `data`
FROM `ag_session`
1 × SELECT tag.*
FROM ag_k2_tags AS tag JOIN ag_k2_tags_xref AS xref
ON tag.id = xref.tagID
1 × SELECT `session_id`
FROM `ag_session`
1 × SELECT id
FROM ag_k2_categories
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ag_assets`
1 × SELECT id, home, template, s.params
FROM ag_template_styles as s
LEFT JOIN ag_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM ag_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ag_menu AS m
LEFT JOIN ag_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ag_extensions
1 × SELECT b.id
FROM ag_usergroups AS a
LEFT JOIN ag_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `ag_viewlevels
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ag_modules AS m
LEFT JOIN ag_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ag_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
discount canadian drugs
March 07, 2021
legitimate canadian pharmacies online
March 07, 2021
mexican pharmacy online
March 07, 2021
Markideog
March 07, 2021
overseas pharmacy
March 07, 2021
Evaideog
March 06, 2021
Annaideog
March 06, 2021
canada drugs online reviews
March 06, 2021
Jasonideog
March 06, 2021
Jimideog
March 06, 2021