Symfony Profiler

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/main-website/routes/fr/reset-password'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  s0_.path AS path_0,
  s0_.locale AS locale_1,
  s0_.entity_class AS entity_class_2,
  s0_.entity_id AS entity_id_3,
  s0_.history AS history_4,
  s0_.id AS id_5,
  s0_.created AS created_6,
  s0_.changed AS changed_7,
  s1_.path AS path_8,
  s1_.locale AS locale_9,
  s1_.entity_class AS entity_class_10,
  s1_.entity_id AS entity_id_11,
  s1_.history AS history_12,
  s1_.id AS id_13,
  s1_.created AS created_14,
  s1_.changed AS changed_15,
  s0_.target_id AS target_id_16,
  s0_.idUsersCreator AS idUsersCreator_17,
  s0_.idUsersChanger AS idUsersChanger_18,
  s1_.target_id AS target_id_19,
  s1_.idUsersCreator AS idUsersCreator_20,
  s1_.idUsersChanger AS idUsersChanger_21
FROM
  sulu_ro_routes s0_
  LEFT JOIN sulu_ro_routes s1_ ON s0_.target_id = s1_.id
WHERE
  s0_.path = ?
  AND s0_.locale = ?

SELECT s0_.path AS path_0, s0_.locale AS locale_1, s0_.entity_class AS entity_class_2, s0_.entity_id AS entity_id_3, s0_.history AS history_4, s0_.id AS id_5, s0_.created AS created_6, s0_.changed AS changed_7, s1_.path AS path_8, s1_.locale AS locale_9, s1_.entity_class AS entity_class_10, s1_.entity_id AS entity_id_11, s1_.history AS history_12, s1_.id AS id_13, s1_.created AS created_14, s1_.changed AS changed_15, s0_.target_id AS target_id_16, s0_.idUsersCreator AS idUsersCreator_17, s0_.idUsersChanger AS idUsersChanger_18, s1_.target_id AS target_id_19, s1_.idUsersCreator AS idUsersCreator_20, s1_.idUsersChanger AS idUsersChanger_21 FROM sulu_ro_routes s0_ LEFT JOIN sulu_ro_routes s1_ ON s0_.target_id = s1_.id WHERE s0_.path = '/reset-password' AND s0_.locale = 'fr';

SELECT
  s0_.enabled AS enabled_0,
  s0_.statusCode AS statusCode_1,
  s0_.source AS source_2,
  s0_.sourceHost AS sourceHost_3,
  s0_.target AS target_4,
  s0_.id AS id_5,
  s0_.created AS created_6,
  s0_.changed AS changed_7,
  s0_.idUsersCreator AS idUsersCreator_8,
  s0_.idUsersChanger AS idUsersChanger_9
FROM
  sulu_re_redirect_routes s0_
WHERE
  s0_.source = ?
  AND (
    s0_.sourceHost = ?
    OR s0_.sourceHost = ''
    OR s0_.sourceHost IS NULL
  )
  AND s0_.enabled = 1
ORDER BY
  s0_.sourceHost DESC
LIMIT
  1

SELECT s0_.enabled AS enabled_0, s0_.statusCode AS statusCode_1, s0_.source AS source_2, s0_.sourceHost AS sourceHost_3, s0_.target AS target_4, s0_.id AS id_5, s0_.created AS created_6, s0_.changed AS changed_7, s0_.idUsersCreator AS idUsersCreator_8, s0_.idUsersChanger AS idUsersChanger_9 FROM sulu_re_redirect_routes s0_ WHERE s0_.source = '/reset-password' AND (s0_.sourceHost = 'finance.preprod-croisiland.dev' OR s0_.sourceHost = '' OR s0_.sourceHost IS NULL) AND s0_.enabled = 1 ORDER BY s0_.sourceHost DESC LIMIT 1;