Symfony Profiler

SELECT
  t0.id AS id_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.price AS price_7,
  t0.oldprice AS oldprice_8,
  t0.description AS description_9,
  t0.text_paid AS text_paid_10,
  t0.charge AS charge_11,
  t0.profexpress AS profexpress_12,
  t0.full_description AS full_description_13,
  t0.accroche AS accroche_14,
  t0.filename AS filename_15,
  t0.stripe_id AS stripe_id_16,
  t0.online AS online_17,
  t0.is_delete AS is_delete_18,
  t0.position AS position_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.type_offer_id AS type_offer_id_22,
  t0.discr,
  t1.started AS started_23,
  t1.ended AS ended_24,
  t1.numberlimit AS numberlimit_25,
  t1.user AS user_26,
  t1.ready AS ready_27,
  t1.multizone AS multizone_28,
  t1.seasons AS seasons_29,
  t1.url_video AS url_video_30,
  t1.is_pack AS is_pack_31,
  t1.text_headband AS text_headband_32,
  t1.url_headband AS url_headband_33,
  t1.date_headband AS date_headband_34,
  t1.discipline_choice AS discipline_choice_35,
  t1.email_content_parent AS email_content_parent_36,
  t1.email_content_student AS email_content_student_37,
  t1.type AS type_38,
  t1.number_day AS number_day_39,
  t1.subscription_started AS subscription_started_40,
  t1.subscription_ended AS subscription_ended_41,
  t2.old_price AS old_price_42,
  t2.percent_discount AS percent_discount_43,
  t2.monthValid AS monthValid_44,
  t2.role AS role_45,
  t2.tutorat AS tutorat_46,
  t2.discount_date AS discount_date_47,
  t2.discount_id AS discount_id_48,
  t3.old_price AS old_price_49,
  t3.nbr_dis AS nbr_dis_50
FROM
  new_offer t0
  LEFT JOIN admin_trainning t1 ON t0.id = t1.id
  LEFT JOIN admin_formule t2 ON t0.id = t2.id
  LEFT JOIN admin_mission t3 ON t0.id = t3.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_4, t0.title AS title_5, t0.slug AS slug_6, t0.price AS price_7, t0.oldprice AS oldprice_8, t0.description AS description_9, t0.text_paid AS text_paid_10, t0.charge AS charge_11, t0.profexpress AS profexpress_12, t0.full_description AS full_description_13, t0.accroche AS accroche_14, t0.filename AS filename_15, t0.stripe_id AS stripe_id_16, t0.online AS online_17, t0.is_delete AS is_delete_18, t0.position AS position_19, t0.created AS created_20, t0.updated AS updated_21, t0.type_offer_id AS type_offer_id_22, t0.discr, t1.started AS started_23, t1.ended AS ended_24, t1.numberlimit AS numberlimit_25, t1.user AS user_26, t1.ready AS ready_27, t1.multizone AS multizone_28, t1.seasons AS seasons_29, t1.url_video AS url_video_30, t1.is_pack AS is_pack_31, t1.text_headband AS text_headband_32, t1.url_headband AS url_headband_33, t1.date_headband AS date_headband_34, t1.discipline_choice AS discipline_choice_35, t1.email_content_parent AS email_content_parent_36, t1.email_content_student AS email_content_student_37, t1.type AS type_38, t1.number_day AS number_day_39, t1.subscription_started AS subscription_started_40, t1.subscription_ended AS subscription_ended_41, t2.old_price AS old_price_42, t2.percent_discount AS percent_discount_43, t2.monthValid AS monthValid_44, t2.role AS role_45, t2.tutorat AS tutorat_46, t2.discount_date AS discount_date_47, t2.discount_id AS discount_id_48, t3.old_price AS old_price_49, t3.nbr_dis AS nbr_dis_50 FROM new_offer t0 LEFT JOIN admin_trainning t1 ON t0.id = t1.id LEFT JOIN admin_formule t2 ON t0.id = t2.id LEFT JOIN admin_mission t3 ON t0.id = t3.id WHERE t0.slug = 'abonnement-assistance-22' LIMIT 1;

SELECT
  t0.id AS id_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.price AS price_7,
  t0.oldprice AS oldprice_8,
  t0.description AS description_9,
  t0.text_paid AS text_paid_10,
  t0.charge AS charge_11,
  t0.profexpress AS profexpress_12,
  t0.full_description AS full_description_13,
  t0.accroche AS accroche_14,
  t0.filename AS filename_15,
  t0.stripe_id AS stripe_id_16,
  t0.online AS online_17,
  t0.is_delete AS is_delete_18,
  t0.position AS position_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.type_offer_id AS type_offer_id_22,
  t0.discr,
  t1.started AS started_23,
  t1.ended AS ended_24,
  t1.numberlimit AS numberlimit_25,
  t1.user AS user_26,
  t1.ready AS ready_27,
  t1.multizone AS multizone_28,
  t1.seasons AS seasons_29,
  t1.url_video AS url_video_30,
  t1.is_pack AS is_pack_31,
  t1.text_headband AS text_headband_32,
  t1.url_headband AS url_headband_33,
  t1.date_headband AS date_headband_34,
  t1.discipline_choice AS discipline_choice_35,
  t1.email_content_parent AS email_content_parent_36,
  t1.email_content_student AS email_content_student_37,
  t1.type AS type_38,
  t1.number_day AS number_day_39,
  t1.subscription_started AS subscription_started_40,
  t1.subscription_ended AS subscription_ended_41,
  t2.old_price AS old_price_42,
  t2.percent_discount AS percent_discount_43,
  t2.monthValid AS monthValid_44,
  t2.role AS role_45,
  t2.tutorat AS tutorat_46,
  t2.discount_date AS discount_date_47,
  t2.discount_id AS discount_id_48,
  t3.old_price AS old_price_49,
  t3.nbr_dis AS nbr_dis_50
FROM
  new_offer t0
  LEFT JOIN admin_trainning t1 ON t0.id = t1.id
  LEFT JOIN admin_formule t2 ON t0.id = t2.id
  LEFT JOIN admin_mission t3 ON t0.id = t3.id
WHERE
  t0.type_offer_id = ?
  AND t0.online = ?
ORDER BY
  t0.price ASC
LIMIT
  1

SELECT t0.id AS id_4, t0.title AS title_5, t0.slug AS slug_6, t0.price AS price_7, t0.oldprice AS oldprice_8, t0.description AS description_9, t0.text_paid AS text_paid_10, t0.charge AS charge_11, t0.profexpress AS profexpress_12, t0.full_description AS full_description_13, t0.accroche AS accroche_14, t0.filename AS filename_15, t0.stripe_id AS stripe_id_16, t0.online AS online_17, t0.is_delete AS is_delete_18, t0.position AS position_19, t0.created AS created_20, t0.updated AS updated_21, t0.type_offer_id AS type_offer_id_22, t0.discr, t1.started AS started_23, t1.ended AS ended_24, t1.numberlimit AS numberlimit_25, t1.user AS user_26, t1.ready AS ready_27, t1.multizone AS multizone_28, t1.seasons AS seasons_29, t1.url_video AS url_video_30, t1.is_pack AS is_pack_31, t1.text_headband AS text_headband_32, t1.url_headband AS url_headband_33, t1.date_headband AS date_headband_34, t1.discipline_choice AS discipline_choice_35, t1.email_content_parent AS email_content_parent_36, t1.email_content_student AS email_content_student_37, t1.type AS type_38, t1.number_day AS number_day_39, t1.subscription_started AS subscription_started_40, t1.subscription_ended AS subscription_ended_41, t2.old_price AS old_price_42, t2.percent_discount AS percent_discount_43, t2.monthValid AS monthValid_44, t2.role AS role_45, t2.tutorat AS tutorat_46, t2.discount_date AS discount_date_47, t2.discount_id AS discount_id_48, t3.old_price AS old_price_49, t3.nbr_dis AS nbr_dis_50 FROM new_offer t0 LEFT JOIN admin_trainning t1 ON t0.id = t1.id LEFT JOIN admin_formule t2 ON t0.id = t2.id LEFT JOIN admin_mission t3 ON t0.id = t3.id WHERE t0.type_offer_id = 1 AND t0.online = 1 ORDER BY t0.price ASC LIMIT 1;

SELECT
  t0.id AS id_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.price AS price_7,
  t0.oldprice AS oldprice_8,
  t0.description AS description_9,
  t0.text_paid AS text_paid_10,
  t0.charge AS charge_11,
  t0.profexpress AS profexpress_12,
  t0.full_description AS full_description_13,
  t0.accroche AS accroche_14,
  t0.filename AS filename_15,
  t0.stripe_id AS stripe_id_16,
  t0.online AS online_17,
  t0.is_delete AS is_delete_18,
  t0.position AS position_19,
  t0.created AS created_20,
  t0.updated AS updated_21,
  t0.type_offer_id AS type_offer_id_22,
  t0.discr,
  t1.started AS started_23,
  t1.ended AS ended_24,
  t1.numberlimit AS numberlimit_25,
  t1.user AS user_26,
  t1.ready AS ready_27,
  t1.multizone AS multizone_28,
  t1.seasons AS seasons_29,
  t1.url_video AS url_video_30,
  t1.is_pack AS is_pack_31,
  t1.text_headband AS text_headband_32,
  t1.url_headband AS url_headband_33,
  t1.date_headband AS date_headband_34,
  t1.discipline_choice AS discipline_choice_35,
  t1.email_content_parent AS email_content_parent_36,
  t1.email_content_student AS email_content_student_37,
  t1.type AS type_38,
  t1.number_day AS number_day_39,
  t1.subscription_started AS subscription_started_40,
  t1.subscription_ended AS subscription_ended_41,
  t2.old_price AS old_price_42,
  t2.percent_discount AS percent_discount_43,
  t2.monthValid AS monthValid_44,
  t2.role AS role_45,
  t2.tutorat AS tutorat_46,
  t2.discount_date AS discount_date_47,
  t2.discount_id AS discount_id_48,
  t3.old_price AS old_price_49,
  t3.nbr_dis AS nbr_dis_50
FROM
  new_offer t0
  LEFT JOIN admin_trainning t1 ON t0.id = t1.id
  LEFT JOIN admin_formule t2 ON t0.id = t2.id
  LEFT JOIN admin_mission t3 ON t0.id = t3.id
WHERE
  t0.online = ?
  AND t0.type_offer_id = ?
ORDER BY
  t0.position DESC

SELECT t0.id AS id_4, t0.title AS title_5, t0.slug AS slug_6, t0.price AS price_7, t0.oldprice AS oldprice_8, t0.description AS description_9, t0.text_paid AS text_paid_10, t0.charge AS charge_11, t0.profexpress AS profexpress_12, t0.full_description AS full_description_13, t0.accroche AS accroche_14, t0.filename AS filename_15, t0.stripe_id AS stripe_id_16, t0.online AS online_17, t0.is_delete AS is_delete_18, t0.position AS position_19, t0.created AS created_20, t0.updated AS updated_21, t0.type_offer_id AS type_offer_id_22, t0.discr, t1.started AS started_23, t1.ended AS ended_24, t1.numberlimit AS numberlimit_25, t1.user AS user_26, t1.ready AS ready_27, t1.multizone AS multizone_28, t1.seasons AS seasons_29, t1.url_video AS url_video_30, t1.is_pack AS is_pack_31, t1.text_headband AS text_headband_32, t1.url_headband AS url_headband_33, t1.date_headband AS date_headband_34, t1.discipline_choice AS discipline_choice_35, t1.email_content_parent AS email_content_parent_36, t1.email_content_student AS email_content_student_37, t1.type AS type_38, t1.number_day AS number_day_39, t1.subscription_started AS subscription_started_40, t1.subscription_ended AS subscription_ended_41, t2.old_price AS old_price_42, t2.percent_discount AS percent_discount_43, t2.monthValid AS monthValid_44, t2.role AS role_45, t2.tutorat AS tutorat_46, t2.discount_date AS discount_date_47, t2.discount_id AS discount_id_48, t3.old_price AS old_price_49, t3.nbr_dis AS nbr_dis_50 FROM new_offer t0 LEFT JOIN admin_trainning t1 ON t0.id = t1.id LEFT JOIN admin_formule t2 ON t0.id = t2.id LEFT JOIN admin_mission t3 ON t0.id = t3.id WHERE t0.online = 1 AND t0.type_offer_id = 1 ORDER BY t0.position DESC;

SELECT
  t0.id AS id_1,
  t0.online AS online_2,
  t0.title AS title_3,
  t0.text_paid AS text_paid_4,
  t0.grab AS grab_5,
  t0.description AS description_6,
  t0.slug AS slug_7,
  t0.display_pack AS display_pack_8
FROM
  type_offer t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.online AS online_2, t0.title AS title_3, t0.text_paid AS text_paid_4, t0.grab AS grab_5, t0.description AS description_6, t0.slug AS slug_7, t0.display_pack AS display_pack_8 FROM type_offer t0 WHERE t0.slug = 'autonomie' LIMIT 1;