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