#1
⏱️ 150.5 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"holon","shufersal"]
#2
⏱️ 514.21 мс
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:
[253,23,145,167,234,360,true,253,23,145,167,234,360]
#3
⏱️ 562.26 мс
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:
[253,23,145,167,234,360,true,253,23,145,167,234,360]
#4
⏱️ 13.53 мс
select * from "canonical_products" where "canonical_products"."id" in (252)
#5
⏱️ 3.76 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[252]
#6
⏱️ 188.39 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?)
Bindings:
[4533815,2319509,2067877,2049531,2047938,2046307,2045870,2045396,1880161,1879673,1879667,1879660,1879659,1879254,1831786,1630736,1613566,1611230,1578616,1560460,1559544,1559519,1546573,1546572,1545926,1531752,1531746,1525483,1525477,1525313,1524934,1519996,1518867,1518864,1518167,1516114,1515669,1515633,1515428,1512197,1507541,1507474,1507418,1507326,1506487,1505646,1503576,1502783,1502751,1501043,1500597,1499977,1499067,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1494697,1490723,1490638,1490558,1490550,1489901,1489397,1489262,1489153,1489097,1488873,1488651,1488619,1488451,1486242,1486122,1485595,1485591,1485566,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480657,1480549,1480538,1480110,1480071,1480054,150751,1452766,133528,2637097,true,253,23,145,167,234,360]
#7
⏱️ 5.3 мс
select * from "stores" where "stores"."id" in (23, 145, 234, 253, 360)
#8
⏱️ 38.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 = 150751 THEN 1879659 WHEN sp.master_product_id = 1452766 THEN 1879659 WHEN sp.master_product_id = 133528 THEN 1879659 WHEN sp.master_product_id = 1879659 THEN 1879659 WHEN sp.master_product_id = 2637097 THEN 1879659 ELSE sp.master_product_id END limit 500
Bindings:
[4533815,2319509,2067877,2049531,2047938,2046307,2045870,2045396,1880161,1879673,1879667,1879660,1879659,1879254,1831786,1630736,1613566,1611230,1578616,1560460,1559544,1559519,1546573,1546572,1545926,1531752,1531746,1525483,1525477,1525313,1524934,1519996,1518867,1518864,1518167,1516114,1515669,1515633,1515428,1512197,1507541,1507474,1507418,1507326,1506487,1505646,1503576,1502783,1502751,1501043,1500597,1499977,1499067,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1494697,1490723,1490638,1490558,1490550,1489901,1489397,1489262,1489153,1489097,1488873,1488651,1488619,1488451,1486242,1486122,1485595,1485591,1485566,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480657,1480549,1480538,1480110,1480071,1480054,150751,1452766,133528,2637097,0,253,23,145,167,234,360]
#9
⏱️ 17.45 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5900395,5902683,5216859,5219589,5248641,5810465,5812373,5793595,5795944,5798370,8180526,5798296,5812188,5812419,5791543,5793575,5798442,5798261,5810401,5791801,5791810,5798443,5802870,5807629,5810165,5791750,5798172,5798301,5798355,5800745,5812428,5798437,5798440,5309305,5309317,5311183,5291299,5293643,5293662,8149029,5298164,5298169,5298240,5291300,5291307,8149032,5298260,5302959,5298161,5293644,5295985,5298163,5298326,5298333,4250616,4252575,4252576,4252583,4252588,4255007,4252563,4252859,4260615,4264436,4252861]
#10
⏱️ 7.38 мс
select * from "stores" where "stores"."id" in (23, 145, 234, 253, 360)
#11
⏱️ 2.55 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"holon","shufersal"]
#12
⏱️ 30.92 мс
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:
[23,145,167,234,360,true,"2026-09-08T05:15:44.132979Z"]
#13
⏱️ 2.39 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["holon"]
#14
⏱️ 10.04 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 6.25 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]