#2
⏱️ 1704.64 мс
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:
[1112,755,767,777,1143,1182,1196,1264,148,123,180,237,252,363,481,1379,21,true,1112,755,767,777,1143,1182,1196,1264,148,123,180,237,252,363,481,1379,21]
#3
⏱️ 2170.44 мс
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:
[1112,755,767,777,1143,1182,1196,1264,148,123,180,237,252,363,481,1379,21,true,1112,755,767,777,1143,1182,1196,1264,148,123,180,237,252,363,481,1379,21]
#4
⏱️ 49.4 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[1502671,1502138,1501278,1501043,1500597,1499977,1499020,1499018,1499016,1499015,1499012,1499008,1499005,1498940,1498805,1498779,1498105,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1497222,1497040,1496758,1496751,1496655,1490638,1490611,1490558,1490556,1490550,1489901,1489397,1489153,1489097,1488873,1488651,1488619,1488451,1487883,1487824,1486465,1486463,1486461,1486344,1486300,1486294,1486293,1486291,1486200,1486122,1485595,1485591,1485566,1485535,1485534,1485511,1485501,1485496,1485422,1484879,1484479,1483335,1482018,1481686,1481357,1481354,1481353,1481314,1480889,1480753,1480659,1480657,1480619,1480549,1480540,1480538,1480473,1480110,1480071,1480054,1480026,1479997,1479996,1479994,1479992,1479985,1479983,1479963,1479907,1479898,1479892,true,1112,755,767,777,1143,1182,1196,1264,148,123,180,237,252,363,481,1379,21]
#6
⏱️ 60.37 мс
select * from "store_prices" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "price" > ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[1502671,1502138,1501278,1501043,1500597,1499977,1499020,1499018,1499016,1499015,1499012,1499008,1499005,1498940,1498805,1498779,1498105,1498080,1498079,1498061,1498034,1498021,1497502,1497481,1497413,1497222,1497040,1496758,1496751,1496655,1490638,1490611,1490558,1490556,1490550,1489901,1489397,1489153,1489097,1488873,1488651,1488619,1488451,1487883,1487824,1486465,1486463,1486461,1486344,1486300,1486294,1486293,1486291,1486200,1486122,1485595,1485591,1485566,1485535,1485534,1485511,1485501,1485496,1485422,1484879,1484479,1483335,1482018,1481686,1481357,1481354,1481353,1481314,1480889,1480753,1480659,1480657,1480619,1480549,1480540,1480538,1480473,1480110,1480071,1480054,1480026,1479997,1479996,1479994,1479992,1479985,1479983,1479963,1479907,1479898,1479892,0,1112,755,767,777,1143,1182,1196,1264,148,123,180,237,252,363,481,1379,21]