#1
⏱️ 148.18 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"tiberias"]
#2
⏱️ 591.96 мс
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
⏱️ 740.46 мс
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 480
Bindings:
[756,633,true,756,633]
#4
⏱️ 21.25 мс
select * from "canonical_products" where "canonical_products"."id" in (119, 147, 159, 250)
#5
⏱️ 10.53 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?)
Bindings:
[147,250,119,159]
#6
⏱️ 17.48 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[164725,164724,164723,164722,164721,164705,164701,164700,164551,164500,164381,164366,164173,163807,163802,163800,163798,163759,163579,163120,162990,162887,162886,162795,162585,162354,162224,162084,161956,161877,161765,161764,161695,161628,161627,161618,161516,161515,161514,161501,161499,161333,161332,161183,161181,160991,160972,160791,160786,160363,160235,159807,159289,158934,158928,158673,158672,158587,158383,158255,158187,158045,157973,157847,157753,157404,157163,156776,156616,156615,156423,156388,156380,156379,156202,156195,156089,155741,154703,154686,154680,154219,154217,154216,154161,153923,153872,153871,153870,153869,153867,153845,153844,153676,153673,153489,1989211,200741,122736,1431277,130514,3214079,7561917,1941919,1456452,191901,195947,157276,123844,true,756,633]
#7
⏱️ 23.39 мс
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 = 1989211 THEN 157753 WHEN sp.master_product_id = 200741 THEN 157753 WHEN sp.master_product_id = 157753 THEN 157753 WHEN sp.master_product_id = 122736 THEN 160972 WHEN sp.master_product_id = 1431277 THEN 160972 WHEN sp.master_product_id = 130514 THEN 160972 WHEN sp.master_product_id = 3214079 THEN 160972 WHEN sp.master_product_id = 160972 THEN 160972 WHEN sp.master_product_id = 7561917 THEN 157163 WHEN sp.master_product_id = 1941919 THEN 157163 WHEN sp.master_product_id = 1456452 THEN 157163 WHEN sp.master_product_id = 157163 THEN 157163 WHEN sp.master_product_id = 191901 THEN 157163 WHEN sp.master_product_id = 195947 THEN 157163 WHEN sp.master_product_id = 157276 THEN 157163 WHEN sp.master_product_id = 123844 THEN 158928 WHEN sp.master_product_id = 158928 THEN 158928 ELSE sp.master_product_id END limit 500
Bindings:
[164725,164724,164723,164722,164721,164705,164701,164700,164551,164500,164381,164366,164173,163807,163802,163800,163798,163759,163579,163120,162990,162887,162886,162795,162585,162354,162224,162084,161956,161877,161765,161764,161695,161628,161627,161618,161516,161515,161514,161501,161499,161333,161332,161183,161181,160991,160972,160791,160786,160363,160235,159807,159289,158934,158928,158673,158672,158587,158383,158255,158187,158045,157973,157847,157753,157404,157163,156776,156616,156615,156423,156388,156380,156379,156202,156195,156089,155741,154703,154686,154680,154219,154217,154216,154161,153923,153872,153871,153870,153869,153867,153845,153844,153676,153673,153489,1989211,200741,122736,1431277,130514,3214079,7561917,1941919,1456452,191901,195947,157276,123844,0,756,633]
#8
⏱️ 25.91 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[2956771,2956812,2956814,2956860,2956862,2956863,2956864,2956866,2956891,2956961,2956970,2956971,2956972,2957111,2957124,2958002,2958197,2958334,2958340,2958591,2958592,2958593,2958611,2958773,2958774,2958872,2959204,2959592,2959652,2959711,2959759,2959792,2959958,2960000,2960001,2960134,2960138,2960214,2960458,2960668,2960735,2960959,2961008,2961100,2961102,2961193,2961260,2961269,2961271,2961273,2961330,2961342,2961343,2961417,2961482,2961558,2961649,2961737,2961813,2961944,2962097,2962133,2962134,2962262,2962628,2962795,2962834,2962836,2962839,2962848,2963168,2963309,2963433,2963471,2963556,2963565,2963566,2963567,1808693,1809390,1809747,1813988,1814747,1818592,1811519,1814410,1818377,1806863,1814809,1818541,1808089,1815093,1808692,1806855,1817230,1808279,1805448,1816847,1817289,1817291,1807886,1817568,1816212,1811491,1813698,1814885,1810225,1815616,1807224,1806779,1808479,1806525,1806543]
#9
⏱️ 9.08 мс
select * from "stores" where "stores"."id" in (633, 756)
#10
⏱️ 6.55 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"tiberias"]
#11
⏱️ 13.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:
[756,633,true,"2026-09-08T04:58:50.104309Z"]
#12
⏱️ 9.74 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["tiberias"]
#13
⏱️ 16.94 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#14
⏱️ 14.48 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]