Why are there many identical requests in auth_assignment in yii2?

Question

I'm developing a small admin panel on yii2. I use rbac and yii2-admin. There are a lot of identical requests in the debugger. These are:

SELECT * FROM `auth_assignment` WHERE` user_id` = '5'

I do not make queries to the tables of the rbac.

My action:

public function actionProduction(){

    $searchModel = new OrderSearch();
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
    $dataProvider->query->andWhere(['order_status' => 'production', 'production_user' => null]);

    //$active_order = $this->getActiveOrder(Yii::$app->user->getId(), Yii::$app->controller->action->id);

    return $this->render('userGrid', [
        'searchModel' => $searchModel,
        'dataProvider' => $dataProvider,
        //'active_order' => $active_order,
        'to' => $to = 'packing'
    ]);

}

you are looged with uer_id = 5? – ScaisEdge Aug 25 '17 at 11:34 — ScaisEdge, Aug 25 '17 at 11:34

score 0 · Answer 1 · answered Aug 25 '17 at 11:36

0

Seems you are logged as user_di =5

the request you see in debugger

  SELECT * FROMauth_assignmentWHERE user_id= '5'

are performed by rbac yii2 module for get the permission related to the act user and store this permission for check the accessing if needed

answered Aug 25 '17 at 11:36

ScaisEdge

131,976
10
91
107

But it normal? I think there are a lot of queries. – Tim Hoggarth Aug 25 '17 at 11:43
@TimHoggarth it is normal until you set `cache` in `DbManager`. [DbManager - cache](http://www.yiiframework.com/doc-2.0/yii-rbac-dbmanager.html#$cache-detail) – Yupik Aug 25 '17 at 11:55
@Yupik Thank you – Tim Hoggarth Aug 25 '17 at 11:59

Why are there many identical requests in auth_assignment in yii2?

1 Answers1