Query Metrics
81
Database Queries
8
Different statements
133.69 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
74.36 ms (55.62%) |
1 |
SELECT t0.id AS ID_1, t0.keyword AS KEYWORD_2 FROM keyword t0
Parameters:
[] |
32.94 ms (24.64%) |
1 |
SELECT t0.id AS ID_1, t0.team_id AS TEAM_ID_2, t0.keyword_id AS KEYWORD_ID_3 FROM team_keyword t0
Parameters:
[] |
23.65 ms (17.69%) |
71 |
SELECT t0.id AS ID_1, t0.intitule AS INTITULE_2, t0.acronyme AS ACRONYME_3, t0.adresse AS ADRESSE_4, t0.contact_1 AS CONTACT_1_5, t0.contact_2 AS CONTACT_2_6, t0.tutelles AS TUTELLES_7, t0.date_de_creation AS DATE_DE_CREATION_8, t0.demarche_qualite AS DEMARCHE_QUALITE_9, t0.certifications AS CERTIFICATIONS_10, t0.savoir_faire AS SAVOIR_FAIRE_11, t0.savoir_faire_en AS SAVOIR_FAIRE_EN_12, t0.specificite AS SPECIFICITE_13, t0.specificite_en AS SPECIFICITE_EN_14, t0.domaine_application AS DOMAINE_APPLICATION_15, t0.domaine_application_en AS DOMAINE_APPLICATION_EN_16, t0.tests_proposes AS TESTS_PROPOSES_17, t0.tests_proposes_en AS TESTS_PROPOSES_EN_18, t0.autres_activites AS AUTRES_ACTIVITES_19, t0.autres_activites_en AS AUTRES_ACTIVITES_EN_20, t0.equipements AS EQUIPEMENTS_21, t0.equipements_en AS EQUIPEMENTS_EN_22, t0.RH AS RH_23, t0.technologies AS TECHNOLOGIES_24, t0.technologies_en AS TECHNOLOGIES_EN_25, t0.debit AS DEBIT_26, t0.debit_en AS DEBIT_EN_27, t0.delai_reponse AS DELAI_REPONSE_28, t0.delai_reponse_en AS DELAI_REPONSE_EN_29, t0.reference AS REFERENCE_30, t0.reference_en AS REFERENCE_EN_31, t0.latitude AS LATITUDE_32, t0.longitude AS LONGITUDE_33, t0.category AS CATEGORY_34, t0.created_at AS CREATED_AT_35, t0.updated_at AS UPDATED_AT_36, t0.labocn_id AS LABOCN_ID_37 FROM equipe t0 WHERE t0.id = ?
Parameters:
[
22
]
|
1.22 ms (0.92%) |
1 |
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:
[] |
0.61 ms (0.45%) |
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.36 ms (0.27%) |
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.35 ms (0.26%) |
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.22 ms (0.16%) |
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\TeamKeyword | No errors. |
App\Entity\Equipe | No errors. |
App\Entity\Keyword | No errors. |
App\Entity\HeaderSection |
|
App\Entity\Page |
|
App\Entity\Paragraph | No errors. |