Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.header AS header_4,
  t0.is_follow AS is_follow_5,
  t0.presentation AS presentation_6
FROM
  page_home t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.header AS header_4, t0.is_follow AS is_follow_5, t0.presentation AS presentation_6 FROM page_home t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.desicion_week AS desicion_week_4,
  t0.purchase_receipt AS purchase_receipt_5,
  t0.grey_card AS grey_card_6,
  t0.rib AS rib_7,
  t0.invoice_receipt AS invoice_receipt_8,
  t0.other_doc AS other_doc_9,
  t0.purchased_at AS purchased_at_10,
  t0.status AS status_11,
  t0.status_message AS status_message_12,
  t0.action_at AS action_at_13,
  t0.purchase_code AS purchase_code_14,
  t0.uuid AS uuid_15,
  t0.channel AS channel_16,
  t0.iban AS iban_17,
  t0.total_amount AS total_amount_18,
  t0.reward AS reward_19,
  t0.rewarded AS rewarded_20,
  t0.additional_decline_message AS additional_decline_message_21,
  t0.additional_accept_message AS additional_accept_message_22,
  t0.all_doublon_ticket_amount_shop_purchase_date AS all_doublon_ticket_amount_shop_purchase_date_23,
  t0.doublon_ticket_amount_shop_purchase_date AS doublon_ticket_amount_shop_purchase_date_24,
  t0.total_quantity AS total_quantity_25,
  t0.decision_week AS decision_week_26,
  t0.comment AS comment_27,
  t0.doublon_first_name_last_name AS doublon_first_name_last_name_28,
  t0.all_doublon_first_name_last_name AS all_doublon_first_name_last_name_29,
  t0.doublon_last_name_zip_code AS doublon_last_name_zip_code_30,
  t0.all_doublon_last_name_zip_code AS all_doublon_last_name_zip_code_31,
  t0.doublon_adress_iban AS doublon_adress_iban_32,
  t0.all_doublon_address_iban AS all_doublon_address_iban_33,
  t0.doublon_purchase_date_shop_total_purchase_amount AS doublon_purchase_date_shop_total_purchase_amount_34,
  t0.all_doublon_purchase_date_shop_total_purchase_amount AS all_doublon_purchase_date_shop_total_purchase_amount_35,
  t0.personal_cheque_number AS personal_cheque_number_36,
  t0.refunded_at AS refunded_at_37,
  t0.location AS location_38,
  t0.zipcode AS zipcode_39,
  t0.city AS city_40,
  t0.serial_number AS serial_number_41,
  t0.shop_name AS shop_name_42,
  t0.original_id AS original_id_43,
  t0.doublon_purchase_date_zip_code_shop_total_purchase_amount AS doublon_purchase_date_zip_code_shop_total_purchase_amount_44,
  t0.all_doublon_purchase_date_zip_code_shop_total_purchase_amount AS ll_doublon_purchase_date_zip_code_shop_total_purchase_amount_45,
  t0.invoice_installation AS invoice_installation_46,
  t0.is_sent AS is_sent_47,
  t0.original_base AS original_base_48,
  t0.origin AS origin_49,
  t0.installed_at AS installed_at_50,
  t0.is_private_usage AS is_private_usage_51,
  t0.email_author AS email_author_52,
  t0.author_first_name AS author_first_name_53,
  t0.author_last_name AS author_last_name_54,
  t0.city_value AS city_value_55,
  t0.shop_value AS shop_value_56,
  t0.answer1 AS answer1_57,
  t0.answer2 AS answer2_58,
  t0.answer3 AS answer3_59,
  t0.answer4 AS answer4_60,
  t0.is_decline_final AS is_decline_final_61,
  t0.rib_control AS rib_control_62,
  t0.rib_control_at AS rib_control_at_63,
  t0.grey_card_control AS grey_card_control_64,
  t0.grey_card_control_at AS grey_card_control_at_65,
  t0.yes_no_answer_one AS yes_no_answer_one_66,
  t0.yes_no_answer_two AS yes_no_answer_two_67,
  t0.yes_no_answer_three AS yes_no_answer_three_68,
  t0.yes_no_answer_four AS yes_no_answer_four_69,
  t0.ranking_answer_one AS ranking_answer_one_70,
  t0.ranking_answer_two AS ranking_answer_two_71,
  t0.ranking_answer_three AS ranking_answer_three_72,
  t0.ranking_answer_four AS ranking_answer_four_73,
  t0.multiple_answer_one AS multiple_answer_one_74,
  t0.multiple_answer_two AS multiple_answer_two_75,
  t0.multiple_answer_three AS multiple_answer_three_76,
  t0.multiple_answer_four AS multiple_answer_four_77,
  t0.shop_postal_code AS shop_postal_code_78,
  t0.gift AS gift_79,
  t0.gift_id AS gift_id_80,
  t0.question1 AS question1_81,
  t0.question2 AS question2_82,
  t0.question3 AS question3_83,
  t0.dissatisfaction_reason AS dissatisfaction_reason_84,
  t0.bar_code AS bar_code_85,
  t0.promo_code AS promo_code_86,
  t0.operation_id AS operation_id_87,
  t0.decline_subject_id AS decline_subject_id_88,
  t0.transfer_id AS transfer_id_89,
  t0.check_payment_id AS check_payment_id_90,
  t0.shop_id AS shop_id_91,
  t0.author_id AS author_id_92,
  t0.optin_id AS optin_id_93,
  t0.created_by_id AS created_by_id_94,
  t0.type_status_id AS type_status_id_95,
  t0.godfather_id AS godfather_id_96,
  t0.installer_id AS installer_id_97,
  t0.answer_id AS answer_id_98,
  t0.instant_win_id AS instant_win_id_99
FROM
  purchase t0
WHERE
  t0.purchase_code IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.desicion_week AS desicion_week_4, t0.purchase_receipt AS purchase_receipt_5, t0.grey_card AS grey_card_6, t0.rib AS rib_7, t0.invoice_receipt AS invoice_receipt_8, t0.other_doc AS other_doc_9, t0.purchased_at AS purchased_at_10, t0.status AS status_11, t0.status_message AS status_message_12, t0.action_at AS action_at_13, t0.purchase_code AS purchase_code_14, t0.uuid AS uuid_15, t0.channel AS channel_16, t0.iban AS iban_17, t0.total_amount AS total_amount_18, t0.reward AS reward_19, t0.rewarded AS rewarded_20, t0.additional_decline_message AS additional_decline_message_21, t0.additional_accept_message AS additional_accept_message_22, t0.all_doublon_ticket_amount_shop_purchase_date AS all_doublon_ticket_amount_shop_purchase_date_23, t0.doublon_ticket_amount_shop_purchase_date AS doublon_ticket_amount_shop_purchase_date_24, t0.total_quantity AS total_quantity_25, t0.decision_week AS decision_week_26, t0.comment AS comment_27, t0.doublon_first_name_last_name AS doublon_first_name_last_name_28, t0.all_doublon_first_name_last_name AS all_doublon_first_name_last_name_29, t0.doublon_last_name_zip_code AS doublon_last_name_zip_code_30, t0.all_doublon_last_name_zip_code AS all_doublon_last_name_zip_code_31, t0.doublon_adress_iban AS doublon_adress_iban_32, t0.all_doublon_address_iban AS all_doublon_address_iban_33, t0.doublon_purchase_date_shop_total_purchase_amount AS doublon_purchase_date_shop_total_purchase_amount_34, t0.all_doublon_purchase_date_shop_total_purchase_amount AS all_doublon_purchase_date_shop_total_purchase_amount_35, t0.personal_cheque_number AS personal_cheque_number_36, t0.refunded_at AS refunded_at_37, t0.location AS location_38, t0.zipcode AS zipcode_39, t0.city AS city_40, t0.serial_number AS serial_number_41, t0.shop_name AS shop_name_42, t0.original_id AS original_id_43, t0.doublon_purchase_date_zip_code_shop_total_purchase_amount AS doublon_purchase_date_zip_code_shop_total_purchase_amount_44, t0.all_doublon_purchase_date_zip_code_shop_total_purchase_amount AS ll_doublon_purchase_date_zip_code_shop_total_purchase_amount_45, t0.invoice_installation AS invoice_installation_46, t0.is_sent AS is_sent_47, t0.original_base AS original_base_48, t0.origin AS origin_49, t0.installed_at AS installed_at_50, t0.is_private_usage AS is_private_usage_51, t0.email_author AS email_author_52, t0.author_first_name AS author_first_name_53, t0.author_last_name AS author_last_name_54, t0.city_value AS city_value_55, t0.shop_value AS shop_value_56, t0.answer1 AS answer1_57, t0.answer2 AS answer2_58, t0.answer3 AS answer3_59, t0.answer4 AS answer4_60, t0.is_decline_final AS is_decline_final_61, t0.rib_control AS rib_control_62, t0.rib_control_at AS rib_control_at_63, t0.grey_card_control AS grey_card_control_64, t0.grey_card_control_at AS grey_card_control_at_65, t0.yes_no_answer_one AS yes_no_answer_one_66, t0.yes_no_answer_two AS yes_no_answer_two_67, t0.yes_no_answer_three AS yes_no_answer_three_68, t0.yes_no_answer_four AS yes_no_answer_four_69, t0.ranking_answer_one AS ranking_answer_one_70, t0.ranking_answer_two AS ranking_answer_two_71, t0.ranking_answer_three AS ranking_answer_three_72, t0.ranking_answer_four AS ranking_answer_four_73, t0.multiple_answer_one AS multiple_answer_one_74, t0.multiple_answer_two AS multiple_answer_two_75, t0.multiple_answer_three AS multiple_answer_three_76, t0.multiple_answer_four AS multiple_answer_four_77, t0.shop_postal_code AS shop_postal_code_78, t0.gift AS gift_79, t0.gift_id AS gift_id_80, t0.question1 AS question1_81, t0.question2 AS question2_82, t0.question3 AS question3_83, t0.dissatisfaction_reason AS dissatisfaction_reason_84, t0.bar_code AS bar_code_85, t0.promo_code AS promo_code_86, t0.operation_id AS operation_id_87, t0.decline_subject_id AS decline_subject_id_88, t0.transfer_id AS transfer_id_89, t0.check_payment_id AS check_payment_id_90, t0.shop_id AS shop_id_91, t0.author_id AS author_id_92, t0.optin_id AS optin_id_93, t0.created_by_id AS created_by_id_94, t0.type_status_id AS type_status_id_95, t0.godfather_id AS godfather_id_96, t0.installer_id AS installer_id_97, t0.answer_id AS answer_id_98, t0.instant_win_id AS instant_win_id_99 FROM purchase t0 WHERE t0.purchase_code IS NULL LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.created_at AS created_at_2,
  o0_.updated_at AS updated_at_3,
  o0_.start_at AS start_at_4,
  o0_.end_at AS end_at_5,
  o0_.code AS code_6,
  o0_.open_until AS open_until_7,
  o0_.max_participations AS max_participations_8,
  o0_.contest_description AS contest_description_9,
  o0_.contest_rules_link AS contest_rules_link_10,
  o0_.contest_rules_description AS contest_rules_description_11,
  o0_.privacy_text AS privacy_text_12,
  o0_.presentation AS presentation_13,
  o0_.cgu AS cgu_14,
  o0_.rgpd AS rgpd_15,
  o0_.informations AS informations_16,
  o0_.logo_email AS logo_email_17,
  o0_.is_stop AS is_stop_18,
  o0_.is_active AS is_active_19,
  o0_.big_banner AS big_banner_20,
  o0_.small_banner AS small_banner_21,
  o0_.brand AS brand_22,
  o0_.modality AS modality_23,
  o0_.products_file AS products_file_24,
  o0_.closing_sales AS closing_sales_25,
  o0_.shops_file AS shops_file_26,
  o0_.url AS url_27,
  o0_.is_zip_code AS is_zip_code_28,
  o0_.is_city AS is_city_29,
  o0_.is_list_shop AS is_list_shop_30,
  o0_.number_op AS number_op_31,
  o0_.product_mutliple AS product_mutliple_32,
  o0_.serial_number AS serial_number_33,
  o0_.qr_code AS qr_code_34,
  o0_.is_total_ttc AS is_total_ttc_35,
  o0_.text_serial_number AS text_serial_number_36,
  o0_.legal_notice AS legal_notice_37,
  o0_.purchase_multiple AS purchase_multiple_38,
  o0_.is_cummulable AS is_cummulable_39,
  o0_.is_gift AS is_gift_40,
  o0_.is_odr AS is_odr_41,
  o0_.background AS background_42,
  o0_.is_one_participation_personne AS is_one_participation_personne_43,
  o0_.is_one_participation_product AS is_one_participation_product_44,
  o0_.slug AS slug_45,
  o0_.address_operation AS address_operation_46,
  o0_.original_id AS original_id_47,
  o0_.logo AS logo_48,
  o0_.original_slug AS original_slug_49,
  o0_.hide AS hide_50,
  o0_.sales_points_excel AS sales_points_excel_51,
  o0_.sales_points_pdf AS sales_points_pdf_52,
  o0_.background_color AS background_color_53,
  o0_.is_one_participation AS is_one_participation_54,
  o0_.is_instant_win AS is_instant_win_55,
  o0_.position AS position_56,
  o0_.user_form_id AS user_form_id_57,
  o0_.product_form_id AS product_form_id_58,
  o0_.document_form_id AS document_form_id_59,
  o0_.refund_form_id AS refund_form_id_60,
  o0_.optin_form_id AS optin_form_id_61,
  o0_.question_form_id AS question_form_id_62,
  o0_.purchase_form_id AS purchase_form_id_63,
  o0_.type_channel_id AS type_channel_id_64,
  o0_.type_process_id AS type_process_id_65
FROM
  operation o0_
WHERE
  o0_.start_at <= ?
  AND o0_.open_until >= ?
ORDER BY
  o0_.brand ASC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.created_at AS created_at_2, o0_.updated_at AS updated_at_3, o0_.start_at AS start_at_4, o0_.end_at AS end_at_5, o0_.code AS code_6, o0_.open_until AS open_until_7, o0_.max_participations AS max_participations_8, o0_.contest_description AS contest_description_9, o0_.contest_rules_link AS contest_rules_link_10, o0_.contest_rules_description AS contest_rules_description_11, o0_.privacy_text AS privacy_text_12, o0_.presentation AS presentation_13, o0_.cgu AS cgu_14, o0_.rgpd AS rgpd_15, o0_.informations AS informations_16, o0_.logo_email AS logo_email_17, o0_.is_stop AS is_stop_18, o0_.is_active AS is_active_19, o0_.big_banner AS big_banner_20, o0_.small_banner AS small_banner_21, o0_.brand AS brand_22, o0_.modality AS modality_23, o0_.products_file AS products_file_24, o0_.closing_sales AS closing_sales_25, o0_.shops_file AS shops_file_26, o0_.url AS url_27, o0_.is_zip_code AS is_zip_code_28, o0_.is_city AS is_city_29, o0_.is_list_shop AS is_list_shop_30, o0_.number_op AS number_op_31, o0_.product_mutliple AS product_mutliple_32, o0_.serial_number AS serial_number_33, o0_.qr_code AS qr_code_34, o0_.is_total_ttc AS is_total_ttc_35, o0_.text_serial_number AS text_serial_number_36, o0_.legal_notice AS legal_notice_37, o0_.purchase_multiple AS purchase_multiple_38, o0_.is_cummulable AS is_cummulable_39, o0_.is_gift AS is_gift_40, o0_.is_odr AS is_odr_41, o0_.background AS background_42, o0_.is_one_participation_personne AS is_one_participation_personne_43, o0_.is_one_participation_product AS is_one_participation_product_44, o0_.slug AS slug_45, o0_.address_operation AS address_operation_46, o0_.original_id AS original_id_47, o0_.logo AS logo_48, o0_.original_slug AS original_slug_49, o0_.hide AS hide_50, o0_.sales_points_excel AS sales_points_excel_51, o0_.sales_points_pdf AS sales_points_pdf_52, o0_.background_color AS background_color_53, o0_.is_one_participation AS is_one_participation_54, o0_.is_instant_win AS is_instant_win_55, o0_.position AS position_56, o0_.user_form_id AS user_form_id_57, o0_.product_form_id AS product_form_id_58, o0_.document_form_id AS document_form_id_59, o0_.refund_form_id AS refund_form_id_60, o0_.optin_form_id AS optin_form_id_61, o0_.question_form_id AS question_form_id_62, o0_.purchase_form_id AS purchase_form_id_63, o0_.type_channel_id AS type_channel_id_64, o0_.type_process_id AS type_process_id_65 FROM operation o0_ WHERE o0_.start_at <= '2025-10-07 08:25:45' AND o0_.open_until >= '2025-10-07 08:25:45' ORDER BY o0_.brand ASC;

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_url AS short_url_3,
  t0.qr_code AS qr_code_4,
  t0.number_scann AS number_scann_5,
  t0.id_api AS id_api_6,
  t0.url_qr_created_at AS url_qr_created_at_7,
  t0.operation_id AS operation_id_8
FROM
  stats t0
WHERE
  t0.operation_id = ?

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_url AS short_url_3, t0.qr_code AS qr_code_4, t0.number_scann AS number_scann_5, t0.id_api AS id_api_6, t0.url_qr_created_at AS url_qr_created_at_7, t0.operation_id AS operation_id_8 FROM stats t0 WHERE t0.operation_id = 41;

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_url AS short_url_3,
  t0.qr_code AS qr_code_4,
  t0.number_scann AS number_scann_5,
  t0.id_api AS id_api_6,
  t0.url_qr_created_at AS url_qr_created_at_7,
  t0.operation_id AS operation_id_8
FROM
  stats t0
WHERE
  t0.operation_id = ?

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_url AS short_url_3, t0.qr_code AS qr_code_4, t0.number_scann AS number_scann_5, t0.id_api AS id_api_6, t0.url_qr_created_at AS url_qr_created_at_7, t0.operation_id AS operation_id_8 FROM stats t0 WHERE t0.operation_id = 58;

SELECT
  t0.id AS id_1,
  t0.original_id AS original_id_2,
  t0.short_url AS short_url_3,
  t0.qr_code AS qr_code_4,
  t0.number_scann AS number_scann_5,
  t0.id_api AS id_api_6,
  t0.url_qr_created_at AS url_qr_created_at_7,
  t0.operation_id AS operation_id_8
FROM
  stats t0
WHERE
  t0.operation_id = ?

SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_url AS short_url_3, t0.qr_code AS qr_code_4, t0.number_scann AS number_scann_5, t0.id_api AS id_api_6, t0.url_qr_created_at AS url_qr_created_at_7, t0.operation_id AS operation_id_8 FROM stats t0 WHERE t0.operation_id = 56;