Query Metrics
532
Database Queries
8
Different statements
591.12 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
566.20 ms (95.78%) |
507 |
SELECT CASE WHEN p0_.id = 1 THEN t1_.montant ELSE t1_.montant_devise END AS sclr_0 FROM tbulletin t2_ INNER JOIN tbulletin_lg t1_ ON t2_.id = t1_.bulletin_id INNER JOIN prubrique p3_ ON t1_.rubrique_id = p3_.id INNER JOIN pbordereau p4_ ON t2_.bordereau_id = p4_.id INNER JOIN pdevise p0_ ON p4_.devise_id = p0_.id WHERE (p3_.id = 5 OR p3_.id = 68) AND t2_.id = ? AND t1_.active = 1
Parameters:
[
107095
]
|
10.61 ms (1.79%) |
10 |
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?
Parameters:
[
7293
]
|
6.26 ms (1.06%) |
10 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?
Parameters:
[
7293
]
|
2.89 ms (0.49%) |
1 |
SELECT p0_.id AS id_0, p1_.designation AS designation_1, p2_.designation AS designation_2, p3_.designation AS designation_3, p4_.abreviation AS abreviation_4, p0_.code AS code_5, p0_.created AS created_6, p0_.type AS type_7, p5_.designation AS designation_8, p6_.designation AS designation_9, p6_.icon AS icon_10 FROM pbordereau p0_ INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id INNER JOIN periode p4_ ON p0_.periode_id = p4_.id INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id WHERE p0_.active = 1 AND p0_.periode_id = ? AND p1_.id = ? ORDER BY p3_.designation DESC
Parameters:
[ 46 3 ] |
1.72 ms (0.29%) |
1 |
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"
]
|
1.58 ms (0.27%) |
1 |
SELECT p0_.id AS id_0, p1_.designation AS designation_1, p2_.designation AS designation_2, p3_.designation AS designation_3, p4_.abreviation AS abreviation_4, p0_.code AS code_5, p0_.created AS created_6, p0_.type AS type_7, p5_.designation AS designation_8, p6_.designation AS designation_9, p6_.icon AS icon_10 FROM pbordereau p0_ INNER JOIN pstatut p6_ ON p0_.statut_id = p6_.id INNER JOIN periode p4_ ON p0_.periode_id = p4_.id INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id INNER JOIN pdevise p3_ ON p0_.devise_id = p3_.id INNER JOIN ppaiement p2_ ON p0_.paiement_id = p2_.id LEFT JOIN pnature_contract p5_ ON p0_.nature_contract_id = p5_.id WHERE p0_.active = 1 AND p0_.periode_id = ? AND p1_.id = ? ORDER BY p0_.id DESC LIMIT 10
Parameters:
[ 46 3 ] |
1.15 ms (0.19%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM pbordereau p0_ INNER JOIN pdossier p1_ ON p0_.dossier_id = p1_.id WHERE p0_.active = 1 AND p0_.periode_id = ? AND p1_.id = ?
Parameters:
[ 46 3 ] |
0.71 ms (0.12%) |
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
]
|
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\PStatut | No errors. |
App\Entity\PDevise | No errors. |
App\Entity\PPaiement | No errors. |
App\Entity\PnatureContract | No errors. |
App\Entity\PPiece | No errors. |
App\Entity\Prubrique | No errors. |
App\Entity\CabBordereau | No errors. |
App\Entity\LContract |
|
App\Entity\TbulletinLg | No errors. |
App\Entity\JournalBulletinLg | No errors. |
App\Entity\ContractNetTheorique | No errors. |