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 (183386, 183378, 183375, 183367, 183335, 183330, 183299, 183219, 183181, 183120, 183108, 183104, 183052, 182950, 182944, 182933, 182884, 182835, 182790, 182763, 182746, 182682, 182657, 182595, 182559, 182523, 182519, 182516, 182515, 182454, 182434, 182418, 182406, 182397, 182377, 182356, 182312, 182185, 182168, 182166, 182159, 182148, 182109, 182084, 182073, 182029, 182001, 181982, 181888, 181887, 181861, 181853, 181819, 181813, 181788, 181786, 181674, 181645, 181640, 181549, 181509, 181508, 181472, 181432, 181402, 181342, 181048, 180998, 180983, 180974, 180966, 180935, 180932, 180887, 180869, 180838, 180802, 180748, 180602, 180567, 180485, 180452, 180445, 180423, 180388, 180325, 180092, 180051, 180036, 179993, 179881, 179866, 179863, 179859, 179785, 179784, 179662, 179659, 179624, 179591, 179535, 179533, 179508, 179496, 179388, 179358, 179322, 179320, 179251, 179203, 179151, 179144, 179142, 179138, 179125, 179120, 179068, 179018, 178964, 178919, 178864, 178773, 178758, 178690, 178578, 178548, 178545, 178387, 178322, 178283, 178272, 178270, 178260, 178237, 178202, 178008, 177965, 177962, 177950, 177938, 177914, 177852, 177839, 177784, 177710, 177671, 177639, 177634, 177586, 177565, 177558, 177539, 177538, 177534, 177469, 177381, 177377, 177265, 177209, 177111, 177102, 177095, 176999, 176992, 176977, 176968, 176945, 176843, 176787, 176732, 176721, 176539, 176533, 176532, 176488, 176453, 176416, 176409, 176393, 176290, 176271, 176266, 176248, 176235, 176127, 176079, 176039, 175919, 175858, 175767, 175717, 175595, 175593, 175591, 175572, 175567, 175566, 175550, 175520, 175410))
Run Time: 0.108340
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` = 806455
Params: 1715463755, {"thread-183386":["thread",183386],"thread-183378":["thread",183378],"thread-183375":["thread",183375],"thread-183367":["thread",183367],"thread-183335":["thread",183335],"thread-183330":["thread",183330],"thread-183299":["thread",183299],"thread-183219":["thread",183219],"thread-183181":["thread",183181],"thread-183120":["thread",183120],"thread-183108":["thread",183108],"thread-183104":["thread",183104],"thread-183052":["thread",183052],"thread-182950":["thread",182950],"thread-182944":["thread",182944],"thread-182933":["thread",182933],"thread-182884":["thread",182884],"thread-182835":["thread",182835],"thread-182790":["thread",182790],"thread-182763":["thread",182763],"thread-182746":["thread",182746],"thread-182682":["thread",182682],"thread-182657":["thread",182657],"thread-182595":["thread",182595],"thread-182559":["thread",182559],"thread-182523":["thread",182523],"thread-182519":["thread",182519],"thread-182516":["thread",182516],"thread-182515":["thread",182515],"thread-182454":["thread",182454],"thread-182434":["thread",182434],"thread-182418":["thread",182418],"thread-182406":["thread",182406],"thread-182397":["thread",182397],"thread-182377":["thread",182377],"thread-182356":["thread",182356],"thread-182312":["thread",182312],"thread-182185":["thread",182185],"thread-182168":["thread",182168],"thread-182166":["thread",182166],"thread-182159":["thread",182159],"thread-182148":["thread",182148],"thread-182109":["thread",182109],"thread-182084":["thread",182084],"thread-182073":["thread",182073],"thread-182029":["thread",182029],"thread-182001":["thread",182001],"thread-181982":["thread",181982],"thread-181888":["thread",181888],"thread-181887":["thread",181887],"thread-181861":["thread",181861],"thread-181853":["thread",181853],"thread-181819":["thread",181819],"thread-181813":["thread",181813],"thread-181788":["thread",181788],"thread-181786":["thread",181786],"thread-181674":["thread",181674],"thread-181645":["thread",181645],"thread-181640":["thread",181640],"thread-181549":["thread",181549],"thread-181509":["thread",181509],"thread-181508":["thread",181508],"thread-181472":["thread",181472],"thread-181432":["thread",181432],"thread-181402":["thread",181402],"thread-181342":["thread",181342],"thread-181048":["thread",181048],"thread-180998":["thread",180998],"thread-180983":["thread",180983],"thread-180974":["thread",180974],"thread-180966":["thread",180966],"thread-180935":["thread",180935],"thread-180932":["thread",180932],"thread-180887":["thread",180887],"thread-180869":["thread",180869],"thread-180838":["thread",180838],"thread-180802":["thread",180802],"thread-180748":["thread",180748],"thread-180602":["thread",180602],"thread-180567":["thread",180567],"thread-180485":["thread",180485],"thread-180452":["thread",180452],"thread-180445":["thread",180445],"thread-180423":["thread",180423],"thread-180388":["thread",180388],"thread-180325":["thread",180325],"thread-180092":["thread",180092],"thread-180051":["thread",180051],"thread-180036":["thread",180036],"thread-179993":["thread",179993],"thread-179881":["thread",179881],"thread-179866":["thread",179866],"thread-179863":["thread",179863],"thread-179859":["thread",179859],"thread-179785":["thread",179785],"thread-179784":["thread",179784],"thread-179662":["thread",179662],"thread-179659":["thread",179659],"thread-179624":["thread",179624],"thread-179591":["thread",179591],"thread-179535":["thread",179535],"thread-179533":["thread",179533],"thread-179508":["thread",179508],"thread-179496":["thread",179496],"thread-179388":["thread",179388],"thread-179358":["thread",179358],"thread-179322":["thread",179322],"thread-179320":["thread",179320],"thread-179251":["thread",179251],"thread-179203":["thread",179203],"thread-179151":["thread",179151],"thread-179144":["thread",179144],"thread-179142":["thread",179142],"thread-179138":["thread",179138],"thread-179125":["thread",179125],"thread-179120":["thread",179120],"thread-179068":["thread",179068],"thread-179018":["thread",179018],"thread-178964":["thread",178964],"thread-178919":["thread",178919],"thread-178864":["thread",178864],"thread-178773":["thread",178773],"thread-178758":["thread",178758],"thread-178690":["thread",178690],"thread-178578":["thread",178578],"thread-178548":["thread",178548],"thread-178545":["thread",178545],"thread-178387":["thread",178387],"thread-178322":["thread",178322],"thread-178283":["thread",178283],"thread-178272":["thread",178272],"thread-178270":["thread",178270],"thread-178260":["thread",178260],"thread-178237":["thread",178237],"thread-178202":["thread",178202],"thread-178008":["thread",178008],"thread-177965":["thread",177965],"thread-177962":["thread",177962],"thread-177950":["thread",177950],"thread-177938":["thread",177938],"thread-177914":["thread",177914],"thread-177852":["thread",177852],"thread-177839":["thread",177839],"thread-177784":["thread",177784],"thread-177710":["thread",177710],"thread-177671":["thread",177671],"thread-177639":["thread",177639],"thread-177634":["thread",177634],"thread-177586":["thread",177586],"thread-177565":["thread",177565],"thread-177558":["thread",177558],"thread-177539":["thread",177539],"thread-177538":["thread",177538],"thread-177534":["thread",177534],"thread-177469":["thread",177469],"thread-177381":["thread",177381],"thread-177377":["thread",177377],"thread-177265":["thread",177265],"thread-177209":["thread",177209],"thread-177111":["thread",177111],"thread-177102":["thread",177102],"thread-177095":["thread",177095],"thread-176999":["thread",176999],"thread-176992":["thread",176992],"thread-176977":["thread",176977],"thread-176968":["thread",176968],"thread-176945":["thread",176945],"thread-176843":["thread",176843],"thread-176787":["thread",176787],"thread-176732":["thread",176732],"thread-176721":["thread",176721],"thread-176539":["thread",176539],"thread-176533":["thread",176533],"thread-176532":["thread",176532],"thread-176488":["thread",176488],"thread-176453":["thread",176453],"thread-176416":["thread",176416],"thread-176409":["thread",176409],"thread-176393":["thread",176393],"thread-176290":["thread",176290],"thread-176271":["thread",176271],"thread-176266":["thread",176266],"thread-176248":["thread",176248],"thread-176235":["thread",176235],"thread-176127":["thread",176127],"thread-176079":["thread",176079],"thread-176039":["thread",176039],"thread-175919":["thread",175919],"thread-175858":["thread",175858],"thread-175767":["thread",175767],"thread-175717":["thread",175717],"thread-175595":["thread",175595],"thread-175593":["thread",175593],"thread-175591":["thread",175591],"thread-175572":["thread",175572],"thread-175567":["thread",175567],"thread-175566":["thread",175566],"thread-175550":["thread",175550],"thread-175520":["thread",175520],"thread-175410":["thread",175410]}
Run Time: 0.000634
- 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