Back

SQL Explained

Executed SQL
SELECT `main_news`.`id`, `main_news`.`title`, `main_news`.`slug`, `main_news`.`body`, `main_news`.`status`, `main_news`.`allow_comments`, `main_news`.`publish`, `main_news`.`created`, `main_news`.`modified` FROM `main_news` WHERE (`main_news`.`publish` <= 2017-06-19 05:37:06 AND `main_news`.`status` >= 2 ) ORDER BY `main_news`.`publish` DESC LIMIT 2
Time
75.37 ms
ID SELECT_TYPE TABLE TYPE POSSIBLE_KEYS KEY KEY_LEN REF ROWS EXTRA
1 SIMPLE main_news ALL None None None None 5 Using where; Using filesort