RAM = 4.47 MO 
TIME = 0.1108

REQUEST NOT IN CACHE
SELECT modules_flat.*, 1 AS sort_group, REPLACE(modules_flat.label, "module_", "") AS module_database_table, 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.*, 2 AS sort_group, REPLACE(website_modules_flat.label, "module_", "") AS module_database_table, NULL AS default_value , entity_id AS attribute_id , website_modules_entities.id, website_modules_entities.pid as pid, website_modules_entities.label as entity_label, website_modules_entities.level as level, website_modules_entities.website as website_id, website_modules_entities.order_left, website_modules_entities.order_right, website_modules_entities.parent, website_modules_entities.website, website_modules_entities.creation_date, website_modules_entities.update_date, website_modules_entities.undeletable, website_modules_entities.unupdatable FROM website_modules_flat RIGHT JOIN website_modules_entities ON website_modules_flat.entity_id = website_modules_entities.id WHERE view = 2
 ORDER BY  sort_group ASC, order_left ASC

RAM = 39.98 MO 
TIME = 0.2866