Symfony Profiler

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

Query Metrics

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

[
  "/manager/media/script/mootools/mootools"
  "barbara.teamsante.at"
]

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

SELECT r0_.enabled AS enabled_0, r0_.statusCode AS statusCode_1, r0_.source AS source_2, r0_.sourceHost AS sourceHost_3, r0_.target AS target_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r0_.idUsersCreator AS idUsersCreator_8, r0_.idUsersChanger AS idUsersChanger_9 FROM re_redirect_routes r0_ WHERE r0_.source = '/manager/media/script/mootools/mootools' AND (r0_.sourceHost = 'barbara.teamsante.at' OR r0_.sourceHost = '' OR r0_.sourceHost IS NULL) AND r0_.enabled = 1 ORDER BY r0_.sourceHost DESC LIMIT 1;

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/teamsante/routes/de/manager/media/script/mootools/mootools"
  "default_live"
]

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

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/teamsante/routes/de/manager/media/script/mootools/mootools'
                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 = ?

[
  "/manager/media/script/mootools/mootools"
  "de"
]

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 = '/manager/media/script/mootools/mootools' AND r0_.locale = 'de';

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

[
  "/de/manager/media/script/mootools/mootools"
  "barbara.teamsante.at"
]

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

SELECT r0_.enabled AS enabled_0, r0_.statusCode AS statusCode_1, r0_.source AS source_2, r0_.sourceHost AS sourceHost_3, r0_.target AS target_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r0_.idUsersCreator AS idUsersCreator_8, r0_.idUsersChanger AS idUsersChanger_9 FROM re_redirect_routes r0_ WHERE r0_.source = '/de/manager/media/script/mootools/mootools' AND (r0_.sourceHost = 'barbara.teamsante.at' OR r0_.sourceHost = '' OR r0_.sourceHost IS NULL) AND r0_.enabled = 1 ORDER BY r0_.sourceHost DESC LIMIT 1;

SELECT a0_.title AS title_0, a0_.description AS description_1, a0_.priority AS priority_2, a0_.allWebspaces AS allWebspaces_3, a0_.active AS active_4, a0_.id AS id_5, a1_.title AS title_6, a1_.frequency AS frequency_7, a1_.id AS id_8, a2_.`type` AS type_9, a2_.`condition` AS condition_10, a2_.id AS id_11, a1_.idTargetGroups AS idTargetGroups_12, a2_.idTargetGroupRules AS idTargetGroupRules_13 FROM at_target_groups a0_ INNER JOIN at_target_group_rules a1_ ON a0_.id = a1_.idTargetGroups INNER JOIN at_target_group_conditions a2_ ON a1_.id = a2_.idTargetGroupRules LEFT JOIN at_target_group_webspaces a3_ ON a0_.id = a3_.idTargetGroups WHERE a0_.active = 1 AND ((a0_.allWebspaces = 1 OR a3_.webspaceKey = ?)) AND a1_.frequency <= ? ORDER BY a0_.priority DESC

[
  "teamsante"
  3
]

SELECT
  a0_.title AS title_0,
  a0_.description AS description_1,
  a0_.priority AS priority_2,
  a0_.allWebspaces AS allWebspaces_3,
  a0_.active AS active_4,
  a0_.id AS id_5,
  a1_.title AS title_6,
  a1_.frequency AS frequency_7,
  a1_.id AS id_8,
  a2_.`type` AS type_9,
  a2_.`condition` AS condition_10,
  a2_.id AS id_11,
  a1_.idTargetGroups AS idTargetGroups_12,
  a2_.idTargetGroupRules AS idTargetGroupRules_13
FROM
  at_target_groups a0_
  INNER JOIN at_target_group_rules a1_ ON a0_.id = a1_.idTargetGroups
  INNER JOIN at_target_group_conditions a2_ ON a1_.id = a2_.idTargetGroupRules
  LEFT JOIN at_target_group_webspaces a3_ ON a0_.id = a3_.idTargetGroups
WHERE
  a0_.active = 1
  AND (
    (
      a0_.allWebspaces = 1
      OR a3_.webspaceKey = ?
    )
  )
  AND a1_.frequency <= ?
ORDER BY
  a0_.priority DESC

SELECT a0_.title AS title_0, a0_.description AS description_1, a0_.priority AS priority_2, a0_.allWebspaces AS allWebspaces_3, a0_.active AS active_4, a0_.id AS id_5, a1_.title AS title_6, a1_.frequency AS frequency_7, a1_.id AS id_8, a2_.`type` AS type_9, a2_.`condition` AS condition_10, a2_.id AS id_11, a1_.idTargetGroups AS idTargetGroups_12, a2_.idTargetGroupRules AS idTargetGroupRules_13 FROM at_target_groups a0_ INNER JOIN at_target_group_rules a1_ ON a0_.id = a1_.idTargetGroups INNER JOIN at_target_group_conditions a2_ ON a1_.id = a2_.idTargetGroupRules LEFT JOIN at_target_group_webspaces a3_ ON a0_.id = a3_.idTargetGroups WHERE a0_.active = 1 AND ((a0_.allWebspaces = 1 OR a3_.webspaceKey = 'teamsante')) AND a1_.frequency <= 3 ORDER BY a0_.priority DESC;

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

[
  "barbara.teamsante.at/{localization}"
  "dev"
  "teamsante"
]

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'barbara.teamsante.at/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'teamsante' ORDER BY w0_.id ASC;