http://drh-fcz.ma/mouvement/prets/app_mouvement_prets_list?_=1750320114336&columns%5B0%5D%5Bdata%5D=id&columns%5B0%5D%5Bname%5D=p.id&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=code&columns%5B1%5D%5Bname%5D=p.code&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=contract_id&columns%5B2%5D%5Bname%5D=c.id&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=nom&columns%5B3%5D%5Bname%5D=emp.nom&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=rubrique&columns%5B4%5D%5Bname%5D=r.designation&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=created&columns%5B5%5D%5Bname%5D=p.created&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=montant&columns%5B6%5D%5Bname%5D=p.montant&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=nombreMois&columns%5B7%5D%5Bname%5D=p.nombreMois&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=motif&columns%5B8%5D%5Bname%5D=p.motif&columns%5B8%5D%5Bsearchable%5D=true&columns%5B8%5D%5Borderable%5D=true&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&draw=2&length=10&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=desc&search%5Bvalue%5D=&search%5Bregex%5D=false&start=0

Query Metrics

4 Database Queries
4 Different statements
5.36 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.27 ms
(42.35%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.40 ms
(26.04%)
1
SELECT p0_.id AS id_0, p0_.active AS active_1, l1_.id AS id_2, p0_.code AS code_3, p0_.created AS created_4, p2_.nom AS nom_5, p2_.prenom AS prenom_6, p3_.designation AS designation_7, p0_.montant AS montant_8, p0_.nombre_mois AS nombre_mois_9, p0_.motif AS motif_10 FROM pprelevement p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id INNER JOIN prubrique p3_ ON p0_.rubrique_id = p3_.id INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id INNER JOIN pdossier p4_ ON p0_.dossier_id = p4_.id WHERE p4_.id = ? ORDER BY p0_.id DESC
Parameters:
[
  66
]
1.19 ms
(22.28%)
1
SELECT p0_.id AS id_0, p0_.active AS active_1, l1_.id AS id_2, p0_.code AS code_3, p0_.created AS created_4, p2_.nom AS nom_5, p2_.prenom AS prenom_6, p3_.designation AS designation_7, p0_.montant AS montant_8, p0_.nombre_mois AS nombre_mois_9, p0_.motif AS motif_10 FROM pprelevement p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id INNER JOIN prubrique p3_ ON p0_.rubrique_id = p3_.id INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id INNER JOIN pdossier p4_ ON p0_.dossier_id = p4_.id WHERE p4_.id = ? ORDER BY p0_.id DESC LIMIT 10
Parameters:
[
  66
]
0.50 ms
(9.33%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM pprelevement p0_ WHERE p0_.dossier_id = ?
Parameters:
[
  66
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Users No errors.
App\Entity\PDossier No errors.
App\Entity\HonoraireDetFixe No errors.
App\Entity\TCnssA00 No errors.
App\Entity\PNotification No errors.
App\Entity\PPrelevement No errors.
App\Entity\LContract
  • The mappings App\Entity\LContract#lmatriculationCotis and App\Entity\LmatriculationCoti#contract_id are inconsistent with each other.
  • The mappings App\Entity\LContract#fonction and App\Entity\Pfonction#lContracts are inconsistent with each other.
  • The association App\Entity\LContract#tCnssA02s refers to the owning side field App\Entity\TCnssA02#LContract which does not exist.
App\Entity\Prubrique No errors.
App\Entity\Pemploye
  • The association App\Entity\Pemploye#situation_familiale_id refers to the inverse side field App\Entity\PsituationFamiliale#code which does not exist.
  • The field App\Entity\Pemploye#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LContract#employe does not contain the required 'inversedBy="contracts"' attribute.