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 (183072, 182513, 182403, 182221, 182061, 181792, 181791, 181790, 181701, 181700, 181699, 181698, 181664, 181663, 181502, 181479, 181451, 181448, 181444, 181440, 181382, 181334, 181315, 181265, 181234, 180979, 180969, 180752, 179417, 179416, 179383, 179374, 179363, 179362, 179361, 179360, 179108, 179088, 179007, 179006, 178981, 178980, 178665, 178636, 178325, 178324, 178321, 178320, 178319, 178243, 178241, 178218, 178217, 178198, 178186, 178184, 178183, 178181, 178090, 178088, 178059, 178047, 178033, 177879, 177878, 177876, 177875, 177729, 177728, 177727, 177680, 177598, 177499, 177488, 177485, 177483, 177474, 177473, 177443, 177222, 177110, 176122, 175973, 174588, 173771, 172228, 171585, 171029, 170999, 170241, 167850, 167275, 167246, 166315, 159648, 158758, 157688, 156029, 153454, 148848, 144461, 136939, 113554, 113494, 113453, 108985, 107030, 104501, 100920, 100547, 98792, 98123, 93408, 91926, 91751, 91459, 91371, 91036, 90778, 87916, 87081, 86628, 83757, 83456, 83453, 82775, 79476, 66463, 58396, 58219, 56007))
Run Time: 0.072763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 131 | 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: 9327, 0, 1715841024, {"thread-183072":["thread",183072],"thread-182513":["thread",182513],"thread-182403":["thread",182403],"thread-182221":["thread",182221],"thread-182061":["thread",182061],"thread-181792":["thread",181792],"thread-181791":["thread",181791],"thread-181790":["thread",181790],"thread-181701":["thread",181701],"thread-181700":["thread",181700],"thread-181699":["thread",181699],"thread-181698":["thread",181698],"thread-181664":["thread",181664],"thread-181663":["thread",181663],"thread-181502":["thread",181502],"thread-181479":["thread",181479],"thread-181451":["thread",181451],"thread-181448":["thread",181448],"thread-181444":["thread",181444],"thread-181440":["thread",181440],"thread-181382":["thread",181382],"thread-181334":["thread",181334],"thread-181315":["thread",181315],"thread-181265":["thread",181265],"thread-181234":["thread",181234],"thread-180979":["thread",180979],"thread-180969":["thread",180969],"thread-180752":["thread",180752],"thread-179417":["thread",179417],"thread-179416":["thread",179416],"thread-179383":["thread",179383],"thread-179374":["thread",179374],"thread-179363":["thread",179363],"thread-179362":["thread",179362],"thread-179361":["thread",179361],"thread-179360":["thread",179360],"thread-179108":["thread",179108],"thread-179088":["thread",179088],"thread-179007":["thread",179007],"thread-179006":["thread",179006],"thread-178981":["thread",178981],"thread-178980":["thread",178980],"thread-178665":["thread",178665],"thread-178636":["thread",178636],"thread-178325":["thread",178325],"thread-178324":["thread",178324],"thread-178321":["thread",178321],"thread-178320":["thread",178320],"thread-178319":["thread",178319],"thread-178243":["thread",178243],"thread-178241":["thread",178241],"thread-178218":["thread",178218],"thread-178217":["thread",178217],"thread-178198":["thread",178198],"thread-178186":["thread",178186],"thread-178184":["thread",178184],"thread-178183":["thread",178183],"thread-178181":["thread",178181],"thread-178090":["thread",178090],"thread-178088":["thread",178088],"thread-178059":["thread",178059],"thread-178047":["thread",178047],"thread-178033":["thread",178033],"thread-177879":["thread",177879],"thread-177878":["thread",177878],"thread-177876":["thread",177876],"thread-177875":["thread",177875],"thread-177729":["thread",177729],"thread-177728":["thread",177728],"thread-177727":["thread",177727],"thread-177680":["thread",177680],"thread-177598":["thread",177598],"thread-177499":["thread",177499],"thread-177488":["thread",177488],"thread-177485":["thread",177485],"thread-177483":["thread",177483],"thread-177474":["thread",177474],"thread-177473":["thread",177473],"thread-177443":["thread",177443],"thread-177222":["thread",177222],"thread-177110":["thread",177110],"thread-176122":["thread",176122],"thread-175973":["thread",175973],"thread-174588":["thread",174588],"thread-173771":["thread",173771],"ams_article-4897":["ams_article",4897],"thread-172228":["thread",172228],"thread-171585":["thread",171585],"ams_article-4850":["ams_article",4850],"ams_article-4847":["ams_article",4847],"thread-171029":["thread",171029],"thread-170999":["thread",170999],"ams_article-4830":["ams_article",4830],"ams_article-4826":["ams_article",4826],"thread-170241":["thread",170241],"thread-167850":["thread",167850],"thread-167275":["thread",167275],"thread-167246":["thread",167246],"thread-166315":["thread",166315],"ams_article-4466":["ams_article",4466],"thread-159648":["thread",159648],"thread-158758":["thread",158758],"thread-157688":["thread",157688],"ams_article-4278":["ams_article",4278],"thread-156029":["thread",156029],"ams_article-4206":["ams_article",4206],"thread-153454":["thread",153454],"ams_article-3730":["ams_article",3730],"thread-148848":["thread",148848],"thread-144461":["thread",144461],"thread-136939":["thread",136939],"thread-113554":["thread",113554],"thread-113494":["thread",113494],"thread-113453":["thread",113453],"thread-108985":["thread",108985],"thread-107030":["thread",107030],"thread-104501":["thread",104501],"thread-100920":["thread",100920],"thread-100547":["thread",100547],"thread-98792":["thread",98792],"thread-98123":["thread",98123],"thread-93408":["thread",93408],"thread-91926":["thread",91926],"thread-91751":["thread",91751],"thread-91459":["thread",91459],"thread-91371":["thread",91371],"thread-91036":["thread",91036],"thread-90778":["thread",90778],"thread-87916":["thread",87916],"thread-87081":["thread",87081],"thread-86628":["thread",86628],"thread-83757":["thread",83757],"thread-83456":["thread",83456],"thread-83453":["thread",83453],"thread-82775":["thread",82775],"thread-79476":["thread",79476],"thread-66463":["thread",66463],"thread-58396":["thread",58396],"thread-58219":["thread",58219],"thread-56007":["thread",56007]}, , 1715837424
Run Time: 0.000422
- 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