{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728914950,
                "last": 1728914950,
                "now": 1728914950
            },
            "token": "50zmu9LXfhtOAksA8M1y8zC8yDgxbLGV"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Time

Memory

109 Queries Logged 423.64 ms

1. Query Time: 3.88 ms Query memory: 0.023 MB Memory before query: 1.306 MB Rows returned: 0

   SELECT `data`
   
     FROM `jml_session`
   
     WHERE `session_id` = X'6161633638653566653134326633613933656234613139333061336438663535'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jml_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 1.25 ms After last query: 2.05 ms Query memory: 0.020 MB Memory before query: 1.317 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jml_session`
   
     WHERE `session_id` = X'6161633638653566653134326633613933656234613139333061336438663535' 
     LIMIT 1

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 11.97 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.322 MB

   INSERT INTO `jml_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6161633638653566653134326633613933656234613139333061336438663535', 1, 1728914950, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `jml_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6161633638653566653134326633613933656234613139333061336438663535', 1, 1728914950, 0, '', 0)

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 6.57 ms After last query: 4.38 ms Query memory: 0.069 MB Memory before query: 1.415 MB Rows returned: 45

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jml_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jml_extensions	ref	extension	extension	82	const	48	100.00	Using index condition; Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 3.44 ms After last query: 4.08 ms Query memory: 0.021 MB Memory before query: 1.460 MB Rows returned: 9

   SELECT id, rules
   
     FROM `jml_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jml_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	NULL

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 6.12 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.474 MB Rows returned: 1

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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.31 ms After last query: 1.53 ms Query memory: 0.023 MB Memory before query: 1.495 MB Rows returned: 112

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jml_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jml_extensions	ref	extension	extension	82	const	211	100.00	Using index condition; Using where; Using filesort

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 25.39 ms After last query: 54.00 ms Query memory: 0.135 MB Memory before query: 2.422 MB Rows returned: 83

   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 jml_menu AS m
   
     LEFT JOIN jml_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	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	201	100.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	S44BD4Ta_new.m.component_id	1	100.00	Using where

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   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: 3.70 ms After last query: 71.73 ms Query memory: 0.025 MB Memory before query: 3.007 MB Rows returned: 45

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `jml_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djclassifieds','com_eshop','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmembership','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jml_assets	range	idx_asset_name	idx_asset_name	202	NULL	46	100.00	Using index condition

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
   10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
   9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:192
   8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 1.97 ms After last query: 1.15 ms Query memory: 0.021 MB Memory before query: 3.072 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM jml_template_styles as s
    
      LEFT JOIN jml_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	filtered	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	75.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	S44BD4Ta_new.s.template,const	1	100.00	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
    9	jsn_template_framework_class_loader()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
    8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 1.57 ms After last query: 0.39 ms Query memory: 0.021 MB Memory before query: 3.099 MB Rows returned: 1

    SELECT manifest_cache
    
      FROM jml_extensions
    
      WHERE element LIKE 'jsn_megazine_pro'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	3	100.00	Using index condition

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
    11	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
    10	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
    9	jsn_template_framework_class_loader()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
    8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.44 ms After last query: 12.88 ms Query memory: 0.021 MB Memory before query: 3.183 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM jml_extensions
    
      WHERE type = 'component' 
      AND element = 'com_sh404sef'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
    10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
    9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
    8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 9.37 ms After last query: 0.77 ms Query memory: 0.022 MB Memory before query: 3.208 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.10 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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.83 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 3.199 MB

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.06 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	2.91 ms
    closing tables	0.04 ms
    freeing items	0.07 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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: 2.68 ms After last query: 4.46 ms Query memory: 0.019 MB Memory before query: 3.299 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.09 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.06 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.]

    ---

16. Query Time: 1.90 ms After last query: 13.95 ms Query memory: 0.020 MB Memory before query: 3.512 MB Rows returned: 0

    SELECT item_id 
      FROM jml_djcf_items_promotions 
      WHERE date_exp <= '2024-10-14 14:09:10' 
      AND updated=0 
      GROUP BY item_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_djcf_items_promotions	index	item_id,date_exp	item_id	4	NULL	46	80.43	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.14 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:818
    7	DJClassifiedsPayment::updatePromotions()	JROOT/components/com_djclassifieds/djclassifieds.php:65
    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: 3.73 ms After last query: 6.81 ms Query memory: 0.024 MB Memory before query: 3.645 MB Rows returned: 25
    Duplicate queries: #27

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

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.35 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.06 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:538
    12	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:577
    11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:149
    10	DJClassifiedsCategory::getCatAllItemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:184
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 1.30 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 3.691 MB Rows returned: 5

    SELECT cat_id, count(*) as items_count 
      FROM (SELECT i.cat_id 
      FROM jml_djcf_items i 
      WHERE i.published=1 
      AND i.blocked=0 
      AND i.date_exp > '2024-10-14 14:00:00' ) v 
      GROUP BY cat_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using temporary; Using filesort
    2	DERIVED	i	range	published,blocked,date_exp	date_exp	4	NULL	11	81.82	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.13 ms
    preparing	0.06 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.11 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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:509
    12	DJClassifiedsCategory::setItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:578
    11	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:149
    10	DJClassifiedsCategory::getCatAllItemsCount()	JROOT/components/com_djclassifieds/views/items/view.html.php:184
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.19 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.712 MB Rows returned: 0

    SELECT * 
      FROM jml_djcf_images 
      WHERE type='category' 
      AND item_id IN (1,5,19,22)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_djcf_images	ref	item_id,type	type	167	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:347
    10	DJClassifiedsImage::getCatImages()	JROOT/components/com_djclassifieds/views/items/view.html.php:197
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 2.42 ms After last query: 0.97 ms Query memory: 0.022 MB Memory before query: 3.726 MB Rows returned: 0
    Duplicate queries: #36

    SELECT * 
      FROM jml_djcf_fields 
      WHERE published=1 
      AND source IN (0,1) 
      AND sortable=1 
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.00 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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/djfield.php:44
    11	DJClassifiedsField::getSortFields()	JROOT/components/com_djclassifieds/models/items.php:242
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 12.29 ms After last query: 0.06 ms Query memory: 0.038 MB Memory before query: 3.734 MB Rows returned: 7

    SELECT i.*, c.name c_name, c.alias c_alias, c.id c_id, c.rev_group_id, c.restriction_18 c_restr_18, c.schema_type c_schema_type, r.name r_name, r.id r_id, r.alias r_alias, u.name u_name, u.username as u_username, u.name as username, u.email as u_email, p.group_id, p.verified p_verified 
      FROM jml_djcf_items i 
      LEFT JOIN jml_djcf_categories c 
      ON i.cat_id=c.id 
      LEFT JOIN jml_djcf_regions r 
      ON i.region_id=r.id 
      LEFT JOIN jml_users u 
      ON i.user_id=u.id 
      LEFT JOIN jml_djcf_profiles p 
      ON u.id=p.user_id 
      WHERE i.blocked=0 
      AND c.published!=0 
      AND c.access_view IN (0,1,1) 
      AND i.published=1 
      AND i.date_exp > '2024-10-14 14:09:10' 
      ORDER BY i.special DESC, i.date_sort DESC 
      LIMIT 0, 7

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	range	cat_id,published,blocked,date_exp	date_exp	4	NULL	11	100.00	Using index condition; Using where; Using temporary; Using filesort
    1	SIMPLE	r	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	S44BD4Ta_new.i.cat_id	1	100.00	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	S44BD4Ta_new.i.user_id	1	100.00	NULL
    1	SIMPLE	p	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.07 ms
    statistics	0.10 ms
    preparing	0.04 ms
    Creating tmp table	1.40 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	5.86 ms
    Creating sort index	0.12 ms
    end	0.01 ms
    removing tmp table	2.39 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.07 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/items.php:318
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 6.07 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.814 MB Rows returned: 7

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.access IN (1,1) 
      AND (f.in_table > 0 OR f.in_blog = 1) 
      AND fv.item_id IN (265,221,300,299,298,297,293)
    
      ORDER BY fv.item_id, f.ordering, f.label

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	system	PRIMARY,published,source	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
    1	SIMPLE	fv	range	field_id,item_id	item_id	4	NULL	7	85.71	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.07 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.53 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.14 ms
    cleaning up	0.06 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/items.php:443
    11	DjclassifiedsModelItems->getFields()	JROOT/components/com_djclassifieds/models/items.php:330
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 2.66 ms After last query: 1.20 ms Query memory: 0.023 MB Memory before query: 3.841 MB Rows returned: 23

    SELECT img.* 
      FROM jml_djcf_images img 
      WHERE img.item_id IN (265,221,300,299,298,297,293) 
      AND img.type='item' 
      ORDER BY img.item_id, img.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	img	range	item_id,type	item_id	4	NULL	23	78.26	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.16 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.02 ms
    cleaning up	0.06 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/djimage.php:265
    12	DJClassifiedsImage::_getImagesRaw()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:272
    11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/models/items.php:331
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 2.08 ms After last query: 0.58 ms Query memory: 0.022 MB Memory before query: 3.948 MB Rows returned: 0

    SELECT * 
      FROM jml_djcf_images 
      WHERE item_id IN (48382,48382,45618,45618,45618,45618,45618) 
      AND type='profile'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_djcf_images	ref	item_id,type	type	167	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.06 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:337
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 2.09 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 3.954 MB Rows returned: 0

    SELECT * 
      FROM jml_djcf_profiles 
      WHERE user_id IN (48382,48382,45618,45618,45618,45618,45618)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jml_djcf_profiles	range	PRIMARY	PRIMARY	4	NULL	2	50.00	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.25 ms
    System lock	0.01 ms
    optimizing	0.07 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/items.php:341
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 1.57 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 3.964 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 265
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.06 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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: 1.96 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 3.969 MB Rows returned: 25
    Duplicate queries: #17

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.18 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:538
    15	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:552
    14	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:270
    13	DJClassifiedsCategory::getParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:146
    12	DJClassifiedsSEO::getItemsMenuItem()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:62
    11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/models/items.php:405
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

28. Query Time: 1.50 ms After last query: 1.76 ms Query memory: 0.022 MB Memory before query: 4.030 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 221
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.05 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

29. Query Time: 4.25 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 4.039 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 300
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

30. Query Time: 1.16 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 4.047 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 299
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

31. Query Time: 3.91 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 4.055 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 298
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

32. Query Time: 5.39 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 4.063 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 297
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.16 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

33. Query Time: 4.53 ms After last query: 0.26 ms Query memory: 0.024 MB Memory before query: 4.078 MB Rows returned: 0

    SELECT fv.*,f.*
    
      FROM jml_djcf_fields f
    
      INNER JOIN jml_djcf_fields_values fv 
      ON f.id = fv.field_id 
      AND fv.item_id = 293
    
      WHERE f.source IN (0,1) 
      AND f.published = 1 
      AND f.name IN ('price','contact','address','postcode','website','video','intro_desc','description','metakey','metadesc','email','region_id','type_id') 
      AND f.name NOT IN ("type_id","region_id")

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.05 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 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/djfield.php:1060
    11	DJClassifiedsField::convertOverwritableFieldsValues()	JROOT/components/com_djclassifieds/models/items.php:403
    10	DjclassifiedsModelItems->getItems()	JROOT/components/com_djclassifieds/views/items/view.html.php:358
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

34. Query Time: 4.08 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 4.082 MB Rows returned: 1

    SELECT count(id) 
      FROM (SELECT i.*, c.name c_name, c.alias c_alias, c.id c_id, c.rev_group_id, c.restriction_18 c_restr_18, c.schema_type c_schema_type, r.name r_name, r.id r_id, r.alias r_alias, u.name u_name, u.username as u_username, u.name as username, u.email as u_email, p.group_id, p.verified p_verified 
      FROM jml_djcf_items i 
      LEFT JOIN jml_djcf_categories c 
      ON i.cat_id=c.id 
      LEFT JOIN jml_djcf_regions r 
      ON i.region_id=r.id 
      LEFT JOIN jml_users u 
      ON i.user_id=u.id 
      LEFT JOIN jml_djcf_profiles p 
      ON u.id=p.user_id 
      WHERE i.blocked=0 
      AND c.published!=0 
      AND c.access_view IN (0,1,1) 
      AND i.published=1 
      AND i.date_exp > '2024-10-14 14:09:10' 
      ORDER BY i.special DESC, i.date_sort DESC) as q

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	<derived2>	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	NULL
    2	DERIVED	i	range	cat_id,published,blocked,date_exp	date_exp	4	NULL	11	81.82	Using index condition; Using where; Using temporary; Using filesort
    2	DERIVED	r	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	c	eq_ref	PRIMARY,published	PRIMARY	4	S44BD4Ta_new.i.cat_id	1	100.00	Using where
    2	DERIVED	u	eq_ref	PRIMARY	PRIMARY	4	S44BD4Ta_new.i.user_id	1	100.00	NULL
    2	DERIVED	p	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.22 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.05 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.32 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.50 ms
    Creating sort index	0.17 ms
    removing tmp table	0.08 ms
    Creating sort index	0.03 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.07 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Call Stack

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

    ---

35. Query Time: 3.75 ms After last query: 2.58 ms Query memory: 0.022 MB Memory before query: 4.140 MB Rows returned: 1

    SELECT f.* 
      FROM jml_djcf_fields f 
      WHERE f.published=1 
      AND (f.in_table>0 OR f.in_blog=1) 
      ORDER BY f.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	system	published	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

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

    ---

36. Query Time: 2.09 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 4.151 MB Rows returned: 0
    Duplicate queries: #20

    SELECT * 
      FROM jml_djcf_fields 
      WHERE published=1 
      AND source IN (0,1) 
      AND sortable=1 
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.00 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djfield.php:44
    10	DJClassifiedsField::getSortFields()	JROOT/components/com_djclassifieds/views/items/view.html.php:436
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

37. Query Time: 10.79 ms After last query: 4.98 ms Query memory: 0.075 MB Memory before query: 4.267 MB Rows returned: 59

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM jml_modules AS m
    
      LEFT JOIN jml_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN jml_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.access IN (1,1) 
      AND m.client_id = 0
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	published,newsfeeds	published	1	const	61	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	S44BD4Ta_new.m.id	1	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	S44BD4Ta_new.m.module,const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.05 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.07 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.08 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
    22	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
    21	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:405
    18	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
    17	JModuleHelper::getModules()	JROOT/components/com_djclassifieds/layouts/moduleposition.php:14
    16	include JROOT/components/com_djclassifieds/layouts/moduleposition.php	JROOT/libraries/src/Layout/FileLayout.php:125
    15	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:457
    14	DJClassifiedsTheme::renderLayout()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:462
    13	DJClassifiedsTheme::renderModule()	JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php:33
    12	include JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
    10	JViewLegacy->display()	JROOT/components/com_djclassifieds/views/items/view.html.php:477
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

38. Query Time: 1.17 ms After last query: 10.24 ms Query memory: 0.029 MB Memory before query: 4.530 MB Rows returned: 1

    SELECT t.parent_id
    
      FROM jml_menu as t
    
      WHERE t.id = 2169

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.22 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    27	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:151
    26	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:72
    25	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:54
    24	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:781
    23	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:201
    22	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:111
    21	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:405
    18	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
    17	JModuleHelper::getModules()	JROOT/components/com_djclassifieds/layouts/moduleposition.php:14
    16	include JROOT/components/com_djclassifieds/layouts/moduleposition.php	JROOT/libraries/src/Layout/FileLayout.php:125
    15	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:457
    14	DJClassifiedsTheme::renderLayout()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:462
    13	DJClassifiedsTheme::renderModule()	JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php:33
    12	include JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
    10	JViewLegacy->display()	JROOT/components/com_djclassifieds/views/items/view.html.php:477
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

39. Query Time: 0.97 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 4.543 MB Rows returned: 1

    SELECT t.parent_id
    
      FROM jml_menu as t
    
      WHERE t.id = 2008

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.05 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.09 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    27	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:151
    26	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:72
    25	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:54
    24	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:781
    23	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:201
    22	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:111
    21	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:405
    18	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
    17	JModuleHelper::getModules()	JROOT/components/com_djclassifieds/layouts/moduleposition.php:14
    16	include JROOT/components/com_djclassifieds/layouts/moduleposition.php	JROOT/libraries/src/Layout/FileLayout.php:125
    15	Joomla\CMS\Layout\FileLayout->render()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:457
    14	DJClassifiedsTheme::renderLayout()	JROOT/administrator/components/com_djclassifieds/lib/djtheme.php:462
    13	DJClassifiedsTheme::renderModule()	JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php:33
    12	include JROOT/components/com_djclassifieds/views/items/tmpl/default_cat.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
    10	JViewLegacy->display()	JROOT/components/com_djclassifieds/views/items/view.html.php:477
    9	DJClassifiedsViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:82
    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.]

    ---

40. Query Time: 2.79 ms After last query: 0.08 ms Query memory: 0.029 MB Memory before query: 4.556 MB Rows returned: 1
    <