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 (4765715, 4764762, 4764761, 4764759, 4762648, 4762625, 4762206, 4761790, 4761114, 4760987, 4760984, 4757779, 4756788, 4756629, 4756161, 4755649, 4751620, 4749826, 4748473, 4747432, 4747390, 4743723, 4740038, 4738589, 4733909, 4730564, 4726118, 4725147, 4725050, 4725020, 4724932, 4724004, 4723740, 4723161, 4722776, 4722775, 4722774, 4721886, 4721839, 4721826, 4721099, 4719635, 4719495, 4717722, 4717667, 4716715, 4715899, 4714634, 4713805, 4712841, 4712731, 4711702, 4711271, 4711213, 4709712, 4707258, 4706294, 4704079, 4703240, 4703200, 4702454, 4700009, 4699152, 4699139, 4698333, 4696150, 4696113, 4695482, 4695356, 4694515, 4694148, 4693045, 4693044, 4692072, 4692029, 4692025, 4690869, 4689044, 4688961, 4688843, 4688839, 4688767, 4688761, 4688389, 4688183, 4688141, 4687488, 4686013, 4684043, 4683175, 4679565, 4678907, 4678906, 4678902, 4677842, 4677840, 4676103, 4675864, 4675388, 4675093, 4674210, 4673323, 4672724, 4672376, 4672371, 4670797, 4670684, 4670528, 4669766, 4669321, 4669311, 4668234, 4667511, 4667371, 4667328, 4667270, 4666869, 4666860, 4666796, 4666786, 4666656, 4666616, 4666123, 4665878, 4665795, 4665275, 4665053, 4661173, 4660926, 4660659, 4660038, 4659885, 4657799, 4656566, 4656137, 4656062, 4655723, 4654897, 4654872, 4653482, 4653463, 4652816, 4652380, 4651491, 4650004, 4649232, 4648590, 4648548, 4648469, 4648377, 4648052, 4648037, 4647795, 4647311, 4647129, 4646891, 4646877, 4646420, 4646401, 4645555, 4643451, 4643005, 4641848, 4640209, 4639614, 4639367, 4637865, 4637175, 4636763, 4636578, 4636515, 4635240, 4635068, 4633707, 4633706, 4633150, 4632599, 4632577, 4627453, 4627335, 4625846, 4625844, 4625838, 4624899, 4624898, 4624408, 4624406, 4624400, 4621648, 4621321, 4619107, 4619040, 4618989, 4618864, 4615980, 4615671, 4614632, 4614383, 4614372, 4613496))
Run Time: 0.003052
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 | fire.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_thread_Thread_1.node_id | 1 | Using where |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,fire.xf_node_Node_3.node_id | 1 | Using where |
- 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 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2718
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 214
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 651
- XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 19
- SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- 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 (4764762, 4764761, 4764759, 4762625, 4761114, 4760987, 4760984, 4757779, 4756788, 4755649, 4749826, 4748473, 4747432, 4730564, 4723161, 4721839, 4715899, 4714634, 4712841, 4712731, 4711702, 4711213, 4702454, 4700009, 4699152, 4696150, 4695482, 4693044, 4692025, 4688961, 4688839, 4688183, 4687488, 4684043, 4678907, 4678906, 4678902, 4677842, 4677840, 4676103, 4674210, 4673323, 4672724, 4670528, 4669766, 4669321, 4668234, 4667511, 4667328, 4667270, 4666869, 4666796, 4666616, 4665795, 4661173, 4657799, 4656566, 4656062, 4655723, 4654872, 4652380, 4651491, 4649232, 4648590, 4648052, 4647795, 4647311, 4646891, 4646420, 4646401, 4637175, 4636763, 4636578, 4636515, 4635240, 4633150, 4632599, 4625846, 4624899, 4624408, 4619040, 4618864, 4614632, 4614383))
Run Time: 0.001485
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 84 | Using where |
SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_thread_Thread_1.node_id | 1 | Using where |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | fire.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,fire.xf_node_Node_3.node_id | 1 | Using where |
- 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 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2718
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 652
- XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 19
- SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20