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 (218950, 217303, 216955, 214072, 213199, 212884, 211633, 211573, 210987, 210863, 210664, 210519, 210297, 209758, 208108, 207937, 207934, 207016, 206017, 206005, 205468, 204172, 202192, 201463, 200017, 199744, 198769, 197590, 197101, 197002, 196015, 194608, 194140, 194077, 193993, 193420, 190879, 188662, 187123, 185332, 183766, 182053, 181240, 178396, 177637, 177487, 175705, 175351, 175189, 174560, 173413, 172396, 172369, 172321, 170960, 170954, 170127, 168465, 168219, 164134, 163786, 163225, 161524, 161440, 159592, 158539, 156904, 156901, 155527, 150598, 147905, 145283, 143786, 143375, 142790, 140937, 139017, 137706, 137391, 137127, 136224, 135387, 134240, 133568, 132692, 132377, 130775, 130658, 129032, 128846, 127890, 126497, 126358, 125305, 124814, 124294, 123653, 123534, 123531, 123450, 120275, 119646, 119443, 119295, 118503, 117367, 115783, 114013, 113678, 113638, 113463, 113306, 112901, 111999, 111642, 111270, 111200, 110755, 110377, 110343, 110312, 109994, 107875, 107866, 107742, 107422, 107087, 107014, 107013, 106898, 106894, 106550, 105954, 105851, 104701, 103953, 103841, 103309, 103283, 102821, 102401, 101863, 101471, 100697, 100242, 99927, 98510, 98324, 98031, 97025, 95748, 92489, 92483, 92359, 91995, 91205))
Run Time: 0.004923
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 156 | 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: 165, 0, 1714299389, {"thread-218950":["thread",218950],"thread-217303":["thread",217303],"thread-216955":["thread",216955],"thread-214072":["thread",214072],"thread-213199":["thread",213199],"thread-212884":["thread",212884],"thread-211633":["thread",211633],"thread-211573":["thread",211573],"thread-210987":["thread",210987],"thread-210863":["thread",210863],"thread-210664":["thread",210664],"thread-210519":["thread",210519],"thread-210297":["thread",210297],"thread-208108":["thread",208108],"thread-207937":["thread",207937],"thread-207934":["thread",207934],"thread-207016":["thread",207016],"thread-206017":["thread",206017],"thread-206005":["thread",206005],"thread-205468":["thread",205468],"thread-204172":["thread",204172],"thread-202192":["thread",202192],"thread-201463":["thread",201463],"thread-200017":["thread",200017],"thread-199744":["thread",199744],"thread-198769":["thread",198769],"thread-197590":["thread",197590],"thread-197101":["thread",197101],"thread-197002":["thread",197002],"thread-196015":["thread",196015],"thread-194608":["thread",194608],"thread-194140":["thread",194140],"thread-194077":["thread",194077],"thread-193993":["thread",193993],"thread-193420":["thread",193420],"thread-190879":["thread",190879],"thread-188662":["thread",188662],"thread-187123":["thread",187123],"thread-185332":["thread",185332],"thread-183766":["thread",183766],"thread-182053":["thread",182053],"thread-181240":["thread",181240],"thread-178396":["thread",178396],"thread-177637":["thread",177637],"thread-177487":["thread",177487],"thread-175705":["thread",175705],"thread-175351":["thread",175351],"thread-175189":["thread",175189],"thread-174560":["thread",174560],"thread-173413":["thread",173413],"thread-172396":["thread",172396],"thread-172369":["thread",172369],"thread-172321":["thread",172321],"thread-170960":["thread",170960],"thread-170954":["thread",170954],"thread-170127":["thread",170127],"thread-168465":["thread",168465],"thread-168219":["thread",168219],"thread-164134":["thread",164134],"thread-163786":["thread",163786],"thread-163225":["thread",163225],"thread-161524":["thread",161524],"thread-161440":["thread",161440],"thread-159592":["thread",159592],"thread-158539":["thread",158539],"thread-156904":["thread",156904],"thread-156901":["thread",156901],"thread-155527":["thread",155527],"thread-150598":["thread",150598],"thread-147905":["thread",147905],"thread-145283":["thread",145283],"thread-143786":["thread",143786],"thread-143375":["thread",143375],"thread-142790":["thread",142790],"thread-140937":["thread",140937],"thread-139017":["thread",139017],"thread-137706":["thread",137706],"thread-137391":["thread",137391],"thread-137127":["thread",137127],"thread-136224":["thread",136224],"thread-135387":["thread",135387],"thread-134240":["thread",134240],"thread-133568":["thread",133568],"thread-132692":["thread",132692],"thread-132377":["thread",132377],"thread-130775":["thread",130775],"thread-130658":["thread",130658],"thread-129032":["thread",129032],"thread-128846":["thread",128846],"thread-127890":["thread",127890],"thread-126497":["thread",126497],"thread-126358":["thread",126358],"thread-125305":["thread",125305],"thread-124814":["thread",124814],"thread-124294":["thread",124294],"thread-123653":["thread",123653],"thread-123534":["thread",123534],"thread-123531":["thread",123531],"thread-123450":["thread",123450],"thread-120275":["thread",120275],"thread-119646":["thread",119646],"thread-119443":["thread",119443],"thread-119295":["thread",119295],"thread-118503":["thread",118503],"thread-117367":["thread",117367],"thread-115783":["thread",115783],"thread-114013":["thread",114013],"thread-113678":["thread",113678],"thread-113638":["thread",113638],"thread-113463":["thread",113463],"thread-113306":["thread",113306],"thread-112901":["thread",112901],"thread-111999":["thread",111999],"thread-111642":["thread",111642],"thread-111270":["thread",111270],"thread-111200":["thread",111200],"thread-110755":["thread",110755],"thread-110377":["thread",110377],"thread-110343":["thread",110343],"thread-110312":["thread",110312],"thread-109994":["thread",109994],"thread-107875":["thread",107875],"thread-107866":["thread",107866],"thread-107742":["thread",107742],"thread-107422":["thread",107422],"thread-107087":["thread",107087],"thread-107014":["thread",107014],"thread-107013":["thread",107013],"thread-106898":["thread",106898],"thread-106894":["thread",106894],"thread-106550":["thread",106550],"thread-105954":["thread",105954],"thread-105851":["thread",105851],"thread-104701":["thread",104701],"thread-103953":["thread",103953],"thread-103841":["thread",103841],"thread-103309":["thread",103309],"thread-103283":["thread",103283],"thread-102821":["thread",102821],"thread-102401":["thread",102401],"thread-101863":["thread",101863],"thread-101471":["thread",101471],"thread-100697":["thread",100697],"thread-100242":["thread",100242],"thread-99927":["thread",99927],"thread-98510":["thread",98510],"thread-98324":["thread",98324],"thread-98031":["thread",98031],"thread-97025":["thread",97025],"thread-95748":["thread",95748],"thread-92489":["thread",92489],"thread-92483":["thread",92483],"thread-92359":["thread",92359],"thread-91995":["thread",91995],"thread-91205":["thread",91205]}, , 1714295789
Run Time: 0.000450
- 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