Query Metrics
5
Database Queries
5
Different statements
8.80 ms
Query time
0
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.33 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.photo AS photo_7, t0.tel_mobile AS tel_mobile_8, t0.last_login AS last_login_9, t0.last_login_ip AS last_login_ip_10, t0.is_actif AS is_actif_11, t0.uuid AS uuid_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.site_id AS site_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
| 2 | 1.31 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.detail AS detail_3, t0.is_done AS is_done_4, t0.done_at AS done_at_5, t0.src_entity AS src_entity_6, t0.src_title AS src_title_7, t0.src_uuid AS src_uuid_8, t0.uuid AS uuid_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.src_type AS src_type_12, t0.site_id AS site_id_13, t0.user_id AS user_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM notification t0 WHERE t0.user_id = ? AND t0.is_done = ?
Parameters:
[ 2 0 ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.94 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.adresse1 AS adresse1_4, t0.adresse2 AS adresse2_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.siteweb AS siteweb_9, t0.email AS email_10, t0.tel AS tel_11, t0.effectif AS effectif_12, t0.siret AS siret_13, t0.numero_tva AS numero_tva_14, t0.pdf_footer AS pdf_footer_15, t0.wiki AS wiki_16, t0.dossier AS dossier_17, t0.logo AS logo_18, t0.devis_conditions AS devis_conditions_19, t0.devis_acompte_pourcent AS devis_acompte_pourcent_20, t0.devis_validation_montant_ttc AS devis_validation_montant_ttc_21, t0.devis_validators AS devis_validators_22, t0.devis_prefix AS devis_prefix_23, t0.devis_index_start AS devis_index_start_24, t0.options AS options_25, t0.is_restricted AS is_restricted_26, t0.restricted_at AS restricted_at_27, t0.is_actif AS is_actif_28, t0.infos AS infos_29, t0.uuid AS uuid_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.code_portefeuille AS code_portefeuille_33, t0.sign_infos AS sign_infos_34, t0.created_by_id AS created_by_id_35, t0.updated_by_id AS updated_by_id_36 FROM site t0 WHERE t0.uuid IS NULL LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 4 | 1.28 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type AS type_5, t0.categories AS categories_6, t0.civilite AS civilite_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.statut_juridique AS statut_juridique_10, t0.adresse1 AS adresse1_11, t0.adresse2 AS adresse2_12, t0.cp AS cp_13, t0.ville AS ville_14, t0.pays AS pays_15, t0.numero_client AS numero_client_16, t0.tel_mobile AS tel_mobile_17, t0.tel_fixe AS tel_fixe_18, t0.email AS email_19, t0.date_naissance AS date_naissance_20, t0.date_creation AS date_creation_21, t0.siret AS siret_22, t0.cni AS cni_23, t0.kbis AS kbis_24, t0.date_premier_contrat AS date_premier_contrat_25, t0.is_actif AS is_actif_26, t0.is_email AS is_email_27, t0.is_sms AS is_sms_28, t0.is_appel AS is_appel_29, t0.is_agri AS is_agri_30, t0.is_prospect AS is_prospect_31, t0.enseigne AS enseigne_32, t0.csp AS csp_33, t0.editing_at AS editing_at_34, t0.paiement_mode AS paiement_mode_35, t0.paiement_frequence AS paiement_frequence_36, t0.rum AS rum_37, t0.infos AS infos_38, t0.is_one_adhesion AS is_one_adhesion_39, t0.is_contentieux AS is_contentieux_40, t0.justif_dom AS justif_dom_41, t0.avis_imposition AS avis_imposition_42, t0.site_id AS site_id_43, t0.parrain_id AS parrain_id_44, t0.apporteur_id AS apporteur_id_45, t0.created_by_id AS created_by_id_46, t0.updated_by_id AS updated_by_id_47, t0.conseiller_id AS conseiller_id_48, t0.editing_by_id AS editing_by_id_49, t0.user_id AS user_id_50 FROM compte t0 WHERE t0.user_id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
| 5 | 3.94 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.type AS type_5, t0.categories AS categories_6, t0.civilite AS civilite_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.statut_juridique AS statut_juridique_10, t0.adresse1 AS adresse1_11, t0.adresse2 AS adresse2_12, t0.cp AS cp_13, t0.ville AS ville_14, t0.pays AS pays_15, t0.numero_client AS numero_client_16, t0.tel_mobile AS tel_mobile_17, t0.tel_fixe AS tel_fixe_18, t0.email AS email_19, t0.date_naissance AS date_naissance_20, t0.date_creation AS date_creation_21, t0.siret AS siret_22, t0.cni AS cni_23, t0.kbis AS kbis_24, t0.date_premier_contrat AS date_premier_contrat_25, t0.is_actif AS is_actif_26, t0.is_email AS is_email_27, t0.is_sms AS is_sms_28, t0.is_appel AS is_appel_29, t0.is_agri AS is_agri_30, t0.is_prospect AS is_prospect_31, t0.enseigne AS enseigne_32, t0.csp AS csp_33, t0.editing_at AS editing_at_34, t0.paiement_mode AS paiement_mode_35, t0.paiement_frequence AS paiement_frequence_36, t0.rum AS rum_37, t0.infos AS infos_38, t0.is_one_adhesion AS is_one_adhesion_39, t0.is_contentieux AS is_contentieux_40, t0.justif_dom AS justif_dom_41, t0.avis_imposition AS avis_imposition_42, t0.site_id AS site_id_43, t0.parrain_id AS parrain_id_44, t0.apporteur_id AS apporteur_id_45, t0.created_by_id AS created_by_id_46, t0.updated_by_id AS updated_by_id_47, t0.conseiller_id AS conseiller_id_48, t0.editing_by_id AS editing_by_id_49, t0.user_id AS user_id_50 FROM compte t0 WHERE t0.email = ?
Parameters:
[
"bnicolas@betterb.fr"
]
|
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\Notification | 7 |
| App\Entity\Base\User | 3 |
| App\Entity\Base\Site | 1 |
| App\Entity\Compte | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Base\User | No errors. |
| App\Entity\Base\Site | No errors. |
| App\Entity\Base\Ticket | No errors. |
| App\Entity\Devis | No errors. |
| App\Entity\Email | No errors. |
| App\Entity\Contrat | No errors. |
| App\Entity\Compte | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Base\UserSession | No errors. |
| App\Entity\CompteRelation | No errors. |
| App\Entity\Facture | No errors. |
| App\Entity\DevisCoPro | No errors. |
| App\Entity\Cheval | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\Echange | No errors. |
| App\Entity\CompteRib | No errors. |
| App\Entity\CompteCompta | No errors. |
| App\Entity\Paiement | No errors. |
| App\Entity\Sinistre | No errors. |
| App\Entity\Comptabilite | No errors. |
| App\Entity\IndAcc\ProduitIndAcc | No errors. |
| App\Entity\IndAcc\DevisIndAcc | No errors. |
| App\Entity\IndAcc\ContratIndAcc | No errors. |
| App\Entity\Fichier | No errors. |
| App\Entity\ContratLigne | No errors. |