#1
⏱️ 209.87 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"nes-ziona"]
#2
⏱️ 782.66 мс
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:
[339,614,91,110,130,272,651,true,339,614,91,110,130,272,651]
#3
⏱️ 896.75 мс
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:
[339,614,91,110,130,272,651,true,339,614,91,110,130,272,651]
#4
⏱️ 16.74 мс
select * from "canonical_products" where "canonical_products"."id" in (120)
#5
⏱️ 6.6 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[120]
#6
⏱️ 50.3 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?)
Bindings:
[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,4984753,4984746,4984537,4984495,4984486,4984481,4984460,4984429,4983744,true,339,614,91,110,130,272,651]
#7
⏱️ 59.98 мс
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 = 4983744 THEN 4985413 WHEN sp.master_product_id = 4985413 THEN 4985413 ELSE sp.master_product_id END limit 500
Bindings:
[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,4984753,4984746,4984537,4984495,4984486,4984481,4984460,4984429,4983744,0,339,614,91,110,130,272,651]
#8
⏱️ 7.98 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[3201529,3201560,3201581,3201586,3201595,3201637,3201846,3201853,3201860,3201871,3201936,3202067,3202093,3202116,3202117,3202132,3202215,3202255,3202309,3202312,3202404,3202440,3200844,3202867,3202868,3203092,3203167,3203322,3203370,3203399,3203412,3203435,3203475,3203534,3203567,3203626,3203657,3203706,3203711,3203822,3203861,3203899,3203942,3203954,3203984,3204101,3204254,3204308,3204310,3204331,3204432,3204459,3204531,3204534,3204618,3204724,3204725,3204874,3204960,3205018,3205020,3205021,3205097,3205319,3205327,3205388,3205503,3205676,3205747,3205781,3205797,3205798,3205920,3206866,3206867,3206872,3206877,3206881,3207061,3207229,3207556,3207676,3207696,3207719,3207889,3207904,3207923,3207925,3207928,3208149,3208192,3208194,3208197,3208202,3208208,3208209]
#9
⏱️ 21.39 мс
select * from "stores" where "stores"."id" in (614)
#10
⏱️ 15.99 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"nes-ziona"]
#11
⏱️ 48.3 мс
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:
[339,614,91,110,130,272,651,true,"2026-09-08T05:04:45.032504Z"]
#12
⏱️ 15.2 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["nes-ziona"]
#13
⏱️ 15.12 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#14
⏱️ 12.02 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]