#1
⏱️ 81.22 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"ramat-hasharon"]
#2
⏱️ 176.49 мс
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:
[646,142,true,646,142]
#3
⏱️ 236.35 мс
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 672
Bindings:
[646,142,true,646,142]
#4
⏱️ 4.58 мс
select * from "canonical_products" where "canonical_products"."id" in (160, 218)
#5
⏱️ 5.15 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?)
Bindings:
[218,160]
#6
⏱️ 53.39 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[112042,112010,111961,111934,111842,111800,111798,111780,111775,111743,111704,111620,111611,111593,111550,111434,111412,111403,111401,111386,111354,111340,111314,111313,111283,111265,111261,111259,111245,111220,111175,111111,111002,110983,110860,110857,110834,110833,110777,110774,110684,110634,110624,110545,110512,110474,110462,110346,110331,110274,110215,109967,109958,109944,109906,109799,109725,109628,109376,109085,108998,108997,108996,108986,108964,108963,108954,108953,108938,108926,108925,108919,108918,108913,108911,108902,108891,108887,108885,108882,108877,108875,108872,108870,108869,108868,108865,108859,108858,108845,108838,108836,108835,108834,108832,108821,4174466,149286,1453489,149408,true,646,142]
#7
⏱️ 3.88 мс
select * from "stores" where "stores"."id" in (142)
#8
⏱️ 12.44 мс
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 = 4174466 THEN 109906 WHEN sp.master_product_id = 149286 THEN 109906 WHEN sp.master_product_id = 1453489 THEN 109906 WHEN sp.master_product_id = 109906 THEN 109906 WHEN sp.master_product_id = 109967 THEN 109967 WHEN sp.master_product_id = 149408 THEN 109967 ELSE sp.master_product_id END limit 500
Bindings:
[112042,112010,111961,111934,111842,111800,111798,111780,111775,111743,111704,111620,111611,111593,111550,111434,111412,111403,111401,111386,111354,111340,111314,111313,111283,111265,111261,111259,111245,111220,111175,111111,111002,110983,110860,110857,110834,110833,110777,110774,110684,110634,110624,110545,110512,110474,110462,110346,110331,110274,110215,109967,109958,109944,109906,109799,109725,109628,109376,109085,108998,108997,108996,108986,108964,108963,108954,108953,108938,108926,108925,108919,108918,108913,108911,108902,108891,108887,108885,108882,108877,108875,108872,108870,108869,108868,108865,108859,108858,108845,108838,108836,108835,108834,108832,108821,4174466,149286,1453489,149408,0,646,142]
#9
⏱️ 16.24 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5542506,5542524,5542526,5542527,5542528,5542530,5542539,5542552,5542553,5542559,5542562,5542563,5542564,5542567,5542574,5542576,5542581,5542583,5542584,5542588,5542596,5542608,5542610,5542615,5542616,5542622,5542626,5542639,5542655,5542656,5542667,5542668,5542689,5542706,5542709,5542710,5541349,5524268,5520985,5528550,5533340,5517261,5512055,5519128,5512105,5526425,5519146,5506845,5526206,5521817,5542624,5528271,5528506,5519162,5524101,5528499,5530844,5520928,5542460,5542459,5541170,5530848,5530847,5506791,5531002,5526459,5526477,5518980,5519324,5542477,5526339,5526488,5519329,5526470,5528184,5514713,5542426,5526484,5526485,5528214,5519306,5528183,5526251,5526341,5542661,5524269,5526344,5504249,5533341,5528186,5528187,5524265,5533344,5525992,5524264,5512319]
#10
⏱️ 0.69 мс
select * from "stores" where "stores"."id" in (142)
#11
⏱️ 3.36 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["ramat-hasharon"]
#12
⏱️ 1.13 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 3.47 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]