Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.93 ms Query time

8 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	0.75 ms	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 Parameters: [`"NBHRSFORMATION" "NOYAU" "PARAMETRAGE"`] View formatted query View runnable query Explain query 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 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 = 'NBHRSFORMATION' AND m1_.module = 'NOYAU' AND m1_.code = 'PARAMETRAGE' LIMIT 1;
2	3.18 ms	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.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.taux_obtention AS taux_obtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = ? Parameters: [`"164"`] View formatted query View runnable query Explain query 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.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.taux_obtention AS taux_obtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = ? 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.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.taux_obtention AS taux_obtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = '164';

#▲

Time

Info

0.75 ms

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

Parameters:

[
  "NBHRSFORMATION"
  "NOYAU"
  "PARAMETRAGE"
]

View formatted query View runnable query Explain query

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

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 = 'NBHRSFORMATION' AND m1_.module = 'NOYAU' AND m1_.code = 'PARAMETRAGE' LIMIT 1;

3.18 ms

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.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.taux_obtention AS taux_obtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = ?

Parameters:

[
  "164"
]

View formatted query View runnable query Explain query

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.intitule AS intitule_5,
  t0.intitule_officiel AS intitule_officiel_6,
  t0.code AS code_7,
  t0.code_diplome AS code_diplome_8,
  t0.sigle AS sigle_9,
  t0.date_debut_valide AS date_debut_valide_10,
  t0.date_fin_valide AS date_fin_valide_11,
  t0.date_publication_officiel AS date_publication_officiel_12,
  t0.plus AS plus_13,
  t0.redirection AS redirection_14,
  t0.publication AS publication_15,
  t0.publication_api AS publication_api_16,
  t0.taux_obtention AS taux_obtention_17,
  t0.taux_abandon AS taux_abandon_18,
  t0.taux_satisfaction AS taux_satisfaction_19,
  t0.taux_pour_suite_etude AS taux_pour_suite_etude_20,
  t0.taux_employabilite AS taux_employabilite_21,
  t0.prerequis AS prerequis_22,
  t0.salaire_moyen AS salaire_moyen_23,
  t0.livrable AS livrable_24,
  t0.alt_banniere AS alt_banniere_25,
  t0.alt_vignette AS alt_vignette_26,
  t0.tarif_jury AS tarif_jury_27,
  t0.tarif_jury2 AS tarif_jury2_28,
  t0.cpf AS cpf_29,
  t0.code_cpf AS code_cpf_30,
  t0.code_rncp_rs AS code_rncp_rs_31,
  t0.code_cpf_salarie AS code_cpf_salarie_32,
  t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33,
  t0.code_nsf AS code_nsf_34,
  t0.duree AS duree_35,
  t0.duree_modulaire AS duree_modulaire_36,
  t0.rncp AS rncp_37,
  t0.duree_accompagnement AS duree_accompagnement_38,
  t0.duree_stage AS duree_stage_39,
  t0.duree_center AS duree_center_40,
  t0.duree_elearning AS duree_elearning_41,
  t0.stage_obligatoire AS stage_obligatoire_42,
  t0.formation_permanente AS formation_permanente_43,
  t0.sanction_resume AS sanction_resume_44,
  t0.sanction_long AS sanction_long_45,
  t0.metier AS metier_46,
  t0.accessibilite_handicap AS accessibilite_handicap_47,
  t0.modalites_delais_acces AS modalites_delais_acces_48,
  t0.modaliteevaluationinitial AS modaliteevaluationinitial_49,
  t0.modaliteevaluationfinal AS modaliteevaluationfinal_50,
  t0.text AS text_51,
  t0.objectif AS objectif_52,
  t0.debouche AS debouche_53,
  t0.condition_admission AS condition_admission_54,
  t0.public AS public_55,
  t0.detail_examen AS detail_examen_56,
  t0.frais_pedagogique AS frais_pedagogique_57,
  t0.methodes_mobilisees AS methodes_mobilisees_58,
  t0.seo_titre AS seo_titre_59,
  t0.seo_description AS seo_description_60,
  t0.rythme AS rythme_61,
  t0.identifiant_dokelio AS identifiant_dokelio_62,
  t0.dokelio_parcours AS dokelio_parcours_63,
  t0.contenu_apres AS contenu_apres_64,
  t0.contenu_avant AS contenu_avant_65,
  t0.path AS path_66,
  t0.items AS items_67,
  t0.is_default AS is_default_68,
  t0.created_by_id AS created_by_id_69,
  t0.updated_by_id AS updated_by_id_70,
  t0.theme_id AS theme_id_71,
  t0.parent_id AS parent_id_72,
  t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73,
  t0.nsf_id AS nsf_id_74,
  t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75,
  t0.filiere_id AS filiere_id_76,
  t0.niveau_entree_id AS niveau_entree_id_77,
  t0.niveau_sortie_id AS niveau_sortie_id_78,
  t0.niveau_technique_id AS niveau_technique_id_79,
  t0.qualifiant_id AS qualifiant_id_80,
  t0.type_formation_id AS type_formation_id_81,
  t0.autorite_delivrance_id AS autorite_delivrance_id_82,
  t0.mode_formation_id AS mode_formation_id_83,
  t0.formateur_id AS formateur_id_84,
  t0.banniere_id AS banniere_id_85,
  t0.vignette_id AS vignette_id_86
FROM
  parcours t0
WHERE
  t0.id = ?

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.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.taux_obtention AS taux_obtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = '164';

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Gestiform\Admin\MasterListe\Masterlistelg	1
App\Entity\Gestiform\Admin\ApiGestiform	1
App\Entity\Gestiform\Admin\MasterListe\Masterliste	1

Entities Mapping

Class	Mapping errors
App\Entity\AbstractEntity	No errors.
App\Entity\Gestiform\Admin\MasterListe\Masterlistelg	No errors.
App\Entity\Gestiform\Admin\MasterListe\Masterliste	No errors.
App\Entity\Gestiform\Users\User	No errors.
App\Entity\Gestiform\Admin\ApiGestiform	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours	The field 'App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours#tarifJury' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours#tarifJury2' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours#modeFormation refers to the inverse side field App\Entity\Gestiform\Admin\MasterListe\Masterlistelg#parcours which does not exist.
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme	The mappings App\Entity\Gestiform\Formations\Catalogue\Theme\Theme#tarifsVenteIntras and App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra#theme are inconsistent with each other.
App\Entity\Gestiform\Formations\Catalogue\Filiere	No errors.
App\Entity\Gestiform\Formations\Catalogue\Niveau	No errors.
App\Entity\Gestiform\Users\Personne	No errors.
App\Entity\Gestiform\Users\Formateur	No errors.
App\Entity\Common\Upload	No errors.
App\Entity\Common\Adresse	No errors.
App\Entity\Gestiform\Admin\Tiers	No errors.
App\Entity\Gestiform\Admin\Societe	No errors.
App\Entity\Gestiform\Formations\Session\Session	The association App\Entity\Gestiform\Formations\Session\Session#salleDefaut refers to the inverse side field App\Entity\Gestiform\Admin\Salle#sessions which does not exist.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\Bloc	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModaliteEvaluation	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteParcours	The field 'App\Entity\Gestiform\Admin\Tarifs\TarifVenteParcours#forfaitAccompagnements' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Common\Document	No errors.
App\Entity\Gestiform\Formations\Catalogue\Theme\SousThemeTheme	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\Module	The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifInterJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifInterHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifIntraJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifIntraHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifJury' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The mappings App\Entity\Gestiform\Formations\Catalogue\Module\Module#moduleModaliteEvaluationFinales and App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale#module are inconsistent with each other. The mappings App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifsVenteIntras and App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra#module are inconsistent with each other.
App\Entity\Gestiform\Formations\Catalogue\Certification	The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifInterJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifInterHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifIntraJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifIntraHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifJury' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The mappings App\Entity\Gestiform\Formations\Catalogue\Certification#moduleModaliteEvaluationFinales and App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale#module are inconsistent with each other. The mappings App\Entity\Gestiform\Formations\Catalogue\Certification#tarifsVenteIntras and App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra#module are inconsistent with each other.
App\Entity\Gestiform\Admin\Tarifs\TarifVente	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteTheme	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra	No errors.
App\Entity\Gestiform\Formations\Dossier\PersonalInformations	No errors.
App\Entity\Common\HistoriqueEmail	No errors.
App\Entity\Gestiform\Admin\Cursus\CVdynamique	No errors.
App\Entity\Gestiform\Admin\Cursus\Entretien	No errors.
App\Entity\Gestiform\Admin\Cursus\CursusReponses	No errors.
App\Entity\Gestiform\Formations\Dossier\DossierQuiz	No errors.
App\Entity\Gestiform\Formations\Formateur\FormateurModule	The field 'App\Entity\Gestiform\Formations\Formateur\FormateurModule#note' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Formateur\FormateurModule#noteAutoEval' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Gestiform\Formations\Entreprise\FormateurEntreprise	No errors.
App\Entity\Gestiform\Formations\Entreprise\Contrat	No errors.
App\Entity\Gestiform\Formations\Session\Planning\LignePrestation	No errors.
App\Entity\Gestiform\Formations\Session\FormateurEvent	The field 'App\Entity\Gestiform\Formations\Session\FormateurEvent#nbjoursPrevus' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Gestiform\Formations\Session\Planning\ApprenantLivrable	No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueComment	No errors.

Symfony Profiler

GET https://frontest.simplyform.lmosoft.com/164/parcours-export-pdf-front

Configuration Settings

Theme

Page Width