#2
⏱️ 163.95 мс
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:
["pharmacy",287,true,287]
#3
⏱️ 123.91 мс
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:
["pharmacy",287,true,287]
#4
⏱️ 17.24 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?)
Bindings:
[284999,200056,189823,181578,171005,169929,169373,166589,165915,163025,162795,161695,161691,149670,134567,134261,132309,131604,127540,127249,127247,126860,126842,124221,124139,123822,123818,114826,114494,114302,113608,113388,true,287]
#6
⏱️ 8.86 мс
select * from "store_prices" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "price" > ? and "store_id" in (?)
Bindings:
[284999,200056,189823,181578,171005,169929,169373,166589,165915,163025,162795,161695,161691,149670,134567,134261,132309,131604,127540,127249,127247,126860,126842,124221,124139,123822,123818,114826,114494,114302,113608,113388,0,287]