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 (7215504, 7211793, 7207779, 7206325, 7206257, 7199811, 7199286, 7198340, 7191633, 7182862, 7182284, 7178384, 7163631, 7162809, 7162669, 7159961, 7158108, 7157393, 7156664, 7155454, 7153169, 7151020, 7150030, 7148075, 7138588, 7137848, 7137304, 7135743, 7132204, 7119587, 7103566, 7094608, 7091601, 7051877, 7017677, 7010126, 7002048, 6989452, 6964623, 6640593, 6299056, 236040, 195162, 194634, 192099, 162627, 6252516, 13496, 13199, 13040, 12890, 12726, 12209, 12023, 11705, 11643, 11391, 11371, 11322, 11249, 11187, 10656, 10501, 10159, 10080, 10032, 9925, 9741, 9724, 9506, 9421, 8968, 8895, 8816, 8733, 8519, 8483, 8467, 8371, 8336, 8334, 8210, 8013, 8001, 7074, 6945, 6673, 6595, 6340, 5784, 5753, 5582, 5309, 5255, 5184, 5146, 4733, 4732, 4227, 4220, 4198, 3192, 3075, 2692, 2630, 2529, 2282, 2238, 2177, 2119, 2066, 1901, 1754, 1226, 1130, 1125, 1123, 1110, 899, 419, 382, 351, 117, 111))
Run Time: 0.007537
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 124 | 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: 70, 0, 1716111635, {"thread-7215504":["thread",7215504],"thread-7211793":["thread",7211793],"thread-7207779":["thread",7207779],"thread-7206325":["thread",7206325],"thread-7206257":["thread",7206257],"thread-7199811":["thread",7199811],"thread-7199286":["thread",7199286],"thread-7198340":["thread",7198340],"thread-7191633":["thread",7191633],"thread-7182862":["thread",7182862],"thread-7182284":["thread",7182284],"thread-7178384":["thread",7178384],"thread-7163631":["thread",7163631],"thread-7162809":["thread",7162809],"thread-7162669":["thread",7162669],"thread-7159961":["thread",7159961],"thread-7158108":["thread",7158108],"thread-7157393":["thread",7157393],"thread-7156664":["thread",7156664],"thread-7155454":["thread",7155454],"thread-7153169":["thread",7153169],"thread-7151020":["thread",7151020],"thread-7150030":["thread",7150030],"thread-7148075":["thread",7148075],"thread-7138588":["thread",7138588],"thread-7137848":["thread",7137848],"thread-7137304":["thread",7137304],"thread-7135743":["thread",7135743],"thread-7132204":["thread",7132204],"thread-7119587":["thread",7119587],"thread-7103566":["thread",7103566],"thread-7094608":["thread",7094608],"thread-7091601":["thread",7091601],"thread-7051877":["thread",7051877],"thread-7017677":["thread",7017677],"thread-7010126":["thread",7010126],"thread-7002048":["thread",7002048],"thread-6989452":["thread",6989452],"thread-6964623":["thread",6964623],"thread-6640593":["thread",6640593],"thread-6299056":["thread",6299056],"thread-236040":["thread",236040],"thread-195162":["thread",195162],"thread-194634":["thread",194634],"thread-192099":["thread",192099],"thread-162627":["thread",162627],"thread-6252516":["thread",6252516],"thread-13496":["thread",13496],"thread-13199":["thread",13199],"thread-13040":["thread",13040],"thread-12890":["thread",12890],"thread-12726":["thread",12726],"thread-12209":["thread",12209],"thread-12023":["thread",12023],"thread-11705":["thread",11705],"thread-11643":["thread",11643],"thread-11391":["thread",11391],"thread-11371":["thread",11371],"thread-11322":["thread",11322],"thread-11249":["thread",11249],"thread-11187":["thread",11187],"thread-10656":["thread",10656],"thread-10501":["thread",10501],"thread-10159":["thread",10159],"thread-10080":["thread",10080],"thread-10032":["thread",10032],"thread-9925":["thread",9925],"thread-9741":["thread",9741],"thread-9724":["thread",9724],"thread-9506":["thread",9506],"thread-9421":["thread",9421],"thread-8968":["thread",8968],"thread-8895":["thread",8895],"thread-8816":["thread",8816],"thread-8733":["thread",8733],"thread-8519":["thread",8519],"thread-8483":["thread",8483],"thread-8467":["thread",8467],"thread-8371":["thread",8371],"thread-8336":["thread",8336],"thread-8334":["thread",8334],"thread-8210":["thread",8210],"thread-8013":["thread",8013],"thread-8001":["thread",8001],"thread-7074":["thread",7074],"thread-6945":["thread",6945],"thread-6673":["thread",6673],"thread-6595":["thread",6595],"thread-6340":["thread",6340],"thread-5784":["thread",5784],"thread-5753":["thread",5753],"thread-5582":["thread",5582],"thread-5309":["thread",5309],"thread-5255":["thread",5255],"thread-5184":["thread",5184],"thread-5146":["thread",5146],"thread-4733":["thread",4733],"thread-4732":["thread",4732],"thread-4227":["thread",4227],"thread-4220":["thread",4220],"thread-4198":["thread",4198],"thread-3192":["thread",3192],"thread-3075":["thread",3075],"thread-2692":["thread",2692],"thread-2630":["thread",2630],"thread-2529":["thread",2529],"thread-2282":["thread",2282],"thread-2238":["thread",2238],"thread-2177":["thread",2177],"thread-2119":["thread",2119],"thread-2066":["thread",2066],"thread-1901":["thread",1901],"thread-1754":["thread",1754],"thread-1226":["thread",1226],"thread-1130":["thread",1130],"thread-1125":["thread",1125],"thread-1123":["thread",1123],"thread-1110":["thread",1110],"thread-899":["thread",899],"thread-419":["thread",419],"thread-382":["thread",382],"thread-351":["thread",351],"thread-117":["thread",117],"thread-111":["thread",111]}, NULL, 1716108035
Run Time: 0.000768
- 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