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 (183336, 183171, 182703, 182576, 182413, 182279, 181694, 181686, 181244, 180727, 180724, 180646, 180624, 180466, 180393, 180386, 179976, 179841, 179659, 179163, 178913, 178545, 177968, 177586, 177580, 177549, 177430, 177419, 177325, 177213, 176647, 176443, 175125, 174862, 174861, 174821, 174756, 174755, 171637, 171271, 170964, 170822, 168278, 166860, 166791, 166741, 166473, 166279, 165908, 165542, 165410, 165394, 165065, 163221, 162532, 162347, 162009, 160495, 160390, 159628, 159443, 159317, 158705, 158506, 157355, 157343, 157318, 157273, 156952, 156951, 155789, 155716, 155278, 154227, 154179, 154089, 153844, 152420, 152105, 151996, 137801, 137800, 136164, 134952, 134338, 131997, 126468, 114329, 112813, 109954, 88183, 86957, 76709, 69129, 68725, 68464, 68310, 64494, 61896, 53604, 15217, 14703))
Run Time: 0.065507
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 102 | 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: 2181, 0, 1716007222, {"thread-183336":["thread",183336],"thread-183171":["thread",183171],"thread-182703":["thread",182703],"thread-182576":["thread",182576],"thread-182413":["thread",182413],"thread-182279":["thread",182279],"thread-181694":["thread",181694],"thread-181686":["thread",181686],"thread-181244":["thread",181244],"thread-180727":["thread",180727],"thread-180724":["thread",180724],"thread-180646":["thread",180646],"thread-180624":["thread",180624],"thread-180466":["thread",180466],"thread-180393":["thread",180393],"thread-180386":["thread",180386],"thread-179976":["thread",179976],"thread-179841":["thread",179841],"thread-179659":["thread",179659],"thread-179163":["thread",179163],"thread-178913":["thread",178913],"thread-178545":["thread",178545],"thread-177968":["thread",177968],"thread-177586":["thread",177586],"thread-177580":["thread",177580],"thread-177549":["thread",177549],"thread-177430":["thread",177430],"thread-177419":["thread",177419],"thread-177325":["thread",177325],"thread-177213":["thread",177213],"thread-176647":["thread",176647],"thread-176443":["thread",176443],"thread-175125":["thread",175125],"thread-174862":["thread",174862],"thread-174861":["thread",174861],"thread-174821":["thread",174821],"thread-174756":["thread",174756],"thread-174755":["thread",174755],"thread-171637":["thread",171637],"thread-171271":["thread",171271],"thread-170964":["thread",170964],"thread-170822":["thread",170822],"thread-168278":["thread",168278],"thread-166860":["thread",166860],"thread-166791":["thread",166791],"thread-166741":["thread",166741],"thread-166473":["thread",166473],"thread-166279":["thread",166279],"thread-165908":["thread",165908],"thread-165542":["thread",165542],"thread-165410":["thread",165410],"thread-165394":["thread",165394],"thread-165065":["thread",165065],"thread-163221":["thread",163221],"thread-162532":["thread",162532],"thread-162347":["thread",162347],"thread-162009":["thread",162009],"thread-160495":["thread",160495],"thread-160390":["thread",160390],"thread-159628":["thread",159628],"thread-159443":["thread",159443],"thread-159317":["thread",159317],"thread-158705":["thread",158705],"thread-158506":["thread",158506],"thread-157355":["thread",157355],"thread-157343":["thread",157343],"thread-157318":["thread",157318],"thread-157273":["thread",157273],"thread-156952":["thread",156952],"thread-156951":["thread",156951],"thread-155789":["thread",155789],"thread-155716":["thread",155716],"thread-155278":["thread",155278],"thread-154227":["thread",154227],"thread-154179":["thread",154179],"thread-153844":["thread",153844],"thread-152420":["thread",152420],"thread-152105":["thread",152105],"thread-151996":["thread",151996],"thread-137801":["thread",137801],"thread-137800":["thread",137800],"thread-136164":["thread",136164],"thread-134952":["thread",134952],"thread-134338":["thread",134338],"thread-131997":["thread",131997],"thread-126468":["thread",126468],"thread-114329":["thread",114329],"thread-112813":["thread",112813],"thread-109954":["thread",109954],"thread-88183":["thread",88183],"thread-86957":["thread",86957],"thread-76709":["thread",76709],"thread-69129":["thread",69129],"thread-68725":["thread",68725],"thread-68464":["thread",68464],"thread-68310":["thread",68310],"thread-64494":["thread",64494],"thread-61896":["thread",61896],"thread-53604":["thread",53604],"thread-15217":["thread",15217],"thread-14703":["thread",14703]}, , 1716003622
Run Time: 0.000292
- 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