Query Metrics
41
Database Queries
9
Different statements
47.41 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.88 ms |
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:
[
6
]
|
2 | 0.57 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"032025"
]
|
3 | 3.15 ms |
SELECT t0_.code AS code_0, t0_.id AS id_1, l1_.id AS id_2, l1_.code AS code_3, p2_.nom AS nom_4, p2_.matricule AS matricule_5, p2_.prenom AS prenom_6 FROM lcontract l1_ INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id INNER JOIN tbulletin t0_ ON l1_.id = t0_.contract_id INNER JOIN ppiece p3_ ON t0_.piece_id = p3_.id WHERE t0_.dossier_id = ? AND t0_.dossier_id = ? AND t0_.periode_id = ? AND p3_.id = 1 AND t0_.active = 1
Parameters:
[ 43 43 46 ] |
4 | 2.92 ms |
SELECT t0_.code AS code_0, t0_.id AS id_1, l1_.id AS id_2, l1_.code AS code_3, p2_.nom AS nom_4, p2_.matricule AS matricule_5, p2_.prenom AS prenom_6 FROM lcontract l1_ INNER JOIN pemploye p2_ ON l1_.employe_id = p2_.id INNER JOIN tbulletin t0_ ON l1_.id = t0_.contract_id INNER JOIN ppiece p3_ ON t0_.piece_id = p3_.id WHERE t0_.dossier_id = ? AND t0_.dossier_id = ? AND t0_.periode_id = ? AND p3_.id = 1 AND t0_.active = 1 LIMIT 10
Parameters:
[ 43 43 46 ] |
5 | 1.42 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 535 46 ] |
6 | 0.95 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 535 46 ] |
7 | 0.68 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105736
]
|
8 | 0.55 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 535 ] |
9 | 2.09 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 1415 46 ] |
10 | 0.62 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 1415 46 ] |
11 | 1.24 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105737
]
|
12 | 0.44 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 1415 ] |
13 | 0.79 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 7976 46 ] |
14 | 0.78 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 7976 46 ] |
15 | 0.55 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105738
]
|
16 | 0.51 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 7976 ] |
17 | 0.70 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 8171 46 ] |
18 | 0.45 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 8171 46 ] |
19 | 1.52 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105739
]
|
20 | 0.85 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 8171 ] |
21 | 2.36 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 9021 46 ] |
22 | 2.11 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 9021 46 ] |
23 | 0.71 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105740
]
|
24 | 4.19 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 9021 ] |
25 | 2.27 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 1193 46 ] |
26 | 1.07 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 1193 46 ] |
27 | 1.08 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105741
]
|
28 | 0.87 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 1193 ] |
29 | 0.81 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 9642 46 ] |
30 | 0.46 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 9642 46 ] |
31 | 0.95 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105742
]
|
32 | 1.10 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 9642 ] |
33 | 0.73 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 9868 46 ] |
34 | 0.51 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 9868 46 ] |
35 | 0.75 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105743
]
|
36 | 0.75 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 9868 ] |
37 | 0.79 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(l2_.nombre_jours) AS sclr_2 FROM lelement_echeance l2_ INNER JOIN lcontract l0_ ON l2_.contract_id = l0_.id INNER JOIN periode p1_ ON l2_.periode_id = p1_.id WHERE l0_.id = ? AND l2_.periode_id = ? AND l2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 11151 46 ] |
38 | 0.74 ms |
SELECT l0_.id AS id_0, p1_.id AS id_1, sum(p2_.nombre_jour) AS sclr_2 FROM parret_travail_lg p2_ INNER JOIN parret_travail p3_ ON p2_.arret_travail_id = p3_.id INNER JOIN lcontract l0_ ON p3_.contract_id = l0_.id INNER JOIN periode p1_ ON p2_.periode_id = p1_.id WHERE l0_.id = ? AND p2_.periode_id = ? AND p3_.active = 1 AND p2_.active = 1 GROUP BY l0_.id, p1_.id
Parameters:
[ 11151 46 ] |
39 | 0.61 ms |
SELECT t0_.montant AS montant_0 FROM tbulletin t1_ INNER JOIN tbulletin_lg t0_ ON t1_.id = t0_.bulletin_id INNER JOIN prubrique p2_ ON t0_.rubrique_id = p2_.id WHERE (p2_.id = 5 OR p2_.id = 68) AND t1_.id = ? AND t0_.active = 1
Parameters:
[
105745
]
|
40 | 0.43 ms |
SELECT p0_.id AS id_0, p0_.resoudre AS resoudre_1, p0_.motif AS motif_2, p0_.periode_id AS periode_id_3, p0_.contract_id AS contract_id_4, p0_.element_echeance_id AS element_echeance_id_5, p0_.element_fixe_id AS element_fixe_id_6, p0_.prelevement_lg_id AS prelevement_lg_id_7 FROM probleme p0_ INNER JOIN lcontract l1_ ON p0_.contract_id = l1_.id WHERE p0_.periode_id = ? AND l1_.id = ? AND p0_.resoudre = 0
Parameters:
[ 46 11151 ] |
41 | 2.46 ms |
SELECT COUNT(l0_.id) AS sclr_0 FROM lcontract l0_ INNER JOIN tbulletin t1_ ON l0_.id = t1_.contract_id INNER JOIN ppiece p2_ ON t1_.piece_id = p2_.id WHERE t1_.dossier_id = ? AND t1_.active = 1 AND p2_.id = 1 AND t1_.periode_id = ?
Parameters:
[ 43 46 ] |
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\Periode | No errors. |
App\Entity\PArretTravailLg | No errors. |
App\Entity\LElementEcheance | No errors. |
App\Entity\Tbulletin |
|
App\Entity\PPrelevementLg | No errors. |
App\Entity\Probleme | No errors. |
App\Entity\PBordereau | No errors. |
App\Entity\SyntheseRemunarationCab | No errors. |
App\Entity\InjectRemuneration | No errors. |
App\Entity\LContract |
|
App\Entity\Pemploye |
|
App\Entity\PPiece | No errors. |
App\Entity\PArretTravail | No errors. |
App\Entity\TbulletinLg | No errors. |
App\Entity\Prubrique | No errors. |
App\Entity\LelementFixe | No errors. |