Explain Query (mysql)
EXPLAIN SELECT `t`.`blog_category_id` AS `t0_c0`, `t`.`parent_category_id` AS `t0_c1`, `t`.`slug` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`body` AS `t0_c4`, `t`.`weight` AS `t0_c5`, `t`.`status` AS `t0_c6`, `t`.`created` AS `t0_c7`, `t`.`updated` AS `t0_c8`, `t`.`user_id` AS `t0_c9`, `i18nBlogCategory`.`l_id` AS `t1_c0`, `i18nBlogCategory`.`blog_category_id` AS `t1_c1`, `i18nBlogCategory`.`lang_id` AS `t1_c2`, `i18nBlogCategory`.`l_slug` AS `t1_c3`, `i18nBlogCategory`.`l_title` AS `t1_c4`, `i18nBlogCategory`.`l_body` AS `t1_c5`, `multilangBlogCategory`.`l_id` AS `t2_c0`, `multilangBlogCategory`.`blog_category_id` AS `t2_c1`, `multilangBlogCategory`.`lang_id` AS `t2_c2`, `multilangBlogCategory`.`l_slug` AS `t2_c3`, `multilangBlogCategory`.`l_title` AS `t2_c4`, `multilangBlogCategory`.`l_body` AS `t2_c5` FROM `blog_category` `t` LEFT OUTER JOIN `blog_categoryLang` `i18nBlogCategory` ON (`i18nBlogCategory`.`blog_category_id`=`t`.`blog_category_id`) AND (i18nBlogCategory.lang_id='en') LEFT OUTER JOIN `blog_categoryLang` `multilangBlogCategory` ON (`multilangBlogCategory`.`blog_category_id`=`t`.`blog_category_id`) WHERE (i18nBlogCategory.l_slug = '"')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | i18nBlogCategory | ALL | 11 | 9.09 | Using where | |||||
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.i18nBlogCategory.blog_category_id | 1 | 100.00 | ||
| 1 | SIMPLE | multilangBlogCategory | ALL | 11 | 100.00 | Using where; Using join buffer (hash join) |