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 (86471, 86172, 81347, 81337, 80824, 80813, 80563, 79995, 78608, 78420, 77561, 73585, 73323, 73263, 73262, 73209, 72206, 72116, 72115, 69228, 69128, 69119, 69076, 68598, 68462, 68252, 66759, 65641, 65573, 65571, 65310, 65308, 65179, 65151, 65132, 65004, 64764, 62770, 62542, 62407, 62400, 62390, 62267, 62229, 62035, 62030, 61801, 61527, 61312, 61308, 61235, 61214, 60912, 60164, 59874, 59520, 59181, 59180, 59018, 59009, 59008, 58973, 58877, 58837, 58802, 58765, 58571, 58368, 58319, 58311, 58206, 58139, 58021, 58014, 57954, 57952, 57941, 57881, 57812, 57788, 57563, 57558, 57455, 57453, 57427, 57380, 57179, 57144, 57042, 57007, 57004, 56963, 56962, 56938, 56927, 56884, 56879, 56696, 56601))
Run Time: 0.058210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 99 | 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: 9495, 0, 1716092582, {"thread-86471":["thread",86471],"thread-86172":["thread",86172],"thread-81347":["thread",81347],"thread-81337":["thread",81337],"thread-80824":["thread",80824],"thread-80813":["thread",80813],"thread-80563":["thread",80563],"thread-79995":["thread",79995],"thread-78608":["thread",78608],"thread-78420":["thread",78420],"thread-77561":["thread",77561],"thread-73585":["thread",73585],"thread-73323":["thread",73323],"thread-73263":["thread",73263],"thread-73262":["thread",73262],"thread-73209":["thread",73209],"thread-72206":["thread",72206],"thread-72116":["thread",72116],"thread-72115":["thread",72115],"thread-69228":["thread",69228],"thread-69128":["thread",69128],"thread-69119":["thread",69119],"thread-69076":["thread",69076],"thread-68598":["thread",68598],"thread-68462":["thread",68462],"thread-68252":["thread",68252],"thread-66759":["thread",66759],"thread-65641":["thread",65641],"thread-65573":["thread",65573],"thread-65571":["thread",65571],"thread-65310":["thread",65310],"thread-65308":["thread",65308],"thread-65179":["thread",65179],"thread-65151":["thread",65151],"thread-65132":["thread",65132],"thread-65004":["thread",65004],"thread-64764":["thread",64764],"thread-62770":["thread",62770],"thread-62542":["thread",62542],"thread-62407":["thread",62407],"thread-62400":["thread",62400],"thread-62390":["thread",62390],"thread-62267":["thread",62267],"thread-62229":["thread",62229],"thread-62035":["thread",62035],"thread-62030":["thread",62030],"thread-61801":["thread",61801],"thread-61527":["thread",61527],"thread-61312":["thread",61312],"thread-61308":["thread",61308],"thread-61235":["thread",61235],"thread-61214":["thread",61214],"thread-60912":["thread",60912],"thread-60164":["thread",60164],"thread-59874":["thread",59874],"thread-59520":["thread",59520],"thread-59181":["thread",59181],"thread-59180":["thread",59180],"thread-59018":["thread",59018],"thread-59009":["thread",59009],"thread-59008":["thread",59008],"thread-58973":["thread",58973],"thread-58877":["thread",58877],"thread-58837":["thread",58837],"thread-58802":["thread",58802],"thread-58765":["thread",58765],"thread-58571":["thread",58571],"thread-58368":["thread",58368],"thread-58319":["thread",58319],"thread-58311":["thread",58311],"thread-58206":["thread",58206],"thread-58139":["thread",58139],"thread-58021":["thread",58021],"thread-58014":["thread",58014],"thread-57954":["thread",57954],"thread-57952":["thread",57952],"thread-57941":["thread",57941],"thread-57881":["thread",57881],"thread-57812":["thread",57812],"thread-57788":["thread",57788],"thread-57563":["thread",57563],"thread-57558":["thread",57558],"thread-57455":["thread",57455],"thread-57453":["thread",57453],"thread-57427":["thread",57427],"thread-57380":["thread",57380],"thread-57179":["thread",57179],"thread-57144":["thread",57144],"thread-57042":["thread",57042],"thread-57007":["thread",57007],"thread-57004":["thread",57004],"thread-56963":["thread",56963],"thread-56962":["thread",56962],"thread-56938":["thread",56938],"thread-56927":["thread",56927],"thread-56884":["thread",56884],"thread-56879":["thread",56879],"thread-56696":["thread",56696],"thread-56601":["thread",56601]}, , 1716088982
Run Time: 0.000396
- 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