#8
⏱️ 116.66 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[90135732,2867897,11465628,10478505,50058060,52263352,60065665,109223403,3234543,3637789,77812179,1889473,12342346,78174123,2796992,2733688,3406291,3177375,10869972,3698500,24743133,47217135,2845662,3249526,60016647,3764490,11900020,12196078,74736997,85128072,3117508,12317417,98613099,3722988,3310709,60566691,3124980,3485781,24880090,3166957,2672129,11465611,24652213,6800231,29218432,2246047,52962227,3724814,3579624,12301833,3344160,7798901,11465623,60016639,90921368,12196149,78177866,2733742,2867967,111723291,2773491,11528906,3456243,3182021,1712702,3159448,60065658,2746137,10285845,90941577,78133615,59944711,11899504,89901359,59902678,3151965,97233668,12287703,37339633,98834311,2182921,98330939,90293411,24491669,3357287,97284149,11783203,3795448,2746087,3154910,3605796,56412291,110701744,11219241,67542224,24892275,3585946,60129623,33216941,227047,11783235,78777404,2867911,10657841,229396,12196081,12344144,60509525,2023112,29888910,59967072,2845628,11744702,29851059,3513248,3386277,3649852,59972508,111791962,12326715,111535960,3115159,98613097,12196095,7771969,11318103,2966105,317357,322890,60023465,2845623,3242066,2845611,1802659,3155112,3252471,3380198,98977055,3692450,22780295,338686,3214946,12348293,11783257,1858260,78419287,78574539,3122631,13462650,2807903,35907970,12392591,2746098,2151880,2226743,3227071,3204529,24821841,59866505,3192650,3121833,3189503,3190301,77964330,60129630,2402487,90613193,90670226,98262204,97284144,37853137,12196079,7798887,219575,98330934,59739448,98281887,2766572,3192448,2845614,3139963,3680683,221924,3235341,3334621,24453384,3465205,3219524,98973622,7771948,3167755,60308132,7798956,2746089,7772002,344315,12282352,12332630,2387386,3145146,2955702,3245213,2966114,12367681,78074826,99743451,90443355,98914242,3564429,31096019,78550431,3230016,2996487,3132301,3175228,3237690,11720529,3207676,78146317,11186912,7252452,3129356,2966152,24425349,78602030,3574901,2996439,11783223,59932411,12297751,7621900,29397569,2733709,12064858,29541313,10412492,111336133,13860506,111763066,54515871,12287000,3621687,2206933,100682926,59967066,12348995,12196116,29494492,98329192,1854220,7902337,10553137,11465614,12317619,3199960,3252673,19027698,90972825,12370039,12369837,10663832,57482375,2996475,3434902,2996450,2955690,2746159,3117306,10869965,7798934,11528869,3598945,24890625,3550082,78338366,3137614,98636203,24971893,90149754,221722,78453372,16130147,68290492,100169416,24311753,11465650,24970047,3205327,3136816,218777,12332428,1952553,90038612,76684283,47978479,98315948,3537573,2733674,311694,3655628,2672132,2728874,90176559,2845684,7798885,29270768,7771932,1695751,33594960,12357257,12362512,37291714,2808532,2955670,20058303,11553958,29259277,2254044,90494640,3147293,3646328,2178705,60339513,33763636,1672649,60385204,3569723,3090735,3110378,90960266,3730603,3130154,62746788,2996441,3197015,10661161,3215148,2672168,78074833,2746103,2672201,229194,98220891,2955665,2733672,3051540,11783198,7252461,3147495,3220322,2778740,3124778,7925931,37244384,60509521,12389440,12280554,59825295,12311197,30186489,11465662,2000162,2052399,98238889,3222469,11528868,12295952,363108,37339626,3632388,3152763,2490475,3714657,3634405,3626455,3227869,7771980,90403907,11783189,2328805,7771943,11900052,2867899,76514545,2672130,27595493,10423352,3250324,2567007,3230218,3611958,12328514,33061836,3160246,78177861,69001667,3415073,98134355,3212799,12392389,111793900,12301631,2341858,3661607,2996455,78550433,3686521,11465684,31345039,24639514,2966119,2672146,3668319,90638678,33457507,74737006,7798896,24639507,3617402,11899506,3674983,3471845,3197813,97136362,24804774,3592440,1976761,11465612,10627328,78133622,2966140,12366882,90344884,98452638,24804769,110738656,26700086,11900040,29684082,2824819,24539485,77812186,90077382,3114361,90696784,89871492,1817036,1926974,2106108,3169902,16237822,2746125,78773350,11900073,59787836,2672180,98381981,2867934,1931450,12243770,11899515,3363459,2845650,78287910,3705204,3576536,62718339,90553319,7771934,90582449,3498580,3162595,97187915,10355728,60171831,65780014,3242864,98207861,2240762,2966174,97093600,88879153,24486439,3245011,12359556,2733683,3207474,3321716,98226710,2796338,19801430,90519735,7866654,98281881,1754632,98155874,3170104,2012901,12156976,97290864]
#11
⏱️ 4736.96 мс
select store_id, count(*) as total from "deals" where "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and ("expires_at" is null or "expires_at" >= ?) group by "store_id"
Bindings:
[1108,1109,704,1110,1111,1112,30,2,13,11,129,1113,1114,18,703,705,93,143,83,114,1120,541,706,542,707,708,711,152,712,710,202,215,186,101,223,713,727,728,729,730,731,716,216,234,732,733,734,735,736,719,720,721,717,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,769,759,760,761,762,763,764,765,766,767,768,770,771,772,773,774,775,776,119,777,246,272,273,264,271,288,236,315,320,102,335,96,106,170,107,108,111,189,103,112,113,117,125,126,325,199,260,220,203,207,309,323,1326,343,345,1394,1118,1121,1123,1124,1125,1126,1129,1131,1132,1133,1138,1139,1140,1141,443,1142,1143,1145,1146,1147,1151,1153,1155,1156,1157,1159,1160,1166,1168,469,1169,1170,1173,1175,1177,482,483,1181,1182,1186,1188,1192,1194,1196,1198,1201,1205,1206,1207,1209,1210,1211,1216,1217,718,1218,1219,1220,1221,1223,1224,1226,1229,1230,1232,1236,714,1238,1239,1240,1241,544,545,1243,1244,1245,1246,1249,1250,1251,557,1254,1255,1260,1261,1262,1263,1264,1265,1271,1273,1274,1275,583,584,585,586,587,1277,1279,1280,1282,597,599,600,604,608,1283,1285,1286,1287,1288,1289,1290,610,614,616,617,618,1291,1292,1293,1296,1298,626,627,628,633,637,1299,1300,1301,1303,1305,1306,1307,646,647,1308,1311,1312,1313,1315,1316,1317,1318,657,1319,1320,1321,1325,1327,1328,1330,1334,1336,1339,1342,1343,1344,1345,1,1349,3,8,14,38,39,40,41,42,43,26,33,44,45,47,48,49,50,51,52,53,54,55,56,57,59,60,61,62,63,64,65,66,67,68,69,70,77,78,80,72,85,98,100,110,135,153,154,155,157,158,159,160,150,161,162,163,164,165,166,167,168,261,174,175,181,197,224,226,238,249,291,292,293,279,301,341,1350,425,426,427,419,420,422,423,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,444,445,446,448,449,450,451,452,454,528,455,456,457,458,459,460,461,462,463,464,465,466,467,468,470,471,472,473,474,475,476,477,478,479,481,484,485,486,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,511,512,513,514,515,516,521,1352,527,1390,1353,1354,1355,1356,535,1359,539,540,1361,543,547,549,550,551,552,553,554,555,556,558,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,609,619,620,623,648,676,649,650,651,652,655,656,658,659,660,661,662,663,664,665,667,669,1362,671,672,673,674,675,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,1368,1369,1370,1371,1377,1379,1380,1382,1384,1385,1386,1388,1395,1397,1398,1400,1402,1405,1409,1411,1412,104,308,358,4,5,6,12,29,16,17,19,23,22,28,24,27,25,20,15,37,32,34,35,36,31,71,701,700,1417,698,73,76,81,82,702,91,92,89,95,105,84,86,87,88,90,97,99,109,118,123,124,120,121,127,122,128,116,137,132,134,138,131,139,140,141,142,130,146,149,151,144,145,147,173,169,171,176,178,180,182,184,185,183,194,195,190,191,192,196,198,200,201,187,188,193,209,211,210,204,208,212,205,227,219,221,222,228,229,231,232,233,217,235,247,242,251,245,243,244,252,237,250,265,257,256,259,267,266,254,268,278,274,281,284,277,287,282,276,280,275,286,285,295,294,296,297,303,302,298,346,351,347,306,353,352,342,305,339,316,313,310,355,334,307,311,329,321,327,332,322,328,359,360,364,338,365,363,356,true,"2026-11-07T11:26:37.791462Z"]