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
  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.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 (11, 28, 41, 73, 57) AND t0.duration_id = 12;

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 = 53;

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 = 'activites-physiques-cancer-du-sein-avirose' 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.color AS color_5,
  t0.updated_at AS updated_at_6,
  t0.show_order AS show_order_7
FROM
  theme t0
  INNER JOIN formation_theme ON t0.id = formation_theme.theme_id
WHERE
  formation_theme.formation_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.color AS color_5, t0.updated_at AS updated_at_6, t0.show_order AS show_order_7 FROM theme t0 INNER JOIN formation_theme ON t0.id = formation_theme.theme_id WHERE formation_theme.formation_id = 53;

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 = 53;

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 = 28;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.user_id AS user_id_3,
  t0.formation_id AS formation_id_4
FROM
  user_formation t0
WHERE
  t0.formation_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.user_id AS user_id_3, t0.formation_id AS formation_id_4 FROM user_formation t0 WHERE t0.formation_id = 53;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.is_active AS is_active_6,
  t0.reset_token AS reset_token_7,
  t0.expires_at AS expires_at_8,
  t0.email_verification_token AS email_verification_token_9,
  t0.created_at AS created_at_10,
  t11.id AS id_12,
  t11.first_name AS first_name_13,
  t11.last_name AS last_name_14,
  t11.bio AS bio_15,
  t11.primary_address AS primary_address_16,
  t11.secondary_address AS secondary_address_17,
  t11.post_code AS post_code_18,
  t11.city AS city_19,
  t11.country AS country_20,
  t11.sex AS sex_21,
  t11.occupation AS occupation_22,
  t11.student AS student_23,
  t11.rpps AS rpps_24,
  t11.status AS status_25,
  t11.tel_mobile AS tel_mobile_26,
  t11.tel_landing AS tel_landing_27,
  t11.objective AS objective_28,
  t11.is_born_at AS is_born_at_29,
  t11.image AS image_30,
  t11.other_occupation AS other_occupation_31,
  t11.siret AS siret_32,
  t11.teacher_num AS teacher_num_33,
  t11.num_ordre AS num_ordre_34,
  t11.rc_pro AS rc_pro_35,
  t11.slug AS slug_36,
  t11.email_backup AS email_backup_37,
  t11.comment AS comment_38,
  t11.user_id AS user_id_39
FROM
  user t0
  LEFT JOIN user_profile t11 ON t11.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.reset_token AS reset_token_7, t0.expires_at AS expires_at_8, t0.email_verification_token AS email_verification_token_9, t0.created_at AS created_at_10, t11.id AS id_12, t11.first_name AS first_name_13, t11.last_name AS last_name_14, t11.bio AS bio_15, t11.primary_address AS primary_address_16, t11.secondary_address AS secondary_address_17, t11.post_code AS post_code_18, t11.city AS city_19, t11.country AS country_20, t11.sex AS sex_21, t11.occupation AS occupation_22, t11.student AS student_23, t11.rpps AS rpps_24, t11.status AS status_25, t11.tel_mobile AS tel_mobile_26, t11.tel_landing AS tel_landing_27, t11.objective AS objective_28, t11.is_born_at AS is_born_at_29, t11.image AS image_30, t11.other_occupation AS other_occupation_31, t11.siret AS siret_32, t11.teacher_num AS teacher_num_33, t11.num_ordre AS num_ordre_34, t11.rc_pro AS rc_pro_35, t11.slug AS slug_36, t11.email_backup AS email_backup_37, t11.comment AS comment_38, t11.user_id AS user_id_39 FROM user t0 LEFT JOIN user_profile t11 ON t11.user_id = t0.id WHERE t0.id = 111;

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;