#1
⏱️ 99.12 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"haifa"]
#2
⏱️ 4582.94 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null and "category_slug" = ? and "subcategory_slug" = ? and (exists (select 1 from "store_prices" where "store_prices"."master_product_id" = "master_products"."id" and "store_prices"."store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) or exists (select 1 from "deals" where "deals"."master_product_id" = "master_products"."id" and "deals"."is_active" = ? and "deals"."store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Bindings:
["grocery","sauces_oils",13,1111,707,202,716,734,721,102,220,309,323,1140,1156,1207,1244,1275,583,1291,1292,657,1345,9,8,49,52,57,61,62,67,72,422,434,468,472,474,1356,558,658,671,1369,1388,366,12,15,28,701,74,89,137,211,233,319,331,true,13,1111,707,202,716,734,721,102,220,309,323,1140,1156,1207,1244,1275,583,1291,1292,657,1345,9,8,49,52,57,61,62,67,72,422,434,468,472,474,1356,558,658,671,1369,1388,366,12,15,28,701,74,89,137,211,233,319,331]
#3
⏱️ 761.07 мс
select * from "master_products" where "barcode" is not null and "category_slug" = ? and "subcategory_slug" = ? and (exists (select 1 from "store_prices" where "store_prices"."master_product_id" = "master_products"."id" and "store_prices"."store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) or exists (select 1 from "deals" where "deals"."master_product_id" = "master_products"."id" and "deals"."is_active" = ? and "deals"."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 32 offset 0
Bindings:
["grocery","sauces_oils",13,1111,707,202,716,734,721,102,220,309,323,1140,1156,1207,1244,1275,583,1291,1292,657,1345,9,8,49,52,57,61,62,67,72,422,434,468,472,474,1356,558,658,671,1369,1388,366,12,15,28,701,74,89,137,211,233,319,331,true,13,1111,707,202,716,734,721,102,220,309,323,1140,1156,1207,1244,1275,583,1291,1292,657,1345,9,8,49,52,57,61,62,67,72,422,434,468,472,474,1356,558,658,671,1369,1388,366,12,15,28,701,74,89,137,211,233,319,331]
#4
⏱️ 2.33 мс
select * from "canonical_products" where "canonical_products"."id" in (242)
#5
⏱️ 0.86 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[242]
#6
⏱️ 10.61 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[123604232,119993800,117041541,117041540,117041539,117041538,112375610,91874114,85059377,82942479,80426687,75165094,66413048,64064994,61866507,39417299,36527595,34464787,34414162,32335444,32080559,30691571,27628022,25603232,8775770,8616048,8383672,4439894,4257349,4227275,4225373,4224398,1915185,true,13,1111,707,202,716,734,721,102,220,309,323,1140,1156,1207,1244,1275,583,1291,1292,657,1345,9,8,49,52,57,61,62,67,72,422,434,468,472,474,1356,558,658,671,1369,1388,366,12,15,28,701,74,89,137,211,233,319,331]
#7
⏱️ 1.74 мс
select * from "stores" where "stores"."id" in (8, 15, 72, 74, 137, 202, 211, 220, 233, 701, 734)
#8
⏱️ 7.24 мс
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 = 1915185 THEN 4227275 WHEN sp.master_product_id = 4227275 THEN 4227275 ELSE sp.master_product_id END limit 500
Bindings:
[123604232,119993800,117041541,117041540,117041539,117041538,112375610,91874114,85059377,82942479,80426687,75165094,66413048,64064994,61866507,39417299,36527595,34464787,34414162,32335444,32080559,30691571,27628022,25603232,8775770,8616048,8383672,4439894,4257349,4227275,4225373,4224398,1915185,0,13,1111,707,202,716,734,721,102,220,309,323,1140,1156,1207,1244,1275,583,1291,1292,657,1345,9,8,49,52,57,61,62,67,72,422,434,468,472,474,1356,558,658,671,1369,1388,366,12,15,28,701,74,89,137,211,233,319,331]
#9
⏱️ 13.13 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[114564000,114513266,4597505,4530467,100117251,65803233,92742968,23051386,87216560,71362725,61674691,77705673,91776779,62443159,78464797,89945745,79796582,78395237,78397728,78402136,3580982,111761885,59793702,78395089,59789884,59793699,110788413,59789894,78397726,98295627,59824179,59788262,110789388,110761507,110758723,98308738,98308747,98308771,98308801,110757133,24454828,37345286,111559330,57603420,77934030,109948672,22239520,24275124,54379199,49743840,94106138,42735139,69033338,69851759,69869083,78776674,75516485,74800140,86093451,89090895,89090921,86093501,9604298]
#10
⏱️ 1.73 мс
select * from "stores" where "stores"."id" in (8, 15, 72, 74, 137, 211, 220, 422, 434, 468, 472, 474, 558, 583, 701, 707, 734)
#11
⏱️ 1.76 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["haifa"]
#12
⏱️ 1.27 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 1.76 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]