Symfony Profiler

WITH
  RECURSIVE tree_view AS (
    SELECT
      id,
      parent_id,
      code,
      name,
      0 AS level,
      customer_id,
      type as entity_type
    FROM
      site
    WHERE
      customer_id IS NOT NULL
      AND parent_id IS NULL
    UNION ALL
    SELECT
      parent.id,
      parent.parent_id,
      parent.code,
      parent.name,
      level + 1 AS level,
      tv.customer_id,
      type as entity_type
    FROM
      site parent
      JOIN tree_view tv ON parent.parent_id = tv.id
  )
SELECT
  c.id,
  c.name,
  c.year,
  t.parent_id,
  t.id as site_id,
  t.name as site_name,
  t.level,
  t.entity_type,
  t.code,
  c.code as code_customer,
  c.reference as reference_customer
FROM
  tree_view t
  right join customer c on t.customer_id = c.id
ORDER BY
  c.name,
  t.parent_id,
  level asc,
  t.name asc;

WITH RECURSIVE tree_view AS (
        
                        SELECT id,
                             parent_id,
                             code,
                             name,
                             0 AS level,
                             customer_id,
                             type  as entity_type
                        FROM site
                        WHERE customer_id IS NOT NULL AND parent_id IS NULL
                         
                         
                    UNION ALL
                     
                        SELECT parent.id,
                    parent.parent_id,
                             parent.code,
                             parent.name,
                             level + 1 AS level,
                    tv.customer_id,
                    type as entity_type
                        FROM site parent
                        JOIN tree_view tv
                          ON parent.parent_id = tv.id 
                    )
                     
                    SELECT
                    c.id, c.name, c.year, t.parent_id, t.id as site_id, t.name as site_name, t.level, t.entity_type, t.code, c.code as code_customer
                    , c.reference as reference_customer
                         
                    FROM tree_view t right join customer c on t.customer_id = c.id  
                    ORDER BY c.name,t.parent_id,level asc, t.name asc;;

"COMMIT"

"COMMIT";

INSERT INTO logs_actions (
  action, route, method, ip_address,
  user_agent, request_data, response_data,
  data_before, data_after, status_code,
  created_at, updated_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO logs_actions (action, route, method, ip_address, user_agent, request_data, response_data, data_before, data_after, status_code, created_at, updated_at, user_id) VALUES ('read', '/api/customers/tree', 'GET', '2c0f:f698:4112:bed9:1c2c:7d0e:b158:4619', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', '{\"method\":\"GET\",\"route\":\"\\/api\\/customers\\/tree\",\"original_route\":null,\"status_code\":200,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/140.0.0.0 Safari\\/537.36\",\"ip_address\":\"2c0f:f698:4112:bed9:1c2c:7d0e:b158:4619\",\"detected_as_delete\":false,\"has_pre_delete_data\":false}', '{\"status_code\":200,\"headers\":{\"content-type\":\"application\\/json; charset=utf-8\",\"cache-control\":\"no-cache, private\"},\"content\":\"[{\\\"id\\\":500,\\\"name\\\":\\\"3X Engineering\\\",\\\"entity_type\\\":\\\"CUSTOMER\\\",\\\"code\\\":\\\"3X Engineerings\\\",\\\"reference\\\":\\\"3X ENGINEERING\\\",\\\"year\\\":\\\"\\\",\\\"childrens\\\":[{\\\"id\\\":500,\\\"name\\\":\\\"3X Engineering\\\",\\\"site_name\\\":\\\"entity 1\\\",\\\"site_id\\\":43180,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"entity\\\",\\\"code\\\":\\\"entity 1\\\",\\\"childrens\\\":[{\\\"id\\\":500,\\\"name\\\":\\\"3X Engineering\\\",\\\"site_name\\\":\\\"site 1\\\",\\\"site_id\\\":43181,\\\"parent_id\\\":43180,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"site 1\\\"}]}]},{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"entity_type\\\":\\\"CUSTOMER\\\",\\\"code\\\":\\\"ACTIVE-FOOD\\\",\\\"reference\\\":\\\"ACTIVE-FOOD\\\",\\\"year\\\":\\\"\\\",\\\"childrens\\\":[{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"Environnement \\\",\\\"site_id\\\":42712,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"entity\\\",\\\"code\\\":\\\"ACTIVE-FOOD - Env\\\",\\\"childrens\\\":[{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"Env - Autres Exigences \\\",\\\"site_id\\\":42716,\\\"parent_id\\\":42712,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ACTIVE-FOOD - Env - Autres Exigences \\\"},{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"Env - Droit Cantonal \\\",\\\"site_id\\\":42714,\\\"parent_id\\\":42712,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ACTIVE-FOOD - Env - Droit Cantonal \\\"},{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"Env - Droit F\\\\u00e9d\\\\u00e9ral\\\",\\\"site_id\\\":42715,\\\"parent_id\\\":42712,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ACTIVE-FOOD - Env - Droit F\\\\u00e9d\\\\u00e9ral\\\"}]},{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"Hygi\\\\u00e8ne & S\\\\u00e9curit\\\\u00e9\\\",\\\"site_id\\\":42713,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"entity\\\",\\\"code\\\":\\\"ACTIVE-FOOD - H&S\\\",\\\"childrens\\\":[{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"H&S - Autres Exigences \\\",\\\"site_id\\\":42719,\\\"parent_id\\\":42713,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ACTIVE-FOOD - H&S - Autres Exigences \\\"},{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"H&S - Droit Cantonal \\\",\\\"site_id\\\":42718,\\\"parent_id\\\":42713,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ACTIVE-FOOD - H&S - Droit Cantonal \\\"},{\\\"id\\\":487,\\\"name\\\":\\\"ACTIVE-FOOD\\\",\\\"site_name\\\":\\\"H&S - Droit F\\\\u00e9d\\\\u00e9ral\\\",\\\"site_id\\\":42717,\\\"parent_id\\\":42713,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ACTIVE-FOOD - H&S - Droit F\\\\u00e9d\\\\u00e9ral \\\"}]}]},{\\\"id\\\":441,\\\"name\\\":\\\"AD FINE\\\",\\\"entity_type\\\":\\\"CUSTOMER\\\",\\\"code\\\":\\\"ADF\\\",\\\"reference\\\":\\\"AD FINE\\\",\\\"year\\\":\\\"\\\",\\\"childrens\\\":[{\\\"id\\\":441,\\\"name\\\":\\\"AD FINE\\\",\\\"site_name\\\":\\\"AD FINE - Energie\\\",\\\"site_id\\\":42498,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ADF.1\\\"}]},{\\\"id\\\":293,\\\"name\\\":\\\"AECOM\\\",\\\"entity_type\\\":\\\"CUSTOMER\\\",\\\"code\\\":\\\"AECOM\\\",\\\"reference\\\":\\\"AECOM\\\",\\\"year\\\":\\\"\\\",\\\"childrens\\\":[{\\\"id\\\":293,\\\"name\\\":\\\"AECOM\\\",\\\"site_name\\\":\\\"ENV\\\",\\\"site_id\\\":38279,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"ENV\\\"},{\\\"id\\\":293,\\\"name\\\":\\\"AECOM\\\",\\\"site_name\\\":\\\"SEC\\\",\\\"site_id\\\":38280,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"SEC\\\"}]},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"entity_type\\\":\\\"CUSTOMER\\\",\\\"code\\\":\\\"AEROPORTS DE LYON\\\",\\\"reference\\\":\\\"AEROPORTS DE LYON\\\",\\\"year\\\":3,\\\"childrens\\\":[{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"Base Commune S\\\\u00e9curit\\\\u00e9\\\",\\\"site_id\\\":38281,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base commune S\\\\u00e9curit\\\\u00e9\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYON-BRON\\\",\\\"site_id\\\":38282,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"entity\\\",\\\"code\\\":\\\"LYON-BRON\\\",\\\"childrens\\\":[{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - Environnement\\\",\\\"site_id\\\":38284,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base Environnement\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - ERP\\\",\\\"site_id\\\":38283,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base ERP\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - S\\\\u00e9curit\\\\u00e9\\\",\\\"site_id\\\":38286,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base S\\\\u00e9curit\\\\u00e9\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - S\\\\u00e9curit\\\\u00e9 a\\\\u00e9ronautique\\\",\\\"site_id\\\":38288,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base S\\\\u00e9curit\\\\u00e9 a\\\\u00e9ronautique\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - S\\\\u00e9curit\\\\u00e9 Publique\\\",\\\"site_id\\\":38287,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base S\\\\u00e9curit\\\\u00e9 Publique\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - S\\\\u00fbret\\\\u00e9 transport a\\\\u00e9rien\\\",\\\"site_id\\\":38289,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base S\\\\u00fbret\\\\u00e9 transport a\\\\u00e9rien\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - Syst\\\\u00e8me d\'information et Donn\\\\u00e9es personnelles\\\",\\\"site_id\\\":38285,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base Syst\\\\u00e8me d_information et Donn\\\\u00e9es personnelles\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - Urbanisme et Construction\\\",\\\"site_id\\\":38290,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base Urbanisme et Construction\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYN - Voirie routi\\\\u00e8re\\\",\\\"site_id\\\":38291,\\\"parent_id\\\":38282,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base Voirie routi\\\\u00e8re\\\"}]},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYON-SAINT-EXUPERY\\\",\\\"site_id\\\":38292,\\\"parent_id\\\":null,\\\"entity_type\\\":\\\"entity\\\",\\\"code\\\":\\\"LYON-SAINT-EXUPERY\\\",\\\"childrens\\\":[{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYS - Environnement\\\",\\\"site_id\\\":38294,\\\"parent_id\\\":38292,\\\"entity_type\\\":\\\"site\\\",\\\"code\\\":\\\"Base Environnement\\\"},{\\\"id\\\":294,\\\"name\\\":\\\"AEROPORTS DE LYON\\\",\\\"site_name\\\":\\\"LYS - ERP\\\",\\\"site_id\\\":38293,... [truncated]\",\"content_truncated\":true,\"original_content_length\":707297}', '[]', '[]', 200, '2025-09-16 13:37:30', '2025-09-16 13:37:30', 47);

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.department AS department_4,
  t0.position AS position_5,
  t0.email AS email_6,
  t0.password AS password_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.website AS website_10,
  t0.roles AS roles_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_created_at AS activation_token_created_at_13,
  t0.is_enabled AS is_enabled_14,
  t0.expire_at AS expire_at_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.application_master AS application_master_18,
  t0.lang AS lang_19,
  t0.customer_associated AS customer_associated_20,
  t0.hide_in_pa AS hide_in_pa_21,
  t0.is_hotline AS is_hotline_22,
  t0.locked_at AS locked_at_23,
  t0.attempts AS attempts_24,
  t0.customer_id AS customer_id_25,
  t0.profile_picture_id AS profile_picture_id_26
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.department AS department_4, t0.position AS position_5, t0.email AS email_6, t0.password AS password_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.roles AS roles_11, t0.activation_token AS activation_token_12, t0.activation_token_created_at AS activation_token_created_at_13, t0.is_enabled AS is_enabled_14, t0.expire_at AS expire_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.application_master AS application_master_18, t0.lang AS lang_19, t0.customer_associated  AS customer_associated_20, t0.hide_in_pa AS hide_in_pa_21, t0.is_hotline AS is_hotline_22, t0.locked_at AS locked_at_23, t0.attempts AS attempts_24, t0.customer_id AS customer_id_25, t0.profile_picture_id AS profile_picture_id_26 FROM user t0 WHERE t0.id = 47;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.department AS department_4,
  t0.position AS position_5,
  t0.email AS email_6,
  t0.password AS password_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.website AS website_10,
  t0.roles AS roles_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_created_at AS activation_token_created_at_13,
  t0.is_enabled AS is_enabled_14,
  t0.expire_at AS expire_at_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.application_master AS application_master_18,
  t0.lang AS lang_19,
  t0.customer_associated AS customer_associated_20,
  t0.hide_in_pa AS hide_in_pa_21,
  t0.is_hotline AS is_hotline_22,
  t0.locked_at AS locked_at_23,
  t0.attempts AS attempts_24,
  t0.customer_id AS customer_id_25,
  t0.profile_picture_id AS profile_picture_id_26
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.department AS department_4, t0.position AS position_5, t0.email AS email_6, t0.password AS password_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.roles AS roles_11, t0.activation_token AS activation_token_12, t0.activation_token_created_at AS activation_token_created_at_13, t0.is_enabled AS is_enabled_14, t0.expire_at AS expire_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.application_master AS application_master_18, t0.lang AS lang_19, t0.customer_associated  AS customer_associated_20, t0.hide_in_pa AS hide_in_pa_21, t0.is_hotline AS is_hotline_22, t0.locked_at AS locked_at_23, t0.attempts AS attempts_24, t0.customer_id AS customer_id_25, t0.profile_picture_id AS profile_picture_id_26 FROM user t0 WHERE t0.email = 'hajer.benothmen@groupe-novallia.com' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";