#6
⏱️ 250.96 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?)
Bindings:
[39417299,27883716,4072560,2257916,2190601,2159512,2151263,2136438,2049531,2045870,2045396,1962114,1955549,1954569,1954257,1922388,1919768,1919767,1918287,1916175,1915898,1915867,1915186,1915185,1912771,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911972,1911874,1910474,1910399,1910197,1910173,1910051,1909873,1909866,1909865,1909474,1909358,1909143,1909142,1908144,1907955,1907954,1907953,1907951,1907946,1907945,1907942,1907939,1907938,1907937,1907936,1907935,1907934,1907933,1907931,1907930,1907929,1907928,1907926,1907923,1907901,1907898,1907879,1907830,1907417,1879673,1879659,1879254,1879230,1474750,1470432,1467932,1463665,1463428,1462893,1462306,1461586,1461585,1461584,1461303,1461266,1461209,1461089,1461069,1461068,1461067,1460960,1460855,1458998,98238,98241,107092,98240,150738,4641826,133481,110100,96273,96274,199451,1453448,1464228,96300,195142,133480,133477,5130723,150758,4227275,109026,109477,164584,133478,1453433,190782,150751,2190668,157086,1453443,1907944,1431173,1431171,190894,1939916,199419,170225,133491,133484,199437,198874,1453314,1453315,1453431,150753,97351,2986223,4642172,4524191,161474,8918271,4172615,100858,1454924,150749,3000385,1455029,2058963,190931,1986966,266035,190786,133473,109601,150752,135652,4602029,190891,133528,1452766,2841208,109305,1431175,1453316,150734,133463,109470,95650,109566,96276,199439,109313,191005,133497,4859689,2637094,133540,131339,2637097,135651,true,161,667,17,82]
#8
⏱️ 170.33 мс
select min(sp.id) as best_sp_id from "store_prices" as "sp" where "sp"."master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "sp"."price" > ? and "sp"."store_id" in (?, ?, ?, ?) group by sp.store_id, CASE WHEN sp.master_product_id = 1907942 THEN 1907942 WHEN sp.master_product_id = 1909143 THEN 1909143 WHEN sp.master_product_id = 98238 THEN 1907936 WHEN sp.master_product_id = 98241 THEN 1907937 WHEN sp.master_product_id = 107092 THEN 1907936 WHEN sp.master_product_id = 98240 THEN 1907938 WHEN sp.master_product_id = 150738 THEN 1907879 WHEN sp.master_product_id = 4641826 THEN 1907929 WHEN sp.master_product_id = 133481 THEN 1907931 WHEN sp.master_product_id = 110100 THEN 1907901 WHEN sp.master_product_id = 1907953 THEN 1907953 WHEN sp.master_product_id = 96273 THEN 1907954 WHEN sp.master_product_id = 1907879 THEN 1907879 WHEN sp.master_product_id = 2190601 THEN 2190601 WHEN sp.master_product_id = 1907931 THEN 1907931 WHEN sp.master_product_id = 96274 THEN 1907931 WHEN sp.master_product_id = 199451 THEN 1907931 WHEN sp.master_product_id = 1453448 THEN 2190601 WHEN sp.master_product_id = 1464228 THEN 1907935 WHEN sp.master_product_id = 96300 THEN 1907926 WHEN sp.master_product_id = 195142 THEN 1907935 WHEN sp.master_product_id = 1907933 THEN 1907933 WHEN sp.master_product_id = 133480 THEN 1907930 WHEN sp.master_product_id = 133477 THEN 1907954 WHEN sp.master_product_id = 1907955 THEN 1907955 WHEN sp.master_product_id = 5130723 THEN 1907930 WHEN sp.master_product_id = 1915185 THEN 1915185 WHEN sp.master_product_id = 150758 THEN 1907929 WHEN sp.master_product_id = 1910399 THEN 1910399 WHEN sp.master_product_id = 4227275 THEN 1915185 WHEN sp.master_product_id = 109026 THEN 1907946 WHEN sp.master_product_id = 109477 THEN 1907954 WHEN sp.master_product_id = 164584 THEN 1910399 WHEN sp.master_product_id = 133478 THEN 1907926 WHEN sp.master_product_id = 1453433 THEN 1907945 WHEN sp.master_product_id = 190782 THEN 1907955 WHEN sp.master_product_id = 150751 THEN 1879659 WHEN sp.master_product_id = 2190668 THEN 1907933 WHEN sp.master_product_id = 157086 THEN 1907946 WHEN sp.master_product_id = 1453443 THEN 1907929 WHEN sp.master_product_id = 1907944 THEN 1463428 WHEN sp.master_product_id = 1907945 THEN 1907945 WHEN sp.master_product_id = 1431173 THEN 1907931 WHEN sp.master_product_id = 1431171 THEN 1907901 WHEN sp.master_product_id = 190894 THEN 1907936 WHEN sp.master_product_id = 1939916 THEN 1907946 WHEN sp.master_product_id = 199419 THEN 1907879 WHEN sp.master_product_id = 170225 THEN 1907901 WHEN sp.master_product_id = 133491 THEN 1907879 WHEN sp.master_product_id = 133484 THEN 1907953 WHEN sp.master_product_id = 199437 THEN 1907938 WHEN sp.master_product_id = 198874 THEN 1909143 WHEN sp.master_product_id = 1453314 THEN 1907938 WHEN sp.master_product_id = 1453315 THEN 1907946 WHEN sp.master_product_id = 1453431 THEN 1907942 WHEN sp.master_product_id = 150753 THEN 1907954 WHEN sp.master_product_id = 97351 THEN 1907936 WHEN sp.master_product_id = 2986223 THEN 1907936 WHEN sp.master_product_id = 1467932 THEN 1467932 WHEN sp.master_product_id = 4642172 THEN 2190601 WHEN sp.master_product_id = 1462306 THEN 1462306 WHEN sp.master_product_id = 1915898 THEN 1907936 WHEN sp.master_product_id = 4524191 THEN 1907955 WHEN sp.master_product_id = 161474 THEN 1907937 WHEN sp.master_product_id = 8918271 THEN 1907923 WHEN sp.master_product_id = 4172615 THEN 1907879 WHEN sp.master_product_id = 1907929 THEN 1907929 WHEN sp.master_product_id = 1907930 THEN 1907930 WHEN sp.master_product_id = 100858 THEN 1907933 WHEN sp.master_product_id = 1454924 THEN 1462306 WHEN sp.master_product_id = 150749 THEN 1907945 WHEN sp.master_product_id = 1907923 THEN 1907923 WHEN sp.master_product_id = 3000385 THEN 1907938 WHEN sp.master_product_id = 1455029 THEN 1907936 WHEN sp.master_product_id = 2058963 THEN 1907938 WHEN sp.master_product_id = 190931 THEN 1907954 WHEN sp.master_product_id = 1907901 THEN 1907901 WHEN sp.master_product_id = 1986966 THEN 1907936 WHEN sp.master_product_id = 266035 THEN 1907933 WHEN sp.master_product_id = 1907946 THEN 1907946 WHEN sp.master_product_id = 1907937 THEN 1907937 WHEN sp.master_product_id = 1907936 THEN 1907936 WHEN sp.master_product_id = 190786 THEN 1907901 WHEN sp.master_product_id = 133473 THEN 1907955 WHEN sp.master_product_id = 109601 THEN 1907926 WHEN sp.master_product_id = 1463428 THEN 1463428 WHEN sp.master_product_id = 150752 THEN 1907926 WHEN sp.master_product_id = 135652 THEN 1907901 WHEN sp.master_product_id = 4602029 THEN 1467932 WHEN sp.master_product_id = 190891 THEN 1907953 WHEN sp.master_product_id = 133528 THEN 1879659 WHEN sp.master_product_id = 1907935 THEN 1907935 WHEN sp.master_product_id = 1452766 THEN 1879659 WHEN sp.master_product_id = 2841208 THEN 1907937 WHEN sp.master_product_id = 1907938 THEN 1907938 WHEN sp.master_product_id = 109305 THEN 1907879 WHEN sp.master_product_id = 1907954 THEN 1907954 WHEN sp.master_product_id = 1431175 THEN 1907926 WHEN sp.master_product_id = 1453316 THEN 1907937 WHEN sp.master_product_id = 150734 THEN 1907930 WHEN sp.master_product_id = 133463 THEN 1907936 WHEN sp.master_product_id = 1907926 THEN 1907926 WHEN sp.master_product_id = 109470 THEN 1907931 WHEN sp.master_product_id = 95650 THEN 1907936 WHEN sp.master_product_id = 109566 THEN 1907955 WHEN sp.master_product_id = 1879659 THEN 1879659 WHEN sp.master_product_id = 96276 THEN 1907953 WHEN sp.master_product_id = 199439 THEN 1907937 WHEN sp.master_product_id = 109313 THEN 1907936 WHEN sp.master_product_id = 191005 THEN 1907926 WHEN sp.master_product_id = 133497 THEN 1907929 WHEN sp.master_product_id = 4859689 THEN 1907945 WHEN sp.master_product_id = 2637094 THEN 1907936 WHEN sp.master_product_id = 133540 THEN 1907945 WHEN sp.master_product_id = 131339 THEN 2190601 WHEN sp.master_product_id = 2637097 THEN 1879659 WHEN sp.master_product_id = 135651 THEN 1907954 ELSE sp.master_product_id END limit 500
Bindings:
[39417299,27883716,4072560,2257916,2190601,2159512,2151263,2136438,2049531,2045870,2045396,1962114,1955549,1954569,1954257,1922388,1919768,1919767,1918287,1916175,1915898,1915867,1915186,1915185,1912771,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911972,1911874,1910474,1910399,1910197,1910173,1910051,1909873,1909866,1909865,1909474,1909358,1909143,1909142,1908144,1907955,1907954,1907953,1907951,1907946,1907945,1907942,1907939,1907938,1907937,1907936,1907935,1907934,1907933,1907931,1907930,1907929,1907928,1907926,1907923,1907901,1907898,1907879,1907830,1907417,1879673,1879659,1879254,1879230,1474750,1470432,1467932,1463665,1463428,1462893,1462306,1461586,1461585,1461584,1461303,1461266,1461209,1461089,1461069,1461068,1461067,1460960,1460855,1458998,98238,98241,107092,98240,150738,4641826,133481,110100,96273,96274,199451,1453448,1464228,96300,195142,133480,133477,5130723,150758,4227275,109026,109477,164584,133478,1453433,190782,150751,2190668,157086,1453443,1907944,1431173,1431171,190894,1939916,199419,170225,133491,133484,199437,198874,1453314,1453315,1453431,150753,97351,2986223,4642172,4524191,161474,8918271,4172615,100858,1454924,150749,3000385,1455029,2058963,190931,1986966,266035,190786,133473,109601,150752,135652,4602029,190891,133528,1452766,2841208,109305,1431175,1453316,150734,133463,109470,95650,109566,96276,199439,109313,191005,133497,4859689,2637094,133540,131339,2637097,135651,0,161,667,17,82]
#9
⏱️ 23.18 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[6093323,6112270,6088775,73539104,6093350,6093326,6111203,6088790,6098625,6098624,81688909,6093324,6093330,6093325,6093327,45831515,14988040,81688936,70713791,70713782,70717664,4849538,4852907,4852929,4852947,4852948,4852949,48434294,4852991,4853074,4853075,4853076,4837321,4837492,4840110,4852992,4840040,4837396,4837690,4840025,4840037,4840053,4840055,4840057,4840058,4840059,4840060,4840061,4840062,4840063,4840064,4840065,4840066,4840069,4840070,4840071,4840076,4840078,4840079,4840080,4840152,4843158,4843160,4843282,4843336,4846218,4846219,4846227,4846394,4846501,4846526,4846878,4851755,4851857,4851898,4851923,4851982,4851983,4852126,4852145,4852193,4853055,4843157,4843474,4851741,4837353,4837354,4843492,4843433,4846844]
