Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.display_name AS display_name_1,
  c0_.price AS price_2,
  c0_.start_date AS start_date_3,
  c0_.end_date AS end_date_4,
  c0_.mid_level_exam_date AS mid_level_exam_date_5,
  c0_.end_level_exam_date AS end_level_exam_date_6,
  c0_.nb_course AS nb_course_7,
  c0_.display_schedule AS display_schedule_8,
  c0_.seat AS seat_9,
  c0_.display_schedule_en AS display_schedule_en_10,
  c0_.display_name_en AS display_name_en_11,
  c0_.total_lost_minutes AS total_lost_minutes_12,
  c0_.is_close AS is_close_13,
  c0_.period AS period_14,
  c0_.course_duration AS course_duration_15,
  c0_.is_custom AS is_custom_16,
  c0_.is_deleted AS is_deleted_17,
  s1_.id AS id_18,
  s1_.name AS name_19,
  s1_.level AS level_20,
  s1_.order AS order_21,
  s1_.name_en AS name_en_22,
  s1_.is_session AS is_session_23,
  s1_.session_price AS session_price_24,
  s1_.session_is_public AS session_is_public_25,
  s1_.session_nb_course AS session_nb_course_26,
  s1_.session_nb_course_min_by_week AS session_nb_course_min_by_week_27,
  s1_.session_duration AS session_duration_28,
  s1_.session_seats AS session_seats_29,
  s2_.id AS id_30,
  s2_.name AS name_31,
  s2_.description AS description_32,
  s2_.name_en AS name_en_33,
  s2_.description_en AS description_en_34,
  s2_.is_free AS is_free_35,
  s2_.has_level AS has_level_36,
  s2_.price AS price_37,
  s2_.is_public AS is_public_38,
  s2_.tag_name AS tag_name_39,
  s2_.is_default AS is_default_40,
  s2_.has_mid_exam AS has_mid_exam_41,
  s2_.has_end_exam AS has_end_exam_42,
  s2_.has_oral_exam AS has_oral_exam_43,
  t3_.id AS id_44,
  t3_.hourly_salary AS hourly_salary_45,
  t3_.is_grader AS is_grader_46,
  t3_.for_children AS for_children_47,
  t3_.hourly_salary_waiting AS hourly_salary_waiting_48,
  t3_.slack_channel AS slack_channel_49,
  t3_.iban AS iban_50,
  t3_.address AS address_51,
  t3_.city AS city_52,
  t3_.zip_code AS zip_code_53,
  t3_.country AS country_54,
  t3_.is_actif AS is_actif_55,
  t3_.is_level_test AS is_level_test_56,
  t3_.is_camera AS is_camera_57,
  t3_.addon_for_arabic AS addon_for_arabic_58,
  t3_.addon_for_quran AS addon_for_quran_59,
  t3_.addon_for_children AS addon_for_children_60,
  t3_.is_beginner AS is_beginner_61,
  t3_.is_intermediate AS is_intermediate_62,
  t3_.is_advanced AS is_advanced_63,
  t3_.currency AS currency_64,
  t3_.group_salary AS group_salary_65,
  t3_.group_waiting_salary AS group_waiting_salary_66,
  a4_.id AS id_67,
  a4_.email AS email_68,
  a4_.password AS password_69,
  a4_.firstname AS firstname_70,
  a4_.lastname AS lastname_71,
  a4_.phone AS phone_72,
  a4_.registration_date AS registration_date_73,
  a4_.roles AS roles_74,
  a4_.language AS language_75,
  a4_.pole AS pole_76,
  a4_.forum_url AS forum_url_77,
  a4_.agreed_terms_at AS agreed_terms_at_78,
  a4_.stripe_customer_id_for_subscription AS stripe_customer_id_for_subscription_79,
  a4_.stripe_customer_id_for_group_session AS stripe_customer_id_for_group_session_80,
  g5_.id AS id_81,
  g5_.name AS name_82,
  g5_.name_en AS name_en_83,
  c0_.teacher_id AS teacher_id_84,
  c0_.level_id AS level_id_85,
  s1_.subject_id AS subject_id_86,
  s2_.category_id AS category_id_87,
  t3_.user_id_id AS user_id_id_88,
  t3_.qiraa_id AS qiraa_id_89,
  a4_.gender_id AS gender_id_90
FROM
  course_session c0_
  INNER JOIN subject_level s1_ ON c0_.level_id = s1_.id
  INNER JOIN subject s2_ ON s1_.subject_id = s2_.id
  INNER JOIN teacher t3_ ON c0_.teacher_id = t3_.id
  INNER JOIN app_users a4_ ON t3_.user_id_id = a4_.id
  INNER JOIN gender g5_ ON a4_.gender_id = g5_.id
WHERE
  s2_.tag_name = ?
  AND g5_.name = ?
  AND c0_.is_close = ?
ORDER BY
  s1_.order ASC

SELECT c0_.id AS id_0, c0_.display_name AS display_name_1, c0_.price AS price_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.mid_level_exam_date AS mid_level_exam_date_5, c0_.end_level_exam_date AS end_level_exam_date_6, c0_.nb_course AS nb_course_7, c0_.display_schedule AS display_schedule_8, c0_.seat AS seat_9, c0_.display_schedule_en AS display_schedule_en_10, c0_.display_name_en AS display_name_en_11, c0_.total_lost_minutes AS total_lost_minutes_12, c0_.is_close AS is_close_13, c0_.period AS period_14, c0_.course_duration AS course_duration_15, c0_.is_custom AS is_custom_16, c0_.is_deleted AS is_deleted_17, s1_.id AS id_18, s1_.name AS name_19, s1_.level AS level_20, s1_.order AS order_21, s1_.name_en AS name_en_22, s1_.is_session AS is_session_23, s1_.session_price AS session_price_24, s1_.session_is_public AS session_is_public_25, s1_.session_nb_course AS session_nb_course_26, s1_.session_nb_course_min_by_week AS session_nb_course_min_by_week_27, s1_.session_duration AS session_duration_28, s1_.session_seats AS session_seats_29, s2_.id AS id_30, s2_.name AS name_31, s2_.description AS description_32, s2_.name_en AS name_en_33, s2_.description_en AS description_en_34, s2_.is_free AS is_free_35, s2_.has_level AS has_level_36, s2_.price AS price_37, s2_.is_public AS is_public_38, s2_.tag_name AS tag_name_39, s2_.is_default AS is_default_40, s2_.has_mid_exam AS has_mid_exam_41, s2_.has_end_exam AS has_end_exam_42, s2_.has_oral_exam AS has_oral_exam_43, t3_.id AS id_44, t3_.hourly_salary AS hourly_salary_45, t3_.is_grader AS is_grader_46, t3_.for_children AS for_children_47, t3_.hourly_salary_waiting AS hourly_salary_waiting_48, t3_.slack_channel AS slack_channel_49, t3_.iban AS iban_50, t3_.address AS address_51, t3_.city AS city_52, t3_.zip_code AS zip_code_53, t3_.country AS country_54, t3_.is_actif AS is_actif_55, t3_.is_level_test AS is_level_test_56, t3_.is_camera AS is_camera_57, t3_.addon_for_arabic AS addon_for_arabic_58, t3_.addon_for_quran AS addon_for_quran_59, t3_.addon_for_children AS addon_for_children_60, t3_.is_beginner AS is_beginner_61, t3_.is_intermediate AS is_intermediate_62, t3_.is_advanced AS is_advanced_63, t3_.currency AS currency_64, t3_.group_salary AS group_salary_65, t3_.group_waiting_salary AS group_waiting_salary_66, a4_.id AS id_67, a4_.email AS email_68, a4_.password AS password_69, a4_.firstname AS firstname_70, a4_.lastname AS lastname_71, a4_.phone AS phone_72, a4_.registration_date AS registration_date_73, a4_.roles AS roles_74, a4_.language AS language_75, a4_.pole AS pole_76, a4_.forum_url AS forum_url_77, a4_.agreed_terms_at AS agreed_terms_at_78, a4_.stripe_customer_id_for_subscription AS stripe_customer_id_for_subscription_79, a4_.stripe_customer_id_for_group_session AS stripe_customer_id_for_group_session_80, g5_.id AS id_81, g5_.name AS name_82, g5_.name_en AS name_en_83, c0_.teacher_id AS teacher_id_84, c0_.level_id AS level_id_85, s1_.subject_id AS subject_id_86, s2_.category_id AS category_id_87, t3_.user_id_id AS user_id_id_88, t3_.qiraa_id AS qiraa_id_89, a4_.gender_id AS gender_id_90 FROM course_session c0_ INNER JOIN subject_level s1_ ON c0_.level_id = s1_.id INNER JOIN subject s2_ ON s1_.subject_id = s2_.id INNER JOIN teacher t3_ ON c0_.teacher_id = t3_.id INNER JOIN app_users a4_ ON t3_.user_id_id = a4_.id INNER JOIN gender g5_ ON a4_.gender_id = g5_.id WHERE s2_.tag_name = 'takallam' AND g5_.name = 'masculin' AND c0_.is_close = 0 ORDER BY s1_.order ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3
FROM
  gender t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3 FROM gender t0 WHERE t0.name = 'masculin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.name_en AS name_en_4,
  t0.description_en AS description_en_5,
  t0.is_free AS is_free_6,
  t0.has_level AS has_level_7,
  t0.price AS price_8,
  t0.is_public AS is_public_9,
  t0.tag_name AS tag_name_10,
  t0.is_default AS is_default_11,
  t0.has_mid_exam AS has_mid_exam_12,
  t0.has_end_exam AS has_end_exam_13,
  t0.has_oral_exam AS has_oral_exam_14,
  t0.category_id AS category_id_15
FROM
  subject t0
WHERE
  t0.tag_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.name_en AS name_en_4, t0.description_en AS description_en_5, t0.is_free AS is_free_6, t0.has_level AS has_level_7, t0.price AS price_8, t0.is_public AS is_public_9, t0.tag_name AS tag_name_10, t0.is_default AS is_default_11, t0.has_mid_exam AS has_mid_exam_12, t0.has_end_exam AS has_end_exam_13, t0.has_oral_exam AS has_oral_exam_14, t0.category_id AS category_id_15 FROM subject t0 WHERE t0.tag_name = 'takallam' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4
FROM
  holiday t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4 FROM holiday t0;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.link_fr AS link_fr_3,
  t0.link_en AS link_en_4,
  t0.is_pdf AS is_pdf_5,
  t0.subject_id AS subject_id_6,
  t0.subject_level_id AS subject_level_id_7
FROM
  level_test t0
WHERE
  t0.type = ?
  AND t0.subject_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.link_fr AS link_fr_3, t0.link_en AS link_en_4, t0.is_pdf AS is_pdf_5, t0.subject_id AS subject_id_6, t0.subject_level_id AS subject_level_id_7 FROM level_test t0 WHERE t0.type = 'info' AND t0.subject_id = 33 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.open_registration_date AS open_registration_date_2,
  t0.close_registration_date AS close_registration_date_3,
  t0.subscribe_form_fr AS subscribe_form_fr_4,
  t0.subscribe_form_en AS subscribe_form_en_5,
  t0.session_duration_by_week AS session_duration_by_week_6,
  t0.start_at AS start_at_7,
  t0.subject_id AS subject_id_8
FROM
  session_registration_date t0
WHERE
  t0.subject_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.open_registration_date AS open_registration_date_2, t0.close_registration_date AS close_registration_date_3, t0.subscribe_form_fr AS subscribe_form_fr_4, t0.subscribe_form_en AS subscribe_form_en_5, t0.session_duration_by_week AS session_duration_by_week_6, t0.start_at AS start_at_7, t0.subject_id AS subject_id_8 FROM session_registration_date t0 WHERE t0.subject_id = 33 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.is_for_group AS is_for_group_3,
  t0.url_parameter AS url_parameter_4,
  t0.type AS type_5,
  t0.description AS description_6,
  t0.stripe_name AS stripe_name_7,
  t0.plan AS plan_8,
  t0.is_for_continue AS is_for_continue_9,
  t0.subject_id AS subject_id_10
FROM
  discount t0
WHERE
  t0.url_parameter IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.is_for_group AS is_for_group_3, t0.url_parameter AS url_parameter_4, t0.type AS type_5, t0.description AS description_6, t0.stripe_name AS stripe_name_7, t0.plan AS plan_8, t0.is_for_continue AS is_for_continue_9, t0.subject_id AS subject_id_10 FROM discount t0 WHERE t0.url_parameter IS NULL LIMIT 1;