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