id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	item	NULL	ref	index_nav_id,index_lang_id	index_lang_id	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	nav	NULL	eq_ref	PRIMARY	PRIMARY	4	jolliotpmntest.item.nav_id	1	50.00	Using where
1	SIMPLE	nav_container	NULL	eq_ref	PRIMARY	PRIMARY	4	jolliotpmntest.nav.nav_container_id	1	100.00	NULL