Yii Debugger
1.1.25
PHP 8.0.30
Status 200
Action SiteController::actionPress()
Log 59
Time 1,422 ms
Memory 3.3 MB
DB 32 1,371 ms

Explain Query (mysql)

EXPLAIN SELECT `t`.`blog_id` AS `t0_c0`, `i18nBlog`.`l_id` AS `t1_c0`, `i18nBlog`.`blog_id` AS `t1_c1`, `i18nBlog`.`lang_id` AS `t1_c2`, `i18nBlog`.`l_slug` AS `t1_c3`, `i18nBlog`.`l_title` AS `t1_c4`, `i18nBlog`.`l_body` AS `t1_c5`, `i18nBlog`.`l_recipe_preparation_time` AS `t1_c6`, `i18nBlog`.`l_recipe_total_time` AS `t1_c7`, `i18nBlog`.`l_recipe_serves` AS `t1_c8`, `i18nBlog`.`l_recipe_ingredients_left` AS `t1_c9`, `i18nBlog`.`l_recipe_ingredients_right` AS `t1_c10`, `i18nBlog`.`l_recipe_directions` AS `t1_c11`, `i18nBlog`.`l_meta_title` AS `t1_c12`, `i18nBlog`.`l_meta_desc` AS `t1_c13` FROM `blog` `t` LEFT OUTER JOIN `blogLang` `i18nBlog` ON (`i18nBlog`.`blog_id`=`t`.`blog_id`) AND (i18nBlog.lang_id='fr') WHERE (`t`.`blog_id` IN (585, 584, 583, 582))
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t range PRIMARY PRIMARY 4 4 100.00 Using where; Using index
1 SIMPLE i18nBlog ALL 307 100.00 Using where; Using join buffer (hash join)