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 (183056, 182917, 182800, 182782, 182625, 182608, 182596, 182554, 182553, 182474, 182309, 182298, 181910, 181705, 181373, 181169, 180660, 180652, 180192, 179845, 179827, 179379, 178958, 178946, 178813, 178696, 178213, 178130, 177977, 177795, 177642, 177057, 176632, 176589, 176543, 176280, 176124, 176095, 176043, 175994, 175751, 175383, 175165, 175046, 174976, 174953, 174842, 174199, 174019, 173912, 173874, 173791, 173504, 172798, 172792, 172725, 172466, 172427, 172138, 172084, 171969, 171897, 171641, 171639, 171539, 171495, 171493, 171451, 171406, 171405, 171404, 171103, 170897, 170149, 169579, 169515, 169388, 169231, 169148, 167499, 167368, 167326, 167042, 167040, 166845, 166522, 166519, 166309, 166037, 165531, 165512, 165482, 165441, 165363, 165290, 165204, 164330, 163599, 163181, 162934, 162413, 162278, 160681, 160263, 159722, 159329, 159319, 158801, 158548, 158403, 158303, 158106, 157980, 157965, 156133, 155944, 155942, 155939, 155753, 155706, 155596, 155441, 155236, 154945, 154834, 154728, 154584, 154418, 154068, 153869, 153755, 153462, 153434, 153215, 153046, 153002, 152651, 152639, 152559, 151771, 139544, 137354, 127754, 121257, 119805, 119804, 119029, 112181, 110991, 103874, 103855, 103831, 88735, 87071, 85102, 83315, 78140, 64080, 47215, 26460, 11965, 8873, 5156, 2574, 605))
Run Time: 0.107793
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 165 | 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: 159, 0, 1716013055, {"thread-183056":["thread",183056],"thread-182917":["thread",182917],"thread-182800":["thread",182800],"thread-182782":["thread",182782],"thread-182625":["thread",182625],"thread-182608":["thread",182608],"thread-182596":["thread",182596],"thread-182554":["thread",182554],"thread-182553":["thread",182553],"thread-182474":["thread",182474],"thread-182309":["thread",182309],"thread-182298":["thread",182298],"thread-181910":["thread",181910],"thread-181705":["thread",181705],"thread-181373":["thread",181373],"thread-181169":["thread",181169],"thread-180660":["thread",180660],"thread-180652":["thread",180652],"thread-180192":["thread",180192],"thread-179845":["thread",179845],"thread-179827":["thread",179827],"thread-179379":["thread",179379],"thread-178958":["thread",178958],"thread-178946":["thread",178946],"thread-178813":["thread",178813],"thread-178696":["thread",178696],"thread-178213":["thread",178213],"thread-178130":["thread",178130],"thread-177977":["thread",177977],"thread-177795":["thread",177795],"thread-177642":["thread",177642],"thread-177057":["thread",177057],"thread-176632":["thread",176632],"thread-176589":["thread",176589],"thread-176543":["thread",176543],"thread-176280":["thread",176280],"thread-176124":["thread",176124],"thread-176095":["thread",176095],"thread-176043":["thread",176043],"thread-175994":["thread",175994],"thread-175751":["thread",175751],"thread-175383":["thread",175383],"thread-175165":["thread",175165],"thread-175046":["thread",175046],"thread-174976":["thread",174976],"thread-174953":["thread",174953],"thread-174842":["thread",174842],"thread-174199":["thread",174199],"thread-174019":["thread",174019],"thread-173912":["thread",173912],"thread-173874":["thread",173874],"thread-173791":["thread",173791],"thread-173504":["thread",173504],"thread-172798":["thread",172798],"thread-172792":["thread",172792],"thread-172725":["thread",172725],"thread-172466":["thread",172466],"thread-172427":["thread",172427],"thread-172138":["thread",172138],"thread-172084":["thread",172084],"thread-171969":["thread",171969],"thread-171897":["thread",171897],"thread-171641":["thread",171641],"thread-171639":["thread",171639],"thread-171539":["thread",171539],"thread-171495":["thread",171495],"thread-171493":["thread",171493],"thread-171451":["thread",171451],"thread-171406":["thread",171406],"thread-171405":["thread",171405],"thread-171404":["thread",171404],"thread-171103":["thread",171103],"thread-170897":["thread",170897],"thread-170149":["thread",170149],"thread-169579":["thread",169579],"thread-169515":["thread",169515],"thread-169388":["thread",169388],"thread-169231":["thread",169231],"thread-169148":["thread",169148],"thread-167499":["thread",167499],"thread-167368":["thread",167368],"thread-167326":["thread",167326],"thread-167042":["thread",167042],"thread-167040":["thread",167040],"thread-166845":["thread",166845],"thread-166522":["thread",166522],"thread-166519":["thread",166519],"thread-166309":["thread",166309],"thread-166037":["thread",166037],"thread-165531":["thread",165531],"thread-165512":["thread",165512],"thread-165482":["thread",165482],"thread-165441":["thread",165441],"thread-165363":["thread",165363],"thread-165290":["thread",165290],"thread-165204":["thread",165204],"thread-164330":["thread",164330],"thread-163599":["thread",163599],"thread-163181":["thread",163181],"thread-162934":["thread",162934],"thread-162413":["thread",162413],"thread-162278":["thread",162278],"thread-160681":["thread",160681],"thread-160263":["thread",160263],"thread-159722":["thread",159722],"thread-159329":["thread",159329],"thread-159319":["thread",159319],"thread-158801":["thread",158801],"thread-158548":["thread",158548],"thread-158403":["thread",158403],"thread-158303":["thread",158303],"thread-158106":["thread",158106],"thread-157980":["thread",157980],"thread-157965":["thread",157965],"thread-156133":["thread",156133],"thread-155944":["thread",155944],"thread-155942":["thread",155942],"thread-155939":["thread",155939],"thread-155753":["thread",155753],"thread-155706":["thread",155706],"thread-155596":["thread",155596],"thread-155441":["thread",155441],"thread-155236":["thread",155236],"thread-154945":["thread",154945],"thread-154834":["thread",154834],"thread-154728":["thread",154728],"thread-154584":["thread",154584],"thread-154418":["thread",154418],"thread-154068":["thread",154068],"thread-153869":["thread",153869],"thread-153755":["thread",153755],"thread-153462":["thread",153462],"thread-153434":["thread",153434],"thread-153215":["thread",153215],"thread-153046":["thread",153046],"thread-153002":["thread",153002],"thread-152651":["thread",152651],"thread-152639":["thread",152639],"thread-152559":["thread",152559],"thread-151771":["thread",151771],"thread-139544":["thread",139544],"thread-137354":["thread",137354],"thread-127754":["thread",127754],"thread-121257":["thread",121257],"thread-119805":["thread",119805],"thread-119804":["thread",119804],"thread-119029":["thread",119029],"thread-112181":["thread",112181],"thread-110991":["thread",110991],"thread-103874":["thread",103874],"thread-103855":["thread",103855],"thread-103831":["thread",103831],"thread-88735":["thread",88735],"thread-87071":["thread",87071],"thread-85102":["thread",85102],"thread-83315":["thread",83315],"thread-78140":["thread",78140],"thread-64080":["thread",64080],"thread-47215":["thread",47215],"thread-26460":["thread",26460],"thread-11965":["thread",11965],"thread-8873":["thread",8873],"thread-5156":["thread",5156],"thread-2574":["thread",2574],"thread-605":["thread",605]}, , 1716009455
Run Time: 0.000182
- 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