OSE

Other Route Parameters

 array:1 [
  "view" => "DiagrammeBdd"
]

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' Params Types Time 0.00056004524230957

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL SELECT cp.code || '-' || p.code privilege, r.code role FROM role_privilege rp JOIN privilege p ON p.id = rp.privilege_id JOIN categorie_privilege cp ON cp.id = p.categorie_id JOIN role r ON r.id = rp.role_id AND r.histo_destruction IS NULL Params Types Time 0.00217199325561523

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL SELECT t0.DATE_DEBUT AS DATE_DEBUT_1, t0.DATE_FIN AS DATE_FIN_2, t0.LIBELLE AS LIBELLE_3, t0.ACTIVE AS ACTIVE_4, t0.ID AS ID_5 FROM ANNEE t0 WHERE t0.ID = ? Params 0 => int(2026)
Types 0 => string(7) "integer"
Time 0.000563859939575195

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL SELECT s0_.CODE AS CODE_0, s0_.LIBELLE AS LIBELLE_1, s0_.ORDRE AS ORDRE_2, s0_.PRIORITAIRE_INDICATEURS AS PRIORITAIRE_INDICATEURS_3, s0_.SERVICE_STATUTAIRE AS SERVICE_STATUTAIRE_4, s0_.DEPASSEMENT_SERVICE_DU_SANS_HC AS PASSEMENT_SERVICE_DU_SANS_HC_5, s0_.TAUX_CHARGES_PATRONALES AS TAUX_CHARGES_PATRONALES_6, s0_.TAUX_CHARGES_TTC AS TAUX_CHARGES_TTC_7, s0_.DOSSIER AS DOSSIER_8, s0_.DOSSIER_VISUALISATION AS DOSSIER_VISUALISATION_9, s0_.DOSSIER_EDITION AS DOSSIER_EDITION_10, s0_.DOSSIER_SELECTIONNABLE AS DOSSIER_SELECTIONNABLE_11, s0_.DOSSIER_IDENTITE_COMP AS DOSSIER_IDENTITE_COMP_12, s0_.DOSSIER_CONTACT AS DOSSIER_CONTACT_13, s0_.DOSSIER_TEL_PERSO AS DOSSIER_TEL_PERSO_14, s0_.DOSSIER_EMAIL_PERSO AS DOSSIER_EMAIL_PERSO_15, s0_.DOSSIER_SITUATION_MATRIMONIALE AS SIER_SITUATION_MATRIMONIALE_16, s0_.DOSSIER_EMPLOYEUR_FACULTATIF AS OSSIER_EMPLOYEUR_FACULTATIF_17, s0_.DOSSIER_ADRESSE AS DOSSIER_ADRESSE_18, s0_.DOSSIER_BANQUE AS DOSSIER_BANQUE_19, s0_.DOSSIER_INSEE AS DOSSIER_INSEE_20, s0_.DOSSIER_STATUT AS DOSSIER_STATUT_21, s0_.DOSSIER_EMPLOYEUR AS DOSSIER_EMPLOYEUR_22, s0_.DOSSIER_AUTRE_1 AS DOSSIER_AUTRE_1_23, s0_.DOSSIER_AUTRE_1_VISUALISATION AS SSIER_AUTRE_1_VISUALISATION_24, s0_.DOSSIER_AUTRE_1_EDITION AS DOSSIER_AUTRE_1_EDITION_25, s0_.DOSSIER_AUTRE_2 AS DOSSIER_AUTRE_2_26, s0_.DOSSIER_AUTRE_2_VISUALISATION AS SSIER_AUTRE_2_VISUALISATION_27, s0_.DOSSIER_AUTRE_2_EDITION AS DOSSIER_AUTRE_2_EDITION_28, s0_.DOSSIER_AUTRE_3 AS DOSSIER_AUTRE_3_29, s0_.DOSSIER_AUTRE_3_VISUALISATION AS SSIER_AUTRE_3_VISUALISATION_30, s0_.DOSSIER_AUTRE_3_EDITION AS DOSSIER_AUTRE_3_EDITION_31, s0_.DOSSIER_AUTRE_4 AS DOSSIER_AUTRE_4_32, s0_.DOSSIER_AUTRE_4_VISUALISATION AS SSIER_AUTRE_4_VISUALISATION_33, s0_.DOSSIER_AUTRE_4_EDITION AS DOSSIER_AUTRE_4_EDITION_34, s0_.DOSSIER_AUTRE_5 AS DOSSIER_AUTRE_5_35, s0_.DOSSIER_AUTRE_5_VISUALISATION AS SSIER_AUTRE_5_VISUALISATION_36, s0_.DOSSIER_AUTRE_5_EDITION AS DOSSIER_AUTRE_5_EDITION_37, s0_.PJ_ACTIVE AS PJ_ACTIVE_38, s0_.PJ_VISUALISATION AS PJ_VISUALISATION_39, s0_.PJ_EDITION AS PJ_EDITION_40, s0_.CONSEIL_RESTREINT AS CONSEIL_RESTREINT_41, s0_.CONSEIL_RESTREINT_VISU AS CONSEIL_RESTREINT_VISU_42, s0_.CONSEIL_RESTREINT_DUREE_VIE AS CONSEIL_RESTREINT_DUREE_VIE_43, s0_.CONSEIL_ACA AS CONSEIL_ACA_44, s0_.CONSEIL_ACA_VISUALISATION AS CONSEIL_ACA_VISUALISATION_45, s0_.CONSEIL_ACA_DUREE_VIE AS CONSEIL_ACA_DUREE_VIE_46, s0_.CONTRAT AS CONTRAT_47, s0_.CONTRAT_VISUALISATION AS CONTRAT_VISUALISATION_48, s0_.CONTRAT_DEPOT AS CONTRAT_DEPOT_49, s0_.CONTRAT_GENERATION AS CONTRAT_GENERATION_50, s0_.SERVICE_PREVU AS SERVICE_PREVU_51, s0_.SERVICE_PREVU_VISU AS SERVICE_PREVU_VISU_52, s0_.SERVICE_PREVU_EDITION AS SERVICE_PREVU_EDITION_53, s0_.SERVICE_REALISE AS SERVICE_REALISE_54, s0_.SERVICE_REALISE_VISU AS SERVICE_REALISE_VISU_55, s0_.SERVICE_REALISE_EDITION AS SERVICE_REALISE_EDITION_56, s0_.SERVICE_EXTERIEUR AS SERVICE_EXTERIEUR_57, s0_.REFERENTIEL_PREVU AS REFERENTIEL_PREVU_58, s0_.REFERENTIEL_PREVU_VISU AS REFERENTIEL_PREVU_VISU_59, s0_.REFERENTIEL_PREVU_EDITION AS REFERENTIEL_PREVU_EDITION_60, s0_.REFERENTIEL_REALISE AS REFERENTIEL_REALISE_61, s0_.REFERENTIEL_REALISE_VISU AS REFERENTIEL_REALISE_VISU_62, s0_.REFERENTIEL_REALISE_EDITION AS REFERENTIEL_REALISE_EDITION_63, s0_.MISSION AS MISSION_64, s0_.MISSION_VISUALISATION AS MISSION_VISUALISATION_65, s0_.MISSION_EDITION AS MISSION_EDITION_66, s0_.MISSION_REALISE_EDITION AS MISSION_REALISE_EDITION_67, s0_.MISSION_DECRET AS MISSION_DECRET_68, s0_.OFFRE_EMPLOI_POSTULER AS OFFRE_EMPLOI_POSTULER_69, s0_.MISSION_INDEMNITEES AS MISSION_INDEMNITEES_70, s0_.CLOTURE AS CLOTURE_71, s0_.MODIF_SERVICE_DU AS MODIF_SERVICE_DU_72, s0_.MODIF_SERVICE_DU_VISUALISATION AS IF_SERVICE_DU_VISUALISATION_73, s0_.PAIEMENT AS PAIEMENT_74, s0_.PAIEMENT_VISUALISATION AS PAIEMENT_VISUALISATION_75, s0_.MOTIF_NON_PAIEMENT AS MOTIF_NON_PAIEMENT_76, s0_.FORMULE_VISUALISATION AS FORMULE_VISUALISATION_77, s0_.CODES_CORRESP_1 AS CODES_CORRESP_1_78, s0_.CODES_CORRESP_2 AS CODES_CORRESP_2_79, s0_.CODES_CORRESP_3 AS CODES_CORRESP_3_80, s0_.CODES_CORRESP_4 AS CODES_CORRESP_4_81, s0_.MODE_ENSEIGNEMENT_PREVISIONNEL AS E_ENSEIGNEMENT_PREVISIONNEL_82, s0_.MODE_ENSEIGNEMENT_REALISE AS MODE_ENSEIGNEMENT_REALISE_83, s0_.MODE_CALCUL AS MODE_CALCUL_84, s0_.CODE_INDEMNITE AS CODE_INDEMNITE_85, s0_.TYPE_PAIE AS TYPE_PAIE_86, s0_.MODE_CALCUL_PRIME AS MODE_CALCUL_PRIME_87, s0_.CODE_INDEMNITE_PRIME AS CODE_INDEMNITE_PRIME_88, s0_.TYPE_PAIE_PRIME AS TYPE_PAIE_PRIME_89, s0_.HISTO_CREATION AS HISTO_CREATION_90, s0_.HISTO_MODIFICATION AS HISTO_MODIFICATION_91, s0_.HISTO_DESTRUCTION AS HISTO_DESTRUCTION_92, s0_.ID AS ID_93, s0_.TYPE_INTERVENANT_ID AS TYPE_INTERVENANT_ID_94, s0_.ANNEE_ID AS ANNEE_ID_95, s0_.CONTRAT_ETAT_SORTIE_ID AS CONTRAT_ETAT_SORTIE_ID_96, s0_.AVENANT_ETAT_SORTIE_ID AS AVENANT_ETAT_SORTIE_ID_97, s0_.HISTO_CREATEUR_ID AS HISTO_CREATEUR_ID_98, s0_.HISTO_MODIFICATEUR_ID AS HISTO_MODIFICATEUR_ID_99, s0_.HISTO_DESTRUCTEUR_ID AS HISTO_DESTRUCTEUR_ID_100, s0_.TAUX_REMU_ID AS TAUX_REMU_ID_101 FROM STATUT s0_ WHERE s0_.ANNEE_ID = ? AND s0_.HISTO_DESTRUCTION IS NULL ORDER BY s0_.ORDRE ASC Params 0 => int(2026)
Types 0 => string(7) "integer"
Time 0.0018761157989502

Appel Application/src/Provider/Role/RoleProvider.php(49): Application\Provider\Role\RoleProvider->makeRoles()
SQL SELECT t0.CODE AS CODE_1, t0.LIBELLE AS LIBELLE_2, t0.ID AS ID_3 FROM TYPE_INTERVENANT t0 WHERE t0.ID = ? Params 0 => int(2)
Types 0 => string(7) "integer"
Time 0.000718116760253906

Appel Application/src/Provider/Role/RoleProvider.php(49): Application\Provider\Role\RoleProvider->makeRoles()
SQL SELECT t0.CODE AS CODE_1, t0.LIBELLE AS LIBELLE_2, t0.ID AS ID_3 FROM TYPE_INTERVENANT t0 WHERE t0.ID = ? Params 0 => int(1)
Types 0 => string(7) "integer"
Time 0.000306129455566406

Appel Application/view/layout/layout.phtml(15): Laminas\View\Renderer\PhpRenderer->__call()
SQL SELECT id FROM offre_emploi WHERE histo_destruction IS NULL AND validation_id IS NOT NULL Params Types Time 0.000638961791992188

Appel Application/view/layout/layout.phtml(84): Laminas\View\Renderer\PhpRenderer->__call()
SQL SELECT id, libelle FROM annee WHERE active = 1 ORDER BY id Params Types Time 0.000598907470703125