Online PHP editor | perf for BsQYv

@ 2015-06-22T10:15:47Z

<?php

public function accessWithdraw( $withdraw_id, $operator_id, $sinaParams=array() ){
        $RechargeApi = new RechargeApi();
        $SinaApi = new SinaApi();
        $model = new Model();
        $model->startTrans();

        try{
                $sql = "SELECT id,accountId,money FROM yx_withdraw WHERE id = $withdraw_id AND (status=1 or status=9)";
                $withdraw = $this->query( $sql )->fetch();
                if(!$withdraw) throw new \PDOException("回调提现订单不在提现列表: [{$sql}]。".$this->getSqlErrorString());
                $money = $withdraw['money'];    // 提现金额
                $accountId = $withdraw['accountId'];    // 提现用户

                // 更新提现表
                $sql = "UPDATE yx_withdraw SET status='{$sinaParams['status']}', action_time='{$sinaParams['payTime']}' WHERE id={$withdraw_id}";
                $r1 = $this->exec($sql);
                if(!$r1) throw new \PDOException("批量提现成功后，更新永利宝提现表失败: [{$sql}]。".$this->getSqlErrorString());
               trace_money($accountId, \LogRules::BATCH_WITHDRAW_UPDATE_YLB_FINISH, "操作结束：[{$accountId}]提现[$money]元回调更新yx_withdraw表状态成功");

                // 更新新浪提现表
                $sql = "UPDATE bw_sina_user_withdraw SET status=2, pay_time={$sinaParams['pay_time']}, response_code='{$sinaParams['withdraw_status']}',response_message='{$sinaParams['error_message']}'  WHERE withdraw_id={$withdraw_id}";
                $r2 = $this->exec( $sql );
                if(!$r2) throw new \PDOException("批量提现成功后，更新新浪提现表: [{$sql}]。".$this->getSqlErrorString());
               trace_money($accountId, \LogRules::BATCH_WITHDRAW_UPDATE_SINA_FINISH, "操作结束：[{$accountId}]提现[$money]元回调更新bw_sina_user_withdraw表状态成功");

                // 插入公司资金流表
               $sql = "INSERT INTO bw_sina_company_record(`money`, `io`, `type`, `userId`, `created`, `response_code`, `response_message`) VALUES({$money}, '-1', 1, $accountId, $sinaParams['payTime'], '{$sinaParams['response_code']}', '{$sinaParams['response_message']}') ";
                $r3 = $this->exec($sql);
                if(!$r3) throw new \PDOException("提现成功后，插入公司资金流表失败: [{$sql}]。".$this->getSqlErrorString());
               trace_money($accountId, \LogRules::BATCH_WITHDRAW_UPDATE_COMPANY_FINISH, "操作结束：[{$accountId}]提现[$money]元回调更新bw_sina_company_record表状态成功");

                $model->commit();

        }catch(\Exception $e){
                $model->rollback();
                trace_error($user_id, \LogRules::BATCH_WITHDRAW_ACTION_ERROR, array('withdraw_id'=>$withdraw_id,'error'=>$e->getMessage())); 
        }
    }

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
5.6.10	0.007	0.083	21.02
5.6.9	0.010	0.067	21.10
5.6.8	0.007	0.033	20.50
5.6.7	0.330	0.030	20.27
5.5.26	0.003	0.047	20.83
5.5.25	0.003	0.083	20.55
5.5.24	0.033	0.060	20.06
5.4.42	0.030	0.063	19.27
5.4.41	0.020	0.040	19.18
5.4.40	0.033	0.070	19.00
5.4.39	0.030	0.040	19.07
5.4.38	0.033	0.060	18.86
5.4.37	0.027	0.050	19.05
5.4.36	0.027	0.077	19.08
5.4.35	0.030	0.050	19.14
5.4.34	0.030	0.057	19.08
5.4.32	0.033	0.067	19.22
5.4.31	0.037	0.070	19.22
5.4.30	0.023	0.037	19.00
5.4.29	0.037	0.047	18.85
5.4.28	0.033	0.027	18.94
5.4.27	0.020	0.037	19.24
5.4.26	0.053	0.037	19.19
5.4.25	0.033	0.037	19.00
5.4.24	0.027	0.077	18.94
5.4.23	0.030	0.067	19.13
5.4.22	0.033	0.067	19.13
5.4.21	0.030	0.067	18.99
5.4.20	0.027	0.037	18.87
5.4.19	0.020	0.050	19.19
5.4.18	0.023	0.047	19.08
5.4.17	0.020	0.040	18.84
5.4.16	0.030	0.077	19.12
5.4.15	0.027	0.063	19.06
5.4.14	0.023	0.043	16.33
5.4.13	0.030	0.067	16.28
5.4.12	0.027	0.063	16.34
5.4.11	0.027	0.037	16.56
5.4.10	0.027	0.043	16.37
5.4.9	0.023	0.037	16.42
5.4.8	0.030	0.067	16.52
5.4.7	0.030	0.047	16.44
5.4.6	0.023	0.037	16.38
5.4.5	0.030	0.060	16.38
5.4.4	0.023	0.067	16.54
5.4.3	0.027	0.067	16.42
5.4.2	0.023	0.047	16.50
5.4.1	0.017	0.047	16.51
5.4.0	0.027	0.060	15.79
5.3.29	0.033	0.070	14.51
5.3.28	0.023	0.043	14.64
5.3.27	0.027	0.033	14.49
5.3.26	0.030	0.063	14.45
5.3.25	0.023	0.077	14.64
5.3.24	0.040	0.063	14.65
5.3.23	0.037	0.043	14.45
5.3.22	0.027	0.070	14.52
5.3.21	0.027	0.050	14.54
5.3.20	0.033	0.053	14.41
5.3.19	0.027	0.040	14.44
5.3.18	0.033	0.063	14.59
5.3.17	0.033	0.063	14.41
5.3.16	0.050	0.050	14.40
5.3.15	0.023	0.073	14.43
5.3.14	0.030	0.073	14.41
5.3.13	0.030	0.070	14.58
5.3.12	0.040	0.060	14.64
5.3.11	0.023	0.053	14.39
5.3.10	0.037	0.060	14.15
5.3.9	0.027	0.053	13.98
5.3.8	0.030	0.043	14.01
5.3.7	0.023	0.073	13.84
5.3.6	0.027	0.057	13.83
5.3.5	0.030	0.063	13.74
5.3.4	0.030	0.063	13.99
5.3.3	0.027	0.047	13.81
5.3.2	0.027	0.047	13.54
5.3.1	0.020	0.040	13.60
5.3.0	0.023	0.073	13.72
5.2.17	0.020	0.043	11.28
5.2.16	0.023	0.057	11.28
5.2.15	0.027	0.027	11.28
5.2.14	0.017	0.050	11.28
5.2.13	0.023	0.060	11.28
5.2.12	0.020	0.040	11.28
5.2.11	0.020	0.060	11.28
5.2.10	0.020	0.030	11.28
5.2.9	0.020	0.053	11.28
5.2.8	0.013	0.033	11.28
5.2.7	0.023	0.027	11.28
5.2.6	0.033	0.047	11.28
5.2.5	0.023	0.040	11.28
5.2.4	0.023	0.030	11.28
5.2.3	0.040	0.040	11.28
5.2.2	0.017	0.043	11.28
5.2.1	0.020	0.047	11.28
5.2.0	0.020	0.057	11.28
5.1.6	0.023	0.043	11.28
5.1.5	0.020	0.033	11.28
5.1.4	0.013	0.050	11.28
5.1.3	0.017	0.040	11.28
5.1.2	0.020	0.023	11.28
5.1.1	0.013	0.040	11.28
5.1.0	0.013	0.050	11.28
5.0.5	0.010	0.033	11.28
5.0.4	0.010	0.020	11.28
5.0.3	0.010	0.063	11.28
5.0.2	0.020	0.023	11.28
5.0.1	0.007	0.047	11.28
5.0.0	0.003	0.033	11.28
4.4.9	0.007	0.017	11.28
4.4.8	0.003	0.023	11.28
4.4.7	0.007	0.037	11.28
4.4.6	0.010	0.030	11.28
4.4.5	0.010	0.027	11.28
4.4.4	0.013	0.040	11.28
4.4.3	0.003	0.027	11.28
4.4.2	0.007	0.027	11.28
4.4.1	0.017	0.030	11.28
4.4.0	0.010	0.053	11.28
4.3.11	0.010	0.017	11.28
4.3.10	0.007	0.023	11.28
4.3.9	0.010	0.017	11.28
4.3.8	0.007	0.023	11.28
4.3.7	0.010	0.013	11.28
4.3.6	0.007	0.013	11.28
4.3.5	0.007	0.013	11.28
4.3.4	0.010	0.023	11.28
4.3.3	0.003	0.017	11.28
4.3.2	0.003	0.013	11.28
4.3.1	0.003	0.013	11.28
4.3.0	0.000	0.017	11.28

preferences:dark modelive previewkey bindings