Mandela Effect Forums - Alternate Memories

	Last Post
Welcome to the forums! 1 1229 carter.tweed , February 29 2020, 10:06 in Announcements	carter.tweed 29 January 03 2020, 13:06
Forum features 1 1011 carter.tweed , February 29 2020, 10:36 in Announcements	carter.tweed 29 January 03 2020, 08:36

Joomla! Debug Console

Session

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

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

#	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

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

#	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

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

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
update	0.06 ms
end	0.00 ms
query end	0.40 ms
closing tables	0.01 ms
freeing items	0.01 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.]

Query Time: 0.17 ms After last query: 0.97 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.00 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.]

Query Time: 0.22 ms After last query: 0.07 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.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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.]

Query Time: 0.61 ms After last query: 2.36 ms Query memory: 0.006 MB Memory before query: 1.578 MB

UPDATE `ref1_extensions`

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

  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.01 ms
init	0.01 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.]

Query Time: 0.56 ms After last query: 12.76 ms Query memory: 0.029 MB Memory before query: 2.328 MB Rows returned: 122

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.32 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	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
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.]

Query Time: 0.22 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 2.333 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.04 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
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	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
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.]

Query Time: 0.23 ms After last query: 3.43 ms Query memory: 0.024 MB Memory before query: 2.572 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.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.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
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.]

Query Time: 0.23 ms After last query: 1.40 ms Query memory: 0.024 MB Memory before query: 2.618 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.03 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.]

Query Time: 0.24 ms After last query: 0.99 ms Query memory: 0.023 MB Memory before query: 2.667 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` = '8';

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.03 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.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.]

Query Time: 0.16 ms After last query: 0.41 ms Query memory: 0.023 MB Memory before query: 2.681 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 ('7');

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.01 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.]

Query Time: 0.38 ms After last query: 1.05 ms Query memory: 0.024 MB Memory before query: 2.725 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.7.8.%' 
  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.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	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
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.]

Query Time: 0.22 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 2.732 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` = '8';

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	2	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	0.03 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
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.]

Query Time: 68.56 ms After last query: 2.07 ms Query memory: 0.042 MB Memory before query: 2.798 MB Rows returned: 2

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` = '8' 
  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	2	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.18 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
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.00 ms
Opening tables	0.05 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.10 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	27.89 ms
Creating sort index	29.08 ms
executing	0.01 ms
Sending data	10.12 ms
Creating sort index	0.28 ms
Creating sort index	0.08 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.00 ms
query end	0.01 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.06 ms
closing tables	0.02 ms
freeing items	3.15 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.]

Query Time: 1.57 ms After last query: 2.99 ms Query memory: 0.024 MB Memory before query: 2.824 MB Rows returned: 0

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 ('51', '52');

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	20.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.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.27 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.36 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/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.]

Query Time: 1.76 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 2.846 MB Rows returned: 2

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 ('51', '52') 
  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	2	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.03 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	1.53 ms
preparing	0.01 ms
Sorting result	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.50 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/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.]

Query Time: 0.50 ms After last query: 9.76 ms Query memory: 0.029 MB Memory before query: 2.970 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.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.08 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
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.]

Query Time: 0.20 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 2.995 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.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.03 ms
preparing	0.01 ms
executing	0.01 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.]

Query Time: 0.43 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 3.009 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.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.07 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
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.]

Query Time: 0.16 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.019 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.01 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.]

Query Time: 0.15 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.027 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.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.]

Query Time: 0.43 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 3.041 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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 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.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.]

Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.051 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.]

Query Time: 0.40 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 3.065 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.01 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.]

Query Time: 0.15 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.074 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.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.]

Query Time: 0.39 ms After last query: 0.14 ms Query memory: 0.029 MB Memory before query: 3.089 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.01 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.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.]

Query Time: 0.22 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.098 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.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.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.]

Query Time: 0.15 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.106 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.]

Query Time: 0.40 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 3.119 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.01 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.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.]

Query Time: 0.15 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 3.129 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.]

Query Time: 0.15 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 3.137 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.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.]

Query Time: 0.15 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 3.151 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.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.]

Query Time: 0.69 ms After last query: 2.04 ms Query memory: 0.026 MB Memory before query: 3.222 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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.36 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:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:49
9	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/sourcerer.php:145
8	PlgSystemSourcerer->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:146
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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 Types Logged, Sorted by Occurrences.

SELECT Tables:

10 × SELECT created 
  FROM ref1_content

6 × 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)

1 × SELECT `data` 
  FROM `ref1_session`

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`, `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`

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

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

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

1 × SELECT COUNT(`Topic`.`id`) AS `Topic.count` 
  FROM `ref1_chronoengine_forums2_topics` AS `Topic`

1 × SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`title` AS `Forum.title`, `Forum`.`alias` AS `Forum.alias` 
  FROM `ref1_chronoengine_forums2_forums` AS `Forum`

1 × SELECT `session_id` 
  FROM `ref1_session`

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`

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`

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`

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

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

1 × SELECT id, rules 
  FROM `ref1_viewlevels

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ref1_assets`

OTHER Tables:

1 × INSERT INTO `ref1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3838643530326264343734393034373937663462343034623639343934306162', 1, 1713495789, 0, '', 0

1 × UPDATE `ref1_extensions` 
  SET `params` = '{\"mediaversion\":\"d12115a4f8f15f30ae4e923a75dc7e16\"}'

```
1 × SHOW TABLE
```

Announcements

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

34 Queries Logged 80.97 ms

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: