Query Metrics
5
Database Queries
5
Different statements
1.92 ms
Query time
8
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.53 ms (27.38%) |
1 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.firstname AS firstname_3, t0.numeroClient AS numeroClient_4, t0.civilite AS civilite_5, t0.lastname AS lastname_6, t0.birthday AS birthday_7, t0.deathday AS deathday_8, t0.gender AS gender_9, t0.email AS email_10, t0.phone AS phone_11, t0.comments AS comments_12, t0.suivi_client AS suivi_client_13, t0.room_number AS room_number_14, t0.building_room AS building_room_15, t0.stairs AS stairs_16, t0.nom_tuteur AS nom_tuteur_17, t0.civilite_tuteur AS civilite_tuteur_18, t0.prenom_tuteur AS prenom_tuteur_19, t0.email_tuteur AS email_tuteur_20, t0.email_notaire AS email_notaire_21, t0.num_tuteur AS num_tuteur_22, t0.type_tuteur AS type_tuteur_23, t0.days_of_week AS days_of_week_24, t0.comment_tuteur AS comment_tuteur_25, t0.consignes_client AS consignes_client_26, t0.status_prospect AS status_prospect_27, t0.profil_client AS profil_client_28, t0.address_tuteur AS address_tuteur_29, t0.address_tuteur2 AS address_tuteur2_30, t0.city_tuteur AS city_tuteur_31, t0.zipcode AS zipcode_32, t0.created AS created_33, t0.updated AS updated_34, t0.privacy_policy_accepted AS privacy_policy_accepted_35, t0.email_agreement AS email_agreement_36, t0.cgv_accepted AS cgv_accepted_37, t0.has_signed_easy_collect AS has_signed_easy_collect_38, t0.address_facturation AS address_facturation_39, t0.complement_adresse_facturation AS complement_adresse_facturation_40, t0.code_postal_facturation AS code_postal_facturation_41, t0.ville_facturation AS ville_facturation_42, t0.nom_facturation AS nom_facturation_43, t0.prenom_facturation AS prenom_facturation_44, t0.civilite_facturation AS civilite_facturation_45, t0.site_id AS site_id_46, t0.contact_id AS contact_id_47, t0.billing_infos_id AS billing_infos_id_48, t0.creator_id AS creator_id_49, t0.maj_id AS maj_id_50 FROM client t0 WHERE t0.id = ?
Parameters:
[
23612
]
|
0.39 ms (20.30%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.intervenant_id AS intervenant_id_5 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
594
]
|
0.37 ms (19.05%) |
1 |
SELECT t0.id AS id_1, t0.mode AS mode_2, t0.reference AS reference_3, t0.status AS status_4, t0.date AS date_5, t0.date_remise_chaque AS date_remise_chaque_6, t0.ttc AS ttc_7, t0.numero_remise AS numero_remise_8, t0.motif_cancel AS motif_cancel_9, t0.client_id AS client_id_10, t0.company_id AS company_id_11 FROM reglement t0 WHERE t0.id = ?
Parameters:
[
"79924"
]
|
0.35 ms (18.22%) |
1 |
SELECT t0.id AS id_1, t0.dateBilling AS dateBilling_2, t0.sendingDate AS sendingDate_3, t0.modeFacturation AS modeFacturation_4, t0.code AS code_5, t0.comment AS comment_6, t0.paidPaytweak AS paidPaytweak_7, t0.ht AS ht_8, t0.ttc AS ttc_9, t0.solde AS solde_10, t0.status AS status_11, t0.accompte AS accompte_12, t0.linkPaytweak AS linkPaytweak_13, t0.linkPaytweakExpire AS linkPaytweakExpire_14, t0.type AS type_15, t0.created AS created_16, t0.updated AS updated_17, t0.client_id AS client_id_18, t0.site_id AS site_id_19, t0.company_id AS company_id_20, t0.reglement_id AS reglement_id_21, t0.rdv_id AS rdv_id_22, t0.creator_id AS creator_id_23, t0.maj_id AS maj_id_24 FROM billing t0 WHERE t0.reglement_id = ?
Parameters:
[
79924
]
|
0.29 ms (15.05%) |
1 |
SELECT t0.id AS id_1, t0.billing_mode AS billing_mode_2, t0.date_signature_mandat AS date_signature_mandat_3, t0.email AS email_4, t0.phone AS phone_5, t0.discount AS discount_6, t0.send_mode AS send_mode_7, t0.pay_mode AS pay_mode_8, t0.esthetique AS esthetique_9, t0.account AS account_10, t0.bankName AS bankName_11, t0.iban AS iban_12, t0.bic AS bic_13, t0.rum AS rum_14, t0.company_id AS company_id_15 FROM billing_infos t0 WHERE t0.id = ?
Parameters:
[
25520
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User |
|
App\Entity\Intervenant |
|
App\Entity\Reglement | No errors. |
App\Entity\Client |
|
App\Entity\Company | No errors. |
App\Entity\Billing | No errors. |
App\Entity\Site |
|
App\Entity\Contact |
|
App\Entity\Client\BillingInfos | No errors. |
App\Entity\Contract |
|
App\Entity\Client\FamilyMember |
|
App\Entity\Recurrence | No errors. |
App\Entity\RDV |
|
App\Entity\BillingItem | No errors. |
App\Entity\RDVBilling | No errors. |