yii2中的sql调试

2017-03-23 07:14:52 catherine

yii2中的sql调试，可打印出sql来：

User::find()->where("isgive=0 and  intime > $t")->limit(100)->orderby("id desc")->createCommand()->getRawSql(); die;
self::find()->asArray()
            ->where(['member_id' => $memberIds])
            ->select(['member_id', 'order_id', 'count(*) as orderCount'])
            ->indexBy('member_id')
            ->groupBy('order_id')
            //->createCommand()->getRawSql();
            ->all();

分类: web

标签: php yii2

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

study ab amap apache apahe awk aws bat centos CFS chrome cmd cnpm composer consul crontab css curl cygwin devops di docker docker,docker-compose ethereum excel fiddler fluentd framework front-end git gitgui github glide go golang gorm grafana gzip ioc item2 iterm2 javascript jenkins jsonp kafka laradock laravel larval linux liunux log mac mac, wi-fi macos magento mariaDB minikube mongoDB msp mysql netbeans nginx nodejs nohup npm nsq oracle php php-fpm php7 phpstorm php扩展 Protobuf python redis scp server shell soap socket socket5 sql sre ssdb ssh ssl study sublime swift system td-agent uml v2ray vagrant vagrnat vim vpn vue vue.js webpack webrtc websocket webtatic windows windows7 word wps xdebug yarn yii2 yum zookeeper 世界国家互联网以太坊分类前端小程序打印机排序算法搞笑权限粤语缓存网络虚拟机视频设计模式项目管理