#1
⏱️ 29.07 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"tel-aviv"]
#2
⏱️ 1140.96 мс
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","canned_preserves",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
⏱️ 795.37 мс
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","canned_preserves",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
⏱️ 3.85 мс
select * from "canonical_products" where "canonical_products"."id" in (109, 117)
#5
⏱️ 2.44 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?)
Bindings:
[109,117]
#6
⏱️ 113.27 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[8775716,7520039,7504693,7499337,7455589,7455588,7065236,6745776,6730411,4989781,4989766,4987587,4987518,4987434,4987359,4987332,4987208,4987001,4986833,4986722,4986611,4986361,4985848,4984139,4983944,4592992,4546323,4541335,4540285,4536333,4535016,4528693,4679481,100076,9960259,4016585,149368,2663583,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
⏱️ 1.59 мс
select * from "stores" where "stores"."id" in (19, 27, 31, 97, 117, 138, 294, 297, 307, 310, 311, 313, 322, 327, 328, 336, 337, 341, 357, 359, 361, 362, 370, 527, 729)
#8
⏱️ 123 мс
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 = 4541335 THEN 4541335 WHEN sp.master_product_id = 4592992 THEN 4541335 WHEN sp.master_product_id = 4679481 THEN 4541335 WHEN sp.master_product_id = 100076 THEN 4541335 WHEN sp.master_product_id = 9960259 THEN 4546323 WHEN sp.master_product_id = 4016585 THEN 4546323 WHEN sp.master_product_id = 149368 THEN 4546323 WHEN sp.master_product_id = 4546323 THEN 4546323 WHEN sp.master_product_id = 2663583 THEN 4546323 ELSE sp.master_product_id END limit 500
Bindings:
[8775716,7520039,7504693,7499337,7455589,7455588,7065236,6745776,6730411,4989781,4989766,4987587,4987518,4987434,4987359,4987332,4987208,4987001,4986833,4986722,4986611,4986361,4985848,4984139,4983944,4592992,4546323,4541335,4540285,4536333,4535016,4528693,4679481,100076,9960259,4016585,149368,2663583,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
⏱️ 83.21 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[67325017,791685,5814952,67324983,5664015,68678129,4491708,68275961,6489595,67795627,5703945,567911,601679,642401,78882970,674481,680229,5080477,78882936,5053482,5002925,711572,78882924,4694648,4666288,1083442,78882916,1091620,193891,1149562,4283469,1157102,1165913,1205287,29269415,10390903,10391445,10391042,10613774,10605058,10606880,29435651,29533579,10814689,29542046,10814814,2202171,13323306,10909331,10909088,2262569,11077009,11081536,11078316,2344924,11331051,11333802,18086073,11711372,11716342,18433857,11719060,47693522,47696756,56586985,2553431,30333539,30333544,30333542,47745775,60622236,2568777,2574214,47765775,47764249,45211704,47766875,30335349,12301265,19090388,31898905,19096152,19096153,19152886,47965823,19157565,78768993,47964154,19168623,47993656,19172885,47989734,47989735,47999874,31961798,62863076,12356809,12356810,9603713,9593133,78223588,59865953,59906858,59931632,59972351,60023411,60135499,60224041,60345186,60466853,3722979,24602525,3200131,3193530,3193725,3195434,3195947,3196197,3196308,3196419,3196587,3196794,3196918,3196945,3197020,3197104,3197173,3199352,3199367,3245182,11498579,11513068,11514712,11529428,3238581,3238776,3240485,3240998,3241248,3241359,3241470,3241638,3241845,3241969,3241996,3242071,3242155,3242224,3244403,3244418,9603695,9593115,1689255,6738811,26388593,10200170,468922,474425,3139932,7739736,3133331,3133526,3135235,3135748,3135998,3136109,3136220,3136388,3136595,3136719,3136746,3136821,3136905,3136974,3139153,3139168]
#10
⏱️ 12.43 мс
select * from "stores" where "stores"."id" in (19, 27, 31, 97, 117, 138, 207, 245, 260, 294, 297, 307, 310, 311, 313, 322, 327, 328, 336, 337, 341, 357, 359, 361, 362, 370, 425, 433, 440, 444, 449, 456, 466, 491, 495, 496, 507, 512, 513, 514, 527, 551, 561, 562, 563, 564, 565, 568, 571, 574, 577, 582, 587, 610, 627, 729, 747, 757, 758, 772)
#11
⏱️ 3 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["tel-aviv"]
#12
⏱️ 3.46 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 9.09 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]