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 (171613, 171147, 170409, 168102, 166141, 166138, 164644, 164355, 161720, 159703, 157855, 157352, 157146, 157000, 156888, 156768, 156441, 155937, 155684, 155656, 155528, 155449, 155289, 154903, 154812, 154776, 154668, 154378, 154289, 153756, 153741, 153521, 153163, 152915, 152819, 152776, 152669, 152665, 152381, 150769, 148486, 148181, 147316, 147212, 147050, 146775, 146644, 146271, 146155, 145632, 145380, 143815, 143567, 143341, 142480, 142331, 141841, 140314, 92792))
Run Time: 0.035032
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 59 | 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: 20636, 0, 1716032420, {"thread-171613":["thread",171613],"thread-171147":["thread",171147],"thread-170409":["thread",170409],"thread-168102":["thread",168102],"thread-166141":["thread",166141],"thread-166138":["thread",166138],"thread-164644":["thread",164644],"thread-164355":["thread",164355],"thread-161720":["thread",161720],"thread-159703":["thread",159703],"thread-157855":["thread",157855],"thread-157352":["thread",157352],"thread-157146":["thread",157146],"thread-157000":["thread",157000],"thread-156888":["thread",156888],"thread-156768":["thread",156768],"thread-156441":["thread",156441],"thread-155937":["thread",155937],"thread-155684":["thread",155684],"thread-155656":["thread",155656],"thread-155528":["thread",155528],"thread-155449":["thread",155449],"thread-155289":["thread",155289],"ams_article-4139":["ams_article",4139],"thread-154903":["thread",154903],"thread-154812":["thread",154812],"thread-154776":["thread",154776],"thread-154668":["thread",154668],"thread-154378":["thread",154378],"thread-154289":["thread",154289],"ams_article-4090":["ams_article",4090],"thread-153756":["thread",153756],"thread-153741":["thread",153741],"ams_article-4045":["ams_article",4045],"thread-153521":["thread",153521],"ams_article-4021":["ams_article",4021],"thread-153163":["thread",153163],"thread-152915":["thread",152915],"thread-152819":["thread",152819],"thread-152776":["thread",152776],"thread-152669":["thread",152669],"thread-152665":["thread",152665],"thread-152381":["thread",152381],"thread-150769":["thread",150769],"ams_article-3771":["ams_article",3771],"thread-148486":["thread",148486],"thread-148181":["thread",148181],"thread-147316":["thread",147316],"thread-147212":["thread",147212],"thread-147050":["thread",147050],"thread-146775":["thread",146775],"thread-146644":["thread",146644],"thread-146271":["thread",146271],"thread-146155":["thread",146155],"thread-145632":["thread",145632],"thread-145380":["thread",145380],"thread-143815":["thread",143815],"thread-143567":["thread",143567],"thread-143341":["thread",143341],"thread-142480":["thread",142480],"thread-142331":["thread",142331],"thread-141841":["thread",141841],"thread-140314":["thread",140314],"thread-92792":["thread",92792]}, , 1716028820
Run Time: 0.000781
- 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