// 获取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;