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 (182858, 182717, 181518, 177864, 177606, 174394, 174374, 173773, 173100, 173011, 172773, 172767, 172422, 171161, 170981, 169832, 169144, 169064, 168875, 168845, 168564, 168166, 168000, 167475, 167412, 166549, 166246, 165614, 165048, 165033, 164736, 164725, 164256, 163450, 163115, 162487, 161815, 161775, 159872, 156975, 156524, 151865, 147675, 147282, 132047, 131984, 131727, 131181, 131144, 131142, 131141, 131140, 131134, 131044, 131038, 130990, 130790, 130315, 129781, 129506, 129430, 129352, 129100, 128619, 128564, 128535, 128391, 128388, 128386, 127997, 127119, 126141, 126051, 125566, 125535, 125534, 125533, 125357, 125341, 125340, 125339, 125338, 125334, 124710, 124696, 124695, 124694, 124693, 124692, 124683, 124200, 124199, 124197, 124195, 124170, 124169, 124168, 123633, 123597, 123525, 123397, 122887, 122256, 120830, 120506, 119662, 119240, 119206, 119201, 119101, 119074, 118804, 118803, 118802, 118801, 118800, 118799, 118798, 118797, 118796, 118795, 118794, 118599, 118598, 118218, 118023, 117722, 117552, 117373, 117303, 116849, 116822, 116779, 116676, 116621, 116539, 116512, 116479, 116478, 116255, 116112, 116020, 115549, 114628, 114465, 114256, 113192, 113160, 112847, 112660, 112649, 112177, 111801, 111787, 111243, 111010, 110787, 109896, 109607, 109541, 109294, 108707, 108676, 108358, 108153, 106953, 106537, 106446, 106035, 105642, 105638, 104370, 104206, 103455, 102829, 102525, 102522, 102517, 102460, 101850, 101805, 101800, 101786, 101252, 101162, 101159, 101106, 100599, 99859, 99826, 99625, 99351, 99107, 98950, 98819, 98687, 98517, 98405, 98366))
Run Time: 0.094088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 183, 0, 1715148375, {"thread-182858":["thread",182858],"thread-182717":["thread",182717],"thread-181518":["thread",181518],"thread-177864":["thread",177864],"thread-177606":["thread",177606],"thread-174394":["thread",174394],"thread-174374":["thread",174374],"thread-173773":["thread",173773],"thread-173100":["thread",173100],"thread-173011":["thread",173011],"thread-172773":["thread",172773],"thread-172767":["thread",172767],"thread-172422":["thread",172422],"thread-171161":["thread",171161],"thread-170981":["thread",170981],"thread-169832":["thread",169832],"thread-169144":["thread",169144],"thread-169064":["thread",169064],"thread-168875":["thread",168875],"thread-168845":["thread",168845],"thread-168564":["thread",168564],"thread-168166":["thread",168166],"thread-168000":["thread",168000],"thread-167475":["thread",167475],"thread-167412":["thread",167412],"thread-166549":["thread",166549],"thread-166246":["thread",166246],"thread-165614":["thread",165614],"thread-165048":["thread",165048],"thread-165033":["thread",165033],"thread-164736":["thread",164736],"thread-164725":["thread",164725],"thread-164256":["thread",164256],"thread-163450":["thread",163450],"thread-163115":["thread",163115],"thread-162487":["thread",162487],"thread-161815":["thread",161815],"thread-161775":["thread",161775],"thread-159872":["thread",159872],"thread-156975":["thread",156975],"thread-156524":["thread",156524],"thread-151865":["thread",151865],"ams_article-3632":["ams_article",3632],"thread-147675":["thread",147675],"thread-147282":["thread",147282],"thread-132047":["thread",132047],"thread-131984":["thread",131984],"thread-131727":["thread",131727],"thread-131181":["thread",131181],"thread-131144":["thread",131144],"thread-131142":["thread",131142],"thread-131141":["thread",131141],"thread-131140":["thread",131140],"thread-131134":["thread",131134],"thread-131044":["thread",131044],"thread-131038":["thread",131038],"thread-130990":["thread",130990],"thread-130790":["thread",130790],"thread-130315":["thread",130315],"thread-129781":["thread",129781],"thread-129506":["thread",129506],"thread-129430":["thread",129430],"thread-129352":["thread",129352],"thread-129100":["thread",129100],"thread-128619":["thread",128619],"thread-128564":["thread",128564],"thread-128535":["thread",128535],"thread-128391":["thread",128391],"thread-128388":["thread",128388],"thread-128386":["thread",128386],"thread-127997":["thread",127997],"thread-127119":["thread",127119],"thread-126141":["thread",126141],"thread-126051":["thread",126051],"thread-125566":["thread",125566],"thread-125535":["thread",125535],"thread-125534":["thread",125534],"thread-125533":["thread",125533],"thread-125357":["thread",125357],"thread-125341":["thread",125341],"thread-125340":["thread",125340],"thread-125339":["thread",125339],"thread-125338":["thread",125338],"thread-125334":["thread",125334],"thread-124710":["thread",124710],"thread-124696":["thread",124696],"thread-124695":["thread",124695],"thread-124694":["thread",124694],"thread-124693":["thread",124693],"thread-124692":["thread",124692],"thread-124683":["thread",124683],"thread-124200":["thread",124200],"thread-124199":["thread",124199],"thread-124197":["thread",124197],"thread-124195":["thread",124195],"thread-124170":["thread",124170],"thread-124169":["thread",124169],"thread-124168":["thread",124168],"thread-123633":["thread",123633],"thread-123597":["thread",123597],"thread-123525":["thread",123525],"thread-123397":["thread",123397],"thread-122887":["thread",122887],"thread-122256":["thread",122256],"thread-120830":["thread",120830],"thread-120506":["thread",120506],"thread-119662":["thread",119662],"thread-119240":["thread",119240],"thread-119206":["thread",119206],"thread-119201":["thread",119201],"thread-119101":["thread",119101],"thread-119074":["thread",119074],"thread-118804":["thread",118804],"thread-118803":["thread",118803],"thread-118802":["thread",118802],"thread-118801":["thread",118801],"thread-118800":["thread",118800],"thread-118799":["thread",118799],"thread-118798":["thread",118798],"thread-118797":["thread",118797],"thread-118796":["thread",118796],"thread-118795":["thread",118795],"thread-118794":["thread",118794],"thread-118599":["thread",118599],"thread-118598":["thread",118598],"thread-118218":["thread",118218],"thread-118023":["thread",118023],"thread-117722":["thread",117722],"thread-117552":["thread",117552],"thread-117373":["thread",117373],"thread-117303":["thread",117303],"thread-116849":["thread",116849],"thread-116822":["thread",116822],"thread-116779":["thread",116779],"thread-116676":["thread",116676],"thread-116621":["thread",116621],"thread-116539":["thread",116539],"thread-116512":["thread",116512],"thread-116479":["thread",116479],"thread-116478":["thread",116478],"thread-116255":["thread",116255],"thread-116112":["thread",116112],"thread-116020":["thread",116020],"thread-115549":["thread",115549],"thread-114628":["thread",114628],"thread-114465":["thread",114465],"thread-114256":["thread",114256],"thread-113192":["thread",113192],"thread-113160":["thread",113160],"thread-112847":["thread",112847],"thread-112660":["thread",112660],"thread-112649":["thread",112649],"thread-112177":["thread",112177],"thread-111801":["thread",111801],"thread-111787":["thread",111787],"thread-111243":["thread",111243],"thread-111010":["thread",111010],"thread-110787":["thread",110787],"thread-109896":["thread",109896],"thread-109607":["thread",109607],"thread-109541":["thread",109541],"thread-109294":["thread",109294],"thread-108707":["thread",108707],"thread-108676":["thread",108676],"thread-108358":["thread",108358],"thread-108153":["thread",108153],"thread-106953":["thread",106953],"thread-106537":["thread",106537],"thread-106446":["thread",106446],"thread-106035":["thread",106035],"thread-105642":["thread",105642],"thread-105638":["thread",105638],"thread-104370":["thread",104370],"thread-104206":["thread",104206],"thread-103455":["thread",103455],"thread-102829":["thread",102829],"thread-102525":["thread",102525],"thread-102522":["thread",102522],"thread-102517":["thread",102517],"thread-102460":["thread",102460],"thread-101850":["thread",101850],"thread-101805":["thread",101805],"thread-101800":["thread",101800],"thread-101786":["thread",101786],"thread-101252":["thread",101252],"thread-101162":["thread",101162],"thread-101159":["thread",101159],"thread-101106":["thread",101106],"thread-100599":["thread",100599],"thread-99859":["thread",99859],"thread-99826":["thread",99826],"thread-99625":["thread",99625],"thread-99351":["thread",99351],"thread-99107":["thread",99107],"thread-98950":["thread",98950],"thread-98819":["thread",98819],"thread-98687":["thread",98687],"thread-98517":["thread",98517],"thread-98405":["thread",98405],"thread-98366":["thread",98366]}, , 1715144775
Run Time: 0.000885
- 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