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 (21020, 21019, 21018, 21017, 21016, 21015, 21014, 21013, 21011, 21010, 21009, 21008, 21007, 21006, 21005, 21004, 21003, 21002, 21001, 21000, 20999, 20998, 20997, 20996, 20995, 20994, 20993, 20992, 20991, 20990, 20989, 20988, 20987, 20986, 20985, 20984, 20983, 20982, 20981, 20980, 20979, 20978, 20977, 20976, 20975, 20974, 20973, 20972, 20971, 20968, 20967, 20966, 20965, 20964, 20963, 20962, 20961, 20960, 20959, 20958, 20957, 20956, 20955, 20954, 20953, 20952, 20951, 20950, 20948, 20945, 20944, 20943, 20942, 20941, 20940, 20939, 20938, 20937, 20936, 20935, 20934, 20932, 20931, 20930, 20929, 20928, 20927, 20926, 20925, 20924, 20923, 20922, 20921, 20920, 20919, 20918, 20917, 20916, 20915, 20914, 20913, 20912, 20911, 20910, 20909, 20905, 20904, 20903, 20902, 20898, 20897, 20896, 20894, 20893, 20892, 20891, 20890, 20889, 20888, 20887, 20886, 20885, 20884, 20883, 20882, 20881, 20880, 20879, 20878, 20877, 20876, 20875, 20874, 20873, 20871, 20870, 20869, 20868, 20867, 20865, 20864, 20863, 20862, 20861, 20860, 20859, 20858, 20857, 20856, 20855, 20854, 20853, 20852, 20851, 20850, 20849, 20848, 20847, 20846, 20845, 20844, 20842, 20840, 20839, 20838, 20837, 20836, 20835, 20834, 20833, 20832, 20831, 20830, 20829, 20828, 20827, 20826, 20825, 20821, 20820, 20818, 20816, 20815, 20814, 20813, 20812, 20811, 20810, 20809, 20808, 20807, 20806, 20804, 20803, 20802, 20801, 20800, 20799, 20798, 20797))
Run Time: 0.012298
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 | import4.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,import4.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 2719
- 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 2345
- XF\App->run() in src/XF.php at line 512
- 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: 596, 0, 1715750909, {"thread-21020":["thread",21020],"thread-21019":["thread",21019],"thread-21018":["thread",21018],"thread-21017":["thread",21017],"thread-21016":["thread",21016],"thread-21015":["thread",21015],"thread-21014":["thread",21014],"thread-21013":["thread",21013],"thread-21011":["thread",21011],"thread-21010":["thread",21010],"thread-21009":["thread",21009],"thread-21008":["thread",21008],"thread-21007":["thread",21007],"thread-21006":["thread",21006],"thread-21005":["thread",21005],"thread-21004":["thread",21004],"thread-21003":["thread",21003],"thread-21002":["thread",21002],"thread-21001":["thread",21001],"thread-21000":["thread",21000],"thread-20999":["thread",20999],"thread-20998":["thread",20998],"thread-20997":["thread",20997],"thread-20996":["thread",20996],"thread-20995":["thread",20995],"thread-20994":["thread",20994],"thread-20993":["thread",20993],"thread-20992":["thread",20992],"thread-20991":["thread",20991],"thread-20990":["thread",20990],"thread-20989":["thread",20989],"thread-20988":["thread",20988],"thread-20987":["thread",20987],"thread-20986":["thread",20986],"thread-20985":["thread",20985],"thread-20984":["thread",20984],"thread-20983":["thread",20983],"thread-20982":["thread",20982],"thread-20981":["thread",20981],"thread-20980":["thread",20980],"thread-20979":["thread",20979],"thread-20978":["thread",20978],"thread-20977":["thread",20977],"thread-20976":["thread",20976],"thread-20975":["thread",20975],"thread-20974":["thread",20974],"thread-20973":["thread",20973],"thread-20972":["thread",20972],"thread-20971":["thread",20971],"thread-20968":["thread",20968],"thread-20967":["thread",20967],"thread-20966":["thread",20966],"thread-20965":["thread",20965],"thread-20964":["thread",20964],"thread-20963":["thread",20963],"thread-20962":["thread",20962],"thread-20961":["thread",20961],"thread-20960":["thread",20960],"thread-20959":["thread",20959],"thread-20958":["thread",20958],"thread-20957":["thread",20957],"thread-20956":["thread",20956],"thread-20955":["thread",20955],"thread-20954":["thread",20954],"thread-20953":["thread",20953],"thread-20952":["thread",20952],"thread-20951":["thread",20951],"thread-20950":["thread",20950],"thread-20948":["thread",20948],"thread-20945":["thread",20945],"thread-20944":["thread",20944],"thread-20943":["thread",20943],"thread-20942":["thread",20942],"thread-20941":["thread",20941],"thread-20940":["thread",20940],"thread-20939":["thread",20939],"thread-20938":["thread",20938],"thread-20937":["thread",20937],"thread-20936":["thread",20936],"thread-20935":["thread",20935],"thread-20934":["thread",20934],"thread-20932":["thread",20932],"thread-20931":["thread",20931],"thread-20930":["thread",20930],"thread-20929":["thread",20929],"thread-20928":["thread",20928],"thread-20927":["thread",20927],"thread-20926":["thread",20926],"thread-20925":["thread",20925],"thread-20924":["thread",20924],"thread-20923":["thread",20923],"thread-20922":["thread",20922],"thread-20921":["thread",20921],"thread-20920":["thread",20920],"thread-20919":["thread",20919],"thread-20918":["thread",20918],"thread-20917":["thread",20917],"thread-20916":["thread",20916],"thread-20915":["thread",20915],"thread-20914":["thread",20914],"thread-20913":["thread",20913],"thread-20912":["thread",20912],"thread-20911":["thread",20911],"thread-20910":["thread",20910],"thread-20909":["thread",20909],"thread-20905":["thread",20905],"thread-20904":["thread",20904],"thread-20903":["thread",20903],"thread-20902":["thread",20902],"thread-20898":["thread",20898],"thread-20897":["thread",20897],"thread-20896":["thread",20896],"thread-20894":["thread",20894],"thread-20893":["thread",20893],"thread-20892":["thread",20892],"thread-20891":["thread",20891],"thread-20890":["thread",20890],"thread-20889":["thread",20889],"thread-20888":["thread",20888],"thread-20887":["thread",20887],"thread-20886":["thread",20886],"thread-20885":["thread",20885],"thread-20884":["thread",20884],"thread-20883":["thread",20883],"thread-20882":["thread",20882],"thread-20881":["thread",20881],"thread-20880":["thread",20880],"thread-20879":["thread",20879],"thread-20878":["thread",20878],"thread-20877":["thread",20877],"thread-20876":["thread",20876],"thread-20875":["thread",20875],"thread-20874":["thread",20874],"thread-20873":["thread",20873],"thread-20871":["thread",20871],"thread-20870":["thread",20870],"thread-20869":["thread",20869],"thread-20868":["thread",20868],"thread-20867":["thread",20867],"thread-20865":["thread",20865],"thread-20864":["thread",20864],"thread-20863":["thread",20863],"thread-20862":["thread",20862],"thread-20861":["thread",20861],"thread-20860":["thread",20860],"thread-20859":["thread",20859],"thread-20858":["thread",20858],"thread-20857":["thread",20857],"thread-20856":["thread",20856],"thread-20855":["thread",20855],"thread-20854":["thread",20854],"thread-20853":["thread",20853],"thread-20852":["thread",20852],"thread-20851":["thread",20851],"thread-20850":["thread",20850],"thread-20849":["thread",20849],"thread-20848":["thread",20848],"thread-20847":["thread",20847],"thread-20846":["thread",20846],"thread-20845":["thread",20845],"thread-20844":["thread",20844],"thread-20842":["thread",20842],"thread-20840":["thread",20840],"thread-20839":["thread",20839],"thread-20838":["thread",20838],"thread-20837":["thread",20837],"thread-20836":["thread",20836],"thread-20835":["thread",20835],"thread-20834":["thread",20834],"thread-20833":["thread",20833],"thread-20832":["thread",20832],"thread-20831":["thread",20831],"thread-20830":["thread",20830],"thread-20829":["thread",20829],"thread-20828":["thread",20828],"thread-20827":["thread",20827],"thread-20826":["thread",20826],"thread-20825":["thread",20825],"thread-20821":["thread",20821],"thread-20820":["thread",20820],"thread-20818":["thread",20818],"thread-20816":["thread",20816],"thread-20815":["thread",20815],"thread-20814":["thread",20814],"thread-20813":["thread",20813],"thread-20812":["thread",20812],"thread-20811":["thread",20811],"thread-20810":["thread",20810],"thread-20809":["thread",20809],"thread-20808":["thread",20808],"thread-20807":["thread",20807],"thread-20806":["thread",20806],"thread-20804":["thread",20804],"thread-20803":["thread",20803],"thread-20802":["thread",20802],"thread-20801":["thread",20801],"thread-20800":["thread",20800],"thread-20799":["thread",20799],"thread-20798":["thread",20798],"thread-20797":["thread",20797]}, , 1715747309
Run Time: 0.000417
- 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 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- 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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20