#2
⏱️ 157.24 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null and "category_slug" = ? and "master_products"."id" in ((select "master_product_id" from "store_prices" where "store_id" in (?)) union (select "master_product_id" from "deals" where "is_active" = ? and "store_id" in (?)))
Bindings:
["snacks",287,true,287]
#3
⏱️ 96.68 мс
select * from "master_products" where "barcode" is not null and "category_slug" = ? and "master_products"."id" in ((select "master_product_id" from "store_prices" where "store_id" in (?)) union (select "master_product_id" from "deals" where "is_active" = ? and "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:
["snacks",287,true,287]
#4
⏱️ 11.38 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?)
Bindings:
[1458351,1452459,1227637,281449,244312,242656,168863,165422,152675,134463,134024,132666,128982,128032,127188,126289,124735,124429,124293,123663,115734,115733,115732,115483,115167,115164,115113,114426,114345,114206,113996,113995,true,287]
#6
⏱️ 9.58 мс
select * from "store_prices" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "price" > ? and "store_id" in (?)
Bindings:
[1458351,1452459,1227637,281449,244312,242656,168863,165422,152675,134463,134024,132666,128982,128032,127188,126289,124735,124429,124293,123663,115734,115733,115732,115483,115167,115164,115113,114426,114345,114206,113996,113995,0,287]