#6
⏱️ 55.25 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?)
Bindings:
[8775869,8775868,8775867,8775866,8775865,8775864,8775863,8775862,8775861,8775860,8775859,8775858,8775857,8775856,8775855,8775854,8775853,8775852,8775851,8775850,8775849,8775848,8775847,8775846,8775845,8775844,8775843,8775842,8775841,8775840,8775839,8775838,8775837,8775836,8775835,8775834,8775833,8775832,8775831,8775830,8775829,8775828,8775827,8775826,8775825,8775816,8775815,8775810,8775804,8775803,8775802,8775801,8775782,8775781,8775755,8775713,8775712,8775711,8775710,8775709,8775708,8775707,8775651,8775580,8775546,8775533,8775532,8775528,8775519,8775509,7443254,5130723,5130389,5127697,4988681,4987518,4619338,4533815,4012164,3915123,3549846,3340041,3119102,3015043,2950238,2931321,2797107,2647878,2642425,2642320,2641760,2639215,2616260,2615066,2609947,2609674,2645047,7696015,199939,4869230,4533490,189745,2671007,190787,809367,420472,95010,764101,337070,1945358,124804,2769595,101043,2901961,3675179,368474,374223,122806,95379,2742300,2629564,3261507,1907886,101044,322317,127029,154873,123105,122841,102185,102244,130085,94867,94974,97463,98565,101042,101339,7471561,2608090,112925,110719,115658,111499,114703,115686,4859763,4725190,191031,195116,113731,1907930,150734,133480,true,744,26,183,475,669,107]
#8
⏱️ 25.92 мс
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 = 8775857 THEN 2642425 WHEN sp.master_product_id = 8775862 THEN 2642425 WHEN sp.master_product_id = 8775826 THEN 2642425 WHEN sp.master_product_id = 8775829 THEN 2642425 WHEN sp.master_product_id = 8775830 THEN 2642425 WHEN sp.master_product_id = 8775837 THEN 2642425 WHEN sp.master_product_id = 8775838 THEN 2642425 WHEN sp.master_product_id = 8775841 THEN 2642425 WHEN sp.master_product_id = 8775842 THEN 2642425 WHEN sp.master_product_id = 8775845 THEN 2642425 WHEN sp.master_product_id = 8775843 THEN 2642425 WHEN sp.master_product_id = 8775844 THEN 2642425 WHEN sp.master_product_id = 8775847 THEN 2642425 WHEN sp.master_product_id = 8775846 THEN 2642425 WHEN sp.master_product_id = 8775848 THEN 2642425 WHEN sp.master_product_id = 8775850 THEN 2642425 WHEN sp.master_product_id = 8775851 THEN 2642425 WHEN sp.master_product_id = 8775859 THEN 2642425 WHEN sp.master_product_id = 8775861 THEN 2642425 WHEN sp.master_product_id = 8775867 THEN 2642425 WHEN sp.master_product_id = 8775868 THEN 2642425 WHEN sp.master_product_id = 2645047 THEN 2642425 WHEN sp.master_product_id = 7696015 THEN 2642425 WHEN sp.master_product_id = 8775839 THEN 2642425 WHEN sp.master_product_id = 8775856 THEN 2642425 WHEN sp.master_product_id = 8775858 THEN 2642425 WHEN sp.master_product_id = 8775860 THEN 2642425 WHEN sp.master_product_id = 8775863 THEN 2642425 WHEN sp.master_product_id = 8775864 THEN 2642425 WHEN sp.master_product_id = 199939 THEN 2642425 WHEN sp.master_product_id = 4869230 THEN 2642425 WHEN sp.master_product_id = 4619338 THEN 2642425 WHEN sp.master_product_id = 8775832 THEN 2642425 WHEN sp.master_product_id = 8775833 THEN 2642425 WHEN sp.master_product_id = 8775836 THEN 2642425 WHEN sp.master_product_id = 8775865 THEN 2642425 WHEN sp.master_product_id = 8775825 THEN 2642425 WHEN sp.master_product_id = 8775828 THEN 2642425 WHEN sp.master_product_id = 4533490 THEN 2642425 WHEN sp.master_product_id = 189745 THEN 2642425 WHEN sp.master_product_id = 8775840 THEN 2642425 WHEN sp.master_product_id = 8775849 THEN 2642425 WHEN sp.master_product_id = 8775853 THEN 2642425 WHEN sp.master_product_id = 8775855 THEN 2642425 WHEN sp.master_product_id = 8775866 THEN 2642425 WHEN sp.master_product_id = 2642425 THEN 2642425 WHEN sp.master_product_id = 2671007 THEN 2642425 WHEN sp.master_product_id = 8775827 THEN 2642425 WHEN sp.master_product_id = 8775831 THEN 2642425 WHEN sp.master_product_id = 8775834 THEN 2642425 WHEN sp.master_product_id = 8775835 THEN 2642425 WHEN sp.master_product_id = 8775852 THEN 2642425 WHEN sp.master_product_id = 8775854 THEN 2642425 WHEN sp.master_product_id = 8775869 THEN 2642425 WHEN sp.master_product_id = 190787 THEN 2642425 WHEN sp.master_product_id = 809367 THEN 2639215 WHEN sp.master_product_id = 420472 THEN 2639215 WHEN sp.master_product_id = 3015043 THEN 2639215 WHEN sp.master_product_id = 95010 THEN 2639215 WHEN sp.master_product_id = 764101 THEN 2639215 WHEN sp.master_product_id = 3549846 THEN 2639215 WHEN sp.master_product_id = 337070 THEN 2639215 WHEN sp.master_product_id = 1945358 THEN 2639215 WHEN sp.master_product_id = 124804 THEN 2639215 WHEN sp.master_product_id = 2769595 THEN 2639215 WHEN sp.master_product_id = 101043 THEN 2639215 WHEN sp.master_product_id = 2901961 THEN 2639215 WHEN sp.master_product_id = 3675179 THEN 2639215 WHEN sp.master_product_id = 368474 THEN 2639215 WHEN sp.master_product_id = 374223 THEN 2639215 WHEN sp.master_product_id = 2950238 THEN 2639215 WHEN sp.master_product_id = 122806 THEN 2639215 WHEN sp.master_product_id = 95379 THEN 2639215 WHEN sp.master_product_id = 2742300 THEN 2639215 WHEN sp.master_product_id = 2629564 THEN 2639215 WHEN sp.master_product_id = 3261507 THEN 2639215 WHEN sp.master_product_id = 1907886 THEN 2639215 WHEN sp.master_product_id = 2639215 THEN 2639215 WHEN sp.master_product_id = 101044 THEN 2639215 WHEN sp.master_product_id = 322317 THEN 2639215 WHEN sp.master_product_id = 127029 THEN 2639215 WHEN sp.master_product_id = 154873 THEN 2639215 WHEN sp.master_product_id = 123105 THEN 2639215 WHEN sp.master_product_id = 122841 THEN 2639215 WHEN sp.master_product_id = 102185 THEN 2639215 WHEN sp.master_product_id = 102244 THEN 2639215 WHEN sp.master_product_id = 130085 THEN 2639215 WHEN sp.master_product_id = 94867 THEN 2639215 WHEN sp.master_product_id = 94974 THEN 2639215 WHEN sp.master_product_id = 97463 THEN 2639215 WHEN sp.master_product_id = 98565 THEN 2639215 WHEN sp.master_product_id = 101042 THEN 2639215 WHEN sp.master_product_id = 101339 THEN 2639215 WHEN sp.master_product_id = 8775528 THEN 8775528 WHEN sp.master_product_id = 7471561 THEN 8775528 WHEN sp.master_product_id = 2608090 THEN 2609674 WHEN sp.master_product_id = 2609674 THEN 2609674 WHEN sp.master_product_id = 112925 THEN 2609674 WHEN sp.master_product_id = 110719 THEN 2609674 WHEN sp.master_product_id = 8775708 THEN 2609947 WHEN sp.master_product_id = 8775709 THEN 2609947 WHEN sp.master_product_id = 8775712 THEN 2609947 WHEN sp.master_product_id = 8775707 THEN 2609947 WHEN sp.master_product_id = 8775710 THEN 2609947 WHEN sp.master_product_id = 8775711 THEN 2609947 WHEN sp.master_product_id = 2609947 THEN 2609947 WHEN sp.master_product_id = 115658 THEN 2609947 WHEN sp.master_product_id = 8775713 THEN 2609947 WHEN sp.master_product_id = 111499 THEN 2609947 WHEN sp.master_product_id = 114703 THEN 2609947 WHEN sp.master_product_id = 115686 THEN 2609947 WHEN sp.master_product_id = 8775781 THEN 8775781 WHEN sp.master_product_id = 8775782 THEN 8775781 WHEN sp.master_product_id = 4859763 THEN 3119102 WHEN sp.master_product_id = 4725190 THEN 3119102 WHEN sp.master_product_id = 191031 THEN 3119102 WHEN sp.master_product_id = 3119102 THEN 3119102 WHEN sp.master_product_id = 195116 THEN 3119102 WHEN sp.master_product_id = 2615066 THEN 2615066 WHEN sp.master_product_id = 113731 THEN 2615066 WHEN sp.master_product_id = 5130723 THEN 5130723 WHEN sp.master_product_id = 1907930 THEN 5130723 WHEN sp.master_product_id = 150734 THEN 5130723 WHEN sp.master_product_id = 133480 THEN 5130723 ELSE sp.master_product_id END limit 500
Bindings:
[8775869,8775868,8775867,8775866,8775865,8775864,8775863,8775862,8775861,8775860,8775859,8775858,8775857,8775856,8775855,8775854,8775853,8775852,8775851,8775850,8775849,8775848,8775847,8775846,8775845,8775844,8775843,8775842,8775841,8775840,8775839,8775838,8775837,8775836,8775835,8775834,8775833,8775832,8775831,8775830,8775829,8775828,8775827,8775826,8775825,8775816,8775815,8775810,8775804,8775803,8775802,8775801,8775782,8775781,8775755,8775713,8775712,8775711,8775710,8775709,8775708,8775707,8775651,8775580,8775546,8775533,8775532,8775528,8775519,8775509,7443254,5130723,5130389,5127697,4988681,4987518,4619338,4533815,4012164,3915123,3549846,3340041,3119102,3015043,2950238,2931321,2797107,2647878,2642425,2642320,2641760,2639215,2616260,2615066,2609947,2609674,2645047,7696015,199939,4869230,4533490,189745,2671007,190787,809367,420472,95010,764101,337070,1945358,124804,2769595,101043,2901961,3675179,368474,374223,122806,95379,2742300,2629564,3261507,1907886,101044,322317,127029,154873,123105,122841,102185,102244,130085,94867,94974,97463,98565,101042,101339,7471561,2608090,112925,110719,115658,111499,114703,115686,4859763,4725190,191031,195116,113731,1907930,150734,133480,0,744,26,183,475,669,107]