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 (183597, 183443, 183410, 179751, 179058, 179012, 178530, 177428, 177375, 176960, 176923, 176833, 176781, 176226, 176191, 175983, 175738, 175734, 175417, 174939, 174933, 174874, 174809, 174804, 174611, 174373, 173922, 173893, 173856, 173706, 173648, 173578, 173414, 173413, 173412, 173374, 173179, 173178, 173176, 172870, 172751, 172510, 172460, 172403, 172251, 172020, 171929, 171819, 171441, 171151, 171041, 170256, 170254, 169800, 169752, 169493, 169331, 169209, 169146, 169039, 169035, 168825, 168746, 168588, 168539, 168516, 168369, 168194, 168135, 168007, 167585, 167468, 167327, 167279, 167248, 166902, 166833, 166621, 166111, 165179, 165152, 165136, 165123, 165121, 164952, 164942, 164634, 163807, 163579, 163513, 163302, 163272, 163254, 162534, 162399, 162299, 162277, 162200, 162175, 162031, 161974, 161904, 161835, 161829, 161711, 161641, 161412, 161368, 161341, 161249, 161246, 161179, 161175, 161136, 161126, 161110, 160861, 160860, 160831, 160666, 160624, 160478, 160355, 160346, 160206, 160120, 160093, 160083, 160046, 160042, 159905, 159885, 159673, 158504, 158493, 158378, 158331, 158086, 157880, 157817, 157765, 157362, 155549, 155380, 154891, 154866, 154394, 153855, 153674, 153083, 153066, 152339, 152296, 151765, 151763, 150992, 150655, 150359, 150236, 150151, 149839, 149124, 148768, 147950, 147666, 146215, 146210, 145810, 145451, 144732, 144263, 141825, 141069, 140925, 140248, 137859, 136303, 135762, 128385, 128361, 122755, 109918, 109066, 107828, 107436, 107130, 105647, 103362, 73490, 71349, 71343))
Run Time: 0.097502
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 191 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 812072
Params: 1716083719, {"thread-183597":["thread",183597],"thread-183443":["thread",183443],"thread-183410":["thread",183410],"thread-179751":["thread",179751],"thread-179058":["thread",179058],"thread-179012":["thread",179012],"thread-178530":["thread",178530],"thread-177428":["thread",177428],"thread-177375":["thread",177375],"thread-176960":["thread",176960],"thread-176923":["thread",176923],"thread-176833":["thread",176833],"thread-176781":["thread",176781],"thread-176226":["thread",176226],"thread-176191":["thread",176191],"thread-175983":["thread",175983],"thread-175738":["thread",175738],"thread-175734":["thread",175734],"thread-175417":["thread",175417],"thread-174939":["thread",174939],"thread-174933":["thread",174933],"thread-174874":["thread",174874],"thread-174809":["thread",174809],"thread-174804":["thread",174804],"thread-174611":["thread",174611],"thread-174373":["thread",174373],"thread-173922":["thread",173922],"thread-173893":["thread",173893],"thread-173856":["thread",173856],"thread-173706":["thread",173706],"thread-173648":["thread",173648],"thread-173578":["thread",173578],"thread-173414":["thread",173414],"thread-173413":["thread",173413],"thread-173412":["thread",173412],"thread-173374":["thread",173374],"thread-173179":["thread",173179],"thread-173178":["thread",173178],"thread-173176":["thread",173176],"thread-172870":["thread",172870],"thread-172751":["thread",172751],"thread-172510":["thread",172510],"thread-172460":["thread",172460],"thread-172403":["thread",172403],"thread-172251":["thread",172251],"ams_article-4896":["ams_article",4896],"thread-172020":["thread",172020],"thread-171929":["thread",171929],"thread-171819":["thread",171819],"ams_article-4875":["ams_article",4875],"tl_group-274":["tl_group",274],"thread-171441":["thread",171441],"thread-171151":["thread",171151],"thread-171041":["thread",171041],"thread-170256":["thread",170256],"thread-170254":["thread",170254],"thread-169800":["thread",169800],"thread-169752":["thread",169752],"thread-169493":["thread",169493],"thread-169331":["thread",169331],"thread-169209":["thread",169209],"thread-169146":["thread",169146],"thread-169039":["thread",169039],"thread-169035":["thread",169035],"thread-168825":["thread",168825],"thread-168746":["thread",168746],"thread-168588":["thread",168588],"thread-168539":["thread",168539],"thread-168516":["thread",168516],"thread-168369":["thread",168369],"thread-168194":["thread",168194],"thread-168135":["thread",168135],"thread-168007":["thread",168007],"thread-167585":["thread",167585],"thread-167468":["thread",167468],"thread-167327":["thread",167327],"thread-167279":["thread",167279],"thread-167248":["thread",167248],"thread-166902":["thread",166902],"thread-166833":["thread",166833],"thread-166621":["thread",166621],"thread-166111":["thread",166111],"thread-165179":["thread",165179],"thread-165152":["thread",165152],"thread-165136":["thread",165136],"thread-165123":["thread",165123],"thread-165121":["thread",165121],"thread-164952":["thread",164952],"thread-164942":["thread",164942],"thread-164634":["thread",164634],"thread-163807":["thread",163807],"thread-163579":["thread",163579],"thread-163513":["thread",163513],"thread-163302":["thread",163302],"thread-163272":["thread",163272],"thread-163254":["thread",163254],"thread-162534":["thread",162534],"thread-162399":["thread",162399],"thread-162299":["thread",162299],"thread-162277":["thread",162277],"thread-162200":["thread",162200],"thread-162175":["thread",162175],"thread-162031":["thread",162031],"thread-161974":["thread",161974],"ams_article-4472":["ams_article",4472],"thread-161904":["thread",161904],"thread-161835":["thread",161835],"thread-161829":["thread",161829],"thread-161711":["thread",161711],"thread-161641":["thread",161641],"thread-161412":["thread",161412],"ams_article-4452":["ams_article",4452],"thread-161368":["thread",161368],"thread-161341":["thread",161341],"thread-161249":["thread",161249],"thread-161246":["thread",161246],"thread-161179":["thread",161179],"thread-161175":["thread",161175],"thread-161136":["thread",161136],"thread-161126":["thread",161126],"thread-161110":["thread",161110],"thread-160861":["thread",160861],"thread-160860":["thread",160860],"thread-160831":["thread",160831],"thread-160666":["thread",160666],"thread-160624":["thread",160624],"ams_article-4436":["ams_article",4436],"thread-160478":["thread",160478],"thread-160355":["thread",160355],"thread-160346":["thread",160346],"thread-160206":["thread",160206],"thread-160120":["thread",160120],"thread-160093":["thread",160093],"thread-160083":["thread",160083],"thread-160046":["thread",160046],"thread-159905":["thread",159905],"thread-159885":["thread",159885],"thread-159673":["thread",159673],"thread-158504":["thread",158504],"thread-158493":["thread",158493],"thread-158378":["thread",158378],"thread-158331":["thread",158331],"thread-158086":["thread",158086],"thread-157880":["thread",157880],"thread-157817":["thread",157817],"thread-157765":["thread",157765],"thread-157362":["thread",157362],"thread-155549":["thread",155549],"thread-155380":["thread",155380],"thread-154891":["thread",154891],"thread-154866":["thread",154866],"thread-154394":["thread",154394],"thread-153855":["thread",153855],"thread-153674":["thread",153674],"thread-153083":["thread",153083],"thread-153066":["thread",153066],"thread-152339":["thread",152339],"thread-152296":["thread",152296],"thread-151765":["thread",151765],"thread-151763":["thread",151763],"thread-150992":["thread",150992],"thread-150655":["thread",150655],"thread-150359":["thread",150359],"thread-150236":["thread",150236],"thread-150151":["thread",150151],"thread-149839":["thread",149839],"thread-149124":["thread",149124],"thread-148768":["thread",148768],"thread-147950":["thread",147950],"thread-147666":["thread",147666],"thread-146215":["thread",146215],"thread-146210":["thread",146210],"thread-145810":["thread",145810],"thread-145451":["thread",145451],"thread-144732":["thread",144732],"thread-144263":["thread",144263],"thread-141825":["thread",141825],"thread-141069":["thread",141069],"thread-140925":["thread",140925],"thread-140248":["thread",140248],"thread-137859":["thread",137859],"thread-136303":["thread",136303],"thread-135762":["thread",135762],"thread-128385":["thread",128385],"thread-128361":["thread",128361],"thread-122755":["thread",122755],"thread-109918":["thread",109918],"thread-109066":["thread",109066],"thread-107828":["thread",107828],"thread-107436":["thread",107436],"thread-107130":["thread",107130],"thread-105647":["thread",105647],"thread-103362":["thread",103362],"thread-73490":["thread",73490],"thread-71349":["thread",71349],"thread-71343":["thread",71343]}
Run Time: 0.000292
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1519
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20