Query Metrics
6
Database Queries
6
Different statements
3.92 ms
Query time
0
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.70 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.code AS code_4, t0.est_publie AS est_publie_5, t0.est_metier AS est_metier_6 FROM front_page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"home"
]
|
| 2 | 0.31 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 ORDER BY t0.ordre ASC
Parameters:
[] |
| 3 | 1.11 ms |
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:
[
7819
]
|
| 4 | 0.94 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.email AS email_4, t0.code_abomarque AS code_abomarque_5, t0.compte_cegid AS compte_cegid_6, t0.tvaintra AS tvaintra_7, t0.exonere_tva AS exonere_tva_8, t0.facebook AS facebook_9, t0.twitter AS twitter_10, t0.site_web AS site_web_11, t0.logo_accueil AS logo_accueil_12, t0.editeur_poche AS editeur_poche_13, t0.alias_electre AS alias_electre_14, t0.sarch_id AS sarch_id_15, t0.type_actif AS type_actif_16, t0.logo AS logo_17, t0.is_referent AS is_referent_18, t0.est_abonne AS est_abonne_19, t0.date_creation AS date_creation_20, t0.siret AS siret_21, t0.zone_geo AS zone_geo_22, t0.type_id AS type_id_23, t0.departement_id AS departement_id_24, t0.region_id AS region_id_25, t26.id AS id_27, t26.sujet AS sujet_28, t26.nom_exp AS nom_exp_29, t26.email_exp AS email_exp_30, t26.nom_retour AS nom_retour_31, t26.email_retour AS email_retour_32, t26.structure_id AS structure_id_33 FROM structure t0 LEFT JOIN client_cle_en_main t26 ON t26.structure_id = t0.id WHERE t0.id = ?
Parameters:
[
5730
]
|
| 5 | 0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.old_id AS old_id_3, t0.type_espace_pro_id AS type_espace_pro_id_4 FROM type_structure t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 6 | 0.58 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM type_espace_pro t0 WHERE t0.id = ?
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Genre | 8 |
| App\Entity\FrontPage | 1 |
| App\Entity\User | 1 |
| App\Entity\Client | 1 |
| App\Entity\Contact | 1 |
| App\Entity\Structure | 1 |
| App\Entity\NewsContact | 1 |
| App\Entity\TypeStructure | 1 |
| App\Entity\EspacePro\TypeEspacePro | 1 |