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 (131957, 131947, 131942, 131939, 131935, 131934, 131932, 131931, 131914, 131912, 131911, 131909, 131905, 131903, 131900, 131898, 131896, 131894, 131891, 131889, 131886, 131884, 131877, 131876, 131875, 131870, 131864, 131860, 131859, 131854, 131851, 131849, 131841, 131839, 131838, 131837, 131836, 131835, 131828, 131825, 131824, 131818, 131817, 131814, 131811, 131810, 131809, 131808, 131806, 131805, 131802, 131800, 131797, 131795, 131794, 131793, 131791, 131788, 131786, 131779, 131772, 131771, 131768, 131765, 131758, 131754, 131750, 131749, 131746, 131743, 131740, 131738, 131733, 131731, 131722, 131721, 131720, 131717, 131714, 131712, 131705, 131703, 131701, 131695, 131694, 131693, 131692, 131691, 131690, 131689, 131686, 131683, 131681, 131680, 131678, 131674, 131669, 131663, 131661, 131659, 131658, 131655, 131651, 131647, 131643, 131642, 131640, 131637, 131636, 131635, 131634, 131624, 131622, 131619, 131612, 131608, 131606, 131602, 131598, 131585, 131572, 131567, 131562, 131560, 131558, 131554, 131549, 131545, 131539, 131537, 131534, 131529, 131520, 131517, 131515, 131514, 131513, 131511, 131502, 131493, 131490, 131487, 131483, 131479, 131476, 131472, 131471, 131469, 131468, 131467, 131466, 131462, 131452, 131451, 131450, 131449, 131448, 131447, 131446, 131445, 131441, 131440, 131439, 131434, 131433, 131432, 131426, 131424, 131422, 131419, 131418, 131414, 131411, 131407, 131398, 131396, 131395, 131383, 131379, 131367, 131365, 131363, 131360, 131357, 131356, 131353, 131351, 131350, 131342, 131340, 131330, 131324, 131320, 131319, 131312, 131310, 131307, 131305, 131304, 131294))
Run Time: 0.053866
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 | 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
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 127, 0, 1714822867, {"thread-131957":["thread",131957],"thread-131947":["thread",131947],"thread-131942":["thread",131942],"thread-131939":["thread",131939],"thread-131935":["thread",131935],"thread-131934":["thread",131934],"thread-131932":["thread",131932],"thread-131931":["thread",131931],"thread-131914":["thread",131914],"thread-131912":["thread",131912],"thread-131911":["thread",131911],"thread-131909":["thread",131909],"thread-131905":["thread",131905],"thread-131903":["thread",131903],"thread-131900":["thread",131900],"thread-131898":["thread",131898],"thread-131896":["thread",131896],"thread-131894":["thread",131894],"thread-131891":["thread",131891],"thread-131889":["thread",131889],"thread-131886":["thread",131886],"thread-131884":["thread",131884],"thread-131877":["thread",131877],"thread-131876":["thread",131876],"thread-131875":["thread",131875],"thread-131870":["thread",131870],"thread-131864":["thread",131864],"thread-131860":["thread",131860],"thread-131859":["thread",131859],"thread-131854":["thread",131854],"thread-131851":["thread",131851],"thread-131849":["thread",131849],"thread-131841":["thread",131841],"thread-131839":["thread",131839],"thread-131838":["thread",131838],"thread-131837":["thread",131837],"thread-131836":["thread",131836],"thread-131835":["thread",131835],"thread-131828":["thread",131828],"thread-131825":["thread",131825],"thread-131824":["thread",131824],"thread-131818":["thread",131818],"thread-131817":["thread",131817],"thread-131814":["thread",131814],"thread-131811":["thread",131811],"thread-131810":["thread",131810],"thread-131809":["thread",131809],"thread-131808":["thread",131808],"thread-131806":["thread",131806],"thread-131805":["thread",131805],"thread-131802":["thread",131802],"thread-131800":["thread",131800],"thread-131797":["thread",131797],"thread-131795":["thread",131795],"thread-131794":["thread",131794],"thread-131793":["thread",131793],"thread-131791":["thread",131791],"thread-131788":["thread",131788],"thread-131786":["thread",131786],"thread-131779":["thread",131779],"thread-131772":["thread",131772],"thread-131771":["thread",131771],"thread-131768":["thread",131768],"thread-131765":["thread",131765],"thread-131758":["thread",131758],"thread-131754":["thread",131754],"thread-131750":["thread",131750],"thread-131749":["thread",131749],"thread-131746":["thread",131746],"thread-131743":["thread",131743],"thread-131740":["thread",131740],"thread-131738":["thread",131738],"thread-131733":["thread",131733],"thread-131731":["thread",131731],"thread-131722":["thread",131722],"thread-131721":["thread",131721],"thread-131720":["thread",131720],"thread-131717":["thread",131717],"thread-131714":["thread",131714],"thread-131712":["thread",131712],"thread-131705":["thread",131705],"thread-131703":["thread",131703],"thread-131701":["thread",131701],"thread-131695":["thread",131695],"thread-131694":["thread",131694],"thread-131693":["thread",131693],"thread-131692":["thread",131692],"thread-131691":["thread",131691],"thread-131690":["thread",131690],"thread-131689":["thread",131689],"thread-131686":["thread",131686],"thread-131683":["thread",131683],"thread-131681":["thread",131681],"thread-131680":["thread",131680],"thread-131678":["thread",131678],"thread-131674":["thread",131674],"thread-131669":["thread",131669],"thread-131663":["thread",131663],"thread-131661":["thread",131661],"thread-131659":["thread",131659],"thread-131658":["thread",131658],"thread-131655":["thread",131655],"thread-131651":["thread",131651],"thread-131647":["thread",131647],"thread-131643":["thread",131643],"thread-131642":["thread",131642],"thread-131640":["thread",131640],"thread-131637":["thread",131637],"thread-131636":["thread",131636],"thread-131635":["thread",131635],"thread-131634":["thread",131634],"thread-131624":["thread",131624],"thread-131622":["thread",131622],"thread-131619":["thread",131619],"thread-131612":["thread",131612],"thread-131608":["thread",131608],"thread-131606":["thread",131606],"thread-131602":["thread",131602],"thread-131598":["thread",131598],"thread-131585":["thread",131585],"thread-131572":["thread",131572],"thread-131567":["thread",131567],"thread-131562":["thread",131562],"thread-131560":["thread",131560],"thread-131558":["thread",131558],"thread-131554":["thread",131554],"thread-131549":["thread",131549],"thread-131545":["thread",131545],"thread-131539":["thread",131539],"thread-131537":["thread",131537],"thread-131534":["thread",131534],"thread-131529":["thread",131529],"thread-131520":["thread",131520],"thread-131517":["thread",131517],"thread-131515":["thread",131515],"thread-131514":["thread",131514],"thread-131513":["thread",131513],"thread-131511":["thread",131511],"thread-131502":["thread",131502],"thread-131493":["thread",131493],"thread-131490":["thread",131490],"thread-131487":["thread",131487],"thread-131483":["thread",131483],"thread-131479":["thread",131479],"thread-131476":["thread",131476],"thread-131472":["thread",131472],"thread-131471":["thread",131471],"thread-131469":["thread",131469],"thread-131468":["thread",131468],"thread-131467":["thread",131467],"thread-131466":["thread",131466],"thread-131462":["thread",131462],"thread-131452":["thread",131452],"thread-131451":["thread",131451],"thread-131450":["thread",131450],"thread-131449":["thread",131449],"thread-131448":["thread",131448],"thread-131447":["thread",131447],"thread-131446":["thread",131446],"thread-131445":["thread",131445],"thread-131441":["thread",131441],"thread-131440":["thread",131440],"thread-131439":["thread",131439],"thread-131434":["thread",131434],"thread-131433":["thread",131433],"thread-131432":["thread",131432],"thread-131426":["thread",131426],"thread-131424":["thread",131424],"thread-131422":["thread",131422],"thread-131419":["thread",131419],"thread-131418":["thread",131418],"thread-131414":["thread",131414],"thread-131411":["thread",131411],"thread-131407":["thread",131407],"thread-131398":["thread",131398],"thread-131396":["thread",131396],"thread-131395":["thread",131395],"thread-131383":["thread",131383],"thread-131379":["thread",131379],"thread-131367":["thread",131367],"thread-131365":["thread",131365],"thread-131363":["thread",131363],"thread-131360":["thread",131360],"thread-131357":["thread",131357],"thread-131356":["thread",131356],"thread-131353":["thread",131353],"thread-131351":["thread",131351],"thread-131350":["thread",131350],"thread-131342":["thread",131342],"thread-131340":["thread",131340],"thread-131330":["thread",131330],"thread-131324":["thread",131324],"thread-131320":["thread",131320],"thread-131319":["thread",131319],"thread-131312":["thread",131312],"thread-131310":["thread",131310],"thread-131307":["thread",131307],"thread-131305":["thread",131305],"thread-131304":["thread",131304],"thread-131294":["thread",131294]}, , 1714819267
Run Time: 0.000237
- 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 1514
- 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