Query Metrics
35
Database Queries
11
Different statements
171.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
101.24 ms (59.04%) |
22 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.societe_nom AS societe_nom_3, t0.societe_adresse AS societe_adresse_4, t0.societe_cp AS societe_cp_5, t0.societe_location AS societe_location_6, t0.societe_ville AS societe_ville_7, t0.societe_pays AS societe_pays_8, t0.societe_email AS societe_email_9, t0.societe_phone AS societe_phone_10, t0.societe_logo_src AS societe_logo_src_11, t0.societe_logo_alt AS societe_logo_alt_12, t0.societe_logo_title AS societe_logo_title_13, t0.societe_logo_base64 AS societe_logo_base64_14, t0.societe_favicon AS societe_favicon_15, t0.societe_website AS societe_website_16, t0.ref_title AS ref_title_17, t0.ref_keyword AS ref_keyword_18, t0.ref_description AS ref_description_19, t0.ref_author AS ref_author_20, t0.length_token AS length_token_21, t0.src404 AS src404_22, t0.alt404 AS alt404_23, t0.title404 AS title404_24, t0.message404 AS message404_25, t0.src403 AS src403_26, t0.alt403 AS alt403_27, t0.title403 AS title403_28, t0.message403 AS message403_29, t0.sujet_size AS sujet_size_30, t0.call_senior AS call_senior_31, t0.agenda_before AS agenda_before_32, t0.agenda_next AS agenda_next_33, t0.message_default AS message_default_34, t0.titre_contact AS titre_contact_35, t0.titre_second_contact AS titre_second_contact_36, t0.description_contact AS description_contact_37, t0.email_contact AS email_contact_38, t0.titre_accueil AS titre_accueil_39, t0.agenda_titre AS agenda_titre_40, t0.agenda_src AS agenda_src_41, t0.agenda_alt AS agenda_alt_42, t0.agenda_title AS agenda_title_43, t0.agenda_description AS agenda_description_44, t0.agenda_src_img AS agenda_src_img_45, t0.agenda_alt_img AS agenda_alt_img_46, t0.agenda_title_img AS agenda_title_img_47, t0.agenda_intro AS agenda_intro_48, t0.color AS color_49, t0.notice AS notice_50, t0.tchap AS tchap_51, t0.tchap_bool AS tchap_bool_52, t0.titre_tchap AS titre_tchap_53, t0.titre_lien AS titre_lien_54, t0.color_lien AS color_lien_55, t0.size_droit AS size_droit_56, t0.limit_droit AS limit_droit_57, t0.size_agora AS size_agora_58, t0.limit_agora AS limit_agora_59, t0.size_post AS size_post_60, t0.limit_post AS limit_post_61, t0.size_parcours AS size_parcours_62, t0.size_competences AS size_competences_63, t0.size_aspiration AS size_aspiration_64, t0.resultat AS resultat_65, t0.horaire AS horaire_66, t0.size_agenda AS size_agenda_67, t0.limit_agenda AS limit_agenda_68, t0.link_agenda AS link_agenda_69, t0.text_presentiel AS text_presentiel_70, t0.text_distanciel AS text_distanciel_71, t0.inscription AS inscription_72, t0.limit_intro_actu AS limit_intro_actu_73 FROM configuration t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"1b3606a6-b889-4fdc-9cef-819ea47094c1"
]
|
|
30.89 ms (18.01%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.slug AS slug_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.nom AS nom_8, t0.description AS description_9, t0.pseudo AS pseudo_10, t0.valided_at AS valided_at_11, t0.moderate AS moderate_12, t0.titre AS titre_13, t0.prenom AS prenom_14, t0.email AS email_15, t0.phone AS phone_16, t0.fake AS fake_17, t0.entite AS entite_18, t0.genre AS genre_19, t0.fichier AS fichier_20, t0.ext AS ext_21, t0.mime AS mime_22, t0.categorie_id AS categorie_id_23, t0.souscategorie_id AS souscategorie_id_24, t0.user_id AS user_id_25, t0.direction_id AS direction_id_26, t0.grade_id AS grade_id_27 FROM agora t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"Q72oHQadPz-lorem"
]
|
|
8.68 ms (5.06%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.nom AS nom_4, t0.src AS src_5, t0.alt AS alt_6, t0.title AS title_7, t0.description AS description_8, t0.src_img AS src_img_9, t0.alt_img AS alt_img_10, t0.title_img AS title_img_11, t0.slug AS slug_12, t0.intro AS intro_13, t0.phrase AS phrase_14, t0.titre AS titre_15, t0.listorder AS listorder_16, t0.statut AS statut_17, t0.lien AS lien_18 FROM rubrique t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"74ee7169-9e87-40d1-a4b0-aac601401cb4"
]
|
|
5.39 ms (3.14%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.slug AS slug_4, t0.statut AS statut_5, t0.nom AS nom_6, t0.description AS description_7, t0.src AS src_8, t0.alt AS alt_9, t0.title AS title_10, t0.src_img AS src_img_11, t0.alt_img AS alt_img_12, t0.title_img AS title_img_13, t0.intro AS intro_14, t0.phrase AS phrase_15, t0.listorder AS listorder_16, t0.lien AS lien_17, t0.info AS info_18, t0.rubrique_id AS rubrique_id_19 FROM sousrubrique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"H709UyMvOW-carrefour-des-comptences"
]
|
|
4.81 ms (2.81%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.nom AS nom_4, t0.src AS src_5, t0.alt AS alt_6, t0.title AS title_7, t0.description AS description_8, t0.src_img AS src_img_9, t0.alt_img AS alt_img_10, t0.title_img AS title_img_11, t0.slug AS slug_12, t0.intro AS intro_13, t0.phrase AS phrase_14, t0.titre AS titre_15, t0.listorder AS listorder_16, t0.statut AS statut_17, t0.lien AS lien_18 FROM rubrique t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"jSgXgXImeM-transmission-de-comptences"
]
|
|
4.04 ms (2.36%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.slug AS slug_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.nom AS nom_8, t0.description AS description_9, t0.listorder AS listorder_10, t0.src AS src_11, t0.alt AS alt_12, t0.title AS title_13, t0.src_img AS src_img_14, t0.alt_img AS alt_img_15, t0.title_img AS title_img_16, t0.intro AS intro_17, t0.entite AS entite_18 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
4.01 ms (2.34%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.slug AS slug_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.nom AS nom_8, t0.description AS description_9, t0.listorder AS listorder_10, t0.src AS src_11, t0.alt AS alt_12, t0.title AS title_13, t0.src_img AS src_img_14, t0.alt_img AS alt_img_15, t0.title_img AS title_img_16, t0.intro AS intro_17 FROM souscategorie t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
3.69 ms (2.15%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.statut AS statut_8, t0.activation AS activation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.token AS token_12, t0.online AS online_13, t0.login_at AS login_at_14, t0.provider AS provider_15, t0.sexe AS sexe_16 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
3.68 ms (2.14%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.titre AS titre_4, t0.body AS body_5, t0.slug AS slug_6, t0.listorder AS listorder_7, t0.statut AS statut_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM page t0 WHERE t0.statut = ? ORDER BY t0.listorder ASC
Parameters:
[
1
]
|
|
2.84 ms (1.66%) |
4 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.token AS token_3, t0.slug AS slug_4, t0.statut AS statut_5, t0.nom AS nom_6, t0.description AS description_7, t0.src AS src_8, t0.alt AS alt_9, t0.title AS title_10, t0.src_img AS src_img_11, t0.alt_img AS alt_img_12, t0.title_img AS title_img_13, t0.intro AS intro_14, t0.phrase AS phrase_15, t0.listorder AS listorder_16, t0.lien AS lien_17, t0.info AS info_18, t0.rubrique_id AS rubrique_id_19 FROM sousrubrique t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"99a2f476-604c-454b-8084-ce0feb3a9082"
]
|
|
2.21 ms (1.29%) |
1 |
SELECT r0_.id AS id_0, r0_.uuid AS uuid_1, r0_.token AS token_2, r0_.nom AS nom_3, r0_.src AS src_4, r0_.alt AS alt_5, r0_.title AS title_6, r0_.description AS description_7, r0_.src_img AS src_img_8, r0_.alt_img AS alt_img_9, r0_.title_img AS title_img_10, r0_.slug AS slug_11, r0_.intro AS intro_12, r0_.phrase AS phrase_13, r0_.titre AS titre_14, r0_.listorder AS listorder_15, r0_.statut AS statut_16, r0_.lien AS lien_17 FROM rubrique r0_ WHERE r0_.id <> ? AND r0_.statut = 1 ORDER BY r0_.listorder ASC
Parameters:
[
5
]
|
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\Configuration | No errors. |
| App\Entity\Rubrique | No errors. |
| App\Entity\Juridique | No errors. |
| App\Entity\Sousrubrique | No errors. |
| App\Entity\Initiative | No errors. |
| App\Entity\Referent | No errors. |
| App\Entity\Archive | No errors. |
| App\Entity\Conference | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Souscategorie | No errors. |
| App\Entity\Agora | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Cv | No errors. |
| App\Entity\Droit | No errors. |
| App\Entity\Domaine | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Direction | No errors. |
| App\Entity\Grade | No errors. |
| App\Entity\FichierAgora | No errors. |
| App\Entity\Conversation | No errors. |
| App\Entity\Messagerie | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Sujet | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Astuce | No errors. |