Query Metrics
368
Database Queries
5
Different statements
213.75 ms
Query time
3
Invalid entities
9633
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
109.08 ms (51.03%) |
1 |
SELECT d0_.id AS id_0, d0_.adherent AS adherent_1, d0_.nom_barque AS nom_barque_2, d0_.numero_immatriculation AS numero_immatriculation_3, d0_.mode_paiement AS mode_paiement_4, d0_.nombre_pecheurs AS nombre_pecheurs_5, d0_.date_effet AS date_effet_6, d0_.date_fin_effet AS date_fin_effet_7, d0_.statut AS statut_8, d0_.numero_cin AS numero_cin_9, d0_.created_at AS created_at_10, d0_.modified_at AS modified_at_11, a1_.id AS id_12, a1_.numero AS numero_13, a1_.date_emission AS date_emission_14, a1_.fichier_path AS fichier_path_15, a1_.statut AS statut_16, a1_.created_at AS created_at_17, a1_.modified_at AS modified_at_18, a2_.id AS id_19, a2_.code AS code_20, a2_.nom AS nom_21, a2_.adresse AS adresse_22, a2_.ville AS ville_23, a2_.contact_nom AS contact_nom_24, a2_.contact_email AS contact_email_25, a2_.contact_telephone AS contact_telephone_26, a2_.status AS status_27, a2_.numero_police AS numero_police_28, a2_.sahara AS sahara_29, a2_.created_at AS created_at_30, a2_.modified_at AS modified_at_31, t3_.id AS id_32, t3_.libelle AS libelle_33, t3_.code AS code_34, t3_.is_active AS is_active_35, t3_.description AS description_36, t3_.libelle_ar AS libelle_ar_37, d0_.association_id AS association_id_38, d0_.type_demande_id AS type_demande_id_39, d0_.created_by_id AS created_by_id_40, d0_.pecheur_id AS pecheur_id_41, a1_.demande_id AS demande_id_42 FROM demande d0_ LEFT JOIN attestation a1_ ON d0_.id = a1_.demande_id INNER JOIN association a2_ ON d0_.association_id = a2_.id INNER JOIN type_demande t3_ ON d0_.type_demande_id = t3_.id WHERE d0_.statut = ? OR d0_.statut = ? ORDER BY d0_.created_at DESC
Parameters:
[ "ACTIVE" "MODIFIED" ]
|
||||||||||||||||||||||||||||||||
|
57.52 ms (26.91%) |
159 |
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:
[
4772
]
|
||||||||||||||||||||||||||||||||
|
35.90 ms (16.79%) |
159 |
SELECT m0_.id AS id_0, m0_.adherent_avant AS adherent_avant_1, m0_.adherent_apres AS adherent_apres_2, m0_.nom_barque_avant AS nom_barque_avant_3, m0_.nom_barque_apres AS nom_barque_apres_4, m0_.immatriculation_avant AS immatriculation_avant_5, m0_.immatriculation_apres AS immatriculation_apres_6, m0_.pecheurs_avant AS pecheurs_avant_7, m0_.pecheurs_apres AS pecheurs_apres_8, m0_.mode_paiement_avant AS mode_paiement_avant_9, m0_.mode_paiement_apres AS mode_paiement_apres_10, m0_.conge_police_path AS conge_police_path_11, m0_.date_modification AS date_modification_12, m0_.numero_cin_avant AS numero_cin_avant_13, m0_.numero_cin_apres AS numero_cin_apres_14, m0_.impacte_prime AS impacte_prime_15, m0_.attestation_originale_id AS attestation_originale_id_16, m0_.demande_id AS demande_id_17, m0_.attestation_nouvelle_id AS attestation_nouvelle_id_18 FROM modification_demande m0_ WHERE m0_.demande_id = ?
Parameters:
[
4772
]
|
||||||||||||||||||||||||||||||||
|
11.10 ms (5.19%) |
48 |
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:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.16 ms (0.07%) |
1 |
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.is_active = ? ORDER BY t0.libelle ASC
Parameters:
[
1
]
|
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 | 4687 |
| App\Entity\Attestation | 4524 |
| App\Entity\Pecheur | 160 |
| App\Entity\ModificationDemande | 159 |
| App\Entity\Association | 51 |
| App\Entity\User | 48 |
| App\Entity\TypeDemande | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Association | No errors. |
| App\Entity\TypeDemande | No errors. |
| App\Entity\Demande |
|
| App\Entity\Attestation | No errors. |
| App\Entity\Pecheur |
|
| App\Entity\ModificationDemande |
|