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 (35957, 35956, 35955, 35954, 35953, 35952, 35951, 35950, 35949, 35948, 35947, 35946, 35945, 35944, 35943, 35942, 35941, 35940, 35939, 35938, 35937, 35936, 35935, 35934, 35933, 35932, 35931, 35930, 35929, 35928, 35927, 35926, 35925, 35924, 35923, 35922, 35921, 35920, 35919, 35918, 35917, 35916, 35915, 35914, 35913, 35912, 35911, 35910, 35909, 35908, 35907, 35906, 35905, 35904, 35903, 35902, 35901, 35900, 35899, 35898, 35897, 35896, 35895, 35894, 35893, 35892, 35891, 35890, 35889, 35888, 35887, 35886, 35885, 35884, 35883, 35882, 35881, 35880, 35879, 35878, 35877, 35876, 35875, 35874, 35873, 35872, 35871, 35870, 35869, 35868, 35867, 35866, 35865, 35864, 35863, 35862, 35861, 35860, 35859, 35858, 35857, 35856, 35855, 35854, 35853, 35852, 35851, 35850, 35849, 35848, 35847, 35846, 35845, 35844, 35843, 35842, 35841, 35840, 35839, 35838, 35837, 35836, 35835, 35834, 35833, 35832, 35831, 35830, 35829, 35828, 35827, 35826, 35825, 35824, 35823, 35822, 35821, 35820, 35819, 35818, 35817, 35816, 35815, 35814, 35813, 35812, 35811, 35810, 35809, 35808, 35807, 35806, 35805, 35804, 35803, 35802, 35801, 35800, 35799, 35798, 35797, 35796, 35795, 35794, 35793, 35792, 35791, 35790, 35789, 35788, 35787, 35786, 35785, 35784, 35783, 35782, 35781, 35780, 35779, 35778, 35777, 35776, 35775))
Run Time: 0.008073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 183 | 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: 5943, 0, 1716093776, {"thread-35957":["thread",35957],"thread-35956":["thread",35956],"thread-35955":["thread",35955],"thread-35954":["thread",35954],"thread-35953":["thread",35953],"thread-35952":["thread",35952],"thread-35951":["thread",35951],"thread-35950":["thread",35950],"thread-35949":["thread",35949],"thread-35948":["thread",35948],"thread-35947":["thread",35947],"thread-35946":["thread",35946],"thread-35945":["thread",35945],"thread-35944":["thread",35944],"thread-35943":["thread",35943],"thread-35942":["thread",35942],"thread-35941":["thread",35941],"thread-35940":["thread",35940],"thread-35939":["thread",35939],"thread-35938":["thread",35938],"thread-35937":["thread",35937],"thread-35936":["thread",35936],"thread-35935":["thread",35935],"thread-35934":["thread",35934],"thread-35933":["thread",35933],"thread-35932":["thread",35932],"thread-35931":["thread",35931],"thread-35930":["thread",35930],"thread-35929":["thread",35929],"thread-35928":["thread",35928],"thread-35927":["thread",35927],"thread-35926":["thread",35926],"thread-35925":["thread",35925],"thread-35924":["thread",35924],"thread-35923":["thread",35923],"thread-35922":["thread",35922],"thread-35921":["thread",35921],"thread-35920":["thread",35920],"thread-35919":["thread",35919],"thread-35918":["thread",35918],"thread-35917":["thread",35917],"thread-35916":["thread",35916],"thread-35915":["thread",35915],"thread-35914":["thread",35914],"thread-35913":["thread",35913],"thread-35912":["thread",35912],"thread-35911":["thread",35911],"thread-35910":["thread",35910],"thread-35909":["thread",35909],"thread-35908":["thread",35908],"thread-35907":["thread",35907],"thread-35906":["thread",35906],"thread-35905":["thread",35905],"thread-35904":["thread",35904],"thread-35903":["thread",35903],"thread-35902":["thread",35902],"thread-35901":["thread",35901],"thread-35900":["thread",35900],"thread-35899":["thread",35899],"thread-35898":["thread",35898],"thread-35897":["thread",35897],"thread-35896":["thread",35896],"thread-35895":["thread",35895],"thread-35894":["thread",35894],"thread-35893":["thread",35893],"thread-35892":["thread",35892],"thread-35891":["thread",35891],"thread-35890":["thread",35890],"thread-35889":["thread",35889],"thread-35888":["thread",35888],"thread-35887":["thread",35887],"thread-35886":["thread",35886],"thread-35885":["thread",35885],"thread-35884":["thread",35884],"thread-35883":["thread",35883],"thread-35882":["thread",35882],"thread-35881":["thread",35881],"thread-35880":["thread",35880],"thread-35879":["thread",35879],"thread-35878":["thread",35878],"thread-35877":["thread",35877],"thread-35876":["thread",35876],"thread-35875":["thread",35875],"thread-35874":["thread",35874],"thread-35873":["thread",35873],"thread-35872":["thread",35872],"thread-35871":["thread",35871],"thread-35870":["thread",35870],"thread-35869":["thread",35869],"thread-35868":["thread",35868],"thread-35867":["thread",35867],"thread-35866":["thread",35866],"thread-35865":["thread",35865],"thread-35864":["thread",35864],"thread-35863":["thread",35863],"thread-35862":["thread",35862],"thread-35861":["thread",35861],"thread-35860":["thread",35860],"thread-35859":["thread",35859],"thread-35858":["thread",35858],"thread-35857":["thread",35857],"thread-35856":["thread",35856],"thread-35855":["thread",35855],"thread-35854":["thread",35854],"thread-35853":["thread",35853],"thread-35852":["thread",35852],"thread-35851":["thread",35851],"thread-35850":["thread",35850],"thread-35849":["thread",35849],"thread-35848":["thread",35848],"thread-35847":["thread",35847],"thread-35846":["thread",35846],"thread-35845":["thread",35845],"thread-35844":["thread",35844],"thread-35843":["thread",35843],"thread-35842":["thread",35842],"thread-35841":["thread",35841],"thread-35840":["thread",35840],"thread-35839":["thread",35839],"thread-35838":["thread",35838],"thread-35837":["thread",35837],"thread-35836":["thread",35836],"thread-35835":["thread",35835],"thread-35834":["thread",35834],"thread-35833":["thread",35833],"thread-35832":["thread",35832],"thread-35831":["thread",35831],"thread-35830":["thread",35830],"thread-35829":["thread",35829],"thread-35828":["thread",35828],"thread-35827":["thread",35827],"thread-35826":["thread",35826],"thread-35825":["thread",35825],"thread-35824":["thread",35824],"thread-35823":["thread",35823],"thread-35822":["thread",35822],"thread-35821":["thread",35821],"thread-35820":["thread",35820],"thread-35819":["thread",35819],"thread-35818":["thread",35818],"thread-35817":["thread",35817],"thread-35816":["thread",35816],"thread-35815":["thread",35815],"thread-35814":["thread",35814],"thread-35813":["thread",35813],"thread-35812":["thread",35812],"thread-35811":["thread",35811],"thread-35810":["thread",35810],"thread-35809":["thread",35809],"thread-35808":["thread",35808],"thread-35807":["thread",35807],"thread-35806":["thread",35806],"thread-35805":["thread",35805],"thread-35804":["thread",35804],"thread-35803":["thread",35803],"thread-35802":["thread",35802],"thread-35801":["thread",35801],"thread-35800":["thread",35800],"thread-35799":["thread",35799],"thread-35798":["thread",35798],"thread-35797":["thread",35797],"thread-35796":["thread",35796],"thread-35795":["thread",35795],"thread-35794":["thread",35794],"thread-35793":["thread",35793],"thread-35792":["thread",35792],"thread-35791":["thread",35791],"thread-35790":["thread",35790],"thread-35789":["thread",35789],"thread-35788":["thread",35788],"thread-35787":["thread",35787],"thread-35786":["thread",35786],"thread-35785":["thread",35785],"thread-35784":["thread",35784],"thread-35783":["thread",35783],"thread-35782":["thread",35782],"thread-35781":["thread",35781],"thread-35780":["thread",35780],"thread-35779":["thread",35779],"thread-35778":["thread",35778],"thread-35777":["thread",35777],"thread-35776":["thread",35776],"thread-35775":["thread",35775]}, , 1716090176
Run Time: 0.001112
- 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