1
0.41 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . logo AS logo_4 , t0 . societe AS societe_5 , t0 . main_color AS main_color_6 , t0 . secondary_color AS secondary_color_7 , t0 . email_sender AS email_sender_8 , t0 . email_copy AS email_copy_9 , t0 . name_sender AS name_sender_10 , t0 . email_signature AS email_signature_11 FROM configuration 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 . logo AS logo_4 , t0 . societe AS societe_5 , t0 . main_color AS main_color_6 , t0 . secondary_color AS secondary_color_7 , t0 . email_sender AS email_sender_8 , t0 . email_copy AS email_copy_9 , t0 . name_sender AS name_sender_10 , t0 . email_signature AS email_signature_11 FROM configuration t0 WHERE t0 . id = 1 ;
Copy
2
0.28 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . start_at AS start_at_5 , t0 . end_at AS end_at_6 , t0 . code AS code_7 , t0 . open_until AS open_until_8 , t0 . max_participations AS max_participations_9 , t0 . contest_description AS contest_description_10 , t0 . contest_rules_link AS contest_rules_link_11 , t0 . contest_rules_description AS contest_rules_description_12 , t0 . privacy_text AS privacy_text_13 , t0 . presentation AS presentation_14 , t0 . cgu AS cgu_15 , t0 . rgpd AS rgpd_16 , t0 . informations AS informations_17 , t0 . logo_email AS logo_email_18 , t0 . is_stop AS is_stop_19 , t0 . is_active AS is_active_20 , t0 . big_banner AS big_banner_21 , t0 . small_banner AS small_banner_22 , t0 . brand AS brand_23 , t0 . modality AS modality_24 , t0 . products_file AS products_file_25 , t0 . closing_sales AS closing_sales_26 , t0 . shops_file AS shops_file_27 , t0 . url AS url_28 , t0 . is_zip_code AS is_zip_code_29 , t0 . is_city AS is_city_30 , t0 . is_list_shop AS is_list_shop_31 , t0 . number_op AS number_op_32 , t0 . product_mutliple AS product_mutliple_33 , t0 . serial_number AS serial_number_34 , t0 . qr_code AS qr_code_35 , t0 . is_total_ttc AS is_total_ttc_36 , t0 . text_serial_number AS text_serial_number_37 , t0 . legal_notice AS legal_notice_38 , t0 . purchase_multiple AS purchase_multiple_39 , t0 . is_cummulable AS is_cummulable_40 , t0 . is_gift AS is_gift_41 , t0 . is_odr AS is_odr_42 , t0 . background AS background_43 , t0 . is_one_participation_personne AS is_one_participation_personne_44 , t0 . is_one_participation_product AS is_one_participation_product_45 , t0 . slug AS slug_46 , t0 . address_operation AS address_operation_47 , t0 . original_id AS original_id_48 , t0 . logo AS logo_49 , t0 . original_slug AS original_slug_50 , t0 . hide AS hide_51 , t0 . sales_points_excel AS sales_points_excel_52 , t0 . sales_points_pdf AS sales_points_pdf_53 , t0 . background_color AS background_color_54 , t0 . is_one_participation AS is_one_participation_55 , t0 . is_instant_win AS is_instant_win_56 , t0 . position AS position_57 , t0 . user_form_id AS user_form_id_58 , t0 . product_form_id AS product_form_id_59 , t0 . document_form_id AS document_form_id_60 , t0 . refund_form_id AS refund_form_id_61 , t0 . optin_form_id AS optin_form_id_62 , t0 . question_form_id AS question_form_id_63 , t0 . purchase_form_id AS purchase_form_id_64 , t0 . type_channel_id AS type_channel_id_65 , t66 . id AS id_67 , t66 . original_id AS original_id_68 , t66 . short_url AS short_url_69 , t66 . qr_code AS qr_code_70 , t66 . number_scann AS number_scann_71 , t66 . id_api AS id_api_72 , t66 . url_qr_created_at AS url_qr_created_at_73 , t66 . operation_id AS operation_id_74 , t0 . type_process_id AS type_process_id_75 FROM operation t0 LEFT JOIN stats t66 ON t66 . operation_id = t0 . id WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"RIP25-17 "
]
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . created_at AS created_at_3 ,
t0 . updated_at AS updated_at_4 ,
t0 . start_at AS start_at_5 ,
t0 . end_at AS end_at_6 ,
t0 . code AS code_7 ,
t0 . open_until AS open_until_8 ,
t0 . max_participations AS max_participations_9 ,
t0 . contest_description AS contest_description_10 ,
t0 . contest_rules_link AS contest_rules_link_11 ,
t0 . contest_rules_description AS contest_rules_description_12 ,
t0 . privacy_text AS privacy_text_13 ,
t0 . presentation AS presentation_14 ,
t0 . cgu AS cgu_15 ,
t0 . rgpd AS rgpd_16 ,
t0 . informations AS informations_17 ,
t0 . logo_email AS logo_email_18 ,
t0 . is_stop AS is_stop_19 ,
t0 . is_active AS is_active_20 ,
t0 . big_banner AS big_banner_21 ,
t0 . small_banner AS small_banner_22 ,
t0 . brand AS brand_23 ,
t0 . modality AS modality_24 ,
t0 . products_file AS products_file_25 ,
t0 . closing_sales AS closing_sales_26 ,
t0 . shops_file AS shops_file_27 ,
t0 . url AS url_28 ,
t0 . is_zip_code AS is_zip_code_29 ,
t0 . is_city AS is_city_30 ,
t0 . is_list_shop AS is_list_shop_31 ,
t0 . number_op AS number_op_32 ,
t0 . product_mutliple AS product_mutliple_33 ,
t0 . serial_number AS serial_number_34 ,
t0 . qr_code AS qr_code_35 ,
t0 . is_total_ttc AS is_total_ttc_36 ,
t0 . text_serial_number AS text_serial_number_37 ,
t0 . legal_notice AS legal_notice_38 ,
t0 . purchase_multiple AS purchase_multiple_39 ,
t0 . is_cummulable AS is_cummulable_40 ,
t0 . is_gift AS is_gift_41 ,
t0 . is_odr AS is_odr_42 ,
t0 . background AS background_43 ,
t0 . is_one_participation_personne AS is_one_participation_personne_44 ,
t0 . is_one_participation_product AS is_one_participation_product_45 ,
t0 . slug AS slug_46 ,
t0 . address_operation AS address_operation_47 ,
t0 . original_id AS original_id_48 ,
t0 . logo AS logo_49 ,
t0 . original_slug AS original_slug_50 ,
t0 . hide AS hide_51 ,
t0 . sales_points_excel AS sales_points_excel_52 ,
t0 . sales_points_pdf AS sales_points_pdf_53 ,
t0 . background_color AS background_color_54 ,
t0 . is_one_participation AS is_one_participation_55 ,
t0 . is_instant_win AS is_instant_win_56 ,
t0 . position AS position_57 ,
t0 . user_form_id AS user_form_id_58 ,
t0 . product_form_id AS product_form_id_59 ,
t0 . document_form_id AS document_form_id_60 ,
t0 . refund_form_id AS refund_form_id_61 ,
t0 . optin_form_id AS optin_form_id_62 ,
t0 . question_form_id AS question_form_id_63 ,
t0 . purchase_form_id AS purchase_form_id_64 ,
t0 . type_channel_id AS type_channel_id_65 ,
t66 . id AS id_67 ,
t66 . original_id AS original_id_68 ,
t66 . short_url AS short_url_69 ,
t66 . qr_code AS qr_code_70 ,
t66 . number_scann AS number_scann_71 ,
t66 . id_api AS id_api_72 ,
t66 . url_qr_created_at AS url_qr_created_at_73 ,
t66 . operation_id AS operation_id_74 ,
t0 . type_process_id AS type_process_id_75
FROM
operation t0
LEFT JOIN stats t66 ON t66 . operation_id = t0 . id
WHERE
t0 . slug = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . start_at AS start_at_5 , t0 . end_at AS end_at_6 , t0 . code AS code_7 , t0 . open_until AS open_until_8 , t0 . max_participations AS max_participations_9 , t0 . contest_description AS contest_description_10 , t0 . contest_rules_link AS contest_rules_link_11 , t0 . contest_rules_description AS contest_rules_description_12 , t0 . privacy_text AS privacy_text_13 , t0 . presentation AS presentation_14 , t0 . cgu AS cgu_15 , t0 . rgpd AS rgpd_16 , t0 . informations AS informations_17 , t0 . logo_email AS logo_email_18 , t0 . is_stop AS is_stop_19 , t0 . is_active AS is_active_20 , t0 . big_banner AS big_banner_21 , t0 . small_banner AS small_banner_22 , t0 . brand AS brand_23 , t0 . modality AS modality_24 , t0 . products_file AS products_file_25 , t0 . closing_sales AS closing_sales_26 , t0 . shops_file AS shops_file_27 , t0 . url AS url_28 , t0 . is_zip_code AS is_zip_code_29 , t0 . is_city AS is_city_30 , t0 . is_list_shop AS is_list_shop_31 , t0 . number_op AS number_op_32 , t0 . product_mutliple AS product_mutliple_33 , t0 . serial_number AS serial_number_34 , t0 . qr_code AS qr_code_35 , t0 . is_total_ttc AS is_total_ttc_36 , t0 . text_serial_number AS text_serial_number_37 , t0 . legal_notice AS legal_notice_38 , t0 . purchase_multiple AS purchase_multiple_39 , t0 . is_cummulable AS is_cummulable_40 , t0 . is_gift AS is_gift_41 , t0 . is_odr AS is_odr_42 , t0 . background AS background_43 , t0 . is_one_participation_personne AS is_one_participation_personne_44 , t0 . is_one_participation_product AS is_one_participation_product_45 , t0 . slug AS slug_46 , t0 . address_operation AS address_operation_47 , t0 . original_id AS original_id_48 , t0 . logo AS logo_49 , t0 . original_slug AS original_slug_50 , t0 . hide AS hide_51 , t0 . sales_points_excel AS sales_points_excel_52 , t0 . sales_points_pdf AS sales_points_pdf_53 , t0 . background_color AS background_color_54 , t0 . is_one_participation AS is_one_participation_55 , t0 . is_instant_win AS is_instant_win_56 , t0 . position AS position_57 , t0 . user_form_id AS user_form_id_58 , t0 . product_form_id AS product_form_id_59 , t0 . document_form_id AS document_form_id_60 , t0 . refund_form_id AS refund_form_id_61 , t0 . optin_form_id AS optin_form_id_62 , t0 . question_form_id AS question_form_id_63 , t0 . purchase_form_id AS purchase_form_id_64 , t0 . type_channel_id AS type_channel_id_65 , t66 . id AS id_67 , t66 . original_id AS original_id_68 , t66 . short_url AS short_url_69 , t66 . qr_code AS qr_code_70 , t66 . number_scann AS number_scann_71 , t66 . id_api AS id_api_72 , t66 . url_qr_created_at AS url_qr_created_at_73 , t66 . operation_id AS operation_id_74 , t0 . type_process_id AS type_process_id_75 FROM operation t0 LEFT JOIN stats t66 ON t66 . operation_id = t0 . id WHERE t0 . slug = 'RIP25-17' LIMIT 1 ;
Copy
3
20.52 ms
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 . uuid 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 . uuid IS NULL
LIMIT
1
Copy
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 . uuid IS NULL LIMIT 1 ;
Copy
4
19.98 ms
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
Copy
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 ;
Copy
5
0.12 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . is_follow AS is_follow_4 , t0 . presentation AS presentation_5 FROM page_end t0 ORDER BY t0 . id ASC LIMIT 1
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . is_follow AS is_follow_4 , t0 . presentation AS presentation_5 FROM page_end t0 ORDER BY t0 . id ASC LIMIT 1 ;
Copy
6
0.13 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . name AS name_3 , t0 . label AS label_4 , t0 . operation_id AS operation_id_5 FROM participation t0 WHERE t0 . operation_id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . name AS name_3 , t0 . label AS label_4 , t0 . operation_id AS operation_id_5 FROM participation t0 WHERE t0 . operation_id = 58 ;
Copy
7
0.24 ms
SELECT p0_ . id AS id_0 , p0_ . created_at AS created_at_1 , p0_ . updated_at AS updated_at_2 , p0_ . desicion_week AS desicion_week_3 , p0_ . purchase_receipt AS purchase_receipt_4 , p0_ . grey_card AS grey_card_5 , p0_ . rib AS rib_6 , p0_ . invoice_receipt AS invoice_receipt_7 , p0_ . other_doc AS other_doc_8 , p0_ . purchased_at AS purchased_at_9 , p0_ . status AS status_10 , p0_ . status_message AS status_message_11 , p0_ . action_at AS action_at_12 , p0_ . purchase_code AS purchase_code_13 , p0_ . uuid AS uuid_14 , p0_ . channel AS channel_15 , p0_ . iban AS iban_16 , p0_ . total_amount AS total_amount_17 , p0_ . reward AS reward_18 , p0_ . rewarded AS rewarded_19 , p0_ . additional_decline_message AS additional_decline_message_20 , p0_ . additional_accept_message AS additional_accept_message_21 , p0_ . all_doublon_ticket_amount_shop_purchase_date AS all_doublon_ticket_amount_shop_purchase_date_22 , p0_ . doublon_ticket_amount_shop_purchase_date AS doublon_ticket_amount_shop_purchase_date_23 , p0_ . total_quantity AS total_quantity_24 , p0_ . decision_week AS decision_week_25 , p0_ . comment AS comment_26 , p0_ . doublon_first_name_last_name AS doublon_first_name_last_name_27 , p0_ . all_doublon_first_name_last_name AS all_doublon_first_name_last_name_28 , p0_ . doublon_last_name_zip_code AS doublon_last_name_zip_code_29 , p0_ . all_doublon_last_name_zip_code AS all_doublon_last_name_zip_code_30 , p0_ . doublon_adress_iban AS doublon_adress_iban_31 , p0_ . all_doublon_address_iban AS all_doublon_address_iban_32 , p0_ . doublon_purchase_date_shop_total_purchase_amount AS doublon_purchase_date_shop_total_purchase_amount_33 , p0_ . all_doublon_purchase_date_shop_total_purchase_amount AS all_doublon_purchase_date_shop_total_purchase_amount_34 , p0_ . personal_cheque_number AS personal_cheque_number_35 , p0_ . refunded_at AS refunded_at_36 , p0_ . location AS location_37 , p0_ . zipcode AS zipcode_38 , p0_ . city AS city_39 , p0_ . serial_number AS serial_number_40 , p0_ . shop_name AS shop_name_41 , p0_ . original_id AS original_id_42 , p0_ . doublon_purchase_date_zip_code_shop_total_purchase_amount AS doublon_purchase_date_zip_code_shop_total_purchase_amount_43 , p0_ . all_doublon_purchase_date_zip_code_shop_total_purchase_amount AS ll_doublon_purchase_date_zip_code_shop_total_purchase_amount_44 , p0_ . invoice_installation AS invoice_installation_45 , p0_ . is_sent AS is_sent_46 , p0_ . original_base AS original_base_47 , p0_ . origin AS origin_48 , p0_ . installed_at AS installed_at_49 , p0_ . is_private_usage AS is_private_usage_50 , p0_ . email_author AS email_author_51 , p0_ . author_first_name AS author_first_name_52 , p0_ . author_last_name AS author_last_name_53 , p0_ . city_value AS city_value_54 , p0_ . shop_value AS shop_value_55 , p0_ . answer1 AS answer1_56 , p0_ . answer2 AS answer2_57 , p0_ . answer3 AS answer3_58 , p0_ . answer4 AS answer4_59 , p0_ . is_decline_final AS is_decline_final_60 , p0_ . rib_control AS rib_control_61 , p0_ . rib_control_at AS rib_control_at_62 , p0_ . grey_card_control AS grey_card_control_63 , p0_ . grey_card_control_at AS grey_card_control_at_64 , p0_ . yes_no_answer_one AS yes_no_answer_one_65 , p0_ . yes_no_answer_two AS yes_no_answer_two_66 , p0_ . yes_no_answer_three AS yes_no_answer_three_67 , p0_ . yes_no_answer_four AS yes_no_answer_four_68 , p0_ . ranking_answer_one AS ranking_answer_one_69 , p0_ . ranking_answer_two AS ranking_answer_two_70 , p0_ . ranking_answer_three AS ranking_answer_three_71 , p0_ . ranking_answer_four AS ranking_answer_four_72 , p0_ . multiple_answer_one AS multiple_answer_one_73 , p0_ . multiple_answer_two AS multiple_answer_two_74 , p0_ . multiple_answer_three AS multiple_answer_three_75 , p0_ . multiple_answer_four AS multiple_answer_four_76 , p0_ . shop_postal_code AS shop_postal_code_77 , p0_ . gift AS gift_78 , p0_ . gift_id AS gift_id_79 , p0_ . question1 AS question1_80 , p0_ . question2 AS question2_81 , p0_ . question3 AS question3_82 , p0_ . dissatisfaction_reason AS dissatisfaction_reason_83 , p0_ . bar_code AS bar_code_84 , p0_ . promo_code AS promo_code_85 , p0_ . operation_id AS operation_id_86 , p0_ . decline_subject_id AS decline_subject_id_87 , p0_ . transfer_id AS transfer_id_88 , p0_ . check_payment_id AS check_payment_id_89 , p0_ . shop_id AS shop_id_90 , p0_ . author_id AS author_id_91 , p0_ . optin_id AS optin_id_92 , p0_ . created_by_id AS created_by_id_93 , p0_ . type_status_id AS type_status_id_94 , p0_ . godfather_id AS godfather_id_95 , p0_ . installer_id AS installer_id_96 , p0_ . answer_id AS answer_id_97 , p0_ . instant_win_id AS instant_win_id_98 FROM purchase p0_ WHERE p0_ . operation_id = ? AND p0_ . status > 0
SELECT
p0_ . id AS id_0 ,
p0_ . created_at AS created_at_1 ,
p0_ . updated_at AS updated_at_2 ,
p0_ . desicion_week AS desicion_week_3 ,
p0_ . purchase_receipt AS purchase_receipt_4 ,
p0_ . grey_card AS grey_card_5 ,
p0_ . rib AS rib_6 ,
p0_ . invoice_receipt AS invoice_receipt_7 ,
p0_ . other_doc AS other_doc_8 ,
p0_ . purchased_at AS purchased_at_9 ,
p0_ . status AS status_10 ,
p0_ . status_message AS status_message_11 ,
p0_ . action_at AS action_at_12 ,
p0_ . purchase_code AS purchase_code_13 ,
p0_ . uuid AS uuid_14 ,
p0_ . channel AS channel_15 ,
p0_ . iban AS iban_16 ,
p0_ . total_amount AS total_amount_17 ,
p0_ . reward AS reward_18 ,
p0_ . rewarded AS rewarded_19 ,
p0_ . additional_decline_message AS additional_decline_message_20 ,
p0_ . additional_accept_message AS additional_accept_message_21 ,
p0_ . all_doublon_ticket_amount_shop_purchase_date AS all_doublon_ticket_amount_shop_purchase_date_22 ,
p0_ . doublon_ticket_amount_shop_purchase_date AS doublon_ticket_amount_shop_purchase_date_23 ,
p0_ . total_quantity AS total_quantity_24 ,
p0_ . decision_week AS decision_week_25 ,
p0_ . comment AS comment_26 ,
p0_ . doublon_first_name_last_name AS doublon_first_name_last_name_27 ,
p0_ . all_doublon_first_name_last_name AS all_doublon_first_name_last_name_28 ,
p0_ . doublon_last_name_zip_code AS doublon_last_name_zip_code_29 ,
p0_ . all_doublon_last_name_zip_code AS all_doublon_last_name_zip_code_30 ,
p0_ . doublon_adress_iban AS doublon_adress_iban_31 ,
p0_ . all_doublon_address_iban AS all_doublon_address_iban_32 ,
p0_ . doublon_purchase_date_shop_total_purchase_amount AS doublon_purchase_date_shop_total_purchase_amount_33 ,
p0_ . all_doublon_purchase_date_shop_total_purchase_amount AS all_doublon_purchase_date_shop_total_purchase_amount_34 ,
p0_ . personal_cheque_number AS personal_cheque_number_35 ,
p0_ . refunded_at AS refunded_at_36 ,
p0_ . location AS location_37 ,
p0_ . zipcode AS zipcode_38 ,
p0_ . city AS city_39 ,
p0_ . serial_number AS serial_number_40 ,
p0_ . shop_name AS shop_name_41 ,
p0_ . original_id AS original_id_42 ,
p0_ . doublon_purchase_date_zip_code_shop_total_purchase_amount AS doublon_purchase_date_zip_code_shop_total_purchase_amount_43 ,
p0_ . all_doublon_purchase_date_zip_code_shop_total_purchase_amount AS ll_doublon_purchase_date_zip_code_shop_total_purchase_amount_44 ,
p0_ . invoice_installation AS invoice_installation_45 ,
p0_ . is_sent AS is_sent_46 ,
p0_ . original_base AS original_base_47 ,
p0_ . origin AS origin_48 ,
p0_ . installed_at AS installed_at_49 ,
p0_ . is_private_usage AS is_private_usage_50 ,
p0_ . email_author AS email_author_51 ,
p0_ . author_first_name AS author_first_name_52 ,
p0_ . author_last_name AS author_last_name_53 ,
p0_ . city_value AS city_value_54 ,
p0_ . shop_value AS shop_value_55 ,
p0_ . answer1 AS answer1_56 ,
p0_ . answer2 AS answer2_57 ,
p0_ . answer3 AS answer3_58 ,
p0_ . answer4 AS answer4_59 ,
p0_ . is_decline_final AS is_decline_final_60 ,
p0_ . rib_control AS rib_control_61 ,
p0_ . rib_control_at AS rib_control_at_62 ,
p0_ . grey_card_control AS grey_card_control_63 ,
p0_ . grey_card_control_at AS grey_card_control_at_64 ,
p0_ . yes_no_answer_one AS yes_no_answer_one_65 ,
p0_ . yes_no_answer_two AS yes_no_answer_two_66 ,
p0_ . yes_no_answer_three AS yes_no_answer_three_67 ,
p0_ . yes_no_answer_four AS yes_no_answer_four_68 ,
p0_ . ranking_answer_one AS ranking_answer_one_69 ,
p0_ . ranking_answer_two AS ranking_answer_two_70 ,
p0_ . ranking_answer_three AS ranking_answer_three_71 ,
p0_ . ranking_answer_four AS ranking_answer_four_72 ,
p0_ . multiple_answer_one AS multiple_answer_one_73 ,
p0_ . multiple_answer_two AS multiple_answer_two_74 ,
p0_ . multiple_answer_three AS multiple_answer_three_75 ,
p0_ . multiple_answer_four AS multiple_answer_four_76 ,
p0_ . shop_postal_code AS shop_postal_code_77 ,
p0_ . gift AS gift_78 ,
p0_ . gift_id AS gift_id_79 ,
p0_ . question1 AS question1_80 ,
p0_ . question2 AS question2_81 ,
p0_ . question3 AS question3_82 ,
p0_ . dissatisfaction_reason AS dissatisfaction_reason_83 ,
p0_ . bar_code AS bar_code_84 ,
p0_ . promo_code AS promo_code_85 ,
p0_ . operation_id AS operation_id_86 ,
p0_ . decline_subject_id AS decline_subject_id_87 ,
p0_ . transfer_id AS transfer_id_88 ,
p0_ . check_payment_id AS check_payment_id_89 ,
p0_ . shop_id AS shop_id_90 ,
p0_ . author_id AS author_id_91 ,
p0_ . optin_id AS optin_id_92 ,
p0_ . created_by_id AS created_by_id_93 ,
p0_ . type_status_id AS type_status_id_94 ,
p0_ . godfather_id AS godfather_id_95 ,
p0_ . installer_id AS installer_id_96 ,
p0_ . answer_id AS answer_id_97 ,
p0_ . instant_win_id AS instant_win_id_98
FROM
purchase p0_
WHERE
p0_ . operation_id = ?
AND p0_ . status > 0
Copy
SELECT p0_ . id AS id_0 , p0_ . created_at AS created_at_1 , p0_ . updated_at AS updated_at_2 , p0_ . desicion_week AS desicion_week_3 , p0_ . purchase_receipt AS purchase_receipt_4 , p0_ . grey_card AS grey_card_5 , p0_ . rib AS rib_6 , p0_ . invoice_receipt AS invoice_receipt_7 , p0_ . other_doc AS other_doc_8 , p0_ . purchased_at AS purchased_at_9 , p0_ . status AS status_10 , p0_ . status_message AS status_message_11 , p0_ . action_at AS action_at_12 , p0_ . purchase_code AS purchase_code_13 , p0_ . uuid AS uuid_14 , p0_ . channel AS channel_15 , p0_ . iban AS iban_16 , p0_ . total_amount AS total_amount_17 , p0_ . reward AS reward_18 , p0_ . rewarded AS rewarded_19 , p0_ . additional_decline_message AS additional_decline_message_20 , p0_ . additional_accept_message AS additional_accept_message_21 , p0_ . all_doublon_ticket_amount_shop_purchase_date AS all_doublon_ticket_amount_shop_purchase_date_22 , p0_ . doublon_ticket_amount_shop_purchase_date AS doublon_ticket_amount_shop_purchase_date_23 , p0_ . total_quantity AS total_quantity_24 , p0_ . decision_week AS decision_week_25 , p0_ . comment AS comment_26 , p0_ . doublon_first_name_last_name AS doublon_first_name_last_name_27 , p0_ . all_doublon_first_name_last_name AS all_doublon_first_name_last_name_28 , p0_ . doublon_last_name_zip_code AS doublon_last_name_zip_code_29 , p0_ . all_doublon_last_name_zip_code AS all_doublon_last_name_zip_code_30 , p0_ . doublon_adress_iban AS doublon_adress_iban_31 , p0_ . all_doublon_address_iban AS all_doublon_address_iban_32 , p0_ . doublon_purchase_date_shop_total_purchase_amount AS doublon_purchase_date_shop_total_purchase_amount_33 , p0_ . all_doublon_purchase_date_shop_total_purchase_amount AS all_doublon_purchase_date_shop_total_purchase_amount_34 , p0_ . personal_cheque_number AS personal_cheque_number_35 , p0_ . refunded_at AS refunded_at_36 , p0_ . location AS location_37 , p0_ . zipcode AS zipcode_38 , p0_ . city AS city_39 , p0_ . serial_number AS serial_number_40 , p0_ . shop_name AS shop_name_41 , p0_ . original_id AS original_id_42 , p0_ . doublon_purchase_date_zip_code_shop_total_purchase_amount AS doublon_purchase_date_zip_code_shop_total_purchase_amount_43 , p0_ . all_doublon_purchase_date_zip_code_shop_total_purchase_amount AS ll_doublon_purchase_date_zip_code_shop_total_purchase_amount_44 , p0_ . invoice_installation AS invoice_installation_45 , p0_ . is_sent AS is_sent_46 , p0_ . original_base AS original_base_47 , p0_ . origin AS origin_48 , p0_ . installed_at AS installed_at_49 , p0_ . is_private_usage AS is_private_usage_50 , p0_ . email_author AS email_author_51 , p0_ . author_first_name AS author_first_name_52 , p0_ . author_last_name AS author_last_name_53 , p0_ . city_value AS city_value_54 , p0_ . shop_value AS shop_value_55 , p0_ . answer1 AS answer1_56 , p0_ . answer2 AS answer2_57 , p0_ . answer3 AS answer3_58 , p0_ . answer4 AS answer4_59 , p0_ . is_decline_final AS is_decline_final_60 , p0_ . rib_control AS rib_control_61 , p0_ . rib_control_at AS rib_control_at_62 , p0_ . grey_card_control AS grey_card_control_63 , p0_ . grey_card_control_at AS grey_card_control_at_64 , p0_ . yes_no_answer_one AS yes_no_answer_one_65 , p0_ . yes_no_answer_two AS yes_no_answer_two_66 , p0_ . yes_no_answer_three AS yes_no_answer_three_67 , p0_ . yes_no_answer_four AS yes_no_answer_four_68 , p0_ . ranking_answer_one AS ranking_answer_one_69 , p0_ . ranking_answer_two AS ranking_answer_two_70 , p0_ . ranking_answer_three AS ranking_answer_three_71 , p0_ . ranking_answer_four AS ranking_answer_four_72 , p0_ . multiple_answer_one AS multiple_answer_one_73 , p0_ . multiple_answer_two AS multiple_answer_two_74 , p0_ . multiple_answer_three AS multiple_answer_three_75 , p0_ . multiple_answer_four AS multiple_answer_four_76 , p0_ . shop_postal_code AS shop_postal_code_77 , p0_ . gift AS gift_78 , p0_ . gift_id AS gift_id_79 , p0_ . question1 AS question1_80 , p0_ . question2 AS question2_81 , p0_ . question3 AS question3_82 , p0_ . dissatisfaction_reason AS dissatisfaction_reason_83 , p0_ . bar_code AS bar_code_84 , p0_ . promo_code AS promo_code_85 , p0_ . operation_id AS operation_id_86 , p0_ . decline_subject_id AS decline_subject_id_87 , p0_ . transfer_id AS transfer_id_88 , p0_ . check_payment_id AS check_payment_id_89 , p0_ . shop_id AS shop_id_90 , p0_ . author_id AS author_id_91 , p0_ . optin_id AS optin_id_92 , p0_ . created_by_id AS created_by_id_93 , p0_ . type_status_id AS type_status_id_94 , p0_ . godfather_id AS godfather_id_95 , p0_ . installer_id AS installer_id_96 , p0_ . answer_id AS answer_id_97 , p0_ . instant_win_id AS instant_win_id_98 FROM purchase p0_ WHERE p0_ . operation_id = 58 AND p0_ . status > 0 ;
Copy