Symfony Profiler

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerSI1xzXB\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = ? AND m1_.module = ? ORDER BY m0_.code ASC"
  "params" => [
    1 => "MINIMUMSOCIAL"
    2 => "CONTRATAPPRENANT"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = ? AND m1_.module = ? ORDER BY m0_.code ASC"
  "params" => [
    1 => "TYPECONTRAT"
    2 => "CONVENTION"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = ? AND m1_.module = ? ORDER BY m0_.code ASC"
  "params" => [
    1 => "TYPEDEROGATION "
    2 => "CONVENTION"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.archive AS archive_3, c0_.numero_contrat_precedent AS numero_contrat_precedent_4, c0_.numero_externe_dossier AS numero_externe_dossier_5, c0_.numero_interne_dossier AS numero_interne_dossier_6, c0_.num_projet AS num_projet_7, c0_.classification_emploi AS classification_emploi_8, c0_.niveau AS niveau_9, c0_.duree_periode_essai AS duree_periode_essai_10, c0_.competences_adevelopper AS competences_adevelopper_11, c0_.temps_stage AS temps_stage_12, c0_.conditions_particulieres AS conditions_particulieres_13, c0_.objective_programme AS objective_programme_14, c0_.objective_du_stage AS objective_du_stage_15, c0_.activites_confiees AS activites_confiees_16, c0_.lieu_stage AS lieu_stage_17, c0_.gratification AS gratification_18, c0_.deroulement_heurs AS deroulement_heurs_19, c0_.nb_heures AS nb_heures_20, c0_.nb_jour AS nb_jour_21, c0_.non_conforme AS non_conforme_22, c0_.travail_machines_dangereuses AS travail_machines_dangereuses_23, c0_.smig AS smig_24, c0_.tutore AS tutore_25, c0_.document_genere AS document_genere_26, c0_.regime_specifique AS regime_specifique_27, c0_.attestation_eligibilite AS attestation_eligibilite_28, c0_.attestation_pieces AS attestation_pieces_29, c0_.opco_document AS opco_document_30, c0_.opco_convention AS opco_convention_31, c0_.commentaire AS commentaire_32, c0_.signature_a AS signature_a_33, c0_.missions AS missions_34, c0_.modalites_encadrement AS modalites_encadrement_35, c0_.avantages_offerts AS avantages_offerts_36, c0_.start AS start_37, c0_.end AS end_38, c0_.signature_le AS signature_le_39, c0_.niveau_emploi AS niveau_emploi_40, c0_.classification_convention_collective AS classification_convention_collective_41, c0_.description_missions_confiees AS description_missions_confiees_42, c0_.emploi_occupe AS emploi_occupe_43, c0_.coefficient_hierarchique AS coefficient_hierarchique_44, c0_.salaire_brut AS salaire_brut_45, c0_.nouriture AS nouriture_46, c0_.logement AS logement_47, c0_.duree_hebdomadaire AS duree_hebdomadaire_48, c0_.date_signature AS date_signature_49, c0_.date_effet AS date_effet_50, c0_.created_by_id AS created_by_id_51, c0_.updated_by_id AS updated_by_id_52, c0_.document_id AS document_id_53, c0_.template_id AS template_id_54, c0_.dossier_id AS dossier_id_55, c0_.employe_id AS employe_id_56, c0_.state_id AS state_id_57, c0_.entreprise_id AS entreprise_id_58, c0_.etablissement_id AS etablissement_id_59, c0_.tuteur_id AS tuteur_id_60, c0_.signature_file_id AS signature_file_id_61, c0_.signature_entreprise_file_id AS signature_entreprise_file_id_62, c0_.tuteur1_id AS tuteur1_id_63, c0_.tuteur2_id AS tuteur2_id_64, c0_.minimum_social_id AS minimum_social_id_65, c0_.type_contrat_id AS type_contrat_id_66, c0_.type_derogation_id AS type_derogation_id_67, c0_.type_id AS type_id_68, c0_.stage_id AS stage_id_69 FROM convention c0_ INNER JOIN dossier d1_ ON c0_.dossier_id = d1_.id INNER JOIN masterlistelg m2_ ON c0_.type_id = m2_.id WHERE d1_.id = ? AND m2_.code = ?"
  "params" => [
    1 => 65
    2 => "contratApprentiEntreprise"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1"
  "params" => [
    1 => "cerfa"
    2 => "CONVENTION"
    3 => "TYPE"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.numero_contrat_precedent AS numero_contrat_precedent_5, t0.numero_externe_dossier AS numero_externe_dossier_6, t0.numero_interne_dossier AS numero_interne_dossier_7, t0.num_projet AS num_projet_8, t0.classification_emploi AS classification_emploi_9, t0.niveau AS niveau_10, t0.duree_periode_essai AS duree_periode_essai_11, t0.competences_adevelopper AS competences_adevelopper_12, t0.temps_stage AS temps_stage_13, t0.conditions_particulieres AS conditions_particulieres_14, t0.objective_programme AS objective_programme_15, t0.objective_du_stage AS objective_du_stage_16, t0.activites_confiees AS activites_confiees_17, t0.lieu_stage AS lieu_stage_18, t0.gratification AS gratification_19, t0.deroulement_heurs AS deroulement_heurs_20, t0.nb_heures AS nb_heures_21, t0.nb_jour AS nb_jour_22, t0.non_conforme AS non_conforme_23, t0.travail_machines_dangereuses AS travail_machines_dangereuses_24, t0.smig AS smig_25, t0.tutore AS tutore_26, t0.document_genere AS document_genere_27, t0.regime_specifique AS regime_specifique_28, t0.attestation_eligibilite AS attestation_eligibilite_29, t0.attestation_pieces AS attestation_pieces_30, t0.opco_document AS opco_document_31, t0.opco_convention AS opco_convention_32, t0.commentaire AS commentaire_33, t0.signature_a AS signature_a_34, t0.missions AS missions_35, t0.modalites_encadrement AS modalites_encadrement_36, t0.avantages_offerts AS avantages_offerts_37, t0.start AS start_38, t0.end AS end_39, t0.signature_le AS signature_le_40, t0.niveau_emploi AS niveau_emploi_41, t0.classification_convention_collective AS classification_convention_collective_42, t0.description_missions_confiees AS description_missions_confiees_43, t0.emploi_occupe AS emploi_occupe_44, t0.coefficient_hierarchique AS coefficient_hierarchique_45, t0.salaire_brut AS salaire_brut_46, t0.nouriture AS nouriture_47, t0.logement AS logement_48, t0.duree_hebdomadaire AS duree_hebdomadaire_49, t0.date_signature AS date_signature_50, t0.date_effet AS date_effet_51, t0.created_by_id AS created_by_id_52, t0.updated_by_id AS updated_by_id_53, t0.document_id AS document_id_54, t0.template_id AS template_id_55, t0.dossier_id AS dossier_id_56, t0.employe_id AS employe_id_57, t0.state_id AS state_id_58, t0.entreprise_id AS entreprise_id_59, t0.etablissement_id AS etablissement_id_60, t0.tuteur_id AS tuteur_id_61, t0.signature_file_id AS signature_file_id_62, t0.signature_entreprise_file_id AS signature_entreprise_file_id_63, t0.tuteur1_id AS tuteur1_id_64, t0.tuteur2_id AS tuteur2_id_65, t0.minimum_social_id AS minimum_social_id_66, t0.type_contrat_id AS type_contrat_id_67, t0.type_derogation_id AS type_derogation_id_68, t0.type_id AS type_id_69, t0.stage_id AS stage_id_70 FROM convention t0 WHERE t0.dossier_id = ?"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.tuteur AS tuteur_5, t0.niveau AS niveau_6, t0.referent_administratif AS referent_administratif_7, t0.responsable_rh AS responsable_rh_8, t0.referent_absences AS referent_absences_9, t0.referent_commercial AS referent_commercial_10, t0.representant_legal AS representant_legal_11, t0.principal AS principal_12, t0.fonction AS fonction_13, t0.email AS email_14, t0.diplome_plus_eleve AS diplome_plus_eleve_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.personal_informations_id AS personal_informations_id_18, t0.adresse_id AS adresse_id_19, t0.tiers_id AS tiers_id_20, t0.type_responsable_id AS type_responsable_id_21, t0.niveau_diplome_id AS niveau_diplome_id_22, t0.cv_id AS cv_id_23 FROM contact t0 WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = ?"
  "params" => [
    1 => 167
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ?"
  "params" => [
    1 => 738
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]