Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 WHERE t0.slug = 'dialogues-en-senologie' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.begins_at AS begins_at_2,
  t0.ends_at AS ends_at_3,
  t0.is_virtual AS is_virtual_4,
  t0.connection_link AS connection_link_5,
  t0.internal_ref AS internal_ref_6,
  t0.start_hour AS start_hour_7,
  t0.end_hour AS end_hour_8,
  t0.min_seats AS min_seats_9,
  t0.max_seats AS max_seats_10,
  t0.is_canceled AS is_canceled_11,
  t0.is_actif AS is_actif_12,
  t0.dpc_num_session AS dpc_num_session_13,
  t0.comment AS comment_14,
  t0.dates_for_certif AS dates_for_certif_15,
  t0.quota_dpc AS quota_dpc_16,
  t0.email_min_reached_received_at AS email_min_reached_received_at_17,
  t0.formation_id AS formation_id_18,
  t0.location_id AS location_id_19
FROM
  session t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.begins_at AS begins_at_2, t0.ends_at AS ends_at_3, t0.is_virtual AS is_virtual_4, t0.connection_link AS connection_link_5, t0.internal_ref AS internal_ref_6, t0.start_hour AS start_hour_7, t0.end_hour AS end_hour_8, t0.min_seats AS min_seats_9, t0.max_seats AS max_seats_10, t0.is_canceled AS is_canceled_11, t0.is_actif AS is_actif_12, t0.dpc_num_session AS dpc_num_session_13, t0.comment AS comment_14, t0.dates_for_certif AS dates_for_certif_15, t0.quota_dpc AS quota_dpc_16, t0.email_min_reached_received_at AS email_min_reached_received_at_17, t0.formation_id AS formation_id_18, t0.location_id AS location_id_19 FROM session t0 WHERE t0.formation_id = 81;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.comment AS comment_3,
  t0.is_available AS is_available_4,
  t0.refund_dpc AS refund_dpc_5,
  t0.formation_id AS formation_id_6,
  t0.funding_id AS funding_id_7
FROM
  formation_funding t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.comment AS comment_3, t0.is_available AS is_available_4, t0.refund_dpc AS refund_dpc_5, t0.formation_id AS formation_id_6, t0.funding_id AS funding_id_7 FROM formation_funding t0 WHERE t0.formation_id = 81;

SELECT
  t0.id AS id_1,
  t0.is_virtual AS is_virtual_2,
  t0.price AS price_3,
  t0.deposit AS deposit_4,
  t0.prise_en_charge_dpc AS prise_en_charge_dpc_5,
  t0.funding_id AS funding_id_6,
  t0.duration_id AS duration_id_7
FROM
  class_price t0
WHERE
  t0.funding_id IN (?)
  AND t0.duration_id = ?

SELECT t0.id AS id_1, t0.is_virtual AS is_virtual_2, t0.price AS price_3, t0.deposit AS deposit_4, t0.prise_en_charge_dpc AS prise_en_charge_dpc_5, t0.funding_id AS funding_id_6, t0.duration_id AS duration_id_7 FROM class_price t0 WHERE t0.funding_id IN (73) AND t0.duration_id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.color AS color_6,
  t0.is_coord_employer AS is_coord_employer_7,
  t0.ref AS ref_8,
  t0.is_active AS is_active_9
FROM
  funding t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.description AS description_4, t0.slug AS slug_5, t0.color AS color_6, t0.is_coord_employer AS is_coord_employer_7, t0.ref AS ref_8, t0.is_active AS is_active_9 FROM funding t0 WHERE t0.id = 73;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.color AS color_5,
  t0.updated_at AS updated_at_6,
  t0.show_order AS show_order_7
FROM
  theme t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.color AS color_5, t0.updated_at AS updated_at_6, t0.show_order AS show_order_7 FROM theme t0;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.short_desc AS short_desc_2,
  t0_.slug AS slug_3,
  t0_.color AS color_4,
  t0_.updated_at AS updated_at_5,
  t0_.show_order AS show_order_6
FROM
  theme t0_
ORDER BY
  t0_.show_order ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.short_desc AS short_desc_2, t0_.slug AS slug_3, t0_.color AS color_4, t0_.updated_at AS updated_at_5, t0_.show_order AS show_order_6 FROM theme t0_ ORDER BY t0_.show_order ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 18;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_desc AS short_desc_3,
  t0.slug AS slug_4,
  t0.is_featured AS is_featured_5,
  t0.image AS image_6,
  t0.image_size AS image_size_7,
  t0.duration AS duration_8,
  t0.updated_at AS updated_at_9,
  t0.programme AS programme_10,
  t0.internal_ref AS internal_ref_11,
  t0.nb_heures AS nb_heures_12,
  t0.featured_comment AS featured_comment_13,
  t0.dpc_num_action AS dpc_num_action_14,
  t0.is_virtual AS is_virtual_15,
  t0.target_audience AS target_audience_16,
  t0.prerequisite AS prerequisite_17,
  t0.objective AS objective_18,
  t0.method AS method_19,
  t0.show_order AS show_order_20,
  t0.text_class_format AS text_class_format_21,
  t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22,
  t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23,
  t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24,
  t0.agremented_dpc_virtual AS agremented_dpc_virtual_25,
  t0.dpc_num_action_virtual AS dpc_num_action_virtual_26,
  t0.text_dpc_virtual AS text_dpc_virtual_27,
  t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28,
  t0.text_dpc_presentiel AS text_dpc_presentiel_29,
  t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30,
  t0.nb_jours_id AS nb_jours_id_31
FROM
  formation t0
  INNER JOIN formation_theme ON t0.id = formation_theme.formation_id
WHERE
  formation_theme.theme_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = 14;