Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'nl' AND e0_.object_class = 'App\\Entity\\Domain';

SELECT
  t0.id AS id_1,
  t0.shipping_status AS shipping_status_2,
  t0.payment_status AS payment_status_3,
  t0.total_price AS total_price_4,
  t0.sale_supply_id AS sale_supply_id_5,
  t0.sale_supply_main_status AS sale_supply_main_status_6,
  t0.sale_supply_shipment_status AS sale_supply_shipment_status_7,
  t0.sale_supply_tracking_code AS sale_supply_tracking_code_8,
  t0.sale_supply_carrier_name AS sale_supply_carrier_name_9,
  t0.terms_and_conditions AS terms_and_conditions_10,
  t0.payment_id AS payment_id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.status AS status_14,
  t0.payment_method AS payment_method_15,
  t0.user_snapshot AS user_snapshot_16,
  t0.paid_at AS paid_at_17,
  t0.shipping_cost AS shipping_cost_18,
  t0.amount_vat AS amount_vat_19,
  t0.currency AS currency_20,
  t0.charge_psp AS charge_psp_21,
  t0.charge_shipping AS charge_shipping_22,
  t0.tracking_params AS tracking_params_23,
  t0.postback_url_date AS postback_url_date_24,
  t0.tracking_commission AS tracking_commission_25,
  t0.total_price_ex AS total_price_ex_26,
  t0.comment AS comment_27,
  t0.order_number AS order_number_28,
  t0.count_by_user AS count_by_user_29,
  t0.charge_pick_and_pack AS charge_pick_and_pack_30,
  t0.sale_supply_tracking_url AS sale_supply_tracking_url_31,
  t0.event_id AS event_id_32,
  t0.event_additional_params AS event_additional_params_33,
  t0.total_price_to_eur AS total_price_to_eur_34,
  t0.total_price_ex_to_eur AS total_price_ex_to_eur_35,
  t0.shipping_cost_to_eur AS shipping_cost_to_eur_36,
  t0.type AS type_37,
  t0.product_cost AS product_cost_38,
  t0.product_cost_to_eur AS product_cost_to_eur_39,
  t0.return_cost AS return_cost_40,
  t0.return_cost_to_eur AS return_cost_to_eur_41,
  t0.is_voucher AS is_voucher_42,
  t0.is_first_order AS is_first_order_43,
  t0.ip AS ip_44,
  t0.payment_provider_id AS payment_provider_id_45,
  t0.shipping_provider_id AS shipping_provider_id_46,
  t0.end_user_id AS end_user_id_47,
  t48.id AS id_49,
  t48.first_name AS first_name_50,
  t48.last_name AS last_name_51,
  t48.email AS email_52,
  t48.address AS address_53,
  t48.apartment AS apartment_54,
  t48.zip AS zip_55,
  t48.city AS city_56,
  t48.active AS active_57,
  t48.locale AS locale_58,
  t48.subscribed AS subscribed_59,
  t48.phone_number AS phone_number_60,
  t48.otp_token AS otp_token_61,
  t48.remember_token AS remember_token_62,
  t48.updated_at AS updated_at_63,
  t48.otp_expired_at AS otp_expired_at_64,
  t48.mollie_customer_id AS mollie_customer_id_65,
  t48.klarna_token_id AS klarna_token_id_66,
  t48.street_name AS street_name_67,
  t48.house_number AS house_number_68,
  t48.country_id AS country_id_69,
  t0.domain_id AS domain_id_70,
  t0.domain_vat_id AS domain_vat_id_71,
  t0.country_id AS country_id_72,
  t0.tracker_id AS tracker_id_73,
  t74.id AS id_75,
  t74.name AS name_76,
  t74.email_address AS email_address_77,
  t74.postback_url AS postback_url_78,
  t74.get_variables AS get_variables_79,
  t74.post_variables AS post_variables_80,
  t74.event_providers AS event_providers_81,
  t74.facebook_test_event_code AS facebook_test_event_code_82,
  t74.facebook_pixel_id AS facebook_pixel_id_83,
  t74.facebook_access_token AS facebook_access_token_84,
  t74.facebook_dedicated_pixel AS facebook_dedicated_pixel_85,
  t74.thank_you_page_custom_code AS thank_you_page_custom_code_86,
  t74.use_margin AS use_margin_87,
  t74.domain_id AS domain_id_88,
  t0.parent_id AS parent_id_89,
  t90.id AS id_91,
  t90.status AS status_92,
  t90.frequency AS frequency_93,
  t90.period AS period_94,
  t90.total_price AS total_price_95,
  t90.shipping_cost AS shipping_cost_96,
  t90.currency AS currency_97,
  t90.created_at AS created_at_98,
  t90.updated_at AS updated_at_99,
  t90.external_subscription_id AS external_subscription_id_100,
  t90.rebill_owner AS rebill_owner_101,
  t90.last_charge_at AS last_charge_at_102,
  t90.next_charge_at AS next_charge_at_103,
  t90.deactivation_at AS deactivation_at_104,
  t90.trial_period AS trial_period_105,
  t90.is_internal_charge AS is_internal_charge_106,
  t90.order_id AS order_id_107,
  t90.end_user_id AS end_user_id_108,
  t109.id AS id_110,
  t109.created_at AS created_at_111,
  t109.sent AS sent_112,
  t109.sent_at AS sent_at_113,
  t109.submission_date AS submission_date_114,
  t109.canceled AS canceled_115,
  t109.order_id AS order_id_116,
  t0.first_product_id AS first_product_id_117,
  t0.warehouse_id AS warehouse_id_118,
  t119.id AS id_120,
  t119.external_id AS external_id_121,
  t119.status AS status_122,
  t119.shipment_status AS shipment_status_123,
  t119.carrier_name AS carrier_name_124,
  t119.tracking_code AS tracking_code_125,
  t119.tracking_url AS tracking_url_126,
  t119.created_at AS created_at_127,
  t119.updated_at AS updated_at_128,
  t119.order_id AS order_id_129,
  t130.id AS id_131,
  t130.shipping_cost AS shipping_cost_132,
  t130.charge_psp AS charge_psp_133,
  t130.charge_shipping AS charge_shipping_134,
  t130.charge_pick_and_pack AS charge_pick_and_pack_135,
  t130.shipping_cost_to_eur AS shipping_cost_to_eur_136,
  t130.product_cost AS product_cost_137,
  t130.product_cost_to_eur AS product_cost_to_eur_138,
  t130.return_cost AS return_cost_139,
  t130.return_cost_to_eur AS return_cost_to_eur_140,
  t130.order_id AS order_id_141,
  t0.funnel_id AS funnel_id_142,
  t143.id AS id_144,
  t143.name AS name_145,
  t143.created_at AS created_at_146,
  t143.checkout_btn_selector AS checkout_btn_selector_147,
  t143.user_id AS user_id_148,
  t143.tracker_id AS tracker_id_149,
  t143.domain_id AS domain_id_150
FROM
  orders t0
  LEFT JOIN end_user t48 ON t0.end_user_id = t48.id
  LEFT JOIN tracker t74 ON t0.tracker_id = t74.id
  LEFT JOIN order_subscription t90 ON t90.order_id = t0.id
  LEFT JOIN order_holder t109 ON t109.order_id = t0.id
  LEFT JOIN order_warehouse_detail t119 ON t119.order_id = t0.id
  LEFT JOIN order_calculated_data t130 ON t130.order_id = t0.id
  LEFT JOIN funnel t143 ON t0.funnel_id = t143.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.shipping_status AS shipping_status_2, t0.payment_status AS payment_status_3, t0.total_price AS total_price_4, t0.sale_supply_id AS sale_supply_id_5, t0.sale_supply_main_status AS sale_supply_main_status_6, t0.sale_supply_shipment_status AS sale_supply_shipment_status_7, t0.sale_supply_tracking_code AS sale_supply_tracking_code_8, t0.sale_supply_carrier_name AS sale_supply_carrier_name_9, t0.terms_and_conditions AS terms_and_conditions_10, t0.payment_id AS payment_id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.status AS status_14, t0.payment_method AS payment_method_15, t0.user_snapshot AS user_snapshot_16, t0.paid_at AS paid_at_17, t0.shipping_cost AS shipping_cost_18, t0.amount_vat AS amount_vat_19, t0.currency AS currency_20, t0.charge_psp AS charge_psp_21, t0.charge_shipping AS charge_shipping_22, t0.tracking_params AS tracking_params_23, t0.postback_url_date AS postback_url_date_24, t0.tracking_commission AS tracking_commission_25, t0.total_price_ex AS total_price_ex_26, t0.comment AS comment_27, t0.order_number AS order_number_28, t0.count_by_user AS count_by_user_29, t0.charge_pick_and_pack AS charge_pick_and_pack_30, t0.sale_supply_tracking_url AS sale_supply_tracking_url_31, t0.event_id AS event_id_32, t0.event_additional_params AS event_additional_params_33, t0.total_price_to_eur AS total_price_to_eur_34, t0.total_price_ex_to_eur AS total_price_ex_to_eur_35, t0.shipping_cost_to_eur AS shipping_cost_to_eur_36, t0.type AS type_37, t0.product_cost AS product_cost_38, t0.product_cost_to_eur AS product_cost_to_eur_39, t0.return_cost AS return_cost_40, t0.return_cost_to_eur AS return_cost_to_eur_41, t0.is_voucher AS is_voucher_42, t0.is_first_order AS is_first_order_43, t0.ip AS ip_44, t0.payment_provider_id AS payment_provider_id_45, t0.shipping_provider_id AS shipping_provider_id_46, t0.end_user_id AS end_user_id_47, t48.id AS id_49, t48.first_name AS first_name_50, t48.last_name AS last_name_51, t48.email AS email_52, t48.address AS address_53, t48.apartment AS apartment_54, t48.zip AS zip_55, t48.city AS city_56, t48.active AS active_57, t48.locale AS locale_58, t48.subscribed AS subscribed_59, t48.phone_number AS phone_number_60, t48.otp_token AS otp_token_61, t48.remember_token AS remember_token_62, t48.updated_at AS updated_at_63, t48.otp_expired_at AS otp_expired_at_64, t48.mollie_customer_id AS mollie_customer_id_65, t48.klarna_token_id AS klarna_token_id_66, t48.street_name AS street_name_67, t48.house_number AS house_number_68, t48.country_id AS country_id_69, t0.domain_id AS domain_id_70, t0.domain_vat_id AS domain_vat_id_71, t0.country_id AS country_id_72, t0.tracker_id AS tracker_id_73, t74.id AS id_75, t74.name AS name_76, t74.email_address AS email_address_77, t74.postback_url AS postback_url_78, t74.get_variables AS get_variables_79, t74.post_variables AS post_variables_80, t74.event_providers AS event_providers_81, t74.facebook_test_event_code AS facebook_test_event_code_82, t74.facebook_pixel_id AS facebook_pixel_id_83, t74.facebook_access_token AS facebook_access_token_84, t74.facebook_dedicated_pixel AS facebook_dedicated_pixel_85, t74.thank_you_page_custom_code AS thank_you_page_custom_code_86, t74.use_margin AS use_margin_87, t74.domain_id AS domain_id_88, t0.parent_id AS parent_id_89, t90.id AS id_91, t90.status AS status_92, t90.frequency AS frequency_93, t90.period AS period_94, t90.total_price AS total_price_95, t90.shipping_cost AS shipping_cost_96, t90.currency AS currency_97, t90.created_at AS created_at_98, t90.updated_at AS updated_at_99, t90.external_subscription_id AS external_subscription_id_100, t90.rebill_owner AS rebill_owner_101, t90.last_charge_at AS last_charge_at_102, t90.next_charge_at AS next_charge_at_103, t90.deactivation_at AS deactivation_at_104, t90.trial_period AS trial_period_105, t90.is_internal_charge AS is_internal_charge_106, t90.order_id AS order_id_107, t90.end_user_id AS end_user_id_108, t109.id AS id_110, t109.created_at AS created_at_111, t109.sent AS sent_112, t109.sent_at AS sent_at_113, t109.submission_date AS submission_date_114, t109.canceled AS canceled_115, t109.order_id AS order_id_116, t0.first_product_id AS first_product_id_117, t0.warehouse_id AS warehouse_id_118, t119.id AS id_120, t119.external_id AS external_id_121, t119.status AS status_122, t119.shipment_status AS shipment_status_123, t119.carrier_name AS carrier_name_124, t119.tracking_code AS tracking_code_125, t119.tracking_url AS tracking_url_126, t119.created_at AS created_at_127, t119.updated_at AS updated_at_128, t119.order_id AS order_id_129, t130.id AS id_131, t130.shipping_cost AS shipping_cost_132, t130.charge_psp AS charge_psp_133, t130.charge_shipping AS charge_shipping_134, t130.charge_pick_and_pack AS charge_pick_and_pack_135, t130.shipping_cost_to_eur AS shipping_cost_to_eur_136, t130.product_cost AS product_cost_137, t130.product_cost_to_eur AS product_cost_to_eur_138, t130.return_cost AS return_cost_139, t130.return_cost_to_eur AS return_cost_to_eur_140, t130.order_id AS order_id_141, t0.funnel_id AS funnel_id_142, t143.id AS id_144, t143.name AS name_145, t143.created_at AS created_at_146, t143.checkout_btn_selector AS checkout_btn_selector_147, t143.user_id AS user_id_148, t143.tracker_id AS tracker_id_149, t143.domain_id AS domain_id_150 FROM orders t0 LEFT JOIN end_user t48 ON t0.end_user_id = t48.id LEFT JOIN tracker t74 ON t0.tracker_id = t74.id LEFT JOIN order_subscription t90 ON t90.order_id = t0.id LEFT JOIN order_holder t109 ON t109.order_id = t0.id LEFT JOIN order_warehouse_detail t119 ON t119.order_id = t0.id LEFT JOIN order_calculated_data t130 ON t130.order_id = t0.id LEFT JOIN funnel t143 ON t0.funnel_id = t143.id WHERE t0.id = '9697';

SELECT
  t0.id AS id_1,
  t0.template_type AS template_type_2,
  t0.primary_color AS primary_color_3,
  t0.secondary_color AS secondary_color_4,
  t0.primary_bg_color AS primary_bg_color_5,
  t0.browser_tab_color AS browser_tab_color_6,
  t0.is_single_page AS is_single_page_7,
  t0.product_id AS product_id_8
FROM
  checkout_configuration t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.template_type AS template_type_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.primary_bg_color AS primary_bg_color_5, t0.browser_tab_color AS browser_tab_color_6, t0.is_single_page AS is_single_page_7, t0.product_id AS product_id_8 FROM checkout_configuration t0 WHERE t0.product_id = 1;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.brand AS brand_5,
  t0.ean_code AS ean_code_6,
  t0.sku AS sku_7,
  t0.hs_code AS hs_code_8,
  t0.product_cost AS product_cost_9,
  t0.return_rate AS return_rate_10,
  t0.recommend_retail_price AS recommend_retail_price_11,
  t0.weight AS weight_12,
  t0.out_of_stock AS out_of_stock_13,
  t0.voucher AS voucher_14,
  t0.expected_date AS expected_date_15,
  t0.type_id AS type_id_16,
  t0.customer_id AS customer_id_17
FROM
  product_detail t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.title AS title_3, t0.description AS description_4, t0.brand AS brand_5, t0.ean_code AS ean_code_6, t0.sku AS sku_7, t0.hs_code AS hs_code_8, t0.product_cost AS product_cost_9, t0.return_rate AS return_rate_10, t0.recommend_retail_price AS recommend_retail_price_11, t0.weight AS weight_12, t0.out_of_stock AS out_of_stock_13, t0.voucher AS voucher_14, t0.expected_date AS expected_date_15, t0.type_id AS type_id_16, t0.customer_id AS customer_id_17 FROM product_detail t0 WHERE t0.id IN (92);

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.total_price AS total_price_4,
  t0.product_cost AS product_cost_5,
  t0.return_cost AS return_cost_6,
  t0.total_price_to_eur AS total_price_to_eur_7,
  t0.product_cost_to_eur AS product_cost_to_eur_8,
  t0.return_cost_to_eur AS return_cost_to_eur_9,
  t0.product_id AS product_id_10,
  t11.id AS id_12,
  t11.name AS name_13,
  t11.cms_title AS cms_title_14,
  t11.title AS title_15,
  t11.meta_title AS meta_title_16,
  t11.meta_description AS meta_description_17,
  t11.usp_info AS usp_info_18,
  t11.usp_days_to_return AS usp_days_to_return_19,
  t11.usp_shipping AS usp_shipping_20,
  t11.ean_code AS ean_code_21,
  t11.sku AS sku_22,
  t11.in_stock AS in_stock_23,
  t11.weight AS weight_24,
  t11.product_cost AS product_cost_25,
  t11.url_title AS url_title_26,
  t11.hs_code AS hs_code_27,
  t11.return_rate AS return_rate_28,
  t11.default_currency AS default_currency_29,
  t11.recommend_retail_price AS recommend_retail_price_30,
  t11.active_languages AS active_languages_31,
  t11.active AS active_32,
  t11.main_product AS main_product_33,
  t11.thanks_page AS thanks_page_34,
  t11.description AS description_35,
  t11.shipping_cost AS shipping_cost_36,
  t11.min_free_shipping_value AS min_free_shipping_value_37,
  t11.error_page AS error_page_38,
  t11.conversion_realtime AS conversion_realtime_39,
  t11.recently_purchased_popup AS recently_purchased_popup_40,
  t11.reserved_time AS reserved_time_41,
  t11.number_bought_product AS number_bought_product_42,
  t11.number_customers_online AS number_customers_online_43,
  t11.max_quantity AS max_quantity_44,
  t11.subscription_mandate AS subscription_mandate_45,
  t11.auto_cart_add AS auto_cart_add_46,
  t11.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_47,
  t11.free_shipping_progress_bar AS free_shipping_progress_bar_48,
  t11.push_to_higher_variant AS push_to_higher_variant_49,
  t11.active_upsell_checkout_page AS active_upsell_checkout_page_50,
  t11.upsell_page_discount_percentage AS upsell_page_discount_percentage_51,
  t11.upsell_page_progress_timer AS upsell_page_progress_timer_52,
  t11.upsell_page_description AS upsell_page_description_53,
  t11.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_54,
  t11.product_type_id AS product_type_id_55,
  t11.product_detail_id AS product_detail_id_56,
  t11.warehouse_id AS warehouse_id_57,
  t0.product_variant_id AS product_variant_id_58,
  t59.id AS id_60,
  t59.name AS name_61,
  t59.quantity AS quantity_62,
  t59.discount AS discount_63,
  t59.unit_price AS unit_price_64,
  t59.total_price AS total_price_65,
  t59.label AS label_66,
  t59.active AS active_67,
  t59.preselected AS preselected_68,
  t59.position AS position_69,
  t59.subscription AS subscription_70,
  t59.subscription_description AS subscription_description_71,
  t59.subscription_discount AS subscription_discount_72,
  t59.subscription_sku AS subscription_sku_73,
  t59.subscription_price AS subscription_price_74,
  t59.subscription_trial_period AS subscription_trial_period_75,
  t59.subscription_preselected AS subscription_preselected_76,
  t59.image_path AS image_path_77,
  t59.out_of_stock AS out_of_stock_78,
  t59.product_id AS product_id_79,
  t0.order_id AS order_id_80,
  t81.id AS id_82,
  t81.product_cost AS product_cost_83,
  t81.return_cost AS return_cost_84,
  t81.product_cost_to_eur AS product_cost_to_eur_85,
  t81.return_cost_to_eur AS return_cost_to_eur_86,
  t81.order_product_id AS order_product_id_87
FROM
  order_product t0
  INNER JOIN product t11 ON t0.product_id = t11.id
  LEFT JOIN product_variant t59 ON t0.product_variant_id = t59.id
  LEFT JOIN order_product_calculated_data t81 ON t81.order_product_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.total_price AS total_price_4, t0.product_cost AS product_cost_5, t0.return_cost AS return_cost_6, t0.total_price_to_eur AS total_price_to_eur_7, t0.product_cost_to_eur AS product_cost_to_eur_8, t0.return_cost_to_eur AS return_cost_to_eur_9, t0.product_id AS product_id_10, t11.id AS id_12, t11.name AS name_13, t11.cms_title AS cms_title_14, t11.title AS title_15, t11.meta_title AS meta_title_16, t11.meta_description AS meta_description_17, t11.usp_info AS usp_info_18, t11.usp_days_to_return AS usp_days_to_return_19, t11.usp_shipping AS usp_shipping_20, t11.ean_code AS ean_code_21, t11.sku AS sku_22, t11.in_stock AS in_stock_23, t11.weight AS weight_24, t11.product_cost AS product_cost_25, t11.url_title AS url_title_26, t11.hs_code AS hs_code_27, t11.return_rate AS return_rate_28, t11.default_currency AS default_currency_29, t11.recommend_retail_price AS recommend_retail_price_30, t11.active_languages AS active_languages_31, t11.active AS active_32, t11.main_product AS main_product_33, t11.thanks_page AS thanks_page_34, t11.description AS description_35, t11.shipping_cost AS shipping_cost_36, t11.min_free_shipping_value AS min_free_shipping_value_37, t11.error_page AS error_page_38, t11.conversion_realtime AS conversion_realtime_39, t11.recently_purchased_popup AS recently_purchased_popup_40, t11.reserved_time AS reserved_time_41, t11.number_bought_product AS number_bought_product_42, t11.number_customers_online AS number_customers_online_43, t11.max_quantity AS max_quantity_44, t11.subscription_mandate AS subscription_mandate_45, t11.auto_cart_add AS auto_cart_add_46, t11.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_47, t11.free_shipping_progress_bar AS free_shipping_progress_bar_48, t11.push_to_higher_variant AS push_to_higher_variant_49, t11.active_upsell_checkout_page AS active_upsell_checkout_page_50, t11.upsell_page_discount_percentage AS upsell_page_discount_percentage_51, t11.upsell_page_progress_timer AS upsell_page_progress_timer_52, t11.upsell_page_description AS upsell_page_description_53, t11.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_54, t11.product_type_id AS product_type_id_55, t11.product_detail_id AS product_detail_id_56, t11.warehouse_id AS warehouse_id_57, t0.product_variant_id AS product_variant_id_58, t59.id AS id_60, t59.name AS name_61, t59.quantity AS quantity_62, t59.discount AS discount_63, t59.unit_price AS unit_price_64, t59.total_price AS total_price_65, t59.label AS label_66, t59.active AS active_67, t59.preselected AS preselected_68, t59.position AS position_69, t59.subscription AS subscription_70, t59.subscription_description AS subscription_description_71, t59.subscription_discount AS subscription_discount_72, t59.subscription_sku AS subscription_sku_73, t59.subscription_price AS subscription_price_74, t59.subscription_trial_period AS subscription_trial_period_75, t59.subscription_preselected AS subscription_preselected_76, t59.image_path AS image_path_77, t59.out_of_stock AS out_of_stock_78, t59.product_id AS product_id_79, t0.order_id AS order_id_80, t81.id AS id_82, t81.product_cost AS product_cost_83, t81.return_cost AS return_cost_84, t81.product_cost_to_eur AS product_cost_to_eur_85, t81.return_cost_to_eur AS return_cost_to_eur_86, t81.order_product_id AS order_product_id_87 FROM order_product t0 INNER JOIN product t11 ON t0.product_id = t11.id LEFT JOIN product_variant t59 ON t0.product_variant_id = t59.id LEFT JOIN order_product_calculated_data t81 ON t81.order_product_id = t0.id WHERE t0.order_id = 9697;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.currency_code AS currency_code_3,
  t0.languages AS languages_4,
  t0.active AS active_5,
  t0.currency_position AS currency_position_6,
  t0.country_code AS country_code_7,
  t0.currency_id AS currency_id_8,
  t0.warehouse_id AS warehouse_id_9
FROM
  country t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.languages AS languages_4, t0.active AS active_5, t0.currency_position AS currency_position_6, t0.country_code AS country_code_7, t0.currency_id AS currency_id_8, t0.warehouse_id AS warehouse_id_9 FROM country t0 WHERE t0.id IN (11);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.homepage AS homepage_4,
  t0.logo AS logo_5,
  t0.favicon AS favicon_6,
  t0.company_name AS company_name_7,
  t0.address AS address_8,
  t0.zip_code AS zip_code_9,
  t0.city AS city_10,
  t0.phone AS phone_11,
  t0.registration_nr AS registration_nr_12,
  t0.email AS email_13,
  t0.seo_title AS seo_title_14,
  t0.seo_description AS seo_description_15,
  t0.terms_and_conditions_page AS terms_and_conditions_page_16,
  t0.privacy_policy_page AS privacy_policy_page_17,
  t0.active AS active_18,
  t0.instagram_url AS instagram_url_19,
  t0.facebook_url AS facebook_url_20,
  t0.facebook_pixel_id AS facebook_pixel_id_21,
  t0.facebook_access_token AS facebook_access_token_22,
  t0.test_event_code AS test_event_code_23,
  t0.sale_supply_shop_id AS sale_supply_shop_id_24,
  t0.changed_url AS changed_url_25,
  t0.changed_translation AS changed_translation_26,
  t0.google_tag_manager_code AS google_tag_manager_code_27,
  t0.klaviyo_api_key AS klaviyo_api_key_28,
  t0.klaviyo_list_id AS klaviyo_list_id_29,
  t0.google_api_secret AS google_api_secret_30,
  t0.google_tag_code AS google_tag_code_31,
  t0.default_event_providers AS default_event_providers_32,
  t0.customer_id AS customer_id_33,
  t0.active_email_provider_id AS active_email_provider_id_34,
  t35.id AS id_36,
  t35.account_id AS account_id_37,
  t35.conversion_token AS conversion_token_38,
  t35.pinterest_tag AS pinterest_tag_39,
  t35.domain_id AS domain_id_40,
  t41.id AS id_42,
  t41.pixel_code AS pixel_code_43,
  t41.access_token AS access_token_44,
  t41.test_event_code AS test_event_code_45,
  t41.domain_id AS domain_id_46,
  t0.country_id AS country_id_47
FROM
  domain t0
  LEFT JOIN pinterest_event_provider t35 ON t35.domain_id = t0.id
  LEFT JOIN tik_tok_event_provider t41 ON t41.domain_id = t0.id
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.homepage AS homepage_4, t0.logo AS logo_5, t0.favicon AS favicon_6, t0.company_name AS company_name_7, t0.address AS address_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.phone AS phone_11, t0.registration_nr AS registration_nr_12, t0.email AS email_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.terms_and_conditions_page AS terms_and_conditions_page_16, t0.privacy_policy_page AS privacy_policy_page_17, t0.active AS active_18, t0.instagram_url AS instagram_url_19, t0.facebook_url AS facebook_url_20, t0.facebook_pixel_id AS facebook_pixel_id_21, t0.facebook_access_token AS facebook_access_token_22, t0.test_event_code AS test_event_code_23, t0.sale_supply_shop_id AS sale_supply_shop_id_24, t0.changed_url AS changed_url_25, t0.changed_translation AS changed_translation_26, t0.google_tag_manager_code AS google_tag_manager_code_27, t0.klaviyo_api_key AS klaviyo_api_key_28, t0.klaviyo_list_id AS klaviyo_list_id_29, t0.google_api_secret AS google_api_secret_30, t0.google_tag_code AS google_tag_code_31, t0.default_event_providers AS default_event_providers_32, t0.customer_id AS customer_id_33, t0.active_email_provider_id AS active_email_provider_id_34, t35.id AS id_36, t35.account_id AS account_id_37, t35.conversion_token AS conversion_token_38, t35.pinterest_tag AS pinterest_tag_39, t35.domain_id AS domain_id_40, t41.id AS id_42, t41.pixel_code AS pixel_code_43, t41.access_token AS access_token_44, t41.test_event_code AS test_event_code_45, t41.domain_id AS domain_id_46, t0.country_id AS country_id_47 FROM domain t0 LEFT JOIN pinterest_event_provider t35 ON t35.domain_id = t0.id LEFT JOIN tik_tok_event_provider t41 ON t41.domain_id = t0.id WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.currency AS currency_2,
  t0.amount AS amount_3,
  t0.is_activated AS is_activated_4,
  t0.activated_at AS activated_at_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.end_user_id AS end_user_id_8,
  t0.order_id AS order_id_9
FROM
  end_user_vouchers t0
WHERE
  t0.order_id IN (?)

SELECT t0.id AS id_1, t0.currency AS currency_2, t0.amount AS amount_3, t0.is_activated AS is_activated_4, t0.activated_at AS activated_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.end_user_id AS end_user_id_8, t0.order_id AS order_id_9 FROM end_user_vouchers t0 WHERE t0.order_id IN (9697);