#1
⏱️ 194.7 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"givatayim"]
#2
⏱️ 418.35 мс
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:
["snacks","chips_savory",1118,1181,1221,1290,16,14,38,118,261,212,226,231,292,431,454,458,492,493,567,663,672,683,687,32,73,4,223,true,1118,1181,1221,1290,16,14,38,118,261,212,226,231,292,431,454,458,492,493,567,663,672,683,687,32,73,4,223]
#3
⏱️ 221.53 мс
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:
["snacks","chips_savory",1118,1181,1221,1290,16,14,38,118,261,212,226,231,292,431,454,458,492,493,567,663,672,683,687,32,73,4,223,true,1118,1181,1221,1290,16,14,38,118,261,212,226,231,292,431,454,458,492,493,567,663,672,683,687,32,73,4,223]
#4
⏱️ 8.45 мс
select * from "canonical_products" where "canonical_products"."id" in (224)
#5
⏱️ 7.57 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[224]
#6
⏱️ 80.11 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[3711116,1452088,1426115,810310,692746,281449,264842,242656,208252,208251,197740,195759,182693,182692,182438,182437,180263,169883,169754,168983,168982,167760,165076,164651,164650,161499,160007,160006,159467,159309,159262,150628,1453483,true,1118,1181,1221,1290,16,14,38,118,261,212,226,231,292,431,454,458,492,493,567,663,672,683,687,32,73,4,223]
#7
⏱️ 13.6 мс
select * from "stores" where "stores"."id" in (4, 14, 16, 32, 73, 118, 212, 223, 231)
#8
⏱️ 30.41 мс
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 = 3711116 THEN 3711116 WHEN sp.master_product_id = 1453483 THEN 3711116 ELSE sp.master_product_id END limit 500
Bindings:
[3711116,1452088,1426115,810310,692746,281449,264842,242656,208252,208251,197740,195759,182693,182692,182438,182437,180263,169883,169754,168983,168982,167760,165076,164651,164650,161499,160007,160006,159467,159309,159262,150628,1453483,0,1118,1181,1221,1290,16,14,38,118,261,212,226,231,292,431,454,458,492,493,567,663,672,683,687,32,73,4,223]
#9
⏱️ 53.14 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[1548570,1549351,6369238,1553432,6367345,1549570,1598455,6168873,1599881,1616718,6121743,6127207,1619267,1619268,1618049,1618050,1618509,1612957,1614133,5616875,5634114,5634125,5617039,5616860,461574,461960,4577238,464960,4574235,461948,463561,6464824,6464876,6465013,6465014,6465969,6469175,6469176,6469876,6475124,6475362,6475378,6466755,6466756,6466786,6465953,6470914,6465954,6459104,6235028,6235202,6235203,6233779,6062030,6062219,6062220,6059510,5877636,5877278,2038292,2035112,2036293,2035940,2032088,2032097,2302729,2314796,2305853,2307812,2313745,2313770,2311537,2363028,2362825,2364605,2364617,2558658,2558669,2554359,2558407,2563887,2563888,2563896,2563897,2563901,2563902,2560923,2563886,2558934,2563068,3623921,3625988,3626010,3626111,3626112,3627151,3627318,3628077,3626422]
#10
⏱️ 9.75 мс
select * from "stores" where "stores"."id" in (4, 14, 16, 32, 73, 118, 212, 223, 231, 431, 454, 458, 492, 493, 567)
#11
⏱️ 10.31 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["givatayim"]
#12
⏱️ 9.45 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 18.36 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]