thinkphp 查询方法

1 原生查询
$data =Db::query("select * from fa_myfile where status=1");
2 .条件查询
$map['id']=['eq',3];
$map['city']=['like','%黑%'];
$map['time']=['like','%22%'];
$data = Db::name('myfile')
->where($map)
->order('id desc')
->select();

3 .返回查询条件
$map['id']=['eq',3];
$map['city']=['like','%黑%'];
$map['time']=['like','%22%'];

    $data = Db::name('myfile')
        ->where($map)
        ->order('id desc')
        ->buildSql(true);