Re: Help with explain query and code 1003

[Rick James]

1003 is simply the code EXPLAIN EXTENDED.

18000 rows takes time to scan through.

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G
* SHOW TABLE STATUS LIKE 'tbl'\G
* EXPLAIN SELECT ...\G
and surround them with [ code ] and [ / code ]
Maybe something can be improved.

SELECT  COUNT(*)
    FROM  wp_term_relationships, wp_posts
    WHERE  wp_posts.ID = wp_term_relationships.object_id
      AND  post_status = 'publish'
      AND  post_type = 'post'
      AND  term_taxonomy_id = 1