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 (183485, 183300, 182893, 182848, 182157, 182065, 181707, 180573, 180462, 180442, 179992, 179864, 179762, 179714, 179651, 179612, 179215, 178249, 178247, 177512, 177435, 177095, 176970, 176787, 176584, 176394, 176218, 175842, 175697, 175180, 174599, 174484, 174074, 173707, 173518, 173499, 173369, 173346, 173291, 172899, 172768, 172657, 172628, 172369, 172135, 171709, 171468, 171146, 171099, 170908, 170802, 170626, 170389, 170311, 170270, 169779, 169677, 169338, 169185, 168944, 168744, 168380, 168220, 168213, 167332, 167079, 166987, 166751, 166271, 166219, 166202, 165908, 165834, 165758, 165755, 165375, 164613, 164566, 164477, 164150, 164008, 163548, 163467, 162625, 162550, 162282, 162123, 161563, 161265, 161114, 160505, 160424, 159521, 159064, 158285, 158243, 158181, 157759, 156552, 156482, 156396, 155777, 155604, 155511, 155163, 155088, 155045, 153749, 153457, 153270, 152482, 152119, 84231, 58683, 53856))
Run Time: 0.048087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 115 | 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: 8817, 0, 1716063448, {"thread-183485":["thread",183485],"thread-183300":["thread",183300],"thread-182893":["thread",182893],"thread-182848":["thread",182848],"thread-182157":["thread",182157],"thread-182065":["thread",182065],"thread-181707":["thread",181707],"thread-180573":["thread",180573],"thread-180462":["thread",180462],"thread-180442":["thread",180442],"thread-179992":["thread",179992],"thread-179864":["thread",179864],"thread-179762":["thread",179762],"thread-179714":["thread",179714],"thread-179651":["thread",179651],"thread-179612":["thread",179612],"thread-179215":["thread",179215],"thread-178249":["thread",178249],"thread-178247":["thread",178247],"thread-177512":["thread",177512],"thread-177435":["thread",177435],"thread-177095":["thread",177095],"thread-176970":["thread",176970],"thread-176787":["thread",176787],"thread-176584":["thread",176584],"thread-176394":["thread",176394],"thread-176218":["thread",176218],"thread-175842":["thread",175842],"thread-175697":["thread",175697],"thread-175180":["thread",175180],"thread-174599":["thread",174599],"thread-174484":["thread",174484],"thread-174074":["thread",174074],"thread-173707":["thread",173707],"thread-173518":["thread",173518],"thread-173499":["thread",173499],"thread-173369":["thread",173369],"thread-173346":["thread",173346],"thread-173291":["thread",173291],"thread-172899":["thread",172899],"thread-172768":["thread",172768],"thread-172657":["thread",172657],"thread-172628":["thread",172628],"thread-172369":["thread",172369],"thread-172135":["thread",172135],"thread-171709":["thread",171709],"thread-171468":["thread",171468],"thread-171146":["thread",171146],"thread-171099":["thread",171099],"thread-170908":["thread",170908],"thread-170802":["thread",170802],"thread-170626":["thread",170626],"thread-170389":["thread",170389],"thread-170311":["thread",170311],"thread-170270":["thread",170270],"thread-169779":["thread",169779],"thread-169677":["thread",169677],"thread-169338":["thread",169338],"thread-169185":["thread",169185],"thread-168944":["thread",168944],"thread-168744":["thread",168744],"thread-168380":["thread",168380],"thread-168220":["thread",168220],"thread-168213":["thread",168213],"thread-167332":["thread",167332],"thread-167079":["thread",167079],"thread-166987":["thread",166987],"thread-166751":["thread",166751],"thread-166271":["thread",166271],"thread-166219":["thread",166219],"thread-166202":["thread",166202],"thread-165908":["thread",165908],"thread-165834":["thread",165834],"thread-165758":["thread",165758],"thread-165755":["thread",165755],"thread-165375":["thread",165375],"thread-164613":["thread",164613],"thread-164566":["thread",164566],"thread-164477":["thread",164477],"thread-164150":["thread",164150],"thread-164008":["thread",164008],"thread-163548":["thread",163548],"thread-163467":["thread",163467],"thread-162625":["thread",162625],"thread-162550":["thread",162550],"thread-162282":["thread",162282],"thread-162123":["thread",162123],"thread-161563":["thread",161563],"thread-161265":["thread",161265],"thread-161114":["thread",161114],"thread-160505":["thread",160505],"thread-160424":["thread",160424],"thread-159521":["thread",159521],"thread-159064":["thread",159064],"thread-158285":["thread",158285],"thread-158243":["thread",158243],"thread-158181":["thread",158181],"thread-157759":["thread",157759],"thread-156552":["thread",156552],"thread-156482":["thread",156482],"thread-156396":["thread",156396],"thread-155777":["thread",155777],"thread-155604":["thread",155604],"thread-155511":["thread",155511],"thread-155163":["thread",155163],"thread-155088":["thread",155088],"thread-155045":["thread",155045],"thread-153749":["thread",153749],"thread-153457":["thread",153457],"thread-153270":["thread",153270],"thread-152482":["thread",152482],"thread-152119":["thread",152119],"thread-84231":["thread",84231],"thread-58683":["thread",58683],"thread-53856":["thread",53856]}, , 1716059848
Run Time: 0.000220
- 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