Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.concept AS concept_2,
  p0_.name AS name_3,
  p0_.price AS price_4,
  p0_.credit AS credit_5,
  p0_.start_date AS start_date_6,
  p0_.end_date AS end_date_7,
  p0_.end_date_access_moodle_course AS end_date_access_moodle_course_8,
  p0_.payment_type AS payment_type_9,
  p0_.first_period AS first_period_10,
  p0_.access_test_dates AS access_test_dates_11,
  p0_.preregistration_price AS preregistration_price_12,
  p0_.public_credit_price AS public_credit_price_13,
  p0_.private_credit_price AS private_credit_price_14,
  p0_.public_credit AS public_credit_15,
  p0_.private_credit AS private_credit_16,
  p0_.school_insurance_price AS school_insurance_price_17,
  p0_.accessories_price AS accessories_price_18,
  p0_.expedient_price AS expedient_price_19,
  p0_.ubrate_price AS ubrate_price_20,
  p0_.public_credit_price_with_specific_degree AS public_credit_price_with_specific_degree_21,
  p0_.student_email_notification AS student_email_notification_22,
  p0_.modality_list AS modality_list_23,
  p0_.modality_course_list AS modality_course_list_24,
  p0_.itinerary_course_list AS itinerary_course_list_25,
  p0_.speciality AS speciality_26,
  p0_.moodle_courses AS moodle_courses_27,
  p0_.edition_id AS edition_id_28,
  p0_.rectification_invoice_id AS rectification_invoice_id_29
FROM
  period p0_
WHERE
  p0_.start_date <= ?
  AND p0_.end_date >= ?
  AND p0_.first_period = 1
ORDER BY
  p0_.end_date ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.concept AS concept_2, p0_.name AS name_3, p0_.price AS price_4, p0_.credit AS credit_5, p0_.start_date AS start_date_6, p0_.end_date AS end_date_7, p0_.end_date_access_moodle_course AS end_date_access_moodle_course_8, p0_.payment_type AS payment_type_9, p0_.first_period AS first_period_10, p0_.access_test_dates AS access_test_dates_11, p0_.preregistration_price AS preregistration_price_12, p0_.public_credit_price AS public_credit_price_13, p0_.private_credit_price AS private_credit_price_14, p0_.public_credit AS public_credit_15, p0_.private_credit AS private_credit_16, p0_.school_insurance_price AS school_insurance_price_17, p0_.accessories_price AS accessories_price_18, p0_.expedient_price AS expedient_price_19, p0_.ubrate_price AS ubrate_price_20, p0_.public_credit_price_with_specific_degree AS public_credit_price_with_specific_degree_21, p0_.student_email_notification AS student_email_notification_22, p0_.modality_list AS modality_list_23, p0_.modality_course_list AS modality_course_list_24, p0_.itinerary_course_list AS itinerary_course_list_25, p0_.speciality AS speciality_26, p0_.moodle_courses AS moodle_courses_27, p0_.edition_id AS edition_id_28, p0_.rectification_invoice_id AS rectification_invoice_id_29 FROM period p0_ WHERE p0_.start_date <= '2024-12-23 03:16:00' AND p0_.end_date >= '2024-12-23 03:16:00' AND p0_.first_period = 1 ORDER BY p0_.end_date ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.concept AS concept_3,
  t0.name AS name_4,
  t0.price AS price_5,
  t0.credit AS credit_6,
  t0.start_date AS start_date_7,
  t0.end_date AS end_date_8,
  t0.end_date_access_moodle_course AS end_date_access_moodle_course_9,
  t0.payment_type AS payment_type_10,
  t0.first_period AS first_period_11,
  t0.access_test_dates AS access_test_dates_12,
  t0.preregistration_price AS preregistration_price_13,
  t0.public_credit_price AS public_credit_price_14,
  t0.private_credit_price AS private_credit_price_15,
  t0.public_credit AS public_credit_16,
  t0.private_credit AS private_credit_17,
  t0.school_insurance_price AS school_insurance_price_18,
  t0.accessories_price AS accessories_price_19,
  t0.expedient_price AS expedient_price_20,
  t0.ubrate_price AS ubrate_price_21,
  t0.public_credit_price_with_specific_degree AS public_credit_price_with_specific_degree_22,
  t0.student_email_notification AS student_email_notification_23,
  t0.modality_list AS modality_list_24,
  t0.modality_course_list AS modality_course_list_25,
  t0.itinerary_course_list AS itinerary_course_list_26,
  t0.speciality AS speciality_27,
  t0.moodle_courses AS moodle_courses_28,
  t0.edition_id AS edition_id_29,
  t0.rectification_invoice_id AS rectification_invoice_id_30
FROM
  period t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.concept AS concept_3, t0.name AS name_4, t0.price AS price_5, t0.credit AS credit_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.end_date_access_moodle_course AS end_date_access_moodle_course_9, t0.payment_type AS payment_type_10, t0.first_period AS first_period_11, t0.access_test_dates AS access_test_dates_12, t0.preregistration_price AS preregistration_price_13, t0.public_credit_price AS public_credit_price_14, t0.private_credit_price AS private_credit_price_15, t0.public_credit AS public_credit_16, t0.private_credit AS private_credit_17, t0.school_insurance_price AS school_insurance_price_18, t0.accessories_price AS accessories_price_19, t0.expedient_price AS expedient_price_20, t0.ubrate_price AS ubrate_price_21, t0.public_credit_price_with_specific_degree AS public_credit_price_with_specific_degree_22, t0.student_email_notification AS student_email_notification_23, t0.modality_list AS modality_list_24, t0.modality_course_list AS modality_course_list_25, t0.itinerary_course_list AS itinerary_course_list_26, t0.speciality AS speciality_27, t0.moodle_courses AS moodle_courses_28, t0.edition_id AS edition_id_29, t0.rectification_invoice_id AS rectification_invoice_id_30 FROM period t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.price AS price_4,
  t0.credit AS credit_5,
  t0.training_id AS training_id_6
FROM
  edition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.price AS price_4, t0.credit AS credit_5, t0.training_id AS training_id_6 FROM edition t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.type AS type_4,
  t0.registration_type AS registration_type_5,
  t0.url AS url_6
FROM
  training t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.registration_type AS registration_type_5, t0.url AS url_6 FROM training t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.price AS price_4,
  t0.credit AS credit_5,
  t0.training_id AS training_id_6
FROM
  edition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.price AS price_4, t0.credit AS credit_5, t0.training_id AS training_id_6 FROM edition t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.type AS type_4,
  t0.registration_type AS registration_type_5,
  t0.url AS url_6
FROM
  training t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.registration_type AS registration_type_5, t0.url AS url_6 FROM training t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.price AS price_4,
  t0.credit AS credit_5,
  t0.training_id AS training_id_6
FROM
  edition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.price AS price_4, t0.credit AS credit_5, t0.training_id AS training_id_6 FROM edition t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.type AS type_4,
  t0.registration_type AS registration_type_5,
  t0.url AS url_6
FROM
  training t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.registration_type AS registration_type_5, t0.url AS url_6 FROM training t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.price AS price_4,
  t0.credit AS credit_5,
  t0.training_id AS training_id_6
FROM
  edition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.price AS price_4, t0.credit AS credit_5, t0.training_id AS training_id_6 FROM edition t0 WHERE t0.id = 11;