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 (268231, 268186, 267790, 267635, 267589, 266630, 266616, 266509, 264320, 264302, 263435, 262335, 262313, 262199, 262173, 261947, 261768, 261264, 261245, 261206, 261088, 261068, 261041, 261029, 261005, 260978, 260942, 260541, 260493, 259283, 259141, 259139, 258879, 258861, 258860, 258858, 256960, 256958, 256954, 254451, 254449, 254448, 254026, 253433, 253420, 253408, 253144, 251631, 251610, 251607, 251605, 250300, 249020, 247457, 245504, 245501, 245499, 244159, 242960, 242821, 242819, 242818, 241817, 240932, 239960, 239953, 238686, 238677, 238673, 238671, 237309, 237224, 237184, 237175, 235081, 235072, 235071, 235067, 231845, 231717, 231716, 231714, 231700, 229816, 229814, 229813, 229212, 229140, 227280, 227279, 227277, 227053, 226083, 226079, 226077, 225004, 224987, 224968, 224815, 223925, 223833, 223830, 223599, 223524, 223186, 222914, 222913, 222911, 219122, 218051, 218049, 218046, 218042, 218040, 218039, 218016, 216927, 216923, 216922, 216917, 216910, 216379, 216077, 216071, 216015, 215829, 213404, 212738, 210628, 210546, 209208, 208822, 208683, 208645, 208644, 208640, 208634, 206699, 205752, 205746, 205737, 205732, 205729, 203833, 203827, 203823, 201561, 201405, 201404, 201403, 200345, 200129, 199588, 199066, 198024, 198023, 198021, 198018, 197852, 197850, 196774, 196771, 196769, 196768, 196766, 195659, 195655, 194348, 194345, 194344, 193414, 193409, 193048, 192974, 192512, 192428, 191920, 191917, 191360, 189840, 189839, 189837, 189836, 189781, 188047, 188046, 188039, 188036, 186513, 185898, 185523, 185520, 185516, 185515, 185511, 185133, 185128, 185122, 183448, 183366))
Run Time: 0.002983
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 (268231, 266630, 266616, 264320, 264302, 263435, 262335, 262313, 262199, 262173, 261947, 261768, 261264, 261245, 261206, 261088, 261068, 261041, 261029, 261005, 260978, 260942, 260541, 260493, 259283, 259141, 259139, 258879, 256960, 256958, 256954, 254026, 253433, 253420, 253408, 253144, 251631, 250300, 249020, 247457, 244159, 242960, 241817, 240932, 239960, 239953, 238686, 237309, 237224, 237184, 237175, 235081, 231845, 231700, 229212, 229140, 227280, 227053, 225004, 224987, 224968, 224815, 223925, 223833, 223830, 223599, 223524, 223186, 219122, 218051, 218049, 218016, 216917, 216910, 216379, 216077, 216071, 216015, 215829, 213404, 212738, 210628, 210546, 209208, 208822, 208683, 208634, 206699, 205752, 205746, 201561, 200345, 200129, 199588, 199066, 197852, 197850, 196774, 196771, 195659, 195655, 193414, 193409, 193048, 192974, 192512, 192428, 191360, 189781, 186513, 185898, 185511, 185133, 185128, 185122))
Run Time: 0.001848
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 115 | 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