Assign modules on offcanvas module position to make them visible in the sidebar.
reducedtoclear.store - Best local shopping portal!
Here you will find affordable and useful items.
Advanced search
//
Contact Us
+44 (0) 7952789994
Information
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1765206540,
"last": 1765206540,
"now": 1765206540
},
"token": "uCuBCfeESujJsOKCNS2iywmzuCwiVtHP"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 28.17 ms / 28.17 ms Memory: 2.012 MB / 2.40 MB Application: afterLoad
Time: 58.65 ms / 86.81 ms Memory: 4.181 MB / 6.58 MB Application: afterInitialise
Time: 56.47 ms / 143.28 ms Memory: 2.409 MB / 8.99 MB Application: afterRoute
Time: 1.51 ms / 144.79 ms Memory: 0.032 MB / 9.02 MB Application: beforeRenderComponent com_content
Time: 5.18 ms / 149.97 ms Memory: 0.455 MB / 9.47 MB Application: Before Access::preloadComponents (all components)
Time: 1.16 ms / 151.13 ms Memory: 0.062 MB / 9.54 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 151.16 ms Memory: -0.003 MB / 9.53 MB Application: Before Access::preloadPermissions (com_content)
Time: 0.98 ms / 152.14 ms Memory: 0.056 MB / 9.59 MB Application: After Access::preloadPermissions (com_content)
Time: 0.03 ms / 152.17 ms Memory: -0.002 MB / 9.59 MB Application: Before Access::getAssetRules (id:366 name:com_content.article.108)
Time: 0.66 ms / 152.83 ms Memory: 0.026 MB / 9.61 MB Application: After Access::getAssetRules (id:366 name:com_content.article.108)
Time: 46.13 ms / 198.96 ms Memory: 2.835 MB / 12.45 MB Application: afterRenderComponent com_content
Time: 0.30 ms / 199.26 ms Memory: 0.006 MB / 12.46 MB Application: afterDispatch
Time: 26.74 ms / 226.00 ms Memory: 1.738 MB / 14.19 MB Application: beforeRenderModule mod_custom (Contact Us)
Time: 0.91 ms / 226.91 ms Memory: 0.034 MB / 14.23 MB Application: afterRenderModule mod_custom (Contact Us)
Time: 0.08 ms / 226.99 ms Memory: 0.003 MB / 14.23 MB Application: beforeRenderModule mod_menu (Information)
Time: 2.37 ms / 229.36 ms Memory: 0.082 MB / 14.31 MB Application: afterRenderModule mod_menu (Information)
Time: 3.52 ms / 232.88 ms Memory: 0.275 MB / 14.59 MB Application: beforeRenderModule mod_custom (Copyrights)
Time: 2.06 ms / 234.94 ms Memory: 0.022 MB / 14.61 MB Application: afterRenderModule mod_custom (Copyrights)
Time: 0.07 ms / 235.01 ms Memory: 0.005 MB / 14.61 MB Application: beforeRenderModule mod_djclassifieds_items (Most Recent Ads)
Time: 9.55 ms / 244.55 ms Memory: 0.580 MB / 15.19 MB Application: afterRenderModule mod_djclassifieds_items (Most Recent Ads)
Time: 0.07 ms / 244.63 ms Memory: -0.010 MB / 15.18 MB Application: beforeRenderModule mod_djclassifieds_menu (Tags)
Time: 2.41 ms / 247.04 ms Memory: 0.098 MB / 15.28 MB Application: afterRenderModule mod_djclassifieds_menu (Tags)
Time: 0.06 ms / 247.09 ms Memory: -0.027 MB / 15.25 MB Application: beforeRenderModule mod_custom (Header Slogan Front)
Time: 0.26 ms / 247.35 ms Memory: 0.003 MB / 15.26 MB Application: afterRenderModule mod_custom (Header Slogan Front)
Time: 0.04 ms / 247.39 ms Memory: 0.003 MB / 15.26 MB Application: beforeRenderModule mod_djclassifieds_search (Header Search Front )
Time: 9.94 ms / 257.33 ms Memory: 0.444 MB / 15.70 MB Application: afterRenderModule mod_djclassifieds_search (Header Search Front )
Time: 0.04 ms / 257.37 ms Memory: -0.066 MB / 15.64 MB Application: beforeRenderModule mod_custom (Header Search Front Advanced)
Time: 0.30 ms / 257.67 ms Memory: 0.003 MB / 15.64 MB Application: afterRenderModule mod_custom (Header Search Front Advanced)
Time: 0.09 ms / 257.76 ms Memory: 0.003 MB / 15.64 MB Application: beforeRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)
Time: 0.41 ms / 258.17 ms Memory: 0.008 MB / 15.65 MB Application: afterRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)
Time: 0.03 ms / 258.19 ms Memory: -0.002 MB / 15.65 MB Application: beforeRenderModule mod_menu (Top-bar Guest)
Time: 2.08 ms / 260.28 ms Memory: 0.021 MB / 15.67 MB Application: afterRenderModule mod_menu (Top-bar Guest)
Time: 0.03 ms / 260.31 ms Memory: -0.002 MB / 15.67 MB Application: beforeRenderModule mod_menu (Top-bar Front Mobile)
Time: 0.70 ms / 261.01 ms Memory: 0.008 MB / 15.68 MB Application: afterRenderModule mod_menu (Top-bar Front Mobile)
Time: 0.05 ms / 261.06 ms Memory: -0.003 MB / 15.68 MB Application: beforeRenderModule mod_custom (Offcanvas Info)
Time: 0.24 ms / 261.29 ms Memory: 0.003 MB / 15.68 MB Application: afterRenderModule mod_custom (Offcanvas Info)
Time: 0.03 ms / 261.32 ms Memory: -0.000 MB / 15.68 MB Application: beforeRenderModule mod_menu (Categories)
Time: 2.17 ms / 263.49 ms Memory: 0.019 MB / 15.70 MB Application: afterRenderModule mod_menu (Categories)
Time: 0.05 ms / 263.54 ms Memory: 0.001 MB / 15.70 MB Application: beforeRenderModule mod_djclassifieds_items (Most Popular)
Time: 2.40 ms / 265.93 ms Memory: 0.016 MB / 15.71 MB Application: afterRenderModule mod_djclassifieds_items (Most Popular)
Time: 4.82 ms / 270.75 ms Memory: 0.121 MB / 15.84 MB Application: afterRender
Database queries total: 33.78 ms
16.42 MB (17,216,464 Bytes)
32 Queries Logged 33.78 ms
- Query Time: 0.81 ms Query memory: 0.007 MB Memory before query: 4.121 MB Rows returned: 0
SELECT `data`
FROM `chlko_session`
WHERE `session_id` = X'3231313065653466336231396433353630376663656339623166386531333037'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_session const PRIMARY PRIMARY 766 const 1 Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.04 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.10 ms Updating status 0.04 ms Reset for next command 0.04 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:47 - Query Time: 0.70 ms After last query: 1.34 ms Query memory: 0.004 MB Memory before query: 4.216 MB Rows returned: 0
SELECT `session_id`
FROM `chlko_session`
WHERE `session_id` = X'3231313065653466336231396433353630376663656339623166386531333037'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.05 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.06 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.04 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:47 - Query Time: 0.90 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 4.221 MB
INSERT INTO `chlko_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3231313065653466336231396433353630376663656339623166386531333037', 1, 1765206540, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `chlko_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3231313065653466336231396433353630376663656339623166386531333037', 1, 1765206540, 0, '', 0)Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.02 ms Update 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.31 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.10 ms Updating status 0.03 ms Reset for next command 0.05 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:47 - Query Time: 1.06 ms After last query: 3.01 ms Query memory: 0.006 MB Memory before query: 4.410 MB Rows returned: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `chlko_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_extensions ref extension extension 62 const 34 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.06 ms Statistics 0.09 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.31 ms End of update loop 0.05 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.05 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.03 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.63 ms After last query: 2.91 ms Query memory: 0.005 MB Memory before query: 4.679 MB Rows returned: 5
SELECT id, rules
FROM `chlko_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.03 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.07 ms Updating status 0.02 ms Reset for next command 0.02 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.84 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 4.691 MB Rows returned: 2
SELECT b.id
FROM chlko_usergroups AS a
LEFT JOIN chlko_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.09 ms checking permissions 0.04 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.04 ms Unlocking tables 0.03 ms Preparing 0.05 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.46 ms After last query: 0.71 ms Query memory: 0.005 MB Memory before query: 4.760 MB Rows returned: 107
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM chlko_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 274 Using where; Using filesort Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.07 ms Statistics 0.08 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.73 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.03 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.03 ms Reset for next command 0.02 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:351 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:356 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.87 ms After last query: 24.57 ms Query memory: 0.009 MB Memory before query: 6.764 MB Rows returned: 79
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 chlko_menu AS m
LEFT JOIN chlko_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 87 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 nrihelpd_joom467.m.component_id 1 Using where Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.95 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.04 ms Reset for next command 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:78 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:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 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:1141 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.25 ms After last query: 35.92 ms Query memory: 0.009 MB Memory before query: 7.954 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `chlko_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using index condition Status Duration Starting 0.37 ms checking permissions 0.11 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.20 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.09 ms Updating status 0.02 ms Reset for next command 0.04 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/djjquerymonster/djjquerymonster.php:58 8 plgSystemDJjQueryMonster->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.84 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 7.947 MB
UPDATE `chlko_extensions`
SET `params` = '{\"mediaversion\":\"30a86addb3bf746da9d196ebecd9d286\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `chlko_extensions` SET `params` = '{\"mediaversion\":\"30a86addb3bf746da9d196ebecd9d286\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.13 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.23 ms Updating 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.07 ms Updating status 0.02 ms Reset for next command 0.04 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58 8 plgSystemDJjQueryMonster->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.18 ms After last query: 2.10 ms Query memory: 0.006 MB Memory before query: 8.188 MB Rows returned: 5
SELECT id, home, template, s.params
FROM chlko_template_styles as s
LEFT JOIN chlko_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 62 const 5 Using index condition; Using where 1 SIMPLE s ref|filter idx_template,idx_client_id,idx_client_id_home idx_template|idx_client_id 152|1 nrihelpd_joom467.e.element 1 (71%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.18 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.04 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.06 ms Executing 0.02 ms Sending data 0.20 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.11 ms Updating status 0.04 ms Reset for next command 0.03 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/plugins/system/ef4_jmframework/ef4_jmframework.php:1018 9 plgSystemEF4_JMFramework->getTemplateName() JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209 8 plgSystemEF4_JMFramework->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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.06 ms After last query: 11.00 ms Query memory: 0.003 MB Memory before query: 9.000 MB Rows returned: 2
SELECT *
FROM chlko_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort Status Duration Starting 0.27 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.04 ms System lock 0.05 ms table lock 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.08 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.08 ms Updating status 0.03 ms Reset for next command 0.03 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.96 ms After last query: 5.52 ms Query memory: 0.009 MB Memory before query: 9.479 MB Rows returned: 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `chlko_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djclassifieds','com_djmediatools','com_djreviews','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 189 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.23 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.04 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:457 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.84 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 9.534 MB Rows returned: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `chlko_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 189 Using where Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.04 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.16 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.07 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.07 ms Updating status 0.02 ms Reset for next command 0.04 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:457 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.59 ms After last query: 1.48 ms Query memory: 0.007 MB Memory before query: 9.654 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `chlko_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `chlko_content`Status Duration Starting 0.09 ms checking permissions 0.02 ms closing tables 0.09 ms Opening tables 0.38 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.23 ms closing tables 0.03 ms Executing 0.01 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.19 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 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:328 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.63 ms After last query: 3.70 ms Query memory: 0.005 MB Memory before query: 9.962 MB
UPDATE chlko_content
SET `hits` = (`hits` + 1)
WHERE `id` = '108'EXPLAIN not possible on query: UPDATE chlko_content SET `hits` = (`hits` + 1) WHERE `id` = '108'Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.05 ms Updating 0.07 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.03 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.09 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.13 ms After last query: 1.71 ms Query memory: 0.007 MB Memory before query: 10.087 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 chlko_content AS a
INNER JOIN chlko_categories AS c
on c.id = a.catid
LEFT JOIN chlko_users AS u
on u.id = a.created_by
LEFT JOIN chlko_categories as parent
ON parent.id = c.parent_id
LEFT JOIN chlko_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 108
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-08 15:09:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-08 15:09:00')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.23 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.04 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.81 ms After last query: 2.07 ms Query memory: 0.006 MB Memory before query: 10.199 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `chlko_contentitem_tag_map` AS m
INNER JOIN `chlko_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 108
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 2 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nrihelpd_joom467.m.tag_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.09 ms Optimizing 0.06 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.04 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.11 ms After last query: 10.66 ms Query memory: 0.010 MB Memory before query: 11.089 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 `chlko_categories` AS `s`
INNER JOIN `chlko_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 = 82
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 9 Using where; Using filesort Status Duration Starting 0.19 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.11 ms End of update loop 0.05 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 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:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.81 ms After last query: 0.52 ms Query memory: 0.009 MB Memory before query: 11.135 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 chlko_fields AS a
LEFT JOIN `chlko_languages` AS l
ON l.lang_code = a.language
LEFT JOIN chlko_users AS uc
ON uc.id=a.checked_out
LEFT JOIN chlko_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN chlko_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN chlko_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `chlko_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 (82,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.16 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.04 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:322 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:194 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 2.88 ms After last query: 7.32 ms Query memory: 0.010 MB Memory before query: 11.760 MB Rows returned: 40
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM chlko_modules AS m
LEFT JOIN chlko_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN chlko_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 <= '2025-12-08 15:09:00')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-08 15:09:00')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 470 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 53 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 nrihelpd_joom467.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 nrihelpd_joom467.m.id 10 Using where; Using index Status Duration Starting 0.19 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.98 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.10 ms Updating status 0.02 ms Reset for next command 0.03 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() 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/libraries/src/Helper/ModuleHelper.php:441 18 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 17 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 16 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/djsuggester/helpers/helperversion.php:841 15 DJSuggesterHelper::loadModules() JROOT/plugins/content/djsuggester/helpers/helperversion.php:82 14 DJSuggesterHelper::handleModules() JROOT/plugins/content/djsuggester/djsuggester.php:85 13 plgContentDJSuggester->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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.78 ms After last query: 19.42 ms Query memory: 0.006 MB Memory before query: 12.718 MB Rows returned: 7
SELECT id
FROM chlko_template_styles
ORDER BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_template_styles index NULL PRIMARY 4 NULL 7 Using index Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.05 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329 9 JMFTemplate->setup() JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126 8 JMFTemplate->__construct() JROOT/templates/jm-joomclassifieds-ef4/index.php:18 7 require JROOT/templates/jm-joomclassifieds-ef4/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.32 ms After last query: 24.64 ms Query memory: 0.010 MB Memory before query: 14.619 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 chlko_fields AS a
LEFT JOIN `chlko_languages` AS l
ON l.lang_code = a.language
LEFT JOIN chlko_users AS uc
ON uc.id=a.checked_out
LEFT JOIN chlko_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN chlko_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN chlko_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
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 ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.42 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.07 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.03 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.06 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.03 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.07 ms After last query: 6.04 ms Query memory: 0.007 MB Memory before query: 15.153 MB Rows returned: 14Duplicate queries: #27
SELECT *
FROM chlko_djcf_categories
WHERE published=1
AND access_view IN (1,1,5)
ORDER BY parent_id, ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_djcf_categories ALL published NO INDEX KEY COULD BE USED NULL NULL 14 Using where; Using filesort Status Duration Starting 0.15 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.17 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.06 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:550 14 DJClassifiedsCategory::getAllCategories() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:589 13 DJClassifiedsCategory::getCategoriesSortParent() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201 12 DJClassifiedsCategory::getSubCat() JROOT/modules/mod_djclassifieds_items/helper.php:142 11 modDjClassifiedsItems::getItems() JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:53 10 include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.28 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 15.203 MB Rows returned: 0
SELECT cat_id, count(*) as items_count
FROM (SELECT i.cat_id
FROM chlko_djcf_items i
WHERE i.published=1
AND i.blocked=0
AND i.date_exp > '2025-12-08 15:00:00' UNION ALL SELECT ic.cat_id
FROM chlko_djcf_items_categories ic
INNER JOIN chlko_djcf_items i
ON ic.item_id=i.id
WHERE i.published=1
AND i.blocked=0
AND i.date_exp > '2025-12-08 15:00:00' ) v
GROUP BY cat_idid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> ALL NULL NO INDEX KEY COULD BE USED NULL NULL 31 Using temporary; Using filesort 2 DERIVED i ALL published,blocked NO INDEX KEY COULD BE USED NULL NULL 30 Using where 3 UNION NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL no matching row in const table Status Duration Starting 0.14 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.07 ms Optimizing 0.02 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.06 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.12 ms Executing 0.02 ms Removing tmp table 0.01 ms Executing 0.02 ms Creating sort index 0.02 ms Removing tmp table 0.02 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.04 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:521 14 DJClassifiedsCategory::setItemsCount() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:590 13 DJClassifiedsCategory::getCategoriesSortParent() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:201 12 DJClassifiedsCategory::getSubCat() JROOT/modules/mod_djclassifieds_items/helper.php:142 11 modDjClassifiedsItems::getItems() JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:53 10 include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.23 ms After last query: 0.15 ms Query memory: 0.006 MB Memory before query: 15.214 MB Rows returned: 0
SELECT i.*,c.id as c_id, c.name as c_name,c.alias as c_alias,c.icon_url as c_icon_url, r.id as r_id, r.name as r_name, r.alias as r_alias
FROM chlko_djcf_categories c, chlko_djcf_items i
LEFT JOIN ( SELECT item_id, count(id) as mcat_c
FROM chlko_djcf_items_categories
WHERE cat_id IN (18,15,16,17)
GROUP BY item_id ) mc
ON i.id=mc.item_id
LEFT JOIN chlko_djcf_regions r
ON r.id=i.region_id
WHERE i.published=1
AND i.date_exp > '2025-12-08 15:09:00'
AND i.blocked=0
AND c.published = 1
AND i.cat_id=c.id
AND (i.cat_id IN (0,18,15,16,17) OR mc.mcat_c>0)
AND c.access_view IN (0,1,1,5)
AND c.restriction_18=0
ORDER BY i.date_sort DESC
limit 18id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 0 Const row not found 1 PRIMARY i ALL cat_id,published,blocked NO INDEX KEY COULD BE USED NULL NULL 30 Using where; Using filesort 1 PRIMARY c eq_ref PRIMARY,published PRIMARY 4 nrihelpd_joom467.i.cat_id 1 Using where 1 PRIMARY r eq_ref PRIMARY PRIMARY 4 nrihelpd_joom467.i.region_id 1 2 DERIVED NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL no matching row in const table Status Duration Starting 0.16 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.09 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Statistics 0.09 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Removing tmp table 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.03 ms Freeing items 0.06 ms Updating status 0.02 ms Reset for next command 0.07 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_djclassifieds_items/helper.php:348 11 modDjClassifiedsItems::getItems() JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:53 10 include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.75 ms After last query: 0.99 ms Query memory: 0.009 MB Memory before query: 15.256 MB Rows returned: 14Duplicate queries: #24
SELECT *
FROM chlko_djcf_categories
WHERE published=1
AND access_view IN (1,1,5)
ORDER BY parent_id, ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_djcf_categories ALL published NO INDEX KEY COULD BE USED NULL NULL 14 Using where; Using filesort Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.03 ms Optimizing 0.05 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.10 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.04 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:550 15 DJClassifiedsCategory::getAllCategories() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:564 14 DJClassifiedsCategory::getCategories() JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:316 13 DJClassifiedsCategory::getSEOParentPath() JROOT/administrator/components/com_djclassifieds/lib/djseo.php:139 12 DJClassifiedsSEO::getCategoryRoute() JROOT/modules/mod_djclassifieds_menu/tmpl/default.php:80 11 require JROOT/modules/mod_djclassifieds_menu/tmpl/default.php JROOT/modules/mod_djclassifieds_menu/mod_djclassifieds_menu.php:121 10 include JROOT/modules/mod_djclassifieds_menu/mod_djclassifieds_menu.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.77 ms After last query: 4.88 ms Query memory: 0.006 MB Memory before query: 15.502 MB Rows returned: 14
SELECT *
FROM chlko_djcf_categories
WHERE published=1
ORDER BY parent_id, orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE chlko_djcf_categories ALL published NO INDEX KEY COULD BE USED NULL NULL 14 Using where; Using filesort Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.11 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.03 ms closing tables 0.05 ms Starting cleanup 0.01 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_djclassifieds_search/helper.php:35 11 modDjClassifiedsSearch::getCats() JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:77 10 include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.68 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 15.550 MB Rows returned: 13
SELECT r.*
FROM chlko_djcf_regions r
WHERE r.published=1
ORDER BY r.parent_id, r.ordering, r.name COLLATE utf8_polish_ciid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ALL published NO INDEX KEY COULD BE USED NULL NULL 20 Using where; Using filesort Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.02 ms Reset for next command 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/components/com_djclassifieds/model.php:110 11 DJClassifiedsModel->getRegions() JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:108 10 include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.58 ms After last query: 0.09 ms Query memory: 0.006 MB Memory before query: 15.577 MB Rows returned: 4
SELECT t.id as value, t.name as text, '0' as disabled
FROM chlko_djcf_types t
WHERE t.published=1
ORDER BY t.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Using where; Using filesort Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.02 ms Reset for next command 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_djclassifieds_search/helper.php:60 11 modDjClassifiedsSearch::getTypes() JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:111 10 include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 0.56 ms After last query: 0.04 ms Query memory: 0.006 MB Memory before query: 15.586 MB Rows returned: 0
SELECT g.*
FROM chlko_djcf_fields_groups g
WHERE g.source=2
AND g.published=1
ORDER BY g.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.04 ms Updating status 0.02 ms Reset for next command 0.03 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_djclassifieds_search/helper.php:74 11 modDjClassifiedsSearch::getProfileGroups() JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:112 10 include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50 - Query Time: 1.41 ms After last query: 10.53 ms Query memory: 0.006 MB Memory before query: 15.733 MB Rows returned: 0
SELECT i.*,c.id as c_id, c.name as c_name,c.alias as c_alias,c.icon_url as c_icon_url, r.id as r_id, r.name as r_name, r.alias as r_alias
FROM chlko_djcf_categories c, chlko_djcf_items i
LEFT JOIN chlko_djcf_regions r
ON r.id=i.region_id
WHERE i.published=1
AND i.date_exp > '2025-12-08 15:09:00'
AND i.blocked=0
AND c.published = 1
AND i.cat_id=c.id
AND c.access_view IN (0,1,1,5)
AND c.restriction_18=0
ORDER BY i.display DESC
limit 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i range cat_id,published,blocked published 4 NULL 30 Using index condition; Using where; Using filesort 1 SIMPLE c eq_ref PRIMARY,published PRIMARY 4 nrihelpd_joom467.i.cat_id 1 Using where 1 SIMPLE r eq_ref PRIMARY PRIMARY 4 nrihelpd_joom467.i.region_id 1 Status Duration Starting 0.23 ms checking permissions 0.04 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.05 ms Creating sort index 0.24 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.11 ms Updating status 0.02 ms Reset for next command 0.06 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_djclassifieds_items/helper.php:348 11 modDjClassifiedsItems::getItems() JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:53 10 include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:50
28 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT *
FROM chlko_djcf_categories2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `chlko_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `chlko_assets`1 × SELECT `data`
FROM `chlko_session`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM chlko_modules AS m
LEFT JOIN chlko_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN chlko_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT g.*
FROM chlko_djcf_fields_groups g1 × SELECT t.id as value, t.name as text, '0' as disabled
FROM chlko_djcf_types t1 × SELECT r.*
FROM chlko_djcf_regions r1 × SELECT i.*,c.id as c_id, c.name as c_name,c.alias as c_alias,c.icon_url as c_icon_url, r.id as r_id, r.name as r_name, r.alias as r_alias
FROM chlko_djcf_categories c, chlko_djcf_items i
LEFT JOIN ( SELECT item_id, count(id) as mcat_c
FROM chlko_djcf_items_categories1 × SELECT cat_id, count(*) as items_count
FROM (SELECT i.cat_id
FROM chlko_djcf_items i1 × 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 chlko_fields AS a
LEFT JOIN `chlko_languages` AS l
ON l.lang_code = a.language
LEFT JOIN chlko_users AS uc
ON uc.id=a.checked_out
LEFT JOIN chlko_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN chlko_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN chlko_fields_groups AS g
ON g.id = a.group_id1 × SELECT id
FROM chlko_template_styles1 × 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 `chlko_categories` AS `s`
INNER JOIN `chlko_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)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 chlko_fields AS a
LEFT JOIN `chlko_languages` AS l
ON l.lang_code = a.language
LEFT JOIN chlko_users AS uc
ON uc.id=a.checked_out
LEFT JOIN chlko_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN chlko_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN chlko_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `chlko_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `session_id`
FROM `chlko_session`1 × SELECT `m`.`tag_id`,`t`.*
FROM `chlko_contentitem_tag_map` AS m
INNER JOIN `chlko_tags` AS t
ON `m`.`tag_id` = `t`.`id`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 chlko_content AS a
INNER JOIN chlko_categories AS c
on c.id = a.catid
LEFT JOIN chlko_users AS u
on u.id = a.created_by
LEFT JOIN chlko_categories as parent
ON parent.id = c.parent_id
LEFT JOIN chlko_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM chlko_languages1 × SELECT id, home, template, s.params
FROM chlko_template_styles as s
LEFT JOIN chlko_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 chlko_menu AS m
LEFT JOIN chlko_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM chlko_extensions1 × SELECT b.id
FROM chlko_usergroups AS a
LEFT JOIN chlko_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `chlko_viewlevels1 × SELECT i.*,c.id as c_id, c.name as c_name,c.alias as c_alias,c.icon_url as c_icon_url, r.id as r_id, r.name as r_name, r.alias as r_alias
FROM chlko_djcf_categories c, chlko_djcf_items i
LEFT JOIN chlko_djcf_regions r
ON r.id=i.region_id
OTHER Tables:
1 × INSERT INTO `chlko_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3231313065653466336231396433353630376663656339623166386531333037', 1, 1765206540, 0, '', 01 × UPDATE `chlko_extensions`
SET `params` = '{\"mediaversion\":\"30a86addb3bf746da9d196ebecd9d286\"}'1 × SHOW FULL COLUMNS
FROM `chlko_content1 × UPDATE chlko_content
SET `hits` = (`hits` + 1)