#6
⏱️ 204.87 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[39417299,11135534,6778985,4536333,4072560,2257916,2190661,2190601,2190128,2151263,2136438,2049531,2045870,2045396,2037598,1987013,1972068,1966954,1962114,1962021,1955549,1954840,1952651,1943841,1942767,1935265,1932597,1930007,1928902,1926920,1926121,1926120,1922599,1921957,1921228,1920468,1919768,1919767,1918295,1918287,1917004,1916627,1915185,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911990,1911972,1911874,1911613,1911330,1910510,1910474,1910399,1910364,1910363,1910304,1910197,1910173,1910051,1909949,1909941,1909908,1909890,1909873,1909866,1909865,1909820,1909819,1909719,1909474,1909383,1909369,1909366,1909358,1909289,1909168,1909143,1909142,1909047,1908879,1908728,1908616,1908615,1908313,1908290,1908153,1908144,1907955,1907954,1907953,1907951,112423,2190109,97564,190782,2927777,193944,109863,1432304,96273,1920702,160117,598075,1453448,4642172,133477,4227275,109477,164584,150753,133484,1458061,274698,198874,7477797,4524191,4034737,133509,190931,7569492,1456475,133504,133473,166132,205836,134045,190891,112818,109889,109566,111462,96276,4039359,127440,129463,131339,135651,true,101,275]
#8
⏱️ 198.21 мс
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 = 112423 THEN 1943841 WHEN sp.master_product_id = 1909143 THEN 1909143 WHEN sp.master_product_id = 2190128 THEN 2190128 WHEN sp.master_product_id = 2190109 THEN 1952651 WHEN sp.master_product_id = 1909820 THEN 1909820 WHEN sp.master_product_id = 97564 THEN 2190128 WHEN sp.master_product_id = 190782 THEN 1907955 WHEN sp.master_product_id = 2927777 THEN 1909820 WHEN sp.master_product_id = 193944 THEN 1908879 WHEN sp.master_product_id = 1907953 THEN 1907953 WHEN sp.master_product_id = 109863 THEN 1943841 WHEN sp.master_product_id = 1432304 THEN 1987013 WHEN sp.master_product_id = 96273 THEN 1907954 WHEN sp.master_product_id = 1920702 THEN 1917004 WHEN sp.master_product_id = 160117 THEN 1926920 WHEN sp.master_product_id = 2190601 THEN 2190601 WHEN sp.master_product_id = 2190661 THEN 2190661 WHEN sp.master_product_id = 1987013 THEN 1987013 WHEN sp.master_product_id = 1908728 THEN 1908728 WHEN sp.master_product_id = 598075 THEN 1987013 WHEN sp.master_product_id = 1453448 THEN 2190601 WHEN sp.master_product_id = 4642172 THEN 2190601 WHEN sp.master_product_id = 133477 THEN 1907954 WHEN sp.master_product_id = 1907955 THEN 1907955 WHEN sp.master_product_id = 1909168 THEN 1909168 WHEN sp.master_product_id = 1915185 THEN 1915185 WHEN sp.master_product_id = 1910399 THEN 1910399 WHEN sp.master_product_id = 4227275 THEN 1915185 WHEN sp.master_product_id = 109477 THEN 1907954 WHEN sp.master_product_id = 164584 THEN 1910399 WHEN sp.master_product_id = 150753 THEN 1907954 WHEN sp.master_product_id = 1926920 THEN 1926920 WHEN sp.master_product_id = 133484 THEN 1907953 WHEN sp.master_product_id = 1458061 THEN 1909941 WHEN sp.master_product_id = 274698 THEN 1908728 WHEN sp.master_product_id = 198874 THEN 1909143 WHEN sp.master_product_id = 7477797 THEN 1909820 WHEN sp.master_product_id = 1943841 THEN 1943841 WHEN sp.master_product_id = 4524191 THEN 1907955 WHEN sp.master_product_id = 1909941 THEN 1909941 WHEN sp.master_product_id = 1917004 THEN 1917004 WHEN sp.master_product_id = 4034737 THEN 1952651 WHEN sp.master_product_id = 133509 THEN 1952651 WHEN sp.master_product_id = 1908879 THEN 1908879 WHEN sp.master_product_id = 190931 THEN 1907954 WHEN sp.master_product_id = 7569492 THEN 1952651 WHEN sp.master_product_id = 1456475 THEN 1909168 WHEN sp.master_product_id = 133504 THEN 1987013 WHEN sp.master_product_id = 133473 THEN 1907955 WHEN sp.master_product_id = 166132 THEN 1926920 WHEN sp.master_product_id = 1930007 THEN 1909941 WHEN sp.master_product_id = 205836 THEN 1909941 WHEN sp.master_product_id = 134045 THEN 1909820 WHEN sp.master_product_id = 190891 THEN 1907953 WHEN sp.master_product_id = 1952651 THEN 1952651 WHEN sp.master_product_id = 1907954 THEN 1907954 WHEN sp.master_product_id = 112818 THEN 1909941 WHEN sp.master_product_id = 109889 THEN 2190661 WHEN sp.master_product_id = 109566 THEN 1907955 WHEN sp.master_product_id = 111462 THEN 1987013 WHEN sp.master_product_id = 96276 THEN 1907953 WHEN sp.master_product_id = 4039359 THEN 1909941 WHEN sp.master_product_id = 127440 THEN 1909941 WHEN sp.master_product_id = 129463 THEN 1909941 WHEN sp.master_product_id = 131339 THEN 2190601 WHEN sp.master_product_id = 135651 THEN 1907954 ELSE sp.master_product_id END limit 500
Bindings:
[39417299,11135534,6778985,4536333,4072560,2257916,2190661,2190601,2190128,2151263,2136438,2049531,2045870,2045396,2037598,1987013,1972068,1966954,1962114,1962021,1955549,1954840,1952651,1943841,1942767,1935265,1932597,1930007,1928902,1926920,1926121,1926120,1922599,1921957,1921228,1920468,1919768,1919767,1918295,1918287,1917004,1916627,1915185,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911990,1911972,1911874,1911613,1911330,1910510,1910474,1910399,1910364,1910363,1910304,1910197,1910173,1910051,1909949,1909941,1909908,1909890,1909873,1909866,1909865,1909820,1909819,1909719,1909474,1909383,1909369,1909366,1909358,1909289,1909168,1909143,1909142,1909047,1908879,1908728,1908616,1908615,1908313,1908290,1908153,1908144,1907955,1907954,1907953,1907951,112423,2190109,97564,190782,2927777,193944,109863,1432304,96273,1920702,160117,598075,1453448,4642172,133477,4227275,109477,164584,150753,133484,1458061,274698,198874,7477797,4524191,4034737,133509,190931,7569492,1456475,133504,133473,166132,205836,134045,190891,112818,109889,109566,111462,96276,4039359,127440,129463,131339,135651,0,101,275]
#9
⏱️ 65.16 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[6213215,6213211,6213219,6213213,45864393,21305074,6216273,73539139,80149402,70746631,23759864,67325031,27493009,5378683,5378685,5378686,5378687,5378911,5378920,5379076,5379100,5381447,5381448,5381562,5383938,5384109,5384212,5384214,5384242,5385871,5385954,5385962,5385965,5385981,5386077,5387972,5388079,5388080,5388116,5388117,5388124,5388146,5388162,5385953,5388201,5388311,5389966,5389988,5390142,5390198,5390199,5390245,5390334,5390376,5395782,5398116,5398375,8318271,5400046,5400063,5400078,5400194,5400195,5400381,5400505,5400633,5384210,5390216,5392588,5398361,5398370,5374116,5374117,5378748,5381538,5388224,5374029,5374030,5378678,5387986,5373964,5386308,27038631,56690984,5378671,5390277,5387973,5388054,5378615,5402630,5378648,85127607]