Query Time: 0.40 ms Query memory: 0.023 MB Memory before query: 3.872 MB Rows returned: 0
SELECT `data`
FROM `dq149_session`
WHERE `session_id` = X'6430633436313963363763353565646662623032646437373333383939393031'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.11 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php: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.24 ms After last query: 1.57 ms Query memory: 0.020 MB Memory before query: 4.030 MB Rows returned: 0
SELECT `session_id`
FROM `dq149_session`
WHERE `session_id` = X'6430633436313963363763353565646662623032646437373333383939393031'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php: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: 16.81 ms After last query: 0.11 ms Query memory: 0.004 MB Memory before query: 4.036 MB
INSERT INTO `dq149_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'6430633436313963363763353565646662623032646437373333383939393031', 1, 1618115243, 0, '')
EXPLAIN not possible on query: INSERT INTO `dq149_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'6430633436313963363763353565646662623032646437373333383939393031', 1, 1618115243, 0, '')
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
update | 0.13 ms |
end | 0.01 ms |
query end | 16.37 ms |
closing tables | 0.02 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php: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: 0.62 ms After last query: 3.40 ms Query memory: 0.024 MB Memory before query: 4.250 MB Rows returned: 37
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `dq149_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_extensions | NULL | ref | extension | extension | 82 | const | 37 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.22 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.28 ms After last query: 2.87 ms Query memory: 0.021 MB Memory before query: 4.439 MB Rows returned: 5
SELECT id, rules
FROM `dq149_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.38 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 4.451 MB Rows returned: 2
SELECT b.id
FROM dq149_usergroups AS a
LEFT JOIN dq149_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.14 ms After last query: 0.83 ms Query memory: 0.030 MB Memory before query: 4.520 MB Rows returned: 106
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM dq149_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_extensions | NULL | ref | extension | extension | 82 | const | 118 | 0.60 | Using index condition; Using where; Using filesort |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.70 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.10 ms After last query: 27.15 ms Query memory: 0.265 MB Memory before query: 6.618 MB Rows returned: 120
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 dq149_menu AS m
LEFT JOIN dq149_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 149 | 10.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Sorting result | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 1.63 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php: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: 0.34 ms After last query: 11.20 ms Query memory: 0.025 MB Memory before query: 7.770 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `dq149_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
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/jcomments/jcomments.php:111 |
8 | plgSystemJComments->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: 12.60 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 7.763 MB
UPDATE `dq149_extensions`
SET `params` = '{\"mediaversion\":\"eefe75df9e003174083ad85feb095d72\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | dq149_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.06 ms |
updating | 0.10 ms |
end | 0.01 ms |
query end | 12.15 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 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/jcomments/jcomments.php:111 |
8 | plgSystemJComments->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: 0.48 ms After last query: 3.52 ms Query memory: 0.032 MB Memory before query: 8.020 MB Rows returned: 91
SELECT *
FROM `dq149_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_jcomments_settings | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 91 | 97.80 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
14 | JCommentsCfg::_load() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
11 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->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: 0.48 ms After last query: 0.33 ms Query memory: 0.021 MB Memory before query: 8.025 MB Rows returned: 2
SELECT id, home, template, s.params
FROM dq149_template_styles as s
LEFT JOIN dq149_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 75.00 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | darry120_jo340.s.template,const | 1 | 4.36 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->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: 0.37 ms After last query: 0.44 ms Query memory: 0.019 MB Memory before query: 8.048 MB Rows returned: 1
SELECT *
FROM dq149_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.39 ms After last query: 5.16 ms Query memory: 0.027 MB Memory before query: 8.463 MB Rows returned: 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `dq149_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_assets | NULL | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 374 | 10.16 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.89 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 0.25 ms Query memory: 0.054 MB Memory before query: 8.510 MB Rows returned: 150
SELECT `id`,`name`,`rules`,`parent_id`
FROM `dq149_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_assets | NULL | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 374 | 22.50 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.45 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.94 ms After last query: 1.76 ms Query memory: 0.031 MB Memory before query: 8.724 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `dq149_content`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `dq149_content`
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Opening tables | 0.02 ms |
checking permissions | 0.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 12.71 ms After last query: 3.47 ms Query memory: 0.006 MB Memory before query: 8.959 MB
UPDATE dq149_content
SET `hits` = (`hits` + 1)
WHERE `id` = '34'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | dq149_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.04 ms |
updating | 0.12 ms |
end | 0.01 ms |
query end | 12.23 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1245 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.68 ms After last query: 1.72 ms Query memory: 0.039 MB Memory before query: 9.082 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM dq149_content AS a
INNER JOIN dq149_categories AS c
on c.id = a.catid
LEFT JOIN dq149_users AS u
on u.id = a.created_by
LEFT JOIN dq149_categories as parent
ON parent.id = c.parent_id
LEFT JOIN dq149_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 34
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-11 04:27:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-11 04:27:23')
AND (a.state = 1 OR a.state =2)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.91 ms After last query: 2.16 ms Query memory: 0.054 MB Memory before query: 9.282 MB Rows returned: 2
SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 34
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 509 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | darry120_jo340.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.50 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.72 ms After last query: 17.63 ms Query memory: 0.027 MB Memory before query: 10.376 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `dq149_categories` AS `s`
INNER JOIN `dq149_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 10
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 6 | 93.33 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.06 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 10.426 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM dq149_fields AS a
LEFT JOIN `dq149_languages` AS l
ON l.lang_code = a.language
LEFT JOIN dq149_users AS uc
ON uc.id=a.checked_out
LEFT JOIN dq149_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN dq149_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN dq149_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `dq149_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (10,0,28))
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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | darry120_jo340.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.17 ms |
Creating sort index | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.47 ms After last query: 3.72 ms Query memory: 0.023 MB Memory before query: 10.722 MB Rows returned: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `dq149_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 20
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | contact | NULL | ref | idx_state | idx_state | 1 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/plugins/content/contact/contact.php:125 |
14 | PlgContentContact->getContactData() | JROOT/plugins/content/contact/contact.php:66 |
13 | PlgContentContact->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.73 ms After last query: 0.46 ms Query memory: 0.028 MB Memory before query: 10.743 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `dq149_categories` AS `s`
INNER JOIN `dq149_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 4
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | range | cat_idx,idx_access,idx_left_right | cat_idx | 207 | NULL | 4 | 90.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_contact/router.php:68 |
23 | ContactRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
15 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
14 | Joomla\CMS\Router\Route::_() | JROOT/plugins/content/contact/contact.php:75 |
13 | PlgContentContact->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 1.72 ms Query memory: 0.024 MB Memory before query: 10.825 MB Rows returned: 12
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM dq149_content AS a
LEFT JOIN dq149_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 10
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-04-11 04:27:23')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-04-11 04:27:23')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 12 | 16.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | cc | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.24 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/pagenavigation/pagenavigation.php:161 |
13 | PlgContentPagenavigation->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.41 ms After last query: 7.01 ms Query memory: 0.027 MB Memory before query: 11.369 MB Rows returned: 1
SELECT *
FROM `dq149_jcomments_objects`
WHERE `object_id` = '34'
AND `object_group` = 'com_content'
AND `lang` = 'en-GB'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_jcomments_objects | NULL | ref | idx_object | idx_object | 833 | const,const,const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
23 | JDatabaseDriver->loadObject() | JROOT/components/com_jcomments/models/object.php:28 |
22 | JCommentsModelObject::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:117 |
21 | JCommentsObjectHelper::fetchObjectInfo() | Same as call in the line below. |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/helpers/object.php:159 |
18 | JCommentsObjectHelper::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:46 |
17 | JCommentsObjectHelper::getLink() | JROOT/components/com_jcomments/classes/factory.php:255 |
16 | JCommentsFactory::getTemplate() | JROOT/components/com_jcomments/jcomments.php:194 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.59 ms After last query: 0.30 ms Query memory: 0.025 MB Memory before query: 11.359 MB Rows returned: 1
SELECT count(*)
FROM dq149_jcomments AS c
WHERE c.object_id = 34
AND c.object_group = 'com_content'
AND c.published = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ref | idx_object | idx_object | 772 | const,const,const | 128 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/models/jcomments.php:35 |
17 | JCommentsModel::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:1306 |
16 | JComments::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:224 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.10 ms After last query: 0.47 ms Query memory: 0.027 MB Memory before query: 11.383 MB Rows returned: 6
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, v.value as voted
,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM dq149_jcomments AS c
LEFT JOIN dq149_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '3.229.120.26'
WHERE c.object_id = 34
AND c.object_group = 'com_content'
AND c.published = 1
ORDER BY c.date ASC
LIMIT 70, 10
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | v | NULL | system | idx_comment,idx_user | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | c | NULL | ref | idx_object | idx_object | 772 | const,const,const | 128 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.54 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/models/jcomments.php:80 |
17 | JCommentsModel::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:658 |
16 | JComments::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:272 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.44 ms After last query: 4.51 ms Query memory: 0.034 MB Memory before query: 11.654 MB Rows returned: 15
SELECT *
FROM `dq149_jcomments_custom_bbcodes`
WHERE `published` = 1
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_jcomments_custom_bbcodes | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 15 | 10.00 | Using where; Using filesort |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/custombbcode.php:43 |
19 | JCommentsCustomBBCode->__construct() | JROOT/components/com_jcomments/classes/factory.php:157 |
18 | JCommentsFactory::getCustomBBCode() | JROOT/components/com_jcomments/jcomments.php:1017 |
17 | JComments::prepareComment() | JROOT/components/com_jcomments/jcomments.php:703 |
16 | JComments::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:272 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.50 ms After last query: 14.68 ms Query memory: 0.043 MB Memory before query: 12.218 MB Rows returned: 27
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM dq149_modules AS m
LEFT JOIN dq149_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN dq149_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-11 04:27:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-11 04:27:23')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 147 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 29 | 1.61 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | darry120_jo340.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | darry120_jo340.m.id | 1 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.95 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/beez3/index.php:18 |
7 | require JROOT/templates/beez3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php: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 |
Query Time: 0.34 ms After last query: 5.52 ms Query memory: 0.023 MB Memory before query: 12.447 MB Rows returned: 1
SELECT metakey
FROM dq149_content
WHERE id = 34
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/modules/mod_related_items/helper.php:79 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 2.47 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 12.458 MB Rows returned: 5
SELECT a.id
FROM dq149_content AS a
WHERE a.id != 34
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.metakey LIKE '%Penyakit cacing%' OR a.metakey LIKE '%Cacing Pita%' OR a.metakey LIKE '%Cacing pita Anjing%' OR a.metakey LIKE '%Cacing pita Kucing%' OR a.metakey LIKE '%Cacing pita Sapi%' OR a.metakey LIKE '%Cacing pita Babi%' OR a.metakey LIKE '%Hewan%')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-11 04:27:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-11 04:27:23')
LIMIT 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | range | PRIMARY,idx_access,idx_state | idx_state | 5 | NULL | 116 | 2.69 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.96 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
15 | JDatabaseDriver->loadColumn() | JROOT/modules/mod_related_items/helper.php:134 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 1.24 ms After last query: 0.33 ms Query memory: 0.115 MB Memory before query: 12.481 MB Rows returned: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM dq149_content AS a
LEFT JOIN dq149_categories AS c
ON c.id = a.catid
LEFT JOIN dq149_users AS ua
ON ua.id = a.created_by
LEFT JOIN dq149_users AS uam
ON uam.id = a.modified_by
LEFT JOIN dq149_categories as parent
ON parent.id = c.parent_id
LEFT JOIN dq149_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.id IN (24,35,39,40,87)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-11 04:27:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-11 04:27:23')
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | range | PRIMARY,idx_access,idx_state,idx_catid | PRIMARY | 4 | NULL | 5 | 2.40 | Using where; Using filesort |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | darry120_jo340.a.catid | 1 | 10.00 | Using where |
1 | SIMPLE | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.c.parent_id | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.23 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
Creating sort index | 0.45 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_related_items/helper.php:147 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.84 ms After last query: 0.33 ms Query memory: 0.074 MB Memory before query: 12.599 MB Rows returned: 3
SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 87
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 509 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | darry120_jo340.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.46 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
16 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_related_items/helper.php:147 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.75 ms After last query: 0.27 ms Query memory: 0.073 MB Memory before query: 12.653 MB Rows returned: 3
SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 40
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 509 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | darry120_jo340.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
16 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_related_items/helper.php:147 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.69 ms After last query: 0.24 ms Query memory: 0.041 MB Memory before query: 12.728 MB Rows returned: 2
SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 35
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 509 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | darry120_jo340.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
16 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_related_items/helper.php:147 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.70 ms After last query: 0.21 ms Query memory: 0.056 MB Memory before query: 12.768 MB Rows returned: 1
SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 39
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 509 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | darry120_jo340.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
16 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_related_items/helper.php:147 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.71 ms After last query: 0.27 ms Query memory: 0.057 MB Memory before query: 12.805 MB Rows returned: 2
SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 24
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 509 | 1.00 | Using where |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | darry120_jo340.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
16 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_related_items/helper.php:147 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.69 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 12.844 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `dq149_categories` AS `s`
INNER JOIN `dq149_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 18
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 43.56 | Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.15 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
27 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
26 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
25 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
24 | ContentRouter->getCategorySegment() | Same as call in the line below. |
23 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
22 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
21 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
20 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
19 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
18 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
17 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
16 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
15 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_related_items/helper.php:164 |
14 | ModRelatedItemsHelper::getList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:587 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_related_items/mod_related_items.php:22 |
10 | include JROOT/modules/mod_related_items/mod_related_items.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.90 ms After last query: 2.41 ms Query memory: 0.056 MB Memory before query: 12.603 MB Rows returned: 2
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM dq149_content AS a
LEFT JOIN dq149_categories AS c
ON c.id = a.catid
LEFT JOIN dq149_users AS ua
ON ua.id = a.created_by
LEFT JOIN dq149_users AS uam
ON uam.id = a.modified_by
LEFT JOIN dq149_categories as parent
ON parent.id = c.parent_id
LEFT JOIN dq149_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (29)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-11 04:27:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-11 04:27:23')
ORDER BY a.created DESC
LIMIT 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 2 | 16.00 | Using index condition; Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.created_by | 1 | 100.00 | Using where |
1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.modified_by | 1 | 100.00 | Using where |
1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | SIMPLE | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.a.id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.20 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.23 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
12 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_latest/helper.php:123 |
11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.68 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 12.673 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `dq149_categories` AS `s`
INNER JOIN `dq149_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 29
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 59.11 | Using where |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
21 | ContentRouter->getCategorySegment() | Same as call in the line below. |
20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_latest/helper.php:135 |
11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 1235.86 ms After last query: 3.77 ms Query memory: 0.023 MB Memory before query: 12.746 MB Rows returned: 5
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
FROM dq149_jcomments AS c JOIN dq149_jcomments_objects AS o
ON c.object_id = o.object_id
AND c.object_group = o.object_group
AND c.lang = o.lang JOIN dq149_content AS cc
ON cc.id = o.object_id
LEFT JOIN dq149_categories AS ct
ON ct.id = cc.catid
WHERE c.published = 1
AND c.deleted = 0
AND o.link <> ''
AND o.access IN (1,5,0)
AND c.object_group = 'com_content'
AND (cc.publish_up = '0000-00-00 00:00:00' OR cc.publish_up <= '2021-04-11 04:27:23')
AND (cc.publish_down = '0000-00-00 00:00:00' OR cc.publish_down >= '2021-04-11 04:27:23')
AND cc.catid IN (0,28,8,9,10,11,13,15,17,18,19,20,21,27,29,30)
ORDER BY c.date DESC
LIMIT 0, 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cc | NULL | range | PRIMARY,idx_catid | idx_catid | 4 | NULL | 90 | 16.00 | Using index condition; Using where; Using temporary; Using filesort |
1 | SIMPLE | ct | NULL | eq_ref | PRIMARY | PRIMARY | 4 | darry120_jo340.cc.catid | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | o | NULL | ref | idx_object | idx_object | 771 | darry120_jo340.cc.id,const | 1 | 27.00 | Using where |
1 | SIMPLE | c | NULL | ref | idx_lang,idx_object | idx_object | 772 | darry120_jo340.cc.id,const,const | 1452 | 1.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.16 ms |
preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 1187.40 ms |
Creating sort index | 43.82 ms |
end | 0.02 ms |
query end | 0.02 ms |
removing tmp table | 3.85 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_jcomments_latest/helper.php:137 |
11 | modJCommentsLatestHelper::getList() | JROOT/modules/mod_jcomments_latest/mod_jcomments_latest.php:40 |
10 | include JROOT/modules/mod_jcomments_latest/mod_jcomments_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.59 ms After last query: 53.60 ms Query memory: 0.034 MB Memory before query: 13.846 MB Rows returned: 249
SELECT guest, client_id
FROM dq149_session
WHERE client_id IS NULL
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_session | NULL | ref | client_id_guest | client_id_guest | 2 | const | 249 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.17 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_whosonline/helper.php:45 |
11 | ModWhosonlineHelper::getOnlineCount() | JROOT/modules/mod_whosonline/mod_whosonline.php:19 |
10 | include JROOT/modules/mod_whosonline/mod_whosonline.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.36 ms After last query: 9.18 ms Query memory: 0.007 MB Memory before query: 15.184 MB
CREATE TABLE IF NOT EXISTS dq149_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS dq149_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
After create | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
14 | JDatabase->query() | JROOT/modules/mod_vvisit_counter/helper.php:1404 |
13 | modVisitCounterHelper->init() | JROOT/modules/mod_vvisit_counter/helper.php:482 |
12 | modVisitCounterHelper->__construct() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.25 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 15.191 MB Rows returned: 1
SELECT count( * ) AS records, MAX( id ) AS max
FROM dq149_vvisitcounter
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Select tables optimized away |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1773 |
14 | JDatabaseDriver->loadRow() | JROOT/modules/mod_vvisit_counter/helper.php:1417 |
13 | modVisitCounterHelper->init() | JROOT/modules/mod_vvisit_counter/helper.php:482 |
12 | modVisitCounterHelper->__construct() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.25 ms After last query: 0.11 ms Query memory: 0.007 MB Memory before query: 15.199 MB
DELETE
FROM dq149_vvisitcounter
WHERE id<='1636856'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | DELETE | dq149_vvisitcounter | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.03 ms |
updating | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
14 | JDatabase->query() | JROOT/modules/mod_vvisit_counter/helper.php:1560 |
13 | modVisitCounterHelper->init() | JROOT/modules/mod_vvisit_counter/helper.php:482 |
12 | modVisitCounterHelper->__construct() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 0.38 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 15.206 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE ip=UNHEX(SHA1('3.229.120.26'))
AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_vvisitcounter | NULL | ref | ip,iptm | iptm | 20 | const | 5 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/modules/mod_vvisit_counter/helper.php:1612 |
13 | modVisitCounterHelper->init() | JROOT/modules/mod_vvisit_counter/helper.php:482 |
12 | modVisitCounterHelper->__construct() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:21 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 1.17 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 15.215 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_vvisitcounter | NULL | range | tm | tm | 4 | NULL | 2077 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.88 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/modules/mod_vvisit_counter/helper.php:1920 |
13 | modVisitCounterHelper->sql_today_visitors() | JROOT/modules/mod_vvisit_counter/helper.php:763 |
12 | modVisitCounterHelper->renderPeopleTable() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 2.10 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 15.223 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
AND UNIX_TIMESTAMP(DATE(NOW()))
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_vvisitcounter | NULL | range | tm | tm | 4 | NULL | 4766 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.87 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/modules/mod_vvisit_counter/helper.php:1935 |
13 | modVisitCounterHelper->sql_yesterday_visitors() | JROOT/modules/mod_vvisit_counter/helper.php:774 |
12 | modVisitCounterHelper->renderPeopleTable() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 9.13 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 15.231 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE tm BETWEEN 1617580800
AND 1618185600
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_vvisitcounter | NULL | range | tm | tm | 4 | NULL | 28348 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 8.89 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/modules/mod_vvisit_counter/helper.php:1979 |
13 | modVisitCounterHelper->sql_week_visitors() | JROOT/modules/mod_vvisit_counter/helper.php:784 |
12 | modVisitCounterHelper->renderPeopleTable() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Query Time: 14.71 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 15.239 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | dq149_vvisitcounter | NULL | range | tm | tm | 4 | NULL | 47932 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 14.38 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/modules/mod_vvisit_counter/helper.php:1994 |
13 | modVisitCounterHelper->sql_month_visitors() | JROOT/modules/mod_vvisit_counter/helper.php:808 |
12 | modVisitCounterHelper->renderPeopleTable() | JROOT/modules/mod_vvisit_counter/tmpl/default.php:26 |
11 | require JROOT/modules/mod_vvisit_counter/tmpl/default.php | JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21 |
10 | include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
6 × SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
5 × SELECT COUNT(*)
FROM dq149_vvisitcounter
4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `dq149_categories` AS `s`
INNER JOIN `dq149_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `dq149_extensions`
2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM dq149_content AS a
LEFT JOIN dq149_categories AS c
ON c.id = a.catid
LEFT JOIN dq149_users AS ua
ON ua.id = a.created_by
LEFT JOIN dq149_users AS uam
ON uam.id = a.modified_by
LEFT JOIN dq149_categories as parent
ON parent.id = c.parent_id
LEFT JOIN dq149_content_rating AS v
ON a.id = v.content_id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `dq149_assets`
1 × SELECT *
FROM `dq149_jcomments_objects`
1 × SELECT count( * ) AS records, MAX( id ) AS max
FROM dq149_vvisitcounte
1 × SELECT guest, client_id
FROM dq149_session
1 × SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
FROM dq149_jcomments AS c JOIN dq149_jcomments_objects AS o
ON c.object_id = o.object_id
AND c.object_group = o.object_group
AND c.lang = o.lang JOIN dq149_content AS cc
ON cc.id = o.object_id
LEFT JOIN dq149_categories AS ct
ON ct.id = cc.catid
1 × SELECT a.id
FROM dq149_content AS a
1 × SELECT metakey
FROM dq149_content
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM dq149_modules AS m
LEFT JOIN dq149_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN dq149_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM `dq149_jcomments_custom_bbcodes`
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM dq149_jcomments AS c
LEFT JOIN dq149_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '3.229.120.26'
1 × SELECT count(*)
FROM dq149_jcomments AS c
1 × SELECT `data`
FROM `dq149_session`
1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM dq149_content AS a
LEFT JOIN dq149_categories AS cc
ON cc.id = a.catid
1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `dq149_contact_details` AS `contact`
1 × SELECT `session_id`
FROM `dq149_session`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM dq149_content AS a
INNER JOIN dq149_categories AS c
on c.id = a.catid
LEFT JOIN dq149_users AS u
on u.id = a.created_by
LEFT JOIN dq149_categories as parent
ON parent.id = c.parent_id
LEFT JOIN dq149_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM dq149_languages
1 × SELECT id, home, template, s.params
FROM dq149_template_styles as s
LEFT JOIN dq149_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM `dq149_jcomments_settings`
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 dq149_menu AS m
LEFT JOIN dq149_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 dq149_extensions
1 × SELECT b.id
FROM dq149_usergroups AS a
LEFT JOIN dq149_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `dq149_viewlevels
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM dq149_fields AS a
LEFT JOIN `dq149_languages` AS l
ON l.lang_code = a.language
LEFT JOIN dq149_users AS uc
ON uc.id=a.checked_out
LEFT JOIN dq149_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN dq149_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN dq149_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `dq149_fields_categories` AS fc
ON fc.field_id = a.id
Comments
but after I clicked submit my comment didn't show up. Grrrr...
well I'm not writing all that over again. Anyhow, just wanted to say
wonderful blog!
My website :: Indira
Also, many thanks for allowing for me to comment!
My web site baccarat online
website, thanks admin of this web site.
Here is my blog - {casino online
listen news on Television, thus I just use internet for that reason, and get the newest information.
Have a look at my homepage ... minecraft games (tinyurl.com)
So wonderful to find another person with
original thoughts on this subject. Really.. thanks for starting this up.
This website is something that is needed on the web, someone
with some originality! 0mniartist asmr
The place else may I am getting that kind of info written in such a perfect approach?
I've a venture that I am just now running on, and I have been on the look out
for such information. asmr 0mniartist.tumblr.com 0mniartist
RSS feed for comments to this post