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 (7216423, 7212169, 7210527, 7210309, 7209943, 7204866, 7204824, 7201656, 7200978, 7199339, 7198398, 7198352, 7194391, 7194240, 7193827, 7192745, 7191118, 7190854, 7188672, 7188670, 7170297, 7170124, 7169763, 7154500, 7150835, 7149884, 7148636, 7147241, 7144804, 7143162, 7140423, 7139249, 7138959, 7138543, 7136344, 7133034, 7128666, 7128138, 7124912, 7123958, 7121610, 7117768, 7112964, 7112961, 7109382, 7106581, 7094203, 7086672, 7078823, 7071805, 7071706, 7071098, 7063627, 7054843, 7035085, 7031568, 7016619, 7010302, 7005747, 6994276, 6989782, 6982364, 6979494, 6978679, 6925291, 6583128, 6502008, 216841, 178651, 174452, 168240, 165979, 160361, 13232, 13172, 11150, 11105, 10750, 10532, 9460, 9043, 8811, 8797, 8681, 8201, 7967, 7635, 7394, 6666, 6162, 5994, 4982, 4487, 3835, 3630, 3166, 2633, 2119, 1889, 820, 697))
Run Time: 0.005591
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 101 | 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: 805, 0, 1714452989, {"thread-7216423":["thread",7216423],"thread-7212169":["thread",7212169],"thread-7210527":["thread",7210527],"thread-7210309":["thread",7210309],"thread-7209943":["thread",7209943],"thread-7204866":["thread",7204866],"thread-7204824":["thread",7204824],"thread-7201656":["thread",7201656],"thread-7200978":["thread",7200978],"thread-7199339":["thread",7199339],"thread-7198398":["thread",7198398],"thread-7198352":["thread",7198352],"thread-7194391":["thread",7194391],"thread-7194240":["thread",7194240],"thread-7193827":["thread",7193827],"thread-7192745":["thread",7192745],"thread-7191118":["thread",7191118],"thread-7190854":["thread",7190854],"thread-7188672":["thread",7188672],"thread-7188670":["thread",7188670],"thread-7170297":["thread",7170297],"thread-7170124":["thread",7170124],"thread-7169763":["thread",7169763],"thread-7154500":["thread",7154500],"thread-7150835":["thread",7150835],"thread-7149884":["thread",7149884],"thread-7148636":["thread",7148636],"thread-7147241":["thread",7147241],"thread-7144804":["thread",7144804],"thread-7143162":["thread",7143162],"thread-7140423":["thread",7140423],"thread-7139249":["thread",7139249],"thread-7138959":["thread",7138959],"thread-7138543":["thread",7138543],"thread-7136344":["thread",7136344],"thread-7133034":["thread",7133034],"thread-7128666":["thread",7128666],"thread-7128138":["thread",7128138],"thread-7124912":["thread",7124912],"thread-7123958":["thread",7123958],"thread-7121610":["thread",7121610],"thread-7117768":["thread",7117768],"thread-7112964":["thread",7112964],"thread-7112961":["thread",7112961],"thread-7109382":["thread",7109382],"thread-7106581":["thread",7106581],"thread-7094203":["thread",7094203],"thread-7086672":["thread",7086672],"thread-7078823":["thread",7078823],"thread-7071805":["thread",7071805],"thread-7071706":["thread",7071706],"thread-7071098":["thread",7071098],"thread-7063627":["thread",7063627],"thread-7054843":["thread",7054843],"thread-7035085":["thread",7035085],"thread-7031568":["thread",7031568],"thread-7016619":["thread",7016619],"thread-7010302":["thread",7010302],"thread-7005747":["thread",7005747],"thread-6994276":["thread",6994276],"thread-6989782":["thread",6989782],"thread-6982364":["thread",6982364],"thread-6979494":["thread",6979494],"thread-6978679":["thread",6978679],"thread-6925291":["thread",6925291],"thread-6583128":["thread",6583128],"thread-6502008":["thread",6502008],"thread-216841":["thread",216841],"thread-178651":["thread",178651],"thread-174452":["thread",174452],"thread-168240":["thread",168240],"thread-165979":["thread",165979],"thread-160361":["thread",160361],"thread-13232":["thread",13232],"thread-13172":["thread",13172],"thread-11150":["thread",11150],"thread-11105":["thread",11105],"thread-10750":["thread",10750],"thread-10532":["thread",10532],"thread-9460":["thread",9460],"thread-9043":["thread",9043],"thread-8811":["thread",8811],"thread-8797":["thread",8797],"thread-8681":["thread",8681],"thread-8201":["thread",8201],"thread-7967":["thread",7967],"thread-7635":["thread",7635],"thread-7394":["thread",7394],"thread-6666":["thread",6666],"thread-6162":["thread",6162],"thread-5994":["thread",5994],"thread-4982":["thread",4982],"thread-4487":["thread",4487],"thread-3835":["thread",3835],"thread-3630":["thread",3630],"thread-3166":["thread",3166],"thread-2633":["thread",2633],"thread-2119":["thread",2119],"thread-1889":["thread",1889],"thread-820":["thread",820],"thread-697":["thread",697]}, NULL, 1714449389
Run Time: 0.000462
- 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