Query Metrics
9
Database Queries
6
Different statements
7.23 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.02 ms |
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 = '.,'
Parameters:
[] |
| 2 | 0.32 ms |
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 = ?
Parameters:
[
"Validée"
]
|
| 3 | 0.50 ms |
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
Parameters:
[] |
| 4 | 0.32 ms |
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
Parameters:
[
1
]
|
| 5 | 0.36 ms |
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
Parameters:
[
1
]
|
| 6 | 0.25 ms |
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
Parameters:
[
2
]
|
| 7 | 1.34 ms |
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
Parameters:
[] |
| 8 | 1.87 ms |
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
Parameters:
[
1
]
|
| 9 | 1.24 ms |
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.is_public = ? ORDER BY t0.order_number ASC
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Sonde | No errors. |
| App\UserBundle\Entity\User | No errors. |
| App\Entity\HeaderSection |
|
| App\Entity\Page |
|
| App\Entity\Paragraph | No errors. |
| App\Entity\Equipe | No errors. |
| App\Entity\File | No errors. |