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 (183078, 182953, 182552, 182548, 182433, 182231, 182022, 182013, 181776, 181469, 181184, 181057, 181023, 180542, 180533, 179841, 179669, 179665, 179573, 179474, 179280, 179050, 179024, 178859, 178760, 178664, 178579, 178536, 178533, 178506, 178401, 178314, 178308, 177916, 177844, 177693, 177440, 177399, 177253, 177051, 176478, 176326, 176194, 175770, 175635, 175388, 175330, 175299, 175264, 175194, 175116, 175032, 174951, 174905, 174688, 174572, 174485, 174384, 174329, 174120, 173438, 173423, 173124, 172964, 172916, 172690, 172682, 172675, 172210, 172111, 171880, 171772, 171766, 171649, 171565, 171564, 171452, 171423, 171412, 170702, 170651, 170590, 170549, 170341, 169977, 169971, 169950, 169881, 169857, 169837, 169671, 169560, 168555, 168450, 168147, 167901, 167717, 167711, 167582, 167523, 167490, 167482, 167463, 167423, 167342, 167323, 167082, 167034, 167023, 167010, 166982, 166960, 166941, 166906, 166876, 166764, 166746, 166599, 166116, 166109, 166096, 165883, 165837, 165825, 165788, 165670, 165648, 165485, 165459, 165359, 165226, 164605, 164588, 164388, 164373, 164024, 164003, 163588, 163484, 163387, 163349, 163279, 163250, 163233, 163179, 163145, 162651, 162642, 162451, 162187, 162174, 161779, 161729, 161698, 161193, 161187, 161018, 160627, 160573, 160533, 160498, 160493, 160222, 160192, 159978, 159945, 159940, 159851, 159366, 159279, 159269, 159261, 159181, 159033, 158994, 158920, 158511, 158429, 158412, 158395, 158384, 158359, 158213, 157953, 157322, 157306, 157242, 157138, 157097, 156989, 156766, 156637, 156502, 155972, 155921, 155721, 155702, 155600, 155564, 155532))
Run Time: 0.076997
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: 1246, 0, 1715071706, {"thread-183078":["thread",183078],"thread-182953":["thread",182953],"thread-182552":["thread",182552],"thread-182548":["thread",182548],"thread-182433":["thread",182433],"thread-182231":["thread",182231],"thread-182022":["thread",182022],"thread-182013":["thread",182013],"thread-181776":["thread",181776],"thread-181469":["thread",181469],"thread-181184":["thread",181184],"thread-181057":["thread",181057],"thread-181023":["thread",181023],"thread-180542":["thread",180542],"thread-180533":["thread",180533],"thread-179841":["thread",179841],"thread-179669":["thread",179669],"thread-179665":["thread",179665],"thread-179573":["thread",179573],"thread-179474":["thread",179474],"thread-179280":["thread",179280],"thread-179050":["thread",179050],"thread-179024":["thread",179024],"thread-178859":["thread",178859],"thread-178760":["thread",178760],"thread-178664":["thread",178664],"thread-178579":["thread",178579],"thread-178536":["thread",178536],"thread-178533":["thread",178533],"thread-178506":["thread",178506],"thread-178401":["thread",178401],"thread-178314":["thread",178314],"thread-178308":["thread",178308],"thread-177916":["thread",177916],"thread-177844":["thread",177844],"thread-177693":["thread",177693],"thread-177440":["thread",177440],"thread-177399":["thread",177399],"thread-177253":["thread",177253],"thread-177051":["thread",177051],"thread-176478":["thread",176478],"thread-176326":["thread",176326],"thread-176194":["thread",176194],"thread-175770":["thread",175770],"thread-175635":["thread",175635],"thread-175388":["thread",175388],"thread-175330":["thread",175330],"thread-175299":["thread",175299],"thread-175264":["thread",175264],"thread-175194":["thread",175194],"thread-175116":["thread",175116],"thread-175032":["thread",175032],"thread-174951":["thread",174951],"thread-174905":["thread",174905],"thread-174688":["thread",174688],"thread-174572":["thread",174572],"thread-174485":["thread",174485],"thread-174384":["thread",174384],"thread-174329":["thread",174329],"thread-174120":["thread",174120],"thread-173438":["thread",173438],"thread-173423":["thread",173423],"thread-173124":["thread",173124],"thread-172964":["thread",172964],"thread-172916":["thread",172916],"thread-172690":["thread",172690],"thread-172682":["thread",172682],"thread-172675":["thread",172675],"thread-172210":["thread",172210],"thread-172111":["thread",172111],"thread-171880":["thread",171880],"thread-171772":["thread",171772],"thread-171766":["thread",171766],"thread-171649":["thread",171649],"thread-171565":["thread",171565],"thread-171564":["thread",171564],"thread-171452":["thread",171452],"thread-171423":["thread",171423],"thread-171412":["thread",171412],"thread-170702":["thread",170702],"thread-170651":["thread",170651],"thread-170590":["thread",170590],"thread-170549":["thread",170549],"thread-170341":["thread",170341],"thread-169977":["thread",169977],"thread-169971":["thread",169971],"thread-169950":["thread",169950],"thread-169881":["thread",169881],"thread-169857":["thread",169857],"thread-169837":["thread",169837],"thread-169671":["thread",169671],"thread-169560":["thread",169560],"thread-168555":["thread",168555],"thread-168450":["thread",168450],"thread-168147":["thread",168147],"thread-167901":["thread",167901],"thread-167717":["thread",167717],"thread-167711":["thread",167711],"thread-167582":["thread",167582],"thread-167523":["thread",167523],"thread-167490":["thread",167490],"thread-167482":["thread",167482],"thread-167463":["thread",167463],"thread-167423":["thread",167423],"thread-167342":["thread",167342],"thread-167323":["thread",167323],"thread-167082":["thread",167082],"thread-167034":["thread",167034],"thread-167023":["thread",167023],"thread-167010":["thread",167010],"thread-166982":["thread",166982],"thread-166960":["thread",166960],"thread-166941":["thread",166941],"thread-166906":["thread",166906],"thread-166876":["thread",166876],"thread-166764":["thread",166764],"thread-166746":["thread",166746],"thread-166599":["thread",166599],"thread-166116":["thread",166116],"thread-166109":["thread",166109],"thread-166096":["thread",166096],"thread-165883":["thread",165883],"thread-165837":["thread",165837],"thread-165825":["thread",165825],"thread-165788":["thread",165788],"thread-165670":["thread",165670],"thread-165648":["thread",165648],"thread-165485":["thread",165485],"thread-165459":["thread",165459],"thread-165359":["thread",165359],"thread-165226":["thread",165226],"thread-164605":["thread",164605],"thread-164588":["thread",164588],"thread-164388":["thread",164388],"thread-164373":["thread",164373],"thread-164024":["thread",164024],"thread-164003":["thread",164003],"thread-163588":["thread",163588],"thread-163484":["thread",163484],"thread-163387":["thread",163387],"thread-163349":["thread",163349],"thread-163279":["thread",163279],"thread-163250":["thread",163250],"thread-163233":["thread",163233],"thread-163179":["thread",163179],"thread-163145":["thread",163145],"thread-162651":["thread",162651],"thread-162642":["thread",162642],"thread-162451":["thread",162451],"thread-162187":["thread",162187],"thread-162174":["thread",162174],"thread-161779":["thread",161779],"thread-161729":["thread",161729],"thread-161698":["thread",161698],"thread-161193":["thread",161193],"thread-161187":["thread",161187],"thread-161018":["thread",161018],"thread-160627":["thread",160627],"thread-160573":["thread",160573],"thread-160533":["thread",160533],"thread-160498":["thread",160498],"thread-160493":["thread",160493],"thread-160222":["thread",160222],"thread-160192":["thread",160192],"thread-159978":["thread",159978],"thread-159945":["thread",159945],"thread-159940":["thread",159940],"thread-159851":["thread",159851],"thread-159366":["thread",159366],"thread-159279":["thread",159279],"thread-159269":["thread",159269],"thread-159261":["thread",159261],"thread-159181":["thread",159181],"thread-159033":["thread",159033],"thread-158994":["thread",158994],"thread-158920":["thread",158920],"thread-158511":["thread",158511],"thread-158429":["thread",158429],"thread-158412":["thread",158412],"thread-158395":["thread",158395],"thread-158384":["thread",158384],"thread-158359":["thread",158359],"thread-158213":["thread",158213],"thread-157953":["thread",157953],"thread-157322":["thread",157322],"thread-157306":["thread",157306],"thread-157242":["thread",157242],"thread-157138":["thread",157138],"thread-157097":["thread",157097],"thread-156989":["thread",156989],"thread-156766":["thread",156766],"thread-156637":["thread",156637],"thread-156502":["thread",156502],"thread-155972":["thread",155972],"thread-155921":["thread",155921],"thread-155721":["thread",155721],"thread-155702":["thread",155702],"thread-155600":["thread",155600],"thread-155564":["thread",155564],"thread-155532":["thread",155532]}, , 1715068106
Run Time: 0.001007
- 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