Sandbox

SELECT 
  * 
FROM 
  cscart_notification_settings

Query time 0.00095

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