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 (219349, 219043, 218539, 217669, 217390, 217360, 216985, 216715, 216286, 215533, 215389, 215131, 214903, 214732, 214183, 214066, 213937, 213337, 213199, 212653, 212302, 212242, 212227, 211873, 211672, 211077, 210964, 210949, 210541, 210503, 210442, 210411, 210372, 210137, 209993, 209986, 209927, 209902, 209473, 209416, 209248, 208789, 208726, 208033, 208006, 207580, 207235, 207073, 206974, 206809, 206071, 205618, 205045, 204247, 204124, 201334, 200995, 200377, 200152, 199897, 198277, 197398, 196714, 196015, 195550, 195412, 195013, 194722, 194272, 193933, 193243, 191947, 191557, 190402, 190075, 189559, 187900, 187642, 187462, 187138, 187033, 186799, 185848, 185431, 185374, 185320, 185158, 184936, 184810, 184117, 183334, 182557, 180901, 179347, 179308, 178168, 178126, 178051, 175948, 175816, 175270, 174901, 174781, 174700, 173977, 173866, 173479, 172864, 171236, 171083, 171011, 170960, 170714, 170379, 170238, 170226, 169728, 169707, 169491, 169158, 168081, 168030, 167853, 167679, 167628, 167319, 165288, 163534, 162646, 162631, 162595, 161986, 161509, 161317, 159892, 158605, 158038, 157672, 154093, 153334, 152440, 152260, 151807, 151357, 150727, 150139, 150079, 149725, 149680, 148370, 147623, 147584, 146825, 146630, 145772, 145496, 145460, 145295, 145151, 144547, 144141, 143810, 143135, 142526, 142412, 142058, 141770, 140937, 140733, 140547, 139728, 139608, 139128, 138711, 137490, 137253, 137214, 136998, 136989, 136017, 135894, 135203, 134771, 134627, 133916, 133559, 133001, 130946, 130262, 128266, 128241, 128098, 127958, 127629, 127373, 127225, 127127, 126811, 126629, 126110, 125940, 125796, 125664, 125496, 125449, 124991, 124865, 124158, 123807, 123723, 123562, 123531, 123515, 123453, 123450, 123320, 123309, 123125, 123034, 122825, 122799, 122745, 122090, 122025, 122019, 121902, 121889, 120117, 119614, 119151, 118921, 118867, 118800, 118793, 118691, 118685, 118313, 118149, 118115, 117992, 117949, 117435, 117162, 116975, 116792, 116772, 116658, 116467, 116462, 116426, 116400, 116351, 116218, 115897, 115851, 115768, 115469, 115323, 115317, 115143, 114956, 114903, 114897, 114875, 114860, 114806, 114277, 113947, 113946, 113309, 113306, 113293, 113204, 113184, 113140, 113139, 113052, 113050, 112977, 112926, 112873, 112657, 112583, 112322, 111974, 111304, 111054, 110976, 110531, 110391, 110286, 110270, 110255, 110223, 110181, 110127, 110109, 109908, 109701, 109666, 109552, 109420, 109251, 109223, 109162, 108960, 108935, 108883, 108708, 108601, 108233, 107523, 107496, 107354, 107127, 106900, 106879, 106721, 106400, 106247, 106098, 105997, 105968, 105876, 105835, 105833, 105790, 105549, 105547, 105521, 105492, 105260, 105258, 105074, 104929, 104685, 104556, 104419, 104368, 104202, 104092, 104069, 104048, 103983, 103642, 103572, 103373, 103159, 103121, 103108, 103100, 103032, 102989, 102896, 102632, 102479, 102478, 102455, 102454, 102452, 102079, 101953, 101914, 101695, 101580, 101432, 101009, 100919, 100620, 100612, 100428, 100193, 100157, 99998, 99989, 99770, 99715, 99607, 99591, 99273, 99137, 99066, 99055, 98983, 98982, 98919, 98732, 98041, 97913, 97874, 97661, 97523, 97511, 97304, 97253, 97028, 96995, 96789, 96555, 96471, 96414, 96405, 96351, 95836, 95724, 95593, 95387, 95332, 95141, 94929, 94771, 94660, 94095, 93822, 93576, 93557, 93449, 93437, 93159, 92991, 92922, 92780, 92459, 92402, 92400, 92374, 92184, 92072, 91960, 91924, 91782, 91771, 91429, 91007))
Run Time: 0.017154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 434 | 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: 71, 0, 1715057199, {"thread-219349":["thread",219349],"thread-219043":["thread",219043],"thread-218539":["thread",218539],"thread-217669":["thread",217669],"thread-217390":["thread",217390],"thread-217360":["thread",217360],"thread-216985":["thread",216985],"thread-216715":["thread",216715],"thread-216286":["thread",216286],"thread-215533":["thread",215533],"thread-215389":["thread",215389],"thread-215131":["thread",215131],"thread-214903":["thread",214903],"thread-214732":["thread",214732],"thread-214183":["thread",214183],"thread-214066":["thread",214066],"thread-213937":["thread",213937],"thread-213337":["thread",213337],"thread-213199":["thread",213199],"thread-212653":["thread",212653],"thread-212302":["thread",212302],"thread-212242":["thread",212242],"thread-212227":["thread",212227],"thread-211873":["thread",211873],"thread-211672":["thread",211672],"thread-211077":["thread",211077],"thread-210964":["thread",210964],"thread-210949":["thread",210949],"thread-210541":["thread",210541],"thread-210503":["thread",210503],"thread-210442":["thread",210442],"thread-210411":["thread",210411],"thread-210372":["thread",210372],"thread-210137":["thread",210137],"thread-209993":["thread",209993],"thread-209986":["thread",209986],"thread-209927":["thread",209927],"thread-209902":["thread",209902],"thread-209473":["thread",209473],"thread-209416":["thread",209416],"thread-209248":["thread",209248],"thread-208789":["thread",208789],"thread-208726":["thread",208726],"thread-208033":["thread",208033],"thread-208006":["thread",208006],"thread-207580":["thread",207580],"thread-207235":["thread",207235],"thread-207073":["thread",207073],"thread-206974":["thread",206974],"thread-206809":["thread",206809],"thread-206071":["thread",206071],"thread-205618":["thread",205618],"thread-205045":["thread",205045],"thread-204247":["thread",204247],"thread-204124":["thread",204124],"thread-201334":["thread",201334],"thread-200995":["thread",200995],"thread-200377":["thread",200377],"thread-200152":["thread",200152],"thread-199897":["thread",199897],"thread-198277":["thread",198277],"thread-197398":["thread",197398],"thread-196714":["thread",196714],"thread-196015":["thread",196015],"thread-195550":["thread",195550],"thread-195412":["thread",195412],"thread-195013":["thread",195013],"thread-194722":["thread",194722],"thread-194272":["thread",194272],"thread-193933":["thread",193933],"thread-193243":["thread",193243],"thread-191947":["thread",191947],"thread-191557":["thread",191557],"thread-190402":["thread",190402],"thread-190075":["thread",190075],"thread-189559":["thread",189559],"thread-187900":["thread",187900],"thread-187642":["thread",187642],"thread-187462":["thread",187462],"thread-187138":["thread",187138],"thread-187033":["thread",187033],"thread-186799":["thread",186799],"thread-185848":["thread",185848],"thread-185431":["thread",185431],"thread-185374":["thread",185374],"thread-185320":["thread",185320],"thread-185158":["thread",185158],"thread-184936":["thread",184936],"thread-184810":["thread",184810],"thread-184117":["thread",184117],"thread-183334":["thread",183334],"thread-182557":["thread",182557],"thread-180901":["thread",180901],"thread-179347":["thread",179347],"thread-179308":["thread",179308],"thread-178168":["thread",178168],"thread-178126":["thread",178126],"thread-178051":["thread",178051],"thread-175948":["thread",175948],"thread-175816":["thread",175816],"thread-175270":["thread",175270],"thread-174901":["thread",174901],"thread-174781":["thread",174781],"thread-174700":["thread",174700],"thread-173977":["thread",173977],"thread-173866":["thread",173866],"thread-173479":["thread",173479],"thread-172864":["thread",172864],"thread-171236":["thread",171236],"thread-171083":["thread",171083],"thread-171011":["thread",171011],"thread-170960":["thread",170960],"thread-170714":["thread",170714],"thread-170379":["thread",170379],"thread-170238":["thread",170238],"thread-170226":["thread",170226],"thread-169728":["thread",169728],"thread-169707":["thread",169707],"thread-169491":["thread",169491],"thread-169158":["thread",169158],"thread-168081":["thread",168081],"thread-168030":["thread",168030],"thread-167853":["thread",167853],"thread-167679":["thread",167679],"thread-167628":["thread",167628],"thread-167319":["thread",167319],"thread-165288":["thread",165288],"thread-163534":["thread",163534],"thread-162646":["thread",162646],"thread-162631":["thread",162631],"thread-162595":["thread",162595],"thread-161986":["thread",161986],"thread-161509":["thread",161509],"thread-161317":["thread",161317],"thread-159892":["thread",159892],"thread-158605":["thread",158605],"thread-158038":["thread",158038],"thread-157672":["thread",157672],"thread-154093":["thread",154093],"thread-153334":["thread",153334],"thread-152440":["thread",152440],"thread-152260":["thread",152260],"thread-151807":["thread",151807],"thread-151357":["thread",151357],"thread-150727":["thread",150727],"thread-150139":["thread",150139],"thread-150079":["thread",150079],"thread-149725":["thread",149725],"thread-149680":["thread",149680],"thread-148370":["thread",148370],"thread-147623":["thread",147623],"thread-147584":["thread",147584],"thread-146825":["thread",146825],"thread-146630":["thread",146630],"thread-145772":["thread",145772],"thread-145496":["thread",145496],"thread-145460":["thread",145460],"thread-145295":["thread",145295],"thread-145151":["thread",145151],"thread-144547":["thread",144547],"thread-144141":["thread",144141],"thread-143810":["thread",143810],"thread-143135":["thread",143135],"thread-142526":["thread",142526],"thread-142412":["thread",142412],"thread-142058":["thread",142058],"thread-141770":["thread",141770],"thread-140937":["thread",140937],"thread-140733":["thread",140733],"thread-140547":["thread",140547],"thread-139728":["thread",139728],"thread-139608":["thread",139608],"thread-139128":["thread",139128],"thread-138711":["thread",138711],"thread-137490":["thread",137490],"thread-137253":["thread",137253],"thread-137214":["thread",137214],"thread-136998":["thread",136998],"thread-136989":["thread",136989],"thread-136017":["thread",136017],"thread-135894":["thread",135894],"thread-135203":["thread",135203],"thread-134771":["thread",134771],"thread-134627":["thread",134627],"thread-133916":["thread",133916],"thread-133559":["thread",133559],"thread-133001":["thread",133001],"thread-130946":["thread",130946],"thread-130262":["thread",130262],"thread-128266":["thread",128266],"thread-128241":["thread",128241],"thread-128098":["thread",128098],"thread-127958":["thread",127958],"thread-127629":["thread",127629],"thread-127373":["thread",127373],"thread-127225":["thread",127225],"thread-127127":["thread",127127],"thread-126811":["thread",126811],"thread-126629":["thread",126629],"thread-126110":["thread",126110],"thread-125940":["thread",125940],"thread-125796":["thread",125796],"thread-125664":["thread",125664],"thread-125496":["thread",125496],"thread-125449":["thread",125449],"thread-124991":["thread",124991],"thread-124865":["thread",124865],"thread-124158":["thread",124158],"thread-123807":["thread",123807],"thread-123723":["thread",123723],"thread-123562":["thread",123562],"thread-123531":["thread",123531],"thread-123515":["thread",123515],"thread-123453":["thread",123453],"thread-123450":["thread",123450],"thread-123320":["thread",123320],"thread-123309":["thread",123309],"thread-123125":["thread",123125],"thread-123034":["thread",123034],"thread-122825":["thread",122825],"thread-122799":["thread",122799],"thread-122745":["thread",122745],"thread-122090":["thread",122090],"thread-122025":["thread",122025],"thread-122019":["thread",122019],"thread-121902":["thread",121902],"thread-121889":["thread",121889],"thread-120117":["thread",120117],"thread-119614":["thread",119614],"thread-119151":["thread",119151],"thread-118921":["thread",118921],"thread-118867":["thread",118867],"thread-118800":["thread",118800],"thread-118793":["thread",118793],"thread-118691":["thread",118691],"thread-118685":["thread",118685],"thread-118313":["thread",118313],"thread-118149":["thread",118149],"thread-118115":["thread",118115],"thread-117992":["thread",117992],"thread-117949":["thread",117949],"thread-117435":["thread",117435],"thread-117162":["thread",117162],"thread-116975":["thread",116975],"thread-116792":["thread",116792],"thread-116772":["thread",116772],"thread-116658":["thread",116658],"thread-116467":["thread",116467],"thread-116462":["thread",116462],"thread-116426":["thread",116426],"thread-116400":["thread",116400],"thread-116351":["thread",116351],"thread-116218":["thread",116218],"thread-115897":["thread",115897],"thread-115851":["thread",115851],"thread-115768":["thread",115768],"thread-115469":["thread",115469],"thread-115323":["thread",115323],"thread-115317":["thread",115317],"thread-115143":["thread",115143],"thread-114956":["thread",114956],"thread-114903":["thread",114903],"thread-114897":["thread",114897],"thread-114875":["thread",114875],"thread-114860":["thread",114860],"thread-114806":["thread",114806],"thread-114277":["thread",114277],"thread-113947":["thread",113947],"thread-113946":["thread",113946],"thread-113309":["thread",113309],"thread-113306":["thread",113306],"thread-113293":["thread",113293],"thread-113204":["thread",113204],"thread-113184":["thread",113184],"thread-113140":["thread",113140],"thread-113139":["thread",113139],"thread-113052":["thread",113052],"thread-113050":["thread",113050],"thread-112977":["thread",112977],"thread-112926":["thread",112926],"thread-112873":["thread",112873],"thread-112657":["thread",112657],"thread-112583":["thread",112583],"thread-112322":["thread",112322],"thread-111974":["thread",111974],"thread-111304":["thread",111304],"thread-111054":["thread",111054],"thread-110976":["thread",110976],"thread-110531":["thread",110531],"thread-110391":["thread",110391],"thread-110286":["thread",110286],"thread-110270":["thread",110270],"thread-110255":["thread",110255],"thread-110223":["thread",110223],"thread-110181":["thread",110181],"thread-110127":["thread",110127],"thread-110109":["thread",110109],"thread-109908":["thread",109908],"thread-109701":["thread",109701],"thread-109666":["thread",109666],"thread-109552":["thread",109552],"thread-109420":["thread",109420],"thread-109251":["thread",109251],"thread-109223":["thread",109223],"thread-109162":["thread",109162],"thread-108960":["thread",108960],"thread-108935":["thread",108935],"thread-108883":["thread",108883],"thread-108708":["thread",108708],"thread-108601":["thread",108601],"thread-108233":["thread",108233],"thread-107523":["thread",107523],"thread-107496":["thread",107496],"thread-107354":["thread",107354],"thread-107127":["thread",107127],"thread-106900":["thread",106900],"thread-106879":["thread",106879],"thread-106721":["thread",106721],"thread-106400":["thread",106400],"thread-106247":["thread",106247],"thread-106098":["thread",106098],"thread-105997":["thread",105997],"thread-105968":["thread",105968],"thread-105876":["thread",105876],"thread-105835":["thread",105835],"thread-105833":["thread",105833],"thread-105790":["thread",105790],"thread-105549":["thread",105549],"thread-105547":["thread",105547],"thread-105521":["thread",105521],"thread-105492":["thread",105492],"thread-105260":["thread",105260],"thread-105258":["thread",105258],"thread-105074":["thread",105074],"thread-104929":["thread",104929],"thread-104685":["thread",104685],"thread-104556":["thread",104556],"thread-104419":["thread",104419],"thread-104368":["thread",104368],"thread-104202":["thread",104202],"thread-104092":["thread",104092],"thread-104069":["thread",104069],"thread-104048":["thread",104048],"thread-103983":["thread",103983],"thread-103642":["thread",103642],"thread-103572":["thread",103572],"thread-103373":["thread",103373],"thread-103159":["thread",103159],"thread-103121":["thread",103121],"thread-103108":["thread",103108],"thread-103100":["thread",103100],"thread-103032":["thread",103032],"thread-102989":["thread",102989],"thread-102896":["thread",102896],"thread-102632":["thread",102632],"thread-102479":["thread",102479],"thread-102478":["thread",102478],"thread-102455":["thread",102455],"thread-102454":["thread",102454],"thread-102452":["thread",102452],"thread-102079":["thread",102079],"thread-101953":["thread",101953],"thread-101914":["thread",101914],"thread-101695":["thread",101695],"thread-101580":["thread",101580],"thread-101432":["thread",101432],"thread-101009":["thread",101009],"thread-100919":["thread",100919],"thread-100620":["thread",100620],"thread-100612":["thread",100612],"thread-100428":["thread",100428],"thread-100193":["thread",100193],"thread-100157":["thread",100157],"thread-99998":["thread",99998],"thread-99989":["thread",99989],"thread-99770":["thread",99770],"thread-99715":["thread",99715],"thread-99607":["thread",99607],"thread-99591":["thread",99591],"thread-99273":["thread",99273],"thread-99137":["thread",99137],"thread-99066":["thread",99066],"thread-99055":["thread",99055],"thread-98983":["thread",98983],"thread-98982":["thread",98982],"thread-98919":["thread",98919],"thread-98732":["thread",98732],"thread-98041":["thread",98041],"thread-97913":["thread",97913],"thread-97874":["thread",97874],"thread-97661":["thread",97661],"thread-97523":["thread",97523],"thread-97511":["thread",97511],"thread-97304":["thread",97304],"thread-97253":["thread",97253],"thread-97028":["thread",97028],"thread-96995":["thread",96995],"thread-96789":["thread",96789],"thread-96555":["thread",96555],"thread-96471":["thread",96471],"thread-96414":["thread",96414],"thread-96405":["thread",96405],"thread-96351":["thread",96351],"thread-95836":["thread",95836],"thread-95724":["thread",95724],"thread-95593":["thread",95593],"thread-95387":["thread",95387],"thread-95332":["thread",95332],"thread-95141":["thread",95141],"thread-94929":["thread",94929],"thread-94771":["thread",94771],"thread-94660":["thread",94660],"thread-94095":["thread",94095],"thread-93822":["thread",93822],"thread-93576":["thread",93576],"thread-93557":["thread",93557],"thread-93449":["thread",93449],"thread-93437":["thread",93437],"thread-93159":["thread",93159],"thread-92991":["thread",92991],"thread-92922":["thread",92922],"thread-92780":["thread",92780],"thread-92459":["thread",92459],"thread-92402":["thread",92402],"thread-92400":["thread",92400],"thread-92374":["thread",92374],"thread-92184":["thread",92184],"thread-92072":["thread",92072],"thread-91960":["thread",91960],"thread-91924":["thread",91924],"thread-91782":["thread",91782],"thread-91771":["thread",91771],"thread-91429":["thread",91429],"thread-91007":["thread",91007]}, , 1715053599
Run Time: 0.000738
- 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