Query Time: 0.27 ms Query memory: 0.023 MB Memory before query: 1.032 MB Rows returned: 0
SELECT `data`
FROM `ref1_session`
WHERE `session_id` = X'3166383034656263316236626335333837306338303034336430633862343638'
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.05 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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.14 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 1.046 MB Rows returned: 0
SELECT `session_id`
FROM `ref1_session`
WHERE `session_id` = X'3166383034656263316236626335333837306338303034336430633862343638'
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.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 |
executing | 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 |
# | 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.79 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.051 MB
INSERT INTO `ref1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3166383034656263316236626335333837306338303034336430633862343638', 1, 1714646596, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `ref1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3166383034656263316236626335333837306338303034336430633862343638', 1, 1714646596, 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.00 ms |
update | 0.08 ms |
end | 0.00 ms |
query end | 0.59 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 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: 1.08 ms Query memory: 0.021 MB Memory before query: 1.125 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.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
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.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 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 |
---|
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.57 ms After last query: 2.54 ms Query memory: 0.006 MB Memory before query: 1.578 MB
UPDATE `ref1_extensions`
SET `params` = '{\"mediaversion\":\"919290298826eb4941bccd9a8f80877f\"}'
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.02 ms |
init | 0.01 ms |
System lock | 0.07 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.60 ms After last query: 13.11 ms Query memory: 0.029 MB Memory before query: 2.328 MB Rows returned: 122
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
Status | Duration |
---|
starting | 0.02 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.39 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.00 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.20 ms After last query: 0.36 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;
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.03 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 |
# | 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.95 ms Query memory: 0.024 MB Memory before query: 2.593 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.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.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.43 ms Query memory: 0.024 MB Memory before query: 2.631 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.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/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.30 ms After last query: 1.27 ms Query memory: 0.023 MB Memory before query: 2.681 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` = '71';
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.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.03 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.43 ms Query memory: 0.023 MB Memory before query: 2.694 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 ('1');
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.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 |
---|
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.31 ms After last query: 1.90 ms Query memory: 0.025 MB Memory before query: 2.781 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` = '71';
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.13 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 |
Opening tables | 0.06 ms |
init | 0.06 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.01 ms |
Sorting result | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
executing | 0.00 ms |
Sending data | 13.65 ms |
Creating sort index | 0.09 ms |
end | 0.00 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.00 ms |
closing tables | 0.01 ms |
freeing items | 1.04 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.46 ms After last query: 0.97 ms Query memory: 0.024 MB Memory before query: 2.813 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 ('71');
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.26 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.44 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.39 ms Query memory: 0.023 MB Memory before query: 2.815 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` = '71';
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 | 4 | 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.03 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 1.39 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.75 ms After last query: 1.35 ms Query memory: 0.025 MB Memory before query: 2.863 MB Rows returned: 3
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` = '71'
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 | 4 | 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.09 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.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.04 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.26 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 | 2.69 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.24 ms After last query: 2.62 ms Query memory: 0.025 MB Memory before query: 2.887 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 ('93', '191', '192');
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Attachment | NULL | ALL | post_id | NO INDEX KEY COULD BE USED | NULL | NULL | 11 | 27.27 | Using where |
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.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 |
---|
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.10 ms Query memory: 0.024 MB Memory before query: 2.897 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 ('93', '191', '192')
GROUP BY `VoteCounter.post_id`;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | VoteCounter | NULL | index | post_id | post_id | 4 | NULL | 7 | 42.86 | 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.02 ms |
preparing | 0.02 ms |
Sorting result | 0.00 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.22 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 2.906 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 ('93', '191', '192');
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.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.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.902 MB
UPDATE `ref1_chronoengine_forums2_topics` AS `Topic`
SET `hits` = `hits`+ 1
WHERE `id` = '71';
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.67 ms After last query: 8.77 ms Query memory: 0.024 MB Memory before query: 2.944 MB Rows returned: 13
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ref1_modules AS m
LEFT JOIN ref1_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ref1_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-02 10:43:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-02 10:43:16')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 474 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 21 | 3.12 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | joomla_alternatememories.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.m.id | 1 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.31 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/alternate-memories_one/index.php:159 |
7 | require JROOT/templates/alternate-memories_one/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.49 ms After last query: 48.91 ms Query memory: 0.042 MB Memory before query: 3.039 MB Rows returned: 14
SELECT *
FROM `ref1_content_types`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ref1_content_types | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 13 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 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/src/Helper/TagsHelper.php:794 |
16 | Joomla\CMS\Helper\TagsHelper::getTypes() | JROOT/libraries/src/Helper/TagsHelper.php:628 |
15 | Joomla\CMS\Helper\TagsHelper->getTagItemsQuery() | JROOT/modules/mod_mini_index/helper.php:74 |
14 | ModTagsselectedHelper::getContentList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:596 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_mini_index/mod_mini_index.php:22 |
10 | include JROOT/modules/mod_mini_index/mod_mini_index.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 0.19 ms Query memory: 0.029 MB Memory before query: 3.054 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.16 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
15 | Joomla\CMS\User\User->authorise() | JROOT/modules/mod_mini_index/helper.php:78 |
14 | ModTagsselectedHelper::getContentList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:596 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_mini_index/mod_mini_index.php:22 |
10 | include JROOT/modules/mod_mini_index/mod_mini_index.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 22.58 ms After last query: 0.35 ms Query memory: 0.043 MB Memory before query: 3.115 MB Rows returned: 10
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM ref1_contentitem_tag_map AS m
INNER JOIN ref1_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (0,1)
INNER JOIN ref1_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN ref1_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN ref1_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (2)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_djimageslider.category')
AND c.core_access IN (0,1,5)
AND c.core_state = 1
AND c.core_publish_up < NOW()
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_publish_up`) DESC
LIMIT 10
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_core_content_id | NO INDEX KEY COULD BE USED | NULL | NULL | 551 | 50.00 | Using where; Using temporary; Using filesort |
1 | SIMPLE | ct | NULL | ref | idx_alias | idx_alias | 402 | joomla_alternatememories.m.type_alias | 1 | 100.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,tag_idx,idx_access,idx_content_type | PRIMARY | 4 | joomla_alternatememories.m.core_content_id | 1 | 5.00 | Using where |
1 | SIMPLE | tc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.c.core_catid | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.c.core_created_user_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.24 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.15 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.03 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 20.81 ms |
Creating sort index | 0.84 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.09 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 5.38 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_mini_index/helper.php:119 |
14 | ModTagsselectedHelper::getContentList() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:596 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_mini_index/mod_mini_index.php:22 |
10 | include JROOT/modules/mod_mini_index/mod_mini_index.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.79 ms After last query: 49.03 ms Query memory: 0.029 MB Memory before query: 3.183 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.21 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.11 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.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.19 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 3.207 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.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.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.43 ms After last query: 0.17 ms Query memory: 0.029 MB Memory before query: 3.222 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.02 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.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.16 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 3.231 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.20 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 3.239 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=597
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.42 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 3.253 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
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 |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.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.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.16 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.262 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=596
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.00 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.276 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
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 |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.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.13 ms Query memory: 0.023 MB Memory before query: 3.293 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=595
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.00 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.49 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 3.308 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
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 |
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.14 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 |
---|
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.318 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=594
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.00 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.17 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 3.325 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=593
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.42 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 3.339 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
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 |
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.00 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 |
# | 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.16 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.349 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=592
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.15 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 3.356 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=591
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.00 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.16 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 3.364 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=590
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.58 ms After last query: 53.16 ms Query memory: 0.026 MB Memory before query: 3.590 MB Rows returned: 5
SELECT `name`,`element`
FROM `ref1_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ref1_extensions | NULL | ref | extension | extension | 82 | const | 132 | 1.00 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 0.12 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_finder/helpers/language.php:126 |
17 | FinderHelperLanguage::loadPluginLanguage() | JROOT/modules/mod_finder/mod_finder.php:51 |
16 | include JROOT/modules/mod_finder/mod_finder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php:177 |
14 | require JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php | JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php:34 |
13 | include JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Same as call in the line below. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.22 ms After last query: 0.49 ms Query memory: 0.026 MB Memory before query: 3.612 MB Rows returned: 1
SELECT t1.id, t1.title, t2.title AS branch
FROM `ref1_finder_taxonomy` AS t1
INNER JOIN `ref1_finder_taxonomy` AS t2
ON t2.id = t1.parent_id
WHERE t1.state = 1
AND t1.access IN (1,1,5)
AND t1.id IN (71)
AND t2.state = 1
AND t2.access IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | t1 | NULL | const | PRIMARY,parent_id,state,access,idx_parent_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | t2 | NULL | const | PRIMARY,state,access | 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 | 1.00 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.01 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_finder/helpers/indexer/query.php:620 |
19 | FinderIndexerQuery->processDynamicTaxonomy() | JROOT/administrator/components/com_finder/helpers/indexer/query.php:220 |
18 | FinderIndexerQuery->__construct() | JROOT/modules/mod_finder/helper.php:84 |
17 | ModFinderHelper::getQuery() | JROOT/modules/mod_finder/mod_finder.php:54 |
16 | include JROOT/modules/mod_finder/mod_finder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php:177 |
14 | require JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php | JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php:34 |
13 | include JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Same as call in the line below. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.24 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 3.622 MB Rows returned: 4
SELECT `title`
FROM `ref1_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1,5)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ref1_finder_taxonomy | NULL | ref | parent_id,state,access,idx_parent_published | parent_id | 4 | const | 4 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.01 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 |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
21 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258 |
20 | FinderIndexerTaxonomy::getBranchTitles() | JROOT/administrator/components/com_finder/helpers/indexer/query.php:750 |
19 | FinderIndexerQuery->processString() | JROOT/administrator/components/com_finder/helpers/indexer/query.php:236 |
18 | FinderIndexerQuery->__construct() | JROOT/modules/mod_finder/helper.php:84 |
17 | ModFinderHelper::getQuery() | JROOT/modules/mod_finder/mod_finder.php:54 |
16 | include JROOT/modules/mod_finder/mod_finder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
15 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php:177 |
14 | require JROOT/templates/alternate-memories_one/html/mod_bootstrapnav/default.php | JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php:34 |
13 | include JROOT/modules/mod_bootstrapnav/mod_bootstrapnav.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Same as call in the line below. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:628 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 `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 t1.id, t1.title, t2.title AS branch
FROM `ref1_finder_taxonomy` AS t1
INNER JOIN `ref1_finder_taxonomy` AS t2
ON t2.id = t1.parent_id
1 × SELECT `name`,`element`
FROM `ref1_extensions`
1 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM ref1_contentitem_tag_map AS m
INNER JOIN ref1_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (0,1)
INNER JOIN ref1_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN ref1_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN ref1_users AS ua
ON ua.id = c.core_created_user_id
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ref1_assets`
1 × SELECT *
FROM `ref1_content_types
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ref1_modules AS m
LEFT JOIN ref1_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ref1_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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 `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 `session_id`
FROM `ref1_session`
1 × SELECT COUNT(`Post`.`id`) AS `Post.count`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
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 (`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 `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 `title`
FROM `ref1_finder_taxonomy`
The match is on youtube: https://www.youtube.com/watch?v=R76l7F0rgAM
In the "real" version of events, pro wrestler Mick Foley was on top of the cage. The roof of the cage ripped and Mick Foley fell to his death. He was survived by his wife and children.
In the "current-fake" version of events, pro wrestler Mick Foley is thrown from top of the cage twice, but manages to survive.
The naysayers will say that I am mistaken, because in 1998 pro wrestler Owen Hart died when he was being lowered from the ceiling down in front of a live audience. The line "snapped" and Owen fell to his death.
Owen Hart death: https://www.youtube.com/watch?v=NI8CbNI0_BQ
I found two posts online who remember something similar.
https://funnyjunk.com/Tinfoil+levels/funny-pictures/6330441/8
https://www.reddit.com/r/MandelaEffect/comments/4v6otc/mick_foley/
Presently, Mick Foley is alive.