Query Metrics
7
Database Queries
7
Different statements
41.69 ms
Query time
10
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20.52 ms (49.23%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
19.98 ms (47.93%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
0.41 ms (0.99%) |
1 |
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 = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
0.28 ms (0.68%) |
1 |
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"
]
|
||||||||||||||||||||||||||||
0.24 ms (0.58%) |
1 |
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
Parameters:
[
58
]
|
||||||||||||||||||||||||||||
0.13 ms (0.31%) |
1 |
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 = ?
Parameters:
[
58
]
|
||||||||||||||||||||||||||||
0.12 ms (0.28%) |
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
Parameters:
[]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Configuration | No errors. |
App\Entity\Operation |
|
App\Entity\FieldFormUser | No errors. |
App\Entity\FieldFormProduct | No errors. |
App\Entity\FieldFormDocument |
|
App\Entity\FieldFormRefund |
|
App\Entity\FieldFormOptin |
|
App\Entity\FieldFormQuestion |
|
App\Entity\FieldFormPurchase | No errors. |
App\Entity\TypeChannel |
|
App\Entity\Stats | No errors. |
App\Entity\TypeProcess |
|
App\Entity\Purchase | No errors. |
App\Entity\Shop | No errors. |
App\Entity\Product | No errors. |
App\Entity\OperationAdditionalData | No errors. |
App\Entity\User | No errors. |
App\Entity\Fund | No errors. |
App\Entity\Mecanique | No errors. |
App\Entity\Bilan | No errors. |
App\Entity\Transfer | No errors. |
App\Entity\Siret | No errors. |
App\Entity\Participation | No errors. |
App\Entity\DeclineSubject | No errors. |
App\Entity\CheckPayment | No errors. |
App\Entity\Optin |
|
App\Entity\TypeStatus | No errors. |
App\Entity\Godfather | No errors. |
App\Entity\Installer | No errors. |
App\Entity\Answer | No errors. |
App\Entity\InstantWin |
|
App\Entity\PageEnd | No errors. |
App\Entity\ProductPurchase | No errors. |
App\Entity\Doublon |
|