Explain Query (mysql)
EXPLAIN SELECT `t`.`category_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`weight` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`slug` AS `t0_c4`, `t`.`product_categories_netsuite_id` AS `t0_c5`, `i18nProductCategories`.`l_id` AS `t1_c0`, `i18nProductCategories`.`category_id` AS `t1_c1`, `i18nProductCategories`.`lang_id` AS `t1_c2`, `i18nProductCategories`.`l_name` AS `t1_c3`, `i18nProductCategories`.`l_slug` AS `t1_c4` FROM `product_categories` `t` LEFT OUTER JOIN `productCategoriesLang` `i18nProductCategories` ON (`i18nProductCategories`.`category_id`=`t`.`category_id`) AND (i18nProductCategories.lang_id='fr') WHERE (`t`.`category_id`=270)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | i18nProductCategories | ref | category_id | category_id | 4 | const | 1 | 100.00 | Using where |