SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
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_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (89956, 89263, 86397, 86338, 84952, 84715, 84113, 83060, 82709, 81846, 80896, 79991, 79361, 75842, 75807, 75747, 75579, 74812, 73957, 73451, 73284, 73277, 73191, 71753, 70517, 69678, 69428, 68168, 66993, 66272, 65870, 65328, 65168, 64289, 63808, 61716, 61680, 61547, 61337, 60276, 60075, 59709, 59509, 59051, 58994, 57823, 56779, 56698, 56507, 56268, 55901, 55647, 55507, 55502, 53297, 52690, 52286, 52278, 52190, 52185, 52111, 52000, 51951, 51590, 51464, 51165, 50760, 50552, 50020, 49493, 49395, 49225, 49054, 47573, 47532, 46509, 46371, 46115, 45985, 45398, 45218, 45157, 45111, 45078, 44862, 44818, 44624, 44405, 44150, 44101, 43449, 43357, 43278, 43237, 42972, 42900, 42888, 42875, 42823, 42818, 42783, 42401, 42400, 42295, 42244, 41697, 41540, 41528, 41315, 41301, 41297, 41255, 41080, 41030, 40965, 40945, 40907, 40835, 40755, 40696, 40661, 40532, 40475, 40449, 40432, 40380, 40305, 40259, 40224, 40215, 40137, 40118, 39712, 39672, 39605, 39513, 39376, 39219, 38888, 38831, 38684, 38262, 38166, 37948, 37785, 37493, 37485, 37418, 37206, 37177, 37007, 36966, 36564, 36538, 36412, 36190, 36151, 36062, 36027, 35972, 35807, 35770, 35720, 35425, 35052, 34940, 34776, 34615, 34569, 34208, 34134, 34088, 34040, 34034, 34026, 33882, 33764, 33712, 33555, 33548, 33241, 33092, 32991, 32958, 32867, 32307, 32281, 32185, 31797, 31735, 31548, 31484, 31102, 30876, 30210, 29635, 29610, 28831, 28112, 27824))
Run Time: 0.071130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | traderviet__d228.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | traderviet__d228.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | traderviet__d228.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | traderviet__d228.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,traderviet__d228.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 138
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20