Query Metrics

4 Database Queries
3 Different statements
1.43 ms Query time
0 Invalid entities
9 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.68 ms
(47.86%)
1
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.roles AS roles_3, t0.email AS email_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.password AS password_9, t0.enabled AS enabled_10, t0.date_creation AS date_creation_11, t0.token_api AS token_api_12, t13.id AS id_14, t13.nom AS nom_15, t13.prenom AS prenom_16, t13.telephone AS telephone_17, t13.code_abomarque AS code_abomarque_18, t13.commentaire AS commentaire_19, t13.facebook AS facebook_20, t13.twitter AS twitter_21, t13.email AS email_22, t13.old_id AS old_id_23, t13.civilite AS civilite_24, t13.old_userid AS old_userid_25, t13.actif AS actif_26, t13.bio AS bio_27, t13.has_photo AS has_photo_28, t13.is_referent AS is_referent_29, t13.date_creation AS date_creation_30, t13.receive_nmardi AS receive_nmardi_31, t13.receive_nvendredi AS receive_nvendredi_32, t13.receive_ireseau AS receive_ireseau_33, t13.structure_id AS structure_id_34, t13.adresse_id AS adresse_id_35, t13.utilisateur_id AS utilisateur_id_36, t13.news_contact_id AS news_contact_id_37, t0.client_id AS client_id_38 FROM user t0 LEFT JOIN contact t13 ON t13.utilisateur_id = t0.id WHERE t0.id = ?
Parameters:
[
  14361
]
0.45 ms
(31.58%)
2
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM type_espace_pro t0
Parameters:
[]
0.29 ms
(20.56%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte_explicatif AS texte_explicatif_3, t0.actif AS actif_4, t0.date AS date_5, t0.slug AS slug_6, t0.lieu AS lieu_7, t0.repartition_pro AS repartition_pro_8, t0.nb_max_peronnes AS nb_max_peronnes_9, t0.critere_inscrit AS critere_inscrit_10, t0.lib_contenu AS lib_contenu_11, t0.bib_abonnee AS bib_abonnee_12, t0.lib_dif AS lib_dif_13, t0.type_jp AS type_jp_14, t0.heure_debut AS heure_debut_15, t0.heure_fin AS heure_fin_16, t0.image_badge AS image_badge_17, t0.display_corner_editeur AS display_corner_editeur_18, t0.illustration AS illustration_19, t0.video AS video_20, t0.programme AS programme_21, t0.livret AS livret_22, t0.active_chapitrage AS active_chapitrage_23, t0.chapitrage_category AS chapitrage_category_24, t0.date_badge AS date_badge_25, t0.page_id AS page_id_26 FROM journee_pro t0 WHERE t0.id = ?
Parameters:
[
  "92"
]

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\EspacePro\TypeEspacePro 3
App\Entity\User 1
App\Entity\Client 1
App\Entity\Contact 1
App\Entity\Structure 1
App\Entity\NewsContact 1
App\Entity\JourneePro 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Contact No errors.
App\Entity\Structure No errors.
App\Entity\Adresse No errors.
App\Entity\NewsContact No errors.
App\Entity\Client No errors.
App\Entity\Livre No errors.
App\Entity\Avis No errors.
App\Entity\Chronique No errors.
App\Entity\MEL No errors.
App\Entity\Newsletter No errors.
App\Entity\InscritJP No errors.
App\Entity\Vote No errors.
App\Entity\InscritAct No errors.
App\Entity\VieLibraire No errors.
App\Entity\SI\CRM\MessageCom No errors.
App\Entity\EspacePro\Nomines No errors.
App\Entity\SI\CRM\TypeCom No errors.
App\Entity\Prix\ParticipantPrix No errors.
App\Entity\Meta\MetaStructure No errors.
App\Entity\JourneePro No errors.
App\Entity\Page No errors.
App\Entity\TypeStructure No errors.
App\Entity\RepartitionPro No errors.
App\Entity\JProEditeur No errors.
App\Entity\EspacePro\ProPage No errors.
App\Entity\EspacePro\TypeEspacePro No errors.
App\Entity\EspacePro\Actualite No errors.
App\Entity\Departement No errors.
App\Entity\Region No errors.
App\Entity\Contrat No errors.
App\Entity\Diffusion No errors.
App\Entity\ClientCleEnMain No errors.
App\Entity\NewsGroupe No errors.
App\Entity\Abonnement No errors.
App\Entity\Paiement\Transaction No errors.
App\Entity\Genre No errors.
App\Entity\TypeLivre No errors.
App\Entity\NiveauLivre No errors.
App\Entity\Auteur No errors.
App\Entity\ThemeLivre No errors.
App\Entity\Distributeur No errors.
App\Entity\Editeur No errors.
App\Entity\Revue No errors.
App\Entity\Etiquette No errors.
App\Entity\EcrivainVoyageur No errors.
App\Entity\Categorie No errors.
App\Entity\Envie No errors.
App\Entity\PhotoExtended No errors.
App\Entity\Jeu\PetitsPapiers No errors.
App\Entity\Prix\Prix No errors.
App\Entity\ChroniqueTexte No errors.
App\Entity\NewsletterActus No errors.
App\Entity\EspaceNewsletterLibraire\NewsletterLibrairie No errors.
App\Entity\Filter\DestinataireFilter No errors.
App\Entity\Newsletter\NewsletterBlock No errors.
App\Entity\EvtVote No errors.
App\Entity\Activite No errors.
App\Entity\SI\CRM\Expediteur No errors.
App\Entity\EspacePro\Election No errors.
App\Entity\Meta\GroupeMetaStructure No errors.
App\Entity\ContentBlock No errors.
App\Entity\CampagneVote No errors.
App\Entity\EspacePro\ProModule No errors.
App\Entity\EspacePro\TypePagePro No errors.
App\Entity\EspacePro\ActuBlocContenu No errors.