問題描述Yii2開發(fā)中,使用關(guān)聯(lián)查詢with后,怎么打印執(zhí)行執(zhí)行sql呢?嘗試過echo $lesson->createCommand()->getRawSql();die;相關(guān)代碼$model = CrmLesson::find()
->where(['id' => $lessonId])
->with([ 'class' => function (ActiveQuery $query){
$query->select('id, num_code');
}
])
->select(['id as lesson_id', 'classroom_id', 'type', 'class_id', 'title', 'teacher', 'teacher_assistant', 'open_time as start_time', 'end_time'])
->asArray();echo $lesson->createCommand()->getRawSql();die;實際看到結(jié)果SELECT `id` AS `lesson_id`, `classroom_id`, `type`, `class_id`, `title`, `teacher`, `teacher_assistant`, `
Yii2 關(guān)聯(lián)查詢with 怎么打印執(zhí)行sql。
哈士奇WWW
2019-03-19 18:43:04