http://drh-fcz.ma/reporting/extraction/app_reporting_extraction_masse_salariale/2025-03

Method
GET
HTTP Status
200
IP
172.70.108.55
Profiled on
Token
8f6e1b

Query Metrics

3 Database Queries
3 Different statements
7026.86 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.55 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: 
[
  11
]
View formatted query    View runnable query    Explain query
2 0.49 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"
]
View formatted query    View runnable query    Explain query
3 7025.82 ms 
SELECT pdossier.id as id_dossier, pdossier.designation as dossier, pfcy.id as id_fcy, pfcy.fcy0, pfcy.fcy0_libelle,pemploye.id as employe_id, lcontract.id as id_contract, pemploye.nom, pemploye.prenom,
            pnature_contract.designation as nature_contrat, pemploye.cin, tbulletin.code as bulletin,prubrique.designation as element, tbulletin_lg.montant, tbulletin_lg.montant_devise, tbulletin_lg.sens,
            ppiece.designation as type, pbareme_type.designation as type_bareme, pfonction.designation as fonction, lcontract.date_anciennete , tbulletin_lg.id,pbordereau.id as id_bordereau, pbordereau.code as bordereau, pbordereau.observation as bordereau_observation,ppaiement.designation as paiement, pbordereau.date_integration
            
            FROM tbulletin_lg
            INNER JOIN tbulletin on tbulletin.id = tbulletin_lg.bulletin_id
            INNER JOIN ppiece on ppiece.id = tbulletin.piece_id
            INNER JOIN lcontract on lcontract.id = tbulletin.contract_id
            INNER JOIN pbordereau on pbordereau.id = tbulletin.bordereau_id
            INNER JOIN pbareme on lcontract.bareme_id = pbareme.id
            INNER JOIN pbareme_type on pbareme.bareme_type_id = pbareme_type.id
            INNER JOIN pdossier on pdossier.id = pbordereau.dossier_id
            INNER JOIN pemploye on pemploye.id = lcontract.employe_id
            INNER JOIN prubrique on prubrique.id = tbulletin_lg.rubrique_id
            INNER JOIN ppaiement on ppaiement.id = pbordereau.paiement_id

            LEFT JOIN pfonction on pfonction.id = lcontract.fonction_id
            LEFT JOIN pnature_contract on pnature_contract.id = pbordereau.nature_contract_id
            LEFT JOIN pfcy on pfcy.id = pdossier.fcy_id

            where  tbulletin.periode_id = 46  and tbulletin.active = 1 and tbulletin_lg.active = 1 and pbordereau.active = 1 

            UNION

            SELECT pdossier.id as id_dossier, pdossier.designation as dossier, pfcy.id as id_fcy, pfcy.fcy0, pfcy.fcy0_libelle, pemploye.id as employe_id, lcontract.id as id_contract, pemploye.nom, pemploye.prenom,
            pnature_contract.designation as nature_contrat, pemploye.cin, tbulletin.code as bulletin, 'brute calculé' as element, sum(tbulletin_lg.montant) as montant, sum(tbulletin_lg.montant_devise) as montant_devise, '1' as sens,
            ppiece.designation as type, pbareme_type.designation as type_bareme, pfonction.designation as fonction, lcontract.date_anciennete , tbulletin_lg.id,pbordereau.id as id_bordereau, pbordereau.code as bordereau, pbordereau.observation as bordereau_observation,ppaiement.designation as paiement, pbordereau.date_integration
            
            FROM tbulletin_lg
            INNER JOIN tbulletin on tbulletin.id = tbulletin_lg.bulletin_id
            INNER JOIN ppiece on ppiece.id = tbulletin.piece_id
            INNER JOIN lcontract on lcontract.id = tbulletin.contract_id
            INNER JOIN pbordereau on pbordereau.id = tbulletin.bordereau_id
            INNER JOIN pbareme on lcontract.bareme_id = pbareme.id
            INNER JOIN pbareme_type on pbareme.bareme_type_id = pbareme_type.id
            INNER JOIN pdossier on pdossier.id = pbordereau.dossier_id
            INNER JOIN pemploye on pemploye.id = lcontract.employe_id
            INNER JOIN prubrique on prubrique.id = tbulletin_lg.rubrique_id
            INNER JOIN ppaiement on ppaiement.id = pbordereau.paiement_id

            LEFT JOIN pfonction on pfonction.id = lcontract.fonction_id
            LEFT JOIN pnature_contract on pnature_contract.id = pbordereau.nature_contract_id
            LEFT JOIN pfcy on pfcy.id = pdossier.fcy_id


            where  tbulletin.periode_id = 46  and tbulletin.active = 1 and tbulletin_lg.active = 1 and prubrique.imposable = 1 and pbordereau.active = 1 
            group by tbulletin.code 

            UNION

            SELECT pdossier.id as id_dossier, pdossier.designation as dossier, pfcy.id as id_fcy, pfcy.fcy0, pfcy.fcy0_libelle,pemploye.id as employe_id, lcontract.id as id_contract, pemploye.nom, pemploye.prenom,
            pnature_contract.designation as nature_contrat,pemploye.cin, tbulletin.code as bulletin, 'rémunération brute' as element, sum(tbulletin_lg.montant) as montant, sum(tbulletin_lg.montant_devise) as montant_devise, '1' as sens,
            ppiece.designation as type, pbareme_type.designation as type_bareme, pfonction.designation as fonction, lcontract.date_anciennete , tbulletin_lg.id,pbordereau.id as id_bordereau, pbordereau.code as bordereau, pbordereau.observation as bordereau_observation,ppaiement.designation as paiement, pbordereau.date_integration
            
            FROM tbulletin_lg
            INNER JOIN tbulletin on tbulletin.id = tbulletin_lg.bulletin_id
            INNER JOIN ppiece on ppiece.id = tbulletin.piece_id
            INNER JOIN lcontract on lcontract.id = tbulletin.contract_id
            INNER JOIN pbordereau on pbordereau.id = tbulletin.bordereau_id

            INNER JOIN pbareme on lcontract.bareme_id = pbareme.id
            INNER JOIN pbareme_type on pbareme.bareme_type_id = pbareme_type.id
            INNER JOIN pdossier on pdossier.id = pbordereau.dossier_id
            INNER JOIN pemploye on pemploye.id = lcontract.employe_id
            INNER JOIN prubrique on prubrique.id = tbulletin_lg.rubrique_id
            INNER JOIN ppaiement on ppaiement.id = pbordereau.paiement_id

            LEFT JOIN pfonction on pfonction.id = lcontract.fonction_id
            LEFT JOIN pnature_contract on pnature_contract.id = pbordereau.nature_contract_id
            LEFT JOIN pfcy on pfcy.id = pdossier.fcy_id


            where  tbulletin.periode_id = 46  and tbulletin.active = 1 and tbulletin_lg.active = 1 and (prubrique.id in (1, 4, 6, 7,8,9) or prubrique.fixe = 1) and pbordereau.active = 1 
            group by tbulletin.code 

            UNION

            SELECT pdossier.id as id_dossier, pdossier.designation as dossier, pfcy.id as id_fcy, pfcy.fcy0, pfcy.fcy0_libelle,pemploye.id as employe_id, lcontract.id as id_contract, pemploye.nom, pemploye.prenom,
            pnature_contract.designation as nature_contrat,pemploye.cin, tbulletin.code as bulletin, 'cotisation PS' as element, sum(tbulletin_lg.montant) as montant, sum(tbulletin_lg.montant_devise) as montant_devise, '1' as sens,
            ppiece.designation as type, pbareme_type.designation as type_bareme, pfonction.designation as fonction, lcontract.date_anciennete , tbulletin_lg.id,pbordereau.id as id_bordereau, pbordereau.code as bordereau, pbordereau.observation as bordereau_observation,ppaiement.designation as paiement, pbordereau.date_integration
            
            FROM tbulletin_lg
            INNER JOIN tbulletin on tbulletin.id = tbulletin_lg.bulletin_id
            INNER JOIN ppiece on ppiece.id = tbulletin.piece_id
            INNER JOIN lcontract on lcontract.id = tbulletin.contract_id
            INNER JOIN pbordereau on pbordereau.id = tbulletin.bordereau_id

            INNER JOIN pbareme on lcontract.bareme_id = pbareme.id
            INNER JOIN pbareme_type on pbareme.bareme_type_id = pbareme_type.id
            INNER JOIN pdossier on pdossier.id = pbordereau.dossier_id
            INNER JOIN pemploye on pemploye.id = lcontract.employe_id
            INNER JOIN prubrique on prubrique.id = tbulletin_lg.rubrique_id
            INNER JOIN ppaiement on ppaiement.id = pbordereau.paiement_id

            LEFT JOIN pfonction on pfonction.id = lcontract.fonction_id
            LEFT JOIN pnature_contract on pnature_contract.id = pbordereau.nature_contract_id
            LEFT JOIN pfcy on pfcy.id = pdossier.fcy_id


            where  tbulletin.periode_id = 46  and tbulletin.active = 1 and tbulletin_lg.active = 1 and prubrique.id in (50, 47, 53, 48) and pbordereau.active = 1 
            group by tbulletin.code 

            UNION

            SELECT pdossier.id as id_dossier, pdossier.designation as dossier, pfcy.id as id_fcy, pfcy.fcy0, pfcy.fcy0_libelle,pemploye.id as employe_id, lcontract.id as id_contract, pemploye.nom, pemploye.prenom,
            pnature_contract.designation as nature_contrat,pemploye.cin, tbulletin.code as bulletin, 'cotisation PP' as element, sum(tbulletin_lg.montant) as montant, sum(tbulletin_lg.montant_devise) as montant_devise, '1' as sens,
            ppiece.designation as type, pbareme_type.designation as type_bareme, pfonction.designation as fonction, lcontract.date_anciennete , tbulletin_lg.id,pbordereau.id as id_bordereau, pbordereau.code as bordereau, pbordereau.observation as bordereau_observation,ppaiement.designation as paiement, pbordereau.date_integration
            
            FROM tbulletin_lg
            INNER JOIN tbulletin on tbulletin.id = tbulletin_lg.bulletin_id
            INNER JOIN ppiece on ppiece.id = tbulletin.piece_id
            INNER JOIN lcontract on lcontract.id = tbulletin.contract_id
            INNER JOIN pbordereau on pbordereau.id = tbulletin.bordereau_id
            INNER JOIN pbareme on lcontract.bareme_id = pbareme.id
            INNER JOIN pbareme_type on pbareme.bareme_type_id = pbareme_type.id
            INNER JOIN pdossier on pdossier.id = pbordereau.dossier_id
            INNER JOIN pemploye on pemploye.id = lcontract.employe_id
            INNER JOIN prubrique on prubrique.id = tbulletin_lg.rubrique_id
            INNER JOIN ppaiement on ppaiement.id = pbordereau.paiement_id
            LEFT JOIN pfonction on pfonction.id = lcontract.fonction_id
            LEFT JOIN pnature_contract on pnature_contract.id = pbordereau.nature_contract_id
            LEFT JOIN pfcy on pfcy.id = pdossier.fcy_id


            where  tbulletin.periode_id = 46  and tbulletin.active = 1 and tbulletin_lg.active = 1 and prubrique.id in (51, 52, 54, 55, 56, 58, 57) and pbordereau.active = 1 
            group by tbulletin.code
Parameters: 
[]
View formatted query    View runnable query    Explain query

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
  • The field App\Entity\Tbulletin#bulletinLgs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TbulletinLg#bulletin does not contain the required 'inversedBy="bulletinLgs"' attribute.
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.