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 (183105, 181622, 181617, 180135, 179197, 177284, 175358, 172140, 172079, 172035, 168741, 167945, 167761, 166704, 166322, 163882, 163881, 162458, 162438, 162141, 160762, 160457, 158037, 156985, 153931, 152864, 152762, 135506, 132558, 131678, 130940, 125846, 120011, 119821, 117988, 117851, 117389, 117112, 112745, 111462, 106154, 102164, 96199, 95271, 94775, 92777, 92767, 68175, 60295, 57651, 48451, 48237, 45823, 27174, 15852, 14794, 12590, 8251, 8247, 4065, 3586))
Run Time: 0.044517
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 61 | 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: 861, 0, 1716702867, {"thread-183105":["thread",183105],"thread-181622":["thread",181622],"thread-181617":["thread",181617],"thread-180135":["thread",180135],"thread-179197":["thread",179197],"thread-177284":["thread",177284],"thread-175358":["thread",175358],"thread-172140":["thread",172140],"thread-172079":["thread",172079],"thread-172035":["thread",172035],"thread-168741":["thread",168741],"thread-167945":["thread",167945],"thread-167761":["thread",167761],"thread-166704":["thread",166704],"thread-166322":["thread",166322],"thread-163882":["thread",163882],"thread-163881":["thread",163881],"thread-162458":["thread",162458],"thread-162438":["thread",162438],"thread-162141":["thread",162141],"thread-160762":["thread",160762],"thread-160457":["thread",160457],"thread-158037":["thread",158037],"thread-156985":["thread",156985],"thread-153931":["thread",153931],"thread-152864":["thread",152864],"thread-152762":["thread",152762],"thread-135506":["thread",135506],"thread-132558":["thread",132558],"thread-131678":["thread",131678],"thread-130940":["thread",130940],"thread-125846":["thread",125846],"thread-120011":["thread",120011],"thread-119821":["thread",119821],"thread-117988":["thread",117988],"thread-117851":["thread",117851],"thread-117389":["thread",117389],"thread-117112":["thread",117112],"thread-112745":["thread",112745],"thread-111462":["thread",111462],"thread-106154":["thread",106154],"thread-102164":["thread",102164],"thread-96199":["thread",96199],"thread-95271":["thread",95271],"thread-94775":["thread",94775],"thread-92777":["thread",92777],"thread-92767":["thread",92767],"thread-68175":["thread",68175],"thread-60295":["thread",60295],"thread-57651":["thread",57651],"thread-48451":["thread",48451],"thread-48237":["thread",48237],"thread-45823":["thread",45823],"thread-27174":["thread",27174],"thread-15852":["thread",15852],"thread-14794":["thread",14794],"thread-12590":["thread",12590],"thread-8251":["thread",8251],"thread-8247":["thread",8247],"thread-4065":["thread",4065],"thread-3586":["thread",3586]}, , 1716699267
Run Time: 0.000337
- 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