RAM = 4.47 MO 
TIME = 0.1133
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 order_left ASC 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


PDO FAILURE SQL METHOD CALLER: suppliers\coding\php\oop\patterns\repositories\repository_modules\Repository_modules_class_do::set_get
PDO FAILURE SQL LINE CALLER: 174
PDO FAILURE MESSAGE: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT modules_flat.*, 1 AS sort_group, REPLACE(modules_flat.label, "module_"...' at line 4
PDO FAILURE ERRORINFO: 42000 / 1064 / You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT modules_flat.*, 1 AS sort_group, REPLACE(modules_flat.label, "module_"...' at line 4
PDO FAILURE SQL STRING:

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 order_left ASC 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