https://www.vinietaoxigen.ro/iframe/check-iframe-order?ext_order_id=135000&token=nqlx3xqmnoo89k9

Query Metrics

24 Database Queries
23 Different statements
12.21 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, t0.account_verification_required AS account_verification_required_15, t0.default_locale_id AS default_locale_id_16, t17.code AS code_18, t17.created_at AS created_at_19, t17.updated_at AS updated_at_20, t17.id AS id_21, t0.base_currency_id AS base_currency_id_22, t23.code AS code_24, t23.created_at AS created_at_25, t23.updated_at AS updated_at_26, t23.id AS id_27, t0.default_tax_zone_id AS default_tax_zone_id_28, t0.shop_billing_data_id AS shop_billing_data_id_29 FROM sylius_channel t0 INNER JOIN sylius_locale t17 ON t0.default_locale_id = t17.id INNER JOIN sylius_currency t23 ON t0.base_currency_id = t23.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "www.vinietaoxigen.ro"
]
2 0.45 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, t0.account_verification_required AS account_verification_required_15, t0.default_locale_id AS default_locale_id_16, t17.code AS code_18, t17.created_at AS created_at_19, t17.updated_at AS updated_at_20, t17.id AS id_21, t0.base_currency_id AS base_currency_id_22, t23.code AS code_24, t23.created_at AS created_at_25, t23.updated_at AS updated_at_26, t23.id AS id_27, t0.default_tax_zone_id AS default_tax_zone_id_28, t0.shop_billing_data_id AS shop_billing_data_id_29 FROM sylius_channel t0 INNER JOIN sylius_locale t17 ON t0.default_locale_id = t17.id INNER JOIN sylius_currency t23 ON t0.base_currency_id = t23.id
Parameters:
[]
3 0.34 ms
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
Parameters:
[
  1
]
4 0.38 ms
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
  1
]
5 0.26 ms
SELECT v0_.id AS id_0, v0_.date_from AS date_from_1, v0_.date_to AS date_to_2 FROM vignette_maintenance v0_ ORDER BY v0_.id DESC LIMIT 1
Parameters:
[]
6 0.40 ms
SELECT p0_.id AS id_0, p0_.vignette_status AS vignette_status_1, p0_.vignette_road_assistance_status AS vignette_road_assistance_status_2, p0_.vignette_sms_status AS vignette_sms_status_3, p0_.hu_vignette_status AS hu_vignette_status_4, p0_.rca_status AS rca_status_5, p0_.rca_road_assistance_status AS rca_road_assistance_status_6, p0_.road_assistance_status AS road_assistance_status_7, p0_.death_insurance_status AS death_insurance_status_8, p0_.license_recovery_status AS license_recovery_status_9, p0_.telemedicine_status AS telemedicine_status_10, p0_.extra_options_status AS extra_options_status_11, p0_.extra_options_death_insurance_status AS extra_options_death_insurance_status_12, p0_.extra_options_road_assistance_status AS extra_options_road_assistance_status_13, p0_.extra_options_sms_status AS extra_options_sms_status_14, p0_.extra_options_license_recovery_status AS extra_options_license_recovery_status_15, p0_.extra_options_telemedicine_status AS extra_options_telemedicine_status_16, p0_.discount_rca_commission AS discount_rca_commission_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.admin_id AS admin_id_20 FROM product_status p0_ ORDER BY p0_.id DESC LIMIT 1
Parameters:
[]
7 0.23 ms
SELECT p0_.id AS id_0, p0_.vignette_status AS vignette_status_1, p0_.vignette_road_assistance_status AS vignette_road_assistance_status_2, p0_.vignette_sms_status AS vignette_sms_status_3, p0_.hu_vignette_status AS hu_vignette_status_4, p0_.rca_status AS rca_status_5, p0_.rca_road_assistance_status AS rca_road_assistance_status_6, p0_.road_assistance_status AS road_assistance_status_7, p0_.death_insurance_status AS death_insurance_status_8, p0_.license_recovery_status AS license_recovery_status_9, p0_.telemedicine_status AS telemedicine_status_10, p0_.extra_options_status AS extra_options_status_11, p0_.extra_options_death_insurance_status AS extra_options_death_insurance_status_12, p0_.extra_options_road_assistance_status AS extra_options_road_assistance_status_13, p0_.extra_options_sms_status AS extra_options_sms_status_14, p0_.extra_options_license_recovery_status AS extra_options_license_recovery_status_15, p0_.extra_options_telemedicine_status AS extra_options_telemedicine_status_16, p0_.discount_rca_commission AS discount_rca_commission_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19 FROM product_status p0_ ORDER BY p0_.id DESC LIMIT 1
Parameters:
[]
8 0.19 ms
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, t0_.admin_id AS admin_id_4 FROM template_status t0_ ORDER BY t0_.id DESC LIMIT 1
Parameters:
[]
9 0.20 ms
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3 FROM template_status t0_ ORDER BY t0_.id DESC LIMIT 1
Parameters:
[]
10 0.30 ms
SELECT c0_.id AS id_0, c0_.ar_promo_price_status AS ar_promo_price_status_1, c0_.ar_promo_price AS ar_promo_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.admin_id AS admin_id_5 FROM campaign_status c0_ ORDER BY c0_.id DESC LIMIT 1
Parameters:
[]
11 0.23 ms
SELECT c0_.id AS id_0, c0_.ar_promo_price_status AS ar_promo_price_status_1, c0_.ar_promo_price AS ar_promo_price_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4 FROM campaign_status c0_ ORDER BY c0_.id DESC LIMIT 1
Parameters:
[]
12 0.57 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.cif_code AS cif_code_3, t0.public_token AS public_token_4, t0.secret_token AS secret_token_5, t0.commission_percentage AS commission_percentage_6, t0.discount_rca_commission_percentage AS discount_rca_commission_percentage_7, t0.place_order_from_product_page AS place_order_from_product_page_8, t0.use_partner_payment_processor AS use_partner_payment_processor_9, t0.without_local_storage AS without_local_storage_10, t0.only_one_product_in_cart AS only_one_product_in_cart_11, t0.is_enabled AS is_enabled_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.autocomplete_limit AS autocomplete_limit_15, t0.remaining_autocomplete_limit AS remaining_autocomplete_limit_16, t0.has_autocomplete_limitless AS has_autocomplete_limitless_17, t0.flags AS flags_18, t0.vignette_api_key AS vignette_api_key_19, t0.company_email AS company_email_20, t0.company_raport_email AS company_raport_email_21, t0.ws_agent_email AS ws_agent_email_22, t0.qr_code_confirm_url AS qr_code_confirm_url_23, t0.role_id AS role_id_24, t0.address_id AS address_id_25 FROM partner t0 WHERE t0.public_token = ? LIMIT 1
Parameters:
[
  "nqlx3xqmnoo89k9"
]
13 1.10 ms
SELECT t0.number AS number_1, t0.notes AS notes_2, t0.state AS state_3, t0.checkout_completed_at AS checkout_completed_at_4, t0.items_total AS items_total_5, t0.adjustments_total AS adjustments_total_6, t0.total AS total_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.id AS id_10, t0.currency_code AS currency_code_11, t0.locale_code AS locale_code_12, t0.checkout_state AS checkout_state_13, t0.payment_state AS payment_state_14, t0.shipping_state AS shipping_state_15, t0.token_value AS token_value_16, t0.customer_ip AS customer_ip_17, t0.old_db_id AS old_db_id_18, t0.ipn_code AS ipn_code_19, t0.paysera_payment_method_code AS paysera_payment_method_code_20, t0.channel_id AS channel_id_21, t0.promotion_coupon_id AS promotion_coupon_id_22, t0.customer_id AS customer_id_23, t0.payment_method AS payment_method_24, t25.id AS id_26, t25.op_code AS op_code_27, t25.cnair_code AS cnair_code_28, t25.created_at AS created_at_29, t25.order_id AS order_id_30, t0.billing_address_id AS billing_address_id_31, t0.shipping_address_id AS shipping_address_id_32, t0.partner_id AS partner_id_33, t34.id AS id_35, t34.created_at AS created_at_36, t34.updated_at AS updated_at_37, t34.partner_comission_id AS partner_comission_id_38, t34.order_id AS order_id_39, t40.agency_name AS agency_name_41, t40.confirmed_at AS confirmed_at_42, t40.payment_receipt_date AS payment_receipt_date_43, t40.hash AS hash_44, t40.flags AS flags_45, t40.order_id AS order_id_46 FROM sylius_order t0 LEFT JOIN log_op_payment_vignettes t25 ON t25.order_id = t0.id LEFT JOIN order_comission t34 ON t34.order_id = t0.id LEFT JOIN order_extra_data t40 ON t40.order_id = t0.id WHERE t0.id = ?
Parameters:
[
  "135000"
]
14 1.44 ms
SELECT t0.id AS id_1, t0.valid_from AS valid_from_2, t0.valid_until AS valid_until_3, t0.price AS price_4, t0.price_currency AS price_currency_5, t0.auth_price AS auth_price_6, t0.auth_currency AS auth_currency_7, t0.total_no_tva AS total_no_tva_8, t0.registration_plate AS registration_plate_9, t0.vin AS vin_10, t0.renew AS renew_11, t0.status AS status_12, t0.old_db_id AS old_db_id_13, t0.client_id AS client_id_14, t0.order_id AS order_id_15, t0.category_id AS category_id_16, t0.availability_id AS availability_id_17, t0.country_id AS country_id_18, t0.api_general_id AS api_general_id_19, t20.id AS id_21, t20.is_sent AS is_sent_22, t20.is_paid AS is_paid_23, t20.error_message AS error_message_24, t20.vignette_id AS vignette_id_25, t20.rca_id AS rca_id_26, t20.hu_vignette_id AS hu_vignette_id_27, t28.quantity AS quantity_29, t28.unit_price AS unit_price_30, t28.units_total AS units_total_31, t28.adjustments_total AS adjustments_total_32, t28.total AS total_33, t28.is_immutable AS is_immutable_34, t28.id AS id_35, t28.product_name AS product_name_36, t28.variant_name AS variant_name_37, t28.issued_at AS issued_at_38, t28.refunded_at AS refunded_at_39, t28.order_id AS order_id_40, t28.variant_id AS variant_id_41, t28.vignette_id AS vignette_id_42, t28.rca_id AS rca_id_43, t28.hu_vignette_id AS hu_vignette_id_44, t28.sms_id AS sms_id_45, t28.road_assistance_id AS road_assistance_id_46, t28.death_insurance_id AS death_insurance_id_47, t28.license_recovery_id AS license_recovery_id_48, t28.telemedicine_id AS telemedicine_id_49, t50.id AS id_51, t50.api_response AS api_response_52, t50.vignette_id AS vignette_id_53, t54.id AS id_55, t54.is_sent AS is_sent_56, t54.is_sent_before_last_day AS is_sent_before_last_day_57, t54.vignette_id AS vignette_id_58, t54.customer_vehicle_id AS customer_vehicle_id_59, t60.id AS id_61, t60.email_allowed AS email_allowed_62, t60.email AS email_63, t60.created_at AS created_at_64, t60.updated_at AS updated_at_65, t60.vignette_id AS vignette_id_66, t67.id AS id_68, t67.number_of_retries AS number_of_retries_69, t67.is_issued AS is_issued_70, t67.created_at AS created_at_71, t67.updated_at AS updated_at_72, t67.vignette_id AS vignette_id_73 FROM vignette t0 LEFT JOIN SMS t20 ON t20.vignette_id = t0.id LEFT JOIN sylius_order_item t28 ON t28.vignette_id = t0.id LEFT JOIN vignette_api_init t50 ON t50.vignette_id = t0.id LEFT JOIN vignette_alert t54 ON t54.vignette_id = t0.id LEFT JOIN cnair_alert t60 ON t60.vignette_id = t0.id LEFT JOIN vignette_failed t67 ON t67.vignette_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
15 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.vin_required AS vin_required_3, t0.url AS url_4, t0.ws_id AS ws_id_5 FROM vignette_availability t0 WHERE t0.id = ?
Parameters:
[
  1
]
16 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4, t0.ws_id AS ws_id_5 FROM vignette_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
17 0.29 ms
SELECT t0.id AS id_1, t0.rca_commission_percentage AS rca_commission_percentage_2, t0.death_insurance_commission_percentage AS death_insurance_commission_percentage_3, t0.license_recovery_commission_percentage AS license_recovery_commission_percentage_4, t0.road_assistance_commission_percentage AS road_assistance_commission_percentage_5, t0.ro_vignette_commission_percentage AS ro_vignette_commission_percentage_6, t0.hu_vignette_commission_percentage AS hu_vignette_commission_percentage_7, t0.telemedicine_commission_percentage AS telemedicine_commission_percentage_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.partner_id AS partner_id_11 FROM partner_comission t0 WHERE t0.id = ?
Parameters:
[
  145
]
18 0.64 ms
SELECT t0.id AS id_1, t0.registration_plate AS registration_plate_2, t0.vin AS vin_3, t0.valid_from AS valid_from_4, t0.valid_until AS valid_until_5, t0.price AS price_6, t0.unit_price AS unit_price_7, t0.vat_amount AS vat_amount_8, t0.vat_percentage AS vat_percentage_9, t0.markup_amount AS markup_amount_10, t0.currency AS currency_11, t0.auth_price AS auth_price_12, t0.auth_unit_price AS auth_unit_price_13, t0.auth_vat_amount AS auth_vat_amount_14, t0.auth_markup_amount AS auth_markup_amount_15, t0.auth_currency AS auth_currency_16, t0.exchange_rate AS exchange_rate_17, t0.exchange_rate_date AS exchange_rate_date_18, t0.alternate_price AS alternate_price_19, t0.alternate_unit_price AS alternate_unit_price_20, t0.alternate_vat_amount AS alternate_vat_amount_21, t0.alternate_exchange_rate AS alternate_exchange_rate_22, t0.alternate_markup_amount AS alternate_markup_amount_23, t0.alternate_currency AS alternate_currency_24, t0.series AS series_25, t0.guid AS guid_26, t0.transaction_id AS transaction_id_27, t0.renew AS renew_28, t0.status AS status_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.flags AS flags_32, t0.customer_id AS customer_id_33, t0.order_id AS order_id_34, t0.category_id AS category_id_35, t0.availability_id AS availability_id_36, t0.country_id AS country_id_37, t0.hu_vignette_api_id AS hu_vignette_api_id_38, t39.id AS id_40, t39.is_sent AS is_sent_41, t39.is_paid AS is_paid_42, t39.error_message AS error_message_43, t39.vignette_id AS vignette_id_44, t39.rca_id AS rca_id_45, t39.hu_vignette_id AS hu_vignette_id_46, t47.quantity AS quantity_48, t47.unit_price AS unit_price_49, t47.units_total AS units_total_50, t47.adjustments_total AS adjustments_total_51, t47.total AS total_52, t47.is_immutable AS is_immutable_53, t47.id AS id_54, t47.product_name AS product_name_55, t47.variant_name AS variant_name_56, t47.issued_at AS issued_at_57, t47.refunded_at AS refunded_at_58, t47.order_id AS order_id_59, t47.variant_id AS variant_id_60, t47.vignette_id AS vignette_id_61, t47.rca_id AS rca_id_62, t47.hu_vignette_id AS hu_vignette_id_63, t47.sms_id AS sms_id_64, t47.road_assistance_id AS road_assistance_id_65, t47.death_insurance_id AS death_insurance_id_66, t47.license_recovery_id AS license_recovery_id_67, t47.telemedicine_id AS telemedicine_id_68, t69.id AS id_70, t69.is_sent AS is_sent_71, t69.is_sent_before_last_day AS is_sent_before_last_day_72, t69.hu_vignette_id AS hu_vignette_id_73, t74.id AS id_75, t74.number_of_retries AS number_of_retries_76, t74.is_issued AS is_issued_77, t74.created_at AS created_at_78, t74.updated_at AS updated_at_79, t74.hu_vignette_id AS hu_vignette_id_80 FROM hu_vignette t0 LEFT JOIN SMS t39 ON t39.hu_vignette_id = t0.id LEFT JOIN sylius_order_item t47 ON t47.hu_vignette_id = t0.id LEFT JOIN hu_vignette_alert t69 ON t69.hu_vignette_id = t0.id LEFT JOIN hu_vignette_failed t74 ON t74.hu_vignette_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
19 0.62 ms
SELECT t0.price AS price_1, t0.bm AS bm_2, t0.auction_code AS auction_code_3, t0.insurance_class AS insurance_class_4, t0.ws_offer_id AS ws_offer_id_5, t0.commission_value AS commission_value_6, t0.commission_percentage AS commission_percentage_7, t0.green_card_excluded AS green_card_excluded_8, t0.is_deducted AS is_deducted_9, t0.series AS series_10, t0.number AS number_11, t0.valid_from AS valid_from_12, t0.valid_until AS valid_until_13, t0.final_price AS final_price_14, t0.sent_to_customer AS sent_to_customer_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.insurance_company_id AS insurance_company_id_19, t0.car_id AS car_id_20, t0.order_id AS order_id_21, t22.quantity AS quantity_23, t22.unit_price AS unit_price_24, t22.units_total AS units_total_25, t22.adjustments_total AS adjustments_total_26, t22.total AS total_27, t22.is_immutable AS is_immutable_28, t22.id AS id_29, t22.product_name AS product_name_30, t22.variant_name AS variant_name_31, t22.issued_at AS issued_at_32, t22.refunded_at AS refunded_at_33, t22.order_id AS order_id_34, t22.variant_id AS variant_id_35, t22.vignette_id AS vignette_id_36, t22.rca_id AS rca_id_37, t22.hu_vignette_id AS hu_vignette_id_38, t22.sms_id AS sms_id_39, t22.road_assistance_id AS road_assistance_id_40, t22.death_insurance_id AS death_insurance_id_41, t22.license_recovery_id AS license_recovery_id_42, t22.telemedicine_id AS telemedicine_id_43, t0.customer_id AS customer_id_44, t45.id AS id_46, t45.is_sent AS is_sent_47, t45.is_sent_before_last_day AS is_sent_before_last_day_48, t45.rca_id AS rca_id_49, t50.id AS id_51, t50.is_sent AS is_sent_52, t50.is_paid AS is_paid_53, t50.error_message AS error_message_54, t50.vignette_id AS vignette_id_55, t50.rca_id AS rca_id_56, t50.hu_vignette_id AS hu_vignette_id_57, t0.availability_id AS availability_id_58, t59.id AS id_60, t59.number_of_retries AS number_of_retries_61, t59.is_issued AS is_issued_62, t59.created_at AS created_at_63, t59.updated_at AS updated_at_64, t59.rca_id AS rca_id_65 FROM rca t0 LEFT JOIN sylius_order_item t22 ON t22.rca_id = t0.id LEFT JOIN rca_alert t45 ON t45.rca_id = t0.id LEFT JOIN SMS t50 ON t50.rca_id = t0.id LEFT JOIN rca_failed t59 ON t59.rca_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
20 0.79 ms
SELECT t0.id AS id_1, t0.registration_plate AS registration_plate_2, t0.vin AS vin_3, t0.valid_from AS valid_from_4, t0.valid_until AS valid_until_5, t0.price AS price_6, t0.status AS status_7, t0.flags AS flags_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.customer_id AS customer_id_11, t0.order_id AS order_id_12, t0.category_id AS category_id_13, t0.availability_id AS availability_id_14, t0.country_id AS country_id_15, t0.road_assistance_api_id AS road_assistance_api_id_16, t0.ro_vignette_id AS ro_vignette_id_17, t18.id AS id_19, t18.number_of_retries AS number_of_retries_20, t18.is_issued AS is_issued_21, t18.created_at AS created_at_22, t18.updated_at AS updated_at_23, t18.road_assistance_id AS road_assistance_id_24, t25.quantity AS quantity_26, t25.unit_price AS unit_price_27, t25.units_total AS units_total_28, t25.adjustments_total AS adjustments_total_29, t25.total AS total_30, t25.is_immutable AS is_immutable_31, t25.id AS id_32, t25.product_name AS product_name_33, t25.variant_name AS variant_name_34, t25.issued_at AS issued_at_35, t25.refunded_at AS refunded_at_36, t25.order_id AS order_id_37, t25.variant_id AS variant_id_38, t25.vignette_id AS vignette_id_39, t25.rca_id AS rca_id_40, t25.hu_vignette_id AS hu_vignette_id_41, t25.sms_id AS sms_id_42, t25.road_assistance_id AS road_assistance_id_43, t25.death_insurance_id AS death_insurance_id_44, t25.license_recovery_id AS license_recovery_id_45, t25.telemedicine_id AS telemedicine_id_46 FROM road_assistance t0 LEFT JOIN road_assistance_failed t18 ON t18.road_assistance_id = t0.id LEFT JOIN sylius_order_item t25 ON t25.road_assistance_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
21 1.54 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.cnp AS cnp_3, t0.email AS email_4, t0.phone AS phone_5, t0.scala_code AS scala_code_6, t0.offer_number AS offer_number_7, t0.policy_number AS policy_number_8, t0.valid_from AS valid_from_9, t0.valid_until AS valid_until_10, t0.price AS price_11, t0.offer_sent_to_customer AS offer_sent_to_customer_12, t0.newsletter_confirmation_nn AS newsletter_confirmation_nn_13, t0.dnt_confirmation AS dnt_confirmation_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.order_id AS order_id_18, t19.quantity AS quantity_20, t19.unit_price AS unit_price_21, t19.units_total AS units_total_22, t19.adjustments_total AS adjustments_total_23, t19.total AS total_24, t19.is_immutable AS is_immutable_25, t19.id AS id_26, t19.product_name AS product_name_27, t19.variant_name AS variant_name_28, t19.issued_at AS issued_at_29, t19.refunded_at AS refunded_at_30, t19.order_id AS order_id_31, t19.variant_id AS variant_id_32, t19.vignette_id AS vignette_id_33, t19.rca_id AS rca_id_34, t19.hu_vignette_id AS hu_vignette_id_35, t19.sms_id AS sms_id_36, t19.road_assistance_id AS road_assistance_id_37, t19.death_insurance_id AS death_insurance_id_38, t19.license_recovery_id AS license_recovery_id_39, t19.telemedicine_id AS telemedicine_id_40, t0.customer_id AS customer_id_41, t0.ro_vignette_id AS ro_vignette_id_42, t0.rca_id AS rca_id_43, t0.hu_vignette_id AS hu_vignette_id_44 FROM death_insurance t0 LEFT JOIN sylius_order_item t19 ON t19.death_insurance_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
22 0.37 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.cnp AS cnp_3, t0.email AS email_4, t0.phone AS phone_5, t0.scala_code AS scala_code_6, t0.invoice_series AS invoice_series_7, t0.invoice_number AS invoice_number_8, t0.valid_from AS valid_from_9, t0.valid_until AS valid_until_10, t0.price AS price_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.flags AS flags_15, t0.order_id AS order_id_16, t17.quantity AS quantity_18, t17.unit_price AS unit_price_19, t17.units_total AS units_total_20, t17.adjustments_total AS adjustments_total_21, t17.total AS total_22, t17.is_immutable AS is_immutable_23, t17.id AS id_24, t17.product_name AS product_name_25, t17.variant_name AS variant_name_26, t17.issued_at AS issued_at_27, t17.refunded_at AS refunded_at_28, t17.order_id AS order_id_29, t17.variant_id AS variant_id_30, t17.vignette_id AS vignette_id_31, t17.rca_id AS rca_id_32, t17.hu_vignette_id AS hu_vignette_id_33, t17.sms_id AS sms_id_34, t17.road_assistance_id AS road_assistance_id_35, t17.death_insurance_id AS death_insurance_id_36, t17.license_recovery_id AS license_recovery_id_37, t17.telemedicine_id AS telemedicine_id_38, t0.customer_id AS customer_id_39 FROM license_recovery t0 LEFT JOIN sylius_order_item t17 ON t17.license_recovery_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
23 0.41 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.price AS price_5, t0.valid_from AS valid_from_6, t0.valid_until AS valid_until_7, t0.status AS status_8, t0.invoice_series AS invoice_series_9, t0.invoice_number AS invoice_number_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.flags AS flags_13, t14.id AS id_15, t14.code AS code_16, t14.status AS status_17, t14.used_at AS used_at_18, t14.created_at AS created_at_19, t14.telemedicine_id AS telemedicine_id_20, t0.order_id AS order_id_21, t22.quantity AS quantity_23, t22.unit_price AS unit_price_24, t22.units_total AS units_total_25, t22.adjustments_total AS adjustments_total_26, t22.total AS total_27, t22.is_immutable AS is_immutable_28, t22.id AS id_29, t22.product_name AS product_name_30, t22.variant_name AS variant_name_31, t22.issued_at AS issued_at_32, t22.refunded_at AS refunded_at_33, t22.order_id AS order_id_34, t22.variant_id AS variant_id_35, t22.vignette_id AS vignette_id_36, t22.rca_id AS rca_id_37, t22.hu_vignette_id AS hu_vignette_id_38, t22.sms_id AS sms_id_39, t22.road_assistance_id AS road_assistance_id_40, t22.death_insurance_id AS death_insurance_id_41, t22.license_recovery_id AS license_recovery_id_42, t22.telemedicine_id AS telemedicine_id_43, t0.customer_id AS customer_id_44 FROM telemedicine t0 LEFT JOIN tele_doc_code t14 ON t14.telemedicine_id = t0.id LEFT JOIN sylius_order_item t22 ON t22.telemedicine_id = t0.id WHERE t0.order_id = ?
Parameters:
[
  135000
]
24 0.32 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_13, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_14, t0.account_verification_required AS account_verification_required_15, t0.default_locale_id AS default_locale_id_16, t17.code AS code_18, t17.created_at AS created_at_19, t17.updated_at AS updated_at_20, t17.id AS id_21, t0.base_currency_id AS base_currency_id_22, t23.code AS code_24, t23.created_at AS created_at_25, t23.updated_at AS updated_at_26, t23.id AS id_27, t0.default_tax_zone_id AS default_tax_zone_id_28, t0.shop_billing_data_id AS shop_billing_data_id_29 FROM sylius_channel t0 INNER JOIN sylius_locale t17 ON t0.default_locale_id = t17.id INNER JOIN sylius_currency t23 ON t0.base_currency_id = t23.id
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\Template\Template No errors.
BitBag\SyliusCmsPlugin\Entity\Block No errors.
BitBag\SyliusCmsPlugin\Entity\Media No errors.
BitBag\SyliusCmsPlugin\Entity\Page No errors.
Sylius\Component\Order\Model\Order No errors.
Sylius\Component\Core\Model\Order No errors.
App\Entity\Order\Order No errors.
Sylius\Component\Channel\Model\Channel No errors.
Sylius\Component\Core\Model\Channel No errors.
App\Entity\Channel\Channel No errors.
Sylius\Component\Locale\Model\Locale No errors.
App\Entity\Locale\Locale No errors.
Sylius\Component\Currency\Model\Currency No errors.
App\Entity\Currency\Currency No errors.
Sylius\Component\Addressing\Model\Zone No errors.
App\Entity\Addressing\Zone No errors.
Sylius\Component\Core\Model\ShopBillingData No errors.
App\Entity\VignetteMaintenance\VignetteMaintenance No errors.
App\Entity\System\ProductStatus No errors.
Sylius\Component\User\Model\User No errors.
Sylius\Component\Core\Model\AdminUser No errors.
App\Entity\User\AdminUser No errors.
App\Entity\System\TemplateStatus No errors.
App\Entity\System\CampaignStatus No errors.
App\Entity\Partner\Partner No errors.
App\Entity\Partner\Role No errors.
Sylius\Component\Addressing\Model\Address No errors.
Sylius\Component\Core\Model\Address No errors.
App\Entity\Addressing\Address No errors.
App\Entity\Log\LogPartnerResetLimit No errors.
App\Entity\Partner\PartnerComission No errors.
Sylius\Component\Promotion\Model\PromotionCoupon No errors.
Sylius\Component\Core\Model\PromotionCoupon No errors.
App\Entity\Promotion\PromotionCoupon No errors.
Sylius\Component\Customer\Model\Customer No errors.
Sylius\Component\Core\Model\Customer No errors.
App\Entity\Customer\Customer No errors.
App\Entity\VignettePaymentMethod\VignettePaymentMethod No errors.
App\Entity\LogOpPaymentVignettes No errors.
App\Entity\Partner\OrderPartnerComission No errors.
App\Entity\Order\OrderExtraData No errors.
App\Entity\Vignette\Vignette No errors.
App\Entity\VignetteInvoice\VignetteInvoice No errors.
App\Entity\RCA\RCA No errors.
App\Entity\Invoice\ProformaInvoice No errors.
App\Entity\HuVignette\HuVignette No errors.
App\Entity\RoadAssistance\RoadAssistance No errors.
App\Entity\DeathInsurance\DeathInsurance No errors.
App\Entity\Telemedicine\Telemedicine No errors.
App\Entity\LicenseRecovery\LicenseRecovery No errors.
App\Entity\Vignette\LogOpVignetteOrder No errors.
App\Entity\Reports\ReportOrderProduct No errors.
Sylius\Component\Payment\Model\Payment No errors.
Sylius\Component\Core\Model\Payment No errors.
App\Entity\Payment\Payment No errors.
Sylius\Component\Shipping\Model\Shipment No errors.
Sylius\Component\Core\Model\Shipment No errors.
App\Entity\Shipping\Shipment No errors.
Sylius\Component\Promotion\Model\Promotion No errors.
Sylius\Component\Core\Model\Promotion No errors.
App\Entity\Promotion\Promotion No errors.
Sylius\Component\Order\Model\OrderItem No errors.
Sylius\Component\Core\Model\OrderItem No errors.
App\Entity\Order\OrderItem No errors.
Sylius\Component\Order\Model\Adjustment No errors.
App\Entity\Order\Adjustment No errors.
App\Entity\Vignette\Category No errors.
App\Entity\Vignette\Availability No errors.
Sylius\Component\Addressing\Model\Country No errors.
App\Entity\Addressing\Country No errors.
App\Entity\Vignette\VignetteApi No errors.
App\Entity\SMS\SMS No errors.
Sylius\Component\Product\Model\ProductVariant No errors.
Sylius\Component\Core\Model\ProductVariant No errors.
App\Entity\Product\ProductVariant No errors.
App\Entity\VignetteApiInit No errors.
App\Entity\Vignette\Alert
  • If association App\Entity\Vignette\Alert#vignette is many-to-one, then the inversed side App\Entity\Vignette\Vignette#alert has to be one-to-many.
  • The association App\Entity\Vignette\Alert#customerVehicle refers to the inverse side field App\Entity\Customer\Vehicle#alert which does not exist.
App\Entity\Customer\Vehicle No errors.
App\Entity\Vignette\CnairAlert No errors.
App\Entity\Vignette\FailedVignette No errors.
App\Entity\Vignette\LogOpVignetteEdit No errors.
App\Entity\Reports\ReportProduct No errors.
Sylius\Component\Order\Model\OrderItemUnit No errors.
Sylius\Component\Core\Model\OrderItemUnit No errors.
App\Entity\Order\OrderItemUnit No errors.
App\Entity\Vignette\Price No errors.
App\Entity\HuVignette\Category No errors.
App\Entity\HuVignette\Availability No errors.
App\Entity\HuVignette\HuVignetteApi No errors.
App\Entity\HuVignette\Alert No errors.
App\Entity\HuVignette\FailedHuVignette No errors.
App\Entity\RCA\InsuranceCompany No errors.
App\Entity\RCA\Car No errors.
App\Entity\RCA\Alert No errors.
App\Entity\RCA\Availability No errors.
App\Entity\RCA\FailedRca No errors.
App\Entity\RoadAssistance\Category No errors.
App\Entity\RoadAssistance\Availability No errors.
App\Entity\RoadAssistance\RoadAssistanceApi No errors.
App\Entity\RoadAssistance\FailedRoadAssistance No errors.
App\Entity\Telemedicine\TeleDoc No errors.