Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• PHPCR
• Debug
• Emails
• Serializer
• JMS Serializer 0
• Sulu
• Configuration

Query Metrics

SELECT 1 FROM phpcr_workspaces WHERE name = ?

[
  "default_live"
]

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 prefix, uri FROM phpcr_namespaces;

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

[
  "/cmf/theatremagique/routes/en/config"
  "default_live"
]

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

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/theatremagique/routes/en/config'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

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

[
  "/config"
  "en"
]

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

SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = '/config' AND r0_.locale = 'en';