#1
⏱️ 263.59 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"herzliya"]
#2
⏱️ 3694.16 мс
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:
[2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,383,true,2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,383]
#3
⏱️ 3237.91 мс
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:
[2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,383,true,2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,383]
#4
⏱️ 4.66 мс
select * from "canonical_products" where "canonical_products"."id" in (28, 120, 263)
#5
⏱️ 12.45 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?)
Bindings:
[28,263,120]
#6
⏱️ 109.01 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[8506300,8338309,7518346,7516636,7443254,7439517,7431628,5280320,4991109,4991108,4991102,4991097,4991094,4991092,4991049,4990828,4990825,4990823,4990804,4990789,4990619,4990596,4990576,4990456,4990129,4989961,4989781,4989777,4989772,4989767,4989766,4988820,4988698,4988697,4988681,4988647,4988576,4988403,4988288,4988227,4988219,4987997,4987921,4987920,4987918,4987860,4987774,4987625,4987624,4987518,4987434,4987431,4987359,4987332,4987231,4987210,4987208,4987154,4987001,4986884,4986854,4986842,4986799,4986761,4986722,4986611,4986606,4986557,4986526,4986467,4986434,4986375,4986335,4986312,4986299,4986270,4986222,4986067,4985992,4985768,4985767,4985413,4985340,4985304,4985212,4985209,4985155,4985115,4985032,4985017,4985016,4984993,4984967,4984836,4984771,4984760,3619438,622184,190924,154941,95625,97843,4983744,150735,190883,96304,109535,true,2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,383]
#7
⏱️ 9.3 мс
select * from "stores" where "stores"."id" in (2, 358, 383, 542)
#8
⏱️ 69.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 = 3619438 THEN 8506300 WHEN sp.master_product_id = 8506300 THEN 8506300 WHEN sp.master_product_id = 622184 THEN 8506300 WHEN sp.master_product_id = 190924 THEN 8506300 WHEN sp.master_product_id = 154941 THEN 8506300 WHEN sp.master_product_id = 95625 THEN 8506300 WHEN sp.master_product_id = 97843 THEN 8506300 WHEN sp.master_product_id = 4983744 THEN 4985413 WHEN sp.master_product_id = 4985413 THEN 4985413 WHEN sp.master_product_id = 150735 THEN 5280320 WHEN sp.master_product_id = 5280320 THEN 5280320 WHEN sp.master_product_id = 190883 THEN 5280320 WHEN sp.master_product_id = 96304 THEN 5280320 WHEN sp.master_product_id = 109535 THEN 5280320 ELSE sp.master_product_id END limit 500
Bindings:
[8506300,8338309,7518346,7516636,7443254,7439517,7431628,5280320,4991109,4991108,4991102,4991097,4991094,4991092,4991049,4990828,4990825,4990823,4990804,4990789,4990619,4990596,4990576,4990456,4990129,4989961,4989781,4989777,4989772,4989767,4989766,4988820,4988698,4988697,4988681,4988647,4988576,4988403,4988288,4988227,4988219,4987997,4987921,4987920,4987918,4987860,4987774,4987625,4987624,4987518,4987434,4987431,4987359,4987332,4987231,4987210,4987208,4987154,4987001,4986884,4986854,4986842,4986799,4986761,4986722,4986611,4986606,4986557,4986526,4986467,4986434,4986375,4986335,4986312,4986299,4986270,4986222,4986067,4985992,4985768,4985767,4985413,4985340,4985304,4985212,4985209,4985155,4985115,4985032,4985017,4985016,4984993,4984967,4984836,4984771,4984760,3619438,622184,190924,154941,95625,97843,4983744,150735,190883,96304,109535,0,2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,383]
#9
⏱️ 27.52 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[6389146,6387997,782226,781555,1290887,1290244,2567223,2567395,2566871,2565374,2567084,358946,363096,3582178,3231874,3231885,3231950,3232081,3232107,3232130,3232131,3232146,3232229,3232269,3232323,3232326,3232418,3232454,3230858,3232881,3232882,3233106,3233181,3233336,3233384,3233413,3233426,3233449,3233489,3233548,3233581,3233640,3233671,3233720,3233725,3233836,3233875,3233913,3233956,3233968,3233998,3234115,3234268,3234322,3234324,3234345,3234446,3234473,3234545,3234548,3234632,3234738,3234739,3234888,3234974,3235032,3235034,3235035,3235111,3235333,3235341,3235402,3235517,3235690,3235761,3235795,3235811,3235812,3235934,3236880,3236881,3236886,3236891,3236895,3237075,3237243,3237570,3237690,3237710,3237733,3237903,3237918,3237937,3237939,3237942,3238163,3238244,3238246,3238249,3238254,3238260,3238261,2925978,2926037,487099,486463]
#10
⏱️ 5.41 мс
select * from "stores" where "stores"."id" in (2, 358, 383, 494, 542, 560, 626, 761)
#11
⏱️ 9.94 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"herzliya"]
#12
⏱️ 38.68 мс
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:
[2,542,761,1141,1157,1194,1219,1223,714,626,647,1343,158,198,494,560,652,1380,358,true,"2026-09-08T04:59:49.282236Z"]
#13
⏱️ 1.63 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["herzliya"]
#14
⏱️ 7.31 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 7.97 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]