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 (218566, 218527, 218497, 218089, 217960, 216226, 215557, 215083, 215080, 212671, 212224, 210810, 210679, 210642, 210538, 210526, 210255, 210247, 210205, 207307, 207040, 206986, 205906, 205228, 205120, 205102, 203305, 202735, 202669, 199984, 199822, 199300, 198946, 198844, 198499, 198472, 196663, 194932, 194770, 194470, 193825, 193243, 192508, 191491, 190384, 189787, 189280, 188974, 188428, 188044, 187915, 186421, 185260, 185149, 184915, 184768, 184192, 183892, 182887, 182248, 180934, 180514, 180181, 179545, 179425, 177994, 177484, 177452, 175888, 175870, 175369, 174940, 174718, 174286, 173233, 172975, 172399, 171822, 171311, 171179, 170551, 169101, 169092, 168603, 167919, 167886, 167571, 167232, 166164, 165920, 165519, 165378, 165363, 164941, 164125, 163537, 163453, 163327, 163258, 162907, 162628, 161242, 158032, 157873, 156637, 155950, 155374, 154156, 153673, 153670, 153664, 153661, 153658, 153655, 153334, 151732, 150514, 150463, 149152, 147242, 146747, 146483, 146246, 145556, 145376, 144355, 142616, 141650, 140994, 136830, 136032, 135516, 129905, 129743, 129077, 128768, 128701, 127758, 126925, 126602, 126321, 125627, 125263, 125188, 125090, 125086, 125071, 124831, 124805, 124058, 124011, 123723, 123661, 123653, 123450, 123409, 123313, 121858, 121471, 120768, 120763, 120371, 120370, 119871, 119823, 119443, 118918, 118632, 118540, 118510, 118313, 117497, 117426, 117402, 116974, 116659, 116504, 116426, 116276, 116224, 115826, 115193, 115184, 114529, 114232, 114119, 114074, 113728, 113680, 113679, 113387, 113265, 112687, 112571, 112510, 112443, 112422, 112394, 112322, 112006, 111333, 111087, 110935, 110857, 110780, 110721, 110427, 110027, 109449, 109214, 109166, 109108, 108304, 107973, 107868, 107041, 106550, 106290, 106132, 105805, 105751, 105674, 105653, 105491, 105254, 105100, 104988, 104984, 104608, 104409, 104316, 103464, 103456, 103441, 103176, 103170, 103095, 101636, 101419, 101087, 100587, 100428, 99696, 99581, 99521, 99363, 99360, 99252, 99183, 99130, 98985, 98891, 98799, 98535, 98358, 98192, 98118, 98075, 98045, 96852, 96391, 96000, 95723, 95477, 95395, 95110, 94690, 93434, 93084, 92559, 92247, 91828, 91513, 91246, 91234, 91205, 90998))
Run Time: 0.019995
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 277 | 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: 64, 0, 1715441519, {"thread-218566":["thread",218566],"thread-218527":["thread",218527],"thread-218497":["thread",218497],"thread-218089":["thread",218089],"thread-217960":["thread",217960],"thread-216226":["thread",216226],"thread-215557":["thread",215557],"thread-215083":["thread",215083],"thread-215080":["thread",215080],"thread-212671":["thread",212671],"thread-212224":["thread",212224],"thread-210810":["thread",210810],"thread-210679":["thread",210679],"thread-210642":["thread",210642],"thread-210538":["thread",210538],"thread-210526":["thread",210526],"thread-210255":["thread",210255],"thread-210247":["thread",210247],"thread-210205":["thread",210205],"thread-207307":["thread",207307],"thread-207040":["thread",207040],"thread-206986":["thread",206986],"thread-205906":["thread",205906],"thread-205228":["thread",205228],"thread-205120":["thread",205120],"thread-205102":["thread",205102],"thread-203305":["thread",203305],"thread-202735":["thread",202735],"thread-202669":["thread",202669],"thread-199984":["thread",199984],"thread-199822":["thread",199822],"thread-199300":["thread",199300],"thread-198946":["thread",198946],"thread-198844":["thread",198844],"thread-198499":["thread",198499],"thread-198472":["thread",198472],"thread-196663":["thread",196663],"thread-194932":["thread",194932],"thread-194770":["thread",194770],"thread-194470":["thread",194470],"thread-193825":["thread",193825],"thread-193243":["thread",193243],"thread-192508":["thread",192508],"thread-191491":["thread",191491],"thread-190384":["thread",190384],"thread-189787":["thread",189787],"thread-189280":["thread",189280],"thread-188974":["thread",188974],"thread-188428":["thread",188428],"thread-188044":["thread",188044],"thread-187915":["thread",187915],"thread-186421":["thread",186421],"thread-185260":["thread",185260],"thread-185149":["thread",185149],"thread-184915":["thread",184915],"thread-184768":["thread",184768],"thread-184192":["thread",184192],"thread-183892":["thread",183892],"thread-182887":["thread",182887],"thread-182248":["thread",182248],"thread-180934":["thread",180934],"thread-180514":["thread",180514],"thread-180181":["thread",180181],"thread-179545":["thread",179545],"thread-179425":["thread",179425],"thread-177994":["thread",177994],"thread-177484":["thread",177484],"thread-177452":["thread",177452],"thread-175888":["thread",175888],"thread-175870":["thread",175870],"thread-175369":["thread",175369],"thread-174940":["thread",174940],"thread-174718":["thread",174718],"thread-174286":["thread",174286],"thread-173233":["thread",173233],"thread-172975":["thread",172975],"thread-172399":["thread",172399],"thread-171822":["thread",171822],"thread-171311":["thread",171311],"thread-171179":["thread",171179],"thread-170551":["thread",170551],"thread-169101":["thread",169101],"thread-169092":["thread",169092],"thread-168603":["thread",168603],"thread-167919":["thread",167919],"thread-167886":["thread",167886],"thread-167571":["thread",167571],"thread-167232":["thread",167232],"thread-166164":["thread",166164],"thread-165920":["thread",165920],"thread-165519":["thread",165519],"thread-165378":["thread",165378],"thread-165363":["thread",165363],"thread-164941":["thread",164941],"thread-164125":["thread",164125],"thread-163537":["thread",163537],"thread-163453":["thread",163453],"thread-163327":["thread",163327],"thread-163258":["thread",163258],"thread-162907":["thread",162907],"thread-162628":["thread",162628],"thread-161242":["thread",161242],"thread-158032":["thread",158032],"thread-157873":["thread",157873],"thread-156637":["thread",156637],"thread-155950":["thread",155950],"thread-155374":["thread",155374],"thread-154156":["thread",154156],"thread-153673":["thread",153673],"thread-153670":["thread",153670],"thread-153664":["thread",153664],"thread-153661":["thread",153661],"thread-153658":["thread",153658],"thread-153655":["thread",153655],"thread-153334":["thread",153334],"thread-151732":["thread",151732],"thread-150514":["thread",150514],"thread-150463":["thread",150463],"thread-149152":["thread",149152],"thread-147242":["thread",147242],"thread-146747":["thread",146747],"thread-146483":["thread",146483],"thread-146246":["thread",146246],"thread-145556":["thread",145556],"thread-145376":["thread",145376],"thread-144355":["thread",144355],"thread-142616":["thread",142616],"thread-141650":["thread",141650],"thread-140994":["thread",140994],"thread-136830":["thread",136830],"thread-136032":["thread",136032],"thread-135516":["thread",135516],"thread-129905":["thread",129905],"thread-129743":["thread",129743],"thread-129077":["thread",129077],"thread-128768":["thread",128768],"thread-128701":["thread",128701],"thread-127758":["thread",127758],"thread-126925":["thread",126925],"thread-126602":["thread",126602],"thread-126321":["thread",126321],"thread-125627":["thread",125627],"thread-125263":["thread",125263],"thread-125188":["thread",125188],"thread-125090":["thread",125090],"thread-125086":["thread",125086],"thread-125071":["thread",125071],"thread-124831":["thread",124831],"thread-124805":["thread",124805],"thread-124058":["thread",124058],"thread-124011":["thread",124011],"thread-123723":["thread",123723],"thread-123661":["thread",123661],"thread-123653":["thread",123653],"thread-123450":["thread",123450],"thread-123409":["thread",123409],"thread-123313":["thread",123313],"thread-121858":["thread",121858],"thread-121471":["thread",121471],"thread-120768":["thread",120768],"thread-120763":["thread",120763],"thread-120371":["thread",120371],"thread-120370":["thread",120370],"thread-119871":["thread",119871],"thread-119823":["thread",119823],"thread-119443":["thread",119443],"thread-118918":["thread",118918],"thread-118632":["thread",118632],"thread-118540":["thread",118540],"thread-118510":["thread",118510],"thread-118313":["thread",118313],"thread-117497":["thread",117497],"thread-117426":["thread",117426],"thread-117402":["thread",117402],"thread-116974":["thread",116974],"thread-116659":["thread",116659],"thread-116504":["thread",116504],"thread-116426":["thread",116426],"thread-116276":["thread",116276],"thread-116224":["thread",116224],"thread-115826":["thread",115826],"thread-115193":["thread",115193],"thread-115184":["thread",115184],"thread-114529":["thread",114529],"thread-114232":["thread",114232],"thread-114119":["thread",114119],"thread-114074":["thread",114074],"thread-113728":["thread",113728],"thread-113680":["thread",113680],"thread-113679":["thread",113679],"thread-113387":["thread",113387],"thread-113265":["thread",113265],"thread-112687":["thread",112687],"thread-112571":["thread",112571],"thread-112510":["thread",112510],"thread-112443":["thread",112443],"thread-112422":["thread",112422],"thread-112394":["thread",112394],"thread-112322":["thread",112322],"thread-112006":["thread",112006],"thread-111333":["thread",111333],"thread-111087":["thread",111087],"thread-110935":["thread",110935],"thread-110857":["thread",110857],"thread-110780":["thread",110780],"thread-110721":["thread",110721],"thread-110427":["thread",110427],"thread-110027":["thread",110027],"thread-109449":["thread",109449],"thread-109214":["thread",109214],"thread-109166":["thread",109166],"thread-109108":["thread",109108],"thread-108304":["thread",108304],"thread-107973":["thread",107973],"thread-107868":["thread",107868],"thread-107041":["thread",107041],"thread-106550":["thread",106550],"thread-106290":["thread",106290],"thread-106132":["thread",106132],"thread-105805":["thread",105805],"thread-105751":["thread",105751],"thread-105674":["thread",105674],"thread-105653":["thread",105653],"thread-105491":["thread",105491],"thread-105254":["thread",105254],"thread-105100":["thread",105100],"thread-104988":["thread",104988],"thread-104984":["thread",104984],"thread-104608":["thread",104608],"thread-104409":["thread",104409],"thread-104316":["thread",104316],"thread-103464":["thread",103464],"thread-103456":["thread",103456],"thread-103441":["thread",103441],"thread-103176":["thread",103176],"thread-103170":["thread",103170],"thread-103095":["thread",103095],"thread-101636":["thread",101636],"thread-101419":["thread",101419],"thread-101087":["thread",101087],"thread-100587":["thread",100587],"thread-100428":["thread",100428],"thread-99696":["thread",99696],"thread-99581":["thread",99581],"thread-99521":["thread",99521],"thread-99363":["thread",99363],"thread-99360":["thread",99360],"thread-99252":["thread",99252],"thread-99183":["thread",99183],"thread-99130":["thread",99130],"thread-98985":["thread",98985],"thread-98891":["thread",98891],"thread-98799":["thread",98799],"thread-98535":["thread",98535],"thread-98358":["thread",98358],"thread-98192":["thread",98192],"thread-98118":["thread",98118],"thread-98075":["thread",98075],"thread-98045":["thread",98045],"thread-96852":["thread",96852],"thread-96391":["thread",96391],"thread-96000":["thread",96000],"thread-95723":["thread",95723],"thread-95477":["thread",95477],"thread-95395":["thread",95395],"thread-95110":["thread",95110],"thread-94690":["thread",94690],"thread-93434":["thread",93434],"thread-93084":["thread",93084],"thread-92559":["thread",92559],"thread-92247":["thread",92247],"thread-91828":["thread",91828],"thread-91513":["thread",91513],"thread-91246":["thread",91246],"thread-91234":["thread",91234],"thread-91205":["thread",91205],"thread-90998":["thread",90998]}, , 1715437919
Run Time: 0.001013
- 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