OSE

Other Route Parameters

^ array:1 [
  "view" => "ajout_cvs"
]

Appel Application/Application.php(117): Application::start()
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.00142502784729

Appel Application/Application.php(117): Application::start()
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.0020041465759277

Appel Application/Application.php(117): Application::start()
SQL SELECT nom, valeur FROM parametre Params Types Time 0.0017778873443604

Appel Application/Application.php(117): Application::start()
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(2023)
Types 0 => string(7) "integer"
Time 0.0020759105682373

Appel Application/Application.php(117): Application::start()
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_EMPLOYEUR_FACULTATIF AS OSSIER_EMPLOYEUR_FACULTATIF_16, s0_.DOSSIER_ADRESSE AS DOSSIER_ADRESSE_17, s0_.DOSSIER_BANQUE AS DOSSIER_BANQUE_18, s0_.DOSSIER_INSEE AS DOSSIER_INSEE_19, s0_.DOSSIER_STATUT AS DOSSIER_STATUT_20, s0_.DOSSIER_EMPLOYEUR AS DOSSIER_EMPLOYEUR_21, s0_.DOSSIER_AUTRE_1 AS DOSSIER_AUTRE_1_22, s0_.DOSSIER_AUTRE_1_VISUALISATION AS SSIER_AUTRE_1_VISUALISATION_23, s0_.DOSSIER_AUTRE_1_EDITION AS DOSSIER_AUTRE_1_EDITION_24, s0_.DOSSIER_AUTRE_2 AS DOSSIER_AUTRE_2_25, s0_.DOSSIER_AUTRE_2_VISUALISATION AS SSIER_AUTRE_2_VISUALISATION_26, s0_.DOSSIER_AUTRE_2_EDITION AS DOSSIER_AUTRE_2_EDITION_27, s0_.DOSSIER_AUTRE_3 AS DOSSIER_AUTRE_3_28, s0_.DOSSIER_AUTRE_3_VISUALISATION AS SSIER_AUTRE_3_VISUALISATION_29, s0_.DOSSIER_AUTRE_3_EDITION AS DOSSIER_AUTRE_3_EDITION_30, s0_.DOSSIER_AUTRE_4 AS DOSSIER_AUTRE_4_31, s0_.DOSSIER_AUTRE_4_VISUALISATION AS SSIER_AUTRE_4_VISUALISATION_32, s0_.DOSSIER_AUTRE_4_EDITION AS DOSSIER_AUTRE_4_EDITION_33, s0_.DOSSIER_AUTRE_5 AS DOSSIER_AUTRE_5_34, s0_.DOSSIER_AUTRE_5_VISUALISATION AS SSIER_AUTRE_5_VISUALISATION_35, s0_.DOSSIER_AUTRE_5_EDITION AS DOSSIER_AUTRE_5_EDITION_36, s0_.PJ_VISUALISATION AS PJ_VISUALISATION_37, s0_.PJ_EDITION AS PJ_EDITION_38, s0_.CONSEIL_RESTREINT AS CONSEIL_RESTREINT_39, s0_.CONSEIL_RESTREINT_VISU AS CONSEIL_RESTREINT_VISU_40, s0_.CONSEIL_RESTREINT_DUREE_VIE AS CONSEIL_RESTREINT_DUREE_VIE_41, s0_.CONSEIL_ACA AS CONSEIL_ACA_42, s0_.CONSEIL_ACA_VISUALISATION AS CONSEIL_ACA_VISUALISATION_43, s0_.CONSEIL_ACA_DUREE_VIE AS CONSEIL_ACA_DUREE_VIE_44, s0_.CONTRAT AS CONTRAT_45, s0_.CONTRAT_VISUALISATION AS CONTRAT_VISUALISATION_46, s0_.CONTRAT_DEPOT AS CONTRAT_DEPOT_47, s0_.CONTRAT_GENERATION AS CONTRAT_GENERATION_48, s0_.SERVICE_PREVU AS SERVICE_PREVU_49, s0_.SERVICE_PREVU_VISU AS SERVICE_PREVU_VISU_50, s0_.SERVICE_PREVU_EDITION AS SERVICE_PREVU_EDITION_51, s0_.SERVICE_REALISE AS SERVICE_REALISE_52, s0_.SERVICE_REALISE_VISU AS SERVICE_REALISE_VISU_53, s0_.SERVICE_REALISE_EDITION AS SERVICE_REALISE_EDITION_54, s0_.SERVICE_EXTERIEUR AS SERVICE_EXTERIEUR_55, s0_.REFERENTIEL_PREVU AS REFERENTIEL_PREVU_56, s0_.REFERENTIEL_PREVU_VISU AS REFERENTIEL_PREVU_VISU_57, s0_.REFERENTIEL_PREVU_EDITION AS REFERENTIEL_PREVU_EDITION_58, s0_.REFERENTIEL_REALISE AS REFERENTIEL_REALISE_59, s0_.REFERENTIEL_REALISE_VISU AS REFERENTIEL_REALISE_VISU_60, s0_.REFERENTIEL_REALISE_EDITION AS REFERENTIEL_REALISE_EDITION_61, s0_.MISSION AS MISSION_62, s0_.MISSION_VISUALISATION AS MISSION_VISUALISATION_63, s0_.MISSION_EDITION AS MISSION_EDITION_64, s0_.MISSION_REALISE_EDITION AS MISSION_REALISE_EDITION_65, s0_.MISSION_DECRET AS MISSION_DECRET_66, s0_.OFFRE_EMPLOI_POSTULER AS OFFRE_EMPLOI_POSTULER_67, s0_.CLOTURE AS CLOTURE_68, s0_.MODIF_SERVICE_DU AS MODIF_SERVICE_DU_69, s0_.MODIF_SERVICE_DU_VISUALISATION AS IF_SERVICE_DU_VISUALISATION_70, s0_.PAIEMENT AS PAIEMENT_71, s0_.PAIEMENT_VISUALISATION AS PAIEMENT_VISUALISATION_72, s0_.MOTIF_NON_PAIEMENT AS MOTIF_NON_PAIEMENT_73, s0_.FORMULE_VISUALISATION AS FORMULE_VISUALISATION_74, s0_.CODES_CORRESP_1 AS CODES_CORRESP_1_75, s0_.CODES_CORRESP_2 AS CODES_CORRESP_2_76, s0_.CODES_CORRESP_3 AS CODES_CORRESP_3_77, s0_.CODES_CORRESP_4 AS CODES_CORRESP_4_78, s0_.MODE_ENSEIGNEMENT_PREVISIONNEL AS E_ENSEIGNEMENT_PREVISIONNEL_79, s0_.MODE_ENSEIGNEMENT_REALISE AS MODE_ENSEIGNEMENT_REALISE_80, s0_.MODE_CALCUL AS MODE_CALCUL_81, s0_.CODE_INDEMNITE AS CODE_INDEMNITE_82, s0_.TYPE_PAIE AS TYPE_PAIE_83, s0_.MODE_CALCUL_PRIME AS MODE_CALCUL_PRIME_84, s0_.CODE_INDEMNITE_PRIME AS CODE_INDEMNITE_PRIME_85, s0_.TYPE_PAIE_PRIME AS TYPE_PAIE_PRIME_86, s0_.HISTO_CREATION AS HISTO_CREATION_87, s0_.HISTO_MODIFICATION AS HISTO_MODIFICATION_88, s0_.HISTO_DESTRUCTION AS HISTO_DESTRUCTION_89, s0_.ID AS ID_90, s0_.TYPE_INTERVENANT_ID AS TYPE_INTERVENANT_ID_91, s0_.ANNEE_ID AS ANNEE_ID_92, s0_.CONTRAT_ETAT_SORTIE_ID AS CONTRAT_ETAT_SORTIE_ID_93, s0_.AVENANT_ETAT_SORTIE_ID AS AVENANT_ETAT_SORTIE_ID_94, s0_.HISTO_CREATEUR_ID AS HISTO_CREATEUR_ID_95, s0_.HISTO_MODIFICATEUR_ID AS HISTO_MODIFICATEUR_ID_96, s0_.HISTO_DESTRUCTEUR_ID AS HISTO_DESTRUCTEUR_ID_97, s0_.TAUX_REMU_ID AS TAUX_REMU_ID_98 FROM STATUT s0_ WHERE s0_.ANNEE_ID = ? AND s0_.HISTO_DESTRUCTION IS NULL ORDER BY s0_.ORDRE ASC Params 0 => int(2023)
Types 0 => string(7) "integer"
Time 0.0028829574584961

Appel Application/Application.php(117): Application::start()
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.00229811668396

Appel Application/Application.php(117): Application::start()
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.0015521049499512

Appel Application/Application.php(117): Application::start()
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.0010759830474854

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT t0.CODE AS CODE_1, t0.HISTO_CREATION AS HISTO_CREATION_2, t0.HISTO_DESTRUCTION AS HISTO_DESTRUCTION_3, t0.HISTO_MODIFICATION AS HISTO_MODIFICATION_4, t0.LIBELLE AS LIBELLE_5, t0.URL_MODELE_DOC AS URL_MODELE_DOC_6, t0.ORDRE AS ORDRE_7, t0.ID AS ID_8, t0.HISTO_MODIFICATEUR_ID AS HISTO_MODIFICATEUR_ID_9, t0.HISTO_DESTRUCTEUR_ID AS HISTO_DESTRUCTEUR_ID_10, t0.HISTO_CREATEUR_ID AS HISTO_CREATEUR_ID_11 FROM TYPE_PIECE_JOINTE t0 WHERE t0.ID = ? Params 0 => int(1)
Types 0 => string(7) "integer"
Time 0.023310899734497

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT t0.CODE AS CODE_1, t0.LIBELLE AS LIBELLE_2, t0.ID AS ID_3 FROM TYPE_VALIDATION t0 WHERE t0.ID = ? Params 0 => int(4)
Types 0 => string(7) "integer"
Time 0.0051789283752441

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT t0.CODE AS CODE_1, t0.LIBELLE AS LIBELLE_2, t0.ID AS ID_3 FROM TYPE_VALIDATION t0 WHERE t0.ID = ? Params 0 => int(5)
Types 0 => string(7) "integer"
Time 0.0012691020965576

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT i.id intervenant_id, i.code intervenant_code, pj.id piece_jointe_id, f.id fichier_id, f.nom fichier_nom, u.id deposant_id, u.display_name deposant FROM intervenant i LEFT JOIN piece_jointe pj ON pj.intervenant_id = i.id AND pj.histo_destruction IS NULL AND pj.type_piece_jointe_id = :type_piece_jointe LEFT JOIN piece_jointe_fichier pjf ON pjf.piece_jointe_id = pj.id LEFT JOIN fichier f ON f.id = pjf.fichier_id AND f.histo_destruction IS NULL LEFT JOIN utilisateur u ON u.id = f.histo_createur_id WHERE i.annee_id = 2020 Params type_piece_jointe => int(1)
Types Time 0.14472508430481

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT id FROM offre_emploi WHERE histo_destruction IS NULL AND validation_id IS NOT NULL Params Types Time 0.0015997886657715

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT id, libelle FROM annee WHERE active = 1 ORDER BY id Params Types Time 0.0011899471282959