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 (7216289, 7201801, 7199591, 7192036, 7191440, 7190545, 7186326, 7182124, 7174243, 7164600, 7159871, 7154429, 7152952, 7142375, 7137866, 7137608, 7137225, 7126775, 7119439, 7116823, 7108241, 7106997, 7101504, 7100794, 7083808, 7068703, 7067864, 7066088, 7062758, 7050619, 7032653, 7028166, 7011489, 7003704, 7003316, 6991805, 6988858, 6984894, 6983368, 6979322, 6973387, 6968830, 6962733, 6811704, 6596248, 6385664, 6288111, 6260103, 233173, 232708, 228467, 222420, 209002, 205091, 202343, 187717, 186552, 186551, 184316, 177237, 176657, 176060, 174245, 173519, 160699, 13672, 13582, 13390, 13139, 13077, 12776, 12560, 12544, 12538, 12431, 12423, 12294, 12225, 11725, 11716, 11659, 11619, 11538, 11108, 11008, 10970, 10497, 9895, 9498, 9321, 8978, 8420, 8410, 8205, 8166, 7928, 7851, 7276, 6956, 6801, 6328, 6181, 6093, 5964, 5524, 5440, 5412, 4975, 4946, 4513, 3890, 3309, 3266, 3220, 3194, 3169, 3040, 3027, 2963, 2793, 2699, 2390, 2362, 2353, 1786, 1620, 1571, 764, 523, 516, 365, 267, 127))
Run Time: 0.007963
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 133 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 103, 0, 1714737397, {"thread-7216289":["thread",7216289],"thread-7201801":["thread",7201801],"thread-7199591":["thread",7199591],"thread-7192036":["thread",7192036],"thread-7191440":["thread",7191440],"thread-7190545":["thread",7190545],"thread-7186326":["thread",7186326],"thread-7182124":["thread",7182124],"thread-7174243":["thread",7174243],"thread-7164600":["thread",7164600],"thread-7159871":["thread",7159871],"thread-7154429":["thread",7154429],"thread-7152952":["thread",7152952],"thread-7142375":["thread",7142375],"thread-7137866":["thread",7137866],"thread-7137608":["thread",7137608],"thread-7137225":["thread",7137225],"thread-7126775":["thread",7126775],"thread-7119439":["thread",7119439],"thread-7116823":["thread",7116823],"thread-7108241":["thread",7108241],"thread-7106997":["thread",7106997],"thread-7101504":["thread",7101504],"thread-7100794":["thread",7100794],"thread-7083808":["thread",7083808],"thread-7068703":["thread",7068703],"thread-7067864":["thread",7067864],"thread-7066088":["thread",7066088],"thread-7062758":["thread",7062758],"thread-7050619":["thread",7050619],"thread-7032653":["thread",7032653],"thread-7028166":["thread",7028166],"thread-7011489":["thread",7011489],"thread-7003704":["thread",7003704],"thread-7003316":["thread",7003316],"thread-6991805":["thread",6991805],"thread-6988858":["thread",6988858],"thread-6984894":["thread",6984894],"thread-6983368":["thread",6983368],"thread-6979322":["thread",6979322],"thread-6973387":["thread",6973387],"thread-6968830":["thread",6968830],"thread-6962733":["thread",6962733],"thread-6811704":["thread",6811704],"thread-6596248":["thread",6596248],"thread-6385664":["thread",6385664],"thread-6288111":["thread",6288111],"thread-233173":["thread",233173],"thread-232708":["thread",232708],"thread-228467":["thread",228467],"thread-222420":["thread",222420],"thread-209002":["thread",209002],"thread-205091":["thread",205091],"thread-202343":["thread",202343],"thread-187717":["thread",187717],"thread-186552":["thread",186552],"thread-186551":["thread",186551],"thread-184316":["thread",184316],"thread-177237":["thread",177237],"thread-176657":["thread",176657],"thread-176060":["thread",176060],"thread-174245":["thread",174245],"thread-173519":["thread",173519],"thread-160699":["thread",160699],"thread-13672":["thread",13672],"thread-13582":["thread",13582],"thread-13390":["thread",13390],"thread-13139":["thread",13139],"thread-13077":["thread",13077],"thread-12776":["thread",12776],"thread-12560":["thread",12560],"thread-12544":["thread",12544],"thread-12538":["thread",12538],"thread-12431":["thread",12431],"thread-12423":["thread",12423],"thread-12294":["thread",12294],"thread-12225":["thread",12225],"thread-11725":["thread",11725],"thread-11716":["thread",11716],"thread-11659":["thread",11659],"thread-11619":["thread",11619],"thread-11538":["thread",11538],"thread-11108":["thread",11108],"thread-11008":["thread",11008],"thread-10970":["thread",10970],"thread-10497":["thread",10497],"thread-9895":["thread",9895],"thread-9498":["thread",9498],"thread-9321":["thread",9321],"thread-8978":["thread",8978],"thread-8420":["thread",8420],"thread-8410":["thread",8410],"thread-8205":["thread",8205],"thread-8166":["thread",8166],"thread-7928":["thread",7928],"thread-7851":["thread",7851],"thread-7276":["thread",7276],"thread-6956":["thread",6956],"thread-6801":["thread",6801],"thread-6328":["thread",6328],"thread-6181":["thread",6181],"thread-6093":["thread",6093],"thread-5964":["thread",5964],"thread-5524":["thread",5524],"thread-5440":["thread",5440],"thread-5412":["thread",5412],"thread-4975":["thread",4975],"thread-4946":["thread",4946],"thread-4513":["thread",4513],"thread-3890":["thread",3890],"thread-3309":["thread",3309],"thread-3266":["thread",3266],"thread-3220":["thread",3220],"thread-3194":["thread",3194],"thread-3169":["thread",3169],"thread-3040":["thread",3040],"thread-3027":["thread",3027],"thread-2963":["thread",2963],"thread-2793":["thread",2793],"thread-2699":["thread",2699],"thread-2390":["thread",2390],"thread-2362":["thread",2362],"thread-2353":["thread",2353],"thread-1786":["thread",1786],"thread-1620":["thread",1620],"thread-1571":["thread",1571],"thread-764":["thread",764],"thread-523":["thread",523],"thread-516":["thread",516],"thread-365":["thread",365],"thread-267":["thread",267],"thread-127":["thread",127]}, NULL, 1714733797
Run Time: 0.000570
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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