Changes between Initial Version and Version 1 of Ticket #16706, comment 6
- Timestamp:
- 03/01/2011 02:07:00 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #16706, comment 6
initial v1 24 24 || SIMPLE || wp_term_relationships || ref || PRIMARY,term_taxonomy_id || term_taxonomy_id || 8 || const || 1 || Using temporary; Using filesort || 25 25 || 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 27 27 28 28 So, it's just a matter of making the {{{'category__and'}}} rewrite internally to that more efficient way.