Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.identifier AS identifier_1,
  m0_.name AS name_2,
  m0_.cm AS cm_3,
  m0_.td AS td_4,
  m0_.tp AS tp_5,
  m0_.ptut AS ptut_6,
  m0_.vet AS vet_7,
  m0_.codelement AS codelement_8,
  m0_.comment AS comment_9,
  m0_.edited AS edited_10,
  m0_.blocked AS blocked_11,
  m0_.excluded_from_service AS excluded_from_service_12,
  m0_.progression AS progression_13,
  m0_.cc_oral_pct AS cc_oral_pct_14,
  m0_.cc_oral_nb AS cc_oral_nb_15,
  m0_.cc_ecrit_pct AS cc_ecrit_pct_16,
  m0_.cc_ecrit_nb AS cc_ecrit_nb_17,
  m0_.cc_rapport_pct AS cc_rapport_pct_18,
  m0_.cc_rapport_nb AS cc_rapport_nb_19,
  m0_.cc_autre_pct AS cc_autre_pct_20,
  m0_.cc_autre_nb AS cc_autre_nb_21,
  m0_.promo_ecrit_pct AS promo_ecrit_pct_22,
  m0_.promo_ecrit_nb AS promo_ecrit_nb_23,
  m0_.promo_rapport_pct AS promo_rapport_pct_24,
  m0_.promo_rapport_nb AS promo_rapport_nb_25,
  m0_.sae_portfolio_pct AS sae_portfolio_pct_26,
  m0_.sae_portfolio_nb AS sae_portfolio_nb_27,
  m0_.sae_livrable_pct AS sae_livrable_pct_28,
  m0_.sae_livrable_nb AS sae_livrable_nb_29,
  m0_.sae_rapport_pct AS sae_rapport_pct_30,
  m0_.sae_rapport_nb AS sae_rapport_nb_31,
  m0_.sae_soutenance_pct AS sae_soutenance_pct_32,
  m0_.sae_soutenance_nb AS sae_soutenance_nb_33,
  m0_.ent_entreprise_pct AS ent_entreprise_pct_34,
  m0_.ent_entreprise_nb AS ent_entreprise_nb_35,
  m0_.ent_rapport_pct AS ent_rapport_pct_36,
  m0_.ent_rapport_nb AS ent_rapport_nb_37,
  m0_.ent_soutenance_pct AS ent_soutenance_pct_38,
  m0_.ent_soutenance_nb AS ent_soutenance_nb_39,
  m0_.coef_bc1 AS coef_bc1_40,
  m0_.coef_bc2 AS coef_bc2_41,
  m0_.coef_bc3 AS coef_bc3_42,
  m0_.coef_bc4 AS coef_bc4_43,
  m0_.coef_bc5 AS coef_bc5_44,
  m0_.semester_id AS semester_id_45,
  m0_.career_id AS career_id_46,
  m0_.academic_year_id AS academic_year_id_47,
  m0_.leader_id AS leader_id_48
FROM
  module m0_
  LEFT JOIN career c1_ ON m0_.career_id = c1_.id
WHERE
  m0_.academic_year_id = ?
  AND (
    (
      c1_.id IS NULL
      OR c1_.active = 1
    )
  )
  AND m0_.career_id = ?
ORDER BY
  m0_.identifier ASC

SELECT m0_.id AS id_0, m0_.identifier AS identifier_1, m0_.name AS name_2, m0_.cm AS cm_3, m0_.td AS td_4, m0_.tp AS tp_5, m0_.ptut AS ptut_6, m0_.vet AS vet_7, m0_.codelement AS codelement_8, m0_.comment AS comment_9, m0_.edited AS edited_10, m0_.blocked AS blocked_11, m0_.excluded_from_service AS excluded_from_service_12, m0_.progression AS progression_13, m0_.cc_oral_pct AS cc_oral_pct_14, m0_.cc_oral_nb AS cc_oral_nb_15, m0_.cc_ecrit_pct AS cc_ecrit_pct_16, m0_.cc_ecrit_nb AS cc_ecrit_nb_17, m0_.cc_rapport_pct AS cc_rapport_pct_18, m0_.cc_rapport_nb AS cc_rapport_nb_19, m0_.cc_autre_pct AS cc_autre_pct_20, m0_.cc_autre_nb AS cc_autre_nb_21, m0_.promo_ecrit_pct AS promo_ecrit_pct_22, m0_.promo_ecrit_nb AS promo_ecrit_nb_23, m0_.promo_rapport_pct AS promo_rapport_pct_24, m0_.promo_rapport_nb AS promo_rapport_nb_25, m0_.sae_portfolio_pct AS sae_portfolio_pct_26, m0_.sae_portfolio_nb AS sae_portfolio_nb_27, m0_.sae_livrable_pct AS sae_livrable_pct_28, m0_.sae_livrable_nb AS sae_livrable_nb_29, m0_.sae_rapport_pct AS sae_rapport_pct_30, m0_.sae_rapport_nb AS sae_rapport_nb_31, m0_.sae_soutenance_pct AS sae_soutenance_pct_32, m0_.sae_soutenance_nb AS sae_soutenance_nb_33, m0_.ent_entreprise_pct AS ent_entreprise_pct_34, m0_.ent_entreprise_nb AS ent_entreprise_nb_35, m0_.ent_rapport_pct AS ent_rapport_pct_36, m0_.ent_rapport_nb AS ent_rapport_nb_37, m0_.ent_soutenance_pct AS ent_soutenance_pct_38, m0_.ent_soutenance_nb AS ent_soutenance_nb_39, m0_.coef_bc1 AS coef_bc1_40, m0_.coef_bc2 AS coef_bc2_41, m0_.coef_bc3 AS coef_bc3_42, m0_.coef_bc4 AS coef_bc4_43, m0_.coef_bc5 AS coef_bc5_44, m0_.semester_id AS semester_id_45, m0_.career_id AS career_id_46, m0_.academic_year_id AS academic_year_id_47, m0_.leader_id AS leader_id_48 FROM module m0_ LEFT JOIN career c1_ ON m0_.career_id = c1_.id WHERE m0_.academic_year_id = 2 AND ((c1_.id IS NULL OR c1_.active = 1)) AND m0_.career_id = 3 ORDER BY m0_.identifier ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3
FROM
  academic_year t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3 FROM academic_year t0 WHERE t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.cm AS cm_4,
  t0.td AS td_5,
  t0.tp AS tp_6,
  t0.ptut AS ptut_7,
  t0.vet AS vet_8,
  t0.codelement AS codelement_9,
  t0.comment AS comment_10,
  t0.edited AS edited_11,
  t0.blocked AS blocked_12,
  t0.excluded_from_service AS excluded_from_service_13,
  t0.progression AS progression_14,
  t0.cc_oral_pct AS cc_oral_pct_15,
  t0.cc_oral_nb AS cc_oral_nb_16,
  t0.cc_ecrit_pct AS cc_ecrit_pct_17,
  t0.cc_ecrit_nb AS cc_ecrit_nb_18,
  t0.cc_rapport_pct AS cc_rapport_pct_19,
  t0.cc_rapport_nb AS cc_rapport_nb_20,
  t0.cc_autre_pct AS cc_autre_pct_21,
  t0.cc_autre_nb AS cc_autre_nb_22,
  t0.promo_ecrit_pct AS promo_ecrit_pct_23,
  t0.promo_ecrit_nb AS promo_ecrit_nb_24,
  t0.promo_rapport_pct AS promo_rapport_pct_25,
  t0.promo_rapport_nb AS promo_rapport_nb_26,
  t0.sae_portfolio_pct AS sae_portfolio_pct_27,
  t0.sae_portfolio_nb AS sae_portfolio_nb_28,
  t0.sae_livrable_pct AS sae_livrable_pct_29,
  t0.sae_livrable_nb AS sae_livrable_nb_30,
  t0.sae_rapport_pct AS sae_rapport_pct_31,
  t0.sae_rapport_nb AS sae_rapport_nb_32,
  t0.sae_soutenance_pct AS sae_soutenance_pct_33,
  t0.sae_soutenance_nb AS sae_soutenance_nb_34,
  t0.ent_entreprise_pct AS ent_entreprise_pct_35,
  t0.ent_entreprise_nb AS ent_entreprise_nb_36,
  t0.ent_rapport_pct AS ent_rapport_pct_37,
  t0.ent_rapport_nb AS ent_rapport_nb_38,
  t0.ent_soutenance_pct AS ent_soutenance_pct_39,
  t0.ent_soutenance_nb AS ent_soutenance_nb_40,
  t0.coef_bc1 AS coef_bc1_41,
  t0.coef_bc2 AS coef_bc2_42,
  t0.coef_bc3 AS coef_bc3_43,
  t0.coef_bc4 AS coef_bc4_44,
  t0.coef_bc5 AS coef_bc5_45,
  t0.semester_id AS semester_id_46,
  t0.career_id AS career_id_47,
  t0.academic_year_id AS academic_year_id_48,
  t0.leader_id AS leader_id_49
FROM
  module t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.cm AS cm_4, t0.td AS td_5, t0.tp AS tp_6, t0.ptut AS ptut_7, t0.vet AS vet_8, t0.codelement AS codelement_9, t0.comment AS comment_10, t0.edited AS edited_11, t0.blocked AS blocked_12, t0.excluded_from_service AS excluded_from_service_13, t0.progression AS progression_14, t0.cc_oral_pct AS cc_oral_pct_15, t0.cc_oral_nb AS cc_oral_nb_16, t0.cc_ecrit_pct AS cc_ecrit_pct_17, t0.cc_ecrit_nb AS cc_ecrit_nb_18, t0.cc_rapport_pct AS cc_rapport_pct_19, t0.cc_rapport_nb AS cc_rapport_nb_20, t0.cc_autre_pct AS cc_autre_pct_21, t0.cc_autre_nb AS cc_autre_nb_22, t0.promo_ecrit_pct AS promo_ecrit_pct_23, t0.promo_ecrit_nb AS promo_ecrit_nb_24, t0.promo_rapport_pct AS promo_rapport_pct_25, t0.promo_rapport_nb AS promo_rapport_nb_26, t0.sae_portfolio_pct AS sae_portfolio_pct_27, t0.sae_portfolio_nb AS sae_portfolio_nb_28, t0.sae_livrable_pct AS sae_livrable_pct_29, t0.sae_livrable_nb AS sae_livrable_nb_30, t0.sae_rapport_pct AS sae_rapport_pct_31, t0.sae_rapport_nb AS sae_rapport_nb_32, t0.sae_soutenance_pct AS sae_soutenance_pct_33, t0.sae_soutenance_nb AS sae_soutenance_nb_34, t0.ent_entreprise_pct AS ent_entreprise_pct_35, t0.ent_entreprise_nb AS ent_entreprise_nb_36, t0.ent_rapport_pct AS ent_rapport_pct_37, t0.ent_rapport_nb AS ent_rapport_nb_38, t0.ent_soutenance_pct AS ent_soutenance_pct_39, t0.ent_soutenance_nb AS ent_soutenance_nb_40, t0.coef_bc1 AS coef_bc1_41, t0.coef_bc2 AS coef_bc2_42, t0.coef_bc3 AS coef_bc3_43, t0.coef_bc4 AS coef_bc4_44, t0.coef_bc5 AS coef_bc5_45, t0.semester_id AS semester_id_46, t0.career_id AS career_id_47, t0.academic_year_id AS academic_year_id_48, t0.leader_id AS leader_id_49 FROM module t0 WHERE t0.id = '327';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.active AS active_3
FROM
  academic_year t0
ORDER BY
  t0.label DESC

SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3 FROM academic_year t0 ORDER BY t0.label DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.lastname AS lastname_5,
  t0.firstname AS firstname_6,
  t0.service AS service_7,
  t0.other_charges AS other_charges_8,
  t0.other_charges_label AS other_charges_label_9,
  t0.allow_extra AS allow_extra_10,
  t0.nb_extra AS nb_extra_11,
  t0.current_service_hours AS current_service_hours_12,
  t0.code AS code_13,
  t0.type AS type_14,
  t0.rh AS rh_15,
  t0.part1 AS part1_16,
  t0.part2 AS part2_17
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.service AS service_7, t0.other_charges AS other_charges_8, t0.other_charges_label AS other_charges_label_9, t0.allow_extra AS allow_extra_10, t0.nb_extra AS nb_extra_11, t0.current_service_hours AS current_service_hours_12, t0.code AS code_13, t0.type AS type_14, t0.rh AS rh_15, t0.part1 AS part1_16, t0.part2 AS part2_17 FROM `user` t0 WHERE t0.id = 266;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.status AS status_3,
  t0.admin_response AS admin_response_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.type AS type_7,
  t0.requested_cm AS requested_cm_8,
  t0.requested_td AS requested_td_9,
  t0.requested_tp AS requested_tp_10,
  t0.module_id AS module_id_11,
  t0.requested_by_id AS requested_by_id_12
FROM
  mccc_change_request t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.description AS description_2, t0.status AS status_3, t0.admin_response AS admin_response_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.type AS type_7, t0.requested_cm AS requested_cm_8, t0.requested_td AS requested_td_9, t0.requested_tp AS requested_tp_10, t0.module_id AS module_id_11, t0.requested_by_id AS requested_by_id_12 FROM mccc_change_request t0 WHERE t0.module_id = 327 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.module_id AS module_id_3,
  t0.related_module_id AS related_module_id_4
FROM
  module_order t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.module_id AS module_id_3, t0.related_module_id AS related_module_id_4 FROM module_order t0 WHERE t0.module_id = 327;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.td AS td_3,
  t0.tp AS tp_4,
  t0.active AS active_5
FROM
  career t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.td AS td_3, t0.tp AS tp_4, t0.active AS active_5 FROM career t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.max_hours AS max_hours_3,
  t0.active AS active_4
FROM
  semester t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.max_hours AS max_hours_3, t0.active AS active_4 FROM semester t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.block AS block_2,
  t0.cm AS cm_3,
  t0.td AS td_4,
  t0.tp AS tp_5,
  t0.gtd AS gtd_6,
  t0.gtp AS gtp_7,
  t0.ptut AS ptut_8,
  t0.total AS total_9,
  t0.user_id AS user_id_10,
  t0.module_id AS module_id_11,
  t0.academic_year_id AS academic_year_id_12
FROM
  predictive t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.block AS block_2, t0.cm AS cm_3, t0.td AS td_4, t0.tp AS tp_5, t0.gtd AS gtd_6, t0.gtp AS gtp_7, t0.ptut AS ptut_8, t0.total AS total_9, t0.user_id AS user_id_10, t0.module_id AS module_id_11, t0.academic_year_id AS academic_year_id_12 FROM predictive t0 WHERE t0.module_id = 327;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.lastname AS lastname_5,
  t0.firstname AS firstname_6,
  t0.service AS service_7,
  t0.other_charges AS other_charges_8,
  t0.other_charges_label AS other_charges_label_9,
  t0.allow_extra AS allow_extra_10,
  t0.nb_extra AS nb_extra_11,
  t0.current_service_hours AS current_service_hours_12,
  t0.code AS code_13,
  t0.type AS type_14,
  t0.rh AS rh_15,
  t0.part1 AS part1_16,
  t0.part2 AS part2_17
FROM
  `user` t0
ORDER BY
  t0.lastname ASC,
  t0.firstname ASC

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.service AS service_7, t0.other_charges AS other_charges_8, t0.other_charges_label AS other_charges_label_9, t0.allow_extra AS allow_extra_10, t0.nb_extra AS nb_extra_11, t0.current_service_hours AS current_service_hours_12, t0.code AS code_13, t0.type AS type_14, t0.rh AS rh_15, t0.part1 AS part1_16, t0.part2 AS part2_17 FROM `user` t0 ORDER BY t0.lastname ASC, t0.firstname ASC;

SELECT
  t0.id AS id_1,
  t0.channel AS channel_2,
  t0.body AS body_3,
  t0.created_at AS created_at_4,
  t0.module_id AS module_id_5,
  t0.author_id AS author_id_6
FROM
  module_comment t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.channel AS channel_2, t0.body AS body_3, t0.created_at AS created_at_4, t0.module_id AS module_id_5, t0.author_id AS author_id_6 FROM module_comment t0 WHERE t0.module_id = 327 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.td_groups AS td_groups_2,
  t0.tp_groups AS tp_groups_3,
  t0.academic_year_id AS academic_year_id_4,
  t0.career_id AS career_id_5,
  t0.semester_id AS semester_id_6
FROM
  career_semester_group t0
WHERE
  t0.academic_year_id = ?

SELECT t0.id AS id_1, t0.td_groups AS td_groups_2, t0.tp_groups AS tp_groups_3, t0.academic_year_id AS academic_year_id_4, t0.career_id AS career_id_5, t0.semester_id AS semester_id_6 FROM career_semester_group t0 WHERE t0.academic_year_id = 2;