#1
⏱️ 153.21 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"modiin","tiv_taam"]
#2
⏱️ 460.3 мс
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:
[549,true,549]
#3
⏱️ 565.45 мс
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:
[549,true,549]
#4
⏱️ 11.36 мс
select * from "canonical_products" where "canonical_products"."id" in (14, 67, 108, 116, 160)
#5
⏱️ 6.74 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?)
Bindings:
[108,67,160,116,14]
#6
⏱️ 9.49 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?)
Bindings:
[4181002,4180188,4179499,4179442,4178083,4177231,4177226,4177207,4177204,4177203,4177190,4177189,4175685,4175300,4174704,4174466,4173605,4172615,4172600,4131723,4121710,4116844,4116623,4115995,4110791,4109280,4106626,4098748,4082236,4068252,4067970,4067534,4067533,4066305,4062032,4060087,4047956,4046919,4045567,4044707,4043348,4043256,4041802,4039544,4039527,4029930,4029534,4026883,4026880,4026878,4025480,4024812,4024348,4024028,4023366,4016206,4015675,4012164,4000631,4000619,3997628,3996093,3987313,3986807,3985360,3985099,3984049,3978527,3941843,2667577,1911330,1451902,1430369,1428342,1427111,1426592,1426589,1426443,1426386,1426036,1426009,1425582,1425519,1425518,1425157,1424798,1420670,1419742,680650,366432,337183,316648,242486,205790,199537,195759,1431276,3802561,190301,94956,112515,1453504,2671004,149364,378375,162150,1907879,133491,199419,109305,150738,149286,1453489,109906,true,549]
#7
⏱️ 13.84 мс
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 = 1431276 THEN 4041802 WHEN sp.master_product_id = 3802561 THEN 4041802 WHEN sp.master_product_id = 4041802 THEN 4041802 WHEN sp.master_product_id = 190301 THEN 4041802 WHEN sp.master_product_id = 94956 THEN 4041802 WHEN sp.master_product_id = 112515 THEN 4041802 WHEN sp.master_product_id = 4177231 THEN 4177231 WHEN sp.master_product_id = 1453504 THEN 4177231 WHEN sp.master_product_id = 2671004 THEN 4177231 WHEN sp.master_product_id = 149364 THEN 4177231 WHEN sp.master_product_id = 378375 THEN 4179499 WHEN sp.master_product_id = 4179499 THEN 4179499 WHEN sp.master_product_id = 162150 THEN 4179499 WHEN sp.master_product_id = 4172615 THEN 4172615 WHEN sp.master_product_id = 1907879 THEN 4172615 WHEN sp.master_product_id = 133491 THEN 4172615 WHEN sp.master_product_id = 199419 THEN 4172615 WHEN sp.master_product_id = 109305 THEN 4172615 WHEN sp.master_product_id = 150738 THEN 4172615 WHEN sp.master_product_id = 4174466 THEN 4174466 WHEN sp.master_product_id = 149286 THEN 4174466 WHEN sp.master_product_id = 1453489 THEN 4174466 WHEN sp.master_product_id = 109906 THEN 4174466 ELSE sp.master_product_id END limit 500
Bindings:
[4181002,4180188,4179499,4179442,4178083,4177231,4177226,4177207,4177204,4177203,4177190,4177189,4175685,4175300,4174704,4174466,4173605,4172615,4172600,4131723,4121710,4116844,4116623,4115995,4110791,4109280,4106626,4098748,4082236,4068252,4067970,4067534,4067533,4066305,4062032,4060087,4047956,4046919,4045567,4044707,4043348,4043256,4041802,4039544,4039527,4029930,4029534,4026883,4026880,4026878,4025480,4024812,4024348,4024028,4023366,4016206,4015675,4012164,4000631,4000619,3997628,3996093,3987313,3986807,3985360,3985099,3984049,3978527,3941843,2667577,1911330,1451902,1430369,1428342,1427111,1426592,1426589,1426443,1426386,1426036,1426009,1425582,1425519,1425518,1425157,1424798,1420670,1419742,680650,366432,337183,316648,242486,205790,199537,195759,1431276,3802561,190301,94956,112515,1453504,2671004,149364,378375,162150,1907879,133491,199419,109305,150738,149286,1453489,109906,0,549]
#8
⏱️ 25.22 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[3504127,3507677,3503012,3503301,3508906,3508032,3506479,3496202,3496660,3496758,3501218,3501437,3501897,3501898,3502046,3502497,3502503,3502937,3503038,3503136,3503137,3503579,3504736,3506584,3498411,3506257,3501733,3503828,3502322,3507736,3508747,3508962,3496655,3496990,3502812,3504145,3506591,3506602,3506001,3496642,3497054,3502130,3502674,3502944,3503305,3503742,3504801,3504803,3504806,3507049,3507381,3499398,3499408,3501074,3502017,3502080,3502942,3503436,3504143,3504800,3498064,3499186,3502148,3502938,3502939,3503221,3503378,3503877,3504807,3496906,3498179,3499185,3502949,3503310,3503437,3506598,3503024,3496274,3496289,3497279,3496508,3498394,3498990,3499376,3500878,3500879,3500892,3500893,3500896,3500915,3496574,3501776,3503133,3503190,3503876,3504697]
#9
⏱️ 9.34 мс
select * from "stores" where "stores"."id" in (549)
#10
⏱️ 9.64 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"modiin","tiv_taam"]
#11
⏱️ 5.24 мс
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:
[549,true,"2026-09-08T04:58:33.457230Z"]
#12
⏱️ 11.15 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["modiin"]
#13
⏱️ 7.17 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#14
⏱️ 8.65 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]