Query Metrics
4
Database Queries
3
Different statements
1.43 ms
Query time
0
Invalid entities
9
Managed entities
Grouped Statements
| 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. |