#1
⏱️ 118.5 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"petah-tikva"]
#2
⏱️ 1734.35 мс
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:
[18,732,750,771,190,356,1145,1211,1239,1246,1262,1306,1328,1334,324,330,391,34,35,103,146,152,174,191,216,224,276,338,448,484,503,504,505,1354,553,575,579,648,655,662,681,688,689,104,257,308,true,18,732,750,771,190,356,1145,1211,1239,1246,1262,1306,1328,1334,324,330,391,34,35,103,146,152,174,191,216,224,276,338,448,484,503,504,505,1354,553,575,579,648,655,662,681,688,689,104,257,308]
#3
⏱️ 3941.62 мс
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 53568
Bindings:
[18,732,750,771,190,356,1145,1211,1239,1246,1262,1306,1328,1334,324,330,391,34,35,103,146,152,174,191,216,224,276,338,448,484,503,504,505,1354,553,575,579,648,655,662,681,688,689,104,257,308,true,18,732,750,771,190,356,1145,1211,1239,1246,1262,1306,1328,1334,324,330,391,34,35,103,146,152,174,191,216,224,276,338,448,484,503,504,505,1354,553,575,579,648,655,662,681,688,689,104,257,308]
#4
⏱️ 867.85 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[102935,102933,102931,102922,102916,102914,102901,102893,102890,102889,102888,102887,102886,102885,102884,102856,102854,102834,102832,102829,102828,102816,102815,102814,102799,102798,102797,102796,102795,102794,102777,102776,102771,102770,102769,102760,102759,102758,102757,102756,102754,102751,102744,102742,102713,102695,102692,102678,102675,102664,102663,102662,102642,102641,102632,102628,102626,102620,102619,102618,102610,102607,102603,102602,102599,102597,102594,102590,102588,102587,102581,102557,102553,102552,102531,102527,102523,102522,102521,102520,102515,102514,102511,102507,102488,102478,102476,102459,102456,102454,102432,102394,102392,102366,102362,102361,true,18,732,750,771,190,356,1145,1211,1239,1246,1262,1306,1328,1334,324,330,391,34,35,103,146,152,174,191,216,224,276,338,448,484,503,504,505,1354,553,575,579,648,655,662,681,688,689,104,257,308]
#5
⏱️ 16.08 мс
select * from "stores" where "stores"."id" in (18, 34, 35, 103, 104, 146, 152, 174, 191, 216, 224, 257, 276, 308, 324, 330, 338, 356, 391, 732, 1145, 1211, 1239, 1246, 1262, 1306, 1328, 1334, 1354)
#6
⏱️ 229.35 мс
select * from "store_prices" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "price" > ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[102935,102933,102931,102922,102916,102914,102901,102893,102890,102889,102888,102887,102886,102885,102884,102856,102854,102834,102832,102829,102828,102816,102815,102814,102799,102798,102797,102796,102795,102794,102777,102776,102771,102770,102769,102760,102759,102758,102757,102756,102754,102751,102744,102742,102713,102695,102692,102678,102675,102664,102663,102662,102642,102641,102632,102628,102626,102620,102619,102618,102610,102607,102603,102602,102599,102597,102594,102590,102588,102587,102581,102557,102553,102552,102531,102527,102523,102522,102521,102520,102515,102514,102511,102507,102488,102478,102476,102459,102456,102454,102432,102394,102392,102366,102362,102361,0,18,732,750,771,190,356,1145,1211,1239,1246,1262,1306,1328,1334,324,330,391,34,35,103,146,152,174,191,216,224,276,338,448,484,503,504,505,1354,553,575,579,648,655,662,681,688,689,104,257,308]
#7
⏱️ 13.77 мс
select * from "stores" where "stores"."id" in (18, 34, 35, 103, 104, 146, 152, 174, 191, 216, 224, 257, 276, 308, 324, 330, 338, 356, 391, 448, 484, 503, 504, 505, 553, 575, 579, 732, 750, 771)
#8
⏱️ 24.38 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["petah-tikva"]
#9
⏱️ 15.07 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#10
⏱️ 21.72 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]