#1
⏱️ 132.03 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"tiberias"]
#2
⏱️ 1802.22 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null and "master_products"."id" in ((select "master_product_id" from "store_prices" where "store_id" in (?, ?)) union (select "master_product_id" from "deals" where "is_active" = ? and "store_id" in (?, ?)))
Bindings:
[756,633,true,756,633]
#3
⏱️ 959.82 мс
select * from "master_products" where "barcode" is not null and "master_products"."id" in ((select "master_product_id" from "store_prices" where "store_id" in (?, ?)) union (select "master_product_id" from "deals" where "is_active" = ? and "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 96 offset 0
Bindings:
[756,633,true,756,633]
#4
⏱️ 4.72 мс
select * from "canonical_products" where "canonical_products"."id" in (193)
#5
⏱️ 8.19 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?)
Bindings:
[193]
#6
⏱️ 11.73 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[129895076,129892744,108808721,108787969,75165094,74076446,72978997,66413048,56283367,54705033,39028558,7529293,7493489,7430884,7065236,6778985,6745776,6744655,6730411,6708345,5305199,4991109,4991108,4991102,4991097,4991094,4991092,4991049,4991048,4991043,4991028,4991027,4990963,4990962,4990961,4990945,4990895,4990894,4990873,4990872,4990849,4990833,4990832,4990828,4990825,4990823,4990804,4990789,4990772,4990767,4990765,4990750,4990715,4990619,4990596,4990576,4990547,4990523,4990456,4990374,4990373,4990354,4990353,4990275,4990129,4990037,4989971,4989961,4989871,4989781,4989777,4989772,4989767,4989766,4989764,4989750,4989747,4989744,4989543,4988931,4988918,4988886,4988885,4988884,4988852,4988820,4988808,4988786,4988774,4988768,4988706,4988698,4988697,4988696,4988681,4988675,112362,true,756,633]
#7
⏱️ 24.22 мс
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 = 112362 THEN 7529293 WHEN sp.master_product_id = 7529293 THEN 7529293 ELSE sp.master_product_id END limit 500
Bindings:
[129895076,129892744,108808721,108787969,75165094,74076446,72978997,66413048,56283367,54705033,39028558,7529293,7493489,7430884,7065236,6778985,6745776,6744655,6730411,6708345,5305199,4991109,4991108,4991102,4991097,4991094,4991092,4991049,4991048,4991043,4991028,4991027,4990963,4990962,4990961,4990945,4990895,4990894,4990873,4990872,4990849,4990833,4990832,4990828,4990825,4990823,4990804,4990789,4990772,4990767,4990765,4990750,4990715,4990619,4990596,4990576,4990547,4990523,4990456,4990374,4990373,4990354,4990353,4990275,4990129,4990037,4989971,4989961,4989871,4989781,4989777,4989772,4989767,4989766,4989764,4989750,4989747,4989744,4989543,4988931,4988918,4988886,4988885,4988884,4988852,4988820,4988808,4988786,4988774,4988768,4988706,4988698,4988697,4988696,4988681,4988675,112362,0,756,633]
#8
⏱️ 27.59 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[12283301,12283307,12283322,12283323,12283324,12283332,12283394,12283400,12283412,12283434,12283446,12283478,12283510,12283511,12283512,12283544,12283557,12285169,12285870,12285873,12285876,12285890,12285892,12285893,12285898,12285903,12285907,12285997,12286087,12286097,12286163,12286755,12286901,12286979,12286980,12286999,12287000,12287082,12287149,12287173,12287703,12287723,12287746,12287842,12287877,12287892,12287894,12287899,12287916,12287931,12287950,12287952,12287955,12287959,12287960,12287976,12287999,12288000,12288021,12288022,12288072,12288088,12288089,12288090,12288154,12288155,12288170,12288175,12288176,12273641,12273643,12273646,12273651,12273657,12273658,11587881,74374936,28255562,72837451,80959306,97259540,97262705,10317932,10319746,10318574,10318895,10319368,55820817,10318960,103484101,38673614,67475443,67466273,53854453,55819549,53854451,67477907,71231553,71231555]
#9
⏱️ 8.65 мс
select * from "stores" where "stores"."id" in (633, 756)
#10
⏱️ 4.87 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["tiberias"]
#11
⏱️ 4.94 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#12
⏱️ 10.43 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]