Query Time: 2.76 ms Query memory: 0.023 MB Memory before query: 1.034 MB Rows returned: 0
SELECT `data`
FROM `ref1_session`
WHERE `session_id` = X'3661383263316636626430363237666539366132393065356233333437393935'
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.03 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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.16 ms After last query: 0.23 ms Query memory: 0.020 MB Memory before query: 1.049 MB Rows returned: 0
SELECT `session_id`
FROM `ref1_session`
WHERE `session_id` = X'3661383263316636626430363237666539366132393065356233333437393935'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ref1_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.37 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.054 MB
INSERT INTO `ref1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3661383263316636626430363237666539366132393065356233333437393935', 1, 1714732815, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `ref1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3661383263316636626430363237666539366132393065356233333437393935', 1, 1714732815, 0, '', 0)
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
update | 0.09 ms |
end | 0.01 ms |
query end | 1.10 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.24 ms After last query: 1.12 ms Query memory: 0.021 MB Memory before query: 1.127 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.26 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 1.139 MB Rows returned: 2
SELECT b.id
FROM ref1_usergroups AS a
LEFT JOIN ref1_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 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.94 ms After last query: 6.58 ms Query memory: 0.006 MB Memory before query: 1.581 MB
UPDATE `ref1_extensions`
SET `params` = '{\"mediaversion\":\"e4a9d5912facc53717e1076f0bef263c\"}'
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.02 ms |
System lock | 0.12 ms |
updating | 0.11 ms |
end | 0.01 ms |
query end | 0.56 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: 4.41 ms After last query: 25.27 ms Query memory: 0.029 MB Memory before query: 2.331 MB Rows returned: 122
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
checking permissions | 0.44 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 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/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.30 ms After last query: 0.45 ms Query memory: 0.023 MB Memory before query: 2.336 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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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: 1.51 ms After last query: 2.99 ms Query memory: 0.024 MB Memory before query: 2.596 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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.10 ms |
end | 0.00 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 |
---|
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: 1.36 ms After last query: 1.42 ms Query memory: 0.024 MB Memory before query: 2.634 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.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/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.50 ms After last query: 4.41 ms Query memory: 0.023 MB Memory before query: 2.684 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` = '5610';
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.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.26 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:66 |
14 | G2\L\Joomla\DatabaseAdapter->loadAssoc() | JROOT/libraries/cegcore2/libs/model.php:988 |
13 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/app.php:174 |
12 | G2\E\Chronoforums\App->setForum() | JROOT/components/com_chronoforums2/chronoforums/app.php:91 |
11 | G2\E\Chronoforums\App->_initialize() | JROOT/libraries/cegcore2/libs/app.php:322 |
10 | G2\L\App->processAction() | JROOT/libraries/cegcore2/libs/joomla/app.php:124 |
9 | G2\L\Joomla\App->dispatch() | JROOT/libraries/cegcore2/libs/app.php:110 |
8 | G2\L\App::call() | JROOT/libraries/cegcore2/libs/app_loader.php:64 |
7 | G2\L\AppLoader->__construct() | JROOT/components/com_chronoforums2/chronoforums2.php:7 |
6 | require_once JROOT/components/com_chronoforums2/chronoforums2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.17 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 2.697 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.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
14 | JDatabaseDriver->loadAssocList() | JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77 |
13 | G2\L\Joomla\DatabaseAdapter->loadAssocList() | JROOT/libraries/cegcore2/libs/model.php:991 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/app.php:104 |
11 | G2\E\Chronoforums\App->_initialize() | JROOT/libraries/cegcore2/libs/app.php:322 |
10 | G2\L\App->processAction() | JROOT/libraries/cegcore2/libs/joomla/app.php:124 |
9 | G2\L\Joomla\App->dispatch() | JROOT/libraries/cegcore2/libs/app.php:110 |
8 | G2\L\App::call() | JROOT/libraries/cegcore2/libs/app_loader.php:64 |
7 | G2\L\AppLoader->__construct() | JROOT/components/com_chronoforums2/chronoforums2.php:7 |
6 | require_once JROOT/components/com_chronoforums2/chronoforums2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 30.02 ms After last query: 1.75 ms Query memory: 0.025 MB Memory before query: 2.784 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` = '5610';
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.14 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.07 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.02 ms |
statistics | 0.07 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
executing | 0.00 ms |
Sending data | 23.75 ms |
Creating sort index | 5.56 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
removing tmp table | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 1.46 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.68 ms After last query: 1.32 ms Query memory: 0.024 MB Memory before query: 2.816 MB Rows returned: 1
SELECT `Tag`.`id` AS `Tag.id`, `Tag`.`title` AS `Tag.title`, `Tag`.`alias` AS `Tag.alias`, `Tag`.`public` AS `Tag.public`, `Tag`.`published` AS `Tag.published`, `Tag`.`ordering` AS `Tag.ordering`, `Tag`.`description` AS `Tag.description`, `Tag`.`params` AS `Tag.params`, `TopicTag`.`tag_id` AS `TopicTag.tag_id`, `TopicTag`.`topic_id` AS `TopicTag.topic_id`
FROM `ref1_chronoengine_forums2_topics_tags` AS `TopicTag`
LEFT JOIN `ref1_chronoengine_tags` AS `Tag`
ON `TopicTag`.`tag_id` = `Tag`.`id`
WHERE `TopicTag`.`topic_id` IN ('5610');
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.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Sending data | 1.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 3.62 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: 2.91 ms After last query: 0.91 ms Query memory: 0.023 MB Memory before query: 2.821 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` = '5610';
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 | 1 | 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.05 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.45 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.82 ms After last query: 1.40 ms Query memory: 0.040 MB Memory before query: 2.869 MB Rows returned: 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`
WHERE `Post`.`published` = '1'
AND `Post`.`topic_id` = '5610'
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 | 1 | 99.97 | Using index condition; 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 | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.Post.id | 1 | 100.00 | NULL |
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.10 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.23 ms |
Creating sort index | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
removing tmp table | 0.03 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: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.41 ms After last query: 0.95 ms Query memory: 0.025 MB Memory before query: 2.891 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 ('5681');
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Attachment | NULL | ref | post_id | post_id | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.23 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | 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.34 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 2.902 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 ('5681')
GROUP BY `VoteCounter.post_id`;
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | VoteCounter | NULL | ref | post_id | post_id | 4 | const | 1 | 100.00 | Using index condition; Using temporary; Using filesort |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
removing tmp table | 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 |
---|
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.910 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 ('5681');
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | Report | NULL | ref | post_id | post_id | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | ReportAuthor | NULL | eq_ref | PRIMARY | PRIMARY | 4 | joomla_alternatememories.Report.user_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
16 | JDatabaseDriver->loadAssocList() | JROOT/libraries/cegcore2/libs/joomla/database_adapter.php:77 |
15 | G2\L\Joomla\DatabaseAdapter->loadAssocList() | JROOT/libraries/cegcore2/libs/model.php:991 |
14 | G2\L\Model->select() | JROOT/libraries/cegcore2/libs/model.php:670 |
13 | G2\L\Model->_relationsMany() | JROOT/libraries/cegcore2/libs/model.php:998 |
12 | G2\L\Model->select() | JROOT/components/com_chronoforums2/chronoforums/controllers/posts.php:115 |
11 | G2\E\Chronoforums\C\Posts->index() | JROOT/libraries/cegcore2/libs/app.php:322 |
10 | G2\L\App->processAction() | JROOT/libraries/cegcore2/libs/joomla/app.php:127 |
9 | G2\L\Joomla\App->dispatch() | JROOT/libraries/cegcore2/libs/app.php:110 |
8 | G2\L\App::call() | JROOT/libraries/cegcore2/libs/app_loader.php:64 |
7 | G2\L\AppLoader->__construct() | JROOT/components/com_chronoforums2/chronoforums2.php:7 |
6 | require_once JROOT/components/com_chronoforums2/chronoforums2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 2.907 MB
UPDATE `ref1_chronoengine_forums2_topics` AS `Topic`
SET `hits` = `hits`+ 1
WHERE `id` = '5610';
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.54 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.62 ms After last query: 16.23 ms Query memory: 0.029 MB Memory before query: 3.008 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.13 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.13 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
Creating sort index | 0.10 ms |
end | 0.00 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.18 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 3.032 MB Rows returned: 1
SELECT created
FROM ref1_content
WHERE id=599
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ref1_content | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.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.42 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 3.047 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `ref1_categories` AS `s`
INNER JOIN `ref1_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 15
ORDER BY c.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 39 | 71.33 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.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.01 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.057 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.75 ms After last query: 6.22 ms Query memory: 0.026 MB Memory before query: 3.219 MB Rows returned: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ref1_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforums2','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plotalot','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_spambotcheck','com_tags','com_templates','com_users','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ref1_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 43 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.35 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:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
14 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
13 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
12 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
11 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
10 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/sourcerer/src/Params.php:49 |
9 | RegularLabs\Plugin\System\Sourcerer\Params::get() | JROOT/plugins/system/sourcerer/sourcerer.php:145 |
8 | PlgSystemSourcerer->changeFinalHtmlOutput() | JROOT/libraries/regularlabs/src/SystemPlugin.php:146 |
7 | RegularLabs\Library\SystemPlugin->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT created
FROM ref1_content
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `ref1_categories` AS `s`
INNER JOIN `ref1_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
1 × SELECT `data`
FROM `ref1_session`
1 × SELECT `Tag`.`id` AS `Tag.id`, `Tag`.`title` AS `Tag.title`, `Tag`.`alias` AS `Tag.alias`, `Tag`.`public` AS `Tag.public`, `Tag`.`published` AS `Tag.published`, `Tag`.`ordering` AS `Tag.ordering`, `Tag`.`description` AS `Tag.description`, `Tag`.`params` AS `Tag.params`, `TopicTag`.`tag_id` AS `TopicTag.tag_id`, `TopicTag`.`topic_id` AS `TopicTag.topic_id`
FROM `ref1_chronoengine_forums2_topics_tags` AS `TopicTag`
LEFT JOIN `ref1_chronoengine_tags` AS `Tag`
ON `TopicTag`.`tag_id` = `Tag`.`id`
1 × SELECT `Report`.`id` AS `Report.id`, `Report`.`post_id` AS `Report.post_id`, `Report`.`user_id` AS `Report.user_id`, `Report`.`reason` AS `Report.reason`, `Report`.`created` AS `Report.created`, `ReportAuthor`.`id` AS `ReportAuthor.id`, `ReportAuthor`.`username` AS `ReportAuthor.username`, `ReportAuthor`.`name` AS `ReportAuthor.name`
FROM `ref1_chronoengine_forums2_posts_reports` AS `Report`
LEFT JOIN `ref1_users` AS `ReportAuthor`
ON `Report`.`user_id` = `ReportAuthor`.`id`
1 × SELECT `VoteCounter`.`post_id` AS `VoteCounter.post_id`, SUM(`VoteCounter`.`vote`) AS `Post.VotesCount`
FROM `ref1_chronoengine_forums2_posts_votes` AS `VoteCounter`
1 × SELECT `Attachment`.`id` AS `Attachment.id`, `Attachment`.`post_id` AS `Attachment.post_id`, `Attachment`.`user_id` AS `Attachment.user_id`, `Attachment`.`filename` AS `Attachment.filename`, `Attachment`.`vfilename` AS `Attachment.vfilename`, `Attachment`.`comment` AS `Attachment.comment`, `Attachment`.`downloads` AS `Attachment.downloads`, `Attachment`.`created` AS `Attachment.created`, `Attachment`.`size` AS `Attachment.size`
FROM `ref1_chronoengine_forums2_posts_attachments` AS `Attachment`
1 × SELECT `Post`.`id` AS `Post.id`, `Post`.`topic_id` AS `Post.topic_id`, `Post`.`text` AS `Post.text`, `Post`.`user_id` AS `Post.user_id`, `Post`.`created` AS `Post.created`, `Post`.`modified` AS `Post.modified`, `Post`.`published` AS `Post.published`, `Post`.`remote_address` AS `Post.remote_address`, `Topic`.`id` AS `Topic.id`, `Topic`.`user_id` AS `Topic.user_id`, `Topic`.`forum_id` AS `Topic.forum_id`, `Topic`.`locked` AS `Topic.locked`, `Topic`.`title` AS `Topic.title`, `Author`.`id` AS `Author.id`, `Author`.`name` AS `Author.name`, `Author`.`username` AS `Author.username`, `AuthorProfile`.`user_id` AS `AuthorProfile.user_id`, `AuthorProfile`.`params` AS `AuthorProfile.params`, `AuthorProfile`.`location` AS `AuthorProfile.location`, `AuthorProfile`.`avatar` AS `AuthorProfile.avatar`, `AuthorProfile`.`about` AS `AuthorProfile.about`, `AuthorProfile`.`signature` AS `AuthorProfile.signature`, `AuthorProfile`.`website` AS `AuthorProfile.website`, `AuthorProfile`.`dob` AS `AuthorProfile.dob`, `AuthorProfile`.`last_visit` AS `AuthorProfile.last_visit`, `AuthorProfile`.`last_activity` AS `AuthorProfile.last_activity`, `AuthorProfile`.`post_count` AS `AuthorProfile.post_count`, `AuthorProfile`.`vote_count` AS `AuthorProfile.vote_count`, `AuthorProfile`.`answer_count` AS `AuthorProfile.answer_count`, `Answer`.`post_id` AS `Answer.post_id`, `Answer`.`user_id` AS `Answer.user_id`, `Answer`.`created` AS `Answer.created`, `Vote`.`post_id` AS `Vote.post_id`, `Vote`.`user_id` AS `Vote.user_id`, `Vote`.`vote` AS `Vote.vote`, `Vote`.`created` AS `Vote.created`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
LEFT JOIN `ref1_users` AS `Author`
ON `Post`.`user_id` = `Author`.`id`
LEFT JOIN `ref1_chronoengine_forums2_topics` AS `Topic`
ON `Post`.`topic_id` = `Topic`.`id`
LEFT JOIN `ref1_chronoengine_forums2_posts_answers` AS `Answer`
ON `Post`.`id` = `Answer`.`post_id`
LEFT JOIN `ref1_chronoengine_forums2_posts_votes` AS `Vote`
ON `Post`.`id` = `Vote`.`post_id`
AND `Vote`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `AuthorProfile`
ON `Author`.`id` = `AuthorProfile`.`user_id`
1 × SELECT COUNT(`Post`.`id`) AS `Post.count`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
1 × SELECT (`AnsweredPost`.`Answer.post_id`) AS `Topic.answered`, `Topic`.`id` AS `Topic.id`, `Topic`.`forum_id` AS `Topic.forum_id`, `Topic`.`title` AS `Topic.title`, `Topic`.`alias` AS `Topic.alias`, `Topic`.`user_id` AS `Topic.user_id`, `Topic`.`published` AS `Topic.published`, `Topic`.`locked` AS `Topic.locked`, `Topic`.`created` AS `Topic.created`, `Topic`.`modified` AS `Topic.modified`, `Topic`.`hits` AS `Topic.hits`, `Topic`.`unique_id` AS `Topic.unique_id`, `Topic`.`params` AS `Topic.params`, `Topic`.`post_count` AS `Topic.post_count`, `Topic`.`last_post` AS `Topic.last_post`, `TopicAuthor`.`id` AS `TopicAuthor.id`, `TopicAuthor`.`username` AS `TopicAuthor.username`, `TopicAuthor`.`name` AS `TopicAuthor.name`, `TopicAuthorProfile`.`user_id` AS `TopicAuthorProfile.user_id`, `TopicAuthorProfile`.`params` AS `TopicAuthorProfile.params`, `TopicAuthorProfile`.`location` AS `TopicAuthorProfile.location`, `TopicAuthorProfile`.`avatar` AS `TopicAuthorProfile.avatar`, `TopicAuthorProfile`.`about` AS `TopicAuthorProfile.about`, `TopicAuthorProfile`.`signature` AS `TopicAuthorProfile.signature`, `TopicAuthorProfile`.`website` AS `TopicAuthorProfile.website`, `TopicAuthorProfile`.`dob` AS `TopicAuthorProfile.dob`, `TopicAuthorProfile`.`last_visit` AS `TopicAuthorProfile.last_visit`, `TopicAuthorProfile`.`last_activity` AS `TopicAuthorProfile.last_activity`, `TopicAuthorProfile`.`post_count` AS `TopicAuthorProfile.post_count`, `TopicAuthorProfile`.`vote_count` AS `TopicAuthorProfile.vote_count`, `TopicAuthorProfile`.`answer_count` AS `TopicAuthorProfile.answer_count`, `Featured`.`topic_id` AS `Featured.topic_id`, `Featured`.`user_id` AS `Featured.user_id`, `Featured`.`created` AS `Featured.created`, `Favorite`.`topic_id` AS `Favorite.topic_id`, `Favorite`.`user_id` AS `Favorite.user_id`, `Favorite`.`created` AS `Favorite.created`, `TopicSubscriber`.`topic_id` AS `TopicSubscriber.topic_id`, `TopicSubscriber`.`user_id` AS `TopicSubscriber.user_id`, `TopicSubscriber`.`notified` AS `TopicSubscriber.notified`, `TopicSubscriber`.`created` AS `TopicSubscriber.created`, `TopicSubscriber`.`topic_id` AS `TopicSubscriber.topic_id`, `TopicSubscriber`.`user_id` AS `TopicSubscriber.user_id`, `TopicSubscriber`.`notified` AS `TopicSubscriber.notified`, `TopicSubscriber`.`created` AS `TopicSubscriber.created`
FROM `ref1_chronoengine_forums2_topics` AS `Topic`
LEFT JOIN (SELECT `Answer`.`post_id` AS `Answer.post_id`, `Post`.`topic_id` AS `Post.topic_id`
FROM `ref1_chronoengine_forums2_posts` AS `Post`
LEFT JOIN `ref1_chronoengine_forums2_posts_answers` AS `Answer`
ON `Post`.`id` = `Answer`.`post_id`
GROUP BY `Answer.post_id`) AS `AnsweredPost`
ON `AnsweredPost`.`Post.topic_id` = `Topic`.`id`
LEFT JOIN `ref1_users` AS `TopicAuthor`
ON `Topic`.`user_id` = `TopicAuthor`.`id`
LEFT JOIN `ref1_chronoengine_forums2_topics_featured` AS `Featured`
ON `Topic`.`id` = `Featured`.`topic_id`
LEFT JOIN `ref1_chronoengine_forums2_topics_favorites` AS `Favorite`
ON `Favorite`.`topic_id` = `Topic`.`id`
AND `Favorite`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_topics_subscribers` AS `TopicSubscriber`
ON `TopicSubscriber`.`topic_id` = `Topic`.`id`
AND `TopicSubscriber`.`user_id` = '0'
LEFT JOIN `ref1_chronoengine_forums2_users_profiles` AS `TopicAuthorProfile`
ON `TopicAuthor`.`id` = `TopicAuthorProfile`.`user_id`
1 × SELECT `session_id`
FROM `ref1_session`
1 × SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`title` AS `Forum.title`, `Forum`.`alias` AS `Forum.alias`
FROM `ref1_chronoengine_forums2_forums` AS `Forum`
1 × SELECT `Forum`.`id` AS `Forum.id`, `Forum`.`parent_id` AS `Forum.parent_id`, `Forum`.`title` AS `Forum.title`, `Forum`.`description` AS `Forum.description`, `Forum`.`alias` AS `Forum.alias`, `Forum`.`type` AS `Forum.type`, `Forum`.`path` AS `Forum.path`, `Forum`.`published` AS `Forum.published`, `Forum`.`created` AS `Forum.created`, `Forum`.`modified` AS `Forum.modified`, `Forum`.`ordering` AS `Forum.ordering`, `Forum`.`topic_count` AS `Forum.topic_count`, `Forum`.`post_count` AS `Forum.post_count`, `Forum`.`last_post` AS `Forum.last_post`, `Forum`.`params` AS `Forum.params`, `Forum`.`rules` AS `Forum.rules`
FROM `ref1_chronoengine_forums2_forums` AS `Forum`
LEFT JOIN `ref1_chronoengine_forums2_topics` AS `Topic`
ON `Forum`.`id` = `Topic`.`forum_id`
1 × SELECT `Acl`.`id` AS `Acl.id`, `Acl`.`aco` AS `Acl.aco`, `Acl`.`title` AS `Acl.title`, `Acl`.`enabled` AS `Acl.enabled`, `Acl`.`rules` AS `Acl.rules`
FROM `ref1_chronoengine_acls` AS `Acl`
1 × SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings`
FROM `ref1_chronoengine_extensions` AS `Extension`
1 × SELECT `
Group`.`id` AS `
Group.id`, `
Group`.`parent_id` AS `
Group.parent_id`, `
Group`.`lft` AS `
Group.lft`, `
Group`.`rgt` AS `
Group.rgt`, `
Group`.`title` AS `
Group.title`
FROM `ref1_usergroups` AS `
Group`
1 × SELECT b.id
FROM ref1_usergroups AS a
LEFT JOIN ref1_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `ref1_viewlevels
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ref1_assets`
casino бесплатно играть <a href=https://top-casino-online.bitbucket.io/pomidori-igrat-besplatno/igrat-onlayn-besplatno-igrovoy-avtomat-pomidor.html>играть онлайн бесплатно игровой автомат помидор</a> бесплатные игровые автоматы копилка <a href=https://top-casino-online.bitbucket.io/club/m-club-vulkan.html>m club vulkan</a> вулкан игровые автоматы главная <a href=https://top-casino-online.bitbucket.io/azartnie-igri-besplatno/igrovie-besplatnie-azartnie-igri.html>игровые бесплатные азартные игры</a> новый РёРіСЂРѕРІРѕР№ клуб <a href=https://top-casino-online.bitbucket.io/vulkan-avtomati/klub-vulkan-igrovie-avtomati.html>клуб вулкан игровые автоматы</a> бесплатные игровые автоматы РїРѕРјРёРґРѕСЂС‹ без регистрации <a href=https://top-casino-online.bitbucket.io/casino/igrovie-avtomati-casino.html>игровые автоматы casino</a>
игры онлайн автоматы 888 вулкан орг игровой клуб азартные игры слот бесплатно без регистрации crazy fruits помидоры вулкан клуб one игровой автомат помидоры crazy fruits играть бесплатно вулкан com клуб вулкан автоматы клуб вулкан копейки клуб вулкан точка ком
игровые автоматы онлайн казино <a href=https://top-casino-online.bitbucket.io/kreyzi-frukt/>крейзи фрукт</a> игровые автоматы играть бесплатно бешеный РїРѕРјРёРґРѕСЂ <a href=https://top-casino-online.bitbucket.io/azartnie-igri-besplatno/besplatnie-azartnie-igri-igrovie-avtomati-igrat-besplatno.html>бесплатные азартные игры игровые автоматы играть бесплатно</a> казино вулкан online club <a href=https://top-casino-online.bitbucket.io/casino/club-vulkan-casino-na.html>club vulkan casino на</a> азартный РёРіСЂР° бесплатный без регистрации <a href=https://top-casino-online.bitbucket.io/azartnie-igri/1-igri-azartnie.html>1 игры азартные</a> вулкан club vulcan com <a href=https://top-casino-online.bitbucket.io/kazino-besplatno-registratsii/igri-kazino-besplatno-bez-registratsii-777.html>игры казино бесплатно без регистрации 777</a>
автомат азартный игровой piggy bank слоты на азартные игровые автоматы онлайн без регистрации азартные игры бесплатно и без регистрации азартные игры онлайн бесплатно без регистрации 2014