Eager loading doesn't work

[alexk984]

I have sql query with eager loading

$shows = UserShow::find()
    ->where(['user_id' => \Yii::$app->user->id])
    ->innerJoinWith('show')->asArray()->all();

But it is doing 2 queries:

SELECT `user__shows`.* FROM `user__shows` 
INNER JOIN `shows` ON `user__shows`.`show_id` = `shows`.`id` 
WHERE `user_id`='1'

And then

SELECT * FROM `shows` WHERE `id` IN ('1', '2', '3')

Relation is

public function getShow()
{
    return $this->hasOne(Show::className(), ['id' => 'show_id']);
}

Is it a bug?

[qiangxue]

This is by design (eager loading in 2.0 is different from 1.1).

[ljames604]

This is a very unfortunate liability of using Yii2. Making 80% unnecessary database calls it totally unacceptable. This would only suffice for the simplest of database models. Any application that requires many table joins would severely suffer from this design flaw. Any application who uses a remote or external database connection, which is very common on apps hosted in the cloud, would suffer greatly as well.

This would make an EAV database model totally out of the question. I have yet to encounter another framework that does not allow this functionality. The performance boost greatly outweighs the complexity.

[klimov-paul]

You may use following extension to get rid of redundant queries:
https://github.com/yii2tech/ar-eagerjoin