{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1780974565,
                "last": 1780974565,
                "now": 1780974565
            },
            "token": "GGmsFk9cAFssszWxzzj79pCnnkI7IkBA"
        },
        "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
        }
    },
    "__easycalccheckplus": {
        "redirect_url": null,
        "ecc_loaded": null
    }
}

Time

Memory

33 Queries Logged 185.13 ms

1. Query Time: 6.91 ms Query memory: 0.023 MB Memory before query: 4.154 MB Rows returned: 0

   SELECT `data`
   
     FROM `wwyb_session`
   
     WHERE `session_id` = X'6134383033353739616262636166363734616161653965643362306465356164'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	wwyb_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   Starting	0.09 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	6.20 ms
   Preparing	0.03 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	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:46

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

   ---

2. Query Time: 0.71 ms After last query: 2.20 ms Query memory: 0.020 MB Memory before query: 4.250 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `wwyb_session`
   
     WHERE `session_id` = X'6134383033353739616262636166363734616161653965643362306465356164' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	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:46

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

   ---

3. Query Time: 30.95 ms After last query: 0.18 ms Query memory: 0.004 MB Memory before query: 4.255 MB

   INSERT INTO `wwyb_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6134383033353739616262636166363734616161653965643362306465356164', 1, 1780974565, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `wwyb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6134383033353739616262636166363734616161653965643362306465356164', 1, 1780974565, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.04 ms
   Update	0.12 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	30.26 ms
   Query end	0.03 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 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:46

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

   ---

4. Query Time: 1.36 ms After last query: 3.90 ms Query memory: 0.040 MB Memory before query: 4.505 MB Rows returned: 37

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `wwyb_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	wwyb_extensions	ref	extension	extension	82	const	37	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.10 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.05 ms
   Optimizing	0.05 ms
   Statistics	0.10 ms
   Preparing	0.06 ms
   Executing	0.02 ms
   Sending data	0.42 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.04 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 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:49

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

   ---

5. Query Time: 0.79 ms After last query: 3.68 ms Query memory: 0.021 MB Memory before query: 4.703 MB Rows returned: 5

   SELECT id, rules
   
     FROM `wwyb_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.06 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 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:49

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

   ---

6. Query Time: 0.98 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 4.715 MB Rows returned: 2

   SELECT b.id
   
     FROM wwyb_usergroups AS a
   
     LEFT JOIN wwyb_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.11 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.10 ms
   Preparing	0.02 ms
   Unlocking tables	0.02 ms
   Preparing	0.05 ms
   Executing	0.02 ms
   Sending data	0.06 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 ms
   Updating status	0.04 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/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:49

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

   ---

7. Query Time: 2.20 ms After last query: 1.21 ms Query memory: 0.030 MB Memory before query: 4.783 MB Rows returned: 95

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM wwyb_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	wwyb_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	228	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.06 ms
   Optimizing	0.05 ms
   Statistics	0.08 ms
   Preparing	0.05 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	1.26 ms
   End of update loop	0.03 ms
   Query end	0.03 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 ms
   Updating status	0.05 ms
   Reset for next command	0.02 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:49

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

   ---

8. Query Time: 2.38 ms After last query: 31.27 ms Query memory: 0.112 MB Memory before query: 6.659 MB Rows returned: 68

   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 wwyb_menu AS m
   
     LEFT JOIN wwyb_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	123	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.m.component_id	1	Using where

   Profile

   Status	Duration
   Starting	0.15 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.07 ms
   Optimizing	0.06 ms
   Statistics	0.10 ms
   Preparing	0.06 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.05 ms
   Creating sort index	1.31 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   Commit	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.03 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.03 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/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:49

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

   ---

9. Query Time: 1.00 ms After last query: 15.13 ms Query memory: 0.027 MB Memory before query: 7.603 MB Rows returned: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `wwyb_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	wwyb_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

   Profile

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

   Call Stack

   #	Caller	File and line number
   24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   23	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   22	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   19	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   18	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   17	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/behavior.php:363
   13	JHtmlBehavior::modal()	Same as call in the line below.
   12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:29
   9	require_once JROOT/administrator/components/com_djclassifieds/lib/djcategory.php	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:31
   8	require_once JROOT/administrator/components/com_djclassifieds/lib/djseo.php	JROOT/components/com_djclassifieds/router.php:31
   7	require_once JROOT/components/com_djclassifieds/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
   6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   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:49

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

   ---

10. Query Time: 15.76 ms After last query: 0.25 ms Query memory: 0.010 MB Memory before query: 7.598 MB

    UPDATE `wwyb_extensions`
    
      SET `params` = '{\"mediaversion\":\"fe4a5256a0bb85bcd5933fa817591bb2\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/behavior.php:363
    13	JHtmlBehavior::modal()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:29
    9	require_once JROOT/administrator/components/com_djclassifieds/lib/djcategory.php	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:31
    8	require_once JROOT/administrator/components/com_djclassifieds/lib/djseo.php	JROOT/components/com_djclassifieds/router.php:31
    7	require_once JROOT/components/com_djclassifieds/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
    6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:49

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

    ---

11. Query Time: 1.29 ms After last query: 6.63 ms Query memory: 0.027 MB Memory before query: 7.997 MB Rows returned: 5

    SELECT id, home, template, s.params
    
      FROM wwyb_template_styles as s
    
      LEFT JOIN wwyb_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	82	const	5	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.06 ms
    Optimizing	0.07 ms
    Statistics	0.16 ms
    Preparing	0.11 ms
    Executing	0.02 ms
    Sending data	0.17 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 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/libraries/src/Application/SiteApplication.php:486
    21	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    20	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    19	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
    15	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:60
    14	JHtmlBehavior::framework()	JROOT/libraries/cms/html/behavior.php:369
    13	JHtmlBehavior::modal()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:29
    9	require_once JROOT/administrator/components/com_djclassifieds/lib/djcategory.php	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:31
    8	require_once JROOT/administrator/components/com_djclassifieds/lib/djseo.php	JROOT/components/com_djclassifieds/router.php:31
    7	require_once JROOT/components/com_djclassifieds/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
    6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:49

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

    ---

12. Query Time: 1.01 ms After last query: 17.02 ms Query memory: 0.019 MB Memory before query: 8.688 MB Rows returned: 1

    SELECT *
    
      FROM wwyb_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

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

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.09 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 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:49

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

    ---

13. Query Time: 0.93 ms After last query: 12.69 ms Query memory: 0.021 MB Memory before query: 9.367 MB Rows returned: 1

    SELECT date_exp, user_id, published 
      FROM wwyb_djcf_items 
      WHERE id=51

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    9	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/controllers/item.php:56
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

14. Query Time: 5.90 ms After last query: 0.22 ms Query memory: 0.005 MB Memory before query: 9.374 MB

    UPDATE `wwyb_djcf_items` 
      SET display=display+1 
      WHERE id=51

    Explain

    EXPLAIN not possible on query: UPDATE `wwyb_djcf_items` SET display=display+1 WHERE id=51

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.04 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.10 ms
    Updating	0.13 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	5.07 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    9	JDatabase->query()	JROOT/components/com_djclassifieds/controllers/item.php:70
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

15. Query Time: 11.54 ms After last query: 6.02 ms Query memory: 0.023 MB Memory before query: 9.649 MB Rows returned: 1

    SELECT i.*, u.name as username, u.email as u_email , t.id as t_id, t.name as t_name,t.params as t_params  
      FROM wwyb_djcf_items i 
      LEFT JOIN wwyb_djcf_types t 
      ON t.id = i.type_id 
      LEFT JOIN wwyb_users u 
      ON u.id = i.user_id 
      WHERE  i.id = 51 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.10 ms
    Optimizing	0.06 ms
    Statistics	10.35 ms
    Preparing	0.03 ms
    Unlocking tables	0.03 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.12 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.03 ms
    Query end	0.04 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 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:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:69
    11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:55
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

16. Query Time: 24.27 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 9.660 MB Rows returned: 1

    SELECT img.* 
      FROM wwyb_djcf_images img 
      WHERE img.item_id IN (51) 
      AND img.type='item' 
      ORDER BY img.item_id, img.ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.05 ms
    Preparing	0.05 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	23.27 ms
    End of update loop	0.03 ms
    Query end	0.03 ms
    Commit	0.03 ms
    Query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 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/djimage.php:354
    11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

17. Query Time: 1.03 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 9.670 MB Rows returned: 1

    SELECT c.* 
      FROM wwyb_djcf_categories c 
      WHERE id='78' 
      LIMIT 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:78
    11	DjclassifiedsModelItem->getCategory()	JROOT/components/com_djclassifieds/views/item/view.html.php:58
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

18. Query Time: 30.11 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 9.678 MB Rows returned: 0

    SELECT f.*, v.value,v.value_date 
      FROM wwyb_djcf_fields f 
      LEFT JOIN wwyb_djcf_fields_xref fx 
      ON f.id=fx.field_id 
      LEFT JOIN (SELECT * 
      FROM wwyb_djcf_fields_values 
      WHERE item_id=51) v 
      ON v.field_id=f.id 
      WHERE fx.cat_id  = 78 
      AND f.published=1 
      AND f.access=0 
      AND f.name!='price' 
      AND f.name!='contact' 
      ORDER BY fx.ordering, f.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fx	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	894	Using where; Using temporary; Using filesort
    1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.fx.field_id	1	Using where
    1	SIMPLE	wwyb_djcf_fields_values	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	168	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:140
    11	DjclassifiedsModelItem->getFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:59
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

19. Query Time: 8.46 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 9.684 MB Rows returned: 0

    SELECT f.*, v.value,v.value_date 
      FROM wwyb_djcf_fields f 
      LEFT JOIN wwyb_djcf_fields_xref fx 
      ON f.id=fx.field_id 
      LEFT JOIN (SELECT * 
      FROM wwyb_djcf_fields_values 
      WHERE item_id=51) v 
      ON v.field_id=f.id 
      WHERE f.source=1 
      AND f.published=1 
      AND f.access=0 
      AND f.name!='price' 
      AND f.name!='contact' 
      GROUP BY f.id 
      ORDER BY fx.ordering, f.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	60	Using where; Using temporary; Using filesort
    1	SIMPLE	fx	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	894	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	wwyb_djcf_fields_values	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	168	Using where; Using join buffer (incremental, BNL join)

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:156
    11	DjclassifiedsModelItem->geContactFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:60
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

20. Query Time: 6.67 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 9.690 MB Rows returned: 1

    SELECT COUNT(p.id) 
      FROM wwyb_djcf_payments p 
      WHERE p.item_id = 51 
      AND p.type=0 
      AND p.price>0

    Explain

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

    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.05 ms
    Optimizing	0.04 ms
    Statistics	0.04 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	5.89 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/item.php:178
    11	DjclassifiedsModelItem->getItemPayment()	JROOT/components/com_djclassifieds/views/item/view.html.php:61
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

21. Query Time: 0.86 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 9.697 MB Rows returned: 1

    SELECT COUNT(i.id) 
      FROM wwyb_djcf_items i 
      WHERE i.published=1 
      AND i.date_exp>NOW() 
      AND i.user_id  = 812

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/item.php:86
    11	DjclassifiedsModelItem->getUserItemsCount()	JROOT/components/com_djclassifieds/views/item/view.html.php:63
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

22. Query Time: 2.25 ms After last query: 2.26 ms Query memory: 0.047 MB Memory before query: 9.735 MB Rows returned: 85
    Duplicate queries: #29

    SELECT c.*, cc.name as parent_name,IFNULL(i.items_count,0) items_count 
      FROM wwyb_djcf_categories c 
      LEFT JOIN wwyb_djcf_categories cc 
      ON c.parent_id=cc.id 
      LEFT JOIN (SELECT i.cat_id, count(i.id) as items_count 
      FROM wwyb_djcf_items i 
      WHERE i.published=1 
      AND i.date_exp > NOW() 
      GROUP BY i.cat_id) i 
      ON i.cat_id=c.id 
      WHERE c.published=1 
      ORDER BY c.parent_id, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	85	Using where; Using filesort
    1	PRIMARY	cc	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.c.parent_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	worldwid_joom.c.id	2
    2	DERIVED	i	ALL	cat_id	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where; Using temporary; Using filesort

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Statistics	0.05 ms
    Preparing	0.05 ms
    Creating tmp table	0.04 ms
    Sorting result	0.03 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.18 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.60 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.02 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:393
    12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:239
    11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:84
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

23. Query Time: 11.24 ms After last query: 1.09 ms Query memory: 0.030 MB Memory before query: 9.885 MB Rows returned: 39

    SELECT r.* 
      FROM wwyb_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	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	39	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:167
    11	DjclassifiedsModelItem->getRegions()	JROOT/components/com_djclassifieds/views/item/view.html.php:114
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

24. Query Time: 0.69 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 9.911 MB Rows returned: 0

    SELECT * 
      FROM wwyb_djcf_images 
      WHERE item_id = 812 
      AND type='profile' 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 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.03 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:189
    11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:148
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

25. Query Time: 1.21 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 9.918 MB Rows returned: 0

    SELECT f.*, v.value, v.value_date 
      FROM wwyb_djcf_fields f 
      LEFT JOIN (SELECT * 
      FROM wwyb_djcf_fields_values_profile 
      WHERE user_id=812) v 
      ON v.field_id=f.id 
      WHERE f.published=1 
      AND f.source=2 
      AND f.in_item=1 
      AND f.access=0 
      ORDER BY f.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	60	Using where; Using temporary; Using filesort
    1	SIMPLE	wwyb_djcf_fields_values_profile	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:196
    11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:148
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

26. Query Time: 2.64 ms After last query: 8.63 ms Query memory: 0.050 MB Memory before query: 10.130 MB Rows returned: 49

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM wwyb_modules AS m
    
      LEFT JOIN wwyb_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN wwyb_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 <= '2026-06-09 03:09:25') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-09 03:09:25') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 532 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	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	80	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	worldwid_joom.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	worldwid_joom.m.id	2	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/jm-joomads/html/com_djclassifieds/item/default.php:72
    13	include JROOT/templates/jm-joomads/html/com_djclassifieds/item/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djclassifieds/views/item/view.html.php:226
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:71
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:103
    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:49

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

    ---

27. Query Time: 2.13 ms After last query: 34.60 ms Query memory: 0.026 MB Memory before query: 11.159 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.name as r_name,  img.path as img_path, img.name as img_name, img.ext as img_ext,img.caption as img_caption 
      FROM wwyb_djcf_categories c, wwyb_djcf_items i 
      LEFT JOIN wwyb_djcf_regions r 
      ON r.id=i.region_id 
      LEFT JOIN ( SELECT img.id, img.item_id, img.name, img.path, img.ext, img.ordering, img.caption 
    		 					  
      FROM (SELECT * 
      FROM wwyb_djcf_images 
      WHERE type='item' 
      ORDER BY ordering) img 
      GROUP BY img.item_id ) AS img 
      ON img.item_id=i.id 
      WHERE i.date_exp > '2026-06-09 03:09:25' 
      AND i.published = 1 
      AND c.published = 1 
      AND i.cat_id=c.id  
      AND i.cat_id IN (9,10,11,12,13,15) 
      ORDER BY i.date_start DESC 
      limit 6

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	i	ALL	cat_id	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where; Using filesort
    1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.i.cat_id	1	Using where
    1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.i.region_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	worldwid_joom.i.id	4
    2	DERIVED	wwyb_djcf_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Using temporary; Using filesort

    Profile

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.20 ms
    Optimizing	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.03 ms
    Statistics	0.43 ms
    Preparing	0.07 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    Creating sort index	0.11 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.03 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 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_items/helper.php:175
    17	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:34
    16	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.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/jmframework/includes/libraries/modulehelper.php:67
    13	DJModuleHelper::renderModules()	JROOT/templates/jm-joomads/tpl/blocks/content.php:42
    12	include JROOT/templates/jm-joomads/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomads/tpl/default.php:40
    10	include JROOT/templates/jm-joomads/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomads/index.php:19
    7	require JROOT/templates/jm-joomads/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:49

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

    ---

28. Query Time: 1.36 ms After last query: 2.56 ms Query memory: 0.051 MB Memory before query: 11.208 MB Rows returned: 85

    SELECT * 
      FROM wwyb_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	wwyb_djcf_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	85	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.56 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 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:54
    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/jmframework/includes/libraries/modulehelper.php:67
    13	DJModuleHelper::renderModules()	JROOT/templates/jm-joomads/tpl/blocks/content.php:80
    12	include JROOT/templates/jm-joomads/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomads/tpl/default.php:40
    10	include JROOT/templates/jm-joomads/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomads/index.php:19
    7	require JROOT/templates/jm-joomads/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:49

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

    ---

29. Query Time: 2.17 ms After last query: 0.29 ms Query memory: 0.051 MB Memory before query: 11.300 MB Rows returned: 85
    Duplicate queries: #22

    SELECT c.*, cc.name as parent_name,IFNULL(i.items_count,0) items_count 
      FROM wwyb_djcf_categories c 
      LEFT JOIN wwyb_djcf_categories cc 
      ON c.parent_id=cc.id 
      LEFT JOIN (SELECT i.cat_id, count(i.id) as items_count 
      FROM wwyb_djcf_items i 
      WHERE i.published=1 
      AND i.date_exp > NOW() 
      GROUP BY i.cat_id) i 
      ON i.cat_id=c.id 
      WHERE c.published=1 
      ORDER BY c.parent_id, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	85	Using where; Using filesort
    1	PRIMARY	cc	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.c.parent_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	worldwid_joom.c.id	2
    2	DERIVED	i	ALL	cat_id	NO INDEX KEY COULD BE USED	NULL	NULL	10	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.08 ms
    Optimizing	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Statistics	0.05 ms
    Preparing	0.05 ms
    Creating tmp table	0.04 ms
    Sorting result	0.03 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.17 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.04 ms
    Creating sort index	0.60 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.05 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/administrator/components/com_djclassifieds/lib/djcategory.php:437
    17	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:67
    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/jmframework/includes/libraries/modulehelper.php:67
    13	DJModuleHelper::renderModules()	JROOT/templates/jm-joomads/tpl/blocks/content.php:80
    12	include JROOT/templates/jm-joomads/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomads/tpl/default.php:40
    10	include JROOT/templates/jm-joomads/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomads/index.php:19
    7	require JROOT/templates/jm-joomads/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:49

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

    ---

30. Query Time: 1.26 ms After last query: 0.33 ms Query memory: 0.034 MB Memory before query: 11.443 MB Rows returned: 39

    SELECT r.* 
      FROM wwyb_djcf_regions r 
      WHERE r.published=1 
      ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

    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	39	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.27 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 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:46
    17	modDjClassifiedsSearch::getRegions()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:72
    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/jmframework/includes/libraries/modulehelper.php:67
    13	DJModuleHelper::renderModules()	JROOT/templates/jm-joomads/tpl/blocks/content.php:80
    12	include JROOT/templates/jm-joomads/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomads/tpl/default.php:40
    10	include JROOT/templates/jm-joomads/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomads/index.php:19
    7	require JROOT/templates/jm-joomads/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:49

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

    ---

31. Query Time: 0.88 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 11.474 MB Rows returned: 4

    SELECT t.id as value, t.name as text, '0' as disabled 
      FROM wwyb_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	4	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 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:58
    17	modDjClassifiedsSearch::getTypes()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:73
    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/jmframework/includes/libraries/modulehelper.php:67
    13	DJModuleHelper::renderModules()	JROOT/templates/jm-joomads/tpl/blocks/content.php:80
    12	include JROOT/templates/jm-joomads/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomads/tpl/default.php:40
    10	include JROOT/templates/jm-joomads/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomads/index.php:19
    7	require JROOT/templates/jm-joomads/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:49

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

    ---

32. Query Time: 1.93 ms After last query: 6.15 ms Query memory: 0.026 MB Memory before query: 11.550 MB Rows returned: 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.name as r_name,  img.path as img_path, img.name as img_name, img.ext as img_ext,img.caption as img_caption 
      FROM wwyb_djcf_categories c, wwyb_djcf_items i 
      LEFT JOIN wwyb_djcf_regions r 
      ON r.id=i.region_id 
      LEFT JOIN ( SELECT img.id, img.item_id, img.name, img.path, img.ext, img.ordering, img.caption 
    		 					  
      FROM (SELECT * 
      FROM wwyb_djcf_images 
      WHERE type='item' 
      ORDER BY ordering) img 
      GROUP BY img.item_id ) AS img 
      ON img.item_id=i.id 
      WHERE i.date_exp > '2026-06-09 03:09:25' 
      AND i.published = 1 
      AND c.published = 1 
      AND i.cat_id=c.id  
      AND i.cat_id IN (78) 
      ORDER BY i.display DESC 
      limit 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	i	ref	cat_id	cat_id	4	const	1	Using where; Using filesort
    1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.i.region_id	1
    1	PRIMARY	<derived2>	ref	key0	key0	5	worldwid_joom.i.id	4
    2	DERIVED	wwyb_djcf_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Using temporary; Using filesort

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.04 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.16 ms
    Optimizing	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.03 ms
    Statistics	0.12 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    Creating sort index	0.12 ms
    Executing	0.02 ms
    Sending data	0.11 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.02 ms
    Creating sort index	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 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_items/helper.php:175
    17	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:34
    16	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.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/jmframework/includes/libraries/modulehelper.php:67
    13	DJModuleHelper::renderModules()	JROOT/templates/jm-joomads/tpl/blocks/content.php:80
    12	include JROOT/templates/jm-joomads/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-joomads/tpl/default.php:40
    10	include JROOT/templates/jm-joomads/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-joomads/index.php:19
    7	require JROOT/templates/jm-joomads/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:49

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

    ---

33. Query Time: 2.27 ms After last query: 32.76 ms Query memory: 0.028 MB Memory before query: 12.264 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 wwyb_fields AS a
    
      LEFT JOIN `wwyb_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN wwyb_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN wwyb_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN wwyb_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN wwyb_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	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	worldwid_joom.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	worldwid_joom.a.group_id	1	Using where

    Profile

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.02 ms
    Opening tables	0.09 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.06 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.23 ms
    Preparing	0.08 ms
    Creating tmp table	0.10 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.57 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.13 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 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/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:49

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

    ---