SELECT 
  * 
FROM 
  cscart_notification_settings

Query time 0.00101

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "11.70"
    },
    "table": {
      "table_name": "cscart_notification_settings",
      "access_type": "ALL",
      "rows_examined_per_scan": 109,
      "rows_produced_per_join": 109,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.80",
        "eval_cost": "10.90",
        "prefix_cost": "11.70",
        "data_read_per_join": "53K"
      },
      "used_columns": [
        "event_id",
        "transport_id",
        "receiver",
        "is_allowed"
      ]
    }
  }
}

Result

event_id transport_id receiver is_allowed
order.status_changed.p mail V 1
order.status_changed.c mail V 1
order.status_changed.o mail V 0
order.status_changed.b mail V 1
order.status_changed.i mail V 1
order.updated mail V 1
profile.activated.v mail V 1
profile.deactivated.v mail V 1
profile.updated.v mail V 1
profile.created.v mail V 1
profile.usergroup_activation.v mail V 1
profile.usergroup_disactivation.v mail V 1
profile.password_recover.v mail V 1
vendor_status_changed_active mail V 1
vendor_status_changed_active internal V 1
vendor_status_changed_pending mail V 0
vendor_status_changed_pending internal V 0
vendor_status_changed_disabled mail V 0
vendor_status_changed_from_suspended mail V 1
vendor_status_changed_suspended mail V 1
vendor_status_changed_suspended internal V 1
apply_for_vendor_notification mail V 1
vendor_plans.plan_changed mail V 0
vendor_plans.plan_payment mail V 0
vendor_communication.message_received mail V 1
vendor_communication.message_received internal V 1
vendor_communication.order_message_received mail V 1
vendor_communication.order_message_received internal V 1
vendor_communication.vendor_to_admin_message_received mail V 1
vendor_communication.vendor_to_admin_message_received internal V 1
vendor_data_premoderation.product_status.approved mail V 1
vendor_data_premoderation.product_status.approved internal V 1
vendor_data_premoderation.product_status.disapproved mail V 1
vendor_data_premoderation.product_status.disapproved internal V 1
discussion.orders.new_post mail V 1
discussion.pages.new_post mail V 1
discussion.vendors.new_post mail V 1
product_reviews.new_post mail V 1
product_reviews.new_post internal V 1
vendor_debt_payout.negative_balance_reached internal V 1
vendor_debt_payout.vendor_days_before_suspend mail V 1
order.shipment_updated mail C 1
order.edp mail C 1
order.status_changed.p mail C 1
order.status_changed.c mail C 1
order.status_changed.o mail C 0
order.status_changed.b mail C 1
order.status_changed.i mail C 1
order.status_changed.s mail C 1
order.updated mail C 1
product.back_in_stock mail C 1
profile.activated.c mail C 1
profile.deactivated.c mail C 1
profile.updated.c mail C 1
profile.created.c mail C 1
profile.usergroup_activation.c mail C 1
profile.usergroup_disactivation.c mail C 1
profile.password_recover.c mail C 1
vendor_communication.message_received mail C 1
vendor_communication.order_message_received mail C 1
discussion.orders.new_post mail C 1
product_reviews.new_reply mail C 1
as_alert_customer.user_login.c mail C 1
order.status_changed.p mail A 1
order.status_changed.c mail A 1
order.status_changed.o mail A 0
order.status_changed.b mail A 1
order.status_changed.i mail A 1
order.status_changed.s mail A 1
order.updated mail A 1
profile.activated.a mail A 1
profile.deactivated.a mail A 1
profile.password_reminder mail A 1
profile.updated.a mail A 1
profile.created.a mail A 1
profile.usergroup_activation.a mail A 1
profile.usergroup_disactivation.a mail A 1
profile.password_recover.a mail A 1
profile.usergroup_request mail A 1
profile.added mail A 1
system.realtime_shipping_error.a mail A 1
helpdesk_process_message internal A 1
vendors_require_approval internal A 1
apply_for_vendor_notification mail A 1
new_vendor_notification mail A 1
new_vendor_notification internal A 1
vendor_communication.message_received mail A 1
vendor_communication.message_received internal A 1
vendor_communication.order_message_received mail A 1
vendor_communication.order_message_received internal A 1
vendor_communication.vendor_to_admin_message_received mail A 1
vendor_communication.vendor_to_admin_message_received internal A 1
vendor_plans.plan_changed mail A 1
vendor_data_premoderation.added_product mail A 1
vendor_data_premoderation.added_product internal A 1
discussion.testimonials.new_post mail A 1
discussion.orders.new_post mail A 1
discussion.categories.new_post mail A 1
discussion.pages.new_post mail A 1
discussion.vendors.new_post mail A 1
product_reviews.new_post mail A 1
product_reviews.new_post internal A 1
as_alert_customer.user_login.a mail A 1
vendor_debt_payout.vendor_status_changed_to_suspended mail A 1
vendor_debt_payout.vendor_status_changed_to_suspended internal A 1
vendor_debt_payout.vendor_status_changed_to_disabled mail A 1
vendor_debt_payout.vendor_status_changed_to_disabled internal A 1
vendor_debt_payout.weekly_digest_of_debtors mail A 1
order.status_changed.s mail V 1