All pastes #927927 Raw Edit

Untitled

public text v1 · immutable
·published 2008-03-04 17:22 UTC
rendered paste body
+----+--------------------+-------------+----------------+------------------------+------------------------+---------+------+------+--------------------------+
| id | select_type        | table       | type           | possible_keys          | key                    | key_len | ref  | rows | Extra                    |
+----+--------------------+-------------+----------------+------------------------+------------------------+---------+------+------+--------------------------+
|  1 | PRIMARY            | faunusEntry | index          | NULL                   | faunusEntry_name       | 767     | NULL |  226 | Using where; Using index | 
|  3 | DEPENDENT SUBQUERY | entryTag    | index_subquery | entryTag_faunusEntryId | entryTag_faunusEntryId | 4       | func |    1 | Using index; Using where | 
|  2 | DEPENDENT SUBQUERY | entryTag    | index_subquery | entryTag_faunusEntryId | entryTag_faunusEntryId | 4       | func |    1 | Using index; Using where | 
+----+--------------------+-------------+----------------+------------------------+------------------------+---------+------+------+--------------------------+