Sandbox

SELECT 
  * 
FROM 
  cscart_notification_group_receivers 
ORDER BY 
  id ASC

Query time 0.00060

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.96"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "24.00"
      },
      "table": {
        "table_name": "cscart_notification_group_receivers",
        "access_type": "ALL",
        "rows_examined_per_scan": 24,
        "rows_produced_per_join": 24,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "0.57",
          "eval_cost": "2.40",
          "prefix_cost": "2.97",
          "data_read_per_join": "23K"
        },
        "used_columns": [
          "id",
          "group_id",
          "method",
          "criterion",
          "receiver"
        ]
      }
    }
  }
}

Result

id	group_id	method	criterion	receiver
1	orders	order_manager	order_manager	A
2	orders	user_id	1	A
3	users	user_id	1	A
4	system	user_id	1	A
5	vendors	user_id	1	A
6	orders	order_manager	order_manager	V
7	orders	vendor_owner	vendor_owner	V
8	vendors	vendor_owner	vendor_owner	V
9	orders	vendor_email	39	V
10	vendor_communication	user_id	1	A
11	vendor_communication	vendor_owner	vendor_owner	V
12	vendor_communication	vendor_email	39	V
13	vendor_plans	user_id	1	A
14	vendor_plans	vendor_owner	vendor_owner	V
17	vendor_data_premoderation	vendor_owner	vendor_owner	V
18	vendor_data_premoderation	user_id	1	A
22	discussion	user_id	1	A
23	discussion	vendor_owner	vendor_owner	V
24	discussion	vendor_email	39	V
25	product_reviews.product_reviews	user_id	1	A
26	product_reviews.product_reviews	vendor_owner	vendor_owner	V
27	product_reviews.product_reviews	vendor_email	39	V
28	vendor_debt_payout	vendor_owner	vendor_owner	V
29	vendor_debt_payout	user_id	1	A