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 (183280, 182719, 182043, 181786, 181106, 180919, 180302, 180273, 180272, 178479, 178144, 177058, 175757, 175643, 175563, 174710, 174403, 174402, 172591, 171973, 171812, 171613, 171096, 170960, 170894, 169416, 168962, 167328, 165767, 164479, 163563, 163340, 161346, 160859, 158371, 157599, 157509, 157054, 155985, 155349, 155319, 154877, 153783, 153661, 153534, 151835, 130830, 129662, 128780, 128243, 126108, 125271, 118290, 112886, 109033, 106627, 106091, 103093, 102265, 101552, 100888, 99404, 98786, 97762, 97685, 96056, 96022, 95995, 95994, 93935, 93265, 91856, 90401, 86891, 84914, 83485, 83250, 81727, 79176, 78674, 78611, 78462, 77182, 76426, 74468, 74359, 73432, 70226, 69603, 68545, 61233, 59901, 56938, 56603, 56463, 55910, 54217, 53760, 49753, 49107, 49047, 48076, 46833, 42133, 36510, 23292, 19321, 17690, 13983, 13698, 13542, 13424, 13399, 13282, 8868, 7962, 7905, 7859, 7849, 7084, 1448, 1357))
Run Time: 0.043877
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 122 | 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: 346, 0, 1716142738, {"thread-183280":["thread",183280],"thread-182719":["thread",182719],"thread-182043":["thread",182043],"thread-181786":["thread",181786],"thread-181106":["thread",181106],"thread-180919":["thread",180919],"thread-180302":["thread",180302],"thread-180273":["thread",180273],"thread-180272":["thread",180272],"thread-178479":["thread",178479],"thread-178144":["thread",178144],"thread-177058":["thread",177058],"thread-175757":["thread",175757],"thread-175643":["thread",175643],"thread-175563":["thread",175563],"thread-174710":["thread",174710],"thread-174403":["thread",174403],"thread-174402":["thread",174402],"thread-172591":["thread",172591],"thread-171973":["thread",171973],"thread-171812":["thread",171812],"thread-171613":["thread",171613],"thread-171096":["thread",171096],"thread-170960":["thread",170960],"thread-170894":["thread",170894],"thread-169416":["thread",169416],"thread-168962":["thread",168962],"thread-167328":["thread",167328],"thread-165767":["thread",165767],"thread-164479":["thread",164479],"thread-163563":["thread",163563],"thread-163340":["thread",163340],"ams_article-4450":["ams_article",4450],"thread-161346":["thread",161346],"thread-160859":["thread",160859],"ams_article-4435":["ams_article",4435],"thread-158371":["thread",158371],"thread-157599":["thread",157599],"thread-157509":["thread",157509],"thread-157054":["thread",157054],"thread-155985":["thread",155985],"ams_article-4192":["ams_article",4192],"thread-155349":["thread",155349],"thread-155319":["thread",155319],"thread-154877":["thread",154877],"thread-153783":["thread",153783],"thread-153534":["thread",153534],"thread-151835":["thread",151835],"ams_article-3300":["ams_article",3300],"ams_article-3190":["ams_article",3190],"thread-130830":["thread",130830],"thread-129662":["thread",129662],"thread-128780":["thread",128780],"thread-128243":["thread",128243],"thread-126108":["thread",126108],"thread-125271":["thread",125271],"thread-118290":["thread",118290],"thread-112886":["thread",112886],"thread-109033":["thread",109033],"thread-106627":["thread",106627],"thread-106091":["thread",106091],"thread-103093":["thread",103093],"thread-102265":["thread",102265],"thread-101552":["thread",101552],"thread-100888":["thread",100888],"thread-99404":["thread",99404],"thread-98786":["thread",98786],"thread-97762":["thread",97762],"thread-97685":["thread",97685],"thread-96056":["thread",96056],"thread-96022":["thread",96022],"thread-95995":["thread",95995],"thread-95994":["thread",95994],"thread-93935":["thread",93935],"thread-93265":["thread",93265],"thread-91856":["thread",91856],"thread-90401":["thread",90401],"thread-86891":["thread",86891],"thread-84914":["thread",84914],"thread-83485":["thread",83485],"thread-83250":["thread",83250],"thread-81727":["thread",81727],"thread-79176":["thread",79176],"thread-78674":["thread",78674],"thread-78611":["thread",78611],"thread-78462":["thread",78462],"thread-77182":["thread",77182],"thread-76426":["thread",76426],"thread-74468":["thread",74468],"thread-74359":["thread",74359],"thread-73432":["thread",73432],"thread-70226":["thread",70226],"thread-69603":["thread",69603],"thread-68545":["thread",68545],"thread-61233":["thread",61233],"thread-59901":["thread",59901],"thread-56938":["thread",56938],"thread-56603":["thread",56603],"thread-56463":["thread",56463],"thread-55910":["thread",55910],"thread-54217":["thread",54217],"thread-53760":["thread",53760],"thread-49753":["thread",49753],"thread-49107":["thread",49107],"thread-49047":["thread",49047],"thread-48076":["thread",48076],"thread-46833":["thread",46833],"thread-42133":["thread",42133],"thread-36510":["thread",36510],"thread-23292":["thread",23292],"thread-19321":["thread",19321],"thread-17690":["thread",17690],"thread-13983":["thread",13983],"thread-13698":["thread",13698],"thread-13542":["thread",13542],"thread-13424":["thread",13424],"thread-13399":["thread",13399],"thread-13282":["thread",13282],"thread-8868":["thread",8868],"thread-7962":["thread",7962],"thread-7905":["thread",7905],"thread-7859":["thread",7859],"thread-7849":["thread",7849],"thread-7084":["thread",7084],"thread-1448":["thread",1448],"thread-1357":["thread",1357]}, , 1716139138
Run Time: 0.000274
- 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