#1
⏱️ 152.64 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"zikhron-yaakov"]
#2
⏱️ 1937.94 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null 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:
[443,616,435,347,true,443,616,435,347]
#3
⏱️ 2320.92 мс
select * from "master_products" where "barcode" is not null 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 96 offset 0
Bindings:
[443,616,435,347,true,443,616,435,347]
#4
⏱️ 14.59 мс
select * from "canonical_products" where "canonical_products"."id" in (193, 238)
#5
⏱️ 13.02 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?)
Bindings:
[238,193]
#6
⏱️ 17.51 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?)
Bindings:
[75165094,74076446,72978997,66413048,56283367,39028558,29905623,24338782,11135534,8897354,7529293,7493489,7460373,7065236,6778985,6745776,6744655,6730411,6708345,5305199,4991109,4991108,4991102,4991097,4991094,4991092,4991049,4991048,4991028,4991027,4990963,4990962,4990961,4990945,4990895,4990894,4990873,4990872,4990849,4990833,4990828,4990825,4990823,4990804,4990789,4990772,4990767,4990765,4990750,4990715,4990619,4990596,4990576,4990547,4990523,4990456,4990374,4990373,4990354,4990353,4990129,4990037,4989971,4989961,4989871,4989781,4989777,4989772,4989767,4989766,4989750,4989747,4989543,4988918,4988886,4988885,4988852,4988820,4988808,4988786,4988774,4988768,4988706,4988698,4988697,4988696,4988681,4988675,4988647,4988581,4988576,4988535,4988498,4988403,4988288,4988287,112362,2317173,true,443,616,435,347]
#7
⏱️ 6.86 мс
select * from "stores" where "stores"."id" in (347)
#8
⏱️ 60.92 мс
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 = 7529293 THEN 7529293 WHEN sp.master_product_id = 112362 THEN 7529293 WHEN sp.master_product_id = 2317173 THEN 8897354 WHEN sp.master_product_id = 8897354 THEN 8897354 ELSE sp.master_product_id END limit 500
Bindings:
[75165094,74076446,72978997,66413048,56283367,39028558,29905623,24338782,11135534,8897354,7529293,7493489,7460373,7065236,6778985,6745776,6744655,6730411,6708345,5305199,4991109,4991108,4991102,4991097,4991094,4991092,4991049,4991048,4991028,4991027,4990963,4990962,4990961,4990945,4990895,4990894,4990873,4990872,4990849,4990833,4990828,4990825,4990823,4990804,4990789,4990772,4990767,4990765,4990750,4990715,4990619,4990596,4990576,4990547,4990523,4990456,4990374,4990373,4990354,4990353,4990129,4990037,4989971,4989961,4989871,4989781,4989777,4989772,4989767,4989766,4989750,4989747,4989543,4988918,4988886,4988885,4988852,4988820,4988808,4988786,4988774,4988768,4988706,4988698,4988697,4988696,4988681,4988675,4988647,4988581,4988576,4988535,4988498,4988403,4988288,4988287,112362,2317173,0,443,616,435,347]
#9
⏱️ 72.55 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5337241,36360923,10668034,10675609,10667946,10668028,10668534,10666729,10668160,33242212,29467343,35099499,77709024,71483484,36960926,57117461,56090845,56090844,10333793,10339357,10334788,10334493,10334946,1827723,10334577,55822491,1824124,77455890,51471669,67490867,67490866,3212859,3212860,3212975,3213070,3213107,3213148,3213153,3213219,3213247,3213253,3213268,3213269,3213270,3213278,3213340,3213346,3213358,3213380,3213392,3213424,3213457,3213458,3213490,3214115,3214319,3214322,3214338,3214339,3214344,3214349,3214353,3214443,3214533,3214543,3214609,3214701,3214925,3214926,3214945,3214946,3215028,3215095,3215119,3215148,3215168,3215191,3215287,3215322,3215337,3215339,3215344,3215361,3215376,3215395,3215397,3215400,3215405,3215421,3215444,3215445,3215466,3215467,3215517,3215533,3215534,3215535,3215599,3215600,3215620,3215621,3215702,3215704,3215707,3215712,3215718,3215719,7954886,84036902,2895725,73161803,72642483]
#10
⏱️ 5.72 мс
select * from "stores" where "stores"."id" in (347, 435, 443, 616)
#11
⏱️ 9.47 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"zikhron-yaakov"]
#12
⏱️ 35.54 мс
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:
[443,616,435,347,true,"2026-10-22T15:29:09.846314Z"]
#13
⏱️ 19.32 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["zikhron-yaakov"]
#14
⏱️ 10.59 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 18.18 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]