mysql循環(huán)查詢優(yōu)化

foreach ($list as $key => $val) {

            $orderId = $val['ORDER_ID'];
            //訂單業(yè)績歸屬人
            $orderPerform = $OrderQueryMod->getOrderPerform($orderId);
            //訂單產(chǎn)品信息
            $productInfo = M('order_detail_info')->where(array('ORDER_ID' => $orderId))->select();
            //訂單類型：1 正常訂單 2 擴容續(xù)費 3 壓貨 4 支付碼訂單
            switch ($val['ORDER_TYPE']) {
                case 1:
                    $ordertype = '正常訂單';
                    break;
                case 2:
                    $ordertype = '擴容續(xù)費';
                    break;
                case 3:
                    $ordertype = '壓貨訂單';
                    break;
                case 4:
                    $ordertype = '支付碼訂單';
                    break;
            }
            foreach ($orderPerform as $k => $v) {
                $num = 0;
                foreach ($productInfo as $kk => $vv) {
                    $num++;
                    $salesOffId = M('consignment_info')->where(array('ORDER_ID' => $orderId))->getField('SALES_OFF');
                    $data[$j]['銷售部門'] = D('config_system')->where(array('CONFIG_KEY' => 'SALES_OFF', 'CONFIG_VALUE' => $salesOffId))->getField('CONFIG_DESCRIPTIO');
                    ;
                    $data[$j]['訂單號'] = $orderId;
                    $data[$j]['訂單標(biāo)識碼'] = $orderId . '-' . $num;
                    $data[$j]['訂單金額'] = $vv['INCOME'] / 100;
                    $data[$j]['訂單類型'] = $ordertype;
                    $receivedMoney = ($vv['INCOME'] / 100) * (($val['RECEIVED_MONEY'] / 100) / ($val['TOTAL_MONEY'] / 100));
                    $data[$j]['到款金額'] = round($receivedMoney, 2);
                    $data[$j]['成本金額'] = $vv['COST'] / 100;
                    $performBfRebate = ($vv['INCOME'] / 100) * ($val['PERFORM_BF_REBATE'] / ($val['TOTAL_MONEY'] / 100));
                    $data[$j]['返點前業(yè)績'] = round($performBfRebate, 2);
                    $data[$j]['返點比例'] = $val['REBATE_PERCENT'];
                    $data[$j]['是否特價審批單'] = $val['IS_BARGAIN_PRICE'] == 0 ? '非特價' : '特價';
                    $data[$j]['結(jié)算方式'] = M('config_system')->where(array('CONFIG_KEY' => 'SETTLEMENT_TYPE', 'CONFIG_VALUE' => $val['PAY_TYPE']))->getField('CONFIG_DESCRIPTIO');
                    $salesmanId = $val['SALESMAN_ID'];
                    $deptId = $v['DEPT_ID'];
                    $data[$j]['部門'] = M('config_dept_info')->where(array('DEPT_ID' => $deptId))->getField('DEPT_NAME');
                    $data[$j]['業(yè)績歸屬人'] = $v['SALESMAN_NAME'];
                    $data[$j]['業(yè)績分配比例'] = $v['PERCENT'];
                    $saler_info = $OrderQueryMod->GetOrderSaler($val['APPLY_SALER_ID']);
                    $second_saler_info = $OrderQueryMod->GetOrderSaler($val['SECONDARY_SALER_ID']);
                    $data[$j]['一級經(jīng)銷商SAP主數(shù)據(jù)編號'] = empty($saler_info['SAP_UID']) ? '無' : $saler_info['SAP_UID'];
                    $data[$j]['經(jīng)銷商全稱'] = $saler_info['REAL_NAME'];
                    $data[$j]['二級經(jīng)銷商SAP主數(shù)據(jù)編號'] = empty($second_saler_info['SAP_UID']) ? '無' : $second_saler_info['SAP_UID'];
                    $data[$j]['二級經(jīng)銷商'] = $second_saler_info['REAL_NAME'];
                    $consignerTime = $val['SAP_CONSIGNER_TIME'];
                    $data[$j]['發(fā)貨日期'] = empty($consignerTime) ? '無' : date('Y-m-d', strtotime($consignerTime));
                    if (empty($consignerTime)) {
                        $data[$j]['季度'] = '';
                        $data[$j]['周起止'] = '';
                    } else {
                        $consignerTimeMonths = date('m', strtotime($consignerTime));
                        if (in_array($consignerTimeMonths, array('01', '02', '03'))) {
                            $data[$j]['季度'] = 1;
                        }
                        if (in_array($consignerTimeMonths, array('04', '05', '06'))) {
                            $data[$j]['季度'] = 2;
                        }
                        if (in_array($consignerTimeMonths, array('07', '08', '09'))) {
                            $data[$j]['季度'] = 3;
                        }
                        if (in_array($consignerTimeMonths, array('10', '11', '12'))) {
                            $data[$j]['季度'] = 4;
                        }
                        $lastday = date('Y-m-d', strtotime("$consignerTime Thursday"));
                        $firstday = date('Y-m-d', strtotime("$lastday -6 days"));
                        $data[$j]['周起止'] = date('m.d', strtotime($firstday)) . '-' . date('m.d', strtotime($lastday));
                    }
                    $finalUser = $OrderQueryMod->GetOrderFinaluser($val['FINAL_USER_ID']);
                    $data[$j]['最終用戶名稱'] = $finalUser['FINAL_USER_NAME'];
                    $data[$j]['項目類型'] = D('config_system')->where(array('CONFIG_KEY' => 'FINAL_USER_TYPE', 'CONFIG_VALUE' => $finalUser['FINAL_USER_TYPE']))->getField('CONFIG_DESCRIPTIO');;
                    $provinceId = $finalUser['FINALE_USER_PROVINCE'];
                    $areaId = M('config_province_info')->where("PROVINCE_ID = $provinceId")->getField('AREA_ID');
                    $areaName = M('config_area_info')->where("AREA_ID = $areaId")->getField('AREA_NAME');
                    $data[$j]['區(qū)域'] = $areaName;
                    $provinceName = M('config_province_info')->where("PROVINCE_ID = $provinceId")->getField('PROVINCE_NAME');
                    $data[$j]['省'] = $provinceName;
                    $cityId = $finalUser['FINALE_USER_CITY'];
                    $cityName = M('config_city_info')->where("CITY_ID = $cityId")->getField('CITY_NAME');
                    $data[$j]['市'] = $cityName;
                    $data[$j]['詳細地址'] = $finalUser['FINAL_USER_ADDRESS'];
                    $customType = $finalUser['CUSTOM_TYPE'];
                    $customTypeName = M('customer_type_info')->where("CUSTOMER_TYPE = $customType")->getField('CUSTOMER_TYPE_NAME');
                    $data[$j]['客戶類型'] = $customTypeName;
                    $customIndustry = $finalUser['CUSTOMER_INDUSTRY'];
                    $customIndustryName = M('customer_industry_info')->where("CUSTOMER_INDUSTRY_ID = $customIndustry")->getField('CUSTOMER_INDUSTRY_NAME');
                    $data[$j]['客戶行業(yè)'] = $customIndustryName;
                    $data[$j]['CRM客戶編號'] = empty($finalUser['CRM_CUSTOM_ID']) ? '無' : $finalUser['CRM_CUSTOM_ID'];
                    $data[$j]['CRM項目編號'] = empty($val['CRM_PROJECT_ID']) ? '無' : $val['CRM_PROJECT_ID'];
                    $data[$j]['采購聯(lián)系人'] = $finalUser['PURCHASER'];
                    $data[$j]['采購聯(lián)系人電話'] = empty($finalUser['PURCHASER_PHONE']) ? '無' : $finalUser['PURCHASER_PHONE'];
                    $data[$j]['采購聯(lián)系人郵箱'] = $finalUser['PURCHASER_EMAIL'];
                    $data[$j]['IT部/信息部負責(zé)人'] = $finalUser['TECHNICIAN'];
                    $data[$j]['IT部/信息部負責(zé)人電話'] = empty($finalUser['TECHNICIAN_PHONE']) ? '無' : $finalUser['TECHNICIAN_PHONE'];
                    $data[$j]['IT部/信息部負責(zé)人郵箱'] = $finalUser['TECHNICIAN_EMAIL'];
                    $data[$j]['WPS+賬號聯(lián)系人'] = $finalUser['WPS_CONTACTOR'];
                    $data[$j]['WPS+賬號聯(lián)系人電話'] = empty($finalUser['WPS_CONTACTOR_PHONE']) ? '無' : $finalUser['WPS_CONTACTOR_PHONE'];
                    $data[$j]['WPS+賬號聯(lián)系人郵箱'] = $finalUser['WPS_CONTACTOR_EMAIL'];
                    $wpsAccount = M('order_inferior_user')->where(array('ORDER_ID' => $orderId, 'WPS_ACCOUNT_ID' => array('neq', '')))->getField('WPS_ACCOUNT_ID', true);
                    $wpsAccountstr = empty($wpsAccount) ? '' : implode(',', $wpsAccount);
                    $data[$j]['WPS+賬號'] = $wpsAccountstr;
                    $data[$j]['支付碼'] = M('order_grant_code')->where(array('ORDER_ID' => $orderId))->order('ID DESC')->getField('GRANT_CODE');
                    if ($vv['PRODUCT_ID'] == 60 || $vv['PRODUCT_ID'] == 61 || $vv['PRODUCT_ID'] == 109 || $vv['PRODUCT_ID'] == 110) {
                        $data[$j]['是否贈送服務(wù)'] = '否';
                    } else {
                        $data[$j]['是否贈送服務(wù)'] = $vv['SERVICE_TYPE'] == '' || $vv['SERVICE_TYPE'] == -1 ? '否' : '是';
                    }
                    $productId = $vv['PRODUCT_ID'];
                    $productCategory = M('config_product_info')->where(array('PRODUCT_ID' => $vv['PRODUCT_ID']))->getField('PRODUCT_CATEGORY');
                    $data[$j]['產(chǎn)品類'] = M('config_system')->where(array('CONFIG_KEY' => 'PRODUCT_CATEGORY', 'CONFIG_VALUE' => $productCategory))->getField('CONFIG_DESCRIPTIO');
                    $data[$j]['物料描述'] = M('config_product_info')->where(array('PRODUCT_ID' => $productId))->getField('PRODUCT_DETAIL_NAME');
                    $productType = M('config_product_info')->where(array('PRODUCT_ID' => $vv['PRODUCT_ID']))->getField('PRODUCT_TYPE');
                    if ($productCategory == 1 && $productType == 1 || $productType == 3) {
                        $serialIds = M('serial_number')->where(array('ORDER_ID' => $orderId, 'SERIAL_NUMBER' => array('neq', '')))->getField('SERIAL_ID', true);
                        $serialTypeStr = '';
                        foreach ($serialIds as $serialId) {
                            $serialTypeInfo = M('serial_number')->where(array('SERIAL_ID' => $serialId))->field('USE_AREA, LANGUAGE_TYPE')->find();
                            $serialTypeStr .= implode(',', $serialTypeInfo) . '|';
                        }
                        $serialTypeStr = str_replace("china", "中國", $serialTypeStr);
                        $serialTypeStr = str_replace("england", "英國", $serialTypeStr);
                        $serialTypeStr = str_replace("japan", "日本", $serialTypeStr);
                        $serialTypeStr = str_replace("chn", "中文", $serialTypeStr);
                        $serialTypeStr = str_replace("enu", "英文", $serialTypeStr);
                        $serialTypeStr = str_replace("jpn", "日文", $serialTypeStr);
                        $data[$j]['序列號類型'] = rtrim($serialTypeStr, '|');
                    } else {
                        $data[$j]['序列號類型'] = '無';
                    }
                    if ($productCategory == 1) {
                        $authorizedType = $vv['AUTHORIZED_TYPE'];
                        $data[$j]['授權(quán)類型'] = M('config_system')->where(array('CONFIG_KEY' => 'AUTHORIZED_TYPE', 'CONFIG_VALUE' => $authorizedType))->getField('CONFIG_DESCRIPTIO');
                    } else {
                        $authorizedType = $vv['SPEC'];
                        $data[$j]['授權(quán)類型'] = M('config_system')->where(array('CONFIG_KEY' => 'PRODUCT_SPECS', 'CONFIG_VALUE' => $authorizedType))->getField('CONFIG_DESCRIPTIO');
                    }
                    $data[$j]['授權(quán)范圍'] = $vv['AUTHORIZED_RANGE'];
                    $data[$j]['介質(zhì)數(shù)量'] = $vv['TANN_COUNT'];
                    $data[$j]['授權(quán)數(shù)量'] = $vv['AMOUNT'];
                    $data[$j]['單價'] = $vv['PRICE'] / 100;
                    $data[$j]['到期后授權(quán)數(shù)量'] = $vv['EXPIRE_AUTHORIZED_AMOUNT'];
                    $data[$j]['服務(wù)年限'] = empty($vv['SERVICE_LENGTH']) ? 0 : $vv['SERVICE_LENGTH'];
                    $data[$j]['服務(wù)截止時間'] = empty($vv['SERVICE_LENGTH']) ? date('Y-m-d', strtotime('+0 years 10 days', strtotime($val['APPLY_TIME']))) : date('Y-m-d', strtotime('+' . $vv['SERVICE_LENGTH'] . ' years 10 days', strtotime($val['APPLY_TIME'])));
                    $data[$j]['授權(quán)年限'] = empty($vv['AUTHORIZED_YEARS']) ? 0 : $vv['AUTHORIZED_YEARS'];
                    if ($vv['AUTHORIZED_YEARS'] == '永久') {
                        $data[$j]['授權(quán)截止時間'] = '永久';
                    } else if ($vv['AUTHORIZED_YEARS'] == '隨設(shè)備') {
                        $data[$j]['授權(quán)截止時間'] = date('Y-m-d', strtotime('+5 years 10 days', strtotime($val['APPLY_TIME'])));
                    } else {
                        $data[$j]['授權(quán)截止時間'] = empty($vv['AUTHORIZED_YEARS']) ? date('Y-m-d', strtotime('+0 years 10 days', strtotime($val['APPLY_TIME']))) : date('Y-m-d', strtotime('+' . $vv['AUTHORIZED_YEARS'] . ' years 10 days', strtotime($val['APPLY_TIME'])));
                    }
                    $isFinal = M('saler_info')->where(array('SALER_ID' => $val['APPLY_SALER_ID']))->getField('IS_FINAL');
                    $data[$j]['訂方性質(zhì)'] = $isFinal == 1 ? '最終用戶' : '經(jīng)銷商';
                    $data[$j]['供貨方'] = M('order_info')->where(array('ORDER_ID' => $orderId))->getField('SALES_ORG');
                    $wuliao = M('config_product_info')->where(array('PRODUCT_ID' => $vv['PRODUCT_ID']))->find();
                    if (empty($wuliao['TAP']) && empty($wuliao['TANN']) && empty($wuliao['TAN'])) {
                        $data[$j]['SAP單號'] = '';
                    } else {
                        $data[$j]['SAP單號'] = empty($val['SAP_SALES_ORDER_ID']) ? '' : (int) $val['SAP_SALES_ORDER_ID'];
                    }
                    $data[$j]['合同編號'] = empty($val['CONTRACT_CODE']) ? '無' : $val['CONTRACT_CODE'];
                    $data[$j]['下單備注'] = $val['DESCRIPTION'];
                    $description = D('order_audit_log')->where(array('AUDIT_TYPE' => 1, 'LOG_STATE' => 1, 'ORDER_ID' => $orderId))->getField('DESCRIPTION');
                    $data[$j]['訂單規(guī)范檢查備注'] = empty($description) ? '' : $description;
                    $data[$j]['訂單審核備注'] = D('order_audit_log')->where(array('ORDER_ID' => $orderId, 'AUDIT_TYPE' => 3, 'LOG_STATE' => 1))->getField('DESCRIPTION');
                    $data[$j]['序列號設(shè)置備注'] = D('order_audit_log')->where(array('ORDER_ID' => $orderId, 'AUDIT_TYPE' => 14, 'LOG_STATE' => 1))->getField('DESCRIPTION');
                    $data[$j]['打印授權(quán)書審核備注'] = D('order_audit_log')->where(array('ORDER_ID' => $orderId, 'AUDIT_TYPE' => 15, 'LOG_STATE' => 1))->getField('DESCRIPTION');
                    $data[$j]['報備審核備注'] = D('order_audit_log')->where(array('ORDER_ID' => $orderId, 'AUDIT_TYPE' => 2, 'LOG_STATE' => 1))->getField('DESCRIPTION');
                    if ($val['INVOICE_OWNER_PROVINCE'] == $val['INVOICE_OWNER_CITY']) {
                        $cityId = $val['INVOICE_OWNER_CITY'];
                        $cityName = M('config_city_info')->where("CITY_ID = $cityId")->getField('CITY_NAME');
                        $data[$j]['發(fā)票收件地址'] = $cityName . $val['INVOICE_OWNER_ADDRESS'];
                    } else {
                        $provinceId = $val['INVOICE_OWNER_PROVINCE'];
                        $provinceName = M('config_province_info')->where("PROVINCE_ID = $provinceId")->getField('PROVINCE_NAME');
                        $cityId = $val['INVOICE_OWNER_CITY'];
                        $cityName = M('config_city_info')->where("CITY_ID = $cityId")->getField('CITY_NAME');
                        $data[$j]['發(fā)票收件地址'] = $provinceName . $cityName . $val['INVOICE_OWNER_ADDRESS'];
                    }
                    $data[$j]['發(fā)票收件人'] = $val['INVOICE_OWNER'];
                    $data[$j]['發(fā)票收件人電話'] = empty($val['INVOICE_OWNER_PHONE']) ? '無' : $val['INVOICE_OWNER_PHONE'];
                    $j++;
                }
            }
        }

$list大約有4000左右條數(shù)據(jù) 打印日志到超時大約有20M的sql日志 每條sql執(zhí)行時間都在0.00幾秒 有什么辦法或者思路優(yōu)化呢？