#6
⏱️ 64.99 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?)
Bindings:
[7431628,7430884,7429691,7428697,3918165,3915123,3914999,3170808,3119102,3041110,2812826,2812350,2671623,2661254,2642320,2641760,2631970,2067877,2047938,2046307,1973858,1961560,1961259,1955549,1928253,1922388,1920468,1919767,1918287,1916627,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911972,1911874,1910474,1910399,1910197,1910173,1909949,1909873,1909866,1909865,1909474,1909366,1909358,1909289,1909142,1909047,1908728,1908153,1907955,1907954,1907953,1907951,1907946,1907945,1907943,1907942,1907939,1907938,1907937,1907936,1907935,1907934,1907933,1907932,1907931,1907930,1907929,1907928,1907926,1907923,1907901,1907898,1907879,1907417,1879659,1831786,1613566,1611230,1560460,1559544,1559519,1546573,1546572,1546237,1545926,1545911,1543653,1543532,1543531,1453431,1462716,160427,123050,1464228,195142,110100,1431171,170225,190786,135652,160965,4859763,4725190,191031,195116,266035,100858,2190668,132357,4172615,133491,199419,109305,150738,164584,1453314,3000385,2058963,199437,98240,4524191,133473,109566,190782,190891,96276,133484,95650,97351,2986223,107092,1915898,1455029,1986966,190894,2637094,133463,109313,98238,96274,199451,1431173,109470,133481,4641826,1453443,150758,133497,109026,1939916,1453315,157086,96300,133478,150752,109601,191005,1431175,98241,2841208,199439,1453316,161474,1453318,150753,109477,135651,133477,190931,96273,4859689,1453433,133540,150749,193911,3918166,274698,5130723,150734,133480,150751,1452766,133528,2637097,1453432,199385,133495,150728,8918271,true,90,471,243]
#8
⏱️ 39.96 мс
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 = 1453431 THEN 1907942 WHEN sp.master_product_id = 3041110 THEN 2812826 WHEN sp.master_product_id = 3170808 THEN 2812826 WHEN sp.master_product_id = 2812826 THEN 2812826 WHEN sp.master_product_id = 1462716 THEN 2812826 WHEN sp.master_product_id = 160427 THEN 2812826 WHEN sp.master_product_id = 123050 THEN 2812826 WHEN sp.master_product_id = 1907935 THEN 1907935 WHEN sp.master_product_id = 1464228 THEN 1907935 WHEN sp.master_product_id = 195142 THEN 1907935 WHEN sp.master_product_id = 110100 THEN 1907901 WHEN sp.master_product_id = 1431171 THEN 1907901 WHEN sp.master_product_id = 170225 THEN 1907901 WHEN sp.master_product_id = 1907901 THEN 1907901 WHEN sp.master_product_id = 190786 THEN 1907901 WHEN sp.master_product_id = 135652 THEN 1907901 WHEN sp.master_product_id = 7428697 THEN 7428697 WHEN sp.master_product_id = 160965 THEN 7428697 WHEN sp.master_product_id = 4859763 THEN 3119102 WHEN sp.master_product_id = 4725190 THEN 3119102 WHEN sp.master_product_id = 191031 THEN 3119102 WHEN sp.master_product_id = 3119102 THEN 3119102 WHEN sp.master_product_id = 195116 THEN 3119102 WHEN sp.master_product_id = 266035 THEN 1907933 WHEN sp.master_product_id = 100858 THEN 1907933 WHEN sp.master_product_id = 1907933 THEN 1907933 WHEN sp.master_product_id = 2190668 THEN 1907933 WHEN sp.master_product_id = 2671623 THEN 2671623 WHEN sp.master_product_id = 132357 THEN 2671623 WHEN sp.master_product_id = 4172615 THEN 1907879 WHEN sp.master_product_id = 1907879 THEN 1907879 WHEN sp.master_product_id = 133491 THEN 1907879 WHEN sp.master_product_id = 199419 THEN 1907879 WHEN sp.master_product_id = 109305 THEN 1907879 WHEN sp.master_product_id = 150738 THEN 1907879 WHEN sp.master_product_id = 1910399 THEN 1910399 WHEN sp.master_product_id = 164584 THEN 1910399 WHEN sp.master_product_id = 1453314 THEN 1907938 WHEN sp.master_product_id = 3000385 THEN 1907938 WHEN sp.master_product_id = 2058963 THEN 1907938 WHEN sp.master_product_id = 199437 THEN 1907938 WHEN sp.master_product_id = 1907938 THEN 1907938 WHEN sp.master_product_id = 98240 THEN 1907938 WHEN sp.master_product_id = 1907955 THEN 1907955 WHEN sp.master_product_id = 4524191 THEN 1907955 WHEN sp.master_product_id = 133473 THEN 1907955 WHEN sp.master_product_id = 109566 THEN 1907955 WHEN sp.master_product_id = 190782 THEN 1907955 WHEN sp.master_product_id = 1907953 THEN 1907953 WHEN sp.master_product_id = 190891 THEN 1907953 WHEN sp.master_product_id = 96276 THEN 1907953 WHEN sp.master_product_id = 133484 THEN 1907953 WHEN sp.master_product_id = 95650 THEN 1907936 WHEN sp.master_product_id = 97351 THEN 1907936 WHEN sp.master_product_id = 2986223 THEN 1907936 WHEN sp.master_product_id = 107092 THEN 1907936 WHEN sp.master_product_id = 1915898 THEN 1907936 WHEN sp.master_product_id = 1455029 THEN 1907936 WHEN sp.master_product_id = 1986966 THEN 1907936 WHEN sp.master_product_id = 1907936 THEN 1907936 WHEN sp.master_product_id = 190894 THEN 1907936 WHEN sp.master_product_id = 2637094 THEN 1907936 WHEN sp.master_product_id = 133463 THEN 1907936 WHEN sp.master_product_id = 109313 THEN 1907936 WHEN sp.master_product_id = 98238 THEN 1907936 WHEN sp.master_product_id = 96274 THEN 1907931 WHEN sp.master_product_id = 199451 THEN 1907931 WHEN sp.master_product_id = 1907931 THEN 1907931 WHEN sp.master_product_id = 1431173 THEN 1907931 WHEN sp.master_product_id = 109470 THEN 1907931 WHEN sp.master_product_id = 133481 THEN 1907931 WHEN sp.master_product_id = 4641826 THEN 1907929 WHEN sp.master_product_id = 1453443 THEN 1907929 WHEN sp.master_product_id = 150758 THEN 1907929 WHEN sp.master_product_id = 1907929 THEN 1907929 WHEN sp.master_product_id = 133497 THEN 1907929 WHEN sp.master_product_id = 109026 THEN 1907946 WHEN sp.master_product_id = 1939916 THEN 1907946 WHEN sp.master_product_id = 1453315 THEN 1907946 WHEN sp.master_product_id = 1907946 THEN 1907946 WHEN sp.master_product_id = 157086 THEN 1907946 WHEN sp.master_product_id = 96300 THEN 1907926 WHEN sp.master_product_id = 133478 THEN 1907926 WHEN sp.master_product_id = 150752 THEN 1907926 WHEN sp.master_product_id = 109601 THEN 1907926 WHEN sp.master_product_id = 191005 THEN 1907926 WHEN sp.master_product_id = 1431175 THEN 1907926 WHEN sp.master_product_id = 1907926 THEN 1907926 WHEN sp.master_product_id = 98241 THEN 1907937 WHEN sp.master_product_id = 1907937 THEN 1907937 WHEN sp.master_product_id = 2841208 THEN 1907937 WHEN sp.master_product_id = 199439 THEN 1907937 WHEN sp.master_product_id = 1453316 THEN 1907937 WHEN sp.master_product_id = 161474 THEN 1907937 WHEN sp.master_product_id = 1907932 THEN 1907932 WHEN sp.master_product_id = 1453318 THEN 1907932 WHEN sp.master_product_id = 150753 THEN 1907954 WHEN sp.master_product_id = 109477 THEN 1907954 WHEN sp.master_product_id = 135651 THEN 1907954 WHEN sp.master_product_id = 133477 THEN 1907954 WHEN sp.master_product_id = 190931 THEN 1907954 WHEN sp.master_product_id = 1907954 THEN 1907954 WHEN sp.master_product_id = 96273 THEN 1907954 WHEN sp.master_product_id = 4859689 THEN 1907945 WHEN sp.master_product_id = 1907945 THEN 1907945 WHEN sp.master_product_id = 1453433 THEN 1907945 WHEN sp.master_product_id = 133540 THEN 1907945 WHEN sp.master_product_id = 150749 THEN 1907945 WHEN sp.master_product_id = 193911 THEN 1961259 WHEN sp.master_product_id = 1961259 THEN 1961259 WHEN sp.master_product_id = 3918166 THEN 1961259 WHEN sp.master_product_id = 3914999 THEN 3914999 WHEN sp.master_product_id = 3918165 THEN 3914999 WHEN sp.master_product_id = 274698 THEN 1908728 WHEN sp.master_product_id = 1908728 THEN 1908728 WHEN sp.master_product_id = 5130723 THEN 1907930 WHEN sp.master_product_id = 1907930 THEN 1907930 WHEN sp.master_product_id = 150734 THEN 1907930 WHEN sp.master_product_id = 133480 THEN 1907930 WHEN sp.master_product_id = 150751 THEN 1879659 WHEN sp.master_product_id = 1452766 THEN 1879659 WHEN sp.master_product_id = 133528 THEN 1879659 WHEN sp.master_product_id = 1879659 THEN 1879659 WHEN sp.master_product_id = 2637097 THEN 1879659 WHEN sp.master_product_id = 1453432 THEN 1907943 WHEN sp.master_product_id = 199385 THEN 1907943 WHEN sp.master_product_id = 1907943 THEN 1907943 WHEN sp.master_product_id = 133495 THEN 1907943 WHEN sp.master_product_id = 150728 THEN 1907943 WHEN sp.master_product_id = 8918271 THEN 1907923 WHEN sp.master_product_id = 1907923 THEN 1907923 ELSE sp.master_product_id END limit 500
Bindings:
[7431628,7430884,7429691,7428697,3918165,3915123,3914999,3170808,3119102,3041110,2812826,2812350,2671623,2661254,2642320,2641760,2631970,2067877,2047938,2046307,1973858,1961560,1961259,1955549,1928253,1922388,1920468,1919767,1918287,1916627,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911972,1911874,1910474,1910399,1910197,1910173,1909949,1909873,1909866,1909865,1909474,1909366,1909358,1909289,1909142,1909047,1908728,1908153,1907955,1907954,1907953,1907951,1907946,1907945,1907943,1907942,1907939,1907938,1907937,1907936,1907935,1907934,1907933,1907932,1907931,1907930,1907929,1907928,1907926,1907923,1907901,1907898,1907879,1907417,1879659,1831786,1613566,1611230,1560460,1559544,1559519,1546573,1546572,1546237,1545926,1545911,1543653,1543532,1543531,1453431,1462716,160427,123050,1464228,195142,110100,1431171,170225,190786,135652,160965,4859763,4725190,191031,195116,266035,100858,2190668,132357,4172615,133491,199419,109305,150738,164584,1453314,3000385,2058963,199437,98240,4524191,133473,109566,190782,190891,96276,133484,95650,97351,2986223,107092,1915898,1455029,1986966,190894,2637094,133463,109313,98238,96274,199451,1431173,109470,133481,4641826,1453443,150758,133497,109026,1939916,1453315,157086,96300,133478,150752,109601,191005,1431175,98241,2841208,199439,1453316,161474,1453318,150753,109477,135651,133477,190931,96273,4859689,1453433,133540,150749,193911,3918166,274698,5130723,150734,133480,150751,1452766,133528,2637097,1453432,199385,133495,150728,8918271,0,90,471,243]
#9
⏱️ 20.77 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4813935,4811437,4813911,4813929,4813931,4813948,4813951,4813953,4813954,4813955,4813956,4813957,4813958,4813959,4813960,4813961,4813962,4813963,4813964,4813967,4813968,4813969,4813970,4813975,4813977,4813978,4813979,4814085,4817728,4820319,4820371,4820379,4820454,4820693,4820694,4820701,4820745,4823417,4823439,4823608,4823667,4832147,4832227,4832254,4832265,4832332,4832333,4832431,4832441,4832490,4823586,4832130,4811369,4814007,4820639,4817741,4823624,4817731,4820369,4814191,5384670,5384671,5384780,5395137,5395152,5397451,5397793,5397794,2481533,2481506,2481589,2481495,2481511,2481497,2481498,2481481,2481509,2481547,2481501,2481494,2481491,2481969,2481974,2481438,2481470,2481439,2481545,2481982,2481079,2480011,2477433,2481358,2477932,2481978,2480831,2477178,2477435,2478429,2479622,2480366]