mysql queries indexes prob ?

explain SELECT cscart_quick_menu.*, cscart_common_descriptions.description AS name FROM cscart_quick_menu LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_quick_menu.menu_id AND cscart_common_descriptions.object_holder = 'quick_menu' AND cscart_common_descriptions.lang_code = 'EN' WHERE cscart_quick_menu.user_id = 1 ORDER BY cscart_quick_menu.parent_id, cscart_quick_menu.position



this one gives something like null index/keys




EXPLAIN SELECT cscart_categories.category_id, cscart_categories.parent_id, cscart_categories.id_path, cscart_category_descriptions.category, cscart_categories.position, cscart_categories.status, cscart_categories.product_count, cscart_seo_names.name AS seo_name
FROM cscart_categories
LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id
AND cscart_category_descriptions.lang_code = 'EN'
LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id
AND cscart_seo_names.type = 'c'
AND cscart_seo_names.dispatch = ''
AND cscart_seo_names.lang_code = 'EN'
WHERE 1
ORDER BY cscart_categories.position ASC , cscart_category_descriptions.category ASC




RESULT Using temporary; Using filesort