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 (219172, 218950, 218902, 217819, 217000, 213712, 212782, 212098, 211768, 211531, 210847, 210118, 209940, 208231, 207955, 206332, 205741, 205486, 205396, 205291, 203260, 202660, 200989, 198946, 198637, 197839, 196585, 194140, 193993, 193585, 191713, 191626, 190954, 186544, 185110, 184408, 184384, 183784, 183622, 182770, 179224, 177760, 176581, 176362, 175561, 175078, 174874, 174745, 174676, 173758, 172579, 170876, 170109, 169377, 168429, 166962, 166869, 166392, 165264, 164770, 164713, 163348, 162028, 160285, 158800, 157867, 154861, 154330, 153190, 152068, 150598, 150217, 147929, 145766, 143342, 141650, 140673, 140181, 139941, 136764, 134741, 134663, 134654, 133241, 132779, 131144, 131069, 130787, 130427, 130388, 128908, 128212, 128137, 128113, 128099, 128075, 127535, 127502, 127371, 126945, 125901, 124813, 124754, 123918, 122508, 122413, 122186, 121530, 120804, 119525, 119468, 119439, 119106, 118489, 117662, 117472, 117470, 117468, 116669, 115891, 114841, 113359, 111293, 111292, 110962, 110377, 109929, 108649, 106795, 102742, 102705, 101766, 100783, 100755, 99533, 99531, 99429, 99065, 98941, 98586, 96879, 96041, 95110, 95034, 94942, 94158, 93105, 93086, 91450, 91364))
Run Time: 0.005432
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 150 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 231, 0, 1715075990, {"thread-219172":["thread",219172],"thread-218950":["thread",218950],"thread-218902":["thread",218902],"thread-217819":["thread",217819],"thread-217000":["thread",217000],"thread-213712":["thread",213712],"thread-212782":["thread",212782],"thread-212098":["thread",212098],"thread-211768":["thread",211768],"thread-211531":["thread",211531],"thread-210847":["thread",210847],"thread-210118":["thread",210118],"thread-209940":["thread",209940],"thread-208231":["thread",208231],"thread-207955":["thread",207955],"thread-206332":["thread",206332],"thread-205741":["thread",205741],"thread-205486":["thread",205486],"thread-205396":["thread",205396],"thread-205291":["thread",205291],"thread-203260":["thread",203260],"thread-202660":["thread",202660],"thread-200989":["thread",200989],"thread-198946":["thread",198946],"thread-198637":["thread",198637],"thread-197839":["thread",197839],"thread-196585":["thread",196585],"thread-194140":["thread",194140],"thread-193993":["thread",193993],"thread-193585":["thread",193585],"thread-191713":["thread",191713],"thread-191626":["thread",191626],"thread-190954":["thread",190954],"thread-186544":["thread",186544],"thread-185110":["thread",185110],"thread-184408":["thread",184408],"thread-184384":["thread",184384],"thread-183784":["thread",183784],"thread-183622":["thread",183622],"thread-182770":["thread",182770],"thread-179224":["thread",179224],"thread-177760":["thread",177760],"thread-176581":["thread",176581],"thread-176362":["thread",176362],"thread-175561":["thread",175561],"thread-175078":["thread",175078],"thread-174874":["thread",174874],"thread-174745":["thread",174745],"thread-174676":["thread",174676],"thread-173758":["thread",173758],"thread-172579":["thread",172579],"thread-170876":["thread",170876],"thread-170109":["thread",170109],"thread-169377":["thread",169377],"thread-168429":["thread",168429],"thread-166962":["thread",166962],"thread-166869":["thread",166869],"thread-166392":["thread",166392],"thread-165264":["thread",165264],"thread-164770":["thread",164770],"thread-164713":["thread",164713],"thread-163348":["thread",163348],"thread-162028":["thread",162028],"thread-160285":["thread",160285],"thread-158800":["thread",158800],"thread-157867":["thread",157867],"thread-154861":["thread",154861],"thread-154330":["thread",154330],"thread-153190":["thread",153190],"thread-152068":["thread",152068],"thread-150598":["thread",150598],"thread-150217":["thread",150217],"thread-147929":["thread",147929],"thread-145766":["thread",145766],"thread-143342":["thread",143342],"thread-141650":["thread",141650],"thread-140673":["thread",140673],"thread-140181":["thread",140181],"thread-139941":["thread",139941],"thread-136764":["thread",136764],"thread-134741":["thread",134741],"thread-134663":["thread",134663],"thread-134654":["thread",134654],"thread-133241":["thread",133241],"thread-132779":["thread",132779],"thread-131144":["thread",131144],"thread-131069":["thread",131069],"thread-130787":["thread",130787],"thread-130427":["thread",130427],"thread-130388":["thread",130388],"thread-128908":["thread",128908],"thread-128212":["thread",128212],"thread-128137":["thread",128137],"thread-128113":["thread",128113],"thread-128099":["thread",128099],"thread-128075":["thread",128075],"thread-127535":["thread",127535],"thread-127502":["thread",127502],"thread-127371":["thread",127371],"thread-126945":["thread",126945],"thread-125901":["thread",125901],"thread-124813":["thread",124813],"thread-124754":["thread",124754],"thread-123918":["thread",123918],"thread-122508":["thread",122508],"thread-122413":["thread",122413],"thread-122186":["thread",122186],"thread-121530":["thread",121530],"thread-120804":["thread",120804],"thread-119525":["thread",119525],"thread-119468":["thread",119468],"thread-119439":["thread",119439],"thread-119106":["thread",119106],"thread-118489":["thread",118489],"thread-117662":["thread",117662],"thread-117472":["thread",117472],"thread-117470":["thread",117470],"thread-117468":["thread",117468],"thread-116669":["thread",116669],"thread-115891":["thread",115891],"thread-114841":["thread",114841],"thread-113359":["thread",113359],"thread-111293":["thread",111293],"thread-111292":["thread",111292],"thread-110962":["thread",110962],"thread-110377":["thread",110377],"thread-109929":["thread",109929],"thread-108649":["thread",108649],"thread-106795":["thread",106795],"thread-102742":["thread",102742],"thread-102705":["thread",102705],"thread-101766":["thread",101766],"thread-100783":["thread",100783],"thread-100755":["thread",100755],"thread-99533":["thread",99533],"thread-99531":["thread",99531],"thread-99429":["thread",99429],"thread-99065":["thread",99065],"thread-98941":["thread",98941],"thread-98586":["thread",98586],"thread-96879":["thread",96879],"thread-96041":["thread",96041],"thread-95110":["thread",95110],"thread-95034":["thread",95034],"thread-94942":["thread",94942],"thread-94158":["thread",94158],"thread-93105":["thread",93105],"thread-93086":["thread",93086],"thread-91450":["thread",91450],"thread-91364":["thread",91364]}, , 1715072390
Run Time: 0.000471
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20