Query Metrics
25
Database Queries
18
Different statements
67.78 ms
Query time
0
Invalid entities
339
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
10.68 ms (15.76%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM contrat_ligne c0_ LEFT JOIN devis_ligne d1_ ON c0_.devis_ligne_id = d1_.id WHERE c0_.site_id = ? AND d1_.declaration_sante IS NULL
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
9.16 ms (13.51%) |
2 |
SELECT d0_.id AS id_0, d0_.origine AS origine_1, d0_.code AS code_2, d0_.nom AS nom_3, d0_.date AS date_4, d0_.echeance AS echeance_5, d0_.statut AS statut_6, d0_.is_done AS is_done_7, d0_.done_at AS done_at_8, d0_.is_denied AS is_denied_9, d0_.denied_raison AS denied_raison_10, d0_.is_accepted AS is_accepted_11, d0_.uuid AS uuid_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.pdf AS pdf_15, d0_.conditions AS conditions_16, d0_.envoi_date AS envoi_date_17, d0_.envoi_mode AS envoi_mode_18, d0_.frequence_paiement AS frequence_paiement_19, d0_.montant AS montant_20, d0_.is_pdf_locked AS is_pdf_locked_21, d0_.infos AS infos_22, d0_.paiement_mode AS paiement_mode_23, d0_.signed_at AS signed_at_24, d0_.pdf_ini AS pdf_ini_25, d0_.is_ta AS is_ta_26, d0_.ta_montant AS ta_montant_27, d0_.type AS type_28, d0_.signed_infos AS signed_infos_29, d0_.site_id AS site_id_30, d0_.conseiller_id AS conseiller_id_31, d0_.compte_id AS compte_id_32, d0_.created_by_id AS created_by_id_33, d0_.updated_by_id AS updated_by_id_34, d0_.devis_deny_id AS devis_deny_id_35, d0_.compagnie_id AS compagnie_id_36 FROM devis d0_ WHERE d0_.site_id = ? AND (d0_.date BETWEEN ? AND ?) ORDER BY d0_.date ASC
Parameters:
[ 1 "2026-02-01" "2026-02-28" ]
|
||||||||||||||||||||||||||||||||
|
8.12 ms (11.98%) |
3 |
SELECT COUNT(e0_.id) AS sclr_0 FROM echange e0_ WHERE e0_.site_id = ? AND e0_.type = ? AND e0_.is_done = ?
Parameters:
[ 1 "expert-avis" 0 ]
|
||||||||||||||||||||||||||||||||
|
6.22 ms (9.18%) |
2 |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.numero_police AS numero_police_2, c0_.date AS date_3, c0_.date_fin AS date_fin_4, c0_.nom AS nom_5, c0_.detail AS detail_6, c0_.document AS document_7, c0_.statut AS statut_8, c0_.is_done AS is_done_9, c0_.prime_ttc AS prime_ttc_10, c0_.uuid AS uuid_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.is_paid AS is_paid_14, c0_.is_contentieux AS is_contentieux_15, c0_.frequence_paiement AS frequence_paiement_16, c0_.type AS type_17, c0_.infos AS infos_18, c0_.paiement_mode AS paiement_mode_19, c0_.signed_at AS signed_at_20, c0_.document_ini AS document_ini_21, c0_.ta_montant AS ta_montant_22, c0_.ta_paid_at AS ta_paid_at_23, c0_.code_index AS code_index_24, c0_.signed_infos AS signed_infos_25, c0_.numero_avenant AS numero_avenant_26, c0_.pdf_recap AS pdf_recap_27, c0_.date_debut AS date_debut_28, c0_.site_id AS site_id_29, c0_.compte_id AS compte_id_30, c0_.devis_id AS devis_id_31, c0_.conseiller_id AS conseiller_id_32, c0_.created_by_id AS created_by_id_33, c0_.updated_by_id AS updated_by_id_34, c0_.compagnie_id AS compagnie_id_35, c0_.parrain_id AS parrain_id_36, c0_.apporteur_id AS apporteur_id_37, c0_.paiement_rib_id AS paiement_rib_id_38 FROM contrat c0_ WHERE c0_.site_id = ? AND (c0_.date BETWEEN ? AND ?) ORDER BY c0_.date ASC
Parameters:
[ 1 "2026-02-01" "2026-02-28" ]
|
||||||||||||||||||||||||||||||||
|
5.50 ms (8.12%) |
3 |
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.site_id = ? AND n0_.src_entity = ? AND n0_.src_type = ? AND n0_.is_done = ?
Parameters:
[ 1 "echange" "expert-avis" 0 ]
|
||||||||||||||||||||||||||||||||
|
5.16 ms (7.61%) |
1 |
SELECT COUNT(d0_.id) AS sclr_0 FROM devis d0_ WHERE d0_.site_id = ? AND (d0_.signed_at IS NULL AND d0_.statut = ?)
Parameters:
[ 1 "accepted" ]
|
||||||||||||||||||||||||||||||||
|
4.94 ms (7.29%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM contrat_ligne c0_ LEFT JOIN devis_ligne d1_ ON c0_.devis_ligne_id = d1_.id WHERE c0_.site_id = ? AND d1_.certificat_veto IS NULL
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.72 ms (4.01%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM contrat c0_ WHERE c0_.site_id = ? AND c0_.conseiller_id = ?
Parameters:
[ 1 2 ]
|
||||||||||||||||||||||||||||||||
|
2.67 ms (3.95%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM contrat c0_ WHERE c0_.site_id = ? AND c0_.signed_at IS NULL
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.62 ms (3.87%) |
1 |
SELECT t0.id AS id_1, t0.origine AS origine_2, t0.code AS code_3, t0.nom AS nom_4, t0.date AS date_5, t0.echeance AS echeance_6, t0.statut AS statut_7, t0.is_done AS is_done_8, t0.done_at AS done_at_9, t0.is_denied AS is_denied_10, t0.denied_raison AS denied_raison_11, t0.is_accepted AS is_accepted_12, t0.uuid AS uuid_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.pdf AS pdf_16, t0.conditions AS conditions_17, t0.envoi_date AS envoi_date_18, t0.envoi_mode AS envoi_mode_19, t0.frequence_paiement AS frequence_paiement_20, t0.montant AS montant_21, t0.is_pdf_locked AS is_pdf_locked_22, t0.infos AS infos_23, t0.paiement_mode AS paiement_mode_24, t0.signed_at AS signed_at_25, t0.pdf_ini AS pdf_ini_26, t0.is_ta AS is_ta_27, t0.ta_montant AS ta_montant_28, t0.type AS type_29, t0.signed_infos AS signed_infos_30, t0.site_id AS site_id_31, t0.conseiller_id AS conseiller_id_32, t0.compte_id AS compte_id_33, t0.created_by_id AS created_by_id_34, t0.updated_by_id AS updated_by_id_35, t0.devis_deny_id AS devis_deny_id_36, t0.compagnie_id AS compagnie_id_37 FROM devis t0 WHERE t0.site_id = ? AND t0.conseiller_id = ? AND t0.is_done = ?
Parameters:
[ 1 2 0 ]
|
||||||||||||||||||||||||||||||||
|
2.01 ms (2.96%) |
2 |
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 ]
|
||||||||||||||||||||||||||||||||
|
1.81 ms (2.67%) |
1 |
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.nom AS nom_2, t0_.type AS type_3, t0_.detail AS detail_4, t0_.reponse AS reponse_5, t0_.statut AS statut_6, t0_.route AS route_7, t0_.is_done AS is_done_8, t0_.is_to_invoice AS is_to_invoice_9, t0_.is_invoiced AS is_invoiced_10, t0_.is_validated AS is_validated_11, t0_.is_validation_email AS is_validation_email_12, t0_.is_user_ticket_validator AS is_user_ticket_validator_13, t0_.validation_at AS validation_at_14, t0_.duree_estime AS duree_estime_15, t0_.duree_reel AS duree_reel_16, t0_.uuid AS uuid_17, t0_.created_at AS created_at_18, t0_.updated_at AS updated_at_19, t0_.site_id AS site_id_20, t0_.user_id AS user_id_21, t0_.validation_by_id AS validation_by_id_22, t0_.created_by_id AS created_by_id_23, t0_.updated_by_id AS updated_by_id_24 FROM ticket t0_ WHERE t0_.user_id = ? AND t0_.is_done = 0 ORDER BY t0_.is_done DESC, t0_.created_at DESC
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
|
1.35 ms (1.99%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM compte c0_ WHERE c0_.site_id = ? AND c0_.is_actif = 1 AND c0_.conseiller_id = ?
Parameters:
[ 1 2 ]
|
||||||||||||||||||||||||||||||||
|
1.33 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.detail AS detail_4, t0.echeance AS echeance_5, t0.priorite AS priorite_6, t0.statut AS statut_7, t0.is_done AS is_done_8, t0.done_at AS done_at_9, t0.uuid AS uuid_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.site_id AS site_id_13, t0.emetteur_id AS emetteur_id_14, t0.pilote_id AS pilote_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM tache t0 WHERE t0.site_id = ? AND t0.is_done = ?
Parameters:
[ 1 0 ]
|
||||||||||||||||||||||||||||||||
|
1.17 ms (1.73%) |
1 |
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.site_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.85 ms (1.26%) |
1 |
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.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.73 ms (1.07%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||
|
0.73 ms (1.07%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.detail AS detail_4, t0.echeance AS echeance_5, t0.priorite AS priorite_6, t0.statut AS statut_7, t0.is_done AS is_done_8, t0.done_at AS done_at_9, t0.uuid AS uuid_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.site_id AS site_id_13, t0.emetteur_id AS emetteur_id_14, t0.pilote_id AS pilote_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM tache t0 WHERE t0.pilote_id = ? AND t0.is_done = ?
Parameters:
[ 2 0 ]
|
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\Devis | 139 |
| App\Entity\Compte | 107 |
| App\Entity\Contrat | 69 |
| App\Entity\Base\User | 12 |
| App\Entity\Notification | 7 |
| App\Entity\DevisDeny | 2 |
| App\Entity\Base\Site | 1 |
| App\Entity\Tache | 1 |
| App\Entity\Base\Ticket | 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\DevisDeny | No errors. |
| App\Entity\DevisLigne | No errors. |
| App\Entity\Echange | No errors. |
| App\Entity\ContratLigne | No errors. |
| App\Entity\Tache | No errors. |
| App\Entity\CompteRib | No errors. |
| App\Entity\FactureLigne | No errors. |
| App\Entity\Cheval | No errors. |
| App\Entity\Produit | No errors. |
| App\Entity\EmailDoc | No errors. |
| App\Entity\EmailAttachment | No errors. |
| App\Entity\Facture | No errors. |
| App\Entity\Liste | No errors. |
| App\Entity\Sinistre | No errors. |
| App\Entity\EmailContent | No errors. |
| App\Entity\IndAcc\ProduitIndAcc | No errors. |