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 (183579, 182995, 182961, 182896, 182707, 182333, 181405, 180124, 178666, 178586, 176874, 176704, 176561, 173904, 173497, 172766, 171504, 171201, 170814, 170459, 170034, 169897, 169746, 169635, 169275, 168973, 168639, 168502, 167948, 166860, 166400, 165809, 165808, 164721, 163840, 163798, 163642, 163042, 159254, 159130, 158872, 158871, 158654, 158353, 158190, 158042, 157610, 157365, 156999, 156995, 156985, 156497, 156278, 156027, 155676, 155576, 155562, 155524, 153934, 153536, 153445, 153360, 153112, 153023, 152925, 152688, 152613, 152420, 152390, 152268, 151870, 143945, 131351, 130891, 129286, 128363, 126727, 123235, 121363, 120666, 117267, 105633, 103726, 101599, 101515, 101381, 100773, 82837, 78817, 78514, 77893, 73745, 72567, 64784, 61805, 61519, 35170, 30535))
Run Time: 0.052387
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 98 | 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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 812919
Params: 1716056678, {"thread-183579":["thread",183579],"thread-182995":["thread",182995],"thread-182961":["thread",182961],"thread-182896":["thread",182896],"thread-182707":["thread",182707],"thread-182333":["thread",182333],"thread-181405":["thread",181405],"thread-180124":["thread",180124],"thread-178666":["thread",178666],"thread-178586":["thread",178586],"thread-176874":["thread",176874],"thread-176704":["thread",176704],"thread-176561":["thread",176561],"thread-173904":["thread",173904],"thread-173497":["thread",173497],"thread-172766":["thread",172766],"thread-171504":["thread",171504],"thread-171201":["thread",171201],"thread-170814":["thread",170814],"thread-170459":["thread",170459],"thread-170034":["thread",170034],"thread-169897":["thread",169897],"thread-169746":["thread",169746],"thread-169635":["thread",169635],"thread-169275":["thread",169275],"thread-168973":["thread",168973],"thread-168639":["thread",168639],"thread-168502":["thread",168502],"thread-167948":["thread",167948],"thread-166860":["thread",166860],"thread-166400":["thread",166400],"thread-165809":["thread",165809],"thread-165808":["thread",165808],"thread-164721":["thread",164721],"thread-163840":["thread",163840],"thread-163798":["thread",163798],"thread-163642":["thread",163642],"thread-163042":["thread",163042],"thread-159254":["thread",159254],"thread-159130":["thread",159130],"thread-158872":["thread",158872],"thread-158871":["thread",158871],"thread-158654":["thread",158654],"thread-158353":["thread",158353],"thread-158190":["thread",158190],"thread-158042":["thread",158042],"thread-157610":["thread",157610],"thread-157365":["thread",157365],"thread-156999":["thread",156999],"thread-156995":["thread",156995],"thread-156985":["thread",156985],"thread-156497":["thread",156497],"thread-156278":["thread",156278],"thread-156027":["thread",156027],"thread-155676":["thread",155676],"thread-155576":["thread",155576],"thread-155562":["thread",155562],"thread-155524":["thread",155524],"thread-153934":["thread",153934],"thread-153536":["thread",153536],"thread-153445":["thread",153445],"thread-153360":["thread",153360],"thread-153112":["thread",153112],"thread-153023":["thread",153023],"thread-152925":["thread",152925],"thread-152688":["thread",152688],"thread-152613":["thread",152613],"thread-152420":["thread",152420],"thread-152390":["thread",152390],"thread-152268":["thread",152268],"thread-151870":["thread",151870],"thread-143945":["thread",143945],"thread-131351":["thread",131351],"thread-130891":["thread",130891],"thread-129286":["thread",129286],"thread-128363":["thread",128363],"thread-126727":["thread",126727],"thread-123235":["thread",123235],"thread-121363":["thread",121363],"thread-120666":["thread",120666],"thread-117267":["thread",117267],"thread-105633":["thread",105633],"thread-103726":["thread",103726],"thread-101599":["thread",101599],"thread-101515":["thread",101515],"thread-101381":["thread",101381],"thread-100773":["thread",100773],"thread-82837":["thread",82837],"thread-78817":["thread",78817],"thread-78514":["thread",78514],"thread-77893":["thread",77893],"thread-73745":["thread",73745],"thread-72567":["thread",72567],"thread-64784":["thread",64784],"thread-61805":["thread",61805],"thread-61519":["thread",61519],"thread-35170":["thread",35170],"thread-30535":["thread",30535]}
Run Time: 0.000312
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1519
- 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