Query Time: 0.28 ms Query memory: 0.023 MB Memory before query: 1.037 MB Rows returned: 0
SELECT `data`
FROM `ref1_session`
WHERE `session_id` = X'3965313032343636326636653136323733656532303263666336353132336665'
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 |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.15 ms After last query: 0.23 ms Query memory: 0.020 MB Memory before query: 1.051 MB Rows returned: 0
SELECT `session_id`
FROM `ref1_session`
WHERE `session_id` = X'3965313032343636326636653136323733656532303263666336353132336665'
LIMIT 1
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 |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.71 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.056 MB
INSERT INTO `ref1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3965313032343636326636653136323733656532303263666336353132336665', 1, 1731950450, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `ref1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3965313032343636326636653136323733656532303263666336353132336665', 1, 1731950450, 0, '', 0)
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.07 ms |
end | 0.00 ms |
query end | 0.52 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.01 ms |
# | 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 |
Query Time: 0.18 ms After last query: 0.96 ms Query memory: 0.021 MB Memory before query: 1.129 MB Rows returned: 5
SELECT id, rules
FROM `ref1_viewlevels`
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.27 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.142 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
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 |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.03 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.55 ms After last query: 2.26 ms Query memory: 0.006 MB Memory before query: 1.583 MB
UPDATE `ref1_extensions`
SET `params` = '{\"mediaversion\":\"940585dd966a3237fd783f1e5e0e456b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
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 |
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.05 ms |
end | 0.01 ms |
query end | 0.31 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.59 ms After last query: 13.41 ms Query memory: 0.029 MB Memory before query: 2.332 MB Rows returned: 122
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 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.35 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 |
# | 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 |
Query Time: 0.22 ms After last query: 0.35 ms Query memory: 0.023 MB Memory before query: 2.338 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;
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 |
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.01 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 |
# | 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 |
Query Time: 0.24 ms After last query: 2.91 ms Query memory: 0.024 MB Memory before query: 2.598 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';
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 |
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 |
# | 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 |
Query Time: 0.23 ms After last query: 1.44 ms Query memory: 0.024 MB Memory before query: 2.636 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;
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 |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.28 ms After last query: 1.15 ms Query memory: 0.023 MB Memory before query: 2.686 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`
LEFT JOIN `ref1_chronoengine_forums2_topics` AS `Topic`
ON `Forum`.`id` = `Topic`.`forum_id`
WHERE `Topic`.`id` = '58';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Topic | NULL | const | PRIMARY,forum_id | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | Forum | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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:174 |
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 |
Query Time: 0.16 ms After last query: 0.45 ms Query memory: 0.023 MB Memory before query: 2.699 MB Rows returned: 1
SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`title` AS `Forum.title`, `Forum`.`alias` AS `Forum.alias`
FROM `ref1_chronoengine_forums2_forums` AS `Forum`
WHERE `Forum`.`id` IN ('10');
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 |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 14.03 ms After last query: 1.73 ms Query memory: 0.025 MB Memory before query: 2.786 MB Rows returned: 1
SELECT (`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`, `TopicAuthor`.`id` AS `TopicAuthor.id`, `TopicAuthor`.`username` AS `TopicAuthor.username`, `TopicAuthor`.`name` AS `TopicAuthor.name`, `TopicAuthorProfile`.`user_id` AS `TopicAuthorProfile.user_id`, `TopicAuthorProfile`.`params` AS `TopicAuthorProfile.params`, `TopicAuthorProfile`.`location` AS `TopicAuthorProfile.location`, `TopicAuthorProfile`.`avatar` AS `TopicAuthorProfile.avatar`, `TopicAuthorProfile`.`about` AS `TopicAuthorProfile.about`, `TopicAuthorProfile`.`signature` AS `TopicAuthorProfile.signature`, `TopicAuthorProfile`.`website` AS `TopicAuthorProfile.website`, `TopicAuthorProfile`.`dob` AS `TopicAuthorProfile.dob`, `TopicAuthorProfile`.`last_visit` AS `TopicAuthorProfile.last_visit`, `TopicAuthorProfile`.`last_activity` AS `TopicAuthorProfile.last_activity`, `TopicAuthorProfile`.`post_count` AS `TopicAuthorProfile.post_count`, `TopicAuthorProfile`.`vote_count` AS `TopicAuthorProfile.vote_count`, `TopicAuthorProfile`.`answer_count` AS `TopicAuthorProfile.answer_count`, `Featured`.`topic_id` AS `Featured.topic_id`, `Featured`.`user_id` AS `Featured.user_id`, `Featured`.`created` AS `Featured.created`, `Favorite`.`topic_id` AS `Favorite.topic_id`, `Favorite`.`user_id` AS `Favorite.user_id`, `Favorite`.`created` AS `Favorite.created`, `TopicSubscriber`.`topic_id` AS `TopicSubscriber.topic_id`, `TopicSubscriber`.`user_id` AS `TopicSubscriber.user_id`, `TopicSubscriber`.`notified` AS `TopicSubscriber.notified`, `TopicSubscriber`.`created` AS `TopicSubscriber.created`, `TopicSubscriber`.`topic_id` AS `TopicSubscriber.topic_id`, `TopicSubscriber`.`user_id` AS `TopicSubscriber.user_id`, `TopicSubscriber`.`notified` AS `TopicSubscriber.notified`, `TopicSubscriber`.`created` AS `TopicSubscriber.created`
FROM `ref1_chronoengine_forums2_topics` AS `Topic`
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_users` AS `TopicAuthor`
ON `Topic`.`user_id` = `TopicAuthor`.`id`
LEFT JOIN `ref1_chronoengine_forums2_topics_featured` AS `Featured`
ON `Topic`.`id` = `Featured`.`topic_id`
LEFT JOIN `ref1_chronoengine_forums2_topics_favorites` AS `Favorite`
ON `Favorite`.`topic_id` = `Topic`.`id`
AND `Favorite`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_topics_subscribers` AS `TopicSubscriber`
ON `TopicSubscriber`.`topic_id` = `Topic`.`id`
AND `TopicSubscriber`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `TopicAuthorProfile`
ON `TopicAuthor`.`id` = `TopicAuthorProfile`.`user_id`
WHERE `Topic`.`id` = '58';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | Topic | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 10 | 100.00 | NULL |
1 | PRIMARY | TopicAuthor | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | Featured | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | Favorite | NULL | const | PRIMARY | PRIMARY | 8 | const,const | 1 | 100.00 | NULL |
1 | PRIMARY | TopicSubscriber | NULL | const | id_user_type | id_user_type | 8 | const,const | 1 | 100.00 | NULL |
1 | PRIMARY | TopicAuthorProfile | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.TopicAuthor.id | 1 | 100.00 | NULL |
2 | DERIVED | Post | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6089 | 100.00 | Using temporary; Using filesort |
2 | DERIVED | Answer | NULL | eq_ref | PRIMARY,user_id | PRIMARY | 4 | joomla_alternatememories.Post.id | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.12 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.06 ms |
System lock | 0.01 ms |
optimizing | 0.00 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Creating tmp table | 0.01 ms |
Sorting result | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
executing | 0.00 ms |
Sending data | 13.41 ms |
Creating sort index | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 1.05 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
14 | JDatabaseDriver->loadAssoc() | JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:66 |
13 | G2\L\Joomla\DatabaseAdapter->loadAssoc() | JROOT/libraries/cegcore2/libs/model.php:988 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:47 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 1.51 ms After last query: 0.97 ms Query memory: 0.024 MB Memory before query: 2.818 MB Rows returned: 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`
WHERE `TopicTag`.`topic_id` IN ('58');
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 | 10.00 | Using where; Using index |
1 | SIMPLE | Tag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.TopicTag.tag_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 1.30 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.70 ms |
cleaning up | 0.01 ms |
# | 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/model.php:670 |
13 | G2\L\Model->_relationsMany() | JROOT/libraries/cegcore2/libs/model.php:998 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:47 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.21 ms After last query: 0.64 ms Query memory: 0.023 MB Memory before query: 2.823 MB Rows returned: 1
SELECT COUNT(`Post`.`id`) AS `Post.count`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
WHERE `Post`.`published` = '1'
AND `Post`.`topic_id` = '58';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Post | NULL | ref | topic_id,published | topic_id | 4 | const | 2 | 99.97 | Using where |
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.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.32 ms |
cleaning up | 0.01 ms |
# | 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/posts.php:108 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.71 ms After last query: 1.72 ms Query memory: 0.025 MB Memory before query: 2.870 MB Rows returned: 2
SELECT `Post`.`id` AS `Post.id`, `Post`.`topic_id` AS `Post.topic_id`, `Post`.`text` AS `Post.text`, `Post`.`user_id` AS `Post.user_id`, `Post`.`created` AS `Post.created`, `Post`.`modified` AS `Post.modified`, `Post`.`published` AS `Post.published`, `Post`.`remote_address` AS `Post.remote_address`, `Topic`.`id` AS `Topic.id`, `Topic`.`user_id` AS `Topic.user_id`, `Topic`.`forum_id` AS `Topic.forum_id`, `Topic`.`locked` AS `Topic.locked`, `Topic`.`title` AS `Topic.title`, `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`, `Answer`.`post_id` AS `Answer.post_id`, `Answer`.`user_id` AS `Answer.user_id`, `Answer`.`created` AS `Answer.created`, `Vote`.`post_id` AS `Vote.post_id`, `Vote`.`user_id` AS `Vote.user_id`, `Vote`.`vote` AS `Vote.vote`, `Vote`.`created` AS `Vote.created`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
LEFT JOIN `ref1_users` AS `Author`
ON `Post`.`user_id` = `Author`.`id`
LEFT JOIN `ref1_chronoengine_forums2_topics` AS `Topic`
ON `Post`.`topic_id` = `Topic`.`id`
LEFT JOIN `ref1_chronoengine_forums2_posts_answers` AS `Answer`
ON `Post`.`id` = `Answer`.`post_id`
LEFT JOIN `ref1_chronoengine_forums2_posts_votes` AS `Vote`
ON `Post`.`id` = `Vote`.`post_id`
AND `Vote`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `AuthorProfile`
ON `Author`.`id` = `AuthorProfile`.`user_id`
WHERE `Post`.`published` = '1'
AND `Post`.`topic_id` = '58'
GROUP BY `Post.id`
ORDER BY `Post.created` ASC
LIMIT 30;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Post | NULL | ref | PRIMARY,topic_id,published | topic_id | 4 | const | 2 | 99.97 | Using where; Using temporary; Using filesort |
1 | SIMPLE | Author | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.Post.user_id | 1 | 100.00 | NULL |
1 | SIMPLE | Topic | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.Post.topic_id | 1 | 100.00 | NULL |
1 | SIMPLE | Answer | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | SIMPLE | Vote | NULL | ref | post_id,user_id | post_id | 4 | joomla_alternatememories.Post.id | 1 | 100.00 | Using where |
1 | SIMPLE | AuthorProfile | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.Author.id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
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.05 ms |
preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.21 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 1.76 ms |
cleaning up | 0.01 ms |
# | 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/posts.php:115 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.22 ms After last query: 1.69 ms Query memory: 0.025 MB Memory before query: 2.893 MB Rows returned: 0
SELECT `Attachment`.`id` AS `Attachment.id`, `Attachment`.`post_id` AS `Attachment.post_id`, `Attachment`.`user_id` AS `Attachment.user_id`, `Attachment`.`filename` AS `Attachment.filename`, `Attachment`.`vfilename` AS `Attachment.vfilename`, `Attachment`.`comment` AS `Attachment.comment`, `Attachment`.`downloads` AS `Attachment.downloads`, `Attachment`.`created` AS `Attachment.created`, `Attachment`.`size` AS `Attachment.size`
FROM `ref1_chronoengine_forums2_posts_attachments` AS `Attachment`
WHERE `Attachment`.`post_id` IN ('72', '80');
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Attachment | NULL | range | post_id | post_id | 4 | NULL | 2 | 100.00 | Using index condition |
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.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 |
# | 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/model.php:670 |
13 | G2\L\Model->_relationsMany() | JROOT/libraries/cegcore2/libs/model.php:998 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:115 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.20 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.903 MB Rows returned: 0
SELECT `VoteCounter`.`post_id` AS `VoteCounter.post_id`, SUM(`VoteCounter`.`vote`) AS `Post.VotesCount`
FROM `ref1_chronoengine_forums2_posts_votes` AS `VoteCounter`
WHERE `VoteCounter`.`post_id` IN ('72', '80')
GROUP BY `VoteCounter.post_id`;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | VoteCounter | NULL | range | post_id | post_id | 4 | NULL | 2 | 100.00 | Using index condition |
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 |
Sorting result | 0.00 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.30 ms |
# | 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/model.php:670 |
13 | G2\L\Model->_relationsMany() | JROOT/libraries/cegcore2/libs/model.php:998 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:115 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.22 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 2.912 MB Rows returned: 0
SELECT `Report`.`id` AS `Report.id`, `Report`.`post_id` AS `Report.post_id`, `Report`.`user_id` AS `Report.user_id`, `Report`.`reason` AS `Report.reason`, `Report`.`created` AS `Report.created`, `ReportAuthor`.`id` AS `ReportAuthor.id`, `ReportAuthor`.`username` AS `ReportAuthor.username`, `ReportAuthor`.`name` AS `ReportAuthor.name`
FROM `ref1_chronoengine_forums2_posts_reports` AS `Report`
LEFT JOIN `ref1_users` AS `ReportAuthor`
ON `Report`.`user_id` = `ReportAuthor`.`id`
WHERE `Report`.`post_id` IN ('72', '80');
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Report | NULL | ALL | post_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
1 | SIMPLE | ReportAuthor | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.Report.user_id | 1 | 100.00 | NULL |
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 | 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 |
# | 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/model.php:670 |
13 | G2\L\Model->_relationsMany() | JROOT/libraries/cegcore2/libs/model.php:998 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:115 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.19 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 2.908 MB
UPDATE `ref1_chronoengine_forums2_topics` AS `Topic`
SET `hits` = `hits`+ 1
WHERE `id` = '58';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | Topic | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.02 ms |
updating | 0.04 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
15 | JDatabase->query() | JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:127 |
14 | G2\L\Joomla\DatabaseAdapter->execute_query() | JROOT/libraries/cegcore2/libs/model.php:1316 |
13 | G2\L\Model->update() | JROOT/libraries/cegcore2/libs/model.php:1195 |
12 | G2\L\Model->increment() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:127 |
11 | G2\E\Chronoforums\C\Posts->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 |
Query Time: 0.50 ms After last query: 9.05 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 = 20
ORDER BY c.lft
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 |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 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.09 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 |
# | 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 |
Query Time: 0.17 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 3.034 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=599
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
Query Time: 0.41 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 3.048 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
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 |
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.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 |
# | 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 |
Query Time: 0.15 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 3.058 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=598
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 |
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 |
# | 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 |
Query Time: 0.67 ms After last query: 2.10 ms Query memory: 0.026 MB Memory before query: 3.220 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')
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 |
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.13 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.33 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 |
# | 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 |
2 × SELECT created
FROM ref1_content
2 × 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 `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 `Report`.`id` AS `Report.id`, `Report`.`post_id` AS `Report.post_id`, `Report`.`user_id` AS `Report.user_id`, `Report`.`reason` AS `Report.reason`, `Report`.`created` AS `Report.created`, `ReportAuthor`.`id` AS `ReportAuthor.id`, `ReportAuthor`.`username` AS `ReportAuthor.username`, `ReportAuthor`.`name` AS `ReportAuthor.name`
FROM `ref1_chronoengine_forums2_posts_reports` AS `Report`
LEFT JOIN `ref1_users` AS `ReportAuthor`
ON `Report`.`user_id` = `ReportAuthor`.`id`
1 × SELECT `VoteCounter`.`post_id` AS `VoteCounter.post_id`, SUM(`VoteCounter`.`vote`) AS `Post.VotesCount`
FROM `ref1_chronoengine_forums2_posts_votes` AS `VoteCounter`
1 × SELECT `Attachment`.`id` AS `Attachment.id`, `Attachment`.`post_id` AS `Attachment.post_id`, `Attachment`.`user_id` AS `Attachment.user_id`, `Attachment`.`filename` AS `Attachment.filename`, `Attachment`.`vfilename` AS `Attachment.vfilename`, `Attachment`.`comment` AS `Attachment.comment`, `Attachment`.`downloads` AS `Attachment.downloads`, `Attachment`.`created` AS `Attachment.created`, `Attachment`.`size` AS `Attachment.size`
FROM `ref1_chronoengine_forums2_posts_attachments` AS `Attachment`
1 × SELECT `Post`.`id` AS `Post.id`, `Post`.`topic_id` AS `Post.topic_id`, `Post`.`text` AS `Post.text`, `Post`.`user_id` AS `Post.user_id`, `Post`.`created` AS `Post.created`, `Post`.`modified` AS `Post.modified`, `Post`.`published` AS `Post.published`, `Post`.`remote_address` AS `Post.remote_address`, `Topic`.`id` AS `Topic.id`, `Topic`.`user_id` AS `Topic.user_id`, `Topic`.`forum_id` AS `Topic.forum_id`, `Topic`.`locked` AS `Topic.locked`, `Topic`.`title` AS `Topic.title`, `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`, `Answer`.`post_id` AS `Answer.post_id`, `Answer`.`user_id` AS `Answer.user_id`, `Answer`.`created` AS `Answer.created`, `Vote`.`post_id` AS `Vote.post_id`, `Vote`.`user_id` AS `Vote.user_id`, `Vote`.`vote` AS `Vote.vote`, `Vote`.`created` AS `Vote.created`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
LEFT JOIN `ref1_users` AS `Author`
ON `Post`.`user_id` = `Author`.`id`
LEFT JOIN `ref1_chronoengine_forums2_topics` AS `Topic`
ON `Post`.`topic_id` = `Topic`.`id`
LEFT JOIN `ref1_chronoengine_forums2_posts_answers` AS `Answer`
ON `Post`.`id` = `Answer`.`post_id`
LEFT JOIN `ref1_chronoengine_forums2_posts_votes` AS `Vote`
ON `Post`.`id` = `Vote`.`post_id`
AND `Vote`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `AuthorProfile`
ON `Author`.`id` = `AuthorProfile`.`user_id`
1 × SELECT COUNT(`Post`.`id`) AS `Post.count`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
1 × SELECT (`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`, `TopicAuthor`.`id` AS `TopicAuthor.id`, `TopicAuthor`.`username` AS `TopicAuthor.username`, `TopicAuthor`.`name` AS `TopicAuthor.name`, `TopicAuthorProfile`.`user_id` AS `TopicAuthorProfile.user_id`, `TopicAuthorProfile`.`params` AS `TopicAuthorProfile.params`, `TopicAuthorProfile`.`location` AS `TopicAuthorProfile.location`, `TopicAuthorProfile`.`avatar` AS `TopicAuthorProfile.avatar`, `TopicAuthorProfile`.`about` AS `TopicAuthorProfile.about`, `TopicAuthorProfile`.`signature` AS `TopicAuthorProfile.signature`, `TopicAuthorProfile`.`website` AS `TopicAuthorProfile.website`, `TopicAuthorProfile`.`dob` AS `TopicAuthorProfile.dob`, `TopicAuthorProfile`.`last_visit` AS `TopicAuthorProfile.last_visit`, `TopicAuthorProfile`.`last_activity` AS `TopicAuthorProfile.last_activity`, `TopicAuthorProfile`.`post_count` AS `TopicAuthorProfile.post_count`, `TopicAuthorProfile`.`vote_count` AS `TopicAuthorProfile.vote_count`, `TopicAuthorProfile`.`answer_count` AS `TopicAuthorProfile.answer_count`, `Featured`.`topic_id` AS `Featured.topic_id`, `Featured`.`user_id` AS `Featured.user_id`, `Featured`.`created` AS `Featured.created`, `Favorite`.`topic_id` AS `Favorite.topic_id`, `Favorite`.`user_id` AS `Favorite.user_id`, `Favorite`.`created` AS `Favorite.created`, `TopicSubscriber`.`topic_id` AS `TopicSubscriber.topic_id`, `TopicSubscriber`.`user_id` AS `TopicSubscriber.user_id`, `TopicSubscriber`.`notified` AS `TopicSubscriber.notified`, `TopicSubscriber`.`created` AS `TopicSubscriber.created`, `TopicSubscriber`.`topic_id` AS `TopicSubscriber.topic_id`, `TopicSubscriber`.`user_id` AS `TopicSubscriber.user_id`, `TopicSubscriber`.`notified` AS `TopicSubscriber.notified`, `TopicSubscriber`.`created` AS `TopicSubscriber.created`
FROM `ref1_chronoengine_forums2_topics` AS `Topic`
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_users` AS `TopicAuthor`
ON `Topic`.`user_id` = `TopicAuthor`.`id`
LEFT JOIN `ref1_chronoengine_forums2_topics_featured` AS `Featured`
ON `Topic`.`id` = `Featured`.`topic_id`
LEFT JOIN `ref1_chronoengine_forums2_topics_favorites` AS `Favorite`
ON `Favorite`.`topic_id` = `Topic`.`id`
AND `Favorite`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_topics_subscribers` AS `TopicSubscriber`
ON `TopicSubscriber`.`topic_id` = `Topic`.`id`
AND `TopicSubscriber`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `TopicAuthorProfile`
ON `TopicAuthor`.`id` = `TopicAuthorProfile`.`user_id`
1 × SELECT `session_id`
FROM `ref1_session`
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 `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`
LEFT JOIN `ref1_chronoengine_forums2_topics` AS `Topic`
ON `Forum`.`id` = `Topic`.`forum_id`
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`
I do not thing the Mandela Effect is the right term. Somehow dimension doors open or are somehow triggered by an event and if someone happens to be at the right place at the wrong moment in time we pass through that door into an alternate static dimension. We live and exist in the Dynamic and exact duplicates of us exist in the Static (other dimensions) and sometimes we change places because the static and dynamic cannot exist in the same place together.