#6
⏱️ 13.95 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?)
Bindings:
[2049531,2045870,2045396,1880161,1879667,1879660,1879659,1879265,1879254,1455075,1453427,1452559,1434014,1425655,1425497,825495,813918,813764,810310,785014,785013,784427,784004,784002,750013,711551,694022,692746,692616,689451,689448,684972,639411,613133,545496,531939,498599,496502,427384,427358,403505,398488,379777,367139,364789,364088,327734,327732,320326,319317,316648,311485,310778,310777,308829,287759,284999,283557,281449,278471,264842,259276,253681,251429,251397,251286,250602,248419,245837,245810,245790,244697,244558,244557,244556,244555,244553,244531,244530,244514,244509,244506,244505,243003,242979,242978,242974,242656,240354,239807,206567,199992,195759,195477,189889,188666,2562307,385456,1461015,1998513,832521,1017455,101337,887052,291891,259648,695500,878126,101057,101041,101338,101350,95054,109243,190899,134681,150736,1463382,199293,150781,150751,1452766,133528,2637097,96262,true,155,342]
#8
⏱️ 26.2 мс
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 = 2562307 THEN 245790 WHEN sp.master_product_id = 385456 THEN 245790 WHEN sp.master_product_id = 1461015 THEN 245790 WHEN sp.master_product_id = 1998513 THEN 245790 WHEN sp.master_product_id = 245790 THEN 245790 WHEN sp.master_product_id = 832521 THEN 245790 WHEN sp.master_product_id = 1017455 THEN 245790 WHEN sp.master_product_id = 101337 THEN 245790 WHEN sp.master_product_id = 887052 THEN 245790 WHEN sp.master_product_id = 291891 THEN 245790 WHEN sp.master_product_id = 259648 THEN 245790 WHEN sp.master_product_id = 695500 THEN 245790 WHEN sp.master_product_id = 878126 THEN 245790 WHEN sp.master_product_id = 101057 THEN 245790 WHEN sp.master_product_id = 101041 THEN 245790 WHEN sp.master_product_id = 101338 THEN 245790 WHEN sp.master_product_id = 101350 THEN 245790 WHEN sp.master_product_id = 95054 THEN 245790 WHEN sp.master_product_id = 109243 THEN 496502 WHEN sp.master_product_id = 496502 THEN 496502 WHEN sp.master_product_id = 190899 THEN 496502 WHEN sp.master_product_id = 134681 THEN 496502 WHEN sp.master_product_id = 150736 THEN 496502 WHEN sp.master_product_id = 1879265 THEN 1879265 WHEN sp.master_product_id = 1463382 THEN 1879265 WHEN sp.master_product_id = 199293 THEN 1879265 WHEN sp.master_product_id = 150781 THEN 1879265 WHEN sp.master_product_id = 150751 THEN 1879659 WHEN sp.master_product_id = 1452766 THEN 1879659 WHEN sp.master_product_id = 133528 THEN 1879659 WHEN sp.master_product_id = 1879659 THEN 1879659 WHEN sp.master_product_id = 2637097 THEN 1879659 WHEN sp.master_product_id = 96262 THEN 1453427 WHEN sp.master_product_id = 1453427 THEN 1453427 ELSE sp.master_product_id END limit 500
Bindings:
[2049531,2045870,2045396,1880161,1879667,1879660,1879659,1879265,1879254,1455075,1453427,1452559,1434014,1425655,1425497,825495,813918,813764,810310,785014,785013,784427,784004,784002,750013,711551,694022,692746,692616,689451,689448,684972,639411,613133,545496,531939,498599,496502,427384,427358,403505,398488,379777,367139,364789,364088,327734,327732,320326,319317,316648,311485,310778,310777,308829,287759,284999,283557,281449,278471,264842,259276,253681,251429,251397,251286,250602,248419,245837,245810,245790,244697,244558,244557,244556,244555,244553,244531,244530,244514,244509,244506,244505,243003,242979,242978,242974,242656,240354,239807,206567,199992,195759,195477,189889,188666,2562307,385456,1461015,1998513,832521,1017455,101337,887052,291891,259648,695500,878126,101057,101041,101338,101350,95054,109243,190899,134681,150736,1463382,199293,150781,150751,1452766,133528,2637097,96262,0,155,342]
#9
⏱️ 14.61 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5421046,5432625,5432704,5444691,5432603,5421483,5432584,5434850,5434856,5434858,5434886,5439845,5439846,5439848,5439850,5439862,5439863,5439881,5439882,5439883,5439884,5439885,5439998,5421023,6549638,5430031,5437683,5439757,5439838,5439858,5443873,5439717,5421324,5432585,5439886,5444748,5430226,5437924,6549669,6549671,5444693,5432749,5439627,5430227,5432569,5439935,5444745,5437565,5444727,6549670,5427337,5435057,5442237,5439875,5427307,5432775,5421409,5421410,5432685,5432779,5439508,8495132,5432561,5432563,5432780,5435191,5435192,5421415,5432686,5432784,5430112,5430171,6549655,5421451,5424978,8493623,5421471,5421482,5427309,5427310,5427317,5430036,5424992]