Query Metrics
5
Database Queries
4
Different statements
3.36 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.72 ms |
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:
[
"96"
]
|
2 | 0.90 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:
[] |
3 | 0.63 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
]
|
4 | 0.71 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
]
|
5 | 0.40 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
]
|
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. |