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 (12049, 11286, 11015, 10979, 10950, 10902, 10768, 10717, 10580, 10549, 10200, 10144, 10002, 9976, 9956, 9821, 9734, 9475, 9347, 9293, 9197, 9178, 9098, 9091, 9074, 9008, 8951, 8903, 8675, 8574, 8483, 8430, 8415, 8398, 8396, 8385, 8361, 8268, 8260, 8199, 8120, 8093, 8043, 7858, 7811, 7737, 7649, 7623, 7596, 7548, 7485, 7443, 7396, 7335, 7316, 7310, 7295, 7283, 7256, 7249, 7245, 7230, 7190, 7177, 7118, 7091, 7080, 7058, 7054, 6985, 6981, 6903, 6762, 6714, 6576, 6537, 6518, 6501, 6498, 6365, 6313, 6284, 6266, 6137, 6047, 5944, 5755, 5733, 5685, 5613, 5595, 5592, 5578, 5553, 5550, 5545, 5536, 5523, 5522, 5313, 5194, 5003, 5060, 5045, 4848, 4792, 4791, 4723, 4715, 4696, 4691, 4614, 4454, 4364, 4346, 4345, 4322, 4321, 4316, 4215, 4106, 4103, 4038, 3883, 3882, 3848, 3767, 3764, 3754, 3723, 3716, 3672, 3652, 3634, 3628, 3609, 3601, 3514, 3490, 3484, 3481, 3459, 3447, 3428, 3409, 3358, 3354, 3315, 3277, 3275, 3247, 3207, 3206, 3180, 3144, 3135, 3105, 3097, 3051, 3025, 3011, 2995, 2978, 2953, 2949, 2937, 2882, 2881, 2879, 2877, 2876, 2865, 2743, 2721, 2708, 2631, 2608, 2595, 2558, 2551, 2376, 921, 919, 918, 914, 905, 895, 880, 853, 849, 848, 840, 835, 827, 826, 825, 796, 791, 782, 773))
Run Time: 0.008287
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 | admin_xencybim.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xencybim.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xencybim.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 1387
- 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 2729
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 182, 0, 1714827131, {"thread-12049":["thread",12049],"thread-11286":["thread",11286],"thread-11015":["thread",11015],"thread-10979":["thread",10979],"thread-10950":["thread",10950],"thread-10902":["thread",10902],"thread-10768":["thread",10768],"thread-10717":["thread",10717],"thread-10580":["thread",10580],"thread-10549":["thread",10549],"thread-10200":["thread",10200],"thread-10144":["thread",10144],"thread-10002":["thread",10002],"thread-9976":["thread",9976],"thread-9956":["thread",9956],"thread-9821":["thread",9821],"thread-9734":["thread",9734],"thread-9475":["thread",9475],"thread-9347":["thread",9347],"thread-9293":["thread",9293],"thread-9197":["thread",9197],"thread-9178":["thread",9178],"thread-9098":["thread",9098],"thread-9091":["thread",9091],"thread-9074":["thread",9074],"thread-9008":["thread",9008],"thread-8951":["thread",8951],"thread-8903":["thread",8903],"thread-8675":["thread",8675],"thread-8574":["thread",8574],"thread-8483":["thread",8483],"thread-8430":["thread",8430],"thread-8415":["thread",8415],"thread-8398":["thread",8398],"thread-8396":["thread",8396],"thread-8385":["thread",8385],"thread-8361":["thread",8361],"thread-8268":["thread",8268],"thread-8260":["thread",8260],"thread-8199":["thread",8199],"thread-8120":["thread",8120],"thread-8093":["thread",8093],"thread-8043":["thread",8043],"thread-7858":["thread",7858],"thread-7811":["thread",7811],"thread-7737":["thread",7737],"thread-7649":["thread",7649],"thread-7623":["thread",7623],"thread-7596":["thread",7596],"thread-7548":["thread",7548],"thread-7485":["thread",7485],"thread-7443":["thread",7443],"thread-7396":["thread",7396],"thread-7335":["thread",7335],"thread-7316":["thread",7316],"thread-7310":["thread",7310],"thread-7295":["thread",7295],"thread-7283":["thread",7283],"thread-7256":["thread",7256],"thread-7249":["thread",7249],"thread-7245":["thread",7245],"thread-7230":["thread",7230],"thread-7190":["thread",7190],"thread-7177":["thread",7177],"thread-7118":["thread",7118],"thread-7091":["thread",7091],"thread-7080":["thread",7080],"thread-7058":["thread",7058],"thread-7054":["thread",7054],"thread-6985":["thread",6985],"thread-6981":["thread",6981],"thread-6903":["thread",6903],"thread-6762":["thread",6762],"thread-6714":["thread",6714],"thread-6576":["thread",6576],"thread-6537":["thread",6537],"thread-6518":["thread",6518],"thread-6501":["thread",6501],"thread-6498":["thread",6498],"thread-6365":["thread",6365],"thread-6313":["thread",6313],"thread-6284":["thread",6284],"thread-6266":["thread",6266],"thread-6137":["thread",6137],"thread-6047":["thread",6047],"thread-5944":["thread",5944],"thread-5755":["thread",5755],"thread-5733":["thread",5733],"thread-5685":["thread",5685],"thread-5613":["thread",5613],"thread-5595":["thread",5595],"thread-5592":["thread",5592],"thread-5578":["thread",5578],"thread-5553":["thread",5553],"thread-5550":["thread",5550],"thread-5545":["thread",5545],"thread-5536":["thread",5536],"thread-5523":["thread",5523],"thread-5522":["thread",5522],"thread-5313":["thread",5313],"thread-5194":["thread",5194],"thread-5003":["thread",5003],"thread-5060":["thread",5060],"thread-5045":["thread",5045],"thread-4848":["thread",4848],"thread-4792":["thread",4792],"thread-4791":["thread",4791],"thread-4723":["thread",4723],"thread-4715":["thread",4715],"thread-4696":["thread",4696],"thread-4691":["thread",4691],"thread-4614":["thread",4614],"thread-4454":["thread",4454],"thread-4364":["thread",4364],"thread-4346":["thread",4346],"thread-4345":["thread",4345],"thread-4322":["thread",4322],"thread-4321":["thread",4321],"thread-4316":["thread",4316],"thread-4215":["thread",4215],"thread-4106":["thread",4106],"thread-4103":["thread",4103],"thread-4038":["thread",4038],"thread-3883":["thread",3883],"thread-3882":["thread",3882],"thread-3848":["thread",3848],"thread-3767":["thread",3767],"thread-3764":["thread",3764],"thread-3754":["thread",3754],"thread-3723":["thread",3723],"thread-3716":["thread",3716],"thread-3672":["thread",3672],"thread-3652":["thread",3652],"thread-3634":["thread",3634],"thread-3628":["thread",3628],"thread-3609":["thread",3609],"thread-3601":["thread",3601],"thread-3514":["thread",3514],"thread-3490":["thread",3490],"thread-3484":["thread",3484],"thread-3481":["thread",3481],"thread-3459":["thread",3459],"thread-3447":["thread",3447],"thread-3428":["thread",3428],"thread-3409":["thread",3409],"thread-3358":["thread",3358],"thread-3354":["thread",3354],"thread-3315":["thread",3315],"thread-3277":["thread",3277],"thread-3275":["thread",3275],"thread-3247":["thread",3247],"thread-3207":["thread",3207],"thread-3206":["thread",3206],"thread-3180":["thread",3180],"thread-3144":["thread",3144],"thread-3135":["thread",3135],"thread-3105":["thread",3105],"thread-3097":["thread",3097],"thread-3051":["thread",3051],"thread-3025":["thread",3025],"thread-3011":["thread",3011],"thread-2995":["thread",2995],"thread-2978":["thread",2978],"thread-2953":["thread",2953],"thread-2949":["thread",2949],"thread-2937":["thread",2937],"thread-2882":["thread",2882],"thread-2881":["thread",2881],"thread-2879":["thread",2879],"thread-2877":["thread",2877],"thread-2876":["thread",2876],"thread-2865":["thread",2865],"thread-2743":["thread",2743],"thread-2721":["thread",2721],"thread-2708":["thread",2708],"thread-2631":["thread",2631],"thread-2608":["thread",2608],"thread-2595":["thread",2595],"thread-2558":["thread",2558],"thread-2551":["thread",2551],"thread-2376":["thread",2376],"thread-921":["thread",921],"thread-919":["thread",919],"thread-918":["thread",918],"thread-914":["thread",914],"thread-905":["thread",905],"thread-895":["thread",895],"thread-880":["thread",880],"thread-853":["thread",853],"thread-849":["thread",849],"thread-848":["thread",848],"thread-840":["thread",840],"thread-835":["thread",835],"thread-827":["thread",827],"thread-826":["thread",826],"thread-825":["thread",825],"thread-796":["thread",796],"thread-791":["thread",791],"thread-782":["thread",782],"thread-773":["thread",773]}, , 1714823531
Run Time: 0.000261
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20