Query Time: 0.80 ms Query memory: 0.025 MB Memory before query: 3.897 MB Rows returned: 0
SELECT `data`
FROM `dq149_session`
WHERE `session_id` = X'3536373562313864643366623863616332396433646138613866626166623030'
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.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.15 ms |
init | 0.06 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.19 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 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: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.88 ms After last query: 2.12 ms Query memory: 0.022 MB Memory before query: 3.999 MB Rows returned: 0
SELECT `session_id`
FROM `dq149_session`
WHERE `session_id` = X'3536373562313864643366623863616332396433646138613866626166623030'
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.16 ms |
checking permissions | 0.05 ms |
Opening tables | 0.09 ms |
init | 0.06 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.09 ms |
executing | 0.03 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 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: 41.82 ms After last query: 0.37 ms Query memory: 0.004 MB Memory before query: 4.005 MB
INSERT INTO `dq149_session`
(`session_id`,`guest`,`time`,`userid`,`username`)
VALUES
(X'3536373562313864643366623863616332396433646138613866626166623030', 1, 1611739430, 0, '')
EXPLAIN not possible on query: INSERT INTO `dq149_session`
(`session_id`,`guest`,`time`,`userid`,`username`) VALUES
(X'3536373562313864643366623863616332396433646138613866626166623030', 1, 1611739430, 0, '')
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
init | 0.04 ms |
System lock | 0.03 ms |
update | 30.08 ms |
end | 0.03 ms |
query end | 11.17 ms |
closing tables | 0.03 ms |
freeing items | 0.04 ms |
cleaning up | 0.06 ms |
# | Caller | File and line number |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.74 ms After last query: 53.93 ms Query memory: 0.029 MB Memory before query: 4.216 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.16 ms |
checking permissions | 0.03 ms |
Opening tables | 0.08 ms |
init | 0.08 ms |
System lock | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.24 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.74 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.57 ms After last query: 5.23 ms Query memory: 0.023 MB Memory before query: 4.408 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.07 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.02 ms |
query end | 0.03 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.58 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.419 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.07 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 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 |
---|
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: 2.69 ms After last query: 1.43 ms Query memory: 0.034 MB Memory before query: 4.549 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.15 ms |
checking permissions | 0.04 ms |
Opening tables | 0.04 ms |
init | 0.06 ms |
System lock | 0.05 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.05 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
Creating sort index | 1.71 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.05 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: 85.30 ms After last query: 297.89 ms Query memory: 0.261 MB Memory before query: 6.524 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.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.06 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.21 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 2.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 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.86 ms After last query: 106.02 ms Query memory: 0.027 MB Memory before query: 7.677 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.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.09 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.03 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: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: 14.77 ms After last query: 0.32 ms Query memory: 0.006 MB Memory before query: 7.670 MB
UPDATE `dq149_extensions`
SET `params` = '{\"mediaversion\":\"d3c5e52c65bba4aaf49635f74305f6a7\"}'
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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.02 ms |
System lock | 0.09 ms |
updating | 0.23 ms |
end | 0.03 ms |
query end | 14.14 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 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: 1.46 ms After last query: 85.13 ms Query memory: 0.036 MB Memory before query: 7.984 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.19 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
init | 0.07 ms |
System lock | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.25 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.20 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.07 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.85 ms After last query: 0.98 ms Query memory: 0.024 MB Memory before query: 7.989 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.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.19 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.16 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.04 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.56 ms After last query: 0.77 ms Query memory: 0.025 MB Memory before query: 8.012 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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.03 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 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.04 ms |
freeing items | 0.03 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.88 ms After last query: 90.30 ms Query memory: 0.030 MB Memory before query: 8.353 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.15 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.10 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.21 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.93 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 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: 1.02 ms After last query: 0.30 ms Query memory: 0.046 MB Memory before query: 8.400 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.05 ms |
checking permissions | 0.05 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 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: 1.38 ms After last query: 2.83 ms Query memory: 0.035 MB Memory before query: 8.615 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.33 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.02 ms |
Opening tables | 0.08 ms |
checking permissions | 0.07 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.06 ms |
closing tables | 0.03 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: 7.41 ms After last query: 91.67 ms Query memory: 0.006 MB Memory before query: 8.923 MB
UPDATE dq149_content
SET `hits` = (`hits` + 1)
WHERE `id` = '76'
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.15 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
init | 0.06 ms |
System lock | 0.09 ms |
updating | 0.47 ms |
end | 0.02 ms |
query end | 6.37 ms |
closing tables | 0.03 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: 1.68 ms After last query: 2.50 ms Query memory: 0.075 MB Memory before query: 9.049 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 = 76
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-27 09:23:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-27 09:23:51')
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.24 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.10 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.57 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.20 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 |
---|
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: 1.67 ms After last query: 2.94 ms Query memory: 0.094 MB Memory before query: 9.240 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` = 76
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.11 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.16 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.92 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: 5.64 ms After last query: 303.09 ms Query memory: 0.039 MB Memory before query: 10.418 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 = 13
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 | 28.00 | Using where |
Status | Duration |
---|
starting | 1.21 ms |
checking permissions | 0.03 ms |
checking permissions | 0.09 ms |
Opening tables | 0.59 ms |
init | 0.34 ms |
System lock | 0.03 ms |
optimizing | 0.07 ms |
statistics | 1.06 ms |
preparing | 0.13 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
Creating sort index | 0.99 ms |
end | 0.01 ms |
query end | 0.11 ms |
closing tables | 0.03 ms |
freeing items | 0.22 ms |
cleaning up | 0.04 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: 16.80 ms After last query: 278.87 ms Query memory: 0.037 MB Memory before query: 10.467 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 (13,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 | 3.19 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 2.93 ms |
init | 0.78 ms |
System lock | 0.14 ms |
optimizing | 0.25 ms |
statistics | 1.75 ms |
preparing | 0.29 ms |
Creating tmp table | 0.87 ms |
Sorting result | 0.10 ms |
executing | 0.01 ms |
Sending data | 2.65 ms |
Creating sort index | 0.42 ms |
end | 0.01 ms |
query end | 0.02 ms |
removing tmp table | 0.28 ms |
query end | 0.03 ms |
closing tables | 0.21 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 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: 2.21 ms After last query: 379.96 ms Query memory: 0.026 MB Memory before query: 10.809 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.28 ms |
checking permissions | 0.02 ms |
Opening tables | 0.25 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 0.45 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.27 ms |
end | 0.02 ms |
query end | 0.08 ms |
closing tables | 0.05 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 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: 2.95 ms After last query: 2.53 ms Query memory: 0.041 MB Memory before query: 10.830 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.55 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 0.70 ms |
preparing | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.73 ms |
end | 0.02 ms |
query end | 0.06 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 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: 2.34 ms After last query: 92.15 ms Query memory: 0.026 MB Memory before query: 10.871 MB Rows returned: 6
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 = 13
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-01-27 09:23:51')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-01-27 09:23:51')
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 | 6 | 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.30 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.12 ms |
init | 0.10 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 0.34 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.92 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 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: 92.91 ms After last query: 205.13 ms Query memory: 0.031 MB Memory before query: 11.355 MB Rows returned: 1
SELECT *
FROM `dq149_jcomments_objects`
WHERE `object_id` = '76'
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.52 ms |
checking permissions | 0.02 ms |
Opening tables | 0.43 ms |
init | 0.15 ms |
System lock | 0.07 ms |
optimizing | 0.14 ms |
statistics | 0.70 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.17 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.04 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: 3.26 ms After last query: 6.41 ms Query memory: 0.026 MB Memory before query: 11.346 MB Rows returned: 1
SELECT count(*)
FROM dq149_jcomments AS c
WHERE c.object_id = 76
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 | 27 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.30 ms |
checking permissions | 0.02 ms |
Opening tables | 0.29 ms |
init | 0.09 ms |
System lock | 0.03 ms |
optimizing | 0.14 ms |
statistics | 1.35 ms |
preparing | 0.14 ms |
executing | 0.01 ms |
Sending data | 0.19 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.08 ms |
freeing items | 0.09 ms |
cleaning up | 0.10 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: 10.64 ms After last query: 196.66 ms Query memory: 0.037 MB Memory before query: 11.370 MB Rows returned: 9
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.238.70.175'
WHERE c.object_id = 76
AND c.object_group = 'com_content'
AND c.published = 1
ORDER BY c.date ASC
LIMIT 20, 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 | 27 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 3.35 ms |
checking permissions | 0.02 ms |
checking permissions | 0.06 ms |
Opening tables | 0.94 ms |
init | 0.30 ms |
System lock | 0.04 ms |
optimizing | 0.05 ms |
statistics | 0.47 ms |
preparing | 0.06 ms |
Sorting result | 0.02 ms |
executing | 0.00 ms |
Sending data | 1.20 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 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: 1.73 ms After last query: 193.15 ms Query memory: 0.041 MB Memory before query: 11.718 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.17 ms |
checking permissions | 0.02 ms |
Opening tables | 0.25 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.73 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 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: 5.00 ms After last query: 293.42 ms Query memory: 0.034 MB Memory before query: 12.239 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-01-27 09:23:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-27 09:23:51')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 195 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.28 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.43 ms |
init | 0.18 ms |
System lock | 0.05 ms |
optimizing | 0.07 ms |
statistics | 0.75 ms |
preparing | 0.11 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 2.85 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.02 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: 189.58 ms After last query: 2499.55 ms Query memory: 0.025 MB Memory before query: 12.531 MB Rows returned: 1
SELECT metakey
FROM dq149_content
WHERE id = 76
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 | 7.76 ms |
checking permissions | 0.31 ms |
Opening tables | 4.46 ms |
init | 0.50 ms |
System lock | 0.21 ms |
optimizing | 0.28 ms |
statistics | 1.22 ms |
preparing | 0.09 ms |
executing | 0.01 ms |
Sending data | 0.13 ms |
end | 0.01 ms |
query end | 0.06 ms |
closing tables | 0.12 ms |
freeing items | 0.81 ms |
cleaning up | 0.09 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:591 |
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: 88.95 ms After last query: 114.62 ms Query memory: 0.025 MB Memory before query: 12.544 MB Rows returned: 3
SELECT a.id
FROM dq149_content AS a
WHERE a.id != 76
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.metakey LIKE '%cara Melatih Anjing Tiarap%' OR a.metakey LIKE '%cara Melatih Anjing down%' OR a.metakey LIKE '%cara Melatih Anjing flat%' OR a.metakey LIKE '%Melatih Anjing Tiarap%' OR a.metakey LIKE '%Melatih Anjing down%' OR a.metakey LIKE '%Melatih Anjing Tflat%' OR a.metakey LIKE '%melatih anjing golden tiarap%' OR a.metakey LIKE '%melatih anjing labrador tiarap%' OR a.metakey LIKE '%Cara melatih anjing%' OR a.metakey LIKE '%melatih anjing rottweiler tiarap%')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-27 09:23:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-27 09:23:51')
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 | 3.32 | Using index condition; Using where |
Status | Duration |
---|
starting | 2.54 ms |
checking permissions | 0.23 ms |
Opening tables | 0.95 ms |
init | 0.60 ms |
System lock | 0.19 ms |
optimizing | 0.19 ms |
statistics | 3.11 ms |
preparing | 0.19 ms |
executing | 0.02 ms |
Sending data | 11.76 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.07 ms |
freeing items | 0.30 ms |
cleaning up | 0.06 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:591 |
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: 16.58 ms After last query: 107.42 ms Query memory: 0.072 MB Memory before query: 12.567 MB Rows returned: 3
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 (73,75,78)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-27 09:23:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-27 09:23:51')
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 | 3 | 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 | 3.91 ms |
checking permissions | 0.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.06 ms |
Opening tables | 1.67 ms |
init | 0.72 ms |
System lock | 0.07 ms |
optimizing | 0.23 ms |
statistics | 1.27 ms |
preparing | 0.11 ms |
Sorting result | 0.06 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
Creating sort index | 5.42 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.07 ms |
freeing items | 0.28 ms |
cleaning up | 0.12 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:591 |
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: 6.37 ms After last query: 73.58 ms Query memory: 0.118 MB Memory before query: 12.677 MB Rows returned: 4
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` = 75
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.20 ms |
checking permissions | 0.01 ms |
checking permissions | 0.06 ms |
Opening tables | 0.78 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.77 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 2.99 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.03 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:591 |
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: 7.54 ms After last query: 2.74 ms Query memory: 0.086 MB Memory before query: 12.782 MB Rows returned: 4
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` = 78
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.01 ms |
Opening tables | 0.04 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.08 ms |
executing | 0.01 ms |
Sending data | 6.83 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:591 |
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: 79.60 ms After last query: 0.94 ms Query memory: 0.063 MB Memory before query: 12.887 MB Rows returned: 5
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` = 73
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.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.06 ms |
executing | 0.01 ms |
Sending data | 1.18 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 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:591 |
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: 82.76 ms After last query: 17.26 ms Query memory: 0.050 MB Memory before query: 12.640 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-01-27 09:23:51')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-27 09:23:51')
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.35 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.09 ms |
init | 0.14 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 0.60 ms |
preparing | 0.10 ms |
Sorting result | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
Creating sort index | 1.07 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: 1.94 ms After last query: 1.46 ms Query memory: 0.040 MB Memory before query: 12.730 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.31 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.34 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
Creating sort index | 0.72 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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: 1698.88 ms After last query: 9.28 ms Query memory: 0.029 MB Memory before query: 12.793 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-01-27 09:23:51')
AND (cc.publish_down = '0000-00-00 00:00:00' OR cc.publish_down >= '2021-01-27 09:23:51')
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 | 163 | 1.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.39 ms |
init | 0.18 ms |
System lock | 0.03 ms |
optimizing | 0.08 ms |
statistics | 0.41 ms |
preparing | 0.10 ms |
Creating tmp table | 0.22 ms |
Sorting result | 0.02 ms |
executing | 0.00 ms |
Sending data | 1649.15 ms |
Creating sort index | 43.72 ms |
end | 0.02 ms |
query end | 0.05 ms |
removing tmp table | 3.32 ms |
query end | 0.04 ms |
closing tables | 0.12 ms |
freeing items | 0.17 ms |
cleaning up | 0.05 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: 1.01 ms After last query: 694.44 ms Query memory: 0.046 MB Memory before query: 13.834 MB Rows returned: 321
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 | 321 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.17 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.29 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: 1.19 ms After last query: 95.63 ms Query memory: 0.007 MB Memory before query: 14.608 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.52 ms |
checking permissions | 0.02 ms |
Opening tables | 0.41 ms |
After create | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.04 ms |
freeing items | 0.02 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.43 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 14.615 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.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.09 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.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.70 ms After last query: 0.18 ms Query memory: 0.007 MB Memory before query: 14.622 MB
DELETE
FROM dq149_vvisitcounter
WHERE id<='1381556'
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 | 3 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
System lock | 0.06 ms |
updating | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.09 ms |
freeing items | 0.02 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.71 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 14.630 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE ip=UNHEX(SHA1('3.238.70.175'))
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 | 3 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.08 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.21 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.07 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 |
---|
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: 0.71 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 14.639 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 | 389 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.18 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.10 ms |
preparing | 0.02 ms |
executing | 0.01 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 |
---|
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: 1.74 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 14.647 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 | 2771 | 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.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.43 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: 2.92 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 14.655 MB Rows returned: 1
SELECT COUNT(*)
FROM dq149_vvisitcounter
WHERE tm BETWEEN 1611532800
AND 1612137600
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 | 6049 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.05 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.07 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 2.58 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: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: 22.80 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 14.663 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 | 67356 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.08 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.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 22.37 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 |
---|
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 |
Query Time: 21.81 ms After last query: 76.02 ms Query memory: 0.004 MB Memory before query: 14.971 MB
DELETE
FROM `dq149_session`
WHERE `time` < 1611738539
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | DELETE | dq149_session | NULL | ALL | time | NO INDEX KEY COULD BE USED | NULL | NULL | 100 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.10 ms |
updating | 7.30 ms |
end | 0.01 ms |
query end | 14.13 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
cleaning up | 0.03 ms |
# | Caller | File and line number |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/session/storage/database.php:156 |
7 | JSessionStorageDatabase->gc() | JROOT/libraries/src/Session/Session.php:836 |
6 | Joomla\CMS\Session\Session->gc() | JROOT/plugins/system/sessiongc/sessiongc.php:60 |
5 | PlgSystemSessionGc->onAfterRespond() | JROOT/libraries/joomla/event/event.php:70 |
4 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
3 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
2 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:218 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × SELECT COUNT(*)
FROM dq149_vvisitcounter
4 × SELECT `m`.`tag_id`,`t`.*
FROM `dq149_contentitem_tag_map` AS m
INNER JOIN `dq149_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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)
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.238.70.175'
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
Biasakan dengan cara melatih berulang ulang,agar daspat menyeimbangkan dirinya, berikan hukuman bi la baru berdiri sudah langsung turun lagi. posisikan anjing dari duduk dan baru UP nya.untuk melatih stay, mis pada posisi duduk.perinytah kan anjingnya duduk, kemudian berikan upah saat dia melakukan perintah dengan baik,kemudian perintahkan dengan stay.dan anda berkeliling melingk
ari anjing yang se dang duduk, sambil selalu mengatakan stay berulang ulang dan sesekali memuji dengan mengusap kepalan ya.berikan hukuman saat dianda mengelilingi dan dia bangun, (untu lebih jelas dalam praktek anda dap at melihat didalm cd yang telah disediakan.)
Salam
Darrylkosambipet
Aku punya anjing pom sekitar umurn 5 bulan
Namanya chesy
Dari pertama beli umur 2bln sampe sekarang
Sering banget gigit tangan aku. Gigit ya gak beneran.
Sampe umurn brp bulan yaa dia gak gigit" ?
Di samping itu aku juga mau beli anjing lagi , karena aku pemula aku sedikit nyesel beli anjing laki" susah di atur,
Lebih baik p elihara anjing betina atau jantan ?
Apakah beda
perilaku betina dengan jantan ?
Terima kasih sebelumnya
Untuk pelihara anjing betina dan jantan sama saja, yang penting dari kecil diajar dengan kepatuhannya,anjing yang aktif dan bandel biasanya anjing yang mudah dilatih. kalau temperamen itu tdk dapat dihilangan seumur hidupnya, karena ini menjadi karakter si anjing, kalau pelatih, selalu mancari anjing yang aktif,bila sering diajak bercanda dengan memainkan tangan anda, si anjing berarti sam
a saja dilatih dengan cara menggigit tangan anda, apa bila saat dia menggigit anda pencet lidahnya atau disentil hidungnya, secara atomatis sianjing akan tidak berani menggigit lag dikarnakan saat menggigit tangan lidahnya dipencet,dan dia merasakan sakit,demikian sedikit penjelsan dari saya.
Salam
Darrylkosambipet
Aku jg gatau usianya brp krn dikasih kakak, mungkin sekitar 7 bulanan. Aku pernah ngelatih dia buat nangkepin bola yg aku lempar, kalo aku suruh ambil bolanya dia bakal ngambil bola itu, tapi kalau dia udh datang trus bolanya aku minta dia malah kabur dan kalau ngambilnya itu musti di rebu t dulu atau tunggu sampai dia berhenti main sm bo
lanya..
cara ngelatihnya Kimo yg baik gimana yah?
2.Trus Kimora jg punya 1 masalah, dia itu malas bgt sama yg namanya makan, aku gtw dia makan jenis makanan apa, soalnya udh dikasih bermacam" makanan anjing ttp aja dia g mau makan, maksudnya makan sih makan tpi kadang mau kadang ngga. tapi efek samping nya itu dia malah suka garuk" badannya. itu dia alergi atau bagaimana yah?
Untuk melati anjing biasakan dengan tali panjang agar anjing tidak membawa lari bolanya,ambil bolanya dan berikan upahnya, sebagai mana contoh yang telah diberikan saat melati.
Salam
Darrylkosambipet
dia bisa naik turun tangga sebenernya, tapi masalahnya kaya suka males gitu..
kebetulan tangga rumah digarasi doang adanya, kadang aku suka duduk disitu sambil ngelatih yg beagle.
dia suka naik turun duduk disamping aku, tapi kadang kalo lagi gimana dia mau naik tapi gamau turun, meskipun di tinggal sampe 2 jam tetep aja duduk disitu kaya mau turun tapi
takut, bahkan sampe nangis" gitu.. padahal biasanya bisa.. itu kenapa dan gimana cara biasainnya ?
Panggil dan berikan makanan, sehingga dia akan menganggap selalu akan diberikan pakan bila naik
Salam
Darrylkosambipet
for newest updates.
main disbobet indonesia
Feeel freee too vijsit my weeb site - bandar taruhan sbobert (Jodie)
RSS feed for comments to this post