Query Metrics
45
Database Queries
14
Different statements
36.56 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
29.28 ms (80.09%) |
26 |
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"
]
|
1.70 ms (4.64%) |
1 |
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.token AS token_2, a0_.slug AS slug_3, a0_.statut AS statut_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.nom AS nom_7, a0_.description AS description_8, a0_.pseudo AS pseudo_9, a0_.valided_at AS valided_at_10, a0_.moderate AS moderate_11, a0_.titre AS titre_12, a0_.prenom AS prenom_13, a0_.email AS email_14, a0_.phone AS phone_15, a0_.fake AS fake_16, a0_.entite AS entite_17, a0_.genre AS genre_18, a0_.fichier AS fichier_19, a0_.ext AS ext_20, a0_.mime AS mime_21, a0_.categorie_id AS categorie_id_22, a0_.souscategorie_id AS souscategorie_id_23, a0_.user_id AS user_id_24, a0_.direction_id AS direction_id_25, a0_.grade_id AS grade_id_26 FROM agora a0_ INNER JOIN souscategorie s1_ ON a0_.souscategorie_id = s1_.id INNER JOIN categorie c2_ ON a0_.categorie_id = c2_.id WHERE c2_.id = ? AND a0_.moderate = ? AND a0_.statut = ? ORDER BY a0_.valided_at DESC LIMIT 50
Parameters:
[ 1 1 1 ] |
0.87 ms (2.38%) |
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.slug = ? LIMIT 1
Parameters:
[
"E9fyrwne2i-besoin-de-competences"
]
|
0.79 ms (2.17%) |
6 |
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"
]
|
0.65 ms (1.79%) |
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
]
|
0.58 ms (1.58%) |
2 |
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.55 ms (1.50%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.token AS token_2, a0_.slug AS slug_3, a0_.statut AS statut_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.nom AS nom_7, a0_.description AS description_8, a0_.pseudo AS pseudo_9, a0_.valided_at AS valided_at_10, a0_.moderate AS moderate_11, a0_.titre AS titre_12, a0_.prenom AS prenom_13, a0_.email AS email_14, a0_.phone AS phone_15, a0_.fake AS fake_16, a0_.entite AS entite_17, a0_.genre AS genre_18, a0_.fichier AS fichier_19, a0_.ext AS ext_20, a0_.mime AS mime_21 FROM agora a0_ INNER JOIN souscategorie s1_ ON a0_.souscategorie_id = s1_.id INNER JOIN categorie c2_ ON a0_.categorie_id = c2_.id WHERE c2_.id = ? AND a0_.moderate = ? AND a0_.statut = ? ORDER BY a0_.valided_at DESC) dctrn_result) dctrn_table
Parameters:
[ 1 1 1 ] |
0.43 ms (1.17%) |
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.31 ms (0.86%) |
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
]
|
0.30 ms (0.82%) |
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"
]
|
0.30 ms (0.81%) |
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
]
|
0.29 ms (0.78%) |
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"
]
|
0.26 ms (0.71%) |
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
]
|
0.25 ms (0.69%) |
1 |
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.token AS token_2, s0_.slug AS slug_3, s0_.statut AS statut_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.nom AS nom_7, s0_.description AS description_8, s0_.listorder AS listorder_9, s0_.src AS src_10, s0_.alt AS alt_11, s0_.title AS title_12, s0_.src_img AS src_img_13, s0_.alt_img AS alt_img_14, s0_.title_img AS title_img_15, s0_.intro AS intro_16 FROM souscategorie s0_ WHERE s0_.statut = ? ORDER BY s0_.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\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. |