#6
⏱️ 75.77 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?)
Bindings:
[8775869,8775782,8775713,8775651,8775580,8775546,8775533,8775532,8775528,8775519,8775509,7443254,5130723,5130389,5127697,4988681,4987518,4012164,3915123,2931321,2797107,2647878,2642320,2641760,2616260,2615066,2609674,2609139,2609137,2608279,2606604,2606582,8775857,8775862,8775826,8775829,8775830,8775837,8775838,8775841,8775842,8775845,8775843,8775844,8775847,8775846,8775848,8775850,8775851,8775859,8775861,8775867,8775868,2645047,7696015,8775839,8775856,8775858,8775860,8775863,8775864,199939,4869230,4619338,8775832,8775833,8775836,8775865,8775825,8775828,4533490,189745,8775840,8775849,8775853,8775855,8775866,2642425,2671007,8775827,8775831,8775834,8775835,8775852,8775854,190787,7471561,2608090,112925,110719,8775708,8775709,8775712,8775707,8775710,8775711,2609947,115658,111499,114703,115686,8775781,115805,114773,115646,113731,1907930,150734,133480,true,744,26,183,475,669,107]
#8
⏱️ 38.58 мс
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 8775869 WHEN sp.master_product_id = 8775862 THEN 8775869 WHEN sp.master_product_id = 8775826 THEN 8775869 WHEN sp.master_product_id = 8775829 THEN 8775869 WHEN sp.master_product_id = 8775830 THEN 8775869 WHEN sp.master_product_id = 8775837 THEN 8775869 WHEN sp.master_product_id = 8775838 THEN 8775869 WHEN sp.master_product_id = 8775841 THEN 8775869 WHEN sp.master_product_id = 8775842 THEN 8775869 WHEN sp.master_product_id = 8775845 THEN 8775869 WHEN sp.master_product_id = 8775843 THEN 8775869 WHEN sp.master_product_id = 8775844 THEN 8775869 WHEN sp.master_product_id = 8775847 THEN 8775869 WHEN sp.master_product_id = 8775846 THEN 8775869 WHEN sp.master_product_id = 8775848 THEN 8775869 WHEN sp.master_product_id = 8775850 THEN 8775869 WHEN sp.master_product_id = 8775851 THEN 8775869 WHEN sp.master_product_id = 8775859 THEN 8775869 WHEN sp.master_product_id = 8775861 THEN 8775869 WHEN sp.master_product_id = 8775867 THEN 8775869 WHEN sp.master_product_id = 8775868 THEN 8775869 WHEN sp.master_product_id = 2645047 THEN 8775869 WHEN sp.master_product_id = 7696015 THEN 8775869 WHEN sp.master_product_id = 8775839 THEN 8775869 WHEN sp.master_product_id = 8775856 THEN 8775869 WHEN sp.master_product_id = 8775858 THEN 8775869 WHEN sp.master_product_id = 8775860 THEN 8775869 WHEN sp.master_product_id = 8775863 THEN 8775869 WHEN sp.master_product_id = 8775864 THEN 8775869 WHEN sp.master_product_id = 199939 THEN 8775869 WHEN sp.master_product_id = 4869230 THEN 8775869 WHEN sp.master_product_id = 4619338 THEN 8775869 WHEN sp.master_product_id = 8775832 THEN 8775869 WHEN sp.master_product_id = 8775833 THEN 8775869 WHEN sp.master_product_id = 8775836 THEN 8775869 WHEN sp.master_product_id = 8775865 THEN 8775869 WHEN sp.master_product_id = 8775825 THEN 8775869 WHEN sp.master_product_id = 8775828 THEN 8775869 WHEN sp.master_product_id = 4533490 THEN 8775869 WHEN sp.master_product_id = 189745 THEN 8775869 WHEN sp.master_product_id = 8775840 THEN 8775869 WHEN sp.master_product_id = 8775849 THEN 8775869 WHEN sp.master_product_id = 8775853 THEN 8775869 WHEN sp.master_product_id = 8775855 THEN 8775869 WHEN sp.master_product_id = 8775866 THEN 8775869 WHEN sp.master_product_id = 2642425 THEN 8775869 WHEN sp.master_product_id = 2671007 THEN 8775869 WHEN sp.master_product_id = 8775827 THEN 8775869 WHEN sp.master_product_id = 8775831 THEN 8775869 WHEN sp.master_product_id = 8775834 THEN 8775869 WHEN sp.master_product_id = 8775835 THEN 8775869 WHEN sp.master_product_id = 8775852 THEN 8775869 WHEN sp.master_product_id = 8775854 THEN 8775869 WHEN sp.master_product_id = 8775869 THEN 8775869 WHEN sp.master_product_id = 190787 THEN 8775869 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 8775713 WHEN sp.master_product_id = 8775709 THEN 8775713 WHEN sp.master_product_id = 8775712 THEN 8775713 WHEN sp.master_product_id = 8775707 THEN 8775713 WHEN sp.master_product_id = 8775710 THEN 8775713 WHEN sp.master_product_id = 8775711 THEN 8775713 WHEN sp.master_product_id = 2609947 THEN 8775713 WHEN sp.master_product_id = 115658 THEN 8775713 WHEN sp.master_product_id = 8775713 THEN 8775713 WHEN sp.master_product_id = 111499 THEN 8775713 WHEN sp.master_product_id = 114703 THEN 8775713 WHEN sp.master_product_id = 115686 THEN 8775713 WHEN sp.master_product_id = 8775781 THEN 8775782 WHEN sp.master_product_id = 8775782 THEN 8775782 WHEN sp.master_product_id = 2609139 THEN 2609139 WHEN sp.master_product_id = 115805 THEN 2609139 WHEN sp.master_product_id = 114773 THEN 2609139 WHEN sp.master_product_id = 115646 THEN 2609139 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,8775782,8775713,8775651,8775580,8775546,8775533,8775532,8775528,8775519,8775509,7443254,5130723,5130389,5127697,4988681,4987518,4012164,3915123,2931321,2797107,2647878,2642320,2641760,2616260,2615066,2609674,2609139,2609137,2608279,2606604,2606582,8775857,8775862,8775826,8775829,8775830,8775837,8775838,8775841,8775842,8775845,8775843,8775844,8775847,8775846,8775848,8775850,8775851,8775859,8775861,8775867,8775868,2645047,7696015,8775839,8775856,8775858,8775860,8775863,8775864,199939,4869230,4619338,8775832,8775833,8775836,8775865,8775825,8775828,4533490,189745,8775840,8775849,8775853,8775855,8775866,2642425,2671007,8775827,8775831,8775834,8775835,8775852,8775854,190787,7471561,2608090,112925,110719,8775708,8775709,8775712,8775707,8775710,8775711,2609947,115658,111499,114703,115686,8775781,115805,114773,115646,113731,1907930,150734,133480,0,744,26,183,475,669,107]