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 (183531, 183426, 183183, 182851, 182652, 182477, 182428, 182405, 182196, 182130, 181978, 181841, 181792, 181791, 181790, 181701, 181700, 181699, 181698, 181664, 181663, 181636, 181635, 181633, 181552, 181537, 181479, 181448, 181404, 181382, 181315, 181265, 181090, 180969, 180940, 180844, 180718, 180638, 180628, 180351, 180305, 180264, 180173, 180027, 179965, 179934, 179929, 179710, 179664, 179456, 179434, 179417, 179416, 179386, 179383, 179382, 179374, 179363, 179362, 179361, 179360, 179356, 179322, 179273, 179108, 179088, 179010, 179007, 179006, 178981, 178980, 178968, 178867, 178798, 178742, 178659, 178642, 178636, 178565, 178381, 178363, 178325, 178324, 178321, 178320, 178319, 178279, 178276, 178250, 178245, 178243, 178241, 178218, 178217, 178198, 178188, 178186, 178184, 178183, 178181, 178144, 178090, 178088, 178059, 178049, 178047, 178033, 177932, 177879, 177878, 177876, 177875, 177851, 177823, 177818, 177729, 177728, 177727, 177680, 177526, 177499, 177488, 177486, 177485, 177483, 177474, 177473, 177214, 177110, 177016, 176899, 176720, 176502, 176444, 176425, 176062, 176051, 175830, 175824, 175269, 175258, 175242, 175212, 175132, 175131, 175121, 175078, 174952, 174565, 174516, 174415, 174346, 173944, 173937, 173856, 173623, 173433, 173426, 173420, 173390, 173209, 173164, 173049, 172987, 172929, 172524, 172160, 172137, 172090, 172059, 172043, 171765, 171428, 171313, 171211, 171069, 170801, 170761, 170712, 170707, 170617, 170420, 170274, 170230, 170210, 169737, 169446, 169331))
Run Time: 0.081817
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 188 | 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: 8479, 0, 1715931998, {"thread-183531":["thread",183531],"thread-183426":["thread",183426],"thread-183183":["thread",183183],"thread-182851":["thread",182851],"thread-182652":["thread",182652],"thread-182477":["thread",182477],"thread-182428":["thread",182428],"thread-182405":["thread",182405],"thread-182196":["thread",182196],"thread-182130":["thread",182130],"thread-181978":["thread",181978],"thread-181841":["thread",181841],"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-181636":["thread",181636],"thread-181635":["thread",181635],"thread-181633":["thread",181633],"thread-181552":["thread",181552],"thread-181537":["thread",181537],"thread-181479":["thread",181479],"thread-181448":["thread",181448],"thread-181404":["thread",181404],"thread-181382":["thread",181382],"thread-181315":["thread",181315],"thread-181265":["thread",181265],"thread-181090":["thread",181090],"thread-180969":["thread",180969],"thread-180940":["thread",180940],"thread-180844":["thread",180844],"thread-180718":["thread",180718],"thread-180638":["thread",180638],"thread-180628":["thread",180628],"thread-180351":["thread",180351],"thread-180305":["thread",180305],"thread-180264":["thread",180264],"thread-180173":["thread",180173],"thread-180027":["thread",180027],"thread-179965":["thread",179965],"thread-179934":["thread",179934],"thread-179929":["thread",179929],"thread-179710":["thread",179710],"thread-179664":["thread",179664],"thread-179456":["thread",179456],"thread-179434":["thread",179434],"thread-179417":["thread",179417],"thread-179416":["thread",179416],"thread-179386":["thread",179386],"thread-179383":["thread",179383],"thread-179382":["thread",179382],"thread-179374":["thread",179374],"thread-179363":["thread",179363],"thread-179362":["thread",179362],"thread-179361":["thread",179361],"thread-179360":["thread",179360],"thread-179356":["thread",179356],"thread-179322":["thread",179322],"thread-179273":["thread",179273],"thread-179108":["thread",179108],"thread-179088":["thread",179088],"thread-179010":["thread",179010],"thread-179007":["thread",179007],"thread-179006":["thread",179006],"thread-178981":["thread",178981],"thread-178980":["thread",178980],"thread-178968":["thread",178968],"thread-178867":["thread",178867],"thread-178798":["thread",178798],"thread-178742":["thread",178742],"thread-178659":["thread",178659],"thread-178642":["thread",178642],"thread-178636":["thread",178636],"thread-178565":["thread",178565],"thread-178381":["thread",178381],"ams_article-5150":["ams_article",5150],"thread-178363":["thread",178363],"thread-178325":["thread",178325],"thread-178324":["thread",178324],"thread-178321":["thread",178321],"thread-178320":["thread",178320],"thread-178319":["thread",178319],"thread-178279":["thread",178279],"thread-178276":["thread",178276],"ams_article-5148":["ams_article",5148],"thread-178250":["thread",178250],"thread-178245":["thread",178245],"thread-178243":["thread",178243],"thread-178241":["thread",178241],"thread-178218":["thread",178218],"thread-178217":["thread",178217],"thread-178198":["thread",178198],"thread-178188":["thread",178188],"thread-178186":["thread",178186],"thread-178184":["thread",178184],"thread-178183":["thread",178183],"thread-178181":["thread",178181],"thread-178144":["thread",178144],"thread-178090":["thread",178090],"thread-178088":["thread",178088],"thread-178059":["thread",178059],"thread-178049":["thread",178049],"thread-178047":["thread",178047],"thread-178033":["thread",178033],"thread-177932":["thread",177932],"thread-177879":["thread",177879],"thread-177878":["thread",177878],"thread-177876":["thread",177876],"thread-177875":["thread",177875],"thread-177851":["thread",177851],"thread-177823":["thread",177823],"thread-177818":["thread",177818],"thread-177729":["thread",177729],"thread-177728":["thread",177728],"thread-177727":["thread",177727],"thread-177680":["thread",177680],"thread-177526":["thread",177526],"thread-177499":["thread",177499],"thread-177488":["thread",177488],"thread-177486":["thread",177486],"thread-177485":["thread",177485],"thread-177483":["thread",177483],"thread-177474":["thread",177474],"thread-177473":["thread",177473],"ams_article-5134":["ams_article",5134],"ams_article-5132":["ams_article",5132],"thread-177214":["thread",177214],"thread-177110":["thread",177110],"thread-177016":["thread",177016],"thread-176899":["thread",176899],"thread-176720":["thread",176720],"thread-176502":["thread",176502],"thread-176444":["thread",176444],"thread-176425":["thread",176425],"thread-176062":["thread",176062],"thread-176051":["thread",176051],"thread-175830":["thread",175830],"thread-175824":["thread",175824],"thread-175269":["thread",175269],"thread-175258":["thread",175258],"thread-175242":["thread",175242],"thread-175212":["thread",175212],"thread-175132":["thread",175132],"thread-175131":["thread",175131],"thread-175121":["thread",175121],"thread-175078":["thread",175078],"thread-174952":["thread",174952],"thread-174565":["thread",174565],"thread-174516":["thread",174516],"thread-174415":["thread",174415],"thread-174346":["thread",174346],"thread-173944":["thread",173944],"thread-173937":["thread",173937],"thread-173856":["thread",173856],"thread-173623":["thread",173623],"thread-173433":["thread",173433],"thread-173426":["thread",173426],"thread-173420":["thread",173420],"thread-173390":["thread",173390],"thread-173209":["thread",173209],"thread-173164":["thread",173164],"thread-173049":["thread",173049],"thread-172987":["thread",172987],"thread-172929":["thread",172929],"thread-172524":["thread",172524],"ams_article-4897":["ams_article",4897],"thread-172160":["thread",172160],"thread-172137":["thread",172137],"thread-172090":["thread",172090],"thread-172059":["thread",172059],"thread-172043":["thread",172043],"thread-171765":["thread",171765],"thread-171428":["thread",171428],"thread-171313":["thread",171313],"thread-171211":["thread",171211],"ams_article-4850":["ams_article",4850],"ams_article-4847":["ams_article",4847],"thread-171069":["thread",171069],"ams_article-4840":["ams_article",4840],"thread-170801":["thread",170801],"thread-170761":["thread",170761],"thread-170712":["thread",170712],"thread-170707":["thread",170707],"thread-170617":["thread",170617],"ams_article-4830":["ams_article",4830],"thread-170420":["thread",170420],"thread-170274":["thread",170274],"thread-170230":["thread",170230],"thread-170210":["thread",170210],"thread-169737":["thread",169737],"thread-169446":["thread",169446],"thread-169331":["thread",169331]}, , 1715928398
Run Time: 0.000387
- 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