#1
⏱️ 80.62 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"ashkelon"]
#2
⏱️ 2801.04 мс
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:
[737,765,405,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352,true,737,765,405,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352]
#3
⏱️ 3761.3 мс
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 288
Bindings:
[737,765,405,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352,true,737,765,405,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352]
#4
⏱️ 3.23 мс
select * from "canonical_products" where "canonical_products"."id" in (11, 128, 240, 252)
#5
⏱️ 14.72 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?)
Bindings:
[11,240,252,128]
#6
⏱️ 276.27 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[1945358,1912771,1911330,1909047,1908728,1880161,1879673,1879667,1879660,1879659,1879265,1879254,1831786,1717061,1613566,1611230,1560460,1559544,1559519,1546573,1546572,1545926,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1514625,1514597,1512197,1507541,1507474,1507326,1506487,1505646,1503576,1502783,1502751,1500597,1499977,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1497222,1496758,1496655,1490638,1489901,1489703,1489397,1489153,1489097,1488873,1488619,1488451,1486463,1486122,1485595,1485591,1485534,1485362,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480753,1480657,1480110,1480054,1480026,1479996,1479994,1479992,1479985,1479983,1479963,1477827,1477241,1477236,1477192,1477123,1477115,1476892,1476473,1476334,809367,420472,3015043,95010,764101,3549846,337070,124804,2769595,101043,2901961,3675179,368474,374223,2950238,122806,95379,2742300,2629564,3261507,1907886,2639215,101044,322317,127029,154873,123105,122841,102185,102244,130085,94867,94974,97463,98565,101042,101339,1463382,199293,150781,274698,150751,1452766,133528,2637097,true,737,765,405,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352]
#7
⏱️ 14.41 мс
select * from "stores" where "stores"."id" in (37, 122, 131, 169, 182, 247, 303, 352, 405, 737, 1125, 1159, 1175, 1192, 1317, 1361, 1394)
#8
⏱️ 100.75 мс
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 = 809367 THEN 1945358 WHEN sp.master_product_id = 420472 THEN 1945358 WHEN sp.master_product_id = 3015043 THEN 1945358 WHEN sp.master_product_id = 95010 THEN 1945358 WHEN sp.master_product_id = 764101 THEN 1945358 WHEN sp.master_product_id = 3549846 THEN 1945358 WHEN sp.master_product_id = 337070 THEN 1945358 WHEN sp.master_product_id = 1945358 THEN 1945358 WHEN sp.master_product_id = 124804 THEN 1945358 WHEN sp.master_product_id = 2769595 THEN 1945358 WHEN sp.master_product_id = 101043 THEN 1945358 WHEN sp.master_product_id = 2901961 THEN 1945358 WHEN sp.master_product_id = 3675179 THEN 1945358 WHEN sp.master_product_id = 368474 THEN 1945358 WHEN sp.master_product_id = 374223 THEN 1945358 WHEN sp.master_product_id = 2950238 THEN 1945358 WHEN sp.master_product_id = 122806 THEN 1945358 WHEN sp.master_product_id = 95379 THEN 1945358 WHEN sp.master_product_id = 2742300 THEN 1945358 WHEN sp.master_product_id = 2629564 THEN 1945358 WHEN sp.master_product_id = 3261507 THEN 1945358 WHEN sp.master_product_id = 1907886 THEN 1945358 WHEN sp.master_product_id = 2639215 THEN 1945358 WHEN sp.master_product_id = 101044 THEN 1945358 WHEN sp.master_product_id = 322317 THEN 1945358 WHEN sp.master_product_id = 127029 THEN 1945358 WHEN sp.master_product_id = 154873 THEN 1945358 WHEN sp.master_product_id = 123105 THEN 1945358 WHEN sp.master_product_id = 122841 THEN 1945358 WHEN sp.master_product_id = 102185 THEN 1945358 WHEN sp.master_product_id = 102244 THEN 1945358 WHEN sp.master_product_id = 130085 THEN 1945358 WHEN sp.master_product_id = 94867 THEN 1945358 WHEN sp.master_product_id = 94974 THEN 1945358 WHEN sp.master_product_id = 97463 THEN 1945358 WHEN sp.master_product_id = 98565 THEN 1945358 WHEN sp.master_product_id = 101042 THEN 1945358 WHEN sp.master_product_id = 101339 THEN 1945358 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 = 274698 THEN 1908728 WHEN sp.master_product_id = 1908728 THEN 1908728 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:
[1945358,1912771,1911330,1909047,1908728,1880161,1879673,1879667,1879660,1879659,1879265,1879254,1831786,1717061,1613566,1611230,1560460,1559544,1559519,1546573,1546572,1545926,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1514625,1514597,1512197,1507541,1507474,1507326,1506487,1505646,1503576,1502783,1502751,1500597,1499977,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1497222,1496758,1496655,1490638,1489901,1489703,1489397,1489153,1489097,1488873,1488619,1488451,1486463,1486122,1485595,1485591,1485534,1485362,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480753,1480657,1480110,1480054,1480026,1479996,1479994,1479992,1479985,1479983,1479963,1477827,1477241,1477236,1477192,1477123,1477115,1476892,1476473,1476334,809367,420472,3015043,95010,764101,3549846,337070,124804,2769595,101043,2901961,3675179,368474,374223,2950238,122806,95379,2742300,2629564,3261507,1907886,2639215,101044,322317,127029,154873,123105,122841,102185,102244,130085,94867,94974,97463,98565,101042,101339,1463382,199293,150781,274698,150751,1452766,133528,2637097,0,737,765,405,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352]
#9
⏱️ 19.79 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[452679,6345481,6046799,6043549,547083,4720133,4720431,4722828,4722860,4723395,4729812,4729821,4729822,4729842,4729847,4729871,4722834,4717423,4720002,4728350,4730001,4717306,4717055,4717067,4719988,4720013,4726374,4720009,4726530,4720006,5586937,5589048,5589113,5589121,5589173,5589177,5598559,5598583,5598922,5599010,5584208,5588837,5589128,5586705,5589176,5598558,5598917,5584204,5584047,5584212,5584219,5586682,5593771,5588988,5589108,5593871,5586661,5586673,5598554,5582224,5582476,5582477,5582482,5582487,5582205,5235275,5236673,5236674,5236681,5236686,5239569,5234910,1461098,1460193,2465497,2465776,2465780,2541821,2542221,2542231,3340602,3340572,3352499,3344087,3826563,509270]
#10
⏱️ 10.74 мс
select * from "stores" where "stores"."id" in (37, 122, 131, 169, 182, 247, 303, 352, 405, 467, 489, 544, 737, 765)
#11
⏱️ 1.42 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"ashkelon"]
#12
⏱️ 41.2 мс
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:
[737,765,1394,1125,1159,1175,1192,544,1317,122,131,168,182,247,303,467,489,1361,37,169,352,true,"2026-09-08T04:57:43.537776Z"]
#13
⏱️ 13.67 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["ashkelon"]
#14
⏱️ 5.21 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#15
⏱️ 11.08 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]