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 (218728, 215023, 213034, 212557, 212125, 211153, 210784, 210679, 210659, 210622, 210324, 210182, 207913, 207169, 205996, 204607, 204364, 203224, 202402, 199558, 197935, 195652, 193708, 192775, 191992, 188101, 187834, 187351, 186772, 185956, 183715, 181756, 181312, 180865, 177319, 176164, 175303, 174337, 173626, 167010, 165636, 164746, 162379, 161806, 160045, 159154, 155083, 150862, 150238, 149293, 149044, 140736, 140184, 139416, 129021, 127936, 126896, 126363, 126336, 125677, 125666, 124388, 123773, 123748, 123164, 122175, 121731, 121544, 121517, 120853, 120337, 120336, 120116, 118835, 118822, 118381, 118051, 117908, 117610, 117570, 117473, 117315, 117212, 116974, 116694, 116471, 116297, 115878, 115717, 115597, 115210, 115163, 114721, 114088, 113685, 113419, 112615, 112485, 112013, 111292, 111203, 110078, 110031, 109583, 108301, 107574, 107308, 106454, 104340, 104233, 103925, 103924, 103302, 103052, 102800, 102785, 102638, 102565, 102528, 101699, 101585, 101576, 100987, 100444, 99844, 99520, 99371, 99320, 99212, 99100, 98039, 97308, 97138, 96448, 94820, 93908, 93191, 92933, 92364, 92022, 91902, 91513))
Run Time: 0.009730
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 142 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 290, 0, 1714201437, {"thread-218728":["thread",218728],"thread-215023":["thread",215023],"thread-213034":["thread",213034],"thread-212557":["thread",212557],"thread-212125":["thread",212125],"thread-211153":["thread",211153],"thread-210784":["thread",210784],"thread-210679":["thread",210679],"thread-210659":["thread",210659],"thread-210622":["thread",210622],"thread-210324":["thread",210324],"thread-210182":["thread",210182],"thread-207913":["thread",207913],"thread-207169":["thread",207169],"thread-205996":["thread",205996],"thread-204607":["thread",204607],"thread-204364":["thread",204364],"thread-203224":["thread",203224],"thread-202402":["thread",202402],"thread-199558":["thread",199558],"thread-197935":["thread",197935],"thread-195652":["thread",195652],"thread-193708":["thread",193708],"thread-192775":["thread",192775],"thread-191992":["thread",191992],"thread-188101":["thread",188101],"thread-187834":["thread",187834],"thread-187351":["thread",187351],"thread-186772":["thread",186772],"thread-185956":["thread",185956],"thread-183715":["thread",183715],"thread-181756":["thread",181756],"thread-181312":["thread",181312],"thread-180865":["thread",180865],"thread-177319":["thread",177319],"thread-176164":["thread",176164],"thread-175303":["thread",175303],"thread-174337":["thread",174337],"thread-173626":["thread",173626],"thread-167010":["thread",167010],"thread-165636":["thread",165636],"thread-164746":["thread",164746],"thread-162379":["thread",162379],"thread-161806":["thread",161806],"thread-160045":["thread",160045],"thread-159154":["thread",159154],"thread-155083":["thread",155083],"thread-150862":["thread",150862],"thread-150238":["thread",150238],"thread-149293":["thread",149293],"thread-149044":["thread",149044],"thread-140736":["thread",140736],"thread-140184":["thread",140184],"thread-139416":["thread",139416],"thread-129021":["thread",129021],"thread-127936":["thread",127936],"thread-126896":["thread",126896],"thread-126363":["thread",126363],"thread-126336":["thread",126336],"thread-125677":["thread",125677],"thread-125666":["thread",125666],"thread-124388":["thread",124388],"thread-123773":["thread",123773],"thread-123748":["thread",123748],"thread-123164":["thread",123164],"thread-122175":["thread",122175],"thread-121731":["thread",121731],"thread-121544":["thread",121544],"thread-121517":["thread",121517],"thread-120853":["thread",120853],"thread-120337":["thread",120337],"thread-120336":["thread",120336],"thread-120116":["thread",120116],"thread-118835":["thread",118835],"thread-118822":["thread",118822],"thread-118381":["thread",118381],"thread-118051":["thread",118051],"thread-117908":["thread",117908],"thread-117610":["thread",117610],"thread-117570":["thread",117570],"thread-117473":["thread",117473],"thread-117315":["thread",117315],"thread-117212":["thread",117212],"thread-116974":["thread",116974],"thread-116694":["thread",116694],"thread-116471":["thread",116471],"thread-116297":["thread",116297],"thread-115878":["thread",115878],"thread-115717":["thread",115717],"thread-115597":["thread",115597],"thread-115210":["thread",115210],"thread-115163":["thread",115163],"thread-114721":["thread",114721],"thread-114088":["thread",114088],"thread-113685":["thread",113685],"thread-113419":["thread",113419],"thread-112615":["thread",112615],"thread-112485":["thread",112485],"thread-112013":["thread",112013],"thread-111292":["thread",111292],"thread-111203":["thread",111203],"thread-110078":["thread",110078],"thread-110031":["thread",110031],"thread-109583":["thread",109583],"thread-108301":["thread",108301],"thread-107574":["thread",107574],"thread-107308":["thread",107308],"thread-106454":["thread",106454],"thread-104340":["thread",104340],"thread-104233":["thread",104233],"thread-103925":["thread",103925],"thread-103924":["thread",103924],"thread-103302":["thread",103302],"thread-103052":["thread",103052],"thread-102800":["thread",102800],"thread-102785":["thread",102785],"thread-102638":["thread",102638],"thread-102565":["thread",102565],"thread-102528":["thread",102528],"thread-101699":["thread",101699],"thread-101585":["thread",101585],"thread-101576":["thread",101576],"thread-100987":["thread",100987],"thread-100444":["thread",100444],"thread-99844":["thread",99844],"thread-99520":["thread",99520],"thread-99371":["thread",99371],"thread-99320":["thread",99320],"thread-99212":["thread",99212],"thread-99100":["thread",99100],"thread-98039":["thread",98039],"thread-97308":["thread",97308],"thread-97138":["thread",97138],"thread-96448":["thread",96448],"thread-94820":["thread",94820],"thread-93908":["thread",93908],"thread-93191":["thread",93191],"thread-92933":["thread",92933],"thread-92364":["thread",92364],"thread-92022":["thread",92022],"thread-91902":["thread",91902],"thread-91513":["thread",91513]}, , 1714197837
Run Time: 0.000883
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20