Query Metrics
52
Database Queries
12
Different statements
180.62 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
120.73 ms (66.84%) |
33 |
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"
]
|
17.86 ms (9.89%) |
9 |
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"
]
|
15.82 ms (8.76%) |
1 |
SELECT g0_.id AS id_0, g0_.uuid AS uuid_1, g0_.token AS token_2, g0_.slug AS slug_3, g0_.statut AS statut_4, g0_.created_at AS created_at_5, g0_.updated_at AS updated_at_6, g0_.nom AS nom_7 FROM grade g0_ WHERE g0_.statut = ? ORDER BY g0_.nom ASC
Parameters:
[
1
]
|
13.11 ms (7.26%) |
1 |
SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.token AS token_2, d0_.slug AS slug_3, d0_.statut AS statut_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.nom AS nom_7 FROM direction d0_ WHERE d0_.statut = ? ORDER BY d0_.nom ASC
Parameters:
[
1
]
|
5.83 ms (3.22%) |
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.id = ?
Parameters:
[
3
]
|
3.33 ms (1.85%) |
1 |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.token AS token_2, c0_.slug AS slug_3, c0_.statut AS statut_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.pseudo AS pseudo_7, c0_.photo AS photo_8, c0_.telephone AS telephone_9, c0_.cv AS cv_10, c0_.parcours AS parcours_11, c0_.competence AS competence_12, c0_.aspiration AS aspiration_13, c0_.couverture AS couverture_14, c0_.valided_at AS valided_at_15, c0_.moderate AS moderate_16, c0_.nom AS nom_17, c0_.prenom AS prenom_18, c0_.email AS email_19, c0_.fake AS fake_20, c0_.user_id AS user_id_21, c0_.grade_id AS grade_id_22, c0_.direction_id AS direction_id_23 FROM cv c0_ WHERE c0_.moderate = ? AND c0_.statut = ? ORDER BY c0_.valided_at DESC LIMIT 50
Parameters:
[ 1 1 ] |
1.26 ms (0.69%) |
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:
[
"LFYhKP5qcX-mobilit-professionnelle"
]
|
0.96 ms (0.53%) |
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.pseudo AS pseudo_8, t0.photo AS photo_9, t0.telephone AS telephone_10, t0.cv AS cv_11, t0.parcours AS parcours_12, t0.competence AS competence_13, t0.aspiration AS aspiration_14, t0.couverture AS couverture_15, t0.valided_at AS valided_at_16, t0.moderate AS moderate_17, t0.nom AS nom_18, t0.prenom AS prenom_19, t0.email AS email_20, t0.fake AS fake_21, t0.user_id AS user_id_22, t0.grade_id AS grade_id_23, t0.direction_id AS direction_id_24 FROM cv t0 WHERE t0.user_id IS NULL
Parameters:
[] |
0.62 ms (0.35%) |
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:
[
"AVysG5sr3e-banque-de-cv"
]
|
0.58 ms (0.32%) |
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"
]
|
0.41 ms (0.23%) |
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
]
|
0.11 ms (0.06%) |
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
]
|
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\Grade | No errors. |
App\Entity\Direction | No errors. |
App\Entity\Conversation | No errors. |
App\Entity\Messagerie | No errors. |
App\Entity\Page | No errors. |