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 (46072, 45969, 37669, 37649, 25027, 25026, 25025, 25024, 25023, 25022, 25021, 25020, 25019, 25018, 25017, 25016, 25015, 25014, 25013, 25012, 25011, 25009, 25008, 25007, 25006, 25005, 25004, 25003, 25002, 25000, 24999, 24998, 24997, 24996, 24995, 24994, 24993, 24992, 24991, 24990, 24989, 24988, 24987, 24986, 24985, 24984, 24983, 24982, 24981, 24980, 24979, 24978, 24977, 24976, 24975, 24974, 24973, 24971, 24970, 24969, 24968, 24967, 24966, 24965, 24964, 24963, 24962, 24961, 24960, 24959, 24958, 24957, 24956, 24955, 24954, 24953, 24952, 24951, 24950, 24949, 24948, 24947, 24945, 24944, 24943, 24942, 24941, 24940, 24939, 24938, 24937, 24936, 24935, 24934, 24933, 24932, 24931, 24930, 24929, 24928, 24927, 24926, 24925, 24924, 24923, 24922, 24921, 24920, 24919, 24918, 24917, 24916, 24915, 24914, 24913, 24912, 24911, 24910, 24909, 24908, 24907, 24906, 24905, 24904, 24903, 24902, 24901, 24899, 24898, 24897, 24896, 24894, 24893, 24892, 24891, 24890, 24889, 24888, 24887, 24886, 24885, 24884, 24882, 24881, 24880, 24879, 24878, 24877, 24876, 24875, 24874, 24873, 24872, 24871, 24870, 24869, 24868, 24867, 24866, 24865, 24864, 24863, 24862, 24861, 24860, 24859, 24858, 24857, 24856, 24855, 24854, 24853, 24852, 24851, 24849, 24848, 24847, 24846, 24844, 24843, 24841, 24840, 24839, 24838, 24837, 24834, 24833, 24832, 24831, 24830, 24829, 24828, 24827, 24826, 24825, 24824, 24823, 24822, 24821, 24820))
Run Time: 0.009786
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: 576, 0, 1715649036, {"thread-46072":["thread",46072],"thread-45969":["thread",45969],"thread-37669":["thread",37669],"thread-37649":["thread",37649],"thread-25027":["thread",25027],"thread-25026":["thread",25026],"thread-25025":["thread",25025],"thread-25024":["thread",25024],"thread-25023":["thread",25023],"thread-25022":["thread",25022],"thread-25021":["thread",25021],"thread-25020":["thread",25020],"thread-25019":["thread",25019],"thread-25018":["thread",25018],"thread-25017":["thread",25017],"thread-25016":["thread",25016],"thread-25015":["thread",25015],"thread-25014":["thread",25014],"thread-25013":["thread",25013],"thread-25012":["thread",25012],"thread-25011":["thread",25011],"thread-25009":["thread",25009],"thread-25008":["thread",25008],"thread-25007":["thread",25007],"thread-25006":["thread",25006],"thread-25005":["thread",25005],"thread-25004":["thread",25004],"thread-25003":["thread",25003],"thread-25002":["thread",25002],"thread-25000":["thread",25000],"thread-24999":["thread",24999],"thread-24998":["thread",24998],"thread-24997":["thread",24997],"thread-24996":["thread",24996],"thread-24995":["thread",24995],"thread-24994":["thread",24994],"thread-24993":["thread",24993],"thread-24992":["thread",24992],"thread-24991":["thread",24991],"thread-24990":["thread",24990],"thread-24989":["thread",24989],"thread-24988":["thread",24988],"thread-24987":["thread",24987],"thread-24986":["thread",24986],"thread-24985":["thread",24985],"thread-24984":["thread",24984],"thread-24983":["thread",24983],"thread-24982":["thread",24982],"thread-24981":["thread",24981],"thread-24980":["thread",24980],"thread-24979":["thread",24979],"thread-24978":["thread",24978],"thread-24977":["thread",24977],"thread-24976":["thread",24976],"thread-24975":["thread",24975],"thread-24974":["thread",24974],"thread-24973":["thread",24973],"thread-24971":["thread",24971],"thread-24970":["thread",24970],"thread-24969":["thread",24969],"thread-24968":["thread",24968],"thread-24967":["thread",24967],"thread-24966":["thread",24966],"thread-24965":["thread",24965],"thread-24964":["thread",24964],"thread-24963":["thread",24963],"thread-24962":["thread",24962],"thread-24961":["thread",24961],"thread-24960":["thread",24960],"thread-24959":["thread",24959],"thread-24958":["thread",24958],"thread-24957":["thread",24957],"thread-24956":["thread",24956],"thread-24955":["thread",24955],"thread-24954":["thread",24954],"thread-24953":["thread",24953],"thread-24952":["thread",24952],"thread-24951":["thread",24951],"thread-24950":["thread",24950],"thread-24949":["thread",24949],"thread-24948":["thread",24948],"thread-24947":["thread",24947],"thread-24945":["thread",24945],"thread-24944":["thread",24944],"thread-24943":["thread",24943],"thread-24942":["thread",24942],"thread-24941":["thread",24941],"thread-24940":["thread",24940],"thread-24939":["thread",24939],"thread-24938":["thread",24938],"thread-24937":["thread",24937],"thread-24936":["thread",24936],"thread-24935":["thread",24935],"thread-24934":["thread",24934],"thread-24933":["thread",24933],"thread-24932":["thread",24932],"thread-24931":["thread",24931],"thread-24930":["thread",24930],"thread-24929":["thread",24929],"thread-24928":["thread",24928],"thread-24927":["thread",24927],"thread-24926":["thread",24926],"thread-24925":["thread",24925],"thread-24924":["thread",24924],"thread-24923":["thread",24923],"thread-24922":["thread",24922],"thread-24921":["thread",24921],"thread-24920":["thread",24920],"thread-24919":["thread",24919],"thread-24918":["thread",24918],"thread-24917":["thread",24917],"thread-24916":["thread",24916],"thread-24915":["thread",24915],"thread-24914":["thread",24914],"thread-24913":["thread",24913],"thread-24912":["thread",24912],"thread-24911":["thread",24911],"thread-24910":["thread",24910],"thread-24909":["thread",24909],"thread-24908":["thread",24908],"thread-24907":["thread",24907],"thread-24906":["thread",24906],"thread-24905":["thread",24905],"thread-24904":["thread",24904],"thread-24903":["thread",24903],"thread-24902":["thread",24902],"thread-24901":["thread",24901],"thread-24899":["thread",24899],"thread-24898":["thread",24898],"thread-24897":["thread",24897],"thread-24896":["thread",24896],"thread-24894":["thread",24894],"thread-24893":["thread",24893],"thread-24892":["thread",24892],"thread-24891":["thread",24891],"thread-24890":["thread",24890],"thread-24889":["thread",24889],"thread-24888":["thread",24888],"thread-24887":["thread",24887],"thread-24886":["thread",24886],"thread-24885":["thread",24885],"thread-24884":["thread",24884],"thread-24882":["thread",24882],"thread-24881":["thread",24881],"thread-24880":["thread",24880],"thread-24879":["thread",24879],"thread-24878":["thread",24878],"thread-24877":["thread",24877],"thread-24876":["thread",24876],"thread-24875":["thread",24875],"thread-24874":["thread",24874],"thread-24873":["thread",24873],"thread-24872":["thread",24872],"thread-24871":["thread",24871],"thread-24870":["thread",24870],"thread-24869":["thread",24869],"thread-24868":["thread",24868],"thread-24867":["thread",24867],"thread-24866":["thread",24866],"thread-24865":["thread",24865],"thread-24864":["thread",24864],"thread-24863":["thread",24863],"thread-24862":["thread",24862],"thread-24861":["thread",24861],"thread-24860":["thread",24860],"thread-24859":["thread",24859],"thread-24858":["thread",24858],"thread-24857":["thread",24857],"thread-24856":["thread",24856],"thread-24855":["thread",24855],"thread-24854":["thread",24854],"thread-24853":["thread",24853],"thread-24852":["thread",24852],"thread-24851":["thread",24851],"thread-24849":["thread",24849],"thread-24848":["thread",24848],"thread-24847":["thread",24847],"thread-24846":["thread",24846],"thread-24844":["thread",24844],"thread-24843":["thread",24843],"thread-24841":["thread",24841],"thread-24840":["thread",24840],"thread-24839":["thread",24839],"thread-24838":["thread",24838],"thread-24837":["thread",24837],"thread-24834":["thread",24834],"thread-24833":["thread",24833],"thread-24832":["thread",24832],"thread-24831":["thread",24831],"thread-24830":["thread",24830],"thread-24829":["thread",24829],"thread-24828":["thread",24828],"thread-24827":["thread",24827],"thread-24826":["thread",24826],"thread-24825":["thread",24825],"thread-24824":["thread",24824],"thread-24823":["thread",24823],"thread-24822":["thread",24822],"thread-24821":["thread",24821],"thread-24820":["thread",24820]}, , 1715645436
Run Time: 0.000656
- 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