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 (219469, 218965, 218752, 218176, 216658, 216535, 215827, 214255, 214045, 213163, 212230, 211732, 211642, 211552, 211243, 210702, 210509, 210410, 210098, 210024, 209966, 209938, 208492, 208390, 208252, 207850, 207676, 207055, 206914, 206569, 206551, 205867, 205654, 204334, 203344, 202744, 202204, 201223, 200635, 200293, 199354, 197923, 197833, 197788, 197680, 197185, 196252, 196090, 195886, 195709, 195415, 195244, 195121, 194368, 193117, 192832, 192328, 192247, 192235, 192193, 191668, 191458, 190735, 189469, 188062, 187204, 186838, 185887, 185524, 183883, 182515, 181762, 180826, 180802, 180496, 177553, 177097, 176743, 175813, 175282, 175231, 175048, 174536, 174503, 174497, 174373, 174238, 173989, 172975, 172618, 172339, 172153, 172090, 171689, 171572, 171311, 171137, 170801, 170774, 170358, 169557, 169203, 168708, 168579, 168321, 168201, 167628, 167472, 166908, 166317, 166164, 163549, 162256, 161809, 161794, 161524, 161374, 161329, 161272, 161122, 161017, 160915, 160720, 160639, 160486, 160162, 159760, 158224, 158080, 157147, 156844, 154081, 152191, 151804, 150862, 149512, 147083, 146885, 146591, 145373, 145265, 144865, 144676, 144670, 144631, 144268, 143321, 143054, 142634, 142505, 142331, 141353, 141069, 141063, 140901, 140199, 140022, 139266, 137382, 137253, 136998, 136959, 136029, 135474, 135471, 135333, 134711, 134345, 134018, 133142, 131753, 131297, 129383, 129366, 129165, 129147, 129046, 128846, 127757, 127727, 127429, 127386, 127271, 127127, 127084, 127082, 127072, 126856, 126837, 126769, 126767, 126508, 126325, 126249, 126128, 126127, 125618, 125407, 125385, 125194, 125136, 124960, 124943, 124934, 124729, 124160, 123987, 123978, 123943, 123939, 123901, 123817, 123631, 123414, 123272, 123237, 123233, 122857, 122370, 122299, 122218, 122211, 122122, 122080, 122019, 121900, 121760, 121735, 121415, 121198, 120996, 120680, 120371, 120370, 120363, 120284, 120224, 120038, 119970, 119892, 119572, 119459, 119446, 119419, 119121, 119108, 119078, 119018, 118778, 118060, 118008, 117792, 117638, 117484, 117384, 117346, 117331, 117282, 116825, 116801, 116772, 116737, 116268, 116179, 116069, 115621, 115467, 115370, 115236, 115013, 115008, 115007, 114891, 114860, 114838, 114768, 114099, 113773, 113660, 113531, 113480, 113474, 113431, 113256, 113033, 112799, 112758, 112734, 112659, 112511, 112152, 111840, 111631, 111479, 111469, 111297, 111168, 111009, 110928, 110747, 110713, 110700, 110622, 110429, 110358, 110246, 110229, 110149, 109884, 109883, 109873, 109785, 109731, 109573, 109127, 109098, 109091, 108973, 108910, 108908, 108850, 108684, 108664, 108304, 108205, 108118, 107701, 107565, 107482, 107455, 107411, 107089, 107053, 106898, 106894, 106656, 106488, 106376, 106337, 106238, 106034, 106006, 105954, 105819, 105719, 105597, 105531, 105205, 105194, 104945, 104870, 104768, 104691, 104605, 104540, 104434, 104207, 104071, 103858, 103644, 103604, 103464, 103309, 103147, 103129, 102831, 102764, 101959, 101874, 101607, 101321, 100964, 100769, 100648, 100632, 100474, 100385, 100191, 99945, 99921, 99791, 99709, 99670, 99604, 99578, 99147, 99090, 98891, 98830, 98623, 98605, 98561, 98225, 97980, 97785, 97769, 97712, 97102, 96981, 96492, 96405, 96399, 96173, 95865, 95826, 95388, 95280, 94364, 94238, 94009, 93959, 93916, 93760, 93759, 93758, 93757, 93668, 93604, 93233, 93018, 92815, 92434, 92112, 91888, 91832, 91812, 91783, 91750, 90964, 90907))
Run Time: 0.022039
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 430 | 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: 12, 0, 1716099413, {"thread-219469":["thread",219469],"thread-218965":["thread",218965],"thread-218752":["thread",218752],"thread-218176":["thread",218176],"thread-216658":["thread",216658],"thread-216535":["thread",216535],"thread-215827":["thread",215827],"thread-214255":["thread",214255],"thread-214045":["thread",214045],"thread-213163":["thread",213163],"thread-212230":["thread",212230],"thread-211732":["thread",211732],"thread-211642":["thread",211642],"thread-211552":["thread",211552],"thread-211243":["thread",211243],"thread-210702":["thread",210702],"thread-210509":["thread",210509],"thread-210410":["thread",210410],"thread-210098":["thread",210098],"thread-210024":["thread",210024],"thread-209966":["thread",209966],"thread-209938":["thread",209938],"thread-208492":["thread",208492],"thread-208390":["thread",208390],"thread-208252":["thread",208252],"thread-207850":["thread",207850],"thread-207676":["thread",207676],"thread-207055":["thread",207055],"thread-206914":["thread",206914],"thread-206569":["thread",206569],"thread-206551":["thread",206551],"thread-205867":["thread",205867],"thread-205654":["thread",205654],"thread-204334":["thread",204334],"thread-203344":["thread",203344],"thread-202744":["thread",202744],"thread-202204":["thread",202204],"thread-201223":["thread",201223],"thread-200635":["thread",200635],"thread-200293":["thread",200293],"thread-199354":["thread",199354],"thread-197923":["thread",197923],"thread-197833":["thread",197833],"thread-197788":["thread",197788],"thread-197680":["thread",197680],"thread-197185":["thread",197185],"thread-196252":["thread",196252],"thread-196090":["thread",196090],"thread-195886":["thread",195886],"thread-195709":["thread",195709],"thread-195415":["thread",195415],"thread-195244":["thread",195244],"thread-195121":["thread",195121],"thread-194368":["thread",194368],"thread-193117":["thread",193117],"thread-192832":["thread",192832],"thread-192328":["thread",192328],"thread-192247":["thread",192247],"thread-192235":["thread",192235],"thread-192193":["thread",192193],"thread-191668":["thread",191668],"thread-191458":["thread",191458],"thread-190735":["thread",190735],"thread-189469":["thread",189469],"thread-188062":["thread",188062],"thread-187204":["thread",187204],"thread-186838":["thread",186838],"thread-185887":["thread",185887],"thread-185524":["thread",185524],"thread-183883":["thread",183883],"thread-182515":["thread",182515],"thread-181762":["thread",181762],"thread-180826":["thread",180826],"thread-180802":["thread",180802],"thread-180496":["thread",180496],"thread-177553":["thread",177553],"thread-177097":["thread",177097],"thread-176743":["thread",176743],"thread-175813":["thread",175813],"thread-175282":["thread",175282],"thread-175231":["thread",175231],"thread-175048":["thread",175048],"thread-174536":["thread",174536],"thread-174503":["thread",174503],"thread-174497":["thread",174497],"thread-174373":["thread",174373],"thread-174238":["thread",174238],"thread-173989":["thread",173989],"thread-172975":["thread",172975],"thread-172618":["thread",172618],"thread-172339":["thread",172339],"thread-172153":["thread",172153],"thread-172090":["thread",172090],"thread-171689":["thread",171689],"thread-171572":["thread",171572],"thread-171311":["thread",171311],"thread-171137":["thread",171137],"thread-170801":["thread",170801],"thread-170774":["thread",170774],"thread-170358":["thread",170358],"thread-169557":["thread",169557],"thread-169203":["thread",169203],"thread-168708":["thread",168708],"thread-168579":["thread",168579],"thread-168321":["thread",168321],"thread-168201":["thread",168201],"thread-167628":["thread",167628],"thread-167472":["thread",167472],"thread-166908":["thread",166908],"thread-166317":["thread",166317],"thread-166164":["thread",166164],"thread-163549":["thread",163549],"thread-162256":["thread",162256],"thread-161809":["thread",161809],"thread-161794":["thread",161794],"thread-161524":["thread",161524],"thread-161374":["thread",161374],"thread-161329":["thread",161329],"thread-161272":["thread",161272],"thread-161122":["thread",161122],"thread-161017":["thread",161017],"thread-160915":["thread",160915],"thread-160720":["thread",160720],"thread-160639":["thread",160639],"thread-160486":["thread",160486],"thread-160162":["thread",160162],"thread-159760":["thread",159760],"thread-158224":["thread",158224],"thread-158080":["thread",158080],"thread-157147":["thread",157147],"thread-156844":["thread",156844],"thread-154081":["thread",154081],"thread-152191":["thread",152191],"thread-151804":["thread",151804],"thread-150862":["thread",150862],"thread-149512":["thread",149512],"thread-147083":["thread",147083],"thread-146885":["thread",146885],"thread-146591":["thread",146591],"thread-145373":["thread",145373],"thread-145265":["thread",145265],"thread-144865":["thread",144865],"thread-144676":["thread",144676],"thread-144670":["thread",144670],"thread-144631":["thread",144631],"thread-144268":["thread",144268],"thread-143321":["thread",143321],"thread-143054":["thread",143054],"thread-142634":["thread",142634],"thread-142505":["thread",142505],"thread-142331":["thread",142331],"thread-141353":["thread",141353],"thread-141069":["thread",141069],"thread-141063":["thread",141063],"thread-140901":["thread",140901],"thread-140199":["thread",140199],"thread-140022":["thread",140022],"thread-139266":["thread",139266],"thread-137382":["thread",137382],"thread-137253":["thread",137253],"thread-136998":["thread",136998],"thread-136959":["thread",136959],"thread-136029":["thread",136029],"thread-135474":["thread",135474],"thread-135471":["thread",135471],"thread-135333":["thread",135333],"thread-134711":["thread",134711],"thread-134345":["thread",134345],"thread-134018":["thread",134018],"thread-133142":["thread",133142],"thread-131753":["thread",131753],"thread-131297":["thread",131297],"thread-129383":["thread",129383],"thread-129366":["thread",129366],"thread-129165":["thread",129165],"thread-129147":["thread",129147],"thread-129046":["thread",129046],"thread-128846":["thread",128846],"thread-127757":["thread",127757],"thread-127727":["thread",127727],"thread-127429":["thread",127429],"thread-127386":["thread",127386],"thread-127271":["thread",127271],"thread-127127":["thread",127127],"thread-127084":["thread",127084],"thread-127082":["thread",127082],"thread-126856":["thread",126856],"thread-126837":["thread",126837],"thread-126769":["thread",126769],"thread-126767":["thread",126767],"thread-126508":["thread",126508],"thread-126325":["thread",126325],"thread-126249":["thread",126249],"thread-126128":["thread",126128],"thread-126127":["thread",126127],"thread-125618":["thread",125618],"thread-125407":["thread",125407],"thread-125385":["thread",125385],"thread-125194":["thread",125194],"thread-125136":["thread",125136],"thread-124960":["thread",124960],"thread-124943":["thread",124943],"thread-124934":["thread",124934],"thread-124729":["thread",124729],"thread-124160":["thread",124160],"thread-123987":["thread",123987],"thread-123978":["thread",123978],"thread-123943":["thread",123943],"thread-123939":["thread",123939],"thread-123901":["thread",123901],"thread-123817":["thread",123817],"thread-123631":["thread",123631],"thread-123414":["thread",123414],"thread-123272":["thread",123272],"thread-123237":["thread",123237],"thread-123233":["thread",123233],"thread-122857":["thread",122857],"thread-122370":["thread",122370],"thread-122299":["thread",122299],"thread-122218":["thread",122218],"thread-122211":["thread",122211],"thread-122122":["thread",122122],"thread-122080":["thread",122080],"thread-122019":["thread",122019],"thread-121900":["thread",121900],"thread-121760":["thread",121760],"thread-121735":["thread",121735],"thread-121415":["thread",121415],"thread-121198":["thread",121198],"thread-120996":["thread",120996],"thread-120680":["thread",120680],"thread-120371":["thread",120371],"thread-120370":["thread",120370],"thread-120363":["thread",120363],"thread-120284":["thread",120284],"thread-120224":["thread",120224],"thread-120038":["thread",120038],"thread-119970":["thread",119970],"thread-119892":["thread",119892],"thread-119572":["thread",119572],"thread-119459":["thread",119459],"thread-119446":["thread",119446],"thread-119419":["thread",119419],"thread-119121":["thread",119121],"thread-119108":["thread",119108],"thread-119078":["thread",119078],"thread-119018":["thread",119018],"thread-118778":["thread",118778],"thread-118060":["thread",118060],"thread-118008":["thread",118008],"thread-117792":["thread",117792],"thread-117638":["thread",117638],"thread-117484":["thread",117484],"thread-117384":["thread",117384],"thread-117331":["thread",117331],"thread-117282":["thread",117282],"thread-116825":["thread",116825],"thread-116801":["thread",116801],"thread-116772":["thread",116772],"thread-116737":["thread",116737],"thread-116268":["thread",116268],"thread-116179":["thread",116179],"thread-116069":["thread",116069],"thread-115621":["thread",115621],"thread-115467":["thread",115467],"thread-115370":["thread",115370],"thread-115236":["thread",115236],"thread-115013":["thread",115013],"thread-115008":["thread",115008],"thread-115007":["thread",115007],"thread-114891":["thread",114891],"thread-114860":["thread",114860],"thread-114838":["thread",114838],"thread-114768":["thread",114768],"thread-114099":["thread",114099],"thread-113773":["thread",113773],"thread-113660":["thread",113660],"thread-113531":["thread",113531],"thread-113480":["thread",113480],"thread-113474":["thread",113474],"thread-113431":["thread",113431],"thread-113256":["thread",113256],"thread-113033":["thread",113033],"thread-112799":["thread",112799],"thread-112758":["thread",112758],"thread-112734":["thread",112734],"thread-112659":["thread",112659],"thread-112511":["thread",112511],"thread-112152":["thread",112152],"thread-111840":["thread",111840],"thread-111631":["thread",111631],"thread-111479":["thread",111479],"thread-111469":["thread",111469],"thread-111297":["thread",111297],"thread-111168":["thread",111168],"thread-111009":["thread",111009],"thread-110928":["thread",110928],"thread-110747":["thread",110747],"thread-110713":["thread",110713],"thread-110700":["thread",110700],"thread-110622":["thread",110622],"thread-110429":["thread",110429],"thread-110358":["thread",110358],"thread-110246":["thread",110246],"thread-110229":["thread",110229],"thread-110149":["thread",110149],"thread-109884":["thread",109884],"thread-109883":["thread",109883],"thread-109873":["thread",109873],"thread-109785":["thread",109785],"thread-109731":["thread",109731],"thread-109573":["thread",109573],"thread-109127":["thread",109127],"thread-109098":["thread",109098],"thread-109091":["thread",109091],"thread-108973":["thread",108973],"thread-108910":["thread",108910],"thread-108908":["thread",108908],"thread-108850":["thread",108850],"thread-108684":["thread",108684],"thread-108664":["thread",108664],"thread-108304":["thread",108304],"thread-108205":["thread",108205],"thread-108118":["thread",108118],"thread-107701":["thread",107701],"thread-107565":["thread",107565],"thread-107482":["thread",107482],"thread-107455":["thread",107455],"thread-107411":["thread",107411],"thread-107089":["thread",107089],"thread-107053":["thread",107053],"thread-106898":["thread",106898],"thread-106894":["thread",106894],"thread-106656":["thread",106656],"thread-106488":["thread",106488],"thread-106376":["thread",106376],"thread-106337":["thread",106337],"thread-106238":["thread",106238],"thread-106034":["thread",106034],"thread-106006":["thread",106006],"thread-105954":["thread",105954],"thread-105819":["thread",105819],"thread-105719":["thread",105719],"thread-105597":["thread",105597],"thread-105531":["thread",105531],"thread-105205":["thread",105205],"thread-105194":["thread",105194],"thread-104945":["thread",104945],"thread-104870":["thread",104870],"thread-104768":["thread",104768],"thread-104691":["thread",104691],"thread-104605":["thread",104605],"thread-104540":["thread",104540],"thread-104434":["thread",104434],"thread-104207":["thread",104207],"thread-104071":["thread",104071],"thread-103858":["thread",103858],"thread-103644":["thread",103644],"thread-103604":["thread",103604],"thread-103464":["thread",103464],"thread-103309":["thread",103309],"thread-103147":["thread",103147],"thread-103129":["thread",103129],"thread-102831":["thread",102831],"thread-102764":["thread",102764],"thread-101959":["thread",101959],"thread-101874":["thread",101874],"thread-101607":["thread",101607],"thread-101321":["thread",101321],"thread-100964":["thread",100964],"thread-100769":["thread",100769],"thread-100648":["thread",100648],"thread-100632":["thread",100632],"thread-100474":["thread",100474],"thread-100385":["thread",100385],"thread-100191":["thread",100191],"thread-99945":["thread",99945],"thread-99921":["thread",99921],"thread-99791":["thread",99791],"thread-99709":["thread",99709],"thread-99670":["thread",99670],"thread-99604":["thread",99604],"thread-99578":["thread",99578],"thread-99147":["thread",99147],"thread-99090":["thread",99090],"thread-98891":["thread",98891],"thread-98830":["thread",98830],"thread-98623":["thread",98623],"thread-98605":["thread",98605],"thread-98561":["thread",98561],"thread-98225":["thread",98225],"thread-97980":["thread",97980],"thread-97785":["thread",97785],"thread-97769":["thread",97769],"thread-97712":["thread",97712],"thread-97102":["thread",97102],"thread-96981":["thread",96981],"thread-96492":["thread",96492],"thread-96405":["thread",96405],"thread-96399":["thread",96399],"thread-96173":["thread",96173],"thread-95865":["thread",95865],"thread-95826":["thread",95826],"thread-95388":["thread",95388],"thread-95280":["thread",95280],"thread-94364":["thread",94364],"thread-94238":["thread",94238],"thread-94009":["thread",94009],"thread-93959":["thread",93959],"thread-93916":["thread",93916],"thread-93760":["thread",93760],"thread-93759":["thread",93759],"thread-93758":["thread",93758],"thread-93757":["thread",93757],"thread-93668":["thread",93668],"thread-93604":["thread",93604],"thread-93233":["thread",93233],"thread-93018":["thread",93018],"thread-92815":["thread",92815],"thread-92434":["thread",92434],"thread-92112":["thread",92112],"thread-91888":["thread",91888],"thread-91832":["thread",91832],"thread-91812":["thread",91812],"thread-91783":["thread",91783],"thread-91750":["thread",91750],"thread-90964":["thread",90964],"thread-90907":["thread",90907]}, , 1716095813
Run Time: 0.001510
- 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