#6
⏱️ 18.83 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[2049531,2045396,1879660,1879659,1831786,1613566,1611230,1560460,1559544,1559519,1546573,1546572,1545926,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1507541,1507474,1507326,1506487,1505646,1503576,1502783,1502751,1501043,1500597,1499977,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1490638,1489901,1489703,1489397,1489153,1488619,1488451,1488407,1486122,1485595,1485591,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480657,1480538,1480110,1480026,1479996,1479994,1479992,1479985,1479983,1479963,1477827,1477123,1477115,1476909,1476892,1476194,1476191,1476188,1476185,1476184,1476182,1476180,1476173,1476150,1476133,1476131,1476121,1476058,1476019,1475945,1475940,1475394,1475391,1475376,1475368,1475335,150751,1452766,133528,2637097,true,355,184]
#8
⏱️ 10.98 мс
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:
[2049531,2045396,1879660,1879659,1831786,1613566,1611230,1560460,1559544,1559519,1546573,1546572,1545926,1531752,1531746,1518867,1518864,1518167,1515669,1515633,1507541,1507474,1507326,1506487,1505646,1503576,1502783,1502751,1501043,1500597,1499977,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1496758,1496655,1490638,1489901,1489703,1489397,1489153,1488619,1488451,1488407,1486122,1485595,1485591,1484879,1484479,1482018,1481686,1481357,1481354,1481353,1480889,1480657,1480538,1480110,1480026,1479996,1479994,1479992,1479985,1479983,1479963,1477827,1477123,1477115,1476909,1476892,1476194,1476191,1476188,1476185,1476184,1476182,1476180,1476173,1476150,1476133,1476131,1476121,1476058,1476019,1475945,1475940,1475394,1475391,1475376,1475368,1475335,150751,1452766,133528,2637097,0,355,184]
#9
⏱️ 7.64 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4668056,4668062,4671244,4671246,4671312,4671316,4671320,4673919,4673932,4677059,4684974,4687189,4671313,4671678,4671315,4684765,4684813,4668323,8264612,4679934,4682713,4684791,5168435,5168436]