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 (183060, 182151, 181610, 178397, 178100, 178092, 177725, 175554, 174658, 173125, 172490, 172383, 170374, 170314, 170187, 169648, 168504, 168204, 163265, 160984, 160442, 160010, 159631, 158749, 157975, 157205, 153150, 152060, 150916, 140529, 139712, 139694, 139657, 139653, 139089, 138989, 138483, 135718, 131112, 125498, 113610, 112811, 108378, 97924, 97902, 97652, 97126, 96198, 95622, 94121, 89223, 85541, 76121, 72317, 69662, 69637, 66332, 65906, 65542, 60182, 58321, 50334, 45134, 38932))
Run Time: 0.041406
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 64 | 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: 5561, 0, 1715985994, {"thread-183060":["thread",183060],"thread-182151":["thread",182151],"thread-181610":["thread",181610],"thread-178397":["thread",178397],"thread-178100":["thread",178100],"thread-178092":["thread",178092],"thread-177725":["thread",177725],"thread-175554":["thread",175554],"thread-174658":["thread",174658],"thread-173125":["thread",173125],"thread-172490":["thread",172490],"thread-172383":["thread",172383],"thread-170374":["thread",170374],"thread-170314":["thread",170314],"thread-170187":["thread",170187],"thread-169648":["thread",169648],"thread-168504":["thread",168504],"thread-168204":["thread",168204],"thread-163265":["thread",163265],"thread-160984":["thread",160984],"thread-160442":["thread",160442],"thread-160010":["thread",160010],"thread-159631":["thread",159631],"thread-158749":["thread",158749],"thread-157975":["thread",157975],"thread-157205":["thread",157205],"thread-153150":["thread",153150],"thread-152060":["thread",152060],"thread-150916":["thread",150916],"thread-140529":["thread",140529],"thread-139712":["thread",139712],"thread-139694":["thread",139694],"thread-139657":["thread",139657],"thread-139653":["thread",139653],"thread-139089":["thread",139089],"thread-138989":["thread",138989],"thread-138483":["thread",138483],"thread-135718":["thread",135718],"thread-131112":["thread",131112],"thread-125498":["thread",125498],"thread-113610":["thread",113610],"thread-112811":["thread",112811],"thread-108378":["thread",108378],"thread-97924":["thread",97924],"thread-97902":["thread",97902],"thread-97652":["thread",97652],"thread-97126":["thread",97126],"thread-96198":["thread",96198],"thread-95622":["thread",95622],"thread-94121":["thread",94121],"thread-89223":["thread",89223],"thread-85541":["thread",85541],"thread-76121":["thread",76121],"thread-72317":["thread",72317],"thread-69662":["thread",69662],"thread-69637":["thread",69637],"thread-66332":["thread",66332],"thread-65906":["thread",65906],"thread-65542":["thread",65542],"thread-60182":["thread",60182],"thread-58321":["thread",58321],"thread-50334":["thread",50334],"thread-45134":["thread",45134],"thread-38932":["thread",38932]}, , 1715982394
Run Time: 0.000761
- 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