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 (182320, 182244, 181616, 181205, 181131, 180201, 179895, 179139, 179137, 177839, 177641, 176560, 176099, 176079, 175818, 175412, 174825, 174590, 174226, 173825, 173490, 172442, 172104, 171600, 171534, 171135, 171105, 170534, 170335, 170172, 170096, 169913, 169815, 169556, 168814, 168749, 168382, 167935, 167402, 167388, 166615, 165956, 165786, 165667, 165655, 165513, 165309, 164957, 164422, 163643, 162974, 162770, 162566, 161907, 161900, 161771, 161664, 161491, 160916, 160477, 160191, 160123, 159997, 159521, 158830, 158613, 158514, 158090, 157846, 156548, 156284, 155265, 154842, 154779, 154604, 154603, 154453, 152357, 152200, 151987, 124603, 99999, 73997, 72965))
Run Time: 0.045336
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 84 | 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: 14252, 0, 1714754232, {"thread-182320":["thread",182320],"thread-182244":["thread",182244],"thread-181616":["thread",181616],"thread-181205":["thread",181205],"thread-181131":["thread",181131],"thread-180201":["thread",180201],"thread-179895":["thread",179895],"thread-179139":["thread",179139],"thread-179137":["thread",179137],"thread-177839":["thread",177839],"thread-177641":["thread",177641],"thread-176560":["thread",176560],"thread-176099":["thread",176099],"thread-176079":["thread",176079],"thread-175818":["thread",175818],"thread-175412":["thread",175412],"thread-174825":["thread",174825],"thread-174590":["thread",174590],"thread-174226":["thread",174226],"thread-173825":["thread",173825],"thread-173490":["thread",173490],"thread-172442":["thread",172442],"thread-172104":["thread",172104],"thread-171600":["thread",171600],"thread-171534":["thread",171534],"thread-171135":["thread",171135],"thread-171105":["thread",171105],"thread-170534":["thread",170534],"thread-170335":["thread",170335],"thread-170172":["thread",170172],"thread-170096":["thread",170096],"thread-169913":["thread",169913],"thread-169815":["thread",169815],"thread-169556":["thread",169556],"thread-168814":["thread",168814],"thread-168749":["thread",168749],"thread-168382":["thread",168382],"thread-167935":["thread",167935],"thread-167402":["thread",167402],"thread-167388":["thread",167388],"thread-166615":["thread",166615],"thread-165956":["thread",165956],"thread-165786":["thread",165786],"thread-165667":["thread",165667],"thread-165655":["thread",165655],"thread-165513":["thread",165513],"thread-165309":["thread",165309],"thread-164957":["thread",164957],"thread-164422":["thread",164422],"thread-163643":["thread",163643],"thread-162974":["thread",162974],"thread-162770":["thread",162770],"thread-162566":["thread",162566],"thread-161907":["thread",161907],"thread-161900":["thread",161900],"thread-161771":["thread",161771],"thread-161664":["thread",161664],"thread-161491":["thread",161491],"thread-160916":["thread",160916],"thread-160477":["thread",160477],"thread-160191":["thread",160191],"thread-160123":["thread",160123],"thread-159997":["thread",159997],"thread-159521":["thread",159521],"thread-158830":["thread",158830],"thread-158613":["thread",158613],"thread-158514":["thread",158514],"thread-158090":["thread",158090],"thread-157846":["thread",157846],"thread-156548":["thread",156548],"thread-156284":["thread",156284],"thread-155265":["thread",155265],"thread-154842":["thread",154842],"thread-154779":["thread",154779],"thread-154604":["thread",154604],"thread-154603":["thread",154603],"thread-154453":["thread",154453],"thread-152357":["thread",152357],"thread-152200":["thread",152200],"thread-151987":["thread",151987],"thread-124603":["thread",124603],"thread-99999":["thread",99999],"thread-73997":["thread",73997],"thread-72965":["thread",72965]}, , 1714750632
Run Time: 0.000463
- 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