Porsche - Cars - Adults only

Assign modules on offcanvas module position to make them visible in the sidebar.

Classifieds Map

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1765206757,
                "last": 1765206757,
                "now": 1765206757
            },
            "token": "plaL1kQXR4aVWGljSkynAX7iPSQdIvTr"
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 21.82 ms / 21.82 ms Memory: 2.012 MB / 2.40 MB Application: afterLoad

Time: 51.59 ms / 73.41 ms Memory: 4.181 MB / 6.58 MB Application: afterInitialise

Time: 64.41 ms / 137.82 ms Memory: 2.566 MB / 9.15 MB Application: afterRoute

Time: 1.49 ms / 139.31 ms Memory: 0.054 MB / 9.20 MB Application: beforeRenderComponent com_djclassifieds

Time: 47.41 ms / 186.72 ms Memory: 2.759 MB / 11.96 MB Application: afterRenderComponent com_djclassifieds

Time: 1.46 ms / 188.17 ms Memory: 0.100 MB / 12.06 MB Application: afterDispatch

Time: 39.24 ms / 227.42 ms Memory: 1.761 MB / 13.82 MB Application: beforeRenderModule mod_djclassifieds_maps (Classifieds Map)

Time: 8.43 ms / 235.85 ms Memory: 0.196 MB / 14.02 MB Application: afterRenderModule mod_djclassifieds_maps (Classifieds Map)

Time: 0.23 ms / 236.08 ms Memory: -0.023 MB / 13.99 MB Application: beforeRenderModule mod_djclassifieds_menu (Categories)

Time: 2.16 ms / 238.24 ms Memory: 0.044 MB / 14.04 MB Application: afterRenderModule mod_djclassifieds_menu (Categories)

Time: 0.08 ms / 238.31 ms Memory: -0.027 MB / 14.01 MB Application: beforeRenderModule mod_djclassifieds_regions (Regions)

Time: 8.51 ms / 246.83 ms Memory: 0.207 MB / 14.22 MB Application: afterRenderModule mod_djclassifieds_regions (Regions)

Time: 0.10 ms / 246.93 ms Memory: -0.009 MB / 14.21 MB Application: beforeRenderModule mod_djclassifieds_search (Search)

Time: 9.63 ms / 256.56 ms Memory: 0.275 MB / 14.48 MB Application: afterRenderModule mod_djclassifieds_search (Search)

Time: 1.62 ms / 258.18 ms Memory: -0.072 MB / 14.41 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 0.64 ms / 258.83 ms Memory: 0.007 MB / 14.42 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 0.11 ms / 258.94 ms Memory: 0.002 MB / 14.42 MB Application: beforeRenderModule mod_menu (Information)

Time: 2.50 ms / 261.44 ms Memory: 0.057 MB / 14.48 MB Application: afterRenderModule mod_menu (Information)

Time: 5.06 ms / 266.50 ms Memory: 0.275 MB / 14.75 MB Application: beforeRenderModule mod_custom (Copyrights)

Time: 18.67 ms / 285.17 ms Memory: 1.026 MB / 15.78 MB Application: afterRenderModule mod_custom (Copyrights)

Time: 0.11 ms / 285.28 ms Memory: -0.001 MB / 15.78 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.13 ms / 286.41 ms Memory: 0.028 MB / 15.80 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.09 ms / 286.50 ms Memory: -0.005 MB / 15.80 MB Application: beforeRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)

Time: 0.45 ms / 286.95 ms Memory: 0.008 MB / 15.81 MB Application: afterRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)

Time: 0.03 ms / 286.97 ms Memory: -0.002 MB / 15.80 MB Application: beforeRenderModule mod_menu (Top-bar Guest)

Time: 2.22 ms / 289.19 ms Memory: 0.022 MB / 15.83 MB Application: afterRenderModule mod_menu (Top-bar Guest)

Time: 0.05 ms / 289.25 ms Memory: -0.003 MB / 15.82 MB Application: beforeRenderModule mod_custom (Offcanvas Info)

Time: 0.25 ms / 289.49 ms Memory: 0.003 MB / 15.83 MB Application: afterRenderModule mod_custom (Offcanvas Info)

Time: 0.03 ms / 289.52 ms Memory: -0.000 MB / 15.83 MB Application: beforeRenderModule mod_menu (Categories)

Time: 1.84 ms / 291.37 ms Memory: 0.019 MB / 15.85 MB Application: afterRenderModule mod_menu (Categories)

Time: 0.04 ms / 291.41 ms Memory: 0.001 MB / 15.85 MB Application: beforeRenderModule mod_djclassifieds_items (Most Popular)

Time: 2.77 ms / 294.17 ms Memory: 0.078 MB / 15.92 MB Application: afterRenderModule mod_djclassifieds_items (Most Popular)

Time: 5.65 ms / 299.82 ms Memory: 0.274 MB / 16.20 MB Application: afterRender

Database queries total: 43.68 ms

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.23 ms
checking permissions	0.04 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.04 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_session	const	PRIMARY	PRIMARY	766	const	1	Using index

#	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

EXPLAIN not possible on query: INSERT INTO `chlko_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3531383037663231353864323663633738376663393833353835306534633732', 1, 1765206757, 0, '', 0)

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.02 ms
Update	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.21 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.05 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.17 ms After last query: 2.58 ms Query memory: 0.006 MB Memory before query: 4.412 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` = 1

Explain

id	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

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.37 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.06 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.64 ms After last query: 2.37 ms Query memory: 0.005 MB Memory before query: 4.681 MB Rows returned: 5

SELECT id, rules

  FROM `chlko_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.05 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.03 ms
Statistics	0.02 ms
Preparing	0.02 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.04 ms
Reset for next command	0.04 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.89 ms After last query: 0.09 ms Query memory: 0.005 MB Memory before query: 4.693 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 = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.08 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.03 ms
Optimizing	0.03 ms
Statistics	0.18 ms
Preparing	0.05 ms
Unlocking tables	0.02 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.03 ms
closing tables	0.02 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.05 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.38 ms After last query: 0.82 ms Query memory: 0.005 MB Memory before query: 4.761 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 ordering

Explain

id	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

Profile

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.02 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.62 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.04 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.25 ms After last query: 21.52 ms Query memory: 0.009 MB Memory before query: 6.766 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.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	87	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	nrihelpd_joom467.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.41 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 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.03 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.12 ms After last query: 43.77 ms Query memory: 0.009 MB Memory before query: 8.113 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `chlko_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profile

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.27 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	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.05 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.76 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 8.106 MB

UPDATE `chlko_extensions`

  SET `params` = '{\"mediaversion\":\"bdfe2044315324774a6bd197dc4992c5\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `chlko_extensions` SET `params` = '{\"mediaversion\":\"bdfe2044315324774a6bd197dc4992c5\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.07 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.25 ms
Updating	0.06 ms
End of update loop	0.02 ms
Query end	0.06 ms
Commit	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 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.03 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.13 ms After last query: 1.99 ms Query memory: 0.006 MB Memory before query: 8.284 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 = 1

Explain

id	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

Profile

Status	Duration
Starting	0.14 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.06 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.25 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.06 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.03 ms After last query: 10.99 ms Query memory: 0.003 MB Memory before query: 9.183 MB Rows returned: 2

SELECT *

  FROM chlko_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	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

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.11 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.03 ms
Reset for next command	0.04 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.94 ms After last query: 19.81 ms Query memory: 0.005 MB Memory before query: 10.937 MB Rows returned: 0

SELECT item_id 
  FROM chlko_djcf_items_promotions 
  WHERE date_exp <= '2025-12-08 15:12:37' 
  AND updated=0 
  GROUP BY item_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_djcf_items_promotions	ALL	date_exp	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where; Using temporary; Using filesort

Profile

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.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.03 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.04 ms
Removing tmp table	0.02 ms
Creating sort index	0.05 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.08 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:957
7	DJClassifiedsPayment::updatePromotions()	JROOT/components/com_djclassifieds/djclassifieds.php:111
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.11 ms After last query: 6.40 ms Query memory: 0.007 MB Memory before query: 11.446 MB Rows returned: 14

Duplicate queries: #18

SELECT * 
  FROM chlko_djcf_categories 
  WHERE published=1 
  AND access_view IN (1,1,5) 
  ORDER BY parent_id, ordering ASC

Explain

id	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

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.12 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.02 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:550
12	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:589
11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:231
10	DJClassifiedsCategory::getSubCatIemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:90
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.60 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 11.496 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_id

Explain

id	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

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.11 ms
table lock	0.05 ms
init	0.07 ms
Optimizing	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Statistics	0.03 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.03 ms
Removing tmp table	0.03 ms
Executing	0.05 ms
Creating sort index	0.04 ms
Removing tmp table	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.05 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:521
12	DJClassifiedsCategory::setItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:590
11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:231
10	DJClassifiedsCategory::getSubCatIemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:90
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.06 ms After last query: 0.32 ms Query memory: 0.006 MB Memory before query: 11.570 MB Rows returned: 0

SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id, r.alias as r_alias , u.name as username 
  FROM  chlko_djcf_items i 
  LEFT JOIN chlko_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN chlko_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN chlko_users u 
  ON i.user_id = u.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM chlko_djcf_items_categories 
  WHERE cat_id IN (8,8) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.blocked=0 
  AND c.published=1  
  AND (i.cat_id IN (8,8) OR mc.mcat_c>0)  
  AND c.access_view IN (0,1,1,5)  
  AND i.published=1 
  AND i.date_exp > '2025-12-08 15:12:37'  
  ORDER BY i.special DESC, i.date_exp DESC 
  LIMIT 0, 6

Explain

id	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; Using temporary; Using filesort
1	PRIMARY	c	range	PRIMARY,published	PRIMARY	4	NULL	1	Using index condition; Using where
1	PRIMARY	i	ref	cat_id,published,blocked	cat_id	4	nrihelpd_joom467.c.id	3	Using where
1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	nrihelpd_joom467.i.region_id	1
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	nrihelpd_joom467.i.user_id	1
2	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
Starting	0.16 ms
checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.04 ms
Statistics	0.14 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Creating tmp table	0.11 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.50 ms
Creating sort index	0.04 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.03 ms
closing tables	0.02 ms
Removing tmp table	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/items.php:407
10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:113
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.34 ms After last query: 0.15 ms Query memory: 0.006 MB Memory before query: 11.578 MB Rows returned: 1

SELECT count(i.id) 
  FROM (SELECT i.id  
  FROM  chlko_djcf_items i 
  LEFT JOIN chlko_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN chlko_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN chlko_users u 
  ON i.user_id = u.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM chlko_djcf_items_categories 
  WHERE cat_id IN (8,8) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.blocked=0 
  AND c.published=1  
  AND (i.cat_id IN (8,8) OR mc.mcat_c>0)  
  AND i.published=1 
  AND i.date_exp > '2025-12-08 15:12:37'  
  AND c.access_view IN (0,1,1,5)  ) as i

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived3>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
1	PRIMARY	c	range	PRIMARY,published	PRIMARY	4	NULL	1	Using index condition; Using where
1	PRIMARY	i	ref	cat_id,published,blocked	cat_id	4	nrihelpd_joom467.c.id	3	Using where
3	DERIVED	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
Starting	0.14 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.11 ms
Optimizing	0.05 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Executing	0.05 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Removing tmp table	0.03 ms
closing tables	0.03 ms
Removing tmp table	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	0.06 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/items.php:827
10	DjclassifiedsModelItems->getCountItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:114
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.07 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 11.583 MB Rows returned: 14

Duplicate queries: #14

SELECT * 
  FROM chlko_djcf_categories 
  WHERE published=1 
  AND access_view IN (1,1,5) 
  ORDER BY parent_id, ordering ASC

Explain

id	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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.13 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.05 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.04 ms
closing tables	0.01 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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:550
12	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:564
11	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276
10	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/items/view.html.php:136
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.76 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 11.633 MB Rows returned: 1

SELECT * 
  FROM chlko_djcf_categories 
  WHERE id=8 
  AND published=1 
  AND access_view IN (1,1,5)  
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_djcf_categories	const	PRIMARY,published	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.07 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.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.04 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 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.05 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/items.php:860
10	DjclassifiedsModelItems->getMainCat()	JROOT/components/com_djclassifieds/views/items/view.html.php:162
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.80 ms After last query: 1.90 ms Query memory: 0.006 MB Memory before query: 11.703 MB Rows returned: 4

SELECT * 
  FROM chlko_djcf_types 
  WHERE published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_djcf_types	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.07 ms
Commit	0.02 ms
closing tables	0.04 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:1251
10	DjclassifiedsModelItems->getTypes()	JROOT/components/com_djclassifieds/views/items/view.html.php:343
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.90 ms After last query: 1.27 ms Query memory: 0.006 MB Memory before query: 11.799 MB Rows returned: 0

SELECT f.*, fg.name group_name 
  FROM chlko_djcf_fields f 
  LEFT JOIN chlko_djcf_fields_groups fg 
  ON f.group_id=fg.id 
  AND fg.published=1 
  WHERE f.published=1 
  AND (f.in_table>0 OR f.in_blog=1) 
  AND (fg.access IS NULL OR fg.access IN (1,1,5)) 
  ORDER BY f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fg	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
1	SIMPLE	f	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	47	Using where; Using filesort

Profile

Status	Duration
Starting	0.12 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.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.04 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.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:1272
10	DjclassifiedsModelItems->getCustomFields()	JROOT/components/com_djclassifieds/views/items/view.html.php:410
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.79 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 11.806 MB Rows returned: 14

SELECT * 
  FROM chlko_djcf_categories 
  ORDER BY parent_id, ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_djcf_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using filesort

Profile

Status	Duration
Starting	0.06 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.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.11 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:550
11	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:564
10	DJClassifiedsCategory::getCategories()	JROOT/components/com_djclassifieds/views/items/view.html.php:426
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.96 ms After last query: 1.62 ms Query memory: 0.009 MB Memory before query: 11.980 MB Rows returned: 38

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:12:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-08 15:12:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 533 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.06 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	2.99 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.03 ms
Reset for next command	0.09 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_djclassifieds/views/items/tmpl/default_terms.php:55
12	include JROOT/components/com_djclassifieds/views/items/tmpl/default_terms.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djclassifieds/views/items/view.html.php:460
9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:140
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.78 ms After last query: 4.26 ms Query memory: 0.006 MB Memory before query: 12.259 MB Rows returned: 7

SELECT id 
  FROM chlko_template_styles 
  ORDER BY id

Explain

id	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

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.04 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.13 ms After last query: 38.02 ms Query memory: 0.010 MB Memory before query: 13.944 MB Rows returned: 0

SELECT element 
  FROM chlko_extensions 
  WHERE type='plugin' 
  AND folder='djclassifieds' 
  AND (element IN ('leaflet','baidu','yandexmaps') OR element LIKE '%maps%') 
  AND enabled=1 
  ORDER BY extension_id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_extensions	index	element_clientid,element_folder_clientid,extension	PRIMARY	4	NULL	1	Using where

Profile

Status	Duration
Starting	0.25 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.03 ms
Statistics	0.16 ms
Preparing	0.12 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	1.14 ms
End of update loop	0.05 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.06 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:337
17	DJClassifiedsTheme::getMapsProvider()	JROOT/modules/mod_djclassifieds_maps/mod_djclassifieds_maps.php:45
16	include JROOT/modules/mod_djclassifieds_maps/mod_djclassifieds_maps.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:69
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.78 ms After last query: 0.24 ms Query memory: 0.010 MB Memory before query: 13.957 MB Rows returned: 0

SELECT i.*, c.name as c_name, c.alias as c_alias, r.name as r_name 
  FROM chlko_djcf_categories c, chlko_djcf_items i  
  LEFT JOIN chlko_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM chlko_djcf_items_categories 
  WHERE cat_id IN (8,8) 
  GROUP BY item_id ) mc 
  ON i.id=mc.item_id 
  WHERE i.date_exp > '2025-12-08 15:12:37' 
  AND i.published = 1 
  AND i.blocked=0 
  AND i.cat_id=c.id 
  AND i.latitude!='0.000000000000000' 
  AND i.longitude!='0.000000000000000'  
  AND (i.cat_id IN (8,8) OR mc.mcat_c>0)  
  AND c.access_view IN (0,1,1,5)  
  ORDER BY i.date_start DESC 
  limit 20

Explain

id	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; Using temporary; Using filesort
1	PRIMARY	c	range	PRIMARY	PRIMARY	4	NULL	1	Using index condition; Using where
1	PRIMARY	i	ref	cat_id,published,blocked	cat_id	4	nrihelpd_joom467.c.id	3	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

Profile

Status	Duration
Starting	0.13 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.11 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Statistics	0.14 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Creating tmp table	0.10 ms
Sorting result	0.06 ms
Executing	0.02 ms
Sending data	0.42 ms
Creating sort index	0.05 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.03 ms
Removing tmp table	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_maps/helper.php:309
17	modDjClassifiedsMaps::getItems()	JROOT/modules/mod_djclassifieds_maps/mod_djclassifieds_maps.php:49
16	include JROOT/modules/mod_djclassifieds_maps/mod_djclassifieds_maps.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:69
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.60 ms After last query: 0.10 ms Query memory: 0.010 MB Memory before query: 13.965 MB Rows returned: 13

SELECT r.* 
  FROM chlko_djcf_regions r 
  WHERE published=1 
  ORDER BY r.parent_id

Explain

id	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

Profile

Status	Duration
Starting	0.06 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.03 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 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.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_maps/helper.php:348
17	modDjClassifiedsMaps::getRegions()	JROOT/modules/mod_djclassifieds_maps/mod_djclassifieds_maps.php:50
16	include JROOT/modules/mod_djclassifieds_maps/mod_djclassifieds_maps.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:69
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.88 ms After last query: 4.52 ms Query memory: 0.011 MB Memory before query: 14.041 MB Rows returned: 2

SELECT r.* 
  FROM chlko_djcf_regions r 
  WHERE r.parent_id=0 
  AND published=1 
  ORDER BY r.parent_id, name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ref	parent_id,published	parent_id	4	const	4	Using where; Using filesort

Profile

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.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:503
19	DJClassifiedsRegion::getMainRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:588
18	DJClassifiedsRegion::getRegionsMain()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:181
17	DJClassifiedsRegion::getMenuRegions()	JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php:64
16	include JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.95 ms After last query: 0.09 ms Query memory: 0.011 MB Memory before query: 14.056 MB Rows returned: 0

SELECT i.region_id, count(i.id) as items_count 
  FROM chlko_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2025-12-08 15:12:37' 
  GROUP BY i.region_id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	published,blocked	NO INDEX KEY COULD BE USED	NULL	NULL	30	Using where; Using temporary; Using filesort

Profile

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.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.14 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	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.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:446
19	DJClassifiedsRegion::setItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:589
18	DJClassifiedsRegion::getRegionsMain()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:181
17	DJClassifiedsRegion::getMenuRegions()	JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php:64
16	include JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.82 ms After last query: 0.07 ms Query memory: 0.011 MB Memory before query: 14.066 MB Rows returned: 13

SELECT r.* 
  FROM chlko_djcf_regions r 
  WHERE published=1 
  ORDER BY r.parent_id, name ASC

Explain

id	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

Profile

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.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.15 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.08 ms
Updating status	0.03 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:478
19	DJClassifiedsRegion::getAllRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:662
18	DJClassifiedsRegion::getRegionsSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:182
17	DJClassifiedsRegion::getMenuRegions()	JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php:64
16	include JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.64 ms After last query: 0.73 ms Query memory: 0.011 MB Memory before query: 14.123 MB Rows returned: 1

SELECT * 
  FROM chlko_djcf_regions 
  WHERE id=6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_djcf_regions	const	PRIMARY	PRIMARY	4	const	1

Profile

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.02 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	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.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.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:193
19	DJClassifiedsSEO::getRegionAlias()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:161
18	DJClassifiedsSEO::getRegionRoute()	JROOT/modules/mod_djclassifieds_regions/tmpl/default.php:96
17	require JROOT/modules/mod_djclassifieds_regions/tmpl/default.php	JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php:99
16	include JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.83 ms After last query: 1.22 ms Query memory: 0.012 MB Memory before query: 14.188 MB Rows returned: 20

SELECT r.* 
  FROM chlko_djcf_regions r 
  ORDER BY r.parent_id, name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	20	Using filesort

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.04 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.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.21 ms
End of update loop	0.04 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.03 ms
Unlocking tables	0.03 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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:478
21	DJClassifiedsRegion::getAllRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:517
20	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:346
19	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:170
18	DJClassifiedsSEO::getRegionRoute()	JROOT/modules/mod_djclassifieds_regions/tmpl/default.php:96
17	require JROOT/modules/mod_djclassifieds_regions/tmpl/default.php	JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php:99
16	include JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.73 ms After last query: 0.78 ms Query memory: 0.012 MB Memory before query: 14.237 MB Rows returned: 1

SELECT * 
  FROM chlko_djcf_regions 
  WHERE id=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	chlko_djcf_regions	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.13 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.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.07 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.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.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:193
19	DJClassifiedsSEO::getRegionAlias()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:161
18	DJClassifiedsSEO::getRegionRoute()	JROOT/modules/mod_djclassifieds_regions/tmpl/default.php:96
17	require JROOT/modules/mod_djclassifieds_regions/tmpl/default.php	JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php:99
16	include JROOT/modules/mod_djclassifieds_regions/mod_djclassifieds_regions.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.82 ms After last query: 1.41 ms Query memory: 0.010 MB Memory before query: 14.265 MB Rows returned: 14

SELECT * 
  FROM chlko_djcf_categories 
  WHERE published=1 
  ORDER BY parent_id, ordering

Explain

id	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

Profile

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.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.04 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.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:35
17	modDjClassifiedsSearch::getCats()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:77
16	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.74 ms After last query: 0.15 ms Query memory: 0.010 MB Memory before query: 14.317 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_ci

Explain

id	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

Profile

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.02 ms
init	0.03 ms
Optimizing	0.02 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.13 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.04 ms
Reset for next command	0.04 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/model.php:110
17	DJClassifiedsModel->getRegions()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:108
16	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.63 ms After last query: 0.10 ms Query memory: 0.010 MB Memory before query: 14.348 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.ordering

Explain

id	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

Profile

Status	Duration
Starting	0.07 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.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.05 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.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:60
17	modDjClassifiedsSearch::getTypes()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:111
16	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.51 ms After last query: 0.08 ms Query memory: 0.010 MB Memory before query: 14.360 MB Rows returned: 0

SELECT g.* 
  FROM chlko_djcf_fields_groups g 
  WHERE g.source=2 
  AND g.published=1 
  ORDER BY g.ordering

Explain

id	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

Profile

Status	Duration
Starting	0.07 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.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 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.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:74
17	modDjClassifiedsSearch::getProfileGroups()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:112
16	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php:76
12	include JROOT/templates/jm-joomclassifieds-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php:76
10	include JROOT/templates/jm-joomclassifieds-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomclassifieds-ef4/index.php:19
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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.20 ms After last query: 28.87 ms Query memory: 0.010 MB Memory before query: 15.579 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 ASC

Explain

id	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

Profile

Status	Duration
Starting	0.29 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.01 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.05 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.48 ms After last query: 11.44 ms Query memory: 0.006 MB Memory before query: 15.943 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:12:37'  
  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 1

Explain

id	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

Profile

Status	Duration
Starting	0.31 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.09 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.07 ms
Sorting result	0.05 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.23 ms
End of update loop	0.04 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.09 ms
Updating status	0.04 ms
Reset for next command	0.04 ms

Call Stack

#	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

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT * 
  FROM chlko_djcf_categories

5 × SELECT r.* 
  FROM chlko_djcf_regions r

2 × SELECT * 
  FROM chlko_djcf_regions

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `chlko_extensions`

1 × SELECT `data` 
  FROM `chlko_session`

1 × SELECT f.*, fg.name group_name 
  FROM chlko_djcf_fields f 
  LEFT JOIN chlko_djcf_fields_groups fg 
  ON f.group_id=fg.id 
  AND fg.published=1

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

1 × SELECT g.* 
  FROM chlko_djcf_fields_groups g

1 × SELECT t.id as value, t.name as text, '0' as disabled 
  FROM chlko_djcf_types t

1 × SELECT i.region_id, count(i.id) as items_count 
  FROM chlko_djcf_items i

1 × SELECT i.*, c.name as c_name, c.alias as c_alias, r.name as r_name 
  FROM chlko_djcf_categories c, chlko_djcf_items i  
  LEFT JOIN chlko_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM chlko_djcf_items_categories

1 × SELECT element 
  FROM chlko_extensions

1 × SELECT id 
  FROM chlko_template_styles

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_id

1 × SELECT count(i.id) 
  FROM (SELECT i.id  
  FROM  chlko_djcf_items i 
  LEFT JOIN chlko_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN chlko_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN chlko_users u 
  ON i.user_id = u.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM chlko_djcf_items_categories

```
1 × SELECT * 
  FROM chlko_djcf_types
```

1 × SELECT `session_id` 
  FROM `chlko_session`

1 × SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id, r.alias as r_alias , u.name as username 
  FROM  chlko_djcf_items i 
  LEFT JOIN chlko_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN chlko_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN chlko_users u 
  ON i.user_id = u.id 
  LEFT JOIN ( SELECT item_id, count(id) as  mcat_c 
  FROM chlko_djcf_items_categories

1 × SELECT cat_id, count(*) as items_count 
  FROM (SELECT i.cat_id 
  FROM chlko_djcf_items i

1 × SELECT item_id 
  FROM chlko_djcf_items_promotions

```
1 × SELECT * 
  FROM chlko_languages
```

1 × 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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM chlko_menu AS m 
  LEFT JOIN chlko_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM chlko_extensions

1 × SELECT b.id 
  FROM chlko_usergroups AS a 
  LEFT JOIN chlko_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `chlko_viewlevels

1 × 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'3531383037663231353864323663633738376663393833353835306534633732', 1, 1765206757, 0, '', 0

1 × UPDATE `chlko_extensions` 
  SET `params` = '{\"mediaversion\":\"bdfe2044315324774a6bd197dc4992c5\"}'

Categories

Classifieds Map

Contact Us

Information

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

39 Queries Logged 43.68 ms

2 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: