mysql效率问题

下面这段代码跑不起来 还要这么优化 请指点下if(!empty($cs_pro_info_pro_no_year)){
    foreach($cs_pro_info_pro_no_year as $val){
        $cs_pro_info_pro_no_query_year = $db -> query("select `pur_price`,`fanli_price`,`ywyc_price`,`sal_price`,`imei` from `oa_one_pro` where `product_id` = '".$val['pro_no']."'");
        while($cs_pro_info_pro_no_array_year = $db -> fetch_array($cs_pro_info_pro_no_query_year)){
            //pur_price采购价  ywyc_price业务预存款  fanli_price返利  sal_price卖价
            if($val['business_type'] == 'main'){
                $pur_price_main_year += $cs_pro_info_pro_no_array_year['pur_price'];
                $fanli_price_main_year += $cs_pro_info_pro_no_array_year['fanli_price'];
                $ywyc_price_main_year += $cs_pro_info_pro_no_array_year['ywyc_price'];
                $sal_price_main_year += $cs_pro_info_pro_no_array_year['sal_price'];
            }else{
                $pur_price_other_year += $cs_pro_info_pro_no_array_year['pur_price'];
                $fanli_price_other_year += $cs_pro_info_pro_no_array_year['fanli_price'];
                $ywyc_price_other_year += $cs_pro_info_pro_no_array_year['ywyc_price'];
                $sal_price_other_year += $cs_pro_info_pro_no_array_year['sal_price'];
            }
            
            //lhyc_price为靓号预存款
           if(strlen($cs_pro_info_pro_no_array_year['imei']) == 11){
                $sql = "select `num_yck` from `cs_new_num` A inner join `vte_numbers` B on A.num_id = B.id where B.number = '".$cs_pro_info_pro_no_array_month['imei']."'";
                $query = $db -> query($sql);
                $array = $db -> fetch_array($query);
                //找不到则赋值为0
                if(empty($array)){
                    if($val['business_type'] == 'main'){
                        $lhyc_price_main_year += 0;
                    }else{
                        $lhyc_price_other_year += 0;
                    }
                }else{
                    if($val['business_type'] == 'main'){
                        $lhyc_price_main_year += $array['num_yck'];
                    }else{
                        $lhyc_price_other_year += $array['num_yck'];
                    }            
                }
            }         
        }
    }
}