WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #16706, comment 6


Ignore:
Timestamp:
03/01/2011 02:07:00 AM (11 years ago)
Author:
scribu
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #16706, comment 6

    initial v1  
    2424|| SIMPLE || wp_term_relationships || ref || PRIMARY,term_taxonomy_id || term_taxonomy_id || 8 || const || 1 || Using temporary; Using filesort ||
    2525|| SIMPLE || tt1 || eq_ref || PRIMARY,term_taxonomy_id || PRIMARY || 16 || wp-trunk.wp_term_relationships.object_id,const || 1 || Using index ||
    26 || SIMPLE || wp_posts || eq_ref || PRIMARY,type_status_date || PRIMARY || 8 || wp-trunk.wp_term_relationships.object_id
     26|| SIMPLE || wp_posts || eq_ref || PRIMARY,type_status_date || PRIMARY || 8 || wp-trunk.wp_term_relationships.object_id || 1 || Using where
    2727
    2828So, it's just a matter of making the {{{'category__and'}}} rewrite internally to that more efficient way.