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 (4773537, 4773477, 4766946, 4766392, 4766205, 4765724, 4764497, 4764451, 4764430, 4763802, 4763229, 4762601, 4762599, 4762587, 4760971, 4760119, 4760026, 4753203, 4751729, 4751095, 4748856, 4742940, 4741656, 4741264, 4740254, 4737842, 4736915, 4736904, 4736836, 4734078, 4733651, 4723327, 4720485, 4719741, 4713717, 4711746, 4710409, 4709737, 4709734, 4709537, 4709503, 4707657, 4707639, 4707312, 4706361, 4703744, 4700917, 4700905, 4700904, 4700892, 4700886, 4700885, 4700883, 4700879, 4700877, 4695376, 4690844, 4690758, 4689187, 4689017, 4687965, 4687287, 4686319, 4682417, 4681204, 4676725, 4676046, 4676004, 4653202, 4651927, 4646034, 4641852, 4640566, 4640558, 4637619, 4637111, 4630555, 4629629, 4629598, 4629547, 4626290, 4623708, 4621937, 4620106, 4619836, 4616288, 4615942, 4615714, 4614626, 4612212, 4611967, 4611393, 4609335, 4608883, 4608138, 4606125, 4599781, 4598206, 4598160, 4597065, 4596057, 4596042, 4595780, 4594451, 4594436, 4593881, 4580410, 4580014, 4575591, 4575511, 4574860, 4572223, 4571102, 4564605, 4563353, 4562621, 4559663, 4557030, 4556124, 4555290, 4554747, 4551687, 4551683, 4545036, 4543907, 4539424, 4538695, 4537690, 4531711, 4531631, 4529534, 4510414, 4503224, 4483416, 4482538, 4482529, 4481220, 4480933, 4478838, 4478836, 4478822, 4473531, 4470271, 4464714, 4453565, 4451923, 4451740, 4451714, 4444669, 4442141, 4433485, 4432054, 4431316, 4431294, 4420640, 4418348, 4417611, 4416784, 4412700, 4412686, 4408992, 4407855, 4384914, 4384054, 4381751, 4381003, 4380999, 4379703, 4378574, 4377501, 4374141, 4370630, 4365349, 4365347, 4364979, 4364977, 4364948, 4362199, 4362061, 4361557, 4361554, 4361475, 4361321, 4361313, 4359993, 4359719, 4357775, 4353735, 4353637, 4353515, 4352581, 4351254, 4350804, 4350585, 4349390, 4348013, 4347963, 4345258, 4344479, 4344102))
Run Time: 0.004144
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 (4765724, 4764497, 4763229, 4760971, 4760119, 4760026, 4751095, 4742940, 4741656, 4737842, 4736915, 4736904, 4710409, 4707639, 4707312, 4706361, 4700917, 4700905, 4700904, 4700892, 4700886, 4700885, 4700883, 4700879, 4700877, 4695376, 4653202, 4651927, 4640558, 4637111, 4630555, 4629629, 4629598, 4626290, 4612212, 4611967, 4611393, 4606125, 4598206, 4598160, 4597065, 4596057, 4596042, 4595780, 4594451, 4594436, 4593881, 4580410, 4580014, 4574860, 4564605, 4559663, 4557030, 4556124, 4555290, 4554747, 4551687, 4551683, 4545036, 4543907, 4539424, 4538695, 4537690, 4531711, 4531631, 4529534, 4510414, 4483416, 4482538, 4481220, 4480933, 4478822, 4453565, 4451923, 4451740, 4433485, 4431294, 4420640, 4418348, 4412686, 4384914, 4384054, 4381003, 4380999, 4374141, 4365349, 4365347, 4364979, 4364977, 4361557, 4361554, 4361475, 4361321, 4359993, 4359719, 4357775, 4353735, 4353637, 4353515, 4351254, 4348013, 4347963, 4345258, 4344479, 4344102))
Run Time: 0.002741
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 105 | 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