GET https://pecheurs.abetari.be/attestation-assurance-individuel/6496

Query Metrics

7 Database Queries
6 Different statements
2.39 ms Query time
3 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.contact_telephone AS contact_telephone_6, t0.contact_nom AS contact_nom_7, t0.ville AS ville_8, t0.created_at AS created_at_9, t0.modified_at AS modified_at_10, t0.association_id AS association_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  26
]
2 0.63 ms
SELECT t0.id AS id_1, t0.adherent AS adherent_2, t0.nom_barque AS nom_barque_3, t0.numero_immatriculation AS numero_immatriculation_4, t0.mode_paiement AS mode_paiement_5, t0.nombre_pecheurs AS nombre_pecheurs_6, t0.date_effet AS date_effet_7, t0.date_fin_effet AS date_fin_effet_8, t0.statut AS statut_9, t0.numero_cin AS numero_cin_10, t0.created_at AS created_at_11, t0.modified_at AS modified_at_12, t0.association_id AS association_id_13, t0.type_demande_id AS type_demande_id_14, t0.created_by_id AS created_by_id_15, t16.id AS id_17, t16.numero AS numero_18, t16.date_emission AS date_emission_19, t16.fichier_path AS fichier_path_20, t16.statut AS statut_21, t16.created_at AS created_at_22, t16.modified_at AS modified_at_23, t16.demande_id AS demande_id_24, t0.pecheur_id AS pecheur_id_25 FROM demande t0 LEFT JOIN attestation t16 ON t16.demande_id = t0.id WHERE t0.id = ?
Parameters:
[
  "6496"
]
3 0.15 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.is_active AS is_active_4, t0.description AS description_5, t0.libelle_ar AS libelle_ar_6 FROM type_demande t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.15 ms
SELECT t0.id AS id_1, t0.adherent_avant AS adherent_avant_2, t0.adherent_apres AS adherent_apres_3, t0.nom_barque_avant AS nom_barque_avant_4, t0.nom_barque_apres AS nom_barque_apres_5, t0.immatriculation_avant AS immatriculation_avant_6, t0.immatriculation_apres AS immatriculation_apres_7, t0.pecheurs_avant AS pecheurs_avant_8, t0.pecheurs_apres AS pecheurs_apres_9, t0.mode_paiement_avant AS mode_paiement_avant_10, t0.mode_paiement_apres AS mode_paiement_apres_11, t0.conge_police_path AS conge_police_path_12, t0.date_modification AS date_modification_13, t0.numero_cin_avant AS numero_cin_avant_14, t0.numero_cin_apres AS numero_cin_apres_15, t0.impacte_prime AS impacte_prime_16, t0.attestation_originale_id AS attestation_originale_id_17, t0.demande_id AS demande_id_18, t0.attestation_nouvelle_id AS attestation_nouvelle_id_19 FROM modification_demande t0 WHERE t0.demande_id = ?
Parameters:
[
  6496
]
5 0.37 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.date_emission AS date_emission_3, t0.fichier_path AS fichier_path_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.demande_id AS demande_id_8 FROM attestation t0 WHERE t0.id = ?
Parameters:
[
  4930
]
6 0.18 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.contact_nom AS contact_nom_6, t0.contact_email AS contact_email_7, t0.contact_telephone AS contact_telephone_8, t0.status AS status_9, t0.numero_police AS numero_police_10, t0.sahara AS sahara_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13 FROM association t0 WHERE t0.id = ?
Parameters:
[
  17
]
7 0.43 ms
SELECT t0.id AS id_1, t0.adherent AS adherent_2, t0.nom_barque AS nom_barque_3, t0.numero_immatriculation AS numero_immatriculation_4, t0.mode_paiement AS mode_paiement_5, t0.nombre_pecheurs AS nombre_pecheurs_6, t0.date_effet AS date_effet_7, t0.date_fin_effet AS date_fin_effet_8, t0.statut AS statut_9, t0.numero_cin AS numero_cin_10, t0.created_at AS created_at_11, t0.modified_at AS modified_at_12, t0.association_id AS association_id_13, t0.type_demande_id AS type_demande_id_14, t0.created_by_id AS created_by_id_15, t16.id AS id_17, t16.numero AS numero_18, t16.date_emission AS date_emission_19, t16.fichier_path AS fichier_path_20, t16.statut AS statut_21, t16.created_at AS created_at_22, t16.modified_at AS modified_at_23, t16.demande_id AS demande_id_24, t0.pecheur_id AS pecheur_id_25 FROM demande t0 LEFT JOIN attestation t16 ON t16.demande_id = t0.id WHERE t0.id = ?
Parameters:
[
  5114
]

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\Demande 2
App\Entity\TypeDemande 2
App\Entity\User 1
App\Entity\Association 1
App\Entity\ModificationDemande 1
App\Entity\Attestation 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Association No errors.
App\Entity\Demande
  • The field App\Entity\Demande#modifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ModificationDemande#demande does not contain the required 'inversedBy: "modifications"' attribute.
App\Entity\TypeDemande No errors.
App\Entity\Attestation No errors.
App\Entity\Pecheur
  • The association App\Entity\Pecheur#association refers to the inverse side field App\Entity\Association#assures which does not exist.
App\Entity\ModificationDemande
  • The association App\Entity\ModificationDemande#attestationOriginale refers to the inverse side field App\Entity\Attestation#modifications which does not exist.