#1
⏱️ 72.9 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"herzliya","shufersal"]
#2
⏱️ 1441.29 мс
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:
[2,761,158,198,358,383,true,2,761,158,198,358,383]
#3
⏱️ 934.15 мс
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:
[2,761,158,198,358,383,true,2,761,158,198,358,383]
#4
⏱️ 7.46 мс
select * from "canonical_products" where "canonical_products"."id" in (123, 128, 189, 207, 252)
#5
⏱️ 1.15 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?)
Bindings:
[207,189,123,252,128]
#6
⏱️ 35.87 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?)
Bindings:
[4533815,2133840,2097960,2067877,2066134,2058963,2049531,2046307,2045870,2045396,1880161,1879673,1879667,1879660,1879659,1879265,1879254,1831786,1613566,1611230,1560460,1559544,1559519,1551600,1546573,1546572,1545926,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1514625,1507541,1507474,1507326,1506487,1505646,1503576,1502783,1502751,1500597,1499977,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1490638,1490550,1489901,1489397,1489153,1489097,1488900,1488619,1488451,1486122,1485595,1485591,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480657,1480549,1480540,1480538,1480110,1480026,1479996,1479994,1479992,1479985,1479983,1479963,1479401,1477827,1477249,1477140,1477123,1477115,1476888,1476886,1476791,1453314,3000385,199437,1907938,98240,1463382,199293,150781,2244024,95571,150751,1452766,133528,2637097,true,2,761,158,198,358,383]
#7
⏱️ 9.7 мс
select * from "stores" where "stores"."id" in (2, 198, 358, 383)
#8
⏱️ 36.48 мс
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 = 1453314 THEN 2058963 WHEN sp.master_product_id = 3000385 THEN 2058963 WHEN sp.master_product_id = 2058963 THEN 2058963 WHEN sp.master_product_id = 199437 THEN 2058963 WHEN sp.master_product_id = 1907938 THEN 2058963 WHEN sp.master_product_id = 98240 THEN 2058963 WHEN sp.master_product_id = 1879265 THEN 1879265 WHEN sp.master_product_id = 1463382 THEN 1879265 WHEN sp.master_product_id = 199293 THEN 1879265 WHEN sp.master_product_id = 150781 THEN 1879265 WHEN sp.master_product_id = 2066134 THEN 2066134 WHEN sp.master_product_id = 2244024 THEN 2066134 WHEN sp.master_product_id = 2133840 THEN 2133840 WHEN sp.master_product_id = 95571 THEN 2133840 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,2133840,2097960,2067877,2066134,2058963,2049531,2046307,2045870,2045396,1880161,1879673,1879667,1879660,1879659,1879265,1879254,1831786,1613566,1611230,1560460,1559544,1559519,1551600,1546573,1546572,1545926,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1514625,1507541,1507474,1507326,1506487,1505646,1503576,1502783,1502751,1500597,1499977,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1490638,1490550,1489901,1489397,1489153,1489097,1488900,1488619,1488451,1486122,1485595,1485591,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480657,1480549,1480540,1480538,1480110,1480026,1479996,1479994,1479992,1479985,1479983,1479963,1479401,1477827,1477249,1477140,1477123,1477115,1476888,1476886,1476791,1453314,3000385,199437,1907938,98240,1463382,199293,150781,2244024,95571,150751,1452766,133528,2637097,0,2,761,158,198,358,383]
#9
⏱️ 31.51 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[6391606,6387953,4414945,4415040,4415041,4415105,4415118,4415155,4417690,4426057,4426649,4426682,4426701,4426704,4429064,4429069,4429085,4406305,4409460,4409480,4412342,4415108,4409478,4409484,4414967,4426707,4428731,4429158,4406295,4409420,4415042,4415094,4426677,4428475,4406313,4406331,4409382,4409411,4409435,4409436,4420747,4423801,4409418,4406236,4415099,4409404,4426678,4426280,4291832,4291845,4294753,4294754,4294761,4294766,4294742,4297697,783888,4297699,4300638,781506,5514223,5516085,5516091,5518495,5516072,5516355,5527506,1292560,5523233,5516356,1290186,488686,486401,491685]
#10
⏱️ 7.2 мс
select * from "stores" where "stores"."id" in (2, 198, 358, 383, 761)
#11
⏱️ 6.15 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"herzliya","shufersal"]
#12
⏱️ 15.21 мс
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:
[2,761,158,198,358,true,"2026-09-08T04:59:52.642399Z"]
#13
⏱️ 5.45 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["herzliya"]
#14
⏱️ 3.45 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 3.28 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]