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 (183405, 182557, 182253, 181571, 181534, 181236, 181179, 180805, 180774, 180436, 180180, 180100, 179954, 179910, 179899, 179718, 179599, 179238, 179140, 179001, 177965, 177819, 177279, 176902, 176849, 176232, 175285, 174671, 174660, 174249, 172413, 172124, 172100, 171870, 171199, 170795, 170683, 170533, 170207, 169734, 169602, 169435, 169340, 169274, 169107, 169058, 168957, 168698, 167933, 167866, 167849, 167752, 167407, 167049, 166667, 166600, 165148, 165046, 164926, 164849, 164670, 164049, 162959, 162615, 161876, 161187, 160633, 159902, 159552, 159517, 159325, 158733, 158686, 158377, 158292, 158167, 158025, 157730, 157721, 157427, 157255, 156949, 156443, 155228, 153873, 153013, 152970, 75975, 50328))
Run Time: 0.044341
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 89 | 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: 7888, 0, 1716028092, {"thread-183405":["thread",183405],"thread-182557":["thread",182557],"thread-182253":["thread",182253],"thread-181571":["thread",181571],"thread-181534":["thread",181534],"thread-181236":["thread",181236],"thread-181179":["thread",181179],"thread-180805":["thread",180805],"thread-180774":["thread",180774],"thread-180180":["thread",180180],"thread-180100":["thread",180100],"thread-179954":["thread",179954],"thread-179910":["thread",179910],"thread-179899":["thread",179899],"thread-179718":["thread",179718],"thread-179599":["thread",179599],"thread-179238":["thread",179238],"thread-179140":["thread",179140],"thread-179001":["thread",179001],"thread-177965":["thread",177965],"thread-177819":["thread",177819],"thread-177279":["thread",177279],"thread-176902":["thread",176902],"thread-176849":["thread",176849],"thread-176232":["thread",176232],"thread-175285":["thread",175285],"thread-174671":["thread",174671],"thread-174660":["thread",174660],"thread-174249":["thread",174249],"thread-172413":["thread",172413],"thread-172124":["thread",172124],"thread-172100":["thread",172100],"thread-171870":["thread",171870],"thread-171199":["thread",171199],"thread-170795":["thread",170795],"thread-170683":["thread",170683],"thread-170533":["thread",170533],"thread-170207":["thread",170207],"thread-169734":["thread",169734],"thread-169602":["thread",169602],"thread-169435":["thread",169435],"thread-169340":["thread",169340],"thread-169274":["thread",169274],"thread-169107":["thread",169107],"thread-169058":["thread",169058],"thread-168957":["thread",168957],"thread-168698":["thread",168698],"thread-167933":["thread",167933],"thread-167866":["thread",167866],"thread-167849":["thread",167849],"thread-167752":["thread",167752],"thread-167407":["thread",167407],"thread-167049":["thread",167049],"thread-166667":["thread",166667],"thread-166600":["thread",166600],"thread-165148":["thread",165148],"thread-165046":["thread",165046],"thread-164926":["thread",164926],"thread-164849":["thread",164849],"thread-164670":["thread",164670],"thread-164049":["thread",164049],"thread-162959":["thread",162959],"thread-162615":["thread",162615],"thread-161876":["thread",161876],"thread-161187":["thread",161187],"thread-160633":["thread",160633],"thread-159902":["thread",159902],"thread-159517":["thread",159517],"thread-159325":["thread",159325],"thread-158733":["thread",158733],"thread-158686":["thread",158686],"thread-158377":["thread",158377],"thread-158292":["thread",158292],"thread-158167":["thread",158167],"thread-158025":["thread",158025],"thread-157730":["thread",157730],"thread-157721":["thread",157721],"thread-157427":["thread",157427],"thread-157255":["thread",157255],"thread-156949":["thread",156949],"thread-156443":["thread",156443],"thread-155228":["thread",155228],"thread-153873":["thread",153873],"thread-153013":["thread",153013],"thread-152970":["thread",152970],"thread-75975":["thread",75975],"thread-50328":["thread",50328]}, , 1716024492
Run Time: 0.000541
- 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