Explain Query (mysql)

EXPLAIN SELECT `t`.`supplier_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`address` AS `t0_c2`, `t`.`city_id` AS `t0_c3`, `t`.`warehouse_id` AS `t0_c4`, `t`.`state_id` AS `t0_c5`, `t`.`zip_code` AS `t0_c6`, `t`.`city_name` AS `t0_c7`, `t`.`website` AS `t0_c8`, `t`.`logo` AS `t0_c9`, `t`.`telephone` AS `t0_c10`, `t`.`email` AS `t0_c11`, `t`.`description` AS `t0_c12`, `t`.`status` AS `t0_c13`, `t`.`uniform_reception` AS `t0_c14`, `t`.`primary` AS `t0_c15`, `t`.`weight` AS `t0_c16`, `t`.`slug` AS `t0_c17`, `t`.`lead_time` AS `t0_c18`, `t`.`shipping_and_handling_fees` AS `t0_c19`, `t`.`region_id` AS `t0_c20`, `t`.`can_create_sfids` AS `t0_c21`, `t`.`can_adjust_qty_for_sell` AS `t0_c22`, `t`.`lock_status` AS `t0_c23`, `t`.`lock_status_comment` AS `t0_c24`, `t`.`created_by` AS `t0_c25`, `t`.`created_at` AS `t0_c26`, `t`.`last_update_by` AS `t0_c27`, `t`.`last_update_at` AS `t0_c28`, `t`.`GST` AS `t0_c29`, `t`.`PST` AS `t0_c30`, `t`.`terms_conditions_approved_by` AS `t0_c31`, `t`.`terms_conditions_approved_at` AS `t0_c32`, `t`.`terms_conditions_approved_ip` AS `t0_c33`, `t`.`time_before_automated_sfid_cancelation` AS `t0_c34`, `t`.`pay_name` AS `t0_c35`, `t`.`preferred_payment_type` AS `t0_c36`, `t`.`warehouse_address` AS `t0_c37`, `t`.`warehouse_state_id` AS `t0_c38`, `t`.`warehouse_zip_code` AS `t0_c39`, `t`.`warehouse_city_name` AS `t0_c40`, `t`.`pickup_order` AS `t0_c41`, `t`.`restricted_to_lufa` AS `t0_c42`, `t`.`default_shipping_method` AS `t0_c43`, `t`.`default_arrival_time` AS `t0_c44`, `t`.`purchasing_automation_status` AS `t0_c45`, `t`.`purchasing_automation_autonomy_level` AS `t0_c46`, `t`.`address_lat` AS `t0_c47`, `t`.`address_lng` AS `t0_c48`, `t`.`wh_lat` AS `t0_c49`, `t`.`wh_lng` AS `t0_c50`, `t`.`netsuite_vendor_id` AS `t0_c51`, `t`.`netsuite_customer_id` AS `t0_c52`, `t`.`rpc_handling_billing` AS `t0_c53`, `t`.`rpc_handling_fee` AS `t0_c54`, `t`.`rpc_consignment_billing` AS `t0_c55`, `t`.`rpc_consignment_fee` AS `t0_c56`, `t`.`via_3pl` AS `t0_c57`, `t`.`name_3pl` AS `t0_c58`, `t`.`r34_handling_fee` AS `t0_c59`, `i18nSuppliers`.`l_id` AS `t1_c0`, `i18nSuppliers`.`supplier_id` AS `t1_c1`, `i18nSuppliers`.`lang_id` AS `t1_c2`, `i18nSuppliers`.`l_name` AS `t1_c3`, `i18nSuppliers`.`l_description` AS `t1_c4`, `i18nSuppliers`.`l_slug` AS `t1_c5` FROM `suppliers` `t` LEFT OUTER JOIN `suppliersLang` `i18nSuppliers` ON (`i18nSuppliers`.`supplier_id`=`t`.`supplier_id`) AND (i18nSuppliers.lang_id='fr') WHERE (slug = 'getBlogs')
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t ALL 904 10.00 Using where
1 SIMPLE i18nSuppliers ref supplier_id, lang_id supplier_id 4 securelufacom.t.supplier_id 1 100.00 Using where