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 (219217, 219040, 218527, 218515, 218272, 217240, 216406, 214012, 213082, 211182, 211134, 210925, 210800, 210797, 210441, 210011, 207457, 205108, 204457, 204091, 203914, 203863, 203020, 202882, 201865, 201562, 200251, 198595, 198085, 197428, 196597, 196222, 195400, 195046, 194995, 194026, 193795, 193249, 192967, 192877, 192700, 192619, 191992, 190033, 188974, 188677, 188377, 187741, 187255, 187021, 186421, 186382, 186328, 185812, 185287, 185278, 185152, 184210, 182662, 181645, 181576, 181169, 180634, 179668, 179650, 176362, 176170, 174118, 172840, 172513, 172294, 171803, 170560, 168585, 167919, 167859, 167232, 165378, 162289, 162208, 158017, 157135, 157012, 154387, 154057, 151489, 150919, 150217, 147227, 143387, 141341, 140079, 139260, 137859, 135044, 134183, 133718, 133193, 133184, 132911, 132803, 131924, 131735, 131672, 131552, 131354, 131144, 130919, 129833, 129483, 128309, 128263, 127995, 127936, 127546, 127291, 126826, 126379, 126278, 125831, 125274, 125180, 125138, 125090, 124780, 124723, 124688, 124599, 124153, 123987, 123196, 119246, 118248, 118060, 117795, 117684, 117678, 117347, 117227, 117128, 116753, 116724, 116708, 116543, 116276, 116259, 116204, 115184, 113306, 112781, 112355, 111959, 111920, 111835, 111511, 111466, 111357, 111245, 111204, 111203, 110923, 110879, 110795, 110694, 109927, 109901, 109454, 109226, 108637, 108033, 107689, 107533, 106983, 106403, 106337, 105876, 105546, 104928, 104233, 103615, 103456, 103292, 103225, 103181, 102957, 102907, 102872, 102831, 102775, 102668, 102656, 102291, 102221, 101886, 101837, 101836, 101608, 100759, 100725, 100590, 100297, 99999, 99371, 99275, 98812, 98799, 98342, 97660, 96805, 96653, 96638, 96541, 96408, 96260, 96062, 95945, 95903, 95631, 95562, 95318, 95046, 94759, 94213, 94210, 92213, 91700))
Run Time: 0.016542
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 226 | 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
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 670942
Params: 1714734935, {"thread-219217":["thread",219217],"thread-219040":["thread",219040],"thread-218527":["thread",218527],"thread-218515":["thread",218515],"thread-218272":["thread",218272],"thread-217240":["thread",217240],"thread-216406":["thread",216406],"thread-214012":["thread",214012],"thread-213082":["thread",213082],"thread-211182":["thread",211182],"thread-211134":["thread",211134],"thread-210925":["thread",210925],"thread-210800":["thread",210800],"thread-210797":["thread",210797],"thread-210441":["thread",210441],"thread-210011":["thread",210011],"thread-207457":["thread",207457],"thread-205108":["thread",205108],"thread-204457":["thread",204457],"thread-204091":["thread",204091],"thread-203914":["thread",203914],"thread-203863":["thread",203863],"thread-203020":["thread",203020],"thread-202882":["thread",202882],"thread-201865":["thread",201865],"thread-201562":["thread",201562],"thread-200251":["thread",200251],"thread-198595":["thread",198595],"thread-198085":["thread",198085],"thread-197428":["thread",197428],"thread-196597":["thread",196597],"thread-196222":["thread",196222],"thread-195400":["thread",195400],"thread-195046":["thread",195046],"thread-194995":["thread",194995],"thread-194026":["thread",194026],"thread-193795":["thread",193795],"thread-193249":["thread",193249],"thread-192967":["thread",192967],"thread-192877":["thread",192877],"thread-192700":["thread",192700],"thread-192619":["thread",192619],"thread-191992":["thread",191992],"thread-190033":["thread",190033],"thread-188974":["thread",188974],"thread-188677":["thread",188677],"thread-188377":["thread",188377],"thread-187741":["thread",187741],"thread-187255":["thread",187255],"thread-187021":["thread",187021],"thread-186421":["thread",186421],"thread-186382":["thread",186382],"thread-186328":["thread",186328],"thread-185812":["thread",185812],"thread-185287":["thread",185287],"thread-185278":["thread",185278],"thread-185152":["thread",185152],"thread-184210":["thread",184210],"thread-182662":["thread",182662],"thread-181645":["thread",181645],"thread-181576":["thread",181576],"thread-181169":["thread",181169],"thread-180634":["thread",180634],"thread-179668":["thread",179668],"thread-179650":["thread",179650],"thread-176362":["thread",176362],"thread-176170":["thread",176170],"thread-174118":["thread",174118],"thread-172840":["thread",172840],"thread-172513":["thread",172513],"thread-172294":["thread",172294],"thread-171803":["thread",171803],"thread-170560":["thread",170560],"thread-168585":["thread",168585],"thread-167919":["thread",167919],"thread-167859":["thread",167859],"thread-167232":["thread",167232],"thread-165378":["thread",165378],"thread-162289":["thread",162289],"thread-162208":["thread",162208],"thread-158017":["thread",158017],"thread-157135":["thread",157135],"thread-157012":["thread",157012],"thread-154387":["thread",154387],"thread-154057":["thread",154057],"thread-151489":["thread",151489],"thread-150919":["thread",150919],"thread-150217":["thread",150217],"thread-147227":["thread",147227],"thread-143387":["thread",143387],"thread-141341":["thread",141341],"thread-140079":["thread",140079],"thread-139260":["thread",139260],"thread-137859":["thread",137859],"thread-135044":["thread",135044],"thread-134183":["thread",134183],"thread-133718":["thread",133718],"thread-133193":["thread",133193],"thread-133184":["thread",133184],"thread-132911":["thread",132911],"thread-132803":["thread",132803],"thread-131924":["thread",131924],"thread-131735":["thread",131735],"thread-131672":["thread",131672],"thread-131552":["thread",131552],"thread-131354":["thread",131354],"thread-131144":["thread",131144],"thread-130919":["thread",130919],"thread-129833":["thread",129833],"thread-129483":["thread",129483],"thread-128309":["thread",128309],"thread-128263":["thread",128263],"thread-127995":["thread",127995],"thread-127936":["thread",127936],"thread-127546":["thread",127546],"thread-127291":["thread",127291],"thread-126826":["thread",126826],"thread-126379":["thread",126379],"thread-126278":["thread",126278],"thread-125831":["thread",125831],"thread-125274":["thread",125274],"thread-125180":["thread",125180],"thread-125138":["thread",125138],"thread-125090":["thread",125090],"thread-124780":["thread",124780],"thread-124723":["thread",124723],"thread-124688":["thread",124688],"thread-124599":["thread",124599],"thread-124153":["thread",124153],"thread-123987":["thread",123987],"thread-123196":["thread",123196],"thread-119246":["thread",119246],"thread-118248":["thread",118248],"thread-118060":["thread",118060],"thread-117795":["thread",117795],"thread-117684":["thread",117684],"thread-117678":["thread",117678],"thread-117347":["thread",117347],"thread-117227":["thread",117227],"thread-117128":["thread",117128],"thread-116753":["thread",116753],"thread-116724":["thread",116724],"thread-116708":["thread",116708],"thread-116543":["thread",116543],"thread-116276":["thread",116276],"thread-116259":["thread",116259],"thread-116204":["thread",116204],"thread-115184":["thread",115184],"thread-113306":["thread",113306],"thread-112781":["thread",112781],"thread-112355":["thread",112355],"thread-111959":["thread",111959],"thread-111920":["thread",111920],"thread-111835":["thread",111835],"thread-111511":["thread",111511],"thread-111466":["thread",111466],"thread-111357":["thread",111357],"thread-111245":["thread",111245],"thread-111203":["thread",111203],"thread-110923":["thread",110923],"thread-110879":["thread",110879],"thread-110795":["thread",110795],"thread-110694":["thread",110694],"thread-109927":["thread",109927],"thread-109901":["thread",109901],"thread-109454":["thread",109454],"thread-109226":["thread",109226],"thread-108637":["thread",108637],"thread-108033":["thread",108033],"thread-107689":["thread",107689],"thread-107533":["thread",107533],"thread-106983":["thread",106983],"thread-106403":["thread",106403],"thread-106337":["thread",106337],"thread-105876":["thread",105876],"thread-105546":["thread",105546],"thread-104928":["thread",104928],"thread-104233":["thread",104233],"thread-103615":["thread",103615],"thread-103456":["thread",103456],"thread-103292":["thread",103292],"thread-103225":["thread",103225],"thread-103181":["thread",103181],"thread-102957":["thread",102957],"thread-102907":["thread",102907],"thread-102872":["thread",102872],"thread-102831":["thread",102831],"thread-102775":["thread",102775],"thread-102668":["thread",102668],"thread-102656":["thread",102656],"thread-102291":["thread",102291],"thread-102221":["thread",102221],"thread-101886":["thread",101886],"thread-101837":["thread",101837],"thread-101836":["thread",101836],"thread-101608":["thread",101608],"thread-100759":["thread",100759],"thread-100725":["thread",100725],"thread-100590":["thread",100590],"thread-100297":["thread",100297],"thread-99999":["thread",99999],"thread-99371":["thread",99371],"thread-99275":["thread",99275],"thread-98812":["thread",98812],"thread-98799":["thread",98799],"thread-98342":["thread",98342],"thread-97660":["thread",97660],"thread-96805":["thread",96805],"thread-96653":["thread",96653],"thread-96638":["thread",96638],"thread-96541":["thread",96541],"thread-96408":["thread",96408],"thread-96260":["thread",96260],"thread-96062":["thread",96062],"thread-95945":["thread",95945],"thread-95903":["thread",95903],"thread-95631":["thread",95631],"thread-95562":["thread",95562],"thread-95318":["thread",95318],"thread-95046":["thread",95046],"thread-94759":["thread",94759],"thread-94213":["thread",94213],"thread-94210":["thread",94210],"thread-92213":["thread",92213],"thread-91700":["thread",91700]}
Run Time: 0.000663
- 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 322
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1515
- 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