#1
⏱️ 40.54 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"tel-aviv"]
#2
⏱️ 1304.48 мс
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","baking_spices",729,747,757,758,772,774,189,117,370,260,1129,1131,1132,1139,1147,1151,1155,1177,1209,1217,1236,1240,1243,1245,1251,587,1277,1285,1289,610,1296,627,1303,1316,1320,1330,1342,42,43,48,51,55,63,65,68,70,291,341,425,433,440,444,449,456,466,491,495,496,507,512,513,514,515,516,527,1353,1355,1359,551,561,562,563,564,565,566,568,569,570,571,572,574,576,577,581,582,649,674,680,1377,1382,1405,1412,19,27,31,97,138,176,178,185,192,193,201,204,207,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362,true,729,747,757,758,772,774,189,117,370,260,1129,1131,1132,1139,1147,1151,1155,1177,1209,1217,1236,1240,1243,1245,1251,587,1277,1285,1289,610,1296,627,1303,1316,1320,1330,1342,42,43,48,51,55,63,65,68,70,291,341,425,433,440,444,449,456,466,491,495,496,507,512,513,514,515,516,527,1353,1355,1359,551,561,562,563,564,565,566,568,569,570,571,572,574,576,577,581,582,649,674,680,1377,1382,1405,1412,19,27,31,97,138,176,178,185,192,193,201,204,207,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#3
⏱️ 626.82 мс
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","baking_spices",729,747,757,758,772,774,189,117,370,260,1129,1131,1132,1139,1147,1151,1155,1177,1209,1217,1236,1240,1243,1245,1251,587,1277,1285,1289,610,1296,627,1303,1316,1320,1330,1342,42,43,48,51,55,63,65,68,70,291,341,425,433,440,444,449,456,466,491,495,496,507,512,513,514,515,516,527,1353,1355,1359,551,561,562,563,564,565,566,568,569,570,571,572,574,576,577,581,582,649,674,680,1377,1382,1405,1412,19,27,31,97,138,176,178,185,192,193,201,204,207,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362,true,729,747,757,758,772,774,189,117,370,260,1129,1131,1132,1139,1147,1151,1155,1177,1209,1217,1236,1240,1243,1245,1251,587,1277,1285,1289,610,1296,627,1303,1316,1320,1330,1342,42,43,48,51,55,63,65,68,70,291,341,425,433,440,444,449,456,466,491,495,496,507,512,513,514,515,516,527,1353,1355,1359,551,561,562,563,564,565,566,568,569,570,571,572,574,576,577,581,582,649,674,680,1377,1382,1405,1412,19,27,31,97,138,176,178,185,192,193,201,204,207,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#4
⏱️ 1.5 мс
select * from "canonical_products" where "canonical_products"."id" in (57, 283, 286)
#5
⏱️ 0.78 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?)
Bindings:
[283,286,57]
#6
⏱️ 604.47 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[81243843,27815085,12196449,12196440,6809522,4990576,4990374,4988227,4987429,4670178,4652621,4546334,4546313,4546301,4546279,4546274,4546265,4546263,4546262,4399619,4322833,4252886,4174891,4148882,4127300,4107700,4087764,4085826,4060426,4053353,4034589,4032627,2261290,162805,4041677,4415637,154967,162154,3253825,2680729,149430,true,729,747,757,758,772,774,189,117,370,260,1129,1131,1132,1139,1147,1151,1155,1177,1209,1217,1236,1240,1243,1245,1251,587,1277,1285,1289,610,1296,627,1303,1316,1320,1330,1342,42,43,48,51,55,63,65,68,70,291,341,425,433,440,444,449,456,466,491,495,496,507,512,513,514,515,516,527,1353,1355,1359,551,561,562,563,564,565,566,568,569,570,571,572,574,576,577,581,582,649,674,680,1377,1382,1405,1412,19,27,31,97,138,176,178,185,192,193,201,204,207,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#7
⏱️ 4.28 мс
select * from "stores" where "stores"."id" in (310)
#8
⏱️ 41.95 мс
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 = 4148882 THEN 4148882 WHEN sp.master_product_id = 2261290 THEN 4148882 WHEN sp.master_product_id = 162805 THEN 4148882 WHEN sp.master_product_id = 4041677 THEN 4148882 WHEN sp.master_product_id = 4415637 THEN 4148882 WHEN sp.master_product_id = 154967 THEN 4148882 WHEN sp.master_product_id = 162154 THEN 4148882 WHEN sp.master_product_id = 3253825 THEN 4148882 WHEN sp.master_product_id = 4546313 THEN 4546313 WHEN sp.master_product_id = 2680729 THEN 4546313 WHEN sp.master_product_id = 4546301 THEN 4546301 WHEN sp.master_product_id = 149430 THEN 4546301 ELSE sp.master_product_id END limit 500
Bindings:
[81243843,27815085,12196449,12196440,6809522,4990576,4990374,4988227,4987429,4670178,4652621,4546334,4546313,4546301,4546279,4546274,4546265,4546263,4546262,4399619,4322833,4252886,4174891,4148882,4127300,4107700,4087764,4085826,4060426,4053353,4034589,4032627,2261290,162805,4041677,4415637,154967,162154,3253825,2680729,149430,0,729,747,757,758,772,774,189,117,370,260,1129,1131,1132,1139,1147,1151,1155,1177,1209,1217,1236,1240,1243,1245,1251,587,1277,1285,1289,610,1296,627,1303,1316,1320,1330,1342,42,43,48,51,55,63,65,68,70,291,341,425,433,440,444,449,456,466,491,495,496,507,512,513,514,515,516,527,1353,1355,1359,551,561,562,563,564,565,566,568,569,570,571,572,574,576,577,581,582,649,674,680,1377,1382,1405,1412,19,27,31,97,138,176,178,185,192,193,201,204,207,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#9
⏱️ 42.13 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5083310,29270768,67542224,33216941,10627328,29541313,2206933,29684082,2254044,2341858,11720529,78251456,3530298,3592440,24821841,59866505,59902678,3598945,78453372,59970071,59938692,3605796,59932411,59967066,59967072,59975064,60015954,3608984,3608981,3611958,59972508,60016639,60016647,60070146,60025665,60065473,60031683,11467369,3617402,60023465,60065658,60065665,3621687,62718339,76514545,60141741,24860588,60139198,78520597,3632388,3634405,60141722,60171831,78533061,60182044,3637789,37853137,22780295,3649852,3646328,78550431,78550433,60254262,3655628,24880090,3661607,78574539,24890625,3674983,78602030,60385200,60385204,60430734,3686521,60473685,3692450,60509521,60509525,3721070,3735246,47943764,3730603,3724814,3722988,47978479,52962227,24604716,24609443,24602150,3465205,24639507,24639514,12156976,7902337,3197015,3197813,3199960,3200162,11528868,11528869,11528871,35907970,11528883,11528906,11528918,11529439,3242066,3242864,3245011,3245213,1695751,2778740,3136816,3137614,3139761,3139963]
#10
⏱️ 2.91 мс
select * from "stores" where "stores"."id" in (310, 425, 433, 440, 444, 449, 456, 466, 551, 561, 562, 563, 564, 565, 566, 568, 569, 570, 571, 572, 574, 576, 577, 581, 582, 587, 610, 627, 747, 772)
#11
⏱️ 3.77 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["tel-aviv"]
#12
⏱️ 3.09 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 3.3 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]