#1
⏱️ 125.81 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"raanana"]
#2
⏱️ 645.63 мс
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:
[1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692,true,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692]
#3
⏱️ 1222.94 мс
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:
[1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692,true,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692]
#4
⏱️ 13.46 мс
select * from "canonical_products" where "canonical_products"."id" in (4, 9, 75, 90, 97, 171, 199, 281, 308, 311, 320)
#5
⏱️ 10.48 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[281,75,320,311,308,9,171,97,199,90,4]
#6
⏱️ 31.19 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[7065236,6744655,6708345,4844233,4841277,4665520,4584074,4546420,4546240,4546223,4540232,4533815,4531886,4528630,4528085,4525248,4524189,4126286,4122848,4122596,4121710,4119111,4119109,4118979,4118978,4118966,4117404,4116844,4116623,4116356,4116124,4115995,4110988,4110824,4110791,4109280,4107318,4106627,4106626,4106058,4105945,4099827,4098748,4097824,4096518,4085256,4077839,4073345,4073343,4072452,4072451,4067751,4067541,4066766,4066305,4054428,4054218,4054217,4047955,4047733,4047728,4046926,4046320,4045906,4044707,4044670,4044669,4044230,4043734,4043256,4039527,4039525,4039495,4039359,4034737,4033597,4033300,4029930,4028971,4028965,4025480,4025282,4024832,4024818,4024812,4024346,4024028,4023994,4023987,4023736,4023598,4023300,4022757,4015675,4015098,4012164,2190109,133509,7569492,1952651,1453310,156666,2984317,1465364,162808,1453360,112864,160598,129463,205836,1458061,1909941,112818,1930007,127440,4004675,2045916,157118,157278,155793,4019922,195115,4983721,1453381,192680,true,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692]
#7
⏱️ 12.21 мс
select * from "stores" where "stores"."id" in (100, 140, 1108, 1133, 1198, 1205)
#8
⏱️ 54.77 мс
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 = 4034737 THEN 4034737 WHEN sp.master_product_id = 2190109 THEN 4034737 WHEN sp.master_product_id = 133509 THEN 4034737 WHEN sp.master_product_id = 7569492 THEN 4034737 WHEN sp.master_product_id = 1952651 THEN 4034737 WHEN sp.master_product_id = 1453310 THEN 4118966 WHEN sp.master_product_id = 156666 THEN 4118966 WHEN sp.master_product_id = 2984317 THEN 4118966 WHEN sp.master_product_id = 1465364 THEN 4118966 WHEN sp.master_product_id = 162808 THEN 4118966 WHEN sp.master_product_id = 4118966 THEN 4118966 WHEN sp.master_product_id = 1453360 THEN 4118966 WHEN sp.master_product_id = 112864 THEN 4118966 WHEN sp.master_product_id = 160598 THEN 4118966 WHEN sp.master_product_id = 4540232 THEN 4540232 WHEN sp.master_product_id = 4584074 THEN 4540232 WHEN sp.master_product_id = 129463 THEN 4039359 WHEN sp.master_product_id = 205836 THEN 4039359 WHEN sp.master_product_id = 1458061 THEN 4039359 WHEN sp.master_product_id = 4039359 THEN 4039359 WHEN sp.master_product_id = 1909941 THEN 4039359 WHEN sp.master_product_id = 112818 THEN 4039359 WHEN sp.master_product_id = 1930007 THEN 4039359 WHEN sp.master_product_id = 127440 THEN 4039359 WHEN sp.master_product_id = 4004675 THEN 4105945 WHEN sp.master_product_id = 4105945 THEN 4105945 WHEN sp.master_product_id = 2045916 THEN 4110824 WHEN sp.master_product_id = 4110824 THEN 4110824 WHEN sp.master_product_id = 157118 THEN 4110824 WHEN sp.master_product_id = 157278 THEN 4110824 WHEN sp.master_product_id = 155793 THEN 4110824 WHEN sp.master_product_id = 4085256 THEN 4085256 WHEN sp.master_product_id = 4019922 THEN 4085256 WHEN sp.master_product_id = 4665520 THEN 4665520 WHEN sp.master_product_id = 195115 THEN 4665520 WHEN sp.master_product_id = 4983721 THEN 4525248 WHEN sp.master_product_id = 4525248 THEN 4525248 WHEN sp.master_product_id = 4528630 THEN 4528630 WHEN sp.master_product_id = 1453381 THEN 4528630 WHEN sp.master_product_id = 4546240 THEN 4546240 WHEN sp.master_product_id = 192680 THEN 4546240 ELSE sp.master_product_id END limit 500
Bindings:
[7065236,6744655,6708345,4844233,4841277,4665520,4584074,4546420,4546240,4546223,4540232,4533815,4531886,4528630,4528085,4525248,4524189,4126286,4122848,4122596,4121710,4119111,4119109,4118979,4118978,4118966,4117404,4116844,4116623,4116356,4116124,4115995,4110988,4110824,4110791,4109280,4107318,4106627,4106626,4106058,4105945,4099827,4098748,4097824,4096518,4085256,4077839,4073345,4073343,4072452,4072451,4067751,4067541,4066766,4066305,4054428,4054218,4054217,4047955,4047733,4047728,4046926,4046320,4045906,4044707,4044670,4044669,4044230,4043734,4043256,4039527,4039525,4039495,4039359,4034737,4033597,4033300,4029930,4028971,4028965,4025480,4025282,4024832,4024818,4024812,4024346,4024028,4023994,4023987,4023736,4023598,4023300,4022757,4015675,4015098,4012164,2190109,133509,7569492,1952651,1453310,156666,2984317,1465364,162808,1453360,112864,160598,129463,205836,1458061,1909941,112818,1930007,127440,4004675,2045916,157118,157278,155793,4019922,195115,4983721,1453381,192680,0,1108,762,346,1133,1198,1205,585,637,230,56,100,140,159,316,364,460,511,656,659,692]
#9
⏱️ 14.2 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4361134,5630392,5600423,921133,915598,2389113,2389251,2388463,2380134,2380915,3444641,3429275,3429940,3437769,3438462,3438846,3439016,3439295,3439303,3439361,3439755,3440377,3440384,3440399,3440939,3441166,3445463,3445469,3446590,3429796,3430054,3431133,3434732,3434855,3434885,3434887,3438388,3438838,3439301,3439702,3439704,3439753,3440941,3441326,3441904,3442659,3442664,3442878,3448588,3448589,3448809,3438571,3439012,3439762,3440022,3444624,3444625,3445476,3445477,3449921,3448639,3440401,3441885,3442884,3444106,3429651,3429828,3430399,3430400,3431087,3433046,3434559,3434592,3434754,3439760,3439889,3440120,3440387,3440611,3441169,3436505,3442745,3442746,3442875,3442877,3445471,3446356,3446607,3450034,2970080,2967038,2967825,2969810,2970251,2970163,2974599,2974610,2974646,2967204,2967842,2970807]
#10
⏱️ 4.24 мс
select * from "stores" where "stores"."id" in (100, 140, 230, 460, 585, 637)
#11
⏱️ 23.06 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["raanana"]
#12
⏱️ 6.23 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 13.88 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]