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 (7181574, 7165223, 7154655, 7119587, 7104116, 7096117, 7032911, 6994560, 6991030, 6960601, 6956728, 6849152, 188949, 178407, 175557, 167263, 13820, 13724, 13693, 13641, 13520, 13508, 13437, 13348, 13235, 13030, 13012, 13004, 12974, 12964, 12944, 12773, 12768, 12737, 12610, 12551, 12548, 12526, 12513, 12503, 12462, 12281, 12177, 12143, 12126, 11866, 11843, 11715, 11575, 11435, 11383, 11357, 11345, 11284, 11147, 10973, 10969, 10854, 10852, 10846, 10754, 10652, 10637, 10560, 10499, 10444, 10413, 10273, 10170, 10127, 10059, 10004, 9819, 9787, 9778, 9742, 9733, 9662, 9593, 9347, 9341, 9316, 9253, 9210, 9172, 9126, 9094, 9078, 9027, 8903, 8895, 8758, 8640, 8570, 8368, 8234, 8213, 8104, 8103, 8079, 8072, 8057, 8056, 7859, 7702, 7508, 7421, 7321, 7287, 7156, 6962, 6947, 6879, 6832, 6734, 6607, 6531, 6504, 6482, 6424, 6331, 6296, 6233, 6225, 6076, 6007, 5993, 5883, 5876, 5865, 5836, 5731, 5699, 5542, 5492, 5450, 5408, 5396, 5391, 5234, 5178, 5007, 4985, 4953, 4885, 4846, 4818, 4628, 4601, 4593, 4548, 4505, 4323, 4315, 4262, 4162, 4119, 4055, 4044, 4018, 4008, 3969, 3674, 3666, 3523, 3517, 3395, 3356, 3264, 3207, 3142, 3113, 3024, 3010, 2957, 2901, 2876, 2858, 2815, 2619, 2610, 2551, 2528, 2505, 2491, 2431, 2426, 2392, 2278, 2269, 2263, 2185, 2080, 1944, 1859, 1858, 1798, 1764, 1703, 1534))
Run Time: 0.009687
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 72, 0, 1715058911, {"thread-7181574":["thread",7181574],"thread-7165223":["thread",7165223],"thread-7154655":["thread",7154655],"thread-7119587":["thread",7119587],"thread-7104116":["thread",7104116],"thread-7096117":["thread",7096117],"thread-7032911":["thread",7032911],"thread-6994560":["thread",6994560],"thread-6991030":["thread",6991030],"thread-6960601":["thread",6960601],"thread-6956728":["thread",6956728],"thread-6849152":["thread",6849152],"thread-188949":["thread",188949],"thread-175557":["thread",175557],"thread-167263":["thread",167263],"thread-13820":["thread",13820],"thread-13724":["thread",13724],"thread-13693":["thread",13693],"thread-13641":["thread",13641],"thread-13520":["thread",13520],"thread-13508":["thread",13508],"thread-13437":["thread",13437],"thread-13348":["thread",13348],"thread-13235":["thread",13235],"thread-13030":["thread",13030],"thread-13012":["thread",13012],"thread-13004":["thread",13004],"thread-12974":["thread",12974],"thread-12964":["thread",12964],"thread-12944":["thread",12944],"thread-12773":["thread",12773],"thread-12768":["thread",12768],"thread-12737":["thread",12737],"thread-12610":["thread",12610],"thread-12551":["thread",12551],"thread-12548":["thread",12548],"thread-12526":["thread",12526],"thread-12513":["thread",12513],"thread-12503":["thread",12503],"thread-12462":["thread",12462],"thread-12281":["thread",12281],"thread-12177":["thread",12177],"thread-12143":["thread",12143],"thread-12126":["thread",12126],"thread-11866":["thread",11866],"thread-11843":["thread",11843],"thread-11715":["thread",11715],"thread-11575":["thread",11575],"thread-11435":["thread",11435],"thread-11383":["thread",11383],"thread-11357":["thread",11357],"thread-11345":["thread",11345],"thread-11284":["thread",11284],"thread-11147":["thread",11147],"thread-10973":["thread",10973],"thread-10969":["thread",10969],"thread-10854":["thread",10854],"thread-10852":["thread",10852],"thread-10846":["thread",10846],"thread-10754":["thread",10754],"thread-10652":["thread",10652],"thread-10637":["thread",10637],"thread-10560":["thread",10560],"thread-10499":["thread",10499],"thread-10444":["thread",10444],"thread-10413":["thread",10413],"thread-10273":["thread",10273],"thread-10170":["thread",10170],"thread-10127":["thread",10127],"thread-10059":["thread",10059],"thread-10004":["thread",10004],"thread-9819":["thread",9819],"thread-9787":["thread",9787],"thread-9778":["thread",9778],"thread-9742":["thread",9742],"thread-9733":["thread",9733],"thread-9662":["thread",9662],"thread-9593":["thread",9593],"thread-9347":["thread",9347],"thread-9341":["thread",9341],"thread-9316":["thread",9316],"thread-9253":["thread",9253],"thread-9210":["thread",9210],"thread-9172":["thread",9172],"thread-9126":["thread",9126],"thread-9094":["thread",9094],"thread-9078":["thread",9078],"thread-9027":["thread",9027],"thread-8903":["thread",8903],"thread-8895":["thread",8895],"thread-8758":["thread",8758],"thread-8640":["thread",8640],"thread-8570":["thread",8570],"thread-8368":["thread",8368],"thread-8234":["thread",8234],"thread-8213":["thread",8213],"thread-8104":["thread",8104],"thread-8103":["thread",8103],"thread-8079":["thread",8079],"thread-8072":["thread",8072],"thread-8057":["thread",8057],"thread-8056":["thread",8056],"thread-7859":["thread",7859],"thread-7702":["thread",7702],"thread-7508":["thread",7508],"thread-7421":["thread",7421],"thread-7321":["thread",7321],"thread-7287":["thread",7287],"thread-7156":["thread",7156],"thread-6962":["thread",6962],"thread-6947":["thread",6947],"thread-6879":["thread",6879],"thread-6832":["thread",6832],"thread-6734":["thread",6734],"thread-6607":["thread",6607],"thread-6531":["thread",6531],"thread-6504":["thread",6504],"thread-6482":["thread",6482],"thread-6424":["thread",6424],"thread-6331":["thread",6331],"thread-6296":["thread",6296],"thread-6233":["thread",6233],"thread-6225":["thread",6225],"thread-6076":["thread",6076],"thread-6007":["thread",6007],"thread-5993":["thread",5993],"thread-5883":["thread",5883],"thread-5876":["thread",5876],"thread-5865":["thread",5865],"thread-5836":["thread",5836],"thread-5731":["thread",5731],"thread-5699":["thread",5699],"thread-5542":["thread",5542],"thread-5492":["thread",5492],"thread-5450":["thread",5450],"thread-5408":["thread",5408],"thread-5396":["thread",5396],"thread-5391":["thread",5391],"thread-5234":["thread",5234],"thread-5178":["thread",5178],"thread-5007":["thread",5007],"thread-4985":["thread",4985],"thread-4953":["thread",4953],"thread-4885":["thread",4885],"thread-4846":["thread",4846],"thread-4818":["thread",4818],"thread-4628":["thread",4628],"thread-4601":["thread",4601],"thread-4593":["thread",4593],"thread-4548":["thread",4548],"thread-4505":["thread",4505],"thread-4323":["thread",4323],"thread-4315":["thread",4315],"thread-4262":["thread",4262],"thread-4162":["thread",4162],"thread-4119":["thread",4119],"thread-4055":["thread",4055],"thread-4044":["thread",4044],"thread-4018":["thread",4018],"thread-4008":["thread",4008],"thread-3969":["thread",3969],"thread-3674":["thread",3674],"thread-3666":["thread",3666],"thread-3523":["thread",3523],"thread-3517":["thread",3517],"thread-3395":["thread",3395],"thread-3356":["thread",3356],"thread-3264":["thread",3264],"thread-3207":["thread",3207],"thread-3142":["thread",3142],"thread-3113":["thread",3113],"thread-3024":["thread",3024],"thread-3010":["thread",3010],"thread-2957":["thread",2957],"thread-2901":["thread",2901],"thread-2876":["thread",2876],"thread-2815":["thread",2815],"thread-2619":["thread",2619],"thread-2610":["thread",2610],"thread-2551":["thread",2551],"thread-2528":["thread",2528],"thread-2505":["thread",2505],"thread-2491":["thread",2491],"thread-2431":["thread",2431],"thread-2426":["thread",2426],"thread-2392":["thread",2392],"thread-2278":["thread",2278],"thread-2269":["thread",2269],"thread-2263":["thread",2263],"thread-2185":["thread",2185],"thread-2080":["thread",2080],"thread-1944":["thread",1944],"thread-1859":["thread",1859],"thread-1858":["thread",1858],"thread-1798":["thread",1798],"thread-1764":["thread",1764],"thread-1703":["thread",1703],"thread-1534":["thread",1534]}, NULL, 1715055311
Run Time: 0.000597
- 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