SHARE
TWEET

Untitled

a guest Aug 26th, 2017 441 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> EXPLAIN SELECT  SQL_CALC_FOUND_ROWS wp_posts.ID
  2.     ->     FROM  wp_posts
  3.     ->     LEFT JOIN  wp_term_relationships
  4.     ->         ON (wp_posts.ID = wp_term_relationships.object_id)
  5.     ->     WHERE  1=1
  6.     ->       AND  ( wp_term_relationships.term_taxonomy_id IN (3) )
  7.     ->       AND  wp_posts.post_type = 'post'
  8.     ->       AND  ((wp_posts.post_status = 'publish'))
  9.     ->     GROUP BY  wp_posts.ID
  10.     ->     ORDER BY  wp_posts.post_date DESC
  11.     ->     LIMIT  0, 6;
  12. +----+-------------+-----------------------+----------------------+--------+---------------------------------------------------------------------------------+----------------------+---------+-------------------------------------+-------+----------+-----------------------------------------------------------+
  13. | id | select_type | table                 | partitions           | type   | possible_keys                                                                   | key                  | key_len | ref                                 | rows  | filtered | Extra                                                     |
  14. +----+-------------+-----------------------+----------------------+--------+---------------------------------------------------------------------------------+----------------------+---------+-------------------------------------+-------+----------+-----------------------------------------------------------+
  15. |  1 | SIMPLE      | wp_posts              | NULL                 | ref    | PRIMARY,post_name,type_status_date,post_parent,post_author,type_status_date_ndx | type_status_date_ndx | 164     | const,const                         | 39756 |   100.00 | Using where; Using index; Using temporary; Using filesort |
  16. |  1 | SIMPLE      | wp_term_relationships | p0,p1,p2,p3,p4,p5,p6 | eq_ref | PRIMARY,term_taxonomy_id                                                        | PRIMARY              | 16      | xxxx.wp_posts.ID,const |     1 |   100.00 | Using index                                               |
  17. +----+-------------+-----------------------+----------------------+--------+---------------------------------------------------------------------------------+----------------------+---------+-------------------------------------+-------+----------+-----------------------------------------------------------+
  18. 2 rows in set, 1 warning (0.00 sec)
  19.  
  20. mysql> EXPLAIN SELECT  SQL_CALC_FOUND_ROWS wp_posts.ID
  21.     ->     FROM  wp_posts
  22.     ->     WHERE  wp_posts.post_type = 'post'
  23.     ->       AND  wp_posts.post_status = 'publish'
  24.     ->     ORDER BY  wp_posts.post_date DESC
  25.     ->     LIMIT  0, 6;
  26. +----+-------------+----------+------------+------+---------------------------------------+----------------------+---------+-------------+-------+----------+--------------------------+
  27. | id | select_type | table    | partitions | type | possible_keys                         | key                  | key_len | ref         | rows  | filtered | Extra                    |
  28. +----+-------------+----------+------------+------+---------------------------------------+----------------------+---------+-------------+-------+----------+--------------------------+
  29. |  1 | SIMPLE      | wp_posts | NULL       | ref  | type_status_date,type_status_date_ndx | type_status_date_ndx | 164     | const,const | 39756 |   100.00 | Using where; Using index |
  30. +----+-------------+----------+------------+------+---------------------------------------+----------------------+---------+-------------+-------+----------+--------------------------+
  31. 1 row in set, 1 warning (0.00 sec)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top