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 (7208682, 7208681, 7205703, 7199404, 7199383, 7198343, 7195060, 7190031, 7186814, 7181273, 7174692, 7173024, 7171237, 7168751, 7156323, 7154120, 7154116, 7152265, 7151814, 7151002, 7149404, 7149282, 7149121, 7146176, 7146174, 7146170, 7139773, 7139295, 7132525, 7131485, 7131125, 7129748, 7125600, 7122634, 7117398, 7117050, 7115294, 7113826, 7112838, 7112794, 7112660, 7111134, 7109748, 7100383, 7092104, 7089867, 7086139, 7086000, 7084558, 7084156, 7075992, 7074186, 7073027, 7070505, 7066456, 7052249, 7047209, 7046579, 7046325, 7041803, 7023169, 7019267, 7015764, 7001724, 7001304, 6979565, 6969650, 225382, 222244, 215125, 210071, 163728, 13421, 13383, 13248, 13182, 13070, 11569, 11447, 11308, 10889, 9709, 9660, 9631, 9449, 8970, 8490, 7902, 6344, 6238, 6052, 5705, 5487, 5357, 5297, 5202, 4907, 4824, 4225, 3246, 2975, 2822, 2314, 2034, 2008, 1651, 1643, 1597, 1545, 1417, 1244, 1077, 1059, 451, 399, 218))
Run Time: 0.007141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 116 | 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: 155, 0, 1714973840, {"thread-7208682":["thread",7208682],"thread-7208681":["thread",7208681],"thread-7205703":["thread",7205703],"thread-7199404":["thread",7199404],"thread-7199383":["thread",7199383],"thread-7198343":["thread",7198343],"thread-7195060":["thread",7195060],"thread-7190031":["thread",7190031],"thread-7186814":["thread",7186814],"thread-7181273":["thread",7181273],"thread-7174692":["thread",7174692],"thread-7173024":["thread",7173024],"thread-7171237":["thread",7171237],"thread-7168751":["thread",7168751],"thread-7156323":["thread",7156323],"thread-7154120":["thread",7154120],"thread-7154116":["thread",7154116],"thread-7152265":["thread",7152265],"thread-7151814":["thread",7151814],"thread-7151002":["thread",7151002],"thread-7149404":["thread",7149404],"thread-7149282":["thread",7149282],"thread-7149121":["thread",7149121],"thread-7146176":["thread",7146176],"thread-7146174":["thread",7146174],"thread-7146170":["thread",7146170],"thread-7139773":["thread",7139773],"thread-7139295":["thread",7139295],"thread-7132525":["thread",7132525],"thread-7131485":["thread",7131485],"thread-7131125":["thread",7131125],"thread-7129748":["thread",7129748],"thread-7125600":["thread",7125600],"thread-7122634":["thread",7122634],"thread-7117398":["thread",7117398],"thread-7117050":["thread",7117050],"thread-7115294":["thread",7115294],"thread-7113826":["thread",7113826],"thread-7112838":["thread",7112838],"thread-7112794":["thread",7112794],"thread-7112660":["thread",7112660],"thread-7111134":["thread",7111134],"thread-7109748":["thread",7109748],"thread-7100383":["thread",7100383],"thread-7092104":["thread",7092104],"thread-7089867":["thread",7089867],"thread-7086139":["thread",7086139],"thread-7086000":["thread",7086000],"thread-7084558":["thread",7084558],"thread-7084156":["thread",7084156],"thread-7075992":["thread",7075992],"thread-7074186":["thread",7074186],"thread-7073027":["thread",7073027],"thread-7070505":["thread",7070505],"thread-7066456":["thread",7066456],"thread-7052249":["thread",7052249],"thread-7047209":["thread",7047209],"thread-7046579":["thread",7046579],"thread-7046325":["thread",7046325],"thread-7041803":["thread",7041803],"thread-7023169":["thread",7023169],"thread-7019267":["thread",7019267],"thread-7015764":["thread",7015764],"thread-7001724":["thread",7001724],"thread-7001304":["thread",7001304],"thread-6979565":["thread",6979565],"thread-6969650":["thread",6969650],"thread-225382":["thread",225382],"thread-222244":["thread",222244],"thread-215125":["thread",215125],"thread-210071":["thread",210071],"thread-163728":["thread",163728],"thread-13421":["thread",13421],"thread-13383":["thread",13383],"thread-13248":["thread",13248],"thread-13182":["thread",13182],"thread-13070":["thread",13070],"thread-11569":["thread",11569],"thread-11447":["thread",11447],"thread-11308":["thread",11308],"thread-10889":["thread",10889],"thread-9709":["thread",9709],"thread-9660":["thread",9660],"thread-9631":["thread",9631],"thread-9449":["thread",9449],"thread-8970":["thread",8970],"thread-8490":["thread",8490],"thread-7902":["thread",7902],"thread-6344":["thread",6344],"thread-6238":["thread",6238],"thread-6052":["thread",6052],"thread-5705":["thread",5705],"thread-5487":["thread",5487],"thread-5357":["thread",5357],"thread-5297":["thread",5297],"thread-5202":["thread",5202],"thread-4907":["thread",4907],"thread-4824":["thread",4824],"thread-4225":["thread",4225],"thread-3246":["thread",3246],"thread-2975":["thread",2975],"thread-2822":["thread",2822],"thread-2314":["thread",2314],"thread-2034":["thread",2034],"thread-2008":["thread",2008],"thread-1651":["thread",1651],"thread-1643":["thread",1643],"thread-1597":["thread",1597],"thread-1545":["thread",1545],"thread-1417":["thread",1417],"thread-1244":["thread",1244],"thread-1077":["thread",1077],"thread-1059":["thread",1059],"thread-451":["thread",451],"thread-399":["thread",399],"thread-218":["thread",218]}, NULL, 1714970240
Run Time: 0.000569
- 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