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 (183976, 183937, 183663, 183599, 183532, 183506, 183409, 183104, 183083, 183005, 183001, 182938, 182858, 182825, 182787, 182692, 182365, 182343, 181943, 181941, 181896, 181891, 181837, 181512, 181508, 181472, 181411, 181402, 181273, 181118, 181086, 181009, 180900, 180756, 180742, 180465, 180456, 180212, 180170, 180043, 179993, 179988, 179904, 179854, 179759, 179743, 179708, 179704, 179698, 179683, 179611, 179202, 179186, 179184, 179144, 179093, 178976, 178913, 178843, 178830, 178652, 178650, 178270, 178190, 178116, 178074, 178061, 177928, 177864, 177745, 177705, 177633, 177586, 177343, 177335, 177313, 176827, 176797, 176710, 176663, 176514, 176456, 176454, 176449, 176413, 176404, 176372, 176332, 176208, 176200, 176178, 176077, 176055, 175995, 175978, 175687, 175624, 175609, 175562, 175490, 175486, 175290, 175263, 175258, 175140, 175081, 175035, 174961, 174944, 174884, 174879, 174871, 174805, 174797, 174741, 174687, 174559, 174557, 174519, 174494, 174473, 174453, 174452, 174426, 174394, 174354, 174301, 174297, 174282, 174267, 174250, 174184, 174126, 173993, 173867, 173822, 173768, 173698, 173549, 173542, 173469, 173401, 173223, 173143, 173100, 172999, 172623, 172494, 172429, 172291, 172165, 172015, 172013, 172003, 171940, 171818, 171788, 171694, 171601, 171527, 171516, 171514, 171336, 171315, 171087, 171086, 171078, 170962, 170858, 170848, 170803, 170775, 170748, 170703, 170623, 170603, 170553, 170547, 170522, 170520, 170490, 170482, 170380, 170333, 170303, 170284, 170264, 170206, 170180, 170170, 170148, 170100, 170083, 169861, 169796, 169381, 169367, 169354, 169319, 169281))
Run Time: 0.063220
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: 1248, 0, 1717042275, {"thread-183976":["thread",183976],"thread-183937":["thread",183937],"thread-183663":["thread",183663],"thread-183599":["thread",183599],"thread-183532":["thread",183532],"thread-183506":["thread",183506],"thread-183409":["thread",183409],"thread-183104":["thread",183104],"thread-183083":["thread",183083],"thread-183005":["thread",183005],"thread-183001":["thread",183001],"thread-182938":["thread",182938],"thread-182858":["thread",182858],"thread-182825":["thread",182825],"thread-182787":["thread",182787],"thread-182692":["thread",182692],"thread-182365":["thread",182365],"thread-182343":["thread",182343],"thread-181943":["thread",181943],"thread-181941":["thread",181941],"thread-181896":["thread",181896],"thread-181891":["thread",181891],"thread-181837":["thread",181837],"thread-181512":["thread",181512],"thread-181508":["thread",181508],"thread-181472":["thread",181472],"thread-181411":["thread",181411],"thread-181402":["thread",181402],"thread-181273":["thread",181273],"thread-181118":["thread",181118],"thread-181086":["thread",181086],"thread-181009":["thread",181009],"thread-180900":["thread",180900],"thread-180756":["thread",180756],"thread-180742":["thread",180742],"thread-180465":["thread",180465],"thread-180456":["thread",180456],"thread-180212":["thread",180212],"thread-180170":["thread",180170],"thread-180043":["thread",180043],"thread-179993":["thread",179993],"thread-179988":["thread",179988],"thread-179904":["thread",179904],"thread-179854":["thread",179854],"thread-179759":["thread",179759],"thread-179743":["thread",179743],"thread-179708":["thread",179708],"thread-179704":["thread",179704],"thread-179698":["thread",179698],"thread-179683":["thread",179683],"thread-179611":["thread",179611],"thread-179202":["thread",179202],"thread-179186":["thread",179186],"thread-179184":["thread",179184],"thread-179144":["thread",179144],"thread-179093":["thread",179093],"thread-178976":["thread",178976],"thread-178913":["thread",178913],"thread-178843":["thread",178843],"thread-178830":["thread",178830],"thread-178652":["thread",178652],"thread-178650":["thread",178650],"thread-178270":["thread",178270],"thread-178190":["thread",178190],"thread-178116":["thread",178116],"thread-178074":["thread",178074],"thread-178061":["thread",178061],"thread-177928":["thread",177928],"thread-177864":["thread",177864],"thread-177745":["thread",177745],"thread-177705":["thread",177705],"thread-177633":["thread",177633],"thread-177586":["thread",177586],"thread-177343":["thread",177343],"thread-177335":["thread",177335],"thread-177313":["thread",177313],"thread-176827":["thread",176827],"thread-176797":["thread",176797],"thread-176710":["thread",176710],"thread-176663":["thread",176663],"thread-176514":["thread",176514],"thread-176456":["thread",176456],"thread-176454":["thread",176454],"thread-176449":["thread",176449],"thread-176413":["thread",176413],"thread-176404":["thread",176404],"thread-176372":["thread",176372],"thread-176332":["thread",176332],"thread-176208":["thread",176208],"thread-176200":["thread",176200],"thread-176178":["thread",176178],"thread-176077":["thread",176077],"thread-176055":["thread",176055],"thread-175995":["thread",175995],"thread-175978":["thread",175978],"thread-175687":["thread",175687],"thread-175624":["thread",175624],"thread-175609":["thread",175609],"thread-175562":["thread",175562],"thread-175490":["thread",175490],"thread-175486":["thread",175486],"thread-175290":["thread",175290],"thread-175263":["thread",175263],"thread-175258":["thread",175258],"thread-175140":["thread",175140],"thread-175081":["thread",175081],"thread-175035":["thread",175035],"thread-174961":["thread",174961],"thread-174944":["thread",174944],"thread-174884":["thread",174884],"thread-174879":["thread",174879],"thread-174871":["thread",174871],"thread-174805":["thread",174805],"thread-174797":["thread",174797],"thread-174741":["thread",174741],"thread-174687":["thread",174687],"thread-174559":["thread",174559],"thread-174557":["thread",174557],"thread-174519":["thread",174519],"thread-174494":["thread",174494],"thread-174473":["thread",174473],"thread-174453":["thread",174453],"thread-174452":["thread",174452],"thread-174426":["thread",174426],"thread-174394":["thread",174394],"thread-174354":["thread",174354],"thread-174301":["thread",174301],"thread-174297":["thread",174297],"thread-174282":["thread",174282],"thread-174267":["thread",174267],"thread-174250":["thread",174250],"thread-174184":["thread",174184],"thread-174126":["thread",174126],"thread-173993":["thread",173993],"thread-173867":["thread",173867],"thread-173822":["thread",173822],"thread-173768":["thread",173768],"thread-173698":["thread",173698],"thread-173549":["thread",173549],"thread-173542":["thread",173542],"thread-173469":["thread",173469],"thread-173401":["thread",173401],"thread-173223":["thread",173223],"thread-173143":["thread",173143],"thread-173100":["thread",173100],"thread-172999":["thread",172999],"thread-172623":["thread",172623],"thread-172494":["thread",172494],"thread-172429":["thread",172429],"thread-172291":["thread",172291],"thread-172165":["thread",172165],"thread-172015":["thread",172015],"thread-172013":["thread",172013],"thread-172003":["thread",172003],"thread-171940":["thread",171940],"thread-171818":["thread",171818],"thread-171788":["thread",171788],"thread-171694":["thread",171694],"thread-171601":["thread",171601],"thread-171527":["thread",171527],"thread-171516":["thread",171516],"thread-171514":["thread",171514],"thread-171336":["thread",171336],"thread-171315":["thread",171315],"thread-171087":["thread",171087],"thread-171086":["thread",171086],"thread-171078":["thread",171078],"thread-170962":["thread",170962],"thread-170858":["thread",170858],"thread-170848":["thread",170848],"thread-170803":["thread",170803],"thread-170775":["thread",170775],"thread-170748":["thread",170748],"thread-170703":["thread",170703],"thread-170623":["thread",170623],"thread-170603":["thread",170603],"thread-170553":["thread",170553],"thread-170547":["thread",170547],"thread-170522":["thread",170522],"thread-170520":["thread",170520],"thread-170490":["thread",170490],"thread-170482":["thread",170482],"thread-170380":["thread",170380],"thread-170333":["thread",170333],"thread-170303":["thread",170303],"thread-170284":["thread",170284],"thread-170264":["thread",170264],"thread-170206":["thread",170206],"thread-170180":["thread",170180],"thread-170170":["thread",170170],"thread-170148":["thread",170148],"thread-170100":["thread",170100],"thread-170083":["thread",170083],"thread-169861":["thread",169861],"thread-169796":["thread",169796],"thread-169381":["thread",169381],"thread-169367":["thread",169367],"thread-169354":["thread",169354],"thread-169319":["thread",169319],"thread-169281":["thread",169281]}, , 1717038675
Run Time: 0.000223
- 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