Identical Cats

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

Time

Memory

41 Queries Logged 117.55 ms

1. Query Time: 0.24 ms Query memory: 0.023 MB Memory before query: 1.032 MB Rows returned: 0

   SELECT `data`
   
     FROM `ref1_session`
   
     WHERE `session_id` = X'6439626536363932366330383261636339643637373336653333393734373638'

   Explain

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

   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.01 ms
   statistics	0.05 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.17 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 1.046 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ref1_session`
   
     WHERE `session_id` = X'6439626536363932366330383261636339643637373336653333393734373638' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 1.58 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.051 MB

   INSERT INTO `ref1_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6439626536363932366330383261636339643637373336653333393734373638', 1, 1714171368, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ref1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6439626536363932366330383261636339643637373336653333393734373638', 1, 1714171368, 0, '', 0)

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.51 ms
   end	0.01 ms
   query end	0.91 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

4. Query Time: 0.18 ms After last query: 1.16 ms Query memory: 0.021 MB Memory before query: 1.125 MB Rows returned: 5

   SELECT id, rules
   
     FROM `ref1_viewlevels`

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

5. Query Time: 0.37 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.137 MB Rows returned: 2

   SELECT b.id
   
     FROM ref1_usergroups AS a
   
     LEFT JOIN ref1_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.04 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

6. Query Time: 0.61 ms After last query: 3.16 ms Query memory: 0.006 MB Memory before query: 1.578 MB

   UPDATE `ref1_extensions`
   
     SET `params` = '{\"mediaversion\":\"6ce8492f1dce6e40e98bfa4f51901fb7\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jamp/jamp.php:1368
   7	PlgSystemJAmp->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.26 ms After last query: 11.70 ms Query memory: 0.019 MB Memory before query: 2.250 MB Rows returned: 1

   SELECT *
   
     FROM ref1_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	ref1_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using filesort

   Profile

   Status	Duration
   starting	0.04 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.01 ms
   preparing	0.01 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
   4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.86 ms After last query: 56.21 ms Query memory: 0.029 MB Memory before query: 2.386 MB Rows returned: 122

   SHOW TABLES

   Explain

   EXPLAIN not possible on query: SHOW TABLES

   Profile

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

   Call Stack

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   17	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
   16	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:48
   15	G2\L\Joomla\DatabaseAdapter->getTablesList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:36
   14	G2\L\Joomla\DatabaseAdapter->__construct()	JROOT/libraries/cegcore2/libs/database_object.php:29
   13	G2\L\DatabaseObject::getInstance()	JROOT/libraries/cegcore2/libs/database.php:48
   12	G2\L\Database::getInstance()	JROOT/libraries/cegcore2/libs/model.php:38
   11	G2\L\Model->__construct()	JROOT/libraries/cegcore2/libs/joomla/app.php:179
   10	G2\L\Joomla\App::set_user()	JROOT/libraries/cegcore2/libs/joomla/app.php:87
   9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
   8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
   7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
   6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.31 ms After last query: 0.49 ms Query memory: 0.024 MB Memory before query: 2.392 MB Rows returned: 11

   SELECT `
     Group`.`id` AS `
     Group.id`, `
     Group`.`parent_id` AS `
     Group.parent_id`, `
     Group`.`lft` AS `
     Group.lft`, `
     Group`.`rgt` AS `
     Group.rgt`, `
     Group`.`title` AS `
     Group.title` 
     FROM `ref1_usergroups` AS `
     Group` 
     ORDER BY `
     Group.parent_id` ASC;

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   13	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
   12	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
   11	G2\L\Model->select()	JROOT/libraries/cegcore2/libs/joomla/app.php:180
   10	G2\L\Joomla\App::set_user()	JROOT/libraries/cegcore2/libs/joomla/app.php:87
   9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
   8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
   7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
   6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.28 ms After last query: 4.01 ms Query memory: 0.023 MB Memory before query: 2.631 MB Rows returned: 1

    SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
      FROM `ref1_chronoengine_extensions` AS `Extension` 
      WHERE `Extension`.`name` = 'chronoforums';

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Extension	NULL	ref	name	name	767	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:66
    14	G2\L\Joomla\DatabaseAdapter->loadAssoc()	JROOT/libraries/cegcore2/libs/model.php:988
    13	G2\L\Model->select()	JROOT/libraries/cegcore2/libs/extension.php:62
    12	G2\L\Extension->settings()	JROOT/components/com_chronoforums2/chronoforums/app.php:23
    11	G2\E\Chronoforums\App->_initialize()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:124
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.24 ms After last query: 1.53 ms Query memory: 0.024 MB Memory before query: 2.677 MB Rows returned: 1

    SELECT `Acl`.`id` AS `Acl.id`, `Acl`.`aco` AS `Acl.aco`, `Acl`.`title` AS `Acl.title`, `Acl`.`enabled` AS `Acl.enabled`, `Acl`.`rules` AS `Acl.rules` 
      FROM `ref1_chronoengine_acls` AS `Acl` 
      WHERE `Acl`.`aco` IN ('ext=chronoforums') 
      AND `Acl`.`enabled` = '1' 
      ORDER BY `Acl.aco` DESC;

    Explain

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
    15	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
    14	G2\L\Model->select()	JROOT/libraries/cegcore2/libs/authorize.php:71
    13	G2\L\Authorize::authorized()	JROOT/libraries/cegcore2/libs/app.php:157
    12	G2\L\App::access()	JROOT/components/com_chronoforums2/chronoforums/app.php:40
    11	G2\E\Chronoforums\App->_initialize()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:124
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.22 ms After last query: 1.11 ms Query memory: 0.023 MB Memory before query: 2.725 MB Rows returned: 1

    SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`parent_id` AS `Forum.parent_id`, `Forum`.`title` AS `Forum.title`, `Forum`.`description` AS `Forum.description`, `Forum`.`alias` AS `Forum.alias`, `Forum`.`type` AS `Forum.type`, `Forum`.`path` AS `Forum.path`, `Forum`.`published` AS `Forum.published`, `Forum`.`created` AS `Forum.created`, `Forum`.`modified` AS `Forum.modified`, `Forum`.`ordering` AS `Forum.ordering`, `Forum`.`topic_count` AS `Forum.topic_count`, `Forum`.`post_count` AS `Forum.post_count`, `Forum`.`last_post` AS `Forum.last_post`, `Forum`.`params` AS `Forum.params`, `Forum`.`rules` AS `Forum.rules` 
      FROM `ref1_chronoengine_forums2_forums` AS `Forum` 
      WHERE `Forum`.`id` = '2';

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:66
    14	G2\L\Joomla\DatabaseAdapter->loadAssoc()	JROOT/libraries/cegcore2/libs/model.php:988
    13	G2\L\Model->select()	JROOT/components/com_chronoforums2/chronoforums/app.php:166
    12	G2\E\Chronoforums\App->setForum()	JROOT/components/com_chronoforums2/chronoforums/app.php:91
    11	G2\E\Chronoforums\App->_initialize()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:124
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.16 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 2.739 MB Rows returned: 1

    SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`title` AS `Forum.title`, `Forum`.`alias` AS `Forum.alias` 
      FROM `ref1_chronoengine_forums2_forums` AS `Forum` 
      WHERE `Forum`.`id` IN ('10');

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
    13	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
    12	G2\L\Model->select()	JROOT/components/com_chronoforums2/chronoforums/app.php:104
    11	G2\E\Chronoforums\App->_initialize()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:124
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.92 ms After last query: 1.18 ms Query memory: 0.024 MB Memory before query: 2.783 MB Rows returned: 0

    SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`parent_id` AS `Forum.parent_id`, `Forum`.`title` AS `Forum.title`, `Forum`.`description` AS `Forum.description`, `Forum`.`alias` AS `Forum.alias`, `Forum`.`type` AS `Forum.type`, `Forum`.`path` AS `Forum.path`, `Forum`.`published` AS `Forum.published`, `Forum`.`created` AS `Forum.created`, `Forum`.`modified` AS `Forum.modified`, `Forum`.`ordering` AS `Forum.ordering`, `Forum`.`topic_count` AS `Forum.topic_count`, `Forum`.`post_count` AS `Forum.post_count`, `Forum`.`last_post` AS `Forum.last_post`, `Forum`.`params` AS `Forum.params`, `Forum`.`rules` AS `Forum.rules`, `LastPost`.`id` AS `LastPost.id`, `LastPost`.`topic_id` AS `LastPost.topic_id`, `LastPost`.`created` AS `LastPost.created`, `LastPostUser`.`id` AS `LastPostUser.id`, `LastPostUser`.`username` AS `LastPostUser.username`, `LastPostUser`.`name` AS `LastPostUser.name`, `LastPostUserProfile`.`user_id` AS `LastPostUserProfile.user_id`, `LastPostUserProfile`.`params` AS `LastPostUserProfile.params`, `LastPostUserProfile`.`location` AS `LastPostUserProfile.location`, `LastPostUserProfile`.`avatar` AS `LastPostUserProfile.avatar`, `LastPostUserProfile`.`about` AS `LastPostUserProfile.about`, `LastPostUserProfile`.`signature` AS `LastPostUserProfile.signature`, `LastPostUserProfile`.`website` AS `LastPostUserProfile.website`, `LastPostUserProfile`.`dob` AS `LastPostUserProfile.dob`, `LastPostUserProfile`.`last_visit` AS `LastPostUserProfile.last_visit`, `LastPostUserProfile`.`last_activity` AS `LastPostUserProfile.last_activity`, `LastPostUserProfile`.`post_count` AS `LastPostUserProfile.post_count`, `LastPostUserProfile`.`vote_count` AS `LastPostUserProfile.vote_count`, `LastPostUserProfile`.`answer_count` AS `LastPostUserProfile.answer_count` 
      FROM `ref1_chronoengine_forums2_forums` AS `Forum` 
      LEFT JOIN `ref1_chronoengine_forums2_posts` AS `LastPost` 
      ON `Forum`.`last_post` = `LastPost`.`id` 
      LEFT JOIN `ref1_users` AS `LastPostUser` 
      ON `LastPost`.`user_id` = `LastPostUser`.`id` 
      LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `LastPostUserProfile` 
      ON `LastPost`.`user_id` = `LastPostUserProfile`.`user_id` 
      WHERE `Forum`.`published` = '1' 
      AND `Forum`.`path` LIKE '.0.10.2.%' 
      ORDER BY `Forum.ordering` ASC;

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Forum	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	6.67	Using where; Using filesort
    1	SIMPLE	LastPost	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.Forum.last_post	1	100.00	NULL
    1	SIMPLE	LastPostUser	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.LastPost.user_id	1	100.00	NULL
    1	SIMPLE	LastPostUserProfile	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.LastPost.user_id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
    13	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
    12	G2\L\Model->select()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:35
    11	G2\E\Chronoforums\C\Topics->index()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:127
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 3.82 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 2.790 MB Rows returned: 1

    SELECT COUNT(`Topic`.`id`) AS `Topic.count` 
      FROM `ref1_chronoengine_forums2_topics` AS `Topic` 
      WHERE `Topic`.`published` = '1' 
      AND `Topic`.`forum_id` = '2';

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	Topic	NULL	ref	forum_id,published	forum_id	4	const	38	99.97	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	3.52 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:66
    14	G2\L\Joomla\DatabaseAdapter->loadAssoc()	JROOT/libraries/cegcore2/libs/model.php:988
    13	G2\L\Model->select()	JROOT/libraries/cegcore2/admin/controllers/traits/paginate.php:19
    12	G2\E\Chronoforums\App->Paginate()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:75
    11	G2\E\Chronoforums\C\Topics->index()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:127
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 72.82 ms After last query: 2.56 ms Query memory: 0.084 MB Memory before query: 2.856 MB Rows returned: 30

    SELECT (CAST((
      CASE WHEN `TagSub`.`TopicTag.MaxOrdering` IS NULL THEN '0' ELSE `TagSub`.`TopicTag.MaxOrdering` END) AS UNSIGNED)) AS `Topic.TagOrdering`, (`AnsweredPost`.`Answer.post_id`) AS `Topic.answered`, `Topic`.`id` AS `Topic.id`, `Topic`.`forum_id` AS `Topic.forum_id`, `Topic`.`title` AS `Topic.title`, `Topic`.`alias` AS `Topic.alias`, `Topic`.`user_id` AS `Topic.user_id`, `Topic`.`published` AS `Topic.published`, `Topic`.`locked` AS `Topic.locked`, `Topic`.`created` AS `Topic.created`, `Topic`.`modified` AS `Topic.modified`, `Topic`.`hits` AS `Topic.hits`, `Topic`.`unique_id` AS `Topic.unique_id`, `Topic`.`params` AS `Topic.params`, `Topic`.`post_count` AS `Topic.post_count`, `Topic`.`last_post` AS `Topic.last_post`, `Forum`.`id` AS `Forum.id`, `Forum`.`title` AS `Forum.title`, `Forum`.`alias` AS `Forum.alias`, `Author`.`id` AS `Author.id`, `Author`.`name` AS `Author.name`, `Author`.`username` AS `Author.username`, `AuthorProfile`.`user_id` AS `AuthorProfile.user_id`, `AuthorProfile`.`params` AS `AuthorProfile.params`, `AuthorProfile`.`location` AS `AuthorProfile.location`, `AuthorProfile`.`avatar` AS `AuthorProfile.avatar`, `AuthorProfile`.`about` AS `AuthorProfile.about`, `AuthorProfile`.`signature` AS `AuthorProfile.signature`, `AuthorProfile`.`website` AS `AuthorProfile.website`, `AuthorProfile`.`dob` AS `AuthorProfile.dob`, `AuthorProfile`.`last_visit` AS `AuthorProfile.last_visit`, `AuthorProfile`.`last_activity` AS `AuthorProfile.last_activity`, `AuthorProfile`.`post_count` AS `AuthorProfile.post_count`, `AuthorProfile`.`vote_count` AS `AuthorProfile.vote_count`, `AuthorProfile`.`answer_count` AS `AuthorProfile.answer_count`, `LastPost`.`id` AS `LastPost.id`, `LastPost`.`created` AS `LastPost.created`, `LastPost`.`text` AS `LastPost.text`, `LastPost`.`topic_id` AS `LastPost.topic_id`, `LastPostUser`.`id` AS `LastPostUser.id`, `LastPostUser`.`name` AS `LastPostUser.name`, `LastPostUser`.`username` AS `LastPostUser.username`, `LastPostUserProfile`.`user_id` AS `LastPostUserProfile.user_id`, `LastPostUserProfile`.`params` AS `LastPostUserProfile.params`, `LastPostUserProfile`.`location` AS `LastPostUserProfile.location`, `LastPostUserProfile`.`avatar` AS `LastPostUserProfile.avatar`, `LastPostUserProfile`.`about` AS `LastPostUserProfile.about`, `LastPostUserProfile`.`signature` AS `LastPostUserProfile.signature`, `LastPostUserProfile`.`website` AS `LastPostUserProfile.website`, `LastPostUserProfile`.`dob` AS `LastPostUserProfile.dob`, `LastPostUserProfile`.`last_visit` AS `LastPostUserProfile.last_visit`, `LastPostUserProfile`.`last_activity` AS `LastPostUserProfile.last_activity`, `LastPostUserProfile`.`post_count` AS `LastPostUserProfile.post_count`, `LastPostUserProfile`.`vote_count` AS `LastPostUserProfile.vote_count`, `LastPostUserProfile`.`answer_count` AS `LastPostUserProfile.answer_count`, `Featured`.`topic_id` AS `Featured.topic_id`, `Featured`.`user_id` AS `Featured.user_id`, `Featured`.`created` AS `Featured.created` 
      FROM `ref1_chronoengine_forums2_topics` AS `Topic` 
      LEFT JOIN (SELECT `TopicTag`.`tag_id` AS `TopicTag.tag_id`, `TopicTag`.`topic_id` AS `TopicTag.topic_id`, `Tag`.`id` AS `Tag.id`, `Tag`.`title` AS `Tag.title`, `Tag`.`alias` AS `Tag.alias`, `Tag`.`public` AS `Tag.public`, `Tag`.`published` AS `Tag.published`, `Tag`.`ordering` AS `Tag.ordering`, `Tag`.`description` AS `Tag.description`, `Tag`.`params` AS `Tag.params`, MAX(`Tag`.`ordering`) AS `TopicTag.MaxOrdering` 
      FROM `ref1_chronoengine_forums2_topics_tags` AS `TopicTag` 
      LEFT JOIN `ref1_chronoengine_tags` AS `Tag` 
      ON `TopicTag`.`tag_id` = `Tag`.`id` 
      GROUP BY `TopicTag.topic_id`) AS `TagSub` 
      ON `TagSub`.`TopicTag.topic_id` = `Topic`.`id` 
      LEFT JOIN `ref1_chronoengine_forums2_topics_featured` AS `Featured` 
      ON `Topic`.`id` = `Featured`.`topic_id` 
      LEFT JOIN (SELECT `Answer`.`post_id` AS `Answer.post_id`, `Post`.`topic_id` AS `Post.topic_id` 
      FROM `ref1_chronoengine_forums2_posts` AS `Post` 
      LEFT JOIN `ref1_chronoengine_forums2_posts_answers` AS `Answer` 
      ON `Post`.`id` = `Answer`.`post_id` 
      GROUP BY `Answer.post_id`) AS `AnsweredPost` 
      ON `AnsweredPost`.`Post.topic_id` = `Topic`.`id` 
      LEFT JOIN `ref1_chronoengine_forums2_forums` AS `Forum` 
      ON `Topic`.`forum_id` = `Forum`.`id` 
      LEFT JOIN `ref1_users` AS `Author` 
      ON `Topic`.`user_id` = `Author`.`id` 
      LEFT JOIN `ref1_chronoengine_forums2_posts` AS `LastPost` 
      ON `Topic`.`last_post` = `LastPost`.`id` 
      LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `AuthorProfile` 
      ON `Author`.`id` = `AuthorProfile`.`user_id` 
      LEFT JOIN `ref1_users` AS `LastPostUser` 
      ON `LastPost`.`user_id` = `LastPostUser`.`id` 
      LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `LastPostUserProfile` 
      ON `LastPost`.`user_id` = `LastPostUserProfile`.`user_id` 
      WHERE `Topic`.`published` = '1' 
      AND `Topic`.`forum_id` = '2' 
      GROUP BY `Topic.id` 
      ORDER BY `Topic.TagOrdering` DESC, `LastPost.created` DESC 
      LIMIT 30;

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	Topic	NULL	ref	PRIMARY,forum_id,published	forum_id	4	const	38	99.97	Using where; Using temporary; Using filesort
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	joomla_alternatememories.Topic.id	10	100.00	NULL
    1	PRIMARY	Featured	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	joomla_alternatememories.Topic.id	10	100.00	NULL
    1	PRIMARY	Forum	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.Topic.forum_id	1	100.00	Using where
    1	PRIMARY	Author	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.Topic.user_id	1	100.00	NULL
    1	PRIMARY	LastPost	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.Topic.last_post	1	100.00	NULL
    1	PRIMARY	AuthorProfile	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.Author.id	1	100.00	NULL
    1	PRIMARY	LastPostUser	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.LastPost.user_id	1	100.00	NULL
    1	PRIMARY	LastPostUserProfile	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.LastPost.user_id	1	100.00	NULL
    3	DERIVED	Post	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6089	100.00	Using temporary; Using filesort
    3	DERIVED	Answer	NULL	eq_ref	PRIMARY,user_id	PRIMARY	4	joomla_alternatememories.Post.id	1	100.00	Using index
    2	DERIVED	TopicTag	NULL	index	PRIMARY	PRIMARY	8	NULL	5179	100.00	Using index; Using temporary; Using filesort
    2	DERIVED	Tag	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.TopicTag.tag_id	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.32 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.13 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.12 ms
    Sending data	0.05 ms
    executing	0.00 ms
    Sending data	27.90 ms
    Creating sort index	30.25 ms
    executing	0.01 ms
    Sending data	12.09 ms
    Creating sort index	0.74 ms
    Creating sort index	0.46 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    removing tmp table	0.05 ms
    query end	0.00 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.05 ms
    closing tables	0.02 ms
    freeing items	3.65 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
    14	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
    13	G2\L\Model->select()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:180
    12	G2\E\Chronoforums\C\Topics->setTopics()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:79
    11	G2\E\Chronoforums\C\Topics->index()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:127
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 1.73 ms After last query: 39.04 ms Query memory: 0.033 MB Memory before query: 3.042 MB Rows returned: 28

    SELECT `Tag`.`id` AS `Tag.id`, `Tag`.`title` AS `Tag.title`, `Tag`.`alias` AS `Tag.alias`, `Tag`.`public` AS `Tag.public`, `Tag`.`published` AS `Tag.published`, `Tag`.`ordering` AS `Tag.ordering`, `Tag`.`description` AS `Tag.description`, `Tag`.`params` AS `Tag.params`, `TopicTag`.`tag_id` AS `TopicTag.tag_id`, `TopicTag`.`topic_id` AS `TopicTag.topic_id` 
      FROM `ref1_chronoengine_forums2_topics_tags` AS `TopicTag` 
      LEFT JOIN `ref1_chronoengine_tags` AS `Tag` 
      ON `TopicTag`.`tag_id` = `Tag`.`id` 
      WHERE `TopicTag`.`topic_id` IN ('4879', '4002', '3978', '3961', '3857', '3855', '3737', '3707', '3665', '3645', '3407', '3215', '3077', '2917', '2743', '2706', '2670', '2594', '1895', '1672', '1054', '804', '684', '674', '113', '112', '86', '58', '68', '54');

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	TopicTag	NULL	index	NULL	PRIMARY	8	NULL	5179	50.00	Using where; Using index
    1	SIMPLE	Tag	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.TopicTag.tag_id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
    16	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
    15	G2\L\Model->select()	JROOT/libraries/cegcore2/libs/model.php:670
    14	G2\L\Model->_relationsMany()	JROOT/libraries/cegcore2/libs/model.php:998
    13	G2\L\Model->select()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:180
    12	G2\E\Chronoforums\C\Topics->setTopics()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:79
    11	G2\E\Chronoforums\C\Topics->index()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:127
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.97 ms After last query: 7.03 ms Query memory: 0.026 MB Memory before query: 3.162 MB Rows returned: 30

    SELECT `PostsVotes`.`topic_id` AS `PostsVotes.topic_id`, SUM(`Votes`.`vote`) AS `Votes.count` 
      FROM `ref1_chronoengine_forums2_posts` AS `PostsVotes` 
      LEFT JOIN `ref1_chronoengine_forums2_posts_votes` AS `Votes` 
      ON `PostsVotes`.`id` = `Votes`.`post_id` 
      WHERE `PostsVotes`.`topic_id` IN ('4879', '4002', '3978', '3961', '3857', '3855', '3737', '3707', '3665', '3645', '3407', '3215', '3077', '2917', '2743', '2706', '2670', '2594', '1895', '1672', '1054', '804', '684', '674', '113', '112', '86', '58', '68', '54') 
      GROUP BY `PostsVotes.topic_id`;

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	PostsVotes	NULL	range	topic_id	topic_id	4	NULL	33	100.00	Using index condition
    1	SIMPLE	Votes	NULL	ref	post_id	post_id	4	joomla_alternatememories.PostsVotes.id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77
    16	G2\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/libraries/cegcore2/libs/model.php:991
    15	G2\L\Model->select()	JROOT/libraries/cegcore2/libs/model.php:670
    14	G2\L\Model->_relationsMany()	JROOT/libraries/cegcore2/libs/model.php:998
    13	G2\L\Model->select()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:180
    12	G2\E\Chronoforums\C\Topics->setTopics()	JROOT/components/com_chronoforums2/chronoforums/controllers/topics.php:79
    11	G2\E\Chronoforums\C\Topics->index()	JROOT/libraries/cegcore2/libs/app.php:322
    10	G2\L\App->processAction()	JROOT/libraries/cegcore2/libs/joomla/app.php:127
    9	G2\L\Joomla\App->dispatch()	JROOT/libraries/cegcore2/libs/app.php:110
    8	G2\L\App::call()	JROOT/libraries/cegcore2/libs/app_loader.php:64
    7	G2\L\AppLoader->__construct()	JROOT/components/com_chronoforums2/chronoforums2.php:7
    6	require_once JROOT/components/com_chronoforums2/chronoforums2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.95 ms After last query: 47.48 ms Query memory: 0.024 MB Memory before query: 3.435 MB Rows returned: 13

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ref1_modules AS m
    
      LEFT JOIN ref1_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ref1_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 <= '2024-04-26 22:42:48') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 22:42:48') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 474 OR mm.menuid <= 0)
    
      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	published	5	NULL	21	3.12	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla_alternatememories.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	joomla_alternatememories.m.id	1	40.00	Using where; Using index

    Profile

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.33 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/alternate-memories_one/index.php:159
    7	require JROOT/templates/alternate-memories_one/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.49 ms After last query: 164.73 ms Query memory: 0.042 MB Memory before query: 3.512 MB Rows returned: 14

    SELECT *
    
      FROM `ref1_content_types`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
    16	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
    15	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/modules/mod_mini_index/helper.php:74
    14	ModTagsselectedHelper::getContentList()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_mini_index/mod_mini_index.php:22
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.78 ms After last query: 0.19 ms Query memory: 0.029 MB Memory before query: 3.528 MB Rows returned: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ref1_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_chronoforums2','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plotalot','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_spambotcheck','com_tags','com_templates','com_users','com_wrapper')

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.16 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.36 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 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/modules/mod_mini_index/helper.php:78
    14	ModTagsselectedHelper::getContentList()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_mini_index/mod_mini_index.php:22
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 22.39 ms After last query: 0.36 ms Query memory: 0.043 MB Memory before query: 3.588 MB Rows returned: 10

    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM ref1_contentitem_tag_map AS m
    
      INNER JOIN ref1_ucm_content AS c 
      ON m.type_alias = c.core_type_alias 
      AND m.core_content_id = c.core_content_id 
      AND c.core_state IN (0,1)
    
      INNER JOIN ref1_content_types AS ct 
      ON ct.type_alias = m.type_alias
    
      LEFT JOIN ref1_categories AS tc 
      ON tc.id = c.core_catid
    
      LEFT JOIN ref1_users AS ua 
      ON ua.id = c.core_created_user_id
    
      WHERE m.tag_id IN (2) 
      AND (c.core_catid = 0 OR tc.published = 1) 
      AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_djimageslider.category') 
      AND c.core_access IN (0,1,5) 
      AND c.core_state = 1 
      AND c.core_publish_up < NOW()
    
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
    
      ORDER BY MAX(`c`.`core_publish_up`) DESC 
      LIMIT 10

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_core_content_id	NO INDEX KEY COULD BE USED	NULL	NULL	551	50.00	Using where; Using temporary; Using filesort
    1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	joomla_alternatememories.m.type_alias	1	100.00	Using where
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	joomla_alternatememories.m.core_content_id	1	5.00	Using where
    1	SIMPLE	tc	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.c.core_catid	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	joomla_alternatememories.c.core_created_user_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.14 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	20.65 ms
    Creating sort index	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.09 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	5.51 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_mini_index/helper.php:119
    14	ModTagsselectedHelper::getContentList()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_mini_index/mod_mini_index.php:22
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.78 ms After last query: 55.84 ms Query memory: 0.029 MB Memory before query: 3.625 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ref1_categories` AS `s`
    
      INNER JOIN `ref1_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 20
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	39	69.03	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_mini_index/tmpl/default.php:23
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.17 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 3.649 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=599

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.44 ms After last query: 0.17 ms Query memory: 0.029 MB Memory before query: 3.664 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ref1_categories` AS `s`
    
      INNER JOIN `ref1_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 15
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	39	71.33	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_mini_index/tmpl/default.php:23
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.15 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 3.673 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=598

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.15 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 3.681 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=597

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.41 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 3.695 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ref1_categories` AS `s`
    
      INNER JOIN `ref1_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 27
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	39	57.53	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_mini_index/tmpl/default.php:23
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.704 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=596

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.40 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 3.718 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ref1_categories` AS `s`
    
      INNER JOIN `ref1_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 14
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	39	52.93	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_mini_index/tmpl/default.php:23
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.732 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=595

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.40 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 3.746 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ref1_categories` AS `s`
    
      INNER JOIN `ref1_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 26
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	39	50.62	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_mini_index/tmpl/default.php:23
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 3.762 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=594

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.15 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.771 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=593

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.42 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 3.785 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `ref1_categories` AS `s`
    
      INNER JOIN `ref1_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 13
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	39	64.43	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_mini_index/tmpl/default.php:23
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.795 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=592

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.15 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.802 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=591

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.15 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 3.810 MB Rows returned: 1

    SELECT created 
      FROM ref1_content 
      WHERE id=590

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/modules/mod_mini_index/tmpl/default.php:51
    11	require JROOT/modules/mod_mini_index/tmpl/default.php	JROOT/modules/mod_mini_index/mod_mini_index.php:31
    10	include JROOT/modules/mod_mini_index/mod_mini_index.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.50 ms After last query: 57.94 ms Query memory: 0.026 MB Memory before query: 4.036 MB Rows returned: 5

    SELECT `name`,`element`
    
      FROM `ref1_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'finder' 
      AND `enabled` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ref1_extensions	NULL	ref	extension	extension	82	const	132	1.00	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
    17	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
    16	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php:177
    14	require JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php	JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php:34
    13	include JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 2.09 ms After last query: 0.93 ms Query memory: 0.026 MB Memory before query: 4.056 MB Rows returned: 0

    SELECT f.data, f.params
    
      FROM `ref1_finder_filters` AS f
    
      WHERE f.filter_id = 2

    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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.81 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	1.13 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:498
    19	FinderIndexerQuery->processStaticTaxonomy()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
    18	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
    17	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
    16	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php:177
    14	require JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php	JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php:34
    13	include JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.24 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 4.067 MB Rows returned: 4

    SELECT `title`
    
      FROM `ref1_finder_taxonomy`
    
      WHERE `parent_id` = 1 
      AND `state` = 1 
      AND `access` IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ref1_finder_taxonomy	NULL	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	4	100.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    21	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
    20	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
    19	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
    18	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
    17	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
    16	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php:177
    14	require JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php	JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php:34
    13	include JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---