Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation 13
• Security
• Twig
• Doctrine 2
• Debug
• Emails
• Configuration

Query Metrics

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

[]

ALTER SESSION
SET
  NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';

SELECT s0_.id AS ID_0, s0_.structure AS STRUCTURE_1, s0_.name AS NAME_2, s0_.CAS_numero AS CAS_NUMERO_3, s0_.properties AS PROPERTIES_4, s0_.protein_target_name AS PROTEIN_TARGET_NAME_5, s0_.mecanism AS MECANISM_6, s0_.probe_availability AS PROBE_AVAILABILITY_7, s0_.bib_primary_reference AS BIB_PRIMARY_REFERENCE_8, s0_.bib_references AS BIB_REFERENCES_9, s0_.probe_details AS PROBE_DETAILS_10, s0_.target_details AS TARGET_DETAILS_11, s0_.selectivity_profile AS SELECTIVITY_PROFILE_12, s0_.in_vitro_data AS IN_VITRO_DATA_13, s0_.in_vivo_data AS IN_VIVO_DATA_14, s0_.toxicity AS TOXICITY_15, s0_.inserted_at AS INSERTED_AT_16, s0_.modified_at AS MODIFIED_AT_17, s0_.status AS STATUS_18, s0_.status_changed_at AS STATUS_CHANGED_AT_19, s0_.creator_id AS CREATOR_ID_20, s0_.modified_by_id AS MODIFIED_BY_ID_21 FROM sonde s0_ WHERE s0_.status = ?

[
  "Validée"
]

SELECT
  s0_.id AS ID_0,
  s0_.structure AS STRUCTURE_1,
  s0_.name AS NAME_2,
  s0_.CAS_numero AS CAS_NUMERO_3,
  s0_.properties AS PROPERTIES_4,
  s0_.protein_target_name AS PROTEIN_TARGET_NAME_5,
  s0_.mecanism AS MECANISM_6,
  s0_.probe_availability AS PROBE_AVAILABILITY_7,
  s0_.bib_primary_reference AS BIB_PRIMARY_REFERENCE_8,
  s0_.bib_references AS BIB_REFERENCES_9,
  s0_.probe_details AS PROBE_DETAILS_10,
  s0_.target_details AS TARGET_DETAILS_11,
  s0_.selectivity_profile AS SELECTIVITY_PROFILE_12,
  s0_.in_vitro_data AS IN_VITRO_DATA_13,
  s0_.in_vivo_data AS IN_VIVO_DATA_14,
  s0_.toxicity AS TOXICITY_15,
  s0_.inserted_at AS INSERTED_AT_16,
  s0_.modified_at AS MODIFIED_AT_17,
  s0_.status AS STATUS_18,
  s0_.status_changed_at AS STATUS_CHANGED_AT_19,
  s0_.creator_id AS CREATOR_ID_20,
  s0_.modified_by_id AS MODIFIED_BY_ID_21
FROM
  sonde s0_
WHERE
  s0_.status = ?

SELECT s0_.id AS ID_0, s0_.structure AS STRUCTURE_1, s0_.name AS NAME_2, s0_.CAS_numero AS CAS_NUMERO_3, s0_.properties AS PROPERTIES_4, s0_.protein_target_name AS PROTEIN_TARGET_NAME_5, s0_.mecanism AS MECANISM_6, s0_.probe_availability AS PROBE_AVAILABILITY_7, s0_.bib_primary_reference AS BIB_PRIMARY_REFERENCE_8, s0_.bib_references AS BIB_REFERENCES_9, s0_.probe_details AS PROBE_DETAILS_10, s0_.target_details AS TARGET_DETAILS_11, s0_.selectivity_profile AS SELECTIVITY_PROFILE_12, s0_.in_vitro_data AS IN_VITRO_DATA_13, s0_.in_vivo_data AS IN_VIVO_DATA_14, s0_.toxicity AS TOXICITY_15, s0_.inserted_at AS INSERTED_AT_16, s0_.modified_at AS MODIFIED_AT_17, s0_.status AS STATUS_18, s0_.status_changed_at AS STATUS_CHANGED_AT_19, s0_.creator_id AS CREATOR_ID_20, s0_.modified_by_id AS MODIFIED_BY_ID_21 FROM sonde s0_ WHERE s0_.status = 'Validée';

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.orderNumber AS ORDERNUMBER_4 FROM header_section t0 ORDER BY t0.orderNumber ASC

[]

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.name_en AS NAME_EN_3,
  t0.orderNumber AS ORDERNUMBER_4
FROM
  header_section t0
ORDER BY
  t0.orderNumber ASC

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.orderNumber AS ORDERNUMBER_4 FROM header_section t0 ORDER BY t0.orderNumber ASC;

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id IS NULL AND t0.is_public = ? ORDER BY t0.order_number ASC

[
  1
]

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.name_en AS NAME_EN_3,
  t0.content AS CONTENT_4,
  t0.contentEn AS CONTENTEN_5,
  t0.is_public AS IS_PUBLIC_6,
  t0.static AS STATIC_7,
  t0.order_number AS ORDER_NUMBER_8,
  t0.should_be_logged AS SHOULD_BE_LOGGED_9,
  t0.url AS URL_10,
  t0.url_en AS URL_EN_11,
  t0.section_id AS SECTION_ID_12
FROM
  PAGE t0
WHERE
  t0.section_id IS NULL
  AND t0.is_public = ?
ORDER BY
  t0.order_number ASC

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id IS NULL AND t0.is_public = 1 ORDER BY t0.order_number ASC;

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = ? ORDER BY t0.order_number ASC

[
  1
]

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.name_en AS NAME_EN_3,
  t0.content AS CONTENT_4,
  t0.contentEn AS CONTENTEN_5,
  t0.is_public AS IS_PUBLIC_6,
  t0.static AS STATIC_7,
  t0.order_number AS ORDER_NUMBER_8,
  t0.should_be_logged AS SHOULD_BE_LOGGED_9,
  t0.url AS URL_10,
  t0.url_en AS URL_EN_11,
  t0.section_id AS SECTION_ID_12
FROM
  PAGE t0
WHERE
  t0.section_id = ?
ORDER BY
  t0.order_number ASC

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = 1 ORDER BY t0.order_number ASC;

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = ? ORDER BY t0.order_number ASC

[
  2
]

SELECT
  t0.id AS ID_1,
  t0.name AS NAME_2,
  t0.name_en AS NAME_EN_3,
  t0.content AS CONTENT_4,
  t0.contentEn AS CONTENTEN_5,
  t0.is_public AS IS_PUBLIC_6,
  t0.static AS STATIC_7,
  t0.order_number AS ORDER_NUMBER_8,
  t0.should_be_logged AS SHOULD_BE_LOGGED_9,
  t0.url AS URL_10,
  t0.url_en AS URL_EN_11,
  t0.section_id AS SECTION_ID_12
FROM
  PAGE t0
WHERE
  t0.section_id = ?
ORDER BY
  t0.order_number ASC

SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = 2 ORDER BY t0.order_number ASC;