Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.ranking AS ranking_3,
  t0.slug AS slug_4,
  t0.is_visible AS is_visible_5,
  t0.front_page AS front_page_6,
  t0.catch_phrase AS catch_phrase_7,
  t0.prerequisite AS prerequisite_8,
  t0.header_desktop_name AS header_desktop_name_9,
  t0.header_desktop_size AS header_desktop_size_10,
  t0.header_mobile_name AS header_mobile_name_11,
  t0.header_mobile_size AS header_mobile_size_12,
  t0.card_image_name AS card_image_name_13,
  t0.card_image_size AS card_image_size_14,
  t0.band_image_name AS band_image_name_15,
  t0.band_image_size AS band_image_size_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.eligible_cpf AS eligible_cpf_19,
  t0.job_opening_content_intro AS job_opening_content_intro_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22,
  t0.acronym AS acronym_23,
  t0.category_id AS category_id_24,
  t0.discr,
  t0.target_profile AS target_profile_25,
  t0.price AS price_26,
  t0.dead_line AS dead_line_27,
  t0.certificate AS certificate_28,
  t0.goal AS goal_29,
  t0.presentation AS presentation_30,
  t0.program AS program_31,
  t0.success_rate AS success_rate_32,
  t0.head_section_title AS head_section_title_33,
  t0.head_section_content AS head_section_content_34,
  t0.validation_goal AS validation_goal_35,
  t0.professional_outlet_intro AS professional_outlet_intro_36,
  t0.professional_outlet_places AS professional_outlet_places_37,
  t0.professional_outlet_outro AS professional_outlet_outro_38,
  t0.participant_number AS participant_number_39,
  t0.place AS place_40,
  t0.market_label AS market_label_41,
  t0.open_to_all AS open_to_all_42,
  t0.public_in_difficulty AS public_in_difficulty_43,
  t0.duration_in_day_min AS duration_in_day_min_44,
  t0.duration_in_day_max AS duration_in_day_max_45,
  t0.goal_short_training AS goal_short_training_46,
  t0.tools AS tools_47,
  t0.teaching_method AS teaching_method_48,
  t0.access_modalities AS access_modalities_49,
  t0.program_short_training AS program_short_training_50,
  t0.accessibility_info AS accessibility_info_51,
  t0.summary AS summary_52,
  t0.evaluation_methods AS evaluation_methods_53,
  t0.benefits_list AS benefits_list_54,
  t0.price_inter AS price_inter_55,
  t0.price_intra AS price_intra_56,
  t0.price_inter_remote AS price_inter_remote_57,
  t0.price_intra_remote AS price_intra_remote_58
FROM
  training t0
WHERE
  t0.front_page = ?
  AND t0.discr IN (
    'diplomaTraining', 'shortTraining'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.category_id AS category_id_24, t0.discr, t0.target_profile AS target_profile_25, t0.price AS price_26, t0.dead_line AS dead_line_27, t0.certificate AS certificate_28, t0.goal AS goal_29, t0.presentation AS presentation_30, t0.program AS program_31, t0.success_rate AS success_rate_32, t0.head_section_title AS head_section_title_33, t0.head_section_content AS head_section_content_34, t0.validation_goal AS validation_goal_35, t0.professional_outlet_intro AS professional_outlet_intro_36, t0.professional_outlet_places AS professional_outlet_places_37, t0.professional_outlet_outro AS professional_outlet_outro_38, t0.participant_number AS participant_number_39, t0.place AS place_40, t0.market_label AS market_label_41, t0.open_to_all AS open_to_all_42, t0.public_in_difficulty AS public_in_difficulty_43, t0.duration_in_day_min AS duration_in_day_min_44, t0.duration_in_day_max AS duration_in_day_max_45, t0.goal_short_training AS goal_short_training_46, t0.tools AS tools_47, t0.teaching_method AS teaching_method_48, t0.access_modalities AS access_modalities_49, t0.program_short_training AS program_short_training_50, t0.accessibility_info AS accessibility_info_51, t0.summary AS summary_52, t0.evaluation_methods AS evaluation_methods_53, t0.benefits_list AS benefits_list_54, t0.price_inter AS price_inter_55, t0.price_intra AS price_intra_56, t0.price_inter_remote AS price_inter_remote_57, t0.price_intra_remote AS price_intra_remote_58 FROM training t0 WHERE t0.front_page = 1 AND t0.discr IN ('diplomaTraining', 'shortTraining') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.place AS place_6,
  t0.duration_in_month AS duration_in_month_7,
  t0.training_file AS training_file_8,
  t0.remote AS remote_9,
  t0.training_id AS training_id_10
FROM
  session t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.place AS place_6, t0.duration_in_month AS duration_in_month_7, t0.training_file AS training_file_8, t0.remote AS remote_9, t0.training_id AS training_id_10 FROM session t0 WHERE t0.training_id = 25;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.ranking AS ranking_3,
  t0.slug AS slug_4,
  t0.is_visible AS is_visible_5,
  t0.front_page AS front_page_6,
  t0.catch_phrase AS catch_phrase_7,
  t0.prerequisite AS prerequisite_8,
  t0.header_desktop_name AS header_desktop_name_9,
  t0.header_desktop_size AS header_desktop_size_10,
  t0.header_mobile_name AS header_mobile_name_11,
  t0.header_mobile_size AS header_mobile_size_12,
  t0.card_image_name AS card_image_name_13,
  t0.card_image_size AS card_image_size_14,
  t0.band_image_name AS band_image_name_15,
  t0.band_image_size AS band_image_size_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.eligible_cpf AS eligible_cpf_19,
  t0.job_opening_content_intro AS job_opening_content_intro_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22,
  t0.acronym AS acronym_23,
  t0.category_id AS category_id_24,
  t0.discr,
  t0.target_profile AS target_profile_25,
  t0.price AS price_26,
  t0.dead_line AS dead_line_27,
  t0.certificate AS certificate_28,
  t0.goal AS goal_29,
  t0.presentation AS presentation_30,
  t0.program AS program_31,
  t0.success_rate AS success_rate_32,
  t0.head_section_title AS head_section_title_33,
  t0.head_section_content AS head_section_content_34,
  t0.validation_goal AS validation_goal_35,
  t0.professional_outlet_intro AS professional_outlet_intro_36,
  t0.professional_outlet_places AS professional_outlet_places_37,
  t0.professional_outlet_outro AS professional_outlet_outro_38,
  t0.participant_number AS participant_number_39,
  t0.place AS place_40,
  t0.market_label AS market_label_41,
  t0.open_to_all AS open_to_all_42,
  t0.public_in_difficulty AS public_in_difficulty_43,
  t0.duration_in_day_min AS duration_in_day_min_44,
  t0.duration_in_day_max AS duration_in_day_max_45,
  t0.goal_short_training AS goal_short_training_46,
  t0.tools AS tools_47,
  t0.teaching_method AS teaching_method_48,
  t0.access_modalities AS access_modalities_49,
  t0.program_short_training AS program_short_training_50,
  t0.accessibility_info AS accessibility_info_51,
  t0.summary AS summary_52,
  t0.evaluation_methods AS evaluation_methods_53,
  t0.benefits_list AS benefits_list_54,
  t0.price_inter AS price_inter_55,
  t0.price_intra AS price_intra_56,
  t0.price_inter_remote AS price_inter_remote_57,
  t0.price_intra_remote AS price_intra_remote_58
FROM
  training t0
WHERE
  t0.category_id = ?
  AND t0.discr IN (
    'diplomaTraining', 'shortTraining'
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.category_id AS category_id_24, t0.discr, t0.target_profile AS target_profile_25, t0.price AS price_26, t0.dead_line AS dead_line_27, t0.certificate AS certificate_28, t0.goal AS goal_29, t0.presentation AS presentation_30, t0.program AS program_31, t0.success_rate AS success_rate_32, t0.head_section_title AS head_section_title_33, t0.head_section_content AS head_section_content_34, t0.validation_goal AS validation_goal_35, t0.professional_outlet_intro AS professional_outlet_intro_36, t0.professional_outlet_places AS professional_outlet_places_37, t0.professional_outlet_outro AS professional_outlet_outro_38, t0.participant_number AS participant_number_39, t0.place AS place_40, t0.market_label AS market_label_41, t0.open_to_all AS open_to_all_42, t0.public_in_difficulty AS public_in_difficulty_43, t0.duration_in_day_min AS duration_in_day_min_44, t0.duration_in_day_max AS duration_in_day_max_45, t0.goal_short_training AS goal_short_training_46, t0.tools AS tools_47, t0.teaching_method AS teaching_method_48, t0.access_modalities AS access_modalities_49, t0.program_short_training AS program_short_training_50, t0.accessibility_info AS accessibility_info_51, t0.summary AS summary_52, t0.evaluation_methods AS evaluation_methods_53, t0.benefits_list AS benefits_list_54, t0.price_inter AS price_inter_55, t0.price_intra AS price_intra_56, t0.price_inter_remote AS price_inter_remote_57, t0.price_intra_remote AS price_intra_remote_58 FROM training t0 WHERE t0.category_id = 3 AND t0.discr IN ('diplomaTraining', 'shortTraining');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.color AS color_4,
  t0.slug AS slug_5,
  t0.catalog AS catalog_6
FROM
  training_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.color AS color_4, t0.slug AS slug_5, t0.catalog AS catalog_6 FROM training_category t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.image_size AS image_size_4,
  t0.quotation AS quotation_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.category_id AS category_id_8
FROM
  alumni_highlight t0
LIMIT
  3

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.quotation AS quotation_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.category_id AS category_id_8 FROM alumni_highlight t0 LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.ranking AS ranking_3,
  t0.slug AS slug_4,
  t0.is_visible AS is_visible_5,
  t0.front_page AS front_page_6,
  t0.catch_phrase AS catch_phrase_7,
  t0.prerequisite AS prerequisite_8,
  t0.header_desktop_name AS header_desktop_name_9,
  t0.header_desktop_size AS header_desktop_size_10,
  t0.header_mobile_name AS header_mobile_name_11,
  t0.header_mobile_size AS header_mobile_size_12,
  t0.card_image_name AS card_image_name_13,
  t0.card_image_size AS card_image_size_14,
  t0.band_image_name AS band_image_name_15,
  t0.band_image_size AS band_image_size_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.eligible_cpf AS eligible_cpf_19,
  t0.job_opening_content_intro AS job_opening_content_intro_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22,
  t0.acronym AS acronym_23,
  t0.participant_number AS participant_number_24,
  t0.place AS place_25,
  t0.market_label AS market_label_26,
  t0.open_to_all AS open_to_all_27,
  t0.public_in_difficulty AS public_in_difficulty_28,
  t0.duration_in_day_min AS duration_in_day_min_29,
  t0.duration_in_day_max AS duration_in_day_max_30,
  t0.goal_short_training AS goal_short_training_31,
  t0.tools AS tools_32,
  t0.teaching_method AS teaching_method_33,
  t0.access_modalities AS access_modalities_34,
  t0.program_short_training AS program_short_training_35,
  t0.accessibility_info AS accessibility_info_36,
  t0.summary AS summary_37,
  t0.evaluation_methods AS evaluation_methods_38,
  t0.benefits_list AS benefits_list_39,
  t0.price_inter AS price_inter_40,
  t0.price_intra AS price_intra_41,
  t0.price_inter_remote AS price_inter_remote_42,
  t0.price_intra_remote AS price_intra_remote_43,
  t0.category_id AS category_id_44,
  t0.discr
FROM
  training t0
WHERE
  t0.is_visible = ?
  AND t0.discr IN ('shortTraining')
ORDER BY
  t0.ranking ASC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.participant_number AS participant_number_24, t0.place AS place_25, t0.market_label AS market_label_26, t0.open_to_all AS open_to_all_27, t0.public_in_difficulty AS public_in_difficulty_28, t0.duration_in_day_min AS duration_in_day_min_29, t0.duration_in_day_max AS duration_in_day_max_30, t0.goal_short_training AS goal_short_training_31, t0.tools AS tools_32, t0.teaching_method AS teaching_method_33, t0.access_modalities AS access_modalities_34, t0.program_short_training AS program_short_training_35, t0.accessibility_info AS accessibility_info_36, t0.summary AS summary_37, t0.evaluation_methods AS evaluation_methods_38, t0.benefits_list AS benefits_list_39, t0.price_inter AS price_inter_40, t0.price_intra AS price_intra_41, t0.price_inter_remote AS price_inter_remote_42, t0.price_intra_remote AS price_intra_remote_43, t0.category_id AS category_id_44, t0.discr FROM training t0 WHERE t0.is_visible = 1 AND t0.discr IN ('shortTraining') ORDER BY t0.ranking ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.ranking AS ranking_3,
  t0.slug AS slug_4,
  t0.is_visible AS is_visible_5,
  t0.front_page AS front_page_6,
  t0.catch_phrase AS catch_phrase_7,
  t0.prerequisite AS prerequisite_8,
  t0.header_desktop_name AS header_desktop_name_9,
  t0.header_desktop_size AS header_desktop_size_10,
  t0.header_mobile_name AS header_mobile_name_11,
  t0.header_mobile_size AS header_mobile_size_12,
  t0.card_image_name AS card_image_name_13,
  t0.card_image_size AS card_image_size_14,
  t0.band_image_name AS band_image_name_15,
  t0.band_image_size AS band_image_size_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.eligible_cpf AS eligible_cpf_19,
  t0.job_opening_content_intro AS job_opening_content_intro_20,
  t0.meta_title AS meta_title_21,
  t0.meta_description AS meta_description_22,
  t0.acronym AS acronym_23,
  t0.target_profile AS target_profile_24,
  t0.price AS price_25,
  t0.dead_line AS dead_line_26,
  t0.certificate AS certificate_27,
  t0.goal AS goal_28,
  t0.presentation AS presentation_29,
  t0.program AS program_30,
  t0.success_rate AS success_rate_31,
  t0.head_section_title AS head_section_title_32,
  t0.head_section_content AS head_section_content_33,
  t0.validation_goal AS validation_goal_34,
  t0.professional_outlet_intro AS professional_outlet_intro_35,
  t0.professional_outlet_places AS professional_outlet_places_36,
  t0.professional_outlet_outro AS professional_outlet_outro_37,
  t0.category_id AS category_id_38,
  t0.discr
FROM
  training t0
WHERE
  t0.is_visible = ?
  AND t0.discr IN ('diplomaTraining')
ORDER BY
  t0.ranking ASC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.ranking AS ranking_3, t0.slug AS slug_4, t0.is_visible AS is_visible_5, t0.front_page AS front_page_6, t0.catch_phrase AS catch_phrase_7, t0.prerequisite AS prerequisite_8, t0.header_desktop_name AS header_desktop_name_9, t0.header_desktop_size AS header_desktop_size_10, t0.header_mobile_name AS header_mobile_name_11, t0.header_mobile_size AS header_mobile_size_12, t0.card_image_name AS card_image_name_13, t0.card_image_size AS card_image_size_14, t0.band_image_name AS band_image_name_15, t0.band_image_size AS band_image_size_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.eligible_cpf AS eligible_cpf_19, t0.job_opening_content_intro AS job_opening_content_intro_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.acronym AS acronym_23, t0.target_profile AS target_profile_24, t0.price AS price_25, t0.dead_line AS dead_line_26, t0.certificate AS certificate_27, t0.goal AS goal_28, t0.presentation AS presentation_29, t0.program AS program_30, t0.success_rate AS success_rate_31, t0.head_section_title AS head_section_title_32, t0.head_section_content AS head_section_content_33, t0.validation_goal AS validation_goal_34, t0.professional_outlet_intro AS professional_outlet_intro_35, t0.professional_outlet_places AS professional_outlet_places_36, t0.professional_outlet_outro AS professional_outlet_outro_37, t0.category_id AS category_id_38, t0.discr FROM training t0 WHERE t0.is_visible = 1 AND t0.discr IN ('diplomaTraining') ORDER BY t0.ranking ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  partners_logotype t0

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM partners_logotype t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.catch_phrase AS catch_phrase_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.body AS body_6,
  t0.cta_text AS cta_text_7,
  t0.cta_link AS cta_link_8,
  t0.image_name AS image_name_9,
  t0.image_size AS image_size_10,
  t0.video_link AS video_link_11,
  t0.published AS published_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.slug AS slug_15,
  t0.body_second AS body_second_16,
  t0.category_id AS category_id_17
FROM
  article t0
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.catch_phrase AS catch_phrase_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.body AS body_6, t0.cta_text AS cta_text_7, t0.cta_link AS cta_link_8, t0.image_name AS image_name_9, t0.image_size AS image_size_10, t0.video_link AS video_link_11, t0.published AS published_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.slug AS slug_15, t0.body_second AS body_second_16, t0.category_id AS category_id_17 FROM article t0 ORDER BY t0.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.learner_number AS learner_number_2,
  t0.training_number AS training_number_3,
  t0.insertion_percentage AS insertion_percentage_4
FROM
  kpi t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.learner_number AS learner_number_2, t0.training_number AS training_number_3, t0.insertion_percentage AS insertion_percentage_4 FROM kpi t0 WHERE t0.id = 1;