$query = Salesorder::find() ->where(['order_id'=>[1,2,3,4]]) ->select(['order_id']) ; $commandQuery = clone $query; echo $commandQuery->createCommand()->getRawSql(); exit; Salesorder::find() ->where(['order_id'=>[1,2,3,4]]) ->select(['order_id']) ->createCommand()->getRawSql()