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 (7217322, 7216686, 7215162, 7211325, 7210523, 7208819, 7202855, 7202254, 7194355, 7192897, 7190792, 7180355, 7177686, 7176093, 7168932, 7162302, 7157125, 7155412, 7155095, 7153677, 7153303, 7144015, 7142232, 7139695, 7137829, 7137606, 7137379, 7136932, 7130846, 7126593, 7113459, 7111523, 7110648, 7107660, 7100594, 7097025, 7089397, 7086424, 7084606, 7083060, 7082413, 7075610, 7074069, 7053898, 7048862, 7045584, 7036152, 7035934, 7034219, 7032915, 7031229, 7021849, 7021425, 7016479, 7009764, 7007931, 7006682, 6999333, 6997947, 6994281, 6994170, 6992080, 6986173, 6985721, 6985293, 6984206, 6982099, 6978764, 6974987, 6966388, 6966384, 6966383, 6956905, 6649247, 6363898, 6279873, 6266315, 234568, 227057, 224314, 223842, 221370, 219781, 212700, 212690, 196950, 193132, 191065, 187832, 187441, 187125, 187085, 186060, 184877, 182710, 182680, 175680, 172460, 169730, 165324, 162989, 160427, 13827, 13800, 13740, 13675, 13596, 13539, 13502, 13495, 13459, 13389, 13357, 13338, 13297, 13210, 13083, 13067, 13021, 12923, 12851, 12804, 12699, 12382, 12357, 12293, 12216, 12172, 12120, 12099, 12078, 12057, 11992, 11964, 11950, 11944, 11933, 11921, 11917, 11846, 11824, 11768, 11748, 11695, 11657, 11179, 11118, 10929, 10892, 10772, 10745, 10723, 10682, 10622, 10589, 10537, 10491, 10434, 10354, 10350, 10262, 10180, 10131, 10097, 9975, 9944, 9943, 9922, 9853, 9802, 9781, 9651, 9636, 9548, 9514, 9417, 9415, 9343, 9056, 8940, 8931, 8880, 8852, 8836, 8817, 8813, 8778, 8759, 8708, 8684, 8656, 8638, 8380, 8377, 8334, 8304, 8177, 8134, 8079, 8057))
Run Time: 0.012356
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: 144, 0, 1716091270, {"thread-7217322":["thread",7217322],"thread-7216686":["thread",7216686],"thread-7215162":["thread",7215162],"thread-7211325":["thread",7211325],"thread-7210523":["thread",7210523],"thread-7208819":["thread",7208819],"thread-7202855":["thread",7202855],"thread-7202254":["thread",7202254],"thread-7194355":["thread",7194355],"thread-7192897":["thread",7192897],"thread-7190792":["thread",7190792],"thread-7180355":["thread",7180355],"thread-7177686":["thread",7177686],"thread-7176093":["thread",7176093],"thread-7168932":["thread",7168932],"thread-7162302":["thread",7162302],"thread-7157125":["thread",7157125],"thread-7155412":["thread",7155412],"thread-7155095":["thread",7155095],"thread-7153677":["thread",7153677],"thread-7153303":["thread",7153303],"thread-7144015":["thread",7144015],"thread-7142232":["thread",7142232],"thread-7139695":["thread",7139695],"thread-7137829":["thread",7137829],"thread-7137606":["thread",7137606],"thread-7137379":["thread",7137379],"thread-7136932":["thread",7136932],"thread-7130846":["thread",7130846],"thread-7126593":["thread",7126593],"thread-7113459":["thread",7113459],"thread-7111523":["thread",7111523],"thread-7110648":["thread",7110648],"thread-7107660":["thread",7107660],"thread-7100594":["thread",7100594],"thread-7097025":["thread",7097025],"thread-7089397":["thread",7089397],"thread-7086424":["thread",7086424],"thread-7084606":["thread",7084606],"thread-7083060":["thread",7083060],"thread-7082413":["thread",7082413],"thread-7075610":["thread",7075610],"thread-7074069":["thread",7074069],"thread-7053898":["thread",7053898],"thread-7048862":["thread",7048862],"thread-7045584":["thread",7045584],"thread-7036152":["thread",7036152],"thread-7035934":["thread",7035934],"thread-7034219":["thread",7034219],"thread-7032915":["thread",7032915],"thread-7031229":["thread",7031229],"thread-7021849":["thread",7021849],"thread-7021425":["thread",7021425],"thread-7016479":["thread",7016479],"thread-7009764":["thread",7009764],"thread-7007931":["thread",7007931],"thread-7006682":["thread",7006682],"thread-6999333":["thread",6999333],"thread-6997947":["thread",6997947],"thread-6994281":["thread",6994281],"thread-6994170":["thread",6994170],"thread-6992080":["thread",6992080],"thread-6986173":["thread",6986173],"thread-6985721":["thread",6985721],"thread-6985293":["thread",6985293],"thread-6984206":["thread",6984206],"thread-6982099":["thread",6982099],"thread-6978764":["thread",6978764],"thread-6974987":["thread",6974987],"thread-6966388":["thread",6966388],"thread-6966384":["thread",6966384],"thread-6966383":["thread",6966383],"thread-6956905":["thread",6956905],"thread-6649247":["thread",6649247],"thread-6363898":["thread",6363898],"thread-6279873":["thread",6279873],"thread-6266315":["thread",6266315],"thread-234568":["thread",234568],"thread-227057":["thread",227057],"thread-224314":["thread",224314],"thread-223842":["thread",223842],"thread-221370":["thread",221370],"thread-219781":["thread",219781],"thread-212700":["thread",212700],"thread-212690":["thread",212690],"thread-196950":["thread",196950],"thread-193132":["thread",193132],"thread-191065":["thread",191065],"thread-187832":["thread",187832],"thread-187441":["thread",187441],"thread-187125":["thread",187125],"thread-187085":["thread",187085],"thread-186060":["thread",186060],"thread-184877":["thread",184877],"thread-182710":["thread",182710],"thread-182680":["thread",182680],"thread-175680":["thread",175680],"thread-172460":["thread",172460],"thread-169730":["thread",169730],"thread-165324":["thread",165324],"thread-162989":["thread",162989],"thread-160427":["thread",160427],"thread-13827":["thread",13827],"thread-13800":["thread",13800],"thread-13740":["thread",13740],"thread-13675":["thread",13675],"thread-13596":["thread",13596],"thread-13539":["thread",13539],"thread-13502":["thread",13502],"thread-13495":["thread",13495],"thread-13459":["thread",13459],"thread-13389":["thread",13389],"thread-13357":["thread",13357],"thread-13338":["thread",13338],"thread-13297":["thread",13297],"thread-13210":["thread",13210],"thread-13083":["thread",13083],"thread-13067":["thread",13067],"thread-13021":["thread",13021],"thread-12923":["thread",12923],"thread-12851":["thread",12851],"thread-12804":["thread",12804],"thread-12699":["thread",12699],"thread-12382":["thread",12382],"thread-12357":["thread",12357],"thread-12293":["thread",12293],"thread-12216":["thread",12216],"thread-12172":["thread",12172],"thread-12120":["thread",12120],"thread-12099":["thread",12099],"thread-12078":["thread",12078],"thread-12057":["thread",12057],"thread-11992":["thread",11992],"thread-11964":["thread",11964],"thread-11950":["thread",11950],"thread-11944":["thread",11944],"thread-11933":["thread",11933],"thread-11921":["thread",11921],"thread-11917":["thread",11917],"thread-11846":["thread",11846],"thread-11824":["thread",11824],"thread-11768":["thread",11768],"thread-11748":["thread",11748],"thread-11695":["thread",11695],"thread-11657":["thread",11657],"thread-11179":["thread",11179],"thread-11118":["thread",11118],"thread-10929":["thread",10929],"thread-10892":["thread",10892],"thread-10772":["thread",10772],"thread-10745":["thread",10745],"thread-10723":["thread",10723],"thread-10682":["thread",10682],"thread-10622":["thread",10622],"thread-10589":["thread",10589],"thread-10537":["thread",10537],"thread-10491":["thread",10491],"thread-10434":["thread",10434],"thread-10354":["thread",10354],"thread-10350":["thread",10350],"thread-10262":["thread",10262],"thread-10180":["thread",10180],"thread-10131":["thread",10131],"thread-10097":["thread",10097],"thread-9975":["thread",9975],"thread-9944":["thread",9944],"thread-9943":["thread",9943],"thread-9922":["thread",9922],"thread-9853":["thread",9853],"thread-9802":["thread",9802],"thread-9781":["thread",9781],"thread-9651":["thread",9651],"thread-9636":["thread",9636],"thread-9548":["thread",9548],"thread-9514":["thread",9514],"thread-9417":["thread",9417],"thread-9415":["thread",9415],"thread-9343":["thread",9343],"thread-9056":["thread",9056],"thread-8940":["thread",8940],"thread-8931":["thread",8931],"thread-8852":["thread",8852],"thread-8836":["thread",8836],"thread-8817":["thread",8817],"thread-8813":["thread",8813],"thread-8778":["thread",8778],"thread-8759":["thread",8759],"thread-8708":["thread",8708],"thread-8684":["thread",8684],"thread-8656":["thread",8656],"thread-8638":["thread",8638],"thread-8380":["thread",8380],"thread-8377":["thread",8377],"thread-8334":["thread",8334],"thread-8304":["thread",8304],"thread-8177":["thread",8177],"thread-8134":["thread",8134],"thread-8079":["thread",8079],"thread-8057":["thread",8057]}, NULL, 1716087670
Run Time: 0.000716
- 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