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 (39921, 33001, 33000, 32998, 32997, 32996, 32995, 32994, 32993, 32992, 32991, 32988, 32986, 32985, 32984, 32983, 32982, 32981, 32980, 32979, 32978, 32977, 32976, 32975, 32974, 32973, 32972, 32971, 32970, 32969, 32968, 32967, 32966, 32965, 32964, 32963, 32962, 32961, 32960, 32959, 32958, 32957, 32956, 32955, 32954, 32953, 32952, 32951, 32950, 32949, 32948, 32947, 32946, 32945, 32944, 32943, 32942, 32941, 32940, 32939, 32938, 32937, 32936, 32935, 32934, 32933, 32932, 32931, 32930, 32929, 32927, 32925, 32924, 32923, 32922, 32921, 32920, 32919, 32918, 32917, 32916, 32915, 32914, 32913, 32912, 32911, 32910, 32909, 32908, 32907, 32906, 32905, 32904, 32903, 32902, 32901, 32900, 32899, 32898, 32897, 32896, 32895, 32894, 32893, 32892, 32891, 32890, 32889, 32888, 32887, 32886, 32885, 32883, 32882, 32881, 32880, 32878, 32877, 32876, 32875, 32874, 32873, 32871, 32870, 32869, 32868, 32867, 32866, 32865, 32864, 32863, 32862, 32861, 32860, 32859, 32858, 32857, 32856, 32854, 32853, 32852, 32851, 32850, 32848, 32847, 32846, 32845, 32844, 32843, 32842, 32841, 32840, 32839, 32838, 32837, 32835, 32834, 32833, 32832, 32831, 32830, 32829, 32828, 32827, 32826, 32823, 32822, 32821, 32820, 32819, 32818, 32817, 32816, 32815, 32814, 32813, 32812, 32811, 32810, 32809, 32808, 32807, 32806, 32804, 32803, 32802, 32801, 32800, 32798, 32797, 32796, 32795, 32794, 32793, 32792, 32791, 32790, 32789, 32788, 32787))
Run Time: 0.025536
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: 823, 0, 1715688901, {"thread-39921":["thread",39921],"thread-33001":["thread",33001],"thread-33000":["thread",33000],"thread-32998":["thread",32998],"thread-32997":["thread",32997],"thread-32996":["thread",32996],"thread-32995":["thread",32995],"thread-32994":["thread",32994],"thread-32993":["thread",32993],"thread-32992":["thread",32992],"thread-32991":["thread",32991],"thread-32988":["thread",32988],"thread-32986":["thread",32986],"thread-32985":["thread",32985],"thread-32984":["thread",32984],"thread-32983":["thread",32983],"thread-32982":["thread",32982],"thread-32981":["thread",32981],"thread-32980":["thread",32980],"thread-32979":["thread",32979],"thread-32978":["thread",32978],"thread-32977":["thread",32977],"thread-32976":["thread",32976],"thread-32975":["thread",32975],"thread-32974":["thread",32974],"thread-32973":["thread",32973],"thread-32972":["thread",32972],"thread-32971":["thread",32971],"thread-32970":["thread",32970],"thread-32969":["thread",32969],"thread-32968":["thread",32968],"thread-32967":["thread",32967],"thread-32966":["thread",32966],"thread-32965":["thread",32965],"thread-32964":["thread",32964],"thread-32963":["thread",32963],"thread-32962":["thread",32962],"thread-32961":["thread",32961],"thread-32960":["thread",32960],"thread-32959":["thread",32959],"thread-32958":["thread",32958],"thread-32957":["thread",32957],"thread-32956":["thread",32956],"thread-32955":["thread",32955],"thread-32954":["thread",32954],"thread-32953":["thread",32953],"thread-32952":["thread",32952],"thread-32951":["thread",32951],"thread-32950":["thread",32950],"thread-32949":["thread",32949],"thread-32948":["thread",32948],"thread-32947":["thread",32947],"thread-32946":["thread",32946],"thread-32945":["thread",32945],"thread-32944":["thread",32944],"thread-32943":["thread",32943],"thread-32942":["thread",32942],"thread-32941":["thread",32941],"thread-32940":["thread",32940],"thread-32939":["thread",32939],"thread-32938":["thread",32938],"thread-32937":["thread",32937],"thread-32936":["thread",32936],"thread-32935":["thread",32935],"thread-32934":["thread",32934],"thread-32933":["thread",32933],"thread-32932":["thread",32932],"thread-32931":["thread",32931],"thread-32930":["thread",32930],"thread-32929":["thread",32929],"thread-32927":["thread",32927],"thread-32925":["thread",32925],"thread-32924":["thread",32924],"thread-32923":["thread",32923],"thread-32922":["thread",32922],"thread-32921":["thread",32921],"thread-32920":["thread",32920],"thread-32919":["thread",32919],"thread-32918":["thread",32918],"thread-32917":["thread",32917],"thread-32916":["thread",32916],"thread-32915":["thread",32915],"thread-32914":["thread",32914],"thread-32913":["thread",32913],"thread-32912":["thread",32912],"thread-32911":["thread",32911],"thread-32910":["thread",32910],"thread-32909":["thread",32909],"thread-32908":["thread",32908],"thread-32907":["thread",32907],"thread-32906":["thread",32906],"thread-32905":["thread",32905],"thread-32904":["thread",32904],"thread-32903":["thread",32903],"thread-32902":["thread",32902],"thread-32901":["thread",32901],"thread-32900":["thread",32900],"thread-32899":["thread",32899],"thread-32898":["thread",32898],"thread-32897":["thread",32897],"thread-32896":["thread",32896],"thread-32895":["thread",32895],"thread-32894":["thread",32894],"thread-32893":["thread",32893],"thread-32892":["thread",32892],"thread-32891":["thread",32891],"thread-32890":["thread",32890],"thread-32889":["thread",32889],"thread-32888":["thread",32888],"thread-32887":["thread",32887],"thread-32886":["thread",32886],"thread-32885":["thread",32885],"thread-32883":["thread",32883],"thread-32882":["thread",32882],"thread-32881":["thread",32881],"thread-32880":["thread",32880],"thread-32878":["thread",32878],"thread-32877":["thread",32877],"thread-32876":["thread",32876],"thread-32875":["thread",32875],"thread-32874":["thread",32874],"thread-32873":["thread",32873],"thread-32871":["thread",32871],"thread-32870":["thread",32870],"thread-32869":["thread",32869],"thread-32868":["thread",32868],"thread-32867":["thread",32867],"thread-32866":["thread",32866],"thread-32865":["thread",32865],"thread-32864":["thread",32864],"thread-32863":["thread",32863],"thread-32862":["thread",32862],"thread-32861":["thread",32861],"thread-32860":["thread",32860],"thread-32859":["thread",32859],"thread-32858":["thread",32858],"thread-32857":["thread",32857],"thread-32856":["thread",32856],"thread-32854":["thread",32854],"thread-32853":["thread",32853],"thread-32852":["thread",32852],"thread-32851":["thread",32851],"thread-32850":["thread",32850],"thread-32848":["thread",32848],"thread-32847":["thread",32847],"thread-32846":["thread",32846],"thread-32845":["thread",32845],"thread-32844":["thread",32844],"thread-32843":["thread",32843],"thread-32842":["thread",32842],"thread-32841":["thread",32841],"thread-32840":["thread",32840],"thread-32839":["thread",32839],"thread-32838":["thread",32838],"thread-32837":["thread",32837],"thread-32835":["thread",32835],"thread-32834":["thread",32834],"thread-32833":["thread",32833],"thread-32832":["thread",32832],"thread-32831":["thread",32831],"thread-32830":["thread",32830],"thread-32829":["thread",32829],"thread-32828":["thread",32828],"thread-32827":["thread",32827],"thread-32826":["thread",32826],"thread-32823":["thread",32823],"thread-32822":["thread",32822],"thread-32821":["thread",32821],"thread-32820":["thread",32820],"thread-32819":["thread",32819],"thread-32818":["thread",32818],"thread-32817":["thread",32817],"thread-32816":["thread",32816],"thread-32815":["thread",32815],"thread-32814":["thread",32814],"thread-32813":["thread",32813],"thread-32812":["thread",32812],"thread-32811":["thread",32811],"thread-32810":["thread",32810],"thread-32809":["thread",32809],"thread-32808":["thread",32808],"thread-32807":["thread",32807],"thread-32806":["thread",32806],"thread-32804":["thread",32804],"thread-32803":["thread",32803],"thread-32802":["thread",32802],"thread-32801":["thread",32801],"thread-32800":["thread",32800],"thread-32798":["thread",32798],"thread-32797":["thread",32797],"thread-32796":["thread",32796],"thread-32795":["thread",32795],"thread-32794":["thread",32794],"thread-32793":["thread",32793],"thread-32792":["thread",32792],"thread-32791":["thread",32791],"thread-32790":["thread",32790],"thread-32789":["thread",32789],"thread-32788":["thread",32788],"thread-32787":["thread",32787]}, , 1715685301
Run Time: 0.000323
- 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