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 (183057, 182978, 182863, 182757, 181987, 181340, 181198, 181082, 179842, 179804, 179388, 179072, 178801, 178799, 178231, 177726, 177725, 177723, 177617, 177594, 177388, 176233, 175861, 174813, 174750, 174735, 174645, 174606, 174400, 174064, 173314, 173189, 173121, 171741, 171583, 171545, 171232, 170852, 170645, 170510, 170172, 170153, 169906, 169877, 169763, 168897, 168729, 168415, 168254, 168089, 167480, 166858, 166564, 166466, 166450, 166312, 165390, 165387, 165385, 165383, 165382, 164865, 164347, 164009, 163798, 163089, 162944, 162917, 162325, 162097, 162095, 161419, 161346, 161138, 160927, 160920, 160912, 160817, 160698, 160241, 159635, 159420, 159289, 158901, 158326, 157313, 156732, 156729, 156708, 156697, 156695, 156694, 156678, 156286, 156136, 155432, 155419, 155416, 155412, 155411, 154880, 154730, 153747, 153651, 153624, 153616, 153565, 153278, 152775, 152481, 151768, 151688, 125294, 114434, 49941, 38019, 162))
Run Time: 0.056725
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 117 | 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: 15, 0, 1714818150, {"thread-183057":["thread",183057],"thread-182978":["thread",182978],"thread-182863":["thread",182863],"thread-182757":["thread",182757],"thread-181987":["thread",181987],"thread-181340":["thread",181340],"thread-181198":["thread",181198],"thread-181082":["thread",181082],"thread-179842":["thread",179842],"thread-179804":["thread",179804],"thread-179388":["thread",179388],"thread-179072":["thread",179072],"thread-178801":["thread",178801],"thread-178799":["thread",178799],"thread-178231":["thread",178231],"thread-177726":["thread",177726],"thread-177725":["thread",177725],"thread-177723":["thread",177723],"thread-177617":["thread",177617],"thread-177594":["thread",177594],"thread-177388":["thread",177388],"thread-176233":["thread",176233],"thread-175861":["thread",175861],"thread-174813":["thread",174813],"thread-174750":["thread",174750],"thread-174735":["thread",174735],"thread-174645":["thread",174645],"thread-174606":["thread",174606],"thread-174400":["thread",174400],"thread-174064":["thread",174064],"thread-173314":["thread",173314],"thread-173189":["thread",173189],"thread-173121":["thread",173121],"thread-171741":["thread",171741],"thread-171583":["thread",171583],"thread-171545":["thread",171545],"thread-171232":["thread",171232],"thread-170852":["thread",170852],"thread-170645":["thread",170645],"thread-170510":["thread",170510],"thread-170172":["thread",170172],"thread-170153":["thread",170153],"thread-169906":["thread",169906],"thread-169877":["thread",169877],"thread-169763":["thread",169763],"thread-168897":["thread",168897],"thread-168729":["thread",168729],"thread-168415":["thread",168415],"thread-168254":["thread",168254],"thread-168089":["thread",168089],"thread-167480":["thread",167480],"thread-166858":["thread",166858],"thread-166564":["thread",166564],"thread-166466":["thread",166466],"thread-166450":["thread",166450],"thread-166312":["thread",166312],"thread-165390":["thread",165390],"thread-165387":["thread",165387],"thread-165385":["thread",165385],"thread-165383":["thread",165383],"thread-165382":["thread",165382],"thread-164865":["thread",164865],"thread-164347":["thread",164347],"thread-164009":["thread",164009],"thread-163798":["thread",163798],"thread-163089":["thread",163089],"thread-162944":["thread",162944],"thread-162917":["thread",162917],"thread-162325":["thread",162325],"thread-162097":["thread",162097],"thread-162095":["thread",162095],"thread-161419":["thread",161419],"thread-161346":["thread",161346],"thread-161138":["thread",161138],"thread-160927":["thread",160927],"thread-160920":["thread",160920],"thread-160912":["thread",160912],"thread-160817":["thread",160817],"thread-160698":["thread",160698],"thread-160241":["thread",160241],"thread-159635":["thread",159635],"thread-159420":["thread",159420],"thread-159289":["thread",159289],"thread-158901":["thread",158901],"thread-158326":["thread",158326],"thread-157313":["thread",157313],"thread-156732":["thread",156732],"thread-156729":["thread",156729],"thread-156708":["thread",156708],"thread-156697":["thread",156697],"thread-156695":["thread",156695],"thread-156694":["thread",156694],"thread-156678":["thread",156678],"thread-156286":["thread",156286],"thread-156136":["thread",156136],"thread-155432":["thread",155432],"thread-155419":["thread",155419],"thread-155416":["thread",155416],"thread-155412":["thread",155412],"thread-155411":["thread",155411],"thread-154880":["thread",154880],"thread-154730":["thread",154730],"thread-153747":["thread",153747],"thread-153651":["thread",153651],"thread-153624":["thread",153624],"thread-153616":["thread",153616],"thread-153565":["thread",153565],"thread-153278":["thread",153278],"thread-152775":["thread",152775],"thread-152481":["thread",152481],"thread-151768":["thread",151768],"thread-151688":["thread",151688],"thread-125294":["thread",125294],"thread-114434":["thread",114434],"thread-49941":["thread",49941],"thread-38019":["thread",38019],"thread-162":["thread",162]}, , 1714814550
Run Time: 0.000369
- 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