Query Metrics
9
Database Queries
6
Different statements
5.51 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.48 ms (26.90%) |
2 |
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:
[] |
0.96 ms (17.36%) |
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 IS NULL AND t0.is_public = ? ORDER BY t0.order_number ASC
Parameters:
[
1
]
|
0.89 ms (16.17%) |
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
Parameters:
[
1
]
|
0.81 ms (14.71%) |
1 |
SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.password AS PASSWORD_3, t0.phone AS PHONE_4, t0.phone2 AS PHONE2_5, t0.roles AS ROLES_6, t0.firstname AS FIRSTNAME_7, t0.lastname AS LASTNAME_8, t0.adresse AS ADRESSE_9, t0.postalcode AS POSTALCODE_10, t0.city AS CITY_11, t0.enabled AS ENABLED_12, t0.token AS TOKEN_13, t0.last_connexion AS LAST_CONNEXION_14, t0.is_public AS IS_PUBLIC_15, t0.bio AS BIO_16, t0.bio_en AS BIO_EN_17, t0.web AS WEB_18, t0.created_at AS CREATED_AT_19, t0.team_id AS TEAM_ID_20, t0.profile_picture_id AS PROFILE_PICTURE_ID_21 FROM t_user t0 WHERE t0.id = ?
Parameters:
[
19
]
|
0.76 ms (13.84%) |
1 |
SELECT t0.id AS ID_1, t0.structure AS STRUCTURE_2, t0.name AS NAME_3, t0.CAS_numero AS CAS_NUMERO_4, t0.properties AS PROPERTIES_5, t0.protein_target_name AS PROTEIN_TARGET_NAME_6, t0.mecanism AS MECANISM_7, t0.probe_availability AS PROBE_AVAILABILITY_8, t0.bib_primary_reference AS BIB_PRIMARY_REFERENCE_9, t0.bib_references AS BIB_REFERENCES_10, t0.probe_details AS PROBE_DETAILS_11, t0.target_details AS TARGET_DETAILS_12, t0.selectivity_profile AS SELECTIVITY_PROFILE_13, t0.in_vitro_data AS IN_VITRO_DATA_14, t0.in_vivo_data AS IN_VIVO_DATA_15, t0.toxicity AS TOXICITY_16, t0.inserted_at AS INSERTED_AT_17, t0.modified_at AS MODIFIED_AT_18, t0.status AS STATUS_19, t0.status_changed_at AS STATUS_CHANGED_AT_20, t0.creator_id AS CREATOR_ID_21, t0.modified_by_id AS MODIFIED_BY_ID_22 FROM sonde t0 WHERE t0.id = ?
Parameters:
[
"47"
]
|
0.61 ms (11.03%) |
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.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. |