#6
⏱️ 13.95 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?)
Bindings:
[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,4010322,4004803,4004675,4004358,3996719,3996635,3996093,3995178,3991426,3991036,3988418,3987313,3986807,3986018,3984049,3982444,3979153,2190109,133509,7569492,1952651,1453310,156666,2984317,1465364,162808,1453360,112864,160598,129463,205836,1458061,1909941,112818,1930007,127440,2045916,157118,157278,155793,4019922,true,585]
#7
⏱️ 26.38 мс
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 = 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 4004675 WHEN sp.master_product_id = 4105945 THEN 4004675 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 ELSE sp.master_product_id END limit 500
Bindings:
[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,4010322,4004803,4004675,4004358,3996719,3996635,3996093,3995178,3991426,3991036,3988418,3987313,3986807,3986018,3984049,3982444,3979153,2190109,133509,7569492,1952651,1453310,156666,2984317,1465364,162808,1453360,112864,160598,129463,205836,1458061,1909941,112818,1930007,127440,2045916,157118,157278,155793,4019922,0,585]
#8
⏱️ 27.32 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[3440109,3444928,3447080,3449802,3429963,3430573,3431570,3433624,3434054,3438426,3439564,3440385,3440521,3449958,3429651,3429834,3441168,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,3429828,3430399,3430400,3431087,3433046,3434559,3434592,3434754,3439760,3439889,3440120,3440387,3440611,3441169,3436505,3442745,3442746,3442875,3442877,3445471,3446356,3446607,3450034]