#5
⏱️ 13.34 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[193,44,90,239,152,32,149,201,359,7,173]
#6
⏱️ 16.28 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?)
Bindings:
[7529293,7493489,7466366,7431628,7430884,7429691,7428697,6744655,6708345,4039359,3929128,3918545,3918165,3915123,3887679,3885397,3885380,3885348,3880530,3876067,3875670,3875648,3864304,3844601,3804990,3795026,3734287,3713449,3700683,3676089,3643885,3580503,3301192,112362,160961,95809,133465,3914999,162827,103034,205836,1946614,864799,160959,170208,160965,1458061,199262,1909941,1930007,406907,129450,133462,95617,109137,195158,160081,112088,112818,109100,113137,112107,2749844,95614,3719257,154955,97844,170223,127440,129463,true,471,90,243]
#8
⏱️ 31.95 мс
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 = 3301192 THEN 3885348 WHEN sp.master_product_id = 112362 THEN 7529293 WHEN sp.master_product_id = 7428697 THEN 7428697 WHEN sp.master_product_id = 160961 THEN 3875670 WHEN sp.master_product_id = 95809 THEN 3795026 WHEN sp.master_product_id = 133465 THEN 3713449 WHEN sp.master_product_id = 3713449 THEN 3713449 WHEN sp.master_product_id = 3643885 THEN 3643885 WHEN sp.master_product_id = 3914999 THEN 3918165 WHEN sp.master_product_id = 162827 THEN 3875670 WHEN sp.master_product_id = 103034 THEN 3885397 WHEN sp.master_product_id = 205836 THEN 4039359 WHEN sp.master_product_id = 1946614 THEN 3885397 WHEN sp.master_product_id = 3885348 THEN 3885348 WHEN sp.master_product_id = 864799 THEN 3713449 WHEN sp.master_product_id = 160959 THEN 3885397 WHEN sp.master_product_id = 170208 THEN 3875670 WHEN sp.master_product_id = 3875670 THEN 3875670 WHEN sp.master_product_id = 3876067 THEN 3876067 WHEN sp.master_product_id = 160965 THEN 7428697 WHEN sp.master_product_id = 1458061 THEN 4039359 WHEN sp.master_product_id = 3795026 THEN 3795026 WHEN sp.master_product_id = 199262 THEN 3713449 WHEN sp.master_product_id = 1909941 THEN 4039359 WHEN sp.master_product_id = 1930007 THEN 4039359 WHEN sp.master_product_id = 406907 THEN 3713449 WHEN sp.master_product_id = 129450 THEN 3876067 WHEN sp.master_product_id = 133462 THEN 3885397 WHEN sp.master_product_id = 95617 THEN 3713449 WHEN sp.master_product_id = 109137 THEN 3885397 WHEN sp.master_product_id = 7529293 THEN 7529293 WHEN sp.master_product_id = 3918165 THEN 3918165 WHEN sp.master_product_id = 195158 THEN 3885348 WHEN sp.master_product_id = 160081 THEN 3643885 WHEN sp.master_product_id = 112088 THEN 3875670 WHEN sp.master_product_id = 112818 THEN 4039359 WHEN sp.master_product_id = 109100 THEN 3713449 WHEN sp.master_product_id = 113137 THEN 3885348 WHEN sp.master_product_id = 112107 THEN 3643885 WHEN sp.master_product_id = 2749844 THEN 3885397 WHEN sp.master_product_id = 95614 THEN 3885397 WHEN sp.master_product_id = 3719257 THEN 3876067 WHEN sp.master_product_id = 154955 THEN 3643885 WHEN sp.master_product_id = 97844 THEN 3885348 WHEN sp.master_product_id = 4039359 THEN 4039359 WHEN sp.master_product_id = 170223 THEN 3713449 WHEN sp.master_product_id = 127440 THEN 4039359 WHEN sp.master_product_id = 3885397 THEN 3885397 WHEN sp.master_product_id = 129463 THEN 4039359 ELSE sp.master_product_id END limit 500
Bindings:
[7529293,7493489,7466366,7431628,7430884,7429691,7428697,6744655,6708345,4039359,3929128,3918545,3918165,3915123,3887679,3885397,3885380,3885348,3880530,3876067,3875670,3875648,3864304,3844601,3804990,3795026,3734287,3713449,3700683,3676089,3643885,3580503,3301192,112362,160961,95809,133465,3914999,162827,103034,205836,1946614,864799,160959,170208,160965,1458061,199262,1909941,1930007,406907,129450,133462,95617,109137,195158,160081,112088,112818,109100,113137,112107,2749844,95614,3719257,154955,97844,170223,127440,129463,0,471,90,243]
#9
⏱️ 34.02 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4811431,4811428,4823392,4820441,89824400,31554676,11861011,30148410,2481483,11876815,11872440,33710101,11850942,31550768,33685601,33685655,2481607,33695992,33707306,33707338,2481480,33712134,2477178,2480831,109175204,109175979,2481608,11843921,11876976,2477435,2478429,2479622,2480366,30141109,30150404,11850154]