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 (159120, 125208, 123896, 93394, 86172, 81469, 81402, 81394, 81347, 80563, 79969, 78608, 78462, 78420, 77561, 77366, 73585, 73209, 72896, 72206, 72116, 72115, 69266, 69228, 69128, 69119, 69076, 69061, 69006, 68729, 68598, 68270, 68209, 65641, 65573, 65571, 65360, 65319, 65310, 65308, 65179, 65151, 65108, 65033, 65004, 64793, 64764, 64431, 64410, 64093, 63318, 63170, 62969, 62770, 62732, 62549, 62542, 62390, 62358, 62267, 62229, 62227, 62191, 62035, 62030, 61801, 61800, 61527, 61351, 61269, 61235, 60912, 60064, 59874, 59520, 59181, 59179, 59018, 59009, 59008, 58973, 58877, 58837, 58802, 58765, 58647, 58368, 58319, 58311, 58206, 58139, 58034, 58021, 58014, 57968, 57941, 57881, 57812, 57666, 57661, 57660, 57563, 57529, 57258, 57144, 56962, 56957, 56927, 56906, 56879, 56727, 56696, 56609, 56601, 56533, 56527, 56502, 56458, 56437))
Run Time: 0.054070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 119 | 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: 9443, 0, 1716095421, {"thread-159120":["thread",159120],"thread-125208":["thread",125208],"thread-123896":["thread",123896],"thread-93394":["thread",93394],"thread-86172":["thread",86172],"thread-81469":["thread",81469],"thread-81402":["thread",81402],"thread-81394":["thread",81394],"thread-81347":["thread",81347],"thread-80563":["thread",80563],"thread-79969":["thread",79969],"thread-78608":["thread",78608],"thread-78462":["thread",78462],"thread-78420":["thread",78420],"thread-77561":["thread",77561],"thread-77366":["thread",77366],"thread-73585":["thread",73585],"thread-73209":["thread",73209],"thread-72896":["thread",72896],"thread-72206":["thread",72206],"thread-72116":["thread",72116],"thread-72115":["thread",72115],"thread-69266":["thread",69266],"thread-69228":["thread",69228],"thread-69128":["thread",69128],"thread-69119":["thread",69119],"thread-69076":["thread",69076],"thread-69061":["thread",69061],"thread-69006":["thread",69006],"thread-68729":["thread",68729],"thread-68598":["thread",68598],"thread-68270":["thread",68270],"thread-68209":["thread",68209],"thread-65641":["thread",65641],"thread-65573":["thread",65573],"thread-65571":["thread",65571],"thread-65360":["thread",65360],"thread-65319":["thread",65319],"thread-65310":["thread",65310],"thread-65308":["thread",65308],"thread-65179":["thread",65179],"thread-65151":["thread",65151],"thread-65108":["thread",65108],"thread-65033":["thread",65033],"thread-65004":["thread",65004],"thread-64793":["thread",64793],"thread-64764":["thread",64764],"thread-64431":["thread",64431],"thread-64410":["thread",64410],"thread-64093":["thread",64093],"thread-63318":["thread",63318],"thread-63170":["thread",63170],"thread-62969":["thread",62969],"thread-62770":["thread",62770],"thread-62732":["thread",62732],"thread-62549":["thread",62549],"thread-62542":["thread",62542],"thread-62390":["thread",62390],"thread-62358":["thread",62358],"thread-62267":["thread",62267],"thread-62229":["thread",62229],"thread-62227":["thread",62227],"thread-62191":["thread",62191],"thread-62035":["thread",62035],"thread-62030":["thread",62030],"thread-61801":["thread",61801],"thread-61800":["thread",61800],"thread-61527":["thread",61527],"thread-61351":["thread",61351],"thread-61269":["thread",61269],"thread-61235":["thread",61235],"thread-60912":["thread",60912],"thread-60064":["thread",60064],"thread-59874":["thread",59874],"thread-59520":["thread",59520],"thread-59181":["thread",59181],"thread-59179":["thread",59179],"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-58647":["thread",58647],"thread-58368":["thread",58368],"thread-58319":["thread",58319],"thread-58311":["thread",58311],"thread-58206":["thread",58206],"thread-58139":["thread",58139],"thread-58034":["thread",58034],"thread-58021":["thread",58021],"thread-58014":["thread",58014],"thread-57968":["thread",57968],"thread-57941":["thread",57941],"thread-57881":["thread",57881],"thread-57812":["thread",57812],"thread-57666":["thread",57666],"thread-57661":["thread",57661],"thread-57660":["thread",57660],"thread-57563":["thread",57563],"thread-57529":["thread",57529],"thread-57258":["thread",57258],"thread-57144":["thread",57144],"thread-56962":["thread",56962],"thread-56957":["thread",56957],"thread-56927":["thread",56927],"thread-56906":["thread",56906],"thread-56879":["thread",56879],"thread-56727":["thread",56727],"thread-56696":["thread",56696],"thread-56609":["thread",56609],"thread-56601":["thread",56601],"thread-56533":["thread",56533],"thread-56527":["thread",56527],"thread-56502":["thread",56502],"thread-56458":["thread",56458],"thread-56437":["thread",56437]}, , 1716091821
Run Time: 0.000793
- 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