#2
⏱️ 314.25 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null and "category_slug" = ? and "subcategory_slug" = ? and (exists (select 1 from "store_prices" where "store_prices"."master_product_id" = "master_products"."id" and "store_prices"."store_id" in (?, ?, ?)) or exists (select 1 from "deals" where "deals"."master_product_id" = "master_products"."id" and "deals"."is_active" = ? and "deals"."store_id" in (?, ?, ?)))
Bindings:
["meat","poultry",90,471,243,true,90,471,243]
#3
⏱️ 97.89 мс
select * from "master_products" where "barcode" is not null and "category_slug" = ? and "subcategory_slug" = ? and (exists (select 1 from "store_prices" where "store_prices"."master_product_id" = "master_products"."id" and "store_prices"."store_id" in (?, ?, ?)) or exists (select 1 from "deals" where "deals"."master_product_id" = "master_products"."id" and "deals"."is_active" = ? and "deals"."store_id" in (?, ?, ?))) order by CASE WHEN master_products.image_url IS NOT NULL AND master_products.image_url != '' THEN 0 ELSE 1 END, "master_products"."id" desc limit 32 offset 0
Bindings:
["meat","poultry",90,471,243,true,90,471,243]
#4
⏱️ 15.29 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?)
Bindings:
[199992,127300,123529,104319,99416,97434,7432055,7428537,2959685,2707024,2678283,2674970,2663337,2662891,2662263,2661690,2644102,2640539,2639367,1914624,1909069,1908974,1908568,1908567,1907896,1907895,1907894,1907893,1907892,1907891,1907890,1907889,true,90,471,243]
#6
⏱️ 7.49 мс
select * from "store_prices" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "price" > ? and "store_id" in (?, ?, ?)
Bindings:
[199992,127300,123529,104319,99416,97434,7432055,7428537,2959685,2707024,2678283,2674970,2663337,2662891,2662263,2661690,2644102,2640539,2639367,1914624,1909069,1908974,1908568,1908567,1907896,1907895,1907894,1907893,1907892,1907891,1907890,1907889,0,90,471,243]