SQL-query
SQL-query: 
EXPLAIN SELECT *
FROM db_items a
LEFT JOIN db_item_icons b ON a.display_id = b.icon_id
LEFT JOIN db_item_classes c ON a.class_id = c.class_id
LEFT JOIN db_item_subclasses d ON a.subclass_id = d.subclass_id
AND a.class_id = d.class_id
 [Edit] [Skip Explain SQL] [Create PHP Code]



id 	select_type 	table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
1 	SIMPLE 	a 	ALL 	NULL 	NULL 	NULL 	NULL 	54734 	 
1 	SIMPLE 	b 	ref 	icon_id 	icon_id 	4 	wowguru_db.a.display_id 	4 	 
1 	SIMPLE 	c 	ref 	class_id 	class_id 	4 	wowguru_db.a.class_id 	4 	 
1 	SIMPLE 	d 	ref 	class_id,subclass_id 	subclass_id 	4 	wowguru_db.a.subclass_id 	11