SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_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_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (1544198, 1543961, 1543719, 1543715, 1543673, 1543670, 1543665, 1543570, 1543564, 1541973, 1541958, 1541576, 1541560, 1541547, 1541486, 1541450, 1541389, 1541176, 1540819, 1540815, 1540780, 1540774, 1540771, 1540763, 1540754, 1540752, 1540747, 1540741, 1540706, 1540703, 1540692, 1540297, 1540291, 1540289, 1540274, 1540231, 1540221, 1540215, 1540200, 1540197, 1540184, 1540183, 1540179, 1540177, 1540170, 1540166, 1540164, 1540159, 1540147, 1540137, 1540136, 1540115, 1540088, 1540087, 1540086, 1540085, 1540084, 1540082, 1540073, 1540058, 1540051, 1540037, 1540035, 1540033, 1539922, 1539920, 1539919, 1539917, 1539913, 1539903, 1539853, 1539827, 1539639, 1539568, 1539294, 1539286, 1539282, 1539280, 1539248, 1538566, 1538564, 1538560, 1538547, 1538544, 1538530, 1538528, 1538527, 1538519, 1538517, 1538335, 1538317, 1538309, 1538283, 1538029, 1537631, 1537515, 1537248, 1537244, 1537141, 1537116, 1537114, 1537113, 1537092, 1537083, 1537062, 1537058, 1537051, 1536812, 1536796, 1536783, 1536756, 1536195, 1536143, 1536102, 1536101, 1536078, 1536062, 1536057, 1536052, 1536042, 1536041, 1536039, 1536024, 1536016, 1536011, 1536000, 1535996, 1535955, 1535946, 1535841, 1535760, 1535712, 1535654, 1535652, 1535625, 1535565, 1535540, 1535539, 1535536, 1535533, 1535528, 1535486, 1535450, 1535440, 1535439, 1535438, 1535433, 1535432, 1535397, 1535394, 1535393, 1535390, 1535346, 1535343, 1535340, 1535339, 1535330, 1535329, 1535328, 1535175, 1535116, 1535067, 1534767, 1534419, 1534405, 1534044, 1534026, 1534000, 1533958, 1533933, 1533818, 1533811, 1533802, 1533782, 1533760, 1533692, 1533529, 1533243, 1533238, 1533228, 1532841, 1532824, 1532815, 1532812, 1532793, 1532770, 1532766, 1532753, 1532636, 1532592, 1532587, 1532579, 1532545, 1532544, 1532479, 1532457, 1532451, 1532387, 1532372, 1532369))
Run Time: 0.010173
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_thread_Thread_1.node_id | 1 | Using where |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,efc.xf_node_Node_3.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 1392
- 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 2730
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->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/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() 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 2352
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_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_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (1544198, 1543570, 1543564, 1541973, 1541576, 1541560, 1541547, 1541486, 1541450, 1541389, 1541176, 1540297, 1540197, 1540164, 1540058, 1539922, 1539920, 1539917, 1539913, 1539827, 1539294, 1539286, 1539282, 1539280, 1539248, 1538566, 1538564, 1538528, 1538519, 1538335, 1537515, 1537248, 1537116, 1537083, 1537062, 1537058, 1537051, 1536812, 1536796, 1536783, 1536756, 1536143, 1536101, 1536042, 1536041, 1535955, 1535841, 1535760, 1535712, 1535652, 1535438, 1535346, 1535343, 1535340, 1535330, 1535329, 1535328, 1535116, 1534767, 1534419, 1534405, 1534044, 1534026, 1534000, 1533958, 1533933, 1533818, 1533811, 1533802, 1533782, 1533760, 1533692, 1533529, 1532812, 1532793, 1532770, 1532766, 1532587, 1532579, 1532545, 1532451))
Run Time: 0.002682
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 81 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_thread_Thread_1.node_id | 1 | Using where |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | efc.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,efc.xf_node_Node_3.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 1392
- 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 2730
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->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/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() 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 2352
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20