#1
⏱️ 168.74 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"tel-aviv"]
#2
⏱️ 1381.49 мс
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:
["dairy","cheese",729,747,757,758,772,774,189,117,370,260,207,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,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,207,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,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#3
⏱️ 1074.94 мс
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:
["dairy","cheese",729,747,757,758,772,774,189,117,370,260,207,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,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,207,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,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#4
⏱️ 6.47 мс
select * from "canonical_products" where "canonical_products"."id" in (155, 199)
#5
⏱️ 9.34 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?)
Bindings:
[155,199]
#6
⏱️ 69.58 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[62358111,55322118,36601256,11135534,8314244,8314242,4990037,4988786,4987083,4986561,4985439,4985410,4286085,4279811,4213380,4157788,4125470,4105860,4085256,4033418,4032127,4019922,4008548,4003338,3987697,3985099,3974567,2802677,2679096,2668917,2668915,2633414,true,729,747,757,758,772,774,189,117,370,260,207,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,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#7
⏱️ 5.17 мс
select * from "stores" where "stores"."id" in (19, 117, 138, 310, 322, 336, 337, 341, 361, 362)
#8
⏱️ 164.48 мс
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 = 4286085 THEN 4157788 WHEN sp.master_product_id = 4157788 THEN 4157788 WHEN sp.master_product_id = 4085256 THEN 4019922 WHEN sp.master_product_id = 4019922 THEN 4019922 ELSE sp.master_product_id END limit 500
Bindings:
[62358111,55322118,36601256,11135534,8314244,8314242,4990037,4988786,4987083,4986561,4985439,4985410,4286085,4279811,4213380,4157788,4125470,4105860,4085256,4033418,4032127,4019922,4008548,4003338,3987697,3985099,3974567,2802677,2679096,2668917,2668915,2633414,0,729,747,757,758,772,774,189,117,370,260,207,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,210,251,244,245,266,277,294,297,307,310,311,313,322,327,328,336,337,357,359,361,362]
#9
⏱️ 97.21 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[26354347,35396946,35133806,36360868,36360833,36360832,36360942,36360812,1876428,29260308,1883329,10398168,10388791,2070715,2070717,2066375,10822018,88932025,88932027,2162414,10802240,31224626,2207605,31231606,11082798,2265826,2265829,2264654,11104543,2343005,11363160,11363163,2334296,2454409,31489418,2460661,2460558,109086164,90478716,47685741,90605305,90632868,90965563,90977404,90987644,78227555,3525692,24739777,98192619,24739880,3534052,98196782,24729988,24729989,78248352,111779943,59875876,59868493,3594416,59877131,110837367,59877133,59901356,111796054,59911067,59929053,59915692,24823140,98343861,24823032,59912082,59912081,59912084,59939654,59940012,59968028,59968199,3604476,24833847,111806833,78456160,78456052,3603392,59941511,59941514,98364290,59982417,59982443,60017722,59975050,24839714,59972730,3609656,113385040,3609631,59984402,59984405,60032768,60032788,98392319,60034743,60034742,60034745,111019837,98406389,24850007,60088105,98406803,98393485,98406802,24848924,98396556,98405746,111094698,60142875,111127101,97096188,60176791,60178172,60134825,60178171,43131356,60145258,60145257,60145260,58126920,98482737,98482827,98455601,37837584,28143303,58150523,97196158,111171846,60211695,60204696,97197497,97197496,98487867,60228275,60228307,60250999,97236983,60229962,60251143,97246488,60229627,60249671,97296748,60263376,60297266,11602945,78564779,60265959,60265958,52726300,3672699,60386596,98542203,60388015,60345074,60388014,60355382,60384944,24917180,78630680,60427391,3684304,86726746,60435315,60435314,24911874,60510920,98574014,3694710,60466735,98571427,98571426,78644644,78656369,24947176,3719558,60570978,60570871,11796716,3719549,24948733,78721026,60608194,24947679,98626657,68895867,24610502,24640556,26819219,24641196,3460444,78083254,24612358,24612360,111618096,3197215,2869040,3194996,3195025,3196147,3196669,3198372,3199623,28595536,3242266,11501285,3240047,3240076,3241198,3241720,3243423,3244674,1690476,1690364,1690368,1692955,3137016,7731170,2779879,3134797,3134826,3135948,3136470,3138173,3139424]
#10
⏱️ 11.6 мс
select * from "stores" where "stores"."id" in (19, 117, 138, 322, 336, 337, 341, 362, 425, 433, 440, 444, 449, 456, 466, 491, 495, 496, 512, 513, 514, 551, 561, 562, 563, 564, 565, 566, 568, 569, 570, 571, 572, 574, 576, 577, 581, 582, 587, 610, 627, 747, 772)
#11
⏱️ 6.47 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["tel-aviv"]
#12
⏱️ 8.58 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 7.23 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]