Query Metrics
4
Database Queries
4
Different statements
11.54 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.59 ms (39.82%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.duree_lib AS duree_lib_5, t0.lieu_complement AS lieu_complement_6, t0.nb_plan_b AS nb_plan_b_7, t0.seuil_nb_inscrit AS seuil_nb_inscrit_8, t0.pre_titre AS pre_titre_9, t0.post_titre AS post_titre_10, t0.editorial AS editorial_11, t0.programme AS programme_12, t0.arrive AS arrive_13, t0.has_badge AS has_badge_14, t0.minisite AS minisite_15, t0.domaine AS domaine_16, t0.sub_domaine AS sub_domaine_17, t0.icon AS icon_18, t0.color AS color_19, t0.header_nom AS header_nom_20, t0.annulation_possible AS annulation_possible_21, t0.commentaire_personne_active AS commentaire_personne_active_22, t0.commentaire_personne_help AS commentaire_personne_help_23, t0.badge_complement AS badge_complement_24, t0.montant_non_remboursable AS montant_non_remboursable_25, t0.comment_atelier AS comment_atelier_26, t0.participant_fonction_facultative AS participant_fonction_facultative_27, t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28, t0.nom AS nom_29, t0.description AS description_30, t0.comment_form AS comment_form_31, t0.comment_mail AS comment_mail_32, t0.date_limite_annulation AS date_limite_annulation_33, t0.date_limite_inscription AS date_limite_inscription_34, t0.date_limite_remplacement AS date_limite_remplacement_35, t0.specialite AS specialite_36, t0.actif AS actif_37, t0.nb_heures AS nb_heures_38, t0.code_youtube AS code_youtube_39, t0.montant_annulation AS montant_annulation_40, t0.brochure_nom AS brochure_nom_41, t0.image_nom AS image_nom_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.lieu_id AS lieu_id_45, t0.organisateur_id AS organisateur_id_46, t0.created_by_id AS created_by_id_47, t0.updated_by_id AS updated_by_id_48 FROM evenement t0 WHERE t0.sub_domaine = ? LIMIT 1
Parameters:
[
"creai-na"
]
|
|
3.29 ms (28.48%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prefixe AS prefixe_3, t0.sub_domain AS sub_domain_4, t0.adresse AS adresse_5, t0.complement AS complement_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.cedex AS cedex_9, t0.agrement_date AS agrement_date_10, t0.agrement_code AS agrement_code_11, t0.logo_url AS logo_url_12, t0.logo_name AS logo_name_13, t0.siret AS siret_14, t0.ape AS ape_15, t0.dom AS dom_16, t0.bic AS bic_17, t0.iban AS iban_18, t0.rib AS rib_19, t0.tel AS tel_20, t0.site AS site_21, t0.slug AS slug_22, t0.co_orga_only AS co_orga_only_23, t0.masculin AS masculin_24, t0.sans_article AS sans_article_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.username AS username_30, t28.confirmation_token AS confirmation_token_31, t28.password_requested_at AS password_requested_at_32, t28.roles AS roles_33, t28.email AS email_34, t28.email_canonical AS email_canonical_35, t28.enabled AS enabled_36, t28.salt AS salt_37, t28.password AS password_38, t28.last_login AS last_login_39, t28.nom AS nom_40, t28.prenom AS prenom_41, t28.homme AS homme_42, t28.fonction AS fonction_43, t28.signature_name AS signature_name_44, t28.organisateur_id AS organisateur_id_45, t28.dirige_id AS dirige_id_46, t28.gere_id AS gere_id_47, t28.journee_id AS journee_id_48, t28.evenement_id AS evenement_id_49, t50.id AS id_51, t50.username AS username_52, t50.confirmation_token AS confirmation_token_53, t50.password_requested_at AS password_requested_at_54, t50.roles AS roles_55, t50.email AS email_56, t50.email_canonical AS email_canonical_57, t50.enabled AS enabled_58, t50.salt AS salt_59, t50.password AS password_60, t50.last_login AS last_login_61, t50.nom AS nom_62, t50.prenom AS prenom_63, t50.homme AS homme_64, t50.fonction AS fonction_65, t50.signature_name AS signature_name_66, t50.organisateur_id AS organisateur_id_67, t50.dirige_id AS dirige_id_68, t50.gere_id AS gere_id_69, t50.journee_id AS journee_id_70, t50.evenement_id AS evenement_id_71, t0.dpo_id AS dpo_id_72 FROM organisateur t0 LEFT JOIN user t28 ON t28.dirige_id = t0.id LEFT JOIN user t50 ON t50.gere_id = t0.id WHERE t0.sub_domain = ? LIMIT 1
Parameters:
[
"creai-na"
]
|
|
2.73 ms (23.67%) |
1 |
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.duree_lib AS duree_lib_4, e0_.lieu_complement AS lieu_complement_5, e0_.nb_plan_b AS nb_plan_b_6, e0_.seuil_nb_inscrit AS seuil_nb_inscrit_7, e0_.pre_titre AS pre_titre_8, e0_.post_titre AS post_titre_9, e0_.editorial AS editorial_10, e0_.programme AS programme_11, e0_.arrive AS arrive_12, e0_.has_badge AS has_badge_13, e0_.minisite AS minisite_14, e0_.domaine AS domaine_15, e0_.sub_domaine AS sub_domaine_16, e0_.icon AS icon_17, e0_.color AS color_18, e0_.header_nom AS header_nom_19, e0_.annulation_possible AS annulation_possible_20, e0_.commentaire_personne_active AS commentaire_personne_active_21, e0_.commentaire_personne_help AS commentaire_personne_help_22, e0_.badge_complement AS badge_complement_23, e0_.montant_non_remboursable AS montant_non_remboursable_24, e0_.comment_atelier AS comment_atelier_25, e0_.participant_fonction_facultative AS participant_fonction_facultative_26, e0_.send_email_admin_to_created_by AS send_email_admin_to_created_by_27, e0_.nom AS nom_28, e0_.description AS description_29, e0_.comment_form AS comment_form_30, e0_.comment_mail AS comment_mail_31, e0_.date_limite_annulation AS date_limite_annulation_32, e0_.date_limite_inscription AS date_limite_inscription_33, e0_.date_limite_remplacement AS date_limite_remplacement_34, e0_.specialite AS specialite_35, e0_.actif AS actif_36, e0_.nb_heures AS nb_heures_37, e0_.code_youtube AS code_youtube_38, e0_.montant_annulation AS montant_annulation_39, e0_.brochure_nom AS brochure_nom_40, e0_.image_nom AS image_nom_41, e0_.created_at AS created_at_42, e0_.updated_at AS updated_at_43, e0_.lieu_id AS lieu_id_44, e0_.organisateur_id AS organisateur_id_45, e0_.created_by_id AS created_by_id_46, e0_.updated_by_id AS updated_by_id_47 FROM evenement e0_ INNER JOIN organisateur o1_ ON e0_.organisateur_id = o1_.id LEFT JOIN evenement_coorga e2_ ON e0_.id = e2_.evenement_id LEFT JOIN organisateur o3_ ON e2_.coorga_id = o3_.id WHERE ((o1_.id = 1 OR o3_.id = 1)) AND (e0_.date_fin > CURRENT_DATE AND e0_.actif = 1)
Parameters:
[] |
|
0.93 ms (8.03%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.Adresse AS Adresse_4, t0.CodePostal AS CodePostal_5, t0.Ville AS Ville_6, t0.email AS email_7, t0.tel AS tel_8, t0.indications AS indications_9, t0.maplink AS maplink_10, t0.image_nom AS image_nom_11, t0.prefixe AS prefixe_12, t0.complement AS complement_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM lieu t0 WHERE t0.id = ?
Parameters:
[
22
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 2 |
| App\Entity\Organisateur | 1 |
| App\Entity\Dpo | 1 |
| App\Entity\Evenement | 1 |
| App\Entity\Lieu | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Evenement | No errors. |
| App\Entity\Lieu | No errors. |
| App\Entity\Organisateur | No errors. |
| App\Entity\User | No errors. |
| App\Entity\JourneesNationale | No errors. |
| App\Entity\Dpo | No errors. |
| App\Entity\Convention | No errors. |
| App\Entity\JourneesNationaleCoorga | No errors. |
| App\Entity\EvenementCoorga | No errors. |
| App\Entity\Etablissement | No errors. |
| App\Entity\Tarif | No errors. |
| App\Entity\Invite | No errors. |
| App\Entity\Atelier | No errors. |
| App\Entity\JourneesSessionPlage | No errors. |
| App\Entity\ProgrammeLigne | No errors. |
| App\Entity\EvenementOnglet | No errors. |
| App\Entity\Variable | No errors. |
| App\Entity\Salle | No errors. |