{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1615277303,
                "last": 1615277303,
                "now": 1615277303
            },
            "token": "JczR3U0twi9qoLJ3bEDVpFHwbqFvTzcG"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Time

Memory

101 Queries Logged 169.24 ms

1. Query Time: 0.76 ms Query memory: 0.023 MB Memory before query: 3.817 MB Rows returned: 0

   SELECT `data`
   
     FROM `j3_session`
   
     WHERE `session_id` = X'3135386162323734323933646636613733316232353565636334356436373063'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j3_session	NULL	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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

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

   ---

2. Query Time: 0.33 ms After last query: 0.73 ms Query memory: 0.020 MB Memory before query: 3.913 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `j3_session`
   
     WHERE `session_id` = X'3135386162323734323933646636613733316232353565636334356436373063' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j3_session	NULL	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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

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

   ---

3. Query Time: 6.44 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 3.918 MB

   INSERT INTO `j3_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3135386162323734323933646636613733316232353565636334356436373063', 1, 1615277303, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3135386162323734323933646636613733316232353565636334356436373063', 1, 1615277303, 0, '', 0)

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.18 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.11 ms
   end	0.01 ms
   query end	5.87 ms
   closing tables	0.03 ms
   freeing items	0.05 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:51

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

   ---

4. Query Time: 1.95 ms After last query: 1.65 ms Query memory: 0.040 MB Memory before query: 4.195 MB Rows returned: 40

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j3_extensions	NULL	ref	extension	extension	62	const	40	1.00	Using where

   Profile

   Status	Duration
   starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.59 ms
   init	0.06 ms
   System lock	0.02 ms
   optimizing	0.05 ms
   statistics	0.14 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.59 ms
   end	0.04 ms
   query end	0.02 ms
   closing tables	0.03 ms
   freeing items	0.06 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/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

   ---

5. Query Time: 1.16 ms After last query: 1.40 ms Query memory: 0.021 MB Memory before query: 4.410 MB Rows returned: 5

   SELECT id, rules
   
     FROM `j3_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

   ---

6. Query Time: 1.63 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 4.422 MB Rows returned: 2

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

   ---

7. Query Time: 2.17 ms After last query: 0.41 ms Query memory: 0.030 MB Memory before query: 4.491 MB Rows returned: 107

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j3_extensions	NULL	ref	extension	extension	62	const	133	0.60	Using index condition; Using where; Using filesort

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

   ---

8. Query Time: 1.11 ms After last query: 10.05 ms Query memory: 0.021 MB Memory before query: 6.473 MB Rows returned: 2

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

   ---

9. Query Time: 0.57 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 6.482 MB Rows returned: 6

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `j3_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j3_extensions	NULL	ref	extension	extension	62	const	6	1.00	Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

   ---

10. Query Time: 0.60 ms After last query: 3.94 ms Query memory: 0.024 MB Memory before query: 6.837 MB Rows returned: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

    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.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
    8	plgSystemK2->onAfterInitialise()	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:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

11. Query Time: 5.61 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 6.830 MB

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	j3_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.14 ms
    updating	0.15 ms
    end	0.03 ms
    query end	4.79 ms
    closing tables	0.04 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
    8	plgSystemK2->onAfterInitialise()	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:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

12. Query Time: 3.78 ms After last query: 3.72 ms Query memory: 0.109 MB Memory before query: 7.440 MB Rows returned: 56

    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 j3_menu AS m
    
      LEFT JOIN j3_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	89	10.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.m.component_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.73 ms
    init	0.11 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.04 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	2.09 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->onAfterInitialise()	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:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

13. Query Time: 1.64 ms After last query: 10.90 ms Query memory: 0.025 MB Memory before query: 9.120 MB Rows returned: 5

    SELECT id, home, template, s.params
    
      FROM j3_template_styles as s
    
      LEFT JOIN j3_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	62	const	7	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	dbs1154626.e.element	1	71.43	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.60 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.21 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
    13	JHtmlJquery::framework()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:259
    9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

14. Query Time: 2.56 ms After last query: 9.29 ms Query memory: 0.028 MB Memory before query: 10.421 MB Rows returned: 39

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j3_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	385	10.65	Using where

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.02 ms
    Opening tables	0.71 ms
    init	0.17 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.20 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.85 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

15. Query Time: 19.27 ms After last query: 0.80 ms Query memory: 0.024 MB Memory before query: 10.616 MB Rows returned: 0

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM j3_content AS a
    
      LEFT JOIN j3_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN j3_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN j3_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN j3_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN j3_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.featured = 1 
      AND a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-09 08:08:23') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-09 08:08:23') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY c.lft,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 5

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid	1	const	1	10.48	Using where; Using temporary; Using filesort
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.a.modified_by	1	100.00	Using where
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbs1154626.a.catid	1	10.00	Using where
    1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.c.parent_id	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.a.id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.58 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	5.98 ms
    init	0.33 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	10.63 ms
    preparing	0.07 ms
    Creating tmp table	0.14 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.38 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.12 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.07 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

16. Query Time: 0.67 ms After last query: 0.72 ms Query memory: 0.023 MB Memory before query: 10.712 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM j3_content AS a
    
      LEFT JOIN j3_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN j3_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN j3_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN j3_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN j3_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.featured = 1 
      AND a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-09 08:08:23') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-09 08:08:23') 
      AND a.language IN ('en-GB','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid	1	const	1	10.48	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.a.created_by	1	100.00	Using where; Using index
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbs1154626.a.catid	1	10.00	Using where
    1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.c.parent_id	1	100.00	Using where; Using index
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1154626.a.id	1	100.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

17. Query Time: 0.60 ms After last query: 3.48 ms Query memory: 0.021 MB Memory before query: 11.108 MB Rows returned: 3

    SELECT language,id
    
      FROM `j3_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j3_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	90	1.00	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.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.24 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

18. Query Time: 0.72 ms After last query: 0.66 ms Query memory: 0.021 MB Memory before query: 11.186 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `j3_menu` AS `c`
    
      INNER JOIN `j3_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `j3_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `j3_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 832

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

19. Query Time: 6.75 ms After last query: 5.21 ms Query memory: 0.021 MB Memory before query: 11.634 MB Rows returned: 7

    SELECT id 
      FROM j3_template_styles 
      ORDER BY id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j3_template_styles	NULL	index	NULL	PRIMARY	4	NULL	7	100.00	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329
    9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
    8	JMFTemplate->__construct()	JROOT/templates/jm-myplace/index.php:18
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

20. Query Time: 7.60 ms After last query: 6.09 ms Query memory: 0.084 MB Memory before query: 12.532 MB Rows returned: 65

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j3_modules AS m
    
      LEFT JOIN j3_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN j3_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-03-09 08:08:23') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-09 08:08:23') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 832 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	116	1.60	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	dbs1154626.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dbs1154626.m.id	3	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.56 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	6.32 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
    11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
    10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
    9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
    8	JMFTemplate->__construct()	JROOT/templates/jm-myplace/index.php:18
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

21. Query Time: 1.39 ms After last query: 9.65 ms Query memory: 0.045 MB Memory before query: 14.434 MB Rows returned: 29
    Duplicate queries: #33  #40

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:35
    31	modDjClassifiedsSearch::getCats()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:75
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

22. Query Time: 0.89 ms After last query: 0.09 ms Query memory: 0.045 MB Memory before query: 14.497 MB Rows returned: 29

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	29	30.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.05 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.03 ms
    preparing	0.02 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.14 ms
    end	0.01 ms
    query end	0.03 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:640
    31	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:91
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

23. Query Time: 1.78 ms After last query: 0.06 ms Query memory: 0.033 MB Memory before query: 14.560 MB Rows returned: 5

    SELECT i.cat_id, count(i.id) as items_count 
      FROM j3_djcf_items i 
      WHERE i.published=1 
      AND i.blocked=0 
      AND i.date_exp > '2021-03-09 09:00:00'  
      GROUP BY i.cat_id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	cat_id,published,blocked	published	4	const	54	33.33	Using index condition; Using where; Using temporary; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:552
    32	DJClassifiedsCategory::getItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:652
    31	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:91
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

24. Query Time: 2.55 ms After last query: 0.04 ms Query memory: 0.033 MB Memory before query: 14.580 MB Rows returned: 5

    SELECT ic.cat_id, count(ic.item_id) as items_count 
      FROM j3_djcf_items_categories ic, j3_djcf_items i 
      WHERE ic.item_id=i.id 
      AND i.published=1 
      AND i.blocked=0 
      AND i.date_exp > '2021-03-09 09:00:00' 
      GROUP BY ic.cat_id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	PRIMARY,published,blocked	published	4	const	54	33.33	Using where; Using temporary; Using filesort
    1	SIMPLE	ic	NULL	ref	item_id,cat_id	item_id	4	dbs1154626.i.id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:661
    31	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:91
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

25. Query Time: 5.49 ms After last query: 0.06 ms Query memory: 0.034 MB Memory before query: 14.600 MB Rows returned: 6
    Duplicate queries: #34  #41

    SELECT r.* 
      FROM j3_djcf_regions r 
      WHERE r.parent_id=0  
      ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	r	NULL	ref	parent_id	parent_id	4	const	6	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:500
    32	DJClassifiedsRegion::getRegionsMain()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:100
    31	DJClassifiedsRegion::getRegAll()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:102
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

26. Query Time: 1.04 ms After last query: 0.03 ms Query memory: 0.034 MB Memory before query: 14.622 MB Rows returned: 20
    Duplicate queries: #28  #35  #42

    SELECT i.region_id, count(i.id) as items_count 
      FROM j3_djcf_items i 
      WHERE i.published=1 
      AND i.blocked=0 
      AND i.date_exp > '2021-03-09 09:08:23' 
      GROUP BY i.region_id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	region_id,published,blocked	published	4	const	54	33.33	Using index condition; Using where; Using temporary; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:505
    32	DJClassifiedsRegion::getRegionsMain()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:100
    31	DJClassifiedsRegion::getRegAll()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:102
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

27. Query Time: 5.03 ms After last query: 0.04 ms Query memory: 0.072 MB Memory before query: 14.640 MB Rows returned: 226

    SELECT r.* 
      FROM j3_djcf_regions r 
      ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:560
    32	DJClassifiedsRegion::getRegionsSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:101
    31	DJClassifiedsRegion::getRegAll()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:102
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

28. Query Time: 1.01 ms After last query: 0.22 ms Query memory: 0.034 MB Memory before query: 14.850 MB Rows returned: 20
    Duplicate queries: #26  #35  #42

    SELECT i.region_id, count(i.id) as items_count 
      FROM j3_djcf_items i 
      WHERE i.published=1 
      AND i.blocked=0 
      AND i.date_exp > '2021-03-09 09:08:23' 
      GROUP BY i.region_id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	region_id,published,blocked	published	4	const	54	33.33	Using index condition; Using where; Using temporary; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:565
    32	DJClassifiedsRegion::getRegionsSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:101
    31	DJClassifiedsRegion::getRegAll()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:102
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

29. Query Time: 1.52 ms After last query: 0.38 ms Query memory: 0.033 MB Memory before query: 15.072 MB Rows returned: 3
    Duplicate queries: #36  #43

    SELECT t.id as value, t.name as text, '0' as disabled 
      FROM j3_djcf_types t 
      WHERE t.published=1 
      ORDER BY t.ordering

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:58
    31	modDjClassifiedsSearch::getTypes()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:107
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

30. Query Time: 0.93 ms After last query: 0.03 ms Query memory: 0.033 MB Memory before query: 15.090 MB Rows returned: 0
    Duplicate queries: #37  #44

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

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.61 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.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    32	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:72
    31	modDjClassifiedsSearch::getProfileGroups()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:108
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

31. Query Time: 0.49 ms After last query: 1.55 ms Query memory: 0.034 MB Memory before query: 15.281 MB Rows returned: 6
    Duplicate queries: #38  #45  #76  #81  #85

    SELECT  id, link 
    
      FROM  `j3_menu` 
    
      WHERE  link  LIKE '%index.php?option=com_djclassifieds&view=items&layout=blog&cid=%'  
      AND  published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j3_menu	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	130	1.11	Using where

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/components/com_jh/helpers/JhHelper.php:38
    32	JhHelper::getMenuItemsForCategories()	JROOT/templates/jm-myplace/html/mod_djclassifieds_search/default.php:29
    31	require JROOT/templates/jm-myplace/html/mod_djclassifieds_search/default.php	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:118
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56

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

    ---

32. Query Time: 2.37 ms After last query: 0.67 ms Query memory: 0.042 MB Memory before query: 15.383 MB Rows returned: 10

    SELECT f.*, fx.ordering 
      FROM j3_djcf_fields f, j3_djcf_fields_xref fx 
      WHERE f.id=fx.field_id 
      AND fx.cat_id  = 77 
      AND f.published=1 
      AND f.access=0 
      AND f.search_type!='' 
      AND f.in_search=1 
      AND f.source<2 
      ORDER BY fx.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	NULL	ALL	PRIMARY,published	NO INDEX KEY COULD BE USED	NULL	NULL	40	2.50	Using where; Using temporary; Using filesort
    1	SIMPLE	fx	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	253	1.00	Using where; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.93 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.57 ms
    Creating sort index	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.23 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/templates/jm-myplace/html/mod_djclassifieds_search/extrafields.php:89
    32	require JROOT/templates/jm-myplace/html/mod_djclassifieds_search/extrafields.php	JROOT/templates/jm-myplace/html/mod_djclassifieds_search/default.php:35
    31	require JROOT/templates/jm-myplace/html/mod_djclassifieds_search/default.php	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:118
    30	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    28	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:175
    27	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    26	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jm_simple_tabs/tmpl/default.php:110
    19	require JROOT/modules/mod_jm_simple_tabs/tmpl/default.php	JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php:146
    18	include JROOT/modules/mod_jm_simple_tabs/mod_jm_simple_tabs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    15	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    14	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-myplace/tpl/blocks/header-mod.php:14
    13	include JROOT/templates/jm-myplace/tpl/blocks/header-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    12	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:668
    11	JMFTemplate->renderBlocks()	JROOT/templates/jm-myplace/tpl/home-stepan-test.php:72
    10	include JROOT/templates/jm-myplace/tpl/home-stepan-test.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-myplace/index.php:19
    7	require JROOT/templates/jm-myplace/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:56