thinkphp5 获取sql语句

// 获取sql语句但不执行
$ipos_vip=$db->name('ipos_vip')
    ->alias('a')
    ->field('a.Id,a.xfcs,a.vpmc,a.sj,a.zjrq,a.xfje,a.birth,a.cz_dqje,c.khmc,d.dymc')
    ->join('ipos_qtlsd e','a.zd_id=e.zd_id','left')
    ->join('com_base_kehu c','e.zd_id=c.Id','left')
    ->join('ipos_dianyuan d','a.jsdy=d.Id','left')
    ->where($where)
    ->order('a.cz_dqje desc')
    ->fetchSql()
    ->select();
var_dump($ipos_vip);die;
 
 
// 获取执行后的sql语句
$ipos_vip=$db->name('ipos_vip')
    ->alias('a')
    ->field('a.Id,a.xfcs,a.vpmc,a.sj,a.zjrq,a.xfje,a.birth,a.cz_dqje,c.khmc,d.dymc')
    ->join('ipos_qtlsd e','a.zd_id=e.zd_id','left')
    ->join('com_base_kehu c','e.zd_id=c.Id','left')
    ->join('ipos_dianyuan d','a.jsdy=d.Id','left')
    ->where($where)
    ->order('a.cz_dqje desc')
    ->select()
    ->getLastSql();
var_dump($ipos_vip);die;

来源:https://blog.csdn.net/qq_39521804/article/details/124445884