Redirect 303 redirect from GET @check_compte_user (10f68d)

GET https://dev.chevaux-assurances.fr/

Query Metrics

25 Database Queries
18 Different statements
67.78 ms Query time
0 Invalid entities
339 Managed entities

Grouped Statements

Show all queries

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