SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.001927
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 41 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1752
- XF\App->preLoadData() in src/XF/App.php at line 1740
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 363
- XF::setupApp() in src/XF.php at line 386
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 320
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `ewr_porta_articles`
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `ewr_porta_articles`.`thread_id`)
INNER JOIN `xf_post` AS `xf_post_FirstPost_2` ON (`xf_post_FirstPost_2`.`post_id` = `xf_thread_Thread_1`.`first_post_id`)
INNER JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_1`.`node_id`)
WHERE (`xf_thread_Thread_1`.`discussion_state` = 'visible') AND (`ewr_porta_articles`.`article_date` < 1614817106) AND (`ewr_porta_articles`.`article_exclude` = '0')
Run Time: 0.001877
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_porta_articles | ALL | PRIMARY | | | | 7 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | kenhlgbt_kenhlgbt.ewr_porta_articles.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.node_id | 1 | Using index |
SIMPLE | xf_post_FirstPost_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.first_post_id | 1 | Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1249
- XF\Mvc\Entity\Finder->total() in src/addons/EWR/Porta/Pub/Controller/Article.php at line 30
- EWR\Porta\Pub\Controller\Article->actionIndex() in src/addons/DC/TinhteStyle/Pub/Controller/Article.php at line 11
- DC\TinhteStyle\Pub\Controller\Article->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_porta_articles`.*, `xf_thread_Thread_1`.*, `xf_post_FirstPost_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_user_User_5`.*
FROM `ewr_porta_articles`
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `ewr_porta_articles`.`thread_id`)
INNER JOIN `xf_post` AS `xf_post_FirstPost_2` ON (`xf_post_FirstPost_2`.`post_id` = `xf_thread_Thread_1`.`first_post_id`)
INNER JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_thread_Thread_1`.`user_id`)
WHERE (`xf_thread_Thread_1`.`discussion_state` = 'visible') AND (`ewr_porta_articles`.`article_date` < 1614817106) AND (`ewr_porta_articles`.`article_exclude` = '0')
ORDER BY `ewr_porta_articles`.`article_sticky` DESC, `ewr_porta_articles`.`article_date` DESC
LIMIT 5
Run Time: 0.001225
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_porta_articles | ALL | PRIMARY | | | | 7 | Using where; Using filesort |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | kenhlgbt_kenhlgbt.ewr_porta_articles.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.node_id | 1 | |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.node_id | 1 | |
SIMPLE | xf_post_FirstPost_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.first_post_id | 1 | |
SIMPLE | xf_user_User_5 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Porta/Pub/Controller/Article.php at line 36
- EWR\Porta\Pub\Controller\Article->actionIndex() in src/addons/DC/TinhteStyle/Pub/Controller/Article.php at line 11
- DC\TinhteStyle\Pub\Controller\Article->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_porta_catlinks`.*, `ewr_porta_categories_Category_1`.*
FROM `ewr_porta_catlinks`
INNER JOIN `ewr_porta_categories` AS `ewr_porta_categories_Category_1` ON (`ewr_porta_categories_Category_1`.`category_id` = `ewr_porta_catlinks`.`category_id`)
WHERE (`ewr_porta_catlinks`.`thread_id` IN (36, 23, 12, 8, 6))
ORDER BY `ewr_porta_categories_Category_1`.`category_name` ASC
Run Time: 0.002701
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_porta_categories_Category_1 | ALL | PRIMARY | | | | 4 | Using filesort |
SIMPLE | ewr_porta_catlinks | ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.ewr_porta_categories_Category_1.category_id | 1 | Using where; Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Porta/Repository/Article.php at line 158
- EWR\Porta\Repository\Article->prepareViewParams() in src/addons/EWR/Porta/Pub/Controller/Article.php at line 36
- EWR\Porta\Pub\Controller\Article->actionIndex() in src/addons/DC/TinhteStyle/Pub/Controller/Article.php at line 11
- DC\TinhteStyle\Pub\Controller\Article->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
INNER JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` IN (109, 87, 20, 16, 14))
ORDER BY `xf_attachment`.`attach_date` DESC
Run Time: 0.000459
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 27 | const | 10 | Using index condition; Using where; Using filesort |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Porta/Repository/Article.php at line 175
- EWR\Porta\Repository\Article->prepareViewParams() in src/addons/EWR/Porta/Pub/Controller/Article.php at line 36
- EWR\Porta\Pub\Controller\Article->actionIndex() in src/addons/DC/TinhteStyle/Pub/Controller/Article.php at line 11
- DC\TinhteStyle\Pub\Controller\Article->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_post_FirstPost_5`.*, `xf_user_LastPoster_6`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_post` AS `xf_post_FirstPost_5` ON (`xf_post_FirstPost_5`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_6` ON (`xf_user_LastPoster_6`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1612225106) AND (`xf_thread`.`reply_count` > 0) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`node_id` IN ('2'))
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
Run Time: 0.001103
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 2 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kenhlgbt_kenhlgbt.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_5 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_LastPoster_6 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DC/TinhteStyle/Pub/Controller/Article.php at line 78
- DC\TinhteStyle\Pub\Controller\Article->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , EWR\Porta\Pub\Controller\Article, Index, valid, , 1614817106,
Run Time: 0.000212
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 343
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `ewr_porta_features`.*, `xf_thread_Thread_1`.*, `xf_post_FirstPost_2`.*
FROM `ewr_porta_features`
INNER JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `ewr_porta_features`.`thread_id`)
INNER JOIN `xf_post` AS `xf_post_FirstPost_2` ON (`xf_post_FirstPost_2`.`post_id` = `xf_thread_Thread_1`.`first_post_id`)
WHERE (`xf_thread_Thread_1`.`discussion_state` = 'visible')
ORDER BY `ewr_porta_features`.`feature_date` DESC
LIMIT 5
Run Time: 0.000664
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ewr_porta_features | ALL | PRIMARY | | | | 7 | Using filesort |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.ewr_porta_features.thread_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread_Thread_1.first_post_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/EWR/Porta/Widget/Features.php at line 58
- EWR\Porta\Widget\Features->render() in internal_data/code_cache/widgets/_25_home_featuredPosts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1649
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 79
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 109)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 5 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Post.php at line 437
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 21
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/Thread.php at line 374
- XF\Entity\Thread->canViewAttachments() in src/XF/Entity/Post.php at line 438
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 87)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000470
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 2 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Post.php at line 437
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 2
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/Thread.php at line 374
- XF\Entity\Thread->canViewAttachments() in src/XF/Entity/Post.php at line 438
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 20)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000307
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Post.php at line 437
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 4
Run Time: 0.000180
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/Thread.php at line 374
- XF\Entity\Thread->canViewAttachments() in src/XF/Entity/Post.php at line 438
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 14)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000338
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/Post.php at line 437
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 5
Run Time: 0.000195
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/Thread.php at line 374
- XF\Entity\Thread->canViewAttachments() in src/XF/Entity/Post.php at line 438
- XF\Entity\Post->getBbCodeRenderOptions() in src/XF/SubContainer/BbCode.php at line 228
- XF\SubContainer\BbCode->getFullRenderOptions() in src/XF/SubContainer/BbCode.php at line 216
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2021
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 519
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_macros.php at line 433
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 199
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*, `xf_post_FirstPost_6`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_6` ON (`xf_post_FirstPost_6`.`post_id` = `xf_thread`.`first_post_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1612225106) AND (`xf_thread`.`reply_count` > 0) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`reply_count` > 0)
ORDER BY `xf_thread`.`last_post_date` DESC, `xf_thread`.`reply_count` DESC
LIMIT 20
Run Time: 0.003175
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 2 | Using index condition; Using where; Using filesort |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kenhlgbt_kenhlgbt.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_post_FirstPost_6 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.first_post_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DC/TinhteStyle/XF/Widget/DCNewThreads.php at line 108
- DC\TinhteStyle\XF\Widget\DCNewThreads->render() in internal_data/code_cache/widgets/_67_home_daily_discussion.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1649
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 218
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*, `xf_post_FirstPost_6`.*
FROM `xf_thread` FORCE INDEX (`post_date`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_6` ON (`xf_post_FirstPost_6`.`post_id` = `xf_thread`.`first_post_id`)
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`view_count` > 0) AND (`xf_thread`.`post_date` >= 1614730707)
ORDER BY `xf_thread`.`post_date` DESC, `xf_thread`.`view_count` DESC
LIMIT 60
Run Time: 0.000964
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | post_date | post_date | 4 | | 1 | Using index condition; Using where; Using filesort |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kenhlgbt_kenhlgbt.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_post_FirstPost_6 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.first_post_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DC/TinhteStyle/XF/Widget/DCNewThreads.php at line 108
- DC\TinhteStyle\XF\Widget\DCNewThreads->render() in internal_data/code_cache/widgets/_68_home_highlight_posts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1649
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 236
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*, `xf_post_FirstPost_6`.*
FROM `xf_thread` FORCE INDEX (`post_date`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_6` ON (`xf_post_FirstPost_6`.`post_id` = `xf_thread`.`first_post_id`)
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`node_id` IN (21, 22, 11, 12, 17, 9, 10, 23, 2, 5, 3, 4))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 20
Run Time: 0.002949
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | index | | post_date | 4 | | 20 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kenhlgbt_kenhlgbt.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.last_post_user_id | 1 | |
SIMPLE | xf_post_FirstPost_6 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.first_post_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DC/TinhteStyle/XF/Widget/DCNewThreads.php at line 108
- DC\TinhteStyle\XF\Widget\DCNewThreads->render() in internal_data/code_cache/widgets/_69_home_discussing_sidebar_block.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6652
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1649
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 281
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 122)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000533
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 113
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s3/public/DC_newThreads_default.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 281
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 121)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 113
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s3/public/DC_newThreads_default.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 281
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 120)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000313
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 113
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s3/public/DC_newThreads_default.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 281
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 119)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000327
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 113
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s3/public/DC_newThreads_default.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 281
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post') AND (`xf_attachment`.`content_id` = 118)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000345
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 113
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s3/public/DC_newThreads_default.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in internal_data/code_cache/templates/l2/s3/public/EWRporta_articles_index.php at line 281
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread` FORCE INDEX (`post_date`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`TinhteStyle_promoteHeader` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect')
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 10
Run Time: 0.001208
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | index | | post_date | 4 | | 10 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kenhlgbt_kenhlgbt.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | kenhlgbt_kenhlgbt.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DC/TinhteStyle/Listener.php at line 41
- DC\TinhteStyle\Listener::appPubRenderPage()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2647
- XF\App->fire() in src/XF/Pub/App.php at line 545
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brmsModernStatistics')
Run Time: 0.000228
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1643
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 3027
- XF\App->container() in src/addons/BR/ModernStatistic/Service/ModernStatistic/Render.php at line 29
- BR\ModernStatistic\Service\ModernStatistic\Render->__construct() in src/XF/Container.php at line 274
- XF\Container->createObject() in src/XF/App.php at line 1563
- XF\App->XF\{closure}() in src/XF/Container.php at line 228
- XF\Container->create() in src/XF/App.php at line 2769
- XF\App->service() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 10
- BR\ModernStatistic\XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l2/s3/public/PAGE_CONTAINER.php at line 2294
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 547
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20