Yii2 mongodb ActiveRecord select query very slow event if there have many rows.

[nishanthrk]

What steps will reproduce the problem?

using yii\mongodb\Query;
$query->select(['data'])
->from('log')
->where(['userId' => 12234])
->limit(10);

using ActiveRecord
$result = Log::find()
->select(['data'])
->where(['userId' => 12234])
->orderBy(['addedOn' => SORT_DESC])
->offset(0)->limit(10)
->asArray()
->all();

What's expected?

I have around 10528546 document in that collection and it is taking more then one minute to execute the query

Additional info

Q	A
Yii version	2.0.6
Yii MongoDB version	2.1.0
MongoDB server version	3.6
PHP version	7.0
Operating system	Ubuntu 16

[cebe]

is it faster if you try the same query without Yii?

[nishanthrk]

When i executve the same query in mongo console or robo 3t it took only approximate 10 sec

Query:
db.getCollection('log').find({'userId': 23453})