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 (11979, 11964, 11908, 11705, 11696, 11569, 11517, 11496, 11483, 11452, 11358, 11310, 11300, 11237, 11175, 11136, 11122, 11114, 11060, 11050, 11012, 10876, 10773, 10761, 10747, 10581, 10580, 10517, 10420, 10416, 10412, 10411, 10383, 10366, 10191, 10144, 10131, 9959, 9956, 9915, 9847, 9762, 9751, 9684, 9627, 9612, 9583, 9525, 9356, 9284, 9257, 9105, 9017, 8788, 8747, 8729, 8714, 8712, 8711, 8584, 8557, 8492, 8359, 8240, 8180, 8158, 8141, 8121, 8062, 7961, 7947, 7913, 7858, 7811, 7745, 7737, 7720, 7672, 7559, 7557, 7513, 7408, 7381, 7296, 7249, 7208, 7156, 7115, 7089, 7075, 7058, 7015, 6933, 6910, 6826, 6716, 6577, 6555, 6535, 6424, 6327, 6322, 6238, 6196, 6123, 6100, 6096, 6029, 5944, 5931, 5749, 5710, 5677, 5428, 5409, 5185, 5169, 5149, 5079, 5003, 5047, 4963, 4950, 4779, 4757, 4725, 4715, 4710, 4709, 4696, 4685, 4547, 4509, 4468, 4453, 4367, 4354, 4345, 4330, 4322, 4321, 4292, 4147, 4124, 4117, 4034, 3919, 3792, 3775, 3731, 3710, 3635, 3602, 3481, 3467, 3307, 3245, 3235, 3198, 3164, 3147, 3112, 3101, 3076, 3042, 3037, 3005, 2988, 2905, 2900, 2874, 2842, 2772, 2749, 2735, 2715, 2595, 2551, 888, 885, 849, 750, 718, 686, 671, 665, 660, 659, 652, 646, 644, 637, 635, 560, 551, 548, 547, 483, 466, 460))
Run Time: 0.005720
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: 29, 0, 1714898541, {"thread-11979":["thread",11979],"thread-11964":["thread",11964],"thread-11908":["thread",11908],"thread-11705":["thread",11705],"thread-11696":["thread",11696],"thread-11569":["thread",11569],"thread-11517":["thread",11517],"thread-11496":["thread",11496],"thread-11483":["thread",11483],"thread-11452":["thread",11452],"thread-11358":["thread",11358],"thread-11310":["thread",11310],"thread-11300":["thread",11300],"thread-11237":["thread",11237],"thread-11175":["thread",11175],"thread-11136":["thread",11136],"thread-11122":["thread",11122],"thread-11114":["thread",11114],"thread-11060":["thread",11060],"thread-11050":["thread",11050],"thread-11012":["thread",11012],"thread-10876":["thread",10876],"thread-10773":["thread",10773],"thread-10761":["thread",10761],"thread-10747":["thread",10747],"thread-10581":["thread",10581],"thread-10580":["thread",10580],"thread-10517":["thread",10517],"thread-10420":["thread",10420],"thread-10416":["thread",10416],"thread-10412":["thread",10412],"thread-10411":["thread",10411],"thread-10383":["thread",10383],"thread-10366":["thread",10366],"thread-10191":["thread",10191],"thread-10144":["thread",10144],"thread-10131":["thread",10131],"thread-9959":["thread",9959],"thread-9956":["thread",9956],"thread-9915":["thread",9915],"thread-9847":["thread",9847],"thread-9762":["thread",9762],"thread-9751":["thread",9751],"thread-9684":["thread",9684],"thread-9627":["thread",9627],"thread-9612":["thread",9612],"thread-9583":["thread",9583],"thread-9525":["thread",9525],"thread-9356":["thread",9356],"thread-9284":["thread",9284],"thread-9257":["thread",9257],"thread-9105":["thread",9105],"thread-9017":["thread",9017],"thread-8788":["thread",8788],"thread-8747":["thread",8747],"thread-8729":["thread",8729],"thread-8714":["thread",8714],"thread-8712":["thread",8712],"thread-8711":["thread",8711],"thread-8584":["thread",8584],"thread-8557":["thread",8557],"thread-8492":["thread",8492],"thread-8359":["thread",8359],"thread-8240":["thread",8240],"thread-8180":["thread",8180],"thread-8158":["thread",8158],"thread-8141":["thread",8141],"thread-8121":["thread",8121],"thread-8062":["thread",8062],"thread-7961":["thread",7961],"thread-7947":["thread",7947],"thread-7913":["thread",7913],"thread-7858":["thread",7858],"thread-7811":["thread",7811],"thread-7745":["thread",7745],"thread-7737":["thread",7737],"thread-7720":["thread",7720],"thread-7672":["thread",7672],"thread-7559":["thread",7559],"thread-7557":["thread",7557],"thread-7513":["thread",7513],"thread-7408":["thread",7408],"thread-7381":["thread",7381],"thread-7296":["thread",7296],"thread-7249":["thread",7249],"thread-7208":["thread",7208],"thread-7156":["thread",7156],"thread-7115":["thread",7115],"thread-7089":["thread",7089],"thread-7075":["thread",7075],"thread-7058":["thread",7058],"thread-7015":["thread",7015],"thread-6933":["thread",6933],"thread-6910":["thread",6910],"thread-6826":["thread",6826],"thread-6716":["thread",6716],"thread-6577":["thread",6577],"thread-6555":["thread",6555],"thread-6535":["thread",6535],"thread-6424":["thread",6424],"thread-6327":["thread",6327],"thread-6322":["thread",6322],"thread-6238":["thread",6238],"thread-6196":["thread",6196],"thread-6123":["thread",6123],"thread-6100":["thread",6100],"thread-6096":["thread",6096],"thread-6029":["thread",6029],"thread-5944":["thread",5944],"thread-5931":["thread",5931],"thread-5749":["thread",5749],"thread-5710":["thread",5710],"thread-5677":["thread",5677],"thread-5428":["thread",5428],"thread-5409":["thread",5409],"thread-5185":["thread",5185],"thread-5169":["thread",5169],"thread-5149":["thread",5149],"thread-5079":["thread",5079],"thread-5003":["thread",5003],"thread-5047":["thread",5047],"thread-4963":["thread",4963],"thread-4950":["thread",4950],"thread-4779":["thread",4779],"thread-4757":["thread",4757],"thread-4725":["thread",4725],"thread-4715":["thread",4715],"thread-4710":["thread",4710],"thread-4709":["thread",4709],"thread-4696":["thread",4696],"thread-4685":["thread",4685],"thread-4547":["thread",4547],"thread-4509":["thread",4509],"thread-4468":["thread",4468],"thread-4453":["thread",4453],"thread-4367":["thread",4367],"thread-4354":["thread",4354],"thread-4345":["thread",4345],"thread-4330":["thread",4330],"thread-4322":["thread",4322],"thread-4321":["thread",4321],"thread-4292":["thread",4292],"thread-4147":["thread",4147],"thread-4124":["thread",4124],"thread-4117":["thread",4117],"thread-4034":["thread",4034],"thread-3919":["thread",3919],"thread-3792":["thread",3792],"thread-3775":["thread",3775],"thread-3731":["thread",3731],"thread-3710":["thread",3710],"thread-3635":["thread",3635],"thread-3602":["thread",3602],"thread-3481":["thread",3481],"thread-3467":["thread",3467],"thread-3307":["thread",3307],"thread-3245":["thread",3245],"thread-3235":["thread",3235],"thread-3198":["thread",3198],"thread-3164":["thread",3164],"thread-3147":["thread",3147],"thread-3112":["thread",3112],"thread-3101":["thread",3101],"thread-3076":["thread",3076],"thread-3042":["thread",3042],"thread-3037":["thread",3037],"thread-3005":["thread",3005],"thread-2988":["thread",2988],"thread-2905":["thread",2905],"thread-2900":["thread",2900],"thread-2874":["thread",2874],"thread-2842":["thread",2842],"thread-2772":["thread",2772],"thread-2749":["thread",2749],"thread-2735":["thread",2735],"thread-2715":["thread",2715],"thread-2595":["thread",2595],"thread-2551":["thread",2551],"thread-888":["thread",888],"thread-885":["thread",885],"thread-849":["thread",849],"thread-750":["thread",750],"thread-718":["thread",718],"thread-686":["thread",686],"thread-671":["thread",671],"thread-665":["thread",665],"thread-660":["thread",660],"thread-659":["thread",659],"thread-652":["thread",652],"thread-646":["thread",646],"thread-644":["thread",644],"thread-637":["thread",637],"thread-635":["thread",635],"thread-560":["thread",560],"thread-551":["thread",551],"thread-548":["thread",548],"thread-547":["thread",547],"thread-483":["thread",483],"thread-466":["thread",466],"thread-460":["thread",460]}, , 1714894941
Run Time: 0.000427
- 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