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
```<br />
<br />
this one gives something like null index/keys<br />
<br />
```php
<br />
<br />
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<br />
FROM cscart_categories<br />
LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id<br />
AND cscart_category_descriptions.lang_code = 'EN'<br />
LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id<br />
AND cscart_seo_names.type = 'c'<br />
AND cscart_seo_names.dispatch = ''<br />
AND cscart_seo_names.lang_code = 'EN'<br />
WHERE 1<br />
ORDER BY cscart_categories.position ASC , cscart_category_descriptions.category ASC
```<br />
<br />
RESULT Using temporary; Using filesort