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 (183216, 183029, 182728, 182008, 182002, 181863, 181544, 180807, 180575, 180569, 180554, 180184, 179895, 179407, 178901, 178819, 178756, 178537, 178535, 178160, 178132, 178131, 178067, 177964, 175435, 175222, 175123, 174555, 174506, 174381, 174380, 174377, 174260, 174170, 174147, 174128, 174090, 174076, 174060, 174037, 174027, 173988, 173978, 173713, 173678, 173361, 173095, 172589, 172482, 172264, 172206, 172106, 171891, 171682, 171408, 171345, 171343, 171335, 171334, 171322, 171321, 171320, 171312, 171292, 171291, 171290, 171122, 171093, 171089, 170969, 170906, 170510, 170052, 170038, 170036, 170034, 169679, 169466, 168770, 168683, 168618, 167569, 167177, 166965, 166776, 166760, 166759, 166720, 166500, 166486, 166472, 166471, 166470, 166469, 166432, 166399, 166385, 166380, 166373, 166371, 166362, 166349, 166169, 166168, 166166, 166134, 166133, 166128, 166119, 166118, 166082, 166077, 166071, 166070, 166069, 166067, 166066, 166042, 166041, 165990, 165981, 165961, 165950, 165703, 165430, 165429, 165428, 165427, 165423, 165422, 164419, 164295, 164267, 163773, 163674, 163044, 162542, 162262, 162234, 161792, 161791, 161790, 161788, 161787, 161694, 161440, 161227, 161215, 160928, 160370, 160193, 160142, 160062, 159967, 159965, 159910, 159784, 159776, 159775, 159758, 159757, 159756, 159735, 159732, 159492, 159436, 159030, 158990, 158894, 158824, 158731, 158687, 158567, 158474, 158440, 158438, 158427, 158392, 158391, 158362, 158361, 158130, 158066, 157861, 157859, 157351, 157305, 157303, 156775, 155673, 155268, 154836, 154618, 154114, 154110, 153975, 153559, 153539, 113463, 67852))
Run Time: 0.098828
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
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 6246, 0, 1715665714, {"thread-183216":["thread",183216],"thread-183029":["thread",183029],"thread-182728":["thread",182728],"thread-182008":["thread",182008],"thread-182002":["thread",182002],"thread-181863":["thread",181863],"thread-181544":["thread",181544],"thread-180807":["thread",180807],"thread-180575":["thread",180575],"thread-180569":["thread",180569],"thread-180554":["thread",180554],"thread-180184":["thread",180184],"thread-179895":["thread",179895],"thread-179407":["thread",179407],"thread-178901":["thread",178901],"thread-178819":["thread",178819],"thread-178756":["thread",178756],"thread-178537":["thread",178537],"thread-178535":["thread",178535],"thread-178160":["thread",178160],"thread-178132":["thread",178132],"thread-178131":["thread",178131],"thread-178067":["thread",178067],"thread-177964":["thread",177964],"thread-175435":["thread",175435],"thread-175222":["thread",175222],"thread-175123":["thread",175123],"thread-174555":["thread",174555],"thread-174506":["thread",174506],"thread-174381":["thread",174381],"thread-174380":["thread",174380],"thread-174377":["thread",174377],"thread-174260":["thread",174260],"thread-174170":["thread",174170],"thread-174147":["thread",174147],"thread-174128":["thread",174128],"thread-174090":["thread",174090],"thread-174076":["thread",174076],"thread-174060":["thread",174060],"thread-174037":["thread",174037],"thread-174027":["thread",174027],"thread-173988":["thread",173988],"thread-173978":["thread",173978],"thread-173713":["thread",173713],"thread-173678":["thread",173678],"thread-173361":["thread",173361],"thread-173095":["thread",173095],"thread-172589":["thread",172589],"thread-172482":["thread",172482],"thread-172264":["thread",172264],"thread-172206":["thread",172206],"thread-172106":["thread",172106],"thread-171891":["thread",171891],"thread-171682":["thread",171682],"thread-171408":["thread",171408],"thread-171345":["thread",171345],"thread-171343":["thread",171343],"thread-171335":["thread",171335],"thread-171334":["thread",171334],"thread-171322":["thread",171322],"thread-171321":["thread",171321],"thread-171320":["thread",171320],"thread-171312":["thread",171312],"thread-171292":["thread",171292],"thread-171291":["thread",171291],"thread-171290":["thread",171290],"thread-171122":["thread",171122],"thread-171093":["thread",171093],"thread-171089":["thread",171089],"thread-170969":["thread",170969],"thread-170906":["thread",170906],"thread-170510":["thread",170510],"thread-170052":["thread",170052],"thread-170038":["thread",170038],"thread-170036":["thread",170036],"thread-170034":["thread",170034],"thread-169679":["thread",169679],"thread-169466":["thread",169466],"thread-168770":["thread",168770],"thread-168683":["thread",168683],"thread-168618":["thread",168618],"thread-167569":["thread",167569],"thread-167177":["thread",167177],"thread-166965":["thread",166965],"thread-166776":["thread",166776],"thread-166760":["thread",166760],"thread-166759":["thread",166759],"thread-166720":["thread",166720],"thread-166500":["thread",166500],"thread-166486":["thread",166486],"thread-166472":["thread",166472],"thread-166471":["thread",166471],"thread-166470":["thread",166470],"thread-166469":["thread",166469],"thread-166432":["thread",166432],"thread-166399":["thread",166399],"thread-166380":["thread",166380],"thread-166373":["thread",166373],"thread-166371":["thread",166371],"thread-166362":["thread",166362],"thread-166349":["thread",166349],"thread-166169":["thread",166169],"thread-166168":["thread",166168],"thread-166166":["thread",166166],"thread-166134":["thread",166134],"thread-166133":["thread",166133],"thread-166128":["thread",166128],"thread-166119":["thread",166119],"thread-166118":["thread",166118],"thread-166082":["thread",166082],"thread-166077":["thread",166077],"thread-166071":["thread",166071],"thread-166070":["thread",166070],"thread-166069":["thread",166069],"thread-166067":["thread",166067],"thread-166066":["thread",166066],"thread-166042":["thread",166042],"thread-166041":["thread",166041],"thread-165990":["thread",165990],"thread-165981":["thread",165981],"thread-165961":["thread",165961],"thread-165950":["thread",165950],"thread-165703":["thread",165703],"thread-165430":["thread",165430],"thread-165429":["thread",165429],"thread-165428":["thread",165428],"thread-165427":["thread",165427],"thread-165423":["thread",165423],"thread-165422":["thread",165422],"thread-164419":["thread",164419],"thread-164295":["thread",164295],"thread-164267":["thread",164267],"thread-163773":["thread",163773],"thread-163674":["thread",163674],"thread-163044":["thread",163044],"thread-162542":["thread",162542],"thread-162262":["thread",162262],"thread-162234":["thread",162234],"thread-161792":["thread",161792],"thread-161791":["thread",161791],"thread-161790":["thread",161790],"thread-161788":["thread",161788],"thread-161787":["thread",161787],"thread-161694":["thread",161694],"thread-161440":["thread",161440],"thread-161227":["thread",161227],"thread-161215":["thread",161215],"thread-160928":["thread",160928],"thread-160370":["thread",160370],"thread-160193":["thread",160193],"thread-160142":["thread",160142],"thread-160062":["thread",160062],"thread-159967":["thread",159967],"thread-159965":["thread",159965],"thread-159910":["thread",159910],"thread-159784":["thread",159784],"thread-159776":["thread",159776],"thread-159775":["thread",159775],"thread-159758":["thread",159758],"thread-159757":["thread",159757],"thread-159756":["thread",159756],"thread-159735":["thread",159735],"thread-159732":["thread",159732],"thread-159492":["thread",159492],"thread-159436":["thread",159436],"thread-159030":["thread",159030],"thread-158990":["thread",158990],"thread-158894":["thread",158894],"thread-158824":["thread",158824],"thread-158731":["thread",158731],"thread-158687":["thread",158687],"thread-158567":["thread",158567],"thread-158474":["thread",158474],"thread-158440":["thread",158440],"thread-158438":["thread",158438],"thread-158427":["thread",158427],"thread-158392":["thread",158392],"thread-158391":["thread",158391],"thread-158362":["thread",158362],"thread-158361":["thread",158361],"thread-158130":["thread",158130],"thread-158066":["thread",158066],"thread-157861":["thread",157861],"thread-157859":["thread",157859],"thread-157351":["thread",157351],"thread-157305":["thread",157305],"thread-157303":["thread",157303],"thread-156775":["thread",156775],"thread-155673":["thread",155673],"thread-155268":["thread",155268],"thread-154836":["thread",154836],"thread-154618":["thread",154618],"thread-154114":["thread",154114],"thread-154110":["thread",154110],"thread-153975":["thread",153975],"thread-153539":["thread",153539],"thread-113463":["thread",113463],"thread-67852":["thread",67852]}, , 1715662114
Run Time: 0.000219
- 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