Symfony Profiler

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

Queries

Group similar statements

default connection

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';

SELECT loc.id, loc.formatting_code AS formatting, lang.code AS language, loc.rtl_mode AS rtl 
    FROM oro_localization AS loc 
    INNER JOIN oro_language AS lang ON lang.id = loc.language_id

[]

SELECT
  loc.id,
  loc.formatting_code AS formatting,
  lang.code AS language,
  loc.rtl_mode AS rtl
FROM
  oro_localization AS loc
  INNER JOIN oro_language AS lang ON lang.id = loc.language_id

SELECT loc.id, loc.formatting_code AS formatting, lang.code AS language, loc.rtl_mode AS rtl 
    FROM oro_localization AS loc 
    INNER JOIN oro_language AS lang ON lang.id = loc.language_id;

SELECT a0_.name AS name_0, a0_.start_date AS start_date_1, a0_.end_date AS end_date_2, a0_.maxGuests AS maxguests_3, a0_.is_active AS is_active_4, a0_.id AS id_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.serialized_data AS serialized_data_8, a0_.business_unit_owner_id AS business_unit_owner_id_9, a0_.organization_id AS organization_id_10 FROM app_festival a0_ WHERE a0_.is_active = ?

[
  1
]

SELECT
  a0_.name AS name_0,
  a0_.start_date AS start_date_1,
  a0_.end_date AS end_date_2,
  a0_.maxGuests AS maxguests_3,
  a0_.is_active AS is_active_4,
  a0_.id AS id_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.serialized_data AS serialized_data_8,
  a0_.business_unit_owner_id AS business_unit_owner_id_9,
  a0_.organization_id AS organization_id_10
FROM
  app_festival a0_
WHERE
  a0_.is_active = ?

SELECT a0_.name AS name_0, a0_.start_date AS start_date_1, a0_.end_date AS end_date_2, a0_.maxGuests AS maxguests_3, a0_.is_active AS is_active_4, a0_.id AS id_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.serialized_data AS serialized_data_8, a0_.business_unit_owner_id AS business_unit_owner_id_9, a0_.organization_id AS organization_id_10 FROM app_festival a0_ WHERE a0_.is_active = 1;

SELECT t0.purchaseIntentStrategyId AS purchaseintentstrategyid_1, t0.eventId AS eventid_2, t0.id AS id_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.festival_id AS festival_id_9 FROM app_guestlist t0 WHERE t0.festival_id = ? LIMIT 1

[
  1
]

SELECT
  t0.purchaseIntentStrategyId AS purchaseintentstrategyid_1,
  t0.eventId AS eventid_2,
  t0.id AS id_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.festival_id AS festival_id_9
FROM
  app_guestlist t0
WHERE
  t0.festival_id = ?
LIMIT
  1

SELECT t0.purchaseIntentStrategyId AS purchaseintentstrategyid_1, t0.eventId AS eventid_2, t0.id AS id_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.festival_id AS festival_id_9 FROM app_guestlist t0 WHERE t0.festival_id = 1 LIMIT 1;

SELECT o0_.id AS id_0 FROM oro_scope o0_ WHERE o0_.user_id IS NULL AND o0_.localization_id IS NULL AND o0_.organization_id IS NULL

[]

SELECT
  o0_.id AS id_0
FROM
  oro_scope o0_
WHERE
  o0_.user_id IS NULL
  AND o0_.localization_id IS NULL
  AND o0_.organization_id IS NULL

SELECT o0_.id AS id_0 FROM oro_scope o0_ WHERE o0_.user_id IS NULL AND o0_.localization_id IS NULL AND o0_.organization_id IS NULL;

SELECT DISTINCT o0_.scope_id AS sclr_0, o0_.menu AS menu_1 FROM oro_navigation_menu_upd o0_

[]

SELECT
  DISTINCT o0_.scope_id AS sclr_0,
  o0_.menu AS menu_1
FROM
  oro_navigation_menu_upd o0_

SELECT DISTINCT o0_.scope_id AS sclr_0, o0_.menu AS menu_1 FROM oro_navigation_menu_upd o0_;

session connection

config connection

message_queue connection

sql_validator connection

search connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

config entity manager

message_queue entity manager

batch entity manager

search entity manager