Explain Query (mysql)
EXPLAIN SELECT `blog`.`blog_id`, `blog`.`image_url`, `blog`.`blog_category_id`, `blog`.`created`, `blog`.`updated`, `blog`.`title`, `blog`.`body`, `blog`.`recipe_preparation_time`, `blog`.`recipe_total_time`, `blog`.`recipe_serves`, `blog`.`recipe_ingredients_left`, `blog`.`recipe_ingredients_right`, `blog`.`recipe_directions`, `blog`.`slug`
FROM `blog`
WHERE created>"2014-06-06" and (status=1 AND (publish_datetime IS NULL OR publish_datetime <= NOW()))
ORDER BY `created` DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | blog | ALL | 384 | 1.33 | Using where; Using filesort |