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 (183499, 180759, 180392, 180312, 180203, 177339, 177135, 176314, 176281, 176137, 175924, 174325, 174072, 173584, 172909, 171883, 171747, 171284, 171017, 170994, 170210, 169438, 169113, 169094, 168958, 168756, 168753, 168608, 168348, 168119, 168084, 167869, 166607, 166577, 166258, 166249, 165645, 164134, 163394, 163378, 163377, 163376, 163375, 163374, 163373, 163372, 163371, 160100, 157323, 157002, 156912, 156250, 156164, 155546, 155145, 152811, 152107, 150590, 150237, 150226, 150225, 149762, 149314, 144283, 137534, 137529, 134664, 132498, 132425, 130343))
Run Time: 0.037011
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 70 | 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: 37068, 0, 1715833539, {"thread-183499":["thread",183499],"ams_article-5342":["ams_article",5342],"ams_article-5269":["ams_article",5269],"thread-180759":["thread",180759],"thread-180392":["thread",180392],"thread-180312":["thread",180312],"thread-180203":["thread",180203],"thread-177339":["thread",177339],"thread-177135":["thread",177135],"thread-176314":["thread",176314],"thread-176281":["thread",176281],"thread-176137":["thread",176137],"thread-175924":["thread",175924],"thread-174325":["thread",174325],"thread-174072":["thread",174072],"thread-173584":["thread",173584],"thread-172909":["thread",172909],"ams_article-4922":["ams_article",4922],"thread-171883":["thread",171883],"thread-171747":["thread",171747],"ams_article-4868":["ams_article",4868],"thread-171284":["thread",171284],"thread-171017":["thread",171017],"thread-170994":["thread",170994],"thread-170210":["thread",170210],"thread-169438":["thread",169438],"thread-169113":["thread",169113],"thread-169094":["thread",169094],"thread-168958":["thread",168958],"thread-168756":["thread",168756],"thread-168753":["thread",168753],"thread-168608":["thread",168608],"thread-168348":["thread",168348],"thread-168119":["thread",168119],"thread-168084":["thread",168084],"thread-167869":["thread",167869],"thread-166607":["thread",166607],"thread-166577":["thread",166577],"thread-166258":["thread",166258],"thread-166249":["thread",166249],"thread-165645":["thread",165645],"thread-164134":["thread",164134],"thread-163394":["thread",163394],"thread-163378":["thread",163378],"thread-163377":["thread",163377],"thread-163376":["thread",163376],"thread-163375":["thread",163375],"thread-163374":["thread",163374],"thread-163373":["thread",163373],"thread-163372":["thread",163372],"thread-163371":["thread",163371],"thread-160100":["thread",160100],"thread-157323":["thread",157323],"thread-157002":["thread",157002],"thread-156912":["thread",156912],"thread-156250":["thread",156250],"thread-156164":["thread",156164],"thread-155546":["thread",155546],"thread-155145":["thread",155145],"thread-152811":["thread",152811],"thread-152107":["thread",152107],"thread-150590":["thread",150590],"thread-150237":["thread",150237],"thread-150226":["thread",150226],"thread-150225":["thread",150225],"thread-149762":["thread",149762],"thread-149314":["thread",149314],"thread-144283":["thread",144283],"thread-137534":["thread",137534],"thread-137529":["thread",137529],"thread-134664":["thread",134664],"thread-132498":["thread",132498],"thread-132425":["thread",132425],"thread-130343":["thread",130343]}, , 1715829939
Run Time: 0.000148
- 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