Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Serializer
• Configuration

Query Metrics

SELECT l0_.id AS id_0, l0_.legacy_id AS legacy_id_1, l0_.login_name AS login_name_2, l0_.password_hash AS password_hash_3, l0_.is_master_account AS is_master_account_4, l0_.status_code AS status_code_5, l0_.is_active AS is_active_6, l0_.legacy_inserted_at AS legacy_inserted_at_7, l0_.legacy_updated_at AS legacy_updated_at_8, l0_.legacy_deleted_at AS legacy_deleted_at_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, p1_.id AS id_12, p1_.legacy_id AS legacy_id_13, p1_.title AS title_14, p1_.description AS description_15, p1_.experience_info AS experience_info_16, p1_.accreditation_info AS accreditation_info_17, p1_.seminar_type_info AS seminar_type_info_18, p1_.requirements_info AS requirements_info_19, p1_.company_name AS company_name_20, p1_.address_extra AS address_extra_21, p1_.street AS street_22, p1_.house_number AS house_number_23, p1_.postal_code AS postal_code_24, p1_.city AS city_25, p1_.state_name AS state_name_26, p1_.country AS country_27, p1_.latitude AS latitude_28, p1_.longitude AS longitude_29, p1_.contact_person AS contact_person_30, p1_.phone AS phone_31, p1_.fax AS fax_32, p1_.email AS email_33, p1_.website AS website_34, p1_.status_code AS status_code_35, p1_.is_active AS is_active_36, p1_.legacy_inserted_at AS legacy_inserted_at_37, p1_.legacy_updated_at AS legacy_updated_at_38, p1_.legacy_deleted_at AS legacy_deleted_at_39, p1_.created_at AS created_at_40, p1_.updated_at AS updated_at_41, l0_.provider_id AS provider_id_42 FROM legacy_users l0_ LEFT JOIN providers p1_ ON l0_.provider_id = p1_.id WHERE LOWER(l0_.login_name) = ? AND l0_.is_active = ? LIMIT 1

[
  "lp-admin"
  1
]

SELECT
  l0_.id AS id_0,
  l0_.legacy_id AS legacy_id_1,
  l0_.login_name AS login_name_2,
  l0_.password_hash AS password_hash_3,
  l0_.is_master_account AS is_master_account_4,
  l0_.status_code AS status_code_5,
  l0_.is_active AS is_active_6,
  l0_.legacy_inserted_at AS legacy_inserted_at_7,
  l0_.legacy_updated_at AS legacy_updated_at_8,
  l0_.legacy_deleted_at AS legacy_deleted_at_9,
  l0_.created_at AS created_at_10,
  l0_.updated_at AS updated_at_11,
  p1_.id AS id_12,
  p1_.legacy_id AS legacy_id_13,
  p1_.title AS title_14,
  p1_.description AS description_15,
  p1_.experience_info AS experience_info_16,
  p1_.accreditation_info AS accreditation_info_17,
  p1_.seminar_type_info AS seminar_type_info_18,
  p1_.requirements_info AS requirements_info_19,
  p1_.company_name AS company_name_20,
  p1_.address_extra AS address_extra_21,
  p1_.street AS street_22,
  p1_.house_number AS house_number_23,
  p1_.postal_code AS postal_code_24,
  p1_.city AS city_25,
  p1_.state_name AS state_name_26,
  p1_.country AS country_27,
  p1_.latitude AS latitude_28,
  p1_.longitude AS longitude_29,
  p1_.contact_person AS contact_person_30,
  p1_.phone AS phone_31,
  p1_.fax AS fax_32,
  p1_.email AS email_33,
  p1_.website AS website_34,
  p1_.status_code AS status_code_35,
  p1_.is_active AS is_active_36,
  p1_.legacy_inserted_at AS legacy_inserted_at_37,
  p1_.legacy_updated_at AS legacy_updated_at_38,
  p1_.legacy_deleted_at AS legacy_deleted_at_39,
  p1_.created_at AS created_at_40,
  p1_.updated_at AS updated_at_41,
  l0_.provider_id AS provider_id_42
FROM
  legacy_users l0_
  LEFT JOIN providers p1_ ON l0_.provider_id = p1_.id
WHERE
  LOWER(l0_.login_name) = ?
  AND l0_.is_active = ?
LIMIT
  1

SELECT l0_.id AS id_0, l0_.legacy_id AS legacy_id_1, l0_.login_name AS login_name_2, l0_.password_hash AS password_hash_3, l0_.is_master_account AS is_master_account_4, l0_.status_code AS status_code_5, l0_.is_active AS is_active_6, l0_.legacy_inserted_at AS legacy_inserted_at_7, l0_.legacy_updated_at AS legacy_updated_at_8, l0_.legacy_deleted_at AS legacy_deleted_at_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11, p1_.id AS id_12, p1_.legacy_id AS legacy_id_13, p1_.title AS title_14, p1_.description AS description_15, p1_.experience_info AS experience_info_16, p1_.accreditation_info AS accreditation_info_17, p1_.seminar_type_info AS seminar_type_info_18, p1_.requirements_info AS requirements_info_19, p1_.company_name AS company_name_20, p1_.address_extra AS address_extra_21, p1_.street AS street_22, p1_.house_number AS house_number_23, p1_.postal_code AS postal_code_24, p1_.city AS city_25, p1_.state_name AS state_name_26, p1_.country AS country_27, p1_.latitude AS latitude_28, p1_.longitude AS longitude_29, p1_.contact_person AS contact_person_30, p1_.phone AS phone_31, p1_.fax AS fax_32, p1_.email AS email_33, p1_.website AS website_34, p1_.status_code AS status_code_35, p1_.is_active AS is_active_36, p1_.legacy_inserted_at AS legacy_inserted_at_37, p1_.legacy_updated_at AS legacy_updated_at_38, p1_.legacy_deleted_at AS legacy_deleted_at_39, p1_.created_at AS created_at_40, p1_.updated_at AS updated_at_41, l0_.provider_id AS provider_id_42 FROM legacy_users l0_ LEFT JOIN providers p1_ ON l0_.provider_id = p1_.id WHERE LOWER(l0_.login_name) = 'lp-admin' AND l0_.is_active = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.state_code AS state_code_2, t0.legacy_id AS legacy_id_3, t0.state_name AS state_name_4, t0.title AS title_5, t0.summary AS summary_6, t0.minimum_refresh_months AS minimum_refresh_months_7, t0.notes AS notes_8, t0.body_html AS body_html_9, t0.target_group_html AS target_group_html_10, t0.cadence_html AS cadence_html_11, t0.legal_basis_html AS legal_basis_html_12, t0.provider_requirements_html AS provider_requirements_html_13, t0.duration_html AS duration_html_14, t0.general_html AS general_html_15, t0.is_active AS is_active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM state_rules t0 ORDER BY t0.state_name ASC

[]

SELECT
  t0.id AS id_1,
  t0.state_code AS state_code_2,
  t0.legacy_id AS legacy_id_3,
  t0.state_name AS state_name_4,
  t0.title AS title_5,
  t0.summary AS summary_6,
  t0.minimum_refresh_months AS minimum_refresh_months_7,
  t0.notes AS notes_8,
  t0.body_html AS body_html_9,
  t0.target_group_html AS target_group_html_10,
  t0.cadence_html AS cadence_html_11,
  t0.legal_basis_html AS legal_basis_html_12,
  t0.provider_requirements_html AS provider_requirements_html_13,
  t0.duration_html AS duration_html_14,
  t0.general_html AS general_html_15,
  t0.is_active AS is_active_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  state_rules t0
ORDER BY
  t0.state_name ASC

SELECT t0.id AS id_1, t0.state_code AS state_code_2, t0.legacy_id AS legacy_id_3, t0.state_name AS state_name_4, t0.title AS title_5, t0.summary AS summary_6, t0.minimum_refresh_months AS minimum_refresh_months_7, t0.notes AS notes_8, t0.body_html AS body_html_9, t0.target_group_html AS target_group_html_10, t0.cadence_html AS cadence_html_11, t0.legal_basis_html AS legal_basis_html_12, t0.provider_requirements_html AS provider_requirements_html_13, t0.duration_html AS duration_html_14, t0.general_html AS general_html_15, t0.is_active AS is_active_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM state_rules t0 ORDER BY t0.state_name ASC;