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 (183513, 183506, 183488, 183486, 183442, 183415, 183409, 183304, 183236, 183224, 183153, 183052, 183020, 182914, 182911, 182853, 182851, 182825, 182820, 182742, 182731, 182632, 182608, 182594, 182565, 182474, 182399, 182318, 182315, 182286, 182265, 182235, 182227, 182215, 182113, 182068, 182060, 182025, 181982, 181974, 181927, 181885, 181743, 181644, 181614, 181533, 181504, 181452, 181438, 181429, 181420, 181301, 181297, 181281, 181272, 181256, 181202, 181111, 181086, 181069, 180997, 180966, 180948, 180944, 180941, 180692, 180670, 180662, 180540, 180536, 180435, 180415, 180404, 180403, 180347, 180267, 180260, 180173, 180170, 180109, 180009, 179988, 179923, 179888, 179856, 179850, 179818, 179743, 179732, 179708, 179678, 179644, 179598, 179564, 179521, 179503, 179472, 179457, 179452, 179448, 179413, 179408, 179359, 179323, 179320, 179317, 179267, 179263, 179262, 179246, 179238, 179148, 179090, 179053, 178997, 178976, 178922, 178916, 178861, 178852, 178798, 178621, 178263, 178257, 178105, 177877, 177871, 177852, 177818, 177755, 177742, 177737, 177605, 177347, 177313, 177267, 177195, 177190, 177146, 177058, 176957, 176948, 176860, 176855, 176852, 176820, 176776, 176718, 176625, 176613, 176558, 176526, 176472, 176355, 176235, 176232, 176215, 176202, 176200, 176178, 176138, 176028, 175995, 175973, 175819, 175798, 175797, 175795, 175739, 175675, 175673, 175671, 175650, 175638, 175589, 175486, 175484, 175480, 175479, 175422, 175376, 175366, 175329, 175212, 175206, 175121, 175109, 174998, 174983, 174881, 174856, 174855, 174780, 174772, 174749, 174744, 174739, 174725))
Run Time: 0.072053
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 198 | 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: 23, 0, 1715920387, {"thread-183513":["thread",183513],"thread-183506":["thread",183506],"thread-183488":["thread",183488],"thread-183486":["thread",183486],"thread-183442":["thread",183442],"thread-183415":["thread",183415],"thread-183409":["thread",183409],"thread-183304":["thread",183304],"thread-183236":["thread",183236],"thread-183224":["thread",183224],"thread-183153":["thread",183153],"thread-183052":["thread",183052],"thread-183020":["thread",183020],"thread-182914":["thread",182914],"thread-182911":["thread",182911],"thread-182853":["thread",182853],"thread-182851":["thread",182851],"thread-182825":["thread",182825],"thread-182820":["thread",182820],"thread-182742":["thread",182742],"thread-182731":["thread",182731],"thread-182632":["thread",182632],"thread-182608":["thread",182608],"thread-182594":["thread",182594],"thread-182565":["thread",182565],"thread-182474":["thread",182474],"thread-182399":["thread",182399],"thread-182318":["thread",182318],"thread-182315":["thread",182315],"thread-182286":["thread",182286],"thread-182265":["thread",182265],"thread-182235":["thread",182235],"thread-182227":["thread",182227],"thread-182215":["thread",182215],"thread-182113":["thread",182113],"thread-182068":["thread",182068],"thread-182060":["thread",182060],"thread-182025":["thread",182025],"thread-181982":["thread",181982],"thread-181974":["thread",181974],"thread-181927":["thread",181927],"thread-181885":["thread",181885],"thread-181743":["thread",181743],"thread-181644":["thread",181644],"thread-181614":["thread",181614],"thread-181533":["thread",181533],"thread-181504":["thread",181504],"thread-181452":["thread",181452],"thread-181438":["thread",181438],"thread-181429":["thread",181429],"thread-181420":["thread",181420],"thread-181301":["thread",181301],"thread-181297":["thread",181297],"thread-181281":["thread",181281],"thread-181272":["thread",181272],"thread-181256":["thread",181256],"thread-181202":["thread",181202],"thread-181111":["thread",181111],"thread-181086":["thread",181086],"thread-181069":["thread",181069],"thread-180997":["thread",180997],"thread-180966":["thread",180966],"thread-180948":["thread",180948],"thread-180944":["thread",180944],"thread-180941":["thread",180941],"thread-180692":["thread",180692],"thread-180670":["thread",180670],"thread-180662":["thread",180662],"thread-180540":["thread",180540],"thread-180536":["thread",180536],"thread-180435":["thread",180435],"thread-180415":["thread",180415],"thread-180404":["thread",180404],"thread-180403":["thread",180403],"thread-180347":["thread",180347],"thread-180267":["thread",180267],"thread-180260":["thread",180260],"thread-180173":["thread",180173],"thread-180170":["thread",180170],"thread-180109":["thread",180109],"thread-180009":["thread",180009],"thread-179988":["thread",179988],"thread-179923":["thread",179923],"thread-179888":["thread",179888],"thread-179856":["thread",179856],"thread-179850":["thread",179850],"thread-179818":["thread",179818],"thread-179743":["thread",179743],"thread-179732":["thread",179732],"thread-179708":["thread",179708],"thread-179678":["thread",179678],"thread-179644":["thread",179644],"thread-179598":["thread",179598],"thread-179564":["thread",179564],"thread-179521":["thread",179521],"thread-179503":["thread",179503],"thread-179472":["thread",179472],"thread-179457":["thread",179457],"thread-179452":["thread",179452],"thread-179448":["thread",179448],"thread-179413":["thread",179413],"thread-179408":["thread",179408],"thread-179359":["thread",179359],"thread-179323":["thread",179323],"thread-179320":["thread",179320],"thread-179317":["thread",179317],"thread-179267":["thread",179267],"thread-179263":["thread",179263],"thread-179262":["thread",179262],"thread-179246":["thread",179246],"thread-179238":["thread",179238],"thread-179148":["thread",179148],"thread-179090":["thread",179090],"thread-179053":["thread",179053],"thread-178997":["thread",178997],"thread-178976":["thread",178976],"thread-178922":["thread",178922],"thread-178916":["thread",178916],"thread-178861":["thread",178861],"thread-178852":["thread",178852],"thread-178798":["thread",178798],"thread-178621":["thread",178621],"thread-178263":["thread",178263],"thread-178257":["thread",178257],"thread-178105":["thread",178105],"thread-177877":["thread",177877],"thread-177871":["thread",177871],"thread-177852":["thread",177852],"thread-177818":["thread",177818],"thread-177755":["thread",177755],"thread-177742":["thread",177742],"thread-177737":["thread",177737],"thread-177605":["thread",177605],"thread-177347":["thread",177347],"thread-177313":["thread",177313],"thread-177267":["thread",177267],"thread-177195":["thread",177195],"thread-177190":["thread",177190],"thread-177146":["thread",177146],"thread-177058":["thread",177058],"thread-176957":["thread",176957],"thread-176948":["thread",176948],"thread-176860":["thread",176860],"thread-176855":["thread",176855],"thread-176852":["thread",176852],"thread-176820":["thread",176820],"thread-176776":["thread",176776],"tl_group-323":["tl_group",323],"thread-176718":["thread",176718],"thread-176625":["thread",176625],"thread-176613":["thread",176613],"thread-176558":["thread",176558],"thread-176526":["thread",176526],"ams_article-5112":["ams_article",5112],"thread-176472":["thread",176472],"thread-176355":["thread",176355],"thread-176235":["thread",176235],"thread-176232":["thread",176232],"thread-176215":["thread",176215],"thread-176202":["thread",176202],"thread-176200":["thread",176200],"thread-176178":["thread",176178],"thread-176138":["thread",176138],"thread-176028":["thread",176028],"thread-175995":["thread",175995],"thread-175973":["thread",175973],"thread-175819":["thread",175819],"thread-175798":["thread",175798],"thread-175797":["thread",175797],"thread-175795":["thread",175795],"thread-175739":["thread",175739],"thread-175675":["thread",175675],"thread-175673":["thread",175673],"thread-175671":["thread",175671],"thread-175650":["thread",175650],"thread-175638":["thread",175638],"thread-175589":["thread",175589],"thread-175486":["thread",175486],"thread-175484":["thread",175484],"thread-175480":["thread",175480],"thread-175479":["thread",175479],"thread-175422":["thread",175422],"thread-175376":["thread",175376],"thread-175366":["thread",175366],"thread-175329":["thread",175329],"thread-175212":["thread",175212],"thread-175206":["thread",175206],"thread-175121":["thread",175121],"thread-175109":["thread",175109],"thread-174998":["thread",174998],"thread-174983":["thread",174983],"thread-174881":["thread",174881],"thread-174856":["thread",174856],"thread-174855":["thread",174855],"thread-174780":["thread",174780],"thread-174772":["thread",174772],"thread-174749":["thread",174749],"thread-174744":["thread",174744],"thread-174739":["thread",174739],"thread-174725":["thread",174725]}, , 1715916787
Run Time: 0.000177
- 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