Query takes 5 seconds. Same query with COUNT (added by Yii), takes 118 seconds. How can I disable the Yii COUNT query? I do not performe any custom count queries.
How can I remove the COUNT query added by Yii? I used to check the count, but removed it, but still the COUNT query is executed… ‘count’ => $dataProvider->getTotalCount(), <-removed
I am using pagination, am that could be a source for the COUNT query…