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 (176513, 175761, 175409, 169772, 168769, 168579, 168215, 159625, 154711, 153379, 152853, 152595, 151795, 151740, 151736, 151653, 151335, 150006, 149310, 146982, 145971, 145316, 145201, 144992, 143784, 136848, 120774, 99424, 99059, 98997, 98893, 98783, 98643, 98601, 98544, 98474, 98463, 90852, 90719, 89692, 86234, 79376, 75732, 74661, 74260, 74029, 73956, 73955, 73954, 73953, 69948, 67947, 67891, 18294, 3808, 3477, 3334))
Run Time: 0.047684
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 57 | 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: 887, 0, 1716160806, {"thread-176513":["thread",176513],"thread-175761":["thread",175761],"thread-175409":["thread",175409],"thread-169772":["thread",169772],"thread-168769":["thread",168769],"thread-168579":["thread",168579],"thread-168215":["thread",168215],"thread-159625":["thread",159625],"thread-154711":["thread",154711],"thread-153379":["thread",153379],"thread-152853":["thread",152853],"thread-152595":["thread",152595],"thread-151795":["thread",151795],"thread-151740":["thread",151740],"thread-151736":["thread",151736],"thread-151653":["thread",151653],"tl_group-35":["tl_group",35],"thread-151335":["thread",151335],"thread-150006":["thread",150006],"thread-149310":["thread",149310],"thread-146982":["thread",146982],"thread-145971":["thread",145971],"thread-145316":["thread",145316],"thread-145201":["thread",145201],"thread-144992":["thread",144992],"thread-143784":["thread",143784],"thread-136848":["thread",136848],"thread-120774":["thread",120774],"thread-99424":["thread",99424],"thread-99059":["thread",99059],"thread-98997":["thread",98997],"thread-98893":["thread",98893],"thread-98783":["thread",98783],"thread-98643":["thread",98643],"thread-98601":["thread",98601],"thread-98544":["thread",98544],"thread-98474":["thread",98474],"thread-98463":["thread",98463],"thread-90852":["thread",90852],"thread-90719":["thread",90719],"thread-89692":["thread",89692],"thread-86234":["thread",86234],"thread-79376":["thread",79376],"thread-75732":["thread",75732],"thread-74661":["thread",74661],"thread-74260":["thread",74260],"thread-74029":["thread",74029],"thread-73956":["thread",73956],"thread-73955":["thread",73955],"thread-73954":["thread",73954],"thread-73953":["thread",73953],"thread-69948":["thread",69948],"thread-67947":["thread",67947],"thread-67891":["thread",67891],"thread-18294":["thread",18294],"thread-3808":["thread",3808],"thread-3477":["thread",3477],"thread-3334":["thread",3334]}, , 1716157206
Run Time: 0.000270
- 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