GET https://pecheurs.abetari.be/assures/list

Response
200 OK
Browse referrer URL
IP
102.53.15.128
Profiled on
Token
dedbf3

Query Metrics

12 Database Queries
4 Different statements
8.09 ms Query time
3 Invalid entities
143 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.66 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.agence AS agence_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 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.21 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.is_active = ? ORDER BY t0.libelle ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.35 ms 
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_.type_structure AS type_structure_29, a2_.confederation_code AS confederation_code_30, a2_.sahara AS sahara_31, a2_.created_at AS created_at_32, a2_.modified_at AS modified_at_33, t3_.id AS id_34, t3_.libelle AS libelle_35, t3_.code AS code_36, t3_.is_active AS is_active_37, t3_.description AS description_38, t3_.libelle_ar AS libelle_ar_39, d0_.association_id AS association_id_40, d0_.type_demande_id AS type_demande_id_41, d0_.created_by_id AS created_by_id_42, d0_.assigned_agent_id AS assigned_agent_id_43, d0_.pecheur_id AS pecheur_id_44, a1_.demande_id AS demande_id_45 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 = ?) AND a2_.id = ? ORDER BY d0_.created_at DESC
Parameters: 
[
  "ACTIVE"
  "MODIFIED"
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.86 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: 
[
  7051
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.58 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: 
[
  6980
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.49 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: 
[
  6970
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.43 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: 
[
  6968
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.45 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: 
[
  6850
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.50 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: 
[
  6795
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.50 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: 
[
  6211
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.44 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: 
[
  5856
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.62 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: 
[
  3310
]
View formatted query    View runnable query    Explain query    View query backtrace

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 67
App\Entity\Attestation 58
App\Entity\ModificationDemande 8
App\Entity\TypeDemande 5
App\Entity\User 2
App\Entity\Pecheur 2
App\Entity\Association 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Association No errors.
App\Entity\TypeDemande 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\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.