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 (44462, 37660, 37648, 15281, 11064, 11063, 11061, 11059, 11058, 11054, 11052, 11051, 11047, 11044, 11043, 11041, 11038, 11037, 11036, 11035, 11034, 11033, 11032, 11031, 11027, 11025, 11024, 11023, 11022, 11021, 11020, 11018, 11017, 11016, 11015, 11012, 11011, 11008, 11007, 11006, 11004, 11002, 11001, 11000, 10999, 10997, 10996, 10995, 10994, 10992, 10990, 10989, 10988, 10987, 10986, 10985, 10984, 10982, 10981, 10980, 10979, 10978, 10976, 10975, 10974, 10971, 10969, 10968, 10967, 10966, 10964, 10962, 10959, 10958, 10957, 10956, 10955, 10954, 10953, 10952, 10951, 10950, 10948, 10947, 10945, 10943, 10942, 10940, 10939, 10938, 10937, 10936, 10935, 10934, 10933, 10929, 10928, 10927, 10925, 10924, 10923, 10922, 10921, 10920, 10919, 10918, 10917, 10916, 10915, 10914, 10913, 10912, 10910, 10909, 10908, 10907, 10906, 10905, 10904, 10903, 10902, 10901, 10900, 10899, 10898, 10897, 10896, 10895, 10894, 10893, 10892, 10891, 10890, 10889, 10887, 10885, 10884, 10883, 10882, 10881, 10880, 10879, 10878, 10877, 10876, 10875, 10874, 10873, 10872, 10871, 10870, 10869, 10868, 10867, 10865, 10864, 10863, 10862, 10861, 10860, 10859, 10858, 10857, 10856, 10855, 10854, 10853, 10852, 10851, 10849, 10848, 10847, 10846, 10844, 10843, 10841, 10838, 10837, 10836, 10835, 10834, 10833, 10832, 10830, 10829, 10827, 10826, 10825, 10824, 10823, 10822, 10821, 10820, 10819, 10818, 10816, 10815, 10814, 10813, 10812))
Run Time: 0.013496
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: 445, 0, 1715639085, {"thread-44462":["thread",44462],"thread-37660":["thread",37660],"thread-37648":["thread",37648],"thread-15281":["thread",15281],"thread-11064":["thread",11064],"thread-11063":["thread",11063],"thread-11061":["thread",11061],"thread-11059":["thread",11059],"thread-11058":["thread",11058],"thread-11054":["thread",11054],"thread-11052":["thread",11052],"thread-11051":["thread",11051],"thread-11047":["thread",11047],"thread-11044":["thread",11044],"thread-11043":["thread",11043],"thread-11041":["thread",11041],"thread-11038":["thread",11038],"thread-11037":["thread",11037],"thread-11036":["thread",11036],"thread-11035":["thread",11035],"thread-11034":["thread",11034],"thread-11033":["thread",11033],"thread-11032":["thread",11032],"thread-11031":["thread",11031],"thread-11027":["thread",11027],"thread-11025":["thread",11025],"thread-11024":["thread",11024],"thread-11023":["thread",11023],"thread-11022":["thread",11022],"thread-11021":["thread",11021],"thread-11020":["thread",11020],"thread-11018":["thread",11018],"thread-11017":["thread",11017],"thread-11016":["thread",11016],"thread-11015":["thread",11015],"thread-11012":["thread",11012],"thread-11011":["thread",11011],"thread-11008":["thread",11008],"thread-11007":["thread",11007],"thread-11006":["thread",11006],"thread-11004":["thread",11004],"thread-11002":["thread",11002],"thread-11001":["thread",11001],"thread-11000":["thread",11000],"thread-10999":["thread",10999],"thread-10997":["thread",10997],"thread-10996":["thread",10996],"thread-10995":["thread",10995],"thread-10994":["thread",10994],"thread-10992":["thread",10992],"thread-10990":["thread",10990],"thread-10989":["thread",10989],"thread-10988":["thread",10988],"thread-10987":["thread",10987],"thread-10986":["thread",10986],"thread-10985":["thread",10985],"thread-10984":["thread",10984],"thread-10982":["thread",10982],"thread-10981":["thread",10981],"thread-10980":["thread",10980],"thread-10979":["thread",10979],"thread-10978":["thread",10978],"thread-10976":["thread",10976],"thread-10975":["thread",10975],"thread-10974":["thread",10974],"thread-10971":["thread",10971],"thread-10969":["thread",10969],"thread-10968":["thread",10968],"thread-10967":["thread",10967],"thread-10966":["thread",10966],"thread-10964":["thread",10964],"thread-10962":["thread",10962],"thread-10959":["thread",10959],"thread-10958":["thread",10958],"thread-10957":["thread",10957],"thread-10956":["thread",10956],"thread-10955":["thread",10955],"thread-10954":["thread",10954],"thread-10953":["thread",10953],"thread-10952":["thread",10952],"thread-10951":["thread",10951],"thread-10950":["thread",10950],"thread-10948":["thread",10948],"thread-10947":["thread",10947],"thread-10945":["thread",10945],"thread-10943":["thread",10943],"thread-10942":["thread",10942],"thread-10940":["thread",10940],"thread-10939":["thread",10939],"thread-10938":["thread",10938],"thread-10937":["thread",10937],"thread-10936":["thread",10936],"thread-10935":["thread",10935],"thread-10934":["thread",10934],"thread-10933":["thread",10933],"thread-10929":["thread",10929],"thread-10928":["thread",10928],"thread-10927":["thread",10927],"thread-10925":["thread",10925],"thread-10924":["thread",10924],"thread-10923":["thread",10923],"thread-10922":["thread",10922],"thread-10921":["thread",10921],"thread-10920":["thread",10920],"thread-10919":["thread",10919],"thread-10918":["thread",10918],"thread-10917":["thread",10917],"thread-10916":["thread",10916],"thread-10915":["thread",10915],"thread-10914":["thread",10914],"thread-10913":["thread",10913],"thread-10912":["thread",10912],"thread-10910":["thread",10910],"thread-10909":["thread",10909],"thread-10908":["thread",10908],"thread-10907":["thread",10907],"thread-10906":["thread",10906],"thread-10905":["thread",10905],"thread-10904":["thread",10904],"thread-10903":["thread",10903],"thread-10902":["thread",10902],"thread-10901":["thread",10901],"thread-10900":["thread",10900],"thread-10899":["thread",10899],"thread-10898":["thread",10898],"thread-10897":["thread",10897],"thread-10896":["thread",10896],"thread-10895":["thread",10895],"thread-10894":["thread",10894],"thread-10893":["thread",10893],"thread-10892":["thread",10892],"thread-10891":["thread",10891],"thread-10890":["thread",10890],"thread-10889":["thread",10889],"thread-10887":["thread",10887],"thread-10885":["thread",10885],"thread-10884":["thread",10884],"thread-10883":["thread",10883],"thread-10882":["thread",10882],"thread-10881":["thread",10881],"thread-10880":["thread",10880],"thread-10879":["thread",10879],"thread-10878":["thread",10878],"thread-10877":["thread",10877],"thread-10876":["thread",10876],"thread-10875":["thread",10875],"thread-10874":["thread",10874],"thread-10873":["thread",10873],"thread-10872":["thread",10872],"thread-10871":["thread",10871],"thread-10870":["thread",10870],"thread-10869":["thread",10869],"thread-10868":["thread",10868],"thread-10867":["thread",10867],"thread-10865":["thread",10865],"thread-10864":["thread",10864],"thread-10863":["thread",10863],"thread-10862":["thread",10862],"thread-10861":["thread",10861],"thread-10860":["thread",10860],"thread-10859":["thread",10859],"thread-10858":["thread",10858],"thread-10857":["thread",10857],"thread-10856":["thread",10856],"thread-10855":["thread",10855],"thread-10854":["thread",10854],"thread-10853":["thread",10853],"thread-10852":["thread",10852],"thread-10851":["thread",10851],"thread-10849":["thread",10849],"thread-10848":["thread",10848],"thread-10847":["thread",10847],"thread-10846":["thread",10846],"thread-10844":["thread",10844],"thread-10843":["thread",10843],"thread-10841":["thread",10841],"thread-10838":["thread",10838],"thread-10837":["thread",10837],"thread-10836":["thread",10836],"thread-10835":["thread",10835],"thread-10834":["thread",10834],"thread-10833":["thread",10833],"thread-10832":["thread",10832],"thread-10830":["thread",10830],"thread-10829":["thread",10829],"thread-10827":["thread",10827],"thread-10826":["thread",10826],"thread-10825":["thread",10825],"thread-10824":["thread",10824],"thread-10823":["thread",10823],"thread-10822":["thread",10822],"thread-10821":["thread",10821],"thread-10820":["thread",10820],"thread-10819":["thread",10819],"thread-10818":["thread",10818],"thread-10816":["thread",10816],"thread-10815":["thread",10815],"thread-10814":["thread",10814],"thread-10813":["thread",10813],"thread-10812":["thread",10812]}, , 1715635485
Run Time: 0.000625
- 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