Guest User

Untitled

a guest
Jun 23rd, 2018
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. 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;
  2.  
  3. +----+-------------+----------+-------+---------------------------+---------------------------+---------+------+-------+-----------------------------+
  4. | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
  5. +----+-------------+----------+-------+---------------------------+---------------------------+---------+------+-------+-----------------------------+
  6. | 1 | SIMPLE | sketches | range | index_sketches_on_user_id | index_sketches_on_user_id | 5 | NULL | 13662 | Using where; Using filesort |
  7. +----+-------------+----------+-------+---------------------------+---------------------------+---------+------+-------+-----------------------------+
  8. 1 row in set (0.00 sec)
  9.  
  10.  
  11. 16 rows in set (4.45 sec)
Add Comment
Please, Sign In to add comment