#1
⏱️ 159.73 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"tiberias"]
#2
⏱️ 4417.58 мс
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:
[756,633,true,756,633]
#3
⏱️ 1275.48 мс
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:
[756,633,true,756,633]
#4
⏱️ 15.47 мс
select * from "canonical_products" where "canonical_products"."id" in (193)
#5
⏱️ 4.05 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[193]
#6
⏱️ 33.82 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[75165094,74076446,72978997,66413048,56283367,54705033,39028558,7529293,7493489,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,4988283,4988282,4988227,4988219,112362,true,756,633]
#7
⏱️ 61.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 ELSE sp.master_product_id END limit 500
Bindings:
[75165094,74076446,72978997,66413048,56283367,54705033,39028558,7529293,7493489,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,4988283,4988282,4988227,4988219,112362,0,756,633]
#8
⏱️ 59.39 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[12282344,12282352,12282407,12282408,12282412,12282413,12282673,12282873,12283005,12283202,12283207,12283273,12283301,12283307,12283322,12283323,12283324,12283332,12283394,12283400,12283412,12283434,12283446,12283478,12283511,12283512,12283544,12285169,12285873,12285876,12285892,12285893,12285898,12285903,12285907,12285997,12286087,12286097,12286163,12286755,12286979,12286980,12286999,12287000,12287082,12287149,12287173,12287703,12287723,12287746,12287842,12287877,12287892,12287894,12287899,12287916,12287931,12287950,12287952,12287955,12287960,12287976,12287999,12288000,12288021,12288022,12288072,12288088,12288089,12288090,12288154,12288155,12288175,12288176,12273641,12273643,12273646,12273651,12273657,12273658,11587881,74374936,28255562,72837451,10317932,10319746,10318574,10318895,10319368,55820817,10318960,38673614,67475443,67466273,53854453,55819549,53854451,67477907]
#9
⏱️ 44.37 мс
select * from "stores" where "stores"."id" in (633, 756)
#10
⏱️ 26.83 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"tiberias"]
#11
⏱️ 31.16 мс
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:
[756,633,true,"2026-10-22T12:58:29.770990Z"]
#12
⏱️ 19.12 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["tiberias"]
#13
⏱️ 29.07 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#14
⏱️ 53.79 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]