Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 13
• 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 '7f7360f6933d41347179231b8d8ada20'

[]

SET
  application_name TO '7f7360f6933d41347179231b8d8ada20'

SET application_name TO '7f7360f6933d41347179231b8d8ada20';

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
  "0664f043ea7c68fa2865dd89e2454fdc"
  "/navigation-root/products/clearance/office-furniture"
  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 = '0664f043ea7c68fa2865dd89e2454fdc' AND o0_.url = '/navigation-root/products/clearance/office-furniture' 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_.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 o1_.id IS NULL AND o0_.slug_prototype = ? 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
  "green-beige-sofa"
  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
  o1_.id IS NULL
  AND o0_.slug_prototype = ?
  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 o1_.id IS NULL AND o0_.slug_prototype = 'green-beige-sofa' 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 1 FROM oro_slug_scope WHERE slug_id = ? LIMIT 1

[
  58
]

SELECT
  1
FROM
  oro_slug_scope
WHERE
  slug_id = ?
LIMIT
  1

SELECT 1 FROM oro_slug_scope WHERE slug_id = 58 LIMIT 1;