I have this query:
SELECT
guild_areas.name,
guild_areas.show_name,
guild_areas.description,
guild_areas.area_id,
guild_area_config.guild_id,
guild_area_config.active
FROM
guild_area_config
Join
guild_areas ON guild_area_config.area_id = guild_areas.area_id
and guild_areas.show_content_option = 0
and guild_area_config.guild_id = 35290
and guild_areas.show_content_option=0
order by
guild_areas.area_id;
Which shows this EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE guild_areas index PRIMARY,idx_covering PRIMARY 1 NULL 16 Using where 1 SIMPLE guild_area_config eq_ref PRIMARY,idx_guild,idx_area PRIMARY 5 guild_areas.area_id,const 1
Incidentally, the query returns 9 rows. guild_areas should only match once per row in guild_are_config, so the 16 is already a bit of an oddity.
describe guild_areas; shows this
Field Type Null Key Default Extra area_id tinyint(4) NO PRI NULL auto_increment name varchar(25) NO MUL show_name varchar(50) YES NULL description varchar(200) YES NULL show_auth tinyint(1) NO show_content_option tinyint(1) NO 0 is_admin_auth tinyint(4) NO 0 is_widget tinyint(4) NO 0
describe guild_area_config; shows this
Field Type Null Key Default Extra guild_id int(11) NO PRI area_id tinyint(4) NO PRI active binary(255) NO
Anyone have any idea why this query shows up in the LOG_QUERIES_WITHOUT_INDEX log? The explain seems to show it using indexes.