#1
⏱️ 210.33 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"raanana","shufersal"]
#2
⏱️ 722.23 мс
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:
[762,346,230,56,100,140,159,316,364,true,762,346,230,56,100,140,159,316,364]
#3
⏱️ 593.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:
[762,346,230,56,100,140,159,316,364,true,762,346,230,56,100,140,159,316,364]
#4
⏱️ 11.88 мс
select * from "canonical_products" where "canonical_products"."id" in (128, 252)
#5
⏱️ 5.8 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?)
Bindings:
[252,128]
#6
⏱️ 65.1 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4533815,2413856,2111996,2110812,2110808,2110801,2110797,2110796,2110795,2067877,2049531,2047938,2046307,2045870,2045396,1880161,1879673,1879667,1879660,1879659,1879265,1879254,1831786,1651472,1630736,1618695,1613566,1611230,1560678,1560460,1559544,1559519,1546573,1546572,1545926,1543275,1533918,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1507541,1507474,1507326,1506487,1505646,1504760,1503576,1502783,1502751,1500597,1499977,1499067,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1490638,1489901,1489397,1489153,1488651,1488619,1488451,1486475,1486460,1486344,1486122,1485595,1485591,1485511,1485449,1485422,1484879,1484479,1482018,1481357,1481354,1481353,1480889,1480753,1480657,1480540,1480538,1480473,1480110,1480071,1463382,199293,150781,150751,1452766,133528,2637097,true,762,346,230,56,100,140,159,316,364]
#7
⏱️ 5.6 мс
select * from "stores" where "stores"."id" in (100, 140, 230, 316, 346, 364)
#8
⏱️ 49.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 = 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 = 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,2413856,2111996,2110812,2110808,2110801,2110797,2110796,2110795,2067877,2049531,2047938,2046307,2045870,2045396,1880161,1879673,1879667,1879660,1879659,1879265,1879254,1831786,1651472,1630736,1618695,1613566,1611230,1560678,1560460,1559544,1559519,1546573,1546572,1545926,1543275,1533918,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1507541,1507474,1507326,1506487,1505646,1504760,1503576,1502783,1502751,1500597,1499977,1499067,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1490638,1489901,1489397,1489153,1488651,1488619,1488451,1486475,1486460,1486344,1486122,1485595,1485591,1485511,1485449,1485422,1484879,1484479,1482018,1481357,1481354,1481353,1480889,1480753,1480657,1480540,1480538,1480473,1480110,1480071,1463382,199293,150781,150751,1452766,133528,2637097,0,762,346,230,56,100,140,159,316,364]
#9
⏱️ 22.7 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4334667,4361134,5593554,5598134,5593470,5630392,5906466,5908713,5908768,5908771,5908991,8186179,5892661,5892688,5892738,5896747,5896833,5896841,5906439,5896848,5901198,5901505,5896765,5906403,5896516,5896678,5889930,5908877,5896846,5896789,921133,4932000,4934024,4934025,4934038,4934048,4937464,4934004,4937268,4944059,4937269,5340536,5340545,5342374,5342376,5342382,5342744,6114817,6114818,6114825,6116793,6114805,6116620,6120890,6116621,6118624,6118625,6118626,6118630,6118637,6118641,6122818]
#10
⏱️ 7.22 мс
select * from "stores" where "stores"."id" in (100, 140, 230, 316, 346, 364)
#11
⏱️ 7.03 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ? and "chain_slug" = ?
Bindings:
[true,"raanana","shufersal"]
#12
⏱️ 50.5 мс
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:
[762,346,56,100,140,159,316,364,true,"2026-09-08T05:05:16.258818Z"]
#13
⏱️ 5.8 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["raanana"]
#14
⏱️ 11.02 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 20.49 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]