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 (186977, 186846, 186762, 186460, 186398, 186093, 185815, 185729, 185433, 185341, 185330, 185137, 185134, 184999, 184584, 184243, 184061, 183741, 183231, 183171, 182995, 182598, 182279, 182229, 182080, 182036, 181693, 181686, 181514, 181509, 181438, 181343, 181258, 181173, 180477, 179928, 179778, 179695, 179501, 179354, 179292, 179063, 178972, 178792, 178615, 178438, 178323, 178195, 178162, 178152, 178149, 178056, 178026, 177872, 177666, 177659, 177312, 177278, 177271, 177213, 177074, 176722, 176669, 176633, 176618, 176482, 176406, 176363, 176174, 175746, 175743, 175637, 175567, 175566, 175286, 175171, 174751, 174421, 174242, 174229, 174185, 174119, 173846, 173807, 173744, 173731, 173611, 173569, 172810, 172480, 172378, 172225, 172100, 171945, 171917, 171616, 171120, 171042, 171014, 170699, 170677, 170521, 170486, 170241, 170209, 170187, 169462, 169305, 169272, 169122, 169086, 169078, 169058, 169038, 168714, 168698, 168561, 168220, 168192, 168037, 167970, 167470, 167407, 167176, 167112, 167100, 167087, 166488, 166107, 165958, 165956, 165901, 165659, 165633, 165621, 165576, 165505, 165375, 165355, 165092, 164893, 164849, 164845, 164667, 164499, 164243, 164236, 164049, 163735, 163669, 163667, 163662, 163583, 163559, 163129, 163041, 162690, 162668, 162570, 162484, 162326, 162267, 161840, 161831, 161614, 161388, 161294, 161267, 161199, 160655, 160633, 160517, 160490, 160268, 160267, 160214, 160201, 160198, 160162, 160156, 159863, 159861, 159854, 159773, 159440, 159369, 159326, 158797, 158777, 158757, 158600, 158425, 158393, 158064, 157980, 157966, 157853, 157849, 157806, 156869))
Run Time: 0.094642
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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 931869
Params: 1726884494, {"thread-186977":["thread",186977],"thread-186846":["thread",186846],"thread-186762":["thread",186762],"thread-186460":["thread",186460],"thread-186398":["thread",186398],"thread-186093":["thread",186093],"thread-185815":["thread",185815],"thread-185729":["thread",185729],"thread-185433":["thread",185433],"thread-185341":["thread",185341],"thread-185330":["thread",185330],"thread-185137":["thread",185137],"thread-185134":["thread",185134],"thread-184999":["thread",184999],"thread-184584":["thread",184584],"thread-184243":["thread",184243],"thread-184061":["thread",184061],"thread-183741":["thread",183741],"thread-183231":["thread",183231],"thread-183171":["thread",183171],"thread-182995":["thread",182995],"thread-182598":["thread",182598],"thread-182279":["thread",182279],"thread-182229":["thread",182229],"thread-182080":["thread",182080],"thread-182036":["thread",182036],"thread-181686":["thread",181686],"thread-181514":["thread",181514],"thread-181509":["thread",181509],"thread-181438":["thread",181438],"thread-181343":["thread",181343],"thread-181258":["thread",181258],"thread-181173":["thread",181173],"thread-180477":["thread",180477],"thread-179928":["thread",179928],"thread-179778":["thread",179778],"thread-179695":["thread",179695],"thread-179501":["thread",179501],"thread-179354":["thread",179354],"thread-179292":["thread",179292],"thread-179063":["thread",179063],"thread-178972":["thread",178972],"thread-178792":["thread",178792],"thread-178615":["thread",178615],"thread-178438":["thread",178438],"thread-178323":["thread",178323],"thread-178195":["thread",178195],"thread-178162":["thread",178162],"thread-178152":["thread",178152],"thread-178149":["thread",178149],"thread-178056":["thread",178056],"thread-178026":["thread",178026],"thread-177872":["thread",177872],"thread-177666":["thread",177666],"thread-177659":["thread",177659],"thread-177312":["thread",177312],"thread-177278":["thread",177278],"thread-177271":["thread",177271],"thread-177213":["thread",177213],"thread-177074":["thread",177074],"thread-176722":["thread",176722],"thread-176669":["thread",176669],"thread-176633":["thread",176633],"thread-176618":["thread",176618],"thread-176482":["thread",176482],"thread-176406":["thread",176406],"thread-176363":["thread",176363],"thread-176174":["thread",176174],"thread-175746":["thread",175746],"thread-175743":["thread",175743],"thread-175637":["thread",175637],"thread-175567":["thread",175567],"thread-175566":["thread",175566],"thread-175286":["thread",175286],"thread-175171":["thread",175171],"thread-174751":["thread",174751],"thread-174421":["thread",174421],"thread-174242":["thread",174242],"thread-174229":["thread",174229],"thread-174185":["thread",174185],"thread-174119":["thread",174119],"thread-173846":["thread",173846],"thread-173807":["thread",173807],"thread-173744":["thread",173744],"thread-173731":["thread",173731],"thread-173611":["thread",173611],"thread-173569":["thread",173569],"thread-172810":["thread",172810],"thread-172480":["thread",172480],"thread-172378":["thread",172378],"thread-172225":["thread",172225],"thread-172100":["thread",172100],"thread-171945":["thread",171945],"thread-171917":["thread",171917],"thread-171616":["thread",171616],"thread-171120":["thread",171120],"thread-171042":["thread",171042],"thread-171014":["thread",171014],"thread-170677":["thread",170677],"thread-170521":["thread",170521],"thread-170486":["thread",170486],"thread-170241":["thread",170241],"thread-170209":["thread",170209],"thread-170187":["thread",170187],"thread-169462":["thread",169462],"thread-169305":["thread",169305],"thread-169272":["thread",169272],"thread-169122":["thread",169122],"thread-169086":["thread",169086],"thread-169078":["thread",169078],"thread-169058":["thread",169058],"thread-169038":["thread",169038],"thread-168714":["thread",168714],"thread-168698":["thread",168698],"thread-168561":["thread",168561],"thread-168220":["thread",168220],"thread-168192":["thread",168192],"thread-168037":["thread",168037],"thread-167970":["thread",167970],"thread-167470":["thread",167470],"thread-167407":["thread",167407],"thread-167176":["thread",167176],"thread-167112":["thread",167112],"thread-167100":["thread",167100],"thread-167087":["thread",167087],"thread-166488":["thread",166488],"thread-166107":["thread",166107],"thread-165958":["thread",165958],"thread-165956":["thread",165956],"thread-165901":["thread",165901],"thread-165659":["thread",165659],"thread-165633":["thread",165633],"thread-165621":["thread",165621],"thread-165576":["thread",165576],"thread-165505":["thread",165505],"thread-165375":["thread",165375],"thread-165355":["thread",165355],"thread-165092":["thread",165092],"thread-164893":["thread",164893],"thread-164849":["thread",164849],"thread-164845":["thread",164845],"thread-164667":["thread",164667],"thread-164499":["thread",164499],"thread-164243":["thread",164243],"thread-164236":["thread",164236],"thread-164049":["thread",164049],"thread-163735":["thread",163735],"thread-163669":["thread",163669],"thread-163667":["thread",163667],"thread-163662":["thread",163662],"thread-163583":["thread",163583],"thread-163559":["thread",163559],"thread-163129":["thread",163129],"thread-163041":["thread",163041],"thread-162690":["thread",162690],"thread-162668":["thread",162668],"thread-162570":["thread",162570],"thread-162484":["thread",162484],"thread-162326":["thread",162326],"thread-162267":["thread",162267],"thread-161840":["thread",161840],"thread-161831":["thread",161831],"thread-161614":["thread",161614],"thread-161388":["thread",161388],"thread-161294":["thread",161294],"thread-161267":["thread",161267],"thread-161199":["thread",161199],"thread-160655":["thread",160655],"thread-160633":["thread",160633],"thread-160517":["thread",160517],"thread-160490":["thread",160490],"thread-160268":["thread",160268],"thread-160267":["thread",160267],"thread-160214":["thread",160214],"thread-160201":["thread",160201],"thread-160198":["thread",160198],"thread-160162":["thread",160162],"thread-160156":["thread",160156],"thread-159863":["thread",159863],"thread-159861":["thread",159861],"thread-159854":["thread",159854],"thread-159773":["thread",159773],"thread-159440":["thread",159440],"thread-159369":["thread",159369],"thread-159326":["thread",159326],"thread-158797":["thread",158797],"thread-158777":["thread",158777],"thread-158757":["thread",158757],"thread-158600":["thread",158600],"thread-158425":["thread",158425],"thread-158393":["thread",158393],"thread-158064":["thread",158064],"thread-157980":["thread",157980],"thread-157966":["thread",157966],"thread-157853":["thread",157853],"thread-157849":["thread",157849],"thread-157806":["thread",157806],"thread-156869":["thread",156869]}
Run Time: 0.000381
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1519
- 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