#1
⏱️ 97.44 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"bat-yam"]
#2
⏱️ 698.13 мс
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:
["grocery","baking_spices",751,124,232,1121,1250,1260,618,318,409,459,676,675,677,true,751,124,232,1121,1250,1260,618,318,409,459,676,675,677]
#3
⏱️ 509.26 мс
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:
["grocery","baking_spices",751,124,232,1121,1250,1260,618,318,409,459,676,675,677,true,751,124,232,1121,1250,1260,618,318,409,459,676,675,677]
#4
⏱️ 8.28 мс
select * from "canonical_products" where "canonical_products"."id" in (145)
#5
⏱️ 5.5 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[145]
#6
⏱️ 155.22 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4991027,4213380,4072452,2608194,1472108,1472107,1434643,1432364,1419976,1419974,685427,364789,262280,256300,249388,248808,195457,192327,189702,182689,182511,168014,161333,160615,160363,158192,156423,152127,135564,134865,132636,132009,192386,true,751,124,232,1121,1250,1260,618,318,409,459,676,675,677]
#7
⏱️ 14.2 мс
select * from "stores" where "stores"."id" in (124, 232, 318, 409, 1121, 1250, 1260)
#8
⏱️ 41.53 мс
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 = 192386 THEN 192327 WHEN sp.master_product_id = 192327 THEN 192327 ELSE sp.master_product_id END limit 500
Bindings:
[4991027,4213380,4072452,2608194,1472108,1472107,1434643,1432364,1419976,1419974,685427,364789,262280,256300,249388,248808,195457,192327,189702,182689,182511,168014,161333,160615,160363,158192,156423,152127,135564,134865,132636,132009,192386,0,751,124,232,1121,1250,1260,618,318,409,459,676,675,677]
#9
⏱️ 47.33 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[528663,530585,6277602,531151,6275999,6279731,590206,592574,5852952,5839474,5839476,5857460,5864910,5845944,5845945,1032637,1028101,1028218,1030966,1032026,1035806,1031280,1031994,1497278,5253419,1492448,1492593,1495540,5271096,5271199,1496646,1500646,5273709,1495866,5273465,1496606,1495469,1496643,5276281,2375617,2366566,2370158,2370830,2377635,2367864,2377633,2368805,3228023,2915978,2913985,2914335,2916662,2918940,2919414,2913859,2916528,2919543,3224199,2921796,2914900,3230669,1748349,1743864,1738777,1746862,1749268,1750970,1748630,1743625,1749552]
#10
⏱️ 7.8 мс
select * from "stores" where "stores"."id" in (124, 232, 318, 409, 459, 618, 751)
#11
⏱️ 3.49 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"bat-yam"]
#12
⏱️ 44.21 мс
select store_id, count(*) as total from "deals" where "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and ("expires_at" is null or "expires_at" >= ?) group by "store_id"
Bindings:
[751,124,232,1121,1250,1260,618,459,676,675,677,true,"2026-09-08T05:45:38.930992Z"]
#13
⏱️ 8.49 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["bat-yam"]
#14
⏱️ 4.88 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 12.28 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]