Query Metrics
7
Database Queries
6
Different statements
2.39 ms
Query time
3
Invalid entities
8
Managed entities
Queries
| #▲ | 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 |
|
| App\Entity\TypeDemande | No errors. |
| App\Entity\Attestation | No errors. |
| App\Entity\Pecheur |
|
| App\Entity\ModificationDemande |
|