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 (39375, 35978, 35977, 35976, 35975, 35974, 35973, 35972, 35970, 35967, 35965, 35961, 35960, 35959, 35958, 27977, 27976, 27975, 27974, 27973, 27972, 27971, 27970, 27969, 27968, 27967, 27966, 27965, 27964, 27963, 27962, 27961, 27960, 27959, 27958, 27957, 27956, 27955, 27954, 27953, 27952, 27951, 27950, 27949, 27948, 27947, 27946, 27945, 27944, 27943, 27942, 27941, 27940, 27939, 27938, 27936, 27935, 27934, 27933, 27932, 27931, 27930, 27929, 27928, 27927, 27926, 27925, 27924, 27923, 27922, 27921, 27920, 27919, 27918, 27917, 27916, 27915, 27914, 27913, 27912, 27911, 27910, 27909, 27908, 27907, 27906, 27905, 27904, 27903, 27902, 27901, 27900, 27899, 27898, 27897, 27896, 27895, 27894, 27893, 27892, 27891, 27890, 27889, 27888, 27887, 27885, 27884, 27883, 27882, 27881, 27880, 27879, 27878, 27877, 27876, 27875, 27874, 27873, 27872, 27871, 27870, 27869, 27868, 27867, 27866, 27865, 27864, 27863, 27862, 27861, 27860, 27859, 27858, 27857, 27856, 27855, 27854, 27853, 27852, 27851, 27849, 27847, 27846, 27845, 27844, 27843, 27842, 27841, 27840, 27839, 27838, 27837, 27836, 27835, 27834, 27833, 27832, 27831, 27830, 27829, 27828, 27827, 27826, 27825, 27824, 27823, 27822, 27821, 27820, 27819, 27818, 27817, 27816, 27815, 27814, 27813, 27812, 27811, 27810, 27809, 27808, 27807, 27806, 27805, 27804, 27803, 27802, 27801, 27800, 27799, 27798, 27797, 27796, 27795, 27794, 27793, 27792, 27791, 27790, 27789))
Run Time: 0.010252
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: 5765, 0, 1715642837, {"thread-39375":["thread",39375],"thread-35978":["thread",35978],"thread-35977":["thread",35977],"thread-35976":["thread",35976],"thread-35975":["thread",35975],"thread-35974":["thread",35974],"thread-35973":["thread",35973],"thread-35972":["thread",35972],"thread-35970":["thread",35970],"thread-35967":["thread",35967],"thread-35965":["thread",35965],"thread-35961":["thread",35961],"thread-35960":["thread",35960],"thread-35959":["thread",35959],"thread-35958":["thread",35958],"thread-27977":["thread",27977],"thread-27976":["thread",27976],"thread-27975":["thread",27975],"thread-27974":["thread",27974],"thread-27973":["thread",27973],"thread-27972":["thread",27972],"thread-27971":["thread",27971],"thread-27970":["thread",27970],"thread-27969":["thread",27969],"thread-27968":["thread",27968],"thread-27967":["thread",27967],"thread-27966":["thread",27966],"thread-27965":["thread",27965],"thread-27964":["thread",27964],"thread-27963":["thread",27963],"thread-27962":["thread",27962],"thread-27961":["thread",27961],"thread-27960":["thread",27960],"thread-27959":["thread",27959],"thread-27958":["thread",27958],"thread-27957":["thread",27957],"thread-27956":["thread",27956],"thread-27955":["thread",27955],"thread-27954":["thread",27954],"thread-27953":["thread",27953],"thread-27952":["thread",27952],"thread-27951":["thread",27951],"thread-27950":["thread",27950],"thread-27949":["thread",27949],"thread-27948":["thread",27948],"thread-27947":["thread",27947],"thread-27946":["thread",27946],"thread-27945":["thread",27945],"thread-27944":["thread",27944],"thread-27943":["thread",27943],"thread-27942":["thread",27942],"thread-27941":["thread",27941],"thread-27940":["thread",27940],"thread-27939":["thread",27939],"thread-27938":["thread",27938],"thread-27936":["thread",27936],"thread-27935":["thread",27935],"thread-27934":["thread",27934],"thread-27933":["thread",27933],"thread-27932":["thread",27932],"thread-27931":["thread",27931],"thread-27930":["thread",27930],"thread-27929":["thread",27929],"thread-27928":["thread",27928],"thread-27927":["thread",27927],"thread-27926":["thread",27926],"thread-27925":["thread",27925],"thread-27924":["thread",27924],"thread-27923":["thread",27923],"thread-27922":["thread",27922],"thread-27921":["thread",27921],"thread-27920":["thread",27920],"thread-27919":["thread",27919],"thread-27918":["thread",27918],"thread-27917":["thread",27917],"thread-27916":["thread",27916],"thread-27915":["thread",27915],"thread-27914":["thread",27914],"thread-27913":["thread",27913],"thread-27912":["thread",27912],"thread-27911":["thread",27911],"thread-27910":["thread",27910],"thread-27909":["thread",27909],"thread-27908":["thread",27908],"thread-27907":["thread",27907],"thread-27906":["thread",27906],"thread-27905":["thread",27905],"thread-27904":["thread",27904],"thread-27903":["thread",27903],"thread-27902":["thread",27902],"thread-27901":["thread",27901],"thread-27900":["thread",27900],"thread-27899":["thread",27899],"thread-27898":["thread",27898],"thread-27897":["thread",27897],"thread-27896":["thread",27896],"thread-27895":["thread",27895],"thread-27894":["thread",27894],"thread-27893":["thread",27893],"thread-27892":["thread",27892],"thread-27891":["thread",27891],"thread-27890":["thread",27890],"thread-27889":["thread",27889],"thread-27888":["thread",27888],"thread-27887":["thread",27887],"thread-27885":["thread",27885],"thread-27884":["thread",27884],"thread-27883":["thread",27883],"thread-27882":["thread",27882],"thread-27881":["thread",27881],"thread-27880":["thread",27880],"thread-27879":["thread",27879],"thread-27878":["thread",27878],"thread-27877":["thread",27877],"thread-27876":["thread",27876],"thread-27875":["thread",27875],"thread-27874":["thread",27874],"thread-27873":["thread",27873],"thread-27872":["thread",27872],"thread-27871":["thread",27871],"thread-27870":["thread",27870],"thread-27869":["thread",27869],"thread-27868":["thread",27868],"thread-27867":["thread",27867],"thread-27866":["thread",27866],"thread-27865":["thread",27865],"thread-27864":["thread",27864],"thread-27863":["thread",27863],"thread-27862":["thread",27862],"thread-27861":["thread",27861],"thread-27860":["thread",27860],"thread-27859":["thread",27859],"thread-27858":["thread",27858],"thread-27857":["thread",27857],"thread-27856":["thread",27856],"thread-27855":["thread",27855],"thread-27854":["thread",27854],"thread-27853":["thread",27853],"thread-27852":["thread",27852],"thread-27851":["thread",27851],"thread-27849":["thread",27849],"thread-27847":["thread",27847],"thread-27846":["thread",27846],"thread-27845":["thread",27845],"thread-27844":["thread",27844],"thread-27843":["thread",27843],"thread-27842":["thread",27842],"thread-27841":["thread",27841],"thread-27840":["thread",27840],"thread-27839":["thread",27839],"thread-27838":["thread",27838],"thread-27837":["thread",27837],"thread-27836":["thread",27836],"thread-27835":["thread",27835],"thread-27834":["thread",27834],"thread-27833":["thread",27833],"thread-27832":["thread",27832],"thread-27831":["thread",27831],"thread-27830":["thread",27830],"thread-27829":["thread",27829],"thread-27828":["thread",27828],"thread-27827":["thread",27827],"thread-27826":["thread",27826],"thread-27825":["thread",27825],"thread-27824":["thread",27824],"thread-27823":["thread",27823],"thread-27822":["thread",27822],"thread-27821":["thread",27821],"thread-27820":["thread",27820],"thread-27819":["thread",27819],"thread-27818":["thread",27818],"thread-27817":["thread",27817],"thread-27816":["thread",27816],"thread-27815":["thread",27815],"thread-27814":["thread",27814],"thread-27813":["thread",27813],"thread-27812":["thread",27812],"thread-27811":["thread",27811],"thread-27810":["thread",27810],"thread-27809":["thread",27809],"thread-27808":["thread",27808],"thread-27807":["thread",27807],"thread-27806":["thread",27806],"thread-27805":["thread",27805],"thread-27804":["thread",27804],"thread-27803":["thread",27803],"thread-27802":["thread",27802],"thread-27801":["thread",27801],"thread-27800":["thread",27800],"thread-27799":["thread",27799],"thread-27798":["thread",27798],"thread-27797":["thread",27797],"thread-27796":["thread",27796],"thread-27795":["thread",27795],"thread-27794":["thread",27794],"thread-27793":["thread",27793],"thread-27792":["thread",27792],"thread-27791":["thread",27791],"thread-27790":["thread",27790],"thread-27789":["thread",27789]}, , 1715639237
Run Time: 0.000683
- 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