RAM = 4.47 MO 
TIME = 0.1102

REQUEST NOT IN CACHE
SELECT modules_flat.*, REPLACE(modules_flat.label, "module_", "") AS database_table_clean, NULL AS default_value , entity_id AS attribute_id , modules_entities.id, modules_entities.pid as pid, modules_entities.label as entity_label, modules_entities.level as level, modules_entities.website as website_id, modules_entities.order_left, modules_entities.order_right, modules_entities.parent, modules_entities.website, modules_entities.creation_date, modules_entities.update_date, modules_entities.undeletable, modules_entities.unupdatable FROM modules_flat RIGHT JOIN modules_entities ON modules_flat.entity_id = modules_entities.id WHERE view = 2
 UNION SELECT website_modules_flat.*, REPLACE(website_modules_flat.label, "module_", "") AS database_table_clean, NULL AS default_value , entity_id AS attribute_id , modules_entities.id, modules_entities.pid as pid, modules_entities.label as entity_label, modules_entities.level as level, modules_entities.website as website_id, modules_entities.order_left, modules_entities.order_right, modules_entities.parent, modules_entities.website, modules_entities.creation_date, modules_entities.update_date, modules_entities.undeletable, modules_entities.unupdatable FROM website_modules_flat RIGHT JOIN modules_entities ON website_modules_flat.entity_id = modules_entities.id WHERE view = 2
 ORDER BY  order_left ASC

RAM = 32.26 MO 
TIME = 0.2478