Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- describe SELECT * FROM `sketches` WHERE (user_id IS NOT NULL) AND (sketches.deleted_at IS NULL OR sketches.deleted_at > '2009-05-08 18:58:11') ORDER BY created_at DESC LIMIT 16;
- +----+-------------+----------+-------+---------------------------+---------------------------+---------+------+-------+-----------------------------+
- | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
- +----+-------------+----------+-------+---------------------------+---------------------------+---------+------+-------+-----------------------------+
- | 1 | SIMPLE | sketches | range | index_sketches_on_user_id | index_sketches_on_user_id | 5 | NULL | 13662 | Using where; Using filesort |
- +----+-------------+----------+-------+---------------------------+---------------------------+---------+------+-------+-----------------------------+
- 1 row in set (0.00 sec)
- 16 rows in set (4.45 sec)
Add Comment
Please, Sign In to add comment