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 (180012, 178249, 178247, 175802, 174035, 172143, 170663, 170474, 169844, 169181, 167353, 165923, 165797, 165207, 165007, 163395, 163268, 161867, 161691, 160699, 160119, 159864, 159849, 159538, 156683, 156571, 155276, 152215, 137162, 132125, 132054, 131887, 131874, 131843, 131633, 131614, 131551, 131389, 131114, 131047, 131046, 130615, 130612, 130342, 130133, 129786, 129360, 129228, 129056, 128667, 128089, 127924, 127885, 127333, 127181, 126968, 126272, 126137, 126062, 125768, 125351, 125252, 124387, 123914, 122880, 122805, 122167, 122151, 121204, 121190, 120754, 120322, 119799, 119756, 119467, 119387, 118863, 118774, 118597, 118538, 118536, 118454, 118019, 117943, 117909, 117464, 117434, 117391, 117014, 117011, 116622, 116551, 116409, 115700, 115267, 114957, 114110, 113984, 113828, 113465, 113462, 113378, 113278, 112648, 112514, 112457, 112095, 112076, 112038, 111962, 111684, 111645, 111609, 111264, 110797, 110487, 110392, 110249, 110224, 109884, 109823, 109822, 109762, 109672, 109548, 109328, 109263, 109144, 109142, 109036, 109030, 108872, 108681, 108642, 108638, 108060, 107609, 107474, 107139, 107079, 106995, 106832, 106720, 106316, 106102, 106040, 105930, 105909, 105276, 105174, 105072, 104837, 104795, 104594, 104183, 104143, 104020, 104009, 103852, 103747, 103706, 103592, 103426, 103272, 103239, 103197, 103173, 102961, 102810, 102809, 102806, 102498, 102156, 102022, 101991, 101955, 101935, 101932, 101898, 101837, 101835, 101683, 101585, 101474, 101466, 101433, 101334, 101304, 101217, 101210, 100713, 100602, 100473, 100455, 99996, 99725, 99448, 99093, 98506, 97927))
Run Time: 0.084117
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: 1689, 0, 1715874727, {"thread-180012":["thread",180012],"thread-178249":["thread",178249],"thread-178247":["thread",178247],"thread-175802":["thread",175802],"thread-174035":["thread",174035],"thread-172143":["thread",172143],"thread-170663":["thread",170663],"thread-170474":["thread",170474],"thread-169844":["thread",169844],"thread-169181":["thread",169181],"thread-167353":["thread",167353],"thread-165923":["thread",165923],"thread-165797":["thread",165797],"thread-165207":["thread",165207],"thread-165007":["thread",165007],"thread-163395":["thread",163395],"thread-163268":["thread",163268],"thread-161867":["thread",161867],"thread-161691":["thread",161691],"thread-160699":["thread",160699],"thread-160119":["thread",160119],"thread-159864":["thread",159864],"thread-159849":["thread",159849],"thread-159538":["thread",159538],"thread-156683":["thread",156683],"thread-156571":["thread",156571],"thread-155276":["thread",155276],"thread-152215":["thread",152215],"thread-137162":["thread",137162],"thread-132125":["thread",132125],"thread-132054":["thread",132054],"thread-131887":["thread",131887],"thread-131874":["thread",131874],"thread-131843":["thread",131843],"thread-131633":["thread",131633],"thread-131614":["thread",131614],"thread-131551":["thread",131551],"thread-131389":["thread",131389],"thread-131114":["thread",131114],"thread-131047":["thread",131047],"thread-131046":["thread",131046],"thread-130615":["thread",130615],"thread-130612":["thread",130612],"thread-130342":["thread",130342],"thread-130133":["thread",130133],"thread-129786":["thread",129786],"thread-129360":["thread",129360],"thread-129228":["thread",129228],"thread-129056":["thread",129056],"thread-128667":["thread",128667],"thread-128089":["thread",128089],"thread-127924":["thread",127924],"thread-127885":["thread",127885],"thread-127333":["thread",127333],"thread-127181":["thread",127181],"thread-126968":["thread",126968],"thread-126272":["thread",126272],"thread-126137":["thread",126137],"thread-126062":["thread",126062],"thread-125768":["thread",125768],"thread-125351":["thread",125351],"thread-125252":["thread",125252],"thread-124387":["thread",124387],"thread-122880":["thread",122880],"thread-122805":["thread",122805],"thread-122167":["thread",122167],"thread-122151":["thread",122151],"thread-121204":["thread",121204],"thread-121190":["thread",121190],"thread-120754":["thread",120754],"thread-120322":["thread",120322],"thread-119799":["thread",119799],"thread-119756":["thread",119756],"thread-119467":["thread",119467],"thread-119387":["thread",119387],"thread-118863":["thread",118863],"thread-118774":["thread",118774],"thread-118597":["thread",118597],"thread-118538":["thread",118538],"thread-118536":["thread",118536],"thread-118454":["thread",118454],"thread-117943":["thread",117943],"thread-117909":["thread",117909],"thread-117464":["thread",117464],"thread-117434":["thread",117434],"thread-117391":["thread",117391],"thread-117014":["thread",117014],"thread-117011":["thread",117011],"thread-116622":["thread",116622],"thread-116551":["thread",116551],"thread-116409":["thread",116409],"thread-115700":["thread",115700],"thread-115267":["thread",115267],"thread-114957":["thread",114957],"thread-114110":["thread",114110],"thread-113984":["thread",113984],"thread-113828":["thread",113828],"thread-113465":["thread",113465],"thread-113462":["thread",113462],"thread-113378":["thread",113378],"thread-113278":["thread",113278],"thread-112648":["thread",112648],"thread-112514":["thread",112514],"thread-112457":["thread",112457],"thread-112095":["thread",112095],"thread-112076":["thread",112076],"thread-112038":["thread",112038],"thread-111962":["thread",111962],"thread-111684":["thread",111684],"thread-111645":["thread",111645],"thread-111609":["thread",111609],"thread-111264":["thread",111264],"thread-110797":["thread",110797],"thread-110487":["thread",110487],"thread-110392":["thread",110392],"thread-110249":["thread",110249],"thread-110224":["thread",110224],"thread-109884":["thread",109884],"thread-109823":["thread",109823],"thread-109822":["thread",109822],"thread-109762":["thread",109762],"thread-109672":["thread",109672],"thread-109548":["thread",109548],"thread-109328":["thread",109328],"thread-109263":["thread",109263],"thread-109144":["thread",109144],"thread-109142":["thread",109142],"thread-109036":["thread",109036],"thread-109030":["thread",109030],"thread-108872":["thread",108872],"thread-108681":["thread",108681],"thread-108642":["thread",108642],"thread-108638":["thread",108638],"thread-108060":["thread",108060],"thread-107609":["thread",107609],"thread-107474":["thread",107474],"thread-107139":["thread",107139],"thread-107079":["thread",107079],"thread-106995":["thread",106995],"thread-106832":["thread",106832],"thread-106720":["thread",106720],"thread-106316":["thread",106316],"thread-106102":["thread",106102],"thread-106040":["thread",106040],"thread-105930":["thread",105930],"thread-105909":["thread",105909],"thread-105276":["thread",105276],"thread-105174":["thread",105174],"thread-105072":["thread",105072],"thread-104837":["thread",104837],"thread-104795":["thread",104795],"thread-104594":["thread",104594],"thread-104183":["thread",104183],"thread-104143":["thread",104143],"thread-104020":["thread",104020],"thread-104009":["thread",104009],"thread-103852":["thread",103852],"thread-103747":["thread",103747],"thread-103706":["thread",103706],"thread-103592":["thread",103592],"thread-103426":["thread",103426],"thread-103272":["thread",103272],"thread-103239":["thread",103239],"thread-103197":["thread",103197],"thread-103173":["thread",103173],"thread-102961":["thread",102961],"thread-102810":["thread",102810],"thread-102809":["thread",102809],"thread-102806":["thread",102806],"thread-102498":["thread",102498],"thread-102156":["thread",102156],"thread-102022":["thread",102022],"thread-101991":["thread",101991],"thread-101955":["thread",101955],"thread-101935":["thread",101935],"thread-101932":["thread",101932],"thread-101898":["thread",101898],"thread-101837":["thread",101837],"thread-101835":["thread",101835],"thread-101683":["thread",101683],"thread-101585":["thread",101585],"thread-101474":["thread",101474],"thread-101466":["thread",101466],"thread-101433":["thread",101433],"thread-101334":["thread",101334],"thread-101304":["thread",101304],"thread-101217":["thread",101217],"thread-101210":["thread",101210],"thread-100713":["thread",100713],"thread-100602":["thread",100602],"thread-100473":["thread",100473],"thread-100455":["thread",100455],"thread-99996":["thread",99996],"thread-99725":["thread",99725],"thread-99448":["thread",99448],"thread-99093":["thread",99093],"thread-98506":["thread",98506],"thread-97927":["thread",97927]}, , 1715871127
Run Time: 0.000480
- 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