Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Layouts
• Twig
• HTTP Client
• Doctrine
• Debug
• Httplug 0/0
• Emails
• Message Queue
• Datagrids 0
• Doctrine ORM
• Doctrine Stats
• Websocket
• API
• Configuration

Query Metrics

SELECT text_value FROM oro_config_value WHERE name = ? AND section = ?

[
  "is_installed"
  "oro_distribution"
]

SELECT
  text_value
FROM
  oro_config_value
WHERE
  name = ?
  AND section = ?

SELECT text_value FROM oro_config_value WHERE name = 'is_installed' AND section = 'oro_distribution';

SET application_name TO '45d26c1a962afabe7e545c8f697b2a8c'

[]

SET
  application_name TO '45d26c1a962afabe7e545c8f697b2a8c'

SET application_name TO '45d26c1a962afabe7e545c8f697b2a8c';

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8, t0.guest_role_id AS guest_role_id_9, t0.default_role_id AS default_role_id_10 FROM oro_website t0 WHERE t0.is_default = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_default AS is_default_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.serialized_data AS serialized_data_6,
  t0.business_unit_owner_id AS business_unit_owner_id_7,
  t0.organization_id AS organization_id_8,
  t0.guest_role_id AS guest_role_id_9,
  t0.default_role_id AS default_role_id_10
FROM
  oro_website t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_default AS is_default_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8, t0.guest_role_id AS guest_role_id_9, t0.default_role_id AS default_role_id_10 FROM oro_website t0 WHERE t0.is_default = 1 LIMIT 1;

SELECT o0_.role AS role_0 FROM oro_customer_user_role o0_ WHERE o0_.id = ?

[
  3
]

SELECT
  o0_.role AS role_0
FROM
  oro_customer_user_role o0_
WHERE
  o0_.id = ?

SELECT o0_.role AS role_0 FROM oro_customer_user_role o0_ WHERE o0_.id = 3;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8 FROM oro_web_catalog t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.serialized_data AS serialized_data_6,
  t0.business_unit_owner_id AS business_unit_owner_id_7,
  t0.organization_id AS organization_id_8
FROM
  oro_web_catalog t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.serialized_data AS serialized_data_6, t0.business_unit_owner_id AS business_unit_owner_id_7, t0.organization_id AS organization_id_8 FROM oro_web_catalog t0 WHERE t0.id = 1;

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.formatting_code AS formatting_code_2, o0_.rtl_mode AS rtl_mode_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.serialized_data AS serialized_data_6, o0_.language_id AS language_id_7, o0_.parent_id AS parent_id_8 FROM oro_localization o0_ ORDER BY o0_.name ASC

[]

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.formatting_code AS formatting_code_2,
  o0_.rtl_mode AS rtl_mode_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.serialized_data AS serialized_data_6,
  o0_.language_id AS language_id_7,
  o0_.parent_id AS parent_id_8
FROM
  oro_localization o0_
ORDER BY
  o0_.name ASC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.formatting_code AS formatting_code_2, o0_.rtl_mode AS rtl_mode_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.serialized_data AS serialized_data_6, o0_.language_id AS language_id_7, o0_.parent_id AS parent_id_8 FROM oro_localization o0_ ORDER BY o0_.name ASC;

SELECT o0_.id AS id_0, o0_.url AS url_1, o0_.slug_prototype AS slug_prototype_2, o0_.url_hash AS url_hash_3, o0_.route_name AS route_name_4, o0_.route_parameters AS route_parameters_5, o0_.scopes_hash AS scopes_hash_6, o0_.parameters_hash AS parameters_hash_7, o1_.id AS id_8 FROM oro_redirect_slug o0_ LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id AND ((o1_.webCatalog_id = ? OR o1_.webCatalog_id IS NULL) AND (o1_.customer_id IS NULL) AND (o1_.customerGroup_id = ? OR o1_.customerGroup_id IS NULL) AND (o1_.organization_id IS NULL) AND (o1_.user_id IS NULL) AND (o1_.website_id IS NULL)) LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id WHERE o0_.url_hash = ? AND o0_.url = ? AND (o1_.localization_id IS NULL OR o1_.localization_id = COALESCE(o3_.id, ?)) ORDER BY o1_.localization_id DESC NULLS LAST, o1_.webCatalog_id DESC NULLS LAST, o1_.customerGroup_id DESC NULLS LAST, o0_.id ASC

[
  1
  1
  "0b7b480b9ee42fd8ea55fa25393f8b5d"
  "/sitemap.xml"
  1
]

SELECT
  o0_.id AS id_0,
  o0_.url AS url_1,
  o0_.slug_prototype AS slug_prototype_2,
  o0_.url_hash AS url_hash_3,
  o0_.route_name AS route_name_4,
  o0_.route_parameters AS route_parameters_5,
  o0_.scopes_hash AS scopes_hash_6,
  o0_.parameters_hash AS parameters_hash_7,
  o1_.id AS id_8
FROM
  oro_redirect_slug o0_
  LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id
  LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id
  AND (
    (
      o1_.webCatalog_id = ?
      OR o1_.webCatalog_id IS NULL
    )
    AND (o1_.customer_id IS NULL)
    AND (
      o1_.customerGroup_id = ?
      OR o1_.customerGroup_id IS NULL
    )
    AND (o1_.organization_id IS NULL)
    AND (o1_.user_id IS NULL)
    AND (o1_.website_id IS NULL)
  )
  LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id
WHERE
  o0_.url_hash = ?
  AND o0_.url = ?
  AND (
    o1_.localization_id IS NULL
    OR o1_.localization_id = COALESCE(o3_.id, ?)
  )
ORDER BY
  o1_.localization_id DESC NULLS LAST,
  o1_.webCatalog_id DESC NULLS LAST,
  o1_.customerGroup_id DESC NULLS LAST,
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.url AS url_1, o0_.slug_prototype AS slug_prototype_2, o0_.url_hash AS url_hash_3, o0_.route_name AS route_name_4, o0_.route_parameters AS route_parameters_5, o0_.scopes_hash AS scopes_hash_6, o0_.parameters_hash AS parameters_hash_7, o1_.id AS id_8 FROM oro_redirect_slug o0_ LEFT JOIN oro_slug_scope o2_ ON o0_.id = o2_.slug_id LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id AND ((o1_.webCatalog_id = 1 OR o1_.webCatalog_id IS NULL) AND (o1_.customer_id IS NULL) AND (o1_.customerGroup_id = 1 OR o1_.customerGroup_id IS NULL) AND (o1_.organization_id IS NULL) AND (o1_.user_id IS NULL) AND (o1_.website_id IS NULL)) LEFT JOIN oro_localization o3_ ON o0_.localization_id = o3_.id WHERE o0_.url_hash = '0b7b480b9ee42fd8ea55fa25393f8b5d' AND o0_.url = '/sitemap.xml' AND (o1_.localization_id IS NULL OR o1_.localization_id = COALESCE(o3_.id, 1)) ORDER BY o1_.localization_id DESC NULLS LAST, o1_.webCatalog_id DESC NULLS LAST, o1_.customerGroup_id DESC NULLS LAST, o0_.id ASC;

SELECT o0_.id AS id_0, o0_.redirect_from_prototype AS redirect_from_prototype_1, o0_.redirect_from AS redirect_from_2, o0_.from_hash AS from_hash_3, o0_.redirect_to_prototype AS redirect_to_prototype_4, o0_.redirect_to AS redirect_to_5, o0_.redirect_type AS redirect_type_6, o1_.id AS id_7, o0_.slug_id AS slug_id_8 FROM oro_redirect o0_ LEFT JOIN oro_redirect_scope o2_ ON o0_.id = o2_.redirect_id LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id AND ((o1_.webCatalog_id = ? OR o1_.webCatalog_id IS NULL) AND (o1_.customer_id IS NULL) AND (o1_.customerGroup_id = ? OR o1_.customerGroup_id IS NULL) AND (o1_.localization_id = ? OR o1_.localization_id IS NULL) AND (o1_.organization_id IS NULL) AND (o1_.user_id IS NULL) AND (o1_.website_id IS NULL)) WHERE o0_.from_hash = ? AND o0_.redirect_from = ? ORDER BY o1_.webCatalog_id DESC NULLS LAST, o1_.customerGroup_id DESC NULLS LAST, o1_.localization_id DESC NULLS LAST

[
  1
  1
  1
  "0b7b480b9ee42fd8ea55fa25393f8b5d"
  "/sitemap.xml"
]

SELECT
  o0_.id AS id_0,
  o0_.redirect_from_prototype AS redirect_from_prototype_1,
  o0_.redirect_from AS redirect_from_2,
  o0_.from_hash AS from_hash_3,
  o0_.redirect_to_prototype AS redirect_to_prototype_4,
  o0_.redirect_to AS redirect_to_5,
  o0_.redirect_type AS redirect_type_6,
  o1_.id AS id_7,
  o0_.slug_id AS slug_id_8
FROM
  oro_redirect o0_
  LEFT JOIN oro_redirect_scope o2_ ON o0_.id = o2_.redirect_id
  LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id
  AND (
    (
      o1_.webCatalog_id = ?
      OR o1_.webCatalog_id IS NULL
    )
    AND (o1_.customer_id IS NULL)
    AND (
      o1_.customerGroup_id = ?
      OR o1_.customerGroup_id IS NULL
    )
    AND (
      o1_.localization_id = ?
      OR o1_.localization_id IS NULL
    )
    AND (o1_.organization_id IS NULL)
    AND (o1_.user_id IS NULL)
    AND (o1_.website_id IS NULL)
  )
WHERE
  o0_.from_hash = ?
  AND o0_.redirect_from = ?
ORDER BY
  o1_.webCatalog_id DESC NULLS LAST,
  o1_.customerGroup_id DESC NULLS LAST,
  o1_.localization_id DESC NULLS LAST

SELECT o0_.id AS id_0, o0_.redirect_from_prototype AS redirect_from_prototype_1, o0_.redirect_from AS redirect_from_2, o0_.from_hash AS from_hash_3, o0_.redirect_to_prototype AS redirect_to_prototype_4, o0_.redirect_to AS redirect_to_5, o0_.redirect_type AS redirect_type_6, o1_.id AS id_7, o0_.slug_id AS slug_id_8 FROM oro_redirect o0_ LEFT JOIN oro_redirect_scope o2_ ON o0_.id = o2_.redirect_id LEFT JOIN oro_scope o1_ ON o1_.id = o2_.scope_id AND ((o1_.webCatalog_id = 1 OR o1_.webCatalog_id IS NULL) AND (o1_.customer_id IS NULL) AND (o1_.customerGroup_id = 1 OR o1_.customerGroup_id IS NULL) AND (o1_.localization_id = 1 OR o1_.localization_id IS NULL) AND (o1_.organization_id IS NULL) AND (o1_.user_id IS NULL) AND (o1_.website_id IS NULL)) WHERE o0_.from_hash = '0b7b480b9ee42fd8ea55fa25393f8b5d' AND o0_.redirect_from = '/sitemap.xml' ORDER BY o1_.webCatalog_id DESC NULLS LAST, o1_.customerGroup_id DESC NULLS LAST, o1_.localization_id DESC NULLS LAST;

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.installed_build_date AS installed_build_date_4, t0.local_files_language AS local_files_language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.organization_id AS organization_id_8 FROM oro_language t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.enabled AS enabled_3,
  t0.installed_build_date AS installed_build_date_4,
  t0.local_files_language AS local_files_language_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.organization_id AS organization_id_8
FROM
  oro_language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.installed_build_date AS installed_build_date_4, t0.local_files_language AS local_files_language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.organization_id AS organization_id_8 FROM oro_language t0 WHERE t0.id = 1;

SELECT o0_.theme AS theme_0 FROM oro_theme_configuration o0_ WHERE o0_.id = ?

[
  1
]

SELECT
  o0_.theme AS theme_0
FROM
  oro_theme_configuration o0_
WHERE
  o0_.id = ?

SELECT o0_.theme AS theme_0 FROM oro_theme_configuration o0_ WHERE o0_.id = 1;