#1
⏱️ 120.92 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"raanana"]
#2
⏱️ 951.59 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null and "category_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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) and master_products.id IN (
SELECT DISTINCT ON (COALESCE(canonical_product_id, -id)) id
FROM master_products
WHERE category_slug = ?
ORDER BY COALESCE(canonical_product_id, -id),
CASE WHEN image_url IS NOT NULL AND image_url != '' THEN 0 ELSE 1 END,
id DESC
)
Bindings:
["produce",1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692,true,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692,"produce"]
#3
⏱️ 561.03 мс
select * from "master_products" where "barcode" is not null and "category_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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) and master_products.id IN (
SELECT DISTINCT ON (COALESCE(canonical_product_id, -id)) id
FROM master_products
WHERE category_slug = ?
ORDER BY COALESCE(canonical_product_id, -id),
CASE WHEN image_url IS NOT NULL AND image_url != '' THEN 0 ELSE 1 END,
id DESC
) 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:
["produce",1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692,true,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692,"produce"]
#4
⏱️ 5.41 мс
select * from "canonical_products" where "canonical_products"."id" in (9, 75, 97, 171, 199, 281, 311, 320)
#5
⏱️ 4.79 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[281,75,320,311,9,171,97,199]
#6
⏱️ 25.04 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[7065236,6744655,6708345,4844233,4841277,4665520,4584074,4546420,4546240,4546223,4528630,4528085,4524189,4126286,4122596,4118979,4118978,4118966,4116124,4110988,4110824,4109280,4107318,4106058,4105945,4097824,4085256,4077839,4072451,4067751,4066766,4054428,1453310,156666,2984317,1465364,162808,1453360,112864,160598,4540232,4004675,2045916,157118,157278,155793,4019922,195115,1453381,192680,true,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692]
#7
⏱️ 3.59 мс
select * from "stores" where "stores"."id" in (140)
#8
⏱️ 19.99 мс
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 = 1453310 THEN 4118966 WHEN sp.master_product_id = 156666 THEN 4118966 WHEN sp.master_product_id = 2984317 THEN 4118966 WHEN sp.master_product_id = 1465364 THEN 4118966 WHEN sp.master_product_id = 162808 THEN 4118966 WHEN sp.master_product_id = 4118966 THEN 4118966 WHEN sp.master_product_id = 1453360 THEN 4118966 WHEN sp.master_product_id = 112864 THEN 4118966 WHEN sp.master_product_id = 160598 THEN 4118966 WHEN sp.master_product_id = 4540232 THEN 4584074 WHEN sp.master_product_id = 4584074 THEN 4584074 WHEN sp.master_product_id = 4004675 THEN 4105945 WHEN sp.master_product_id = 4105945 THEN 4105945 WHEN sp.master_product_id = 2045916 THEN 4110824 WHEN sp.master_product_id = 4110824 THEN 4110824 WHEN sp.master_product_id = 157118 THEN 4110824 WHEN sp.master_product_id = 157278 THEN 4110824 WHEN sp.master_product_id = 155793 THEN 4110824 WHEN sp.master_product_id = 4085256 THEN 4085256 WHEN sp.master_product_id = 4019922 THEN 4085256 WHEN sp.master_product_id = 4665520 THEN 4665520 WHEN sp.master_product_id = 195115 THEN 4665520 WHEN sp.master_product_id = 4528630 THEN 4528630 WHEN sp.master_product_id = 1453381 THEN 4528630 WHEN sp.master_product_id = 4546240 THEN 4546240 WHEN sp.master_product_id = 192680 THEN 4546240 ELSE sp.master_product_id END limit 500
Bindings:
[7065236,6744655,6708345,4844233,4841277,4665520,4584074,4546420,4546240,4546223,4528630,4528085,4524189,4126286,4122596,4118979,4118978,4118966,4116124,4110988,4110824,4109280,4107318,4106058,4105945,4097824,4085256,4077839,4072451,4067751,4066766,4054428,1453310,156666,2984317,1465364,162808,1453360,112864,160598,4540232,4004675,2045916,157118,157278,155793,4019922,195115,1453381,192680,0,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692]
#9
⏱️ 12.65 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5600423,915598,2388463,2380134,2380915,3448809,3439012,3440022,3444624,3449921,3448639,3441885,3429651,3429828,3431087,3433046,3434592,3434754,3439889,3436505,3442745,3442746,3446356,3450034,2967038,2969810,2970251,2974599,2974610,2974646,2970163,2967204,2967842,2970807]
#10
⏱️ 4.02 мс
select * from "stores" where "stores"."id" in (140, 230, 460, 585, 637)
#11
⏱️ 7.23 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"raanana"]
#12
⏱️ 27.18 мс
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:
[1108,762,346,1133,1198,1205,585,637,56,100,140,159,316,364,460,511,656,659,692,true,"2026-09-08T05:46:00.236454Z"]
#13
⏱️ 3.16 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["raanana"]
#14
⏱️ 6.49 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 7.7 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]