Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.ctime AS ctime_2,
  t0.utime AS utime_3,
  t0.active AS active_4,
  t0.deleted AS deleted_5,
  t0.digi_id AS digi_id_6,
  t0.digi_ref AS digi_ref_7,
  t0.cerfa_data AS cerfa_data_8,
  t0.session_id AS session_id_9,
  t10.customers_nb AS customers_nb_11,
  t10.afest_jours AS afest_jours_12,
  t10.debut AS debut_13,
  t10.fin AS fin_14,
  t10.diplome AS diplome_15,
  t10.state AS state_16,
  t10.remarques AS remarques_17,
  t10.id AS id_18,
  t10.ctime AS ctime_19,
  t10.utime AS utime_20,
  t10.active AS active_21,
  t10.deleted AS deleted_22,
  t10.ref AS ref_23,
  t10.label AS label_24,
  t10.digi_id AS digi_id_25,
  t10.digi_ref AS digi_ref_26,
  t10.cerfa_data AS cerfa_data_27,
  t10.formation_id AS formation_id_28,
  t10.programme_id AS programme_id_29,
  t10.lieu_id AS lieu_id_30,
  t10.salle_id AS salle_id_31,
  t10.creneau_type_id AS creneau_type_id_32,
  t10.digi_account_id AS digi_account_id_33,
  t0.entreprise_id AS entreprise_id_34,
  t35.id AS id_36,
  t35.ctime AS ctime_37,
  t35.utime AS utime_38,
  t35.active AS active_39,
  t35.deleted AS deleted_40,
  t35.ref AS ref_41,
  t35.label AS label_42,
  t35.tel AS tel_43,
  t35.fax AS fax_44,
  t35.email AS email_45,
  t35.adresse AS adresse_46,
  t35.adresse_cp AS adresse_cp_47,
  t35.adresse_ville AS adresse_ville_48,
  t35.digi_id AS digi_id_49,
  t35.digi_ref AS digi_ref_50,
  t35.cerfa_data AS cerfa_data_51,
  t35.digi_account_id AS digi_account_id_52,
  t0.apprenant_id AS apprenant_id_53,
  t54.contrat_debut AS contrat_debut_55,
  t54.contrat_signature AS contrat_signature_56,
  t54.id AS id_57,
  t54.ctime AS ctime_58,
  t54.utime AS utime_59,
  t54.active AS active_60,
  t54.deleted AS deleted_61,
  t54.civilite AS civilite_62,
  t54.nom AS nom_63,
  t54.prenom AS prenom_64,
  t54.tel AS tel_65,
  t54.fax AS fax_66,
  t54.email AS email_67,
  t54.adresse AS adresse_68,
  t54.adresse_cp AS adresse_cp_69,
  t54.adresse_ville AS adresse_ville_70,
  t54.digi_id AS digi_id_71,
  t54.digi_ref AS digi_ref_72,
  t54.cerfa_data AS cerfa_data_73,
  t54.digi_account_id AS digi_account_id_74,
  t0.digi_account_id AS digi_account_id_75
FROM
  session_customer t0
  LEFT JOIN session t10 ON t0.session_id = t10.id
  LEFT JOIN entreprise t35 ON t0.entreprise_id = t35.id
  LEFT JOIN apprenant t54 ON t0.apprenant_id = t54.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.digi_id AS digi_id_6, t0.digi_ref AS digi_ref_7, t0.cerfa_data AS cerfa_data_8, t0.session_id AS session_id_9, t10.customers_nb AS customers_nb_11, t10.afest_jours AS afest_jours_12, t10.debut AS debut_13, t10.fin AS fin_14, t10.diplome AS diplome_15, t10.state AS state_16, t10.remarques AS remarques_17, t10.id AS id_18, t10.ctime AS ctime_19, t10.utime AS utime_20, t10.active AS active_21, t10.deleted AS deleted_22, t10.ref AS ref_23, t10.label AS label_24, t10.digi_id AS digi_id_25, t10.digi_ref AS digi_ref_26, t10.cerfa_data AS cerfa_data_27, t10.formation_id AS formation_id_28, t10.programme_id AS programme_id_29, t10.lieu_id AS lieu_id_30, t10.salle_id AS salle_id_31, t10.creneau_type_id AS creneau_type_id_32, t10.digi_account_id AS digi_account_id_33, t0.entreprise_id AS entreprise_id_34, t35.id AS id_36, t35.ctime AS ctime_37, t35.utime AS utime_38, t35.active AS active_39, t35.deleted AS deleted_40, t35.ref AS ref_41, t35.label AS label_42, t35.tel AS tel_43, t35.fax AS fax_44, t35.email AS email_45, t35.adresse AS adresse_46, t35.adresse_cp AS adresse_cp_47, t35.adresse_ville AS adresse_ville_48, t35.digi_id AS digi_id_49, t35.digi_ref AS digi_ref_50, t35.cerfa_data AS cerfa_data_51, t35.digi_account_id AS digi_account_id_52, t0.apprenant_id AS apprenant_id_53, t54.contrat_debut AS contrat_debut_55, t54.contrat_signature AS contrat_signature_56, t54.id AS id_57, t54.ctime AS ctime_58, t54.utime AS utime_59, t54.active AS active_60, t54.deleted AS deleted_61, t54.civilite AS civilite_62, t54.nom AS nom_63, t54.prenom AS prenom_64, t54.tel AS tel_65, t54.fax AS fax_66, t54.email AS email_67, t54.adresse AS adresse_68, t54.adresse_cp AS adresse_cp_69, t54.adresse_ville AS adresse_ville_70, t54.digi_id AS digi_id_71, t54.digi_ref AS digi_ref_72, t54.cerfa_data AS cerfa_data_73, t54.digi_account_id AS digi_account_id_74, t0.digi_account_id AS digi_account_id_75 FROM session_customer t0 LEFT JOIN session t10 ON t0.session_id = t10.id LEFT JOIN entreprise t35 ON t0.entreprise_id = t35.id LEFT JOIN apprenant t54 ON t0.apprenant_id = t54.id WHERE t0.id = '3056';

SELECT
  t0.heures AS heures_1,
  t0.jours AS jours_2,
  t0.rncp_code AS rncp_code_3,
  t0.diploma_code AS diploma_code_4,
  t0.diploma_label AS diploma_label_5,
  t0.id AS id_6,
  t0.ctime AS ctime_7,
  t0.utime AS utime_8,
  t0.active AS active_9,
  t0.deleted AS deleted_10,
  t0.ref AS ref_11,
  t0.label AS label_12,
  t0.digi_id AS digi_id_13,
  t0.digi_ref AS digi_ref_14,
  t0.cerfa_data AS cerfa_data_15,
  t0.parent_id AS parent_id_16,
  t17.heures AS heures_18,
  t17.jours AS jours_19,
  t17.rncp_code AS rncp_code_20,
  t17.diploma_code AS diploma_code_21,
  t17.diploma_label AS diploma_label_22,
  t17.id AS id_23,
  t17.ctime AS ctime_24,
  t17.utime AS utime_25,
  t17.active AS active_26,
  t17.deleted AS deleted_27,
  t17.ref AS ref_28,
  t17.label AS label_29,
  t17.digi_id AS digi_id_30,
  t17.digi_ref AS digi_ref_31,
  t17.cerfa_data AS cerfa_data_32,
  t17.parent_id AS parent_id_33,
  t17.creneau_id AS creneau_id_34,
  t17.formation_id AS formation_id_35,
  t17.digi_account_id AS digi_account_id_36,
  t0.creneau_id AS creneau_id_37,
  t0.formation_id AS formation_id_38,
  t39.id AS id_40,
  t39.ctime AS ctime_41,
  t39.utime AS utime_42,
  t39.active AS active_43,
  t39.deleted AS deleted_44,
  t39.ref AS ref_45,
  t39.label AS label_46,
  t0.digi_account_id AS digi_account_id_47
FROM
  formation_programme t0
  LEFT JOIN formation_programme t17 ON t0.parent_id = t17.id
  LEFT JOIN formation t39 ON t0.formation_id = t39.id
WHERE
  t0.id IN (?)

SELECT t0.heures AS heures_1, t0.jours AS jours_2, t0.rncp_code AS rncp_code_3, t0.diploma_code AS diploma_code_4, t0.diploma_label AS diploma_label_5, t0.id AS id_6, t0.ctime AS ctime_7, t0.utime AS utime_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.ref AS ref_11, t0.label AS label_12, t0.digi_id AS digi_id_13, t0.digi_ref AS digi_ref_14, t0.cerfa_data AS cerfa_data_15, t0.parent_id AS parent_id_16, t17.heures AS heures_18, t17.jours AS jours_19, t17.rncp_code AS rncp_code_20, t17.diploma_code AS diploma_code_21, t17.diploma_label AS diploma_label_22, t17.id AS id_23, t17.ctime AS ctime_24, t17.utime AS utime_25, t17.active AS active_26, t17.deleted AS deleted_27, t17.ref AS ref_28, t17.label AS label_29, t17.digi_id AS digi_id_30, t17.digi_ref AS digi_ref_31, t17.cerfa_data AS cerfa_data_32, t17.parent_id AS parent_id_33, t17.creneau_id AS creneau_id_34, t17.formation_id AS formation_id_35, t17.digi_account_id AS digi_account_id_36, t0.creneau_id AS creneau_id_37, t0.formation_id AS formation_id_38, t39.id AS id_40, t39.ctime AS ctime_41, t39.utime AS utime_42, t39.active AS active_43, t39.deleted AS deleted_44, t39.ref AS ref_45, t39.label AS label_46, t0.digi_account_id AS digi_account_id_47 FROM formation_programme t0 LEFT JOIN formation_programme t17 ON t0.parent_id = t17.id LEFT JOIN formation t39 ON t0.formation_id = t39.id WHERE t0.id IN (448);

SELECT
  t0.etage AS etage_1,
  t0.capacite AS capacite_2,
  t0.color AS color_3,
  t0.id AS id_4,
  t0.ctime AS ctime_5,
  t0.utime AS utime_6,
  t0.active AS active_7,
  t0.deleted AS deleted_8,
  t0.ref AS ref_9,
  t0.label AS label_10,
  t0.digi_id AS digi_id_11,
  t0.digi_ref AS digi_ref_12,
  t0.lieu_id AS lieu_id_13,
  t14.external AS external_15,
  t14.id AS id_16,
  t14.ctime AS ctime_17,
  t14.utime AS utime_18,
  t14.active AS active_19,
  t14.deleted AS deleted_20,
  t14.ref AS ref_21,
  t14.label AS label_22,
  t14.tel AS tel_23,
  t14.fax AS fax_24,
  t14.email AS email_25,
  t14.adresse AS adresse_26,
  t14.adresse_cp AS adresse_cp_27,
  t14.adresse_ville AS adresse_ville_28,
  t0.parent_id AS parent_id_29,
  t30.etage AS etage_31,
  t30.capacite AS capacite_32,
  t30.color AS color_33,
  t30.id AS id_34,
  t30.ctime AS ctime_35,
  t30.utime AS utime_36,
  t30.active AS active_37,
  t30.deleted AS deleted_38,
  t30.ref AS ref_39,
  t30.label AS label_40,
  t30.digi_id AS digi_id_41,
  t30.digi_ref AS digi_ref_42,
  t30.lieu_id AS lieu_id_43,
  t30.parent_id AS parent_id_44,
  t30.digi_account_id AS digi_account_id_45,
  t0.digi_account_id AS digi_account_id_46
FROM
  salle t0
  LEFT JOIN lieu t14 ON t0.lieu_id = t14.id
  LEFT JOIN salle t30 ON t0.parent_id = t30.id
WHERE
  t0.id IN (?)

SELECT t0.etage AS etage_1, t0.capacite AS capacite_2, t0.color AS color_3, t0.id AS id_4, t0.ctime AS ctime_5, t0.utime AS utime_6, t0.active AS active_7, t0.deleted AS deleted_8, t0.ref AS ref_9, t0.label AS label_10, t0.digi_id AS digi_id_11, t0.digi_ref AS digi_ref_12, t0.lieu_id AS lieu_id_13, t14.external AS external_15, t14.id AS id_16, t14.ctime AS ctime_17, t14.utime AS utime_18, t14.active AS active_19, t14.deleted AS deleted_20, t14.ref AS ref_21, t14.label AS label_22, t14.tel AS tel_23, t14.fax AS fax_24, t14.email AS email_25, t14.adresse AS adresse_26, t14.adresse_cp AS adresse_cp_27, t14.adresse_ville AS adresse_ville_28, t0.parent_id AS parent_id_29, t30.etage AS etage_31, t30.capacite AS capacite_32, t30.color AS color_33, t30.id AS id_34, t30.ctime AS ctime_35, t30.utime AS utime_36, t30.active AS active_37, t30.deleted AS deleted_38, t30.ref AS ref_39, t30.label AS label_40, t30.digi_id AS digi_id_41, t30.digi_ref AS digi_ref_42, t30.lieu_id AS lieu_id_43, t30.parent_id AS parent_id_44, t30.digi_account_id AS digi_account_id_45, t0.digi_account_id AS digi_account_id_46 FROM salle t0 LEFT JOIN lieu t14 ON t0.lieu_id = t14.id LEFT JOIN salle t30 ON t0.parent_id = t30.id WHERE t0.id IN (15);

SELECT
  t0.label AS label_1,
  t0.email AS email_2,
  t0.api_token AS api_token_3,
  t0.id AS id_4,
  t0.ctime AS ctime_5,
  t0.utime AS utime_6,
  t0.active AS active_7,
  t0.deleted AS deleted_8,
  t0.civilite AS civilite_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11
FROM
  digi_account t0

SELECT t0.label AS label_1, t0.email AS email_2, t0.api_token AS api_token_3, t0.id AS id_4, t0.ctime AS ctime_5, t0.utime AS utime_6, t0.active AS active_7, t0.deleted AS deleted_8, t0.civilite AS civilite_9, t0.nom AS nom_10, t0.prenom AS prenom_11 FROM digi_account t0;

SELECT
  t0.id AS id_1,
  t0.ctime AS ctime_2,
  t0.utime AS utime_3,
  t0.active AS active_4,
  t0.deleted AS deleted_5,
  t0.ref AS ref_6,
  t0.label AS label_7
FROM
  user_role t0
  INNER JOIN user_role_user_type ON t0.id = user_role_user_type.user_role_id
WHERE
  user_role_user_type.user_type_id = ?

SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.ref AS ref_6, t0.label AS label_7 FROM user_role t0 INNER JOIN user_role_user_type ON t0.id = user_role_user_type.user_role_id WHERE user_role_user_type.user_type_id = 6;

SELECT
  t0.password AS password_1,
  t0.id AS id_2,
  t0.ctime AS ctime_3,
  t0.utime AS utime_4,
  t0.active AS active_5,
  t0.deleted AS deleted_6,
  t0.civilite AS civilite_7,
  t0.nom AS nom_8,
  t0.prenom AS prenom_9,
  t0.tel AS tel_10,
  t0.fax AS fax_11,
  t0.email AS email_12,
  t0.adresse AS adresse_13,
  t0.adresse_cp AS adresse_cp_14,
  t0.adresse_ville AS adresse_ville_15,
  t0.digi_id AS digi_id_16,
  t0.digi_ref AS digi_ref_17,
  t0.type_id AS type_id_18,
  t19.id AS id_20,
  t19.ctime AS ctime_21,
  t19.utime AS utime_22,
  t19.active AS active_23,
  t19.deleted AS deleted_24,
  t19.ref AS ref_25,
  t19.label AS label_26,
  t0.digi_account_id AS digi_account_id_27
FROM
  user t0
  LEFT JOIN user_type t19 ON t0.type_id = t19.id
WHERE
  t0.id = ?

SELECT t0.password AS password_1, t0.id AS id_2, t0.ctime AS ctime_3, t0.utime AS utime_4, t0.active AS active_5, t0.deleted AS deleted_6, t0.civilite AS civilite_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.tel AS tel_10, t0.fax AS fax_11, t0.email AS email_12, t0.adresse AS adresse_13, t0.adresse_cp AS adresse_cp_14, t0.adresse_ville AS adresse_ville_15, t0.digi_id AS digi_id_16, t0.digi_ref AS digi_ref_17, t0.type_id AS type_id_18, t19.id AS id_20, t19.ctime AS ctime_21, t19.utime AS utime_22, t19.active AS active_23, t19.deleted AS deleted_24, t19.ref AS ref_25, t19.label AS label_26, t0.digi_account_id AS digi_account_id_27 FROM user t0 LEFT JOIN user_type t19 ON t0.type_id = t19.id WHERE t0.id = 6;

SELECT
  t0.contrat_debut AS contrat_debut_1,
  t0.contrat_signature AS contrat_signature_2,
  t0.id AS id_3,
  t0.ctime AS ctime_4,
  t0.utime AS utime_5,
  t0.active AS active_6,
  t0.deleted AS deleted_7,
  t0.civilite AS civilite_8,
  t0.nom AS nom_9,
  t0.prenom AS prenom_10,
  t0.tel AS tel_11,
  t0.fax AS fax_12,
  t0.email AS email_13,
  t0.adresse AS adresse_14,
  t0.adresse_cp AS adresse_cp_15,
  t0.adresse_ville AS adresse_ville_16,
  t0.digi_id AS digi_id_17,
  t0.digi_ref AS digi_ref_18,
  t0.cerfa_data AS cerfa_data_19,
  t0.digi_account_id AS digi_account_id_20
FROM
  apprenant t0
WHERE
  t0.id = ?

SELECT t0.contrat_debut AS contrat_debut_1, t0.contrat_signature AS contrat_signature_2, t0.id AS id_3, t0.ctime AS ctime_4, t0.utime AS utime_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.civilite AS civilite_8, t0.nom AS nom_9, t0.prenom AS prenom_10, t0.tel AS tel_11, t0.fax AS fax_12, t0.email AS email_13, t0.adresse AS adresse_14, t0.adresse_cp AS adresse_cp_15, t0.adresse_ville AS adresse_ville_16, t0.digi_id AS digi_id_17, t0.digi_ref AS digi_ref_18, t0.cerfa_data AS cerfa_data_19, t0.digi_account_id AS digi_account_id_20 FROM apprenant t0 WHERE t0.id = '3252';

SELECT
  t0.type AS type_1,
  t0.value AS value_2,
  t0.id AS id_3,
  t0.ctime AS ctime_4,
  t0.utime AS utime_5,
  t0.active AS active_6,
  t0.deleted AS deleted_7,
  t0.ref AS ref_8,
  t0.label AS label_9
FROM
  param t0
WHERE
  t0.ref = ?
LIMIT
  1

SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.ctime AS ctime_4, t0.utime AS utime_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.ref AS ref_8, t0.label AS label_9 FROM param t0 WHERE t0.ref = 'digi_account_id' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ctime AS ctime_2,
  t0.utime AS utime_3,
  t0.active AS active_4,
  t0.deleted AS deleted_5,
  t0.ref AS ref_6,
  t0.label AS label_7
FROM
  user_role t0
  INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id
WHERE
  user_role_user.user_id = ?

SELECT t0.id AS id_1, t0.ctime AS ctime_2, t0.utime AS utime_3, t0.active AS active_4, t0.deleted AS deleted_5, t0.ref AS ref_6, t0.label AS label_7 FROM user_role t0 INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = 6;