Symfony Profiler

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.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.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);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.cms_title AS cms_title_2,
  p0_.title AS title_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.usp_info AS usp_info_6,
  p0_.usp_days_to_return AS usp_days_to_return_7,
  p0_.usp_shipping AS usp_shipping_8,
  p0_.ean_code AS ean_code_9,
  p0_.sku AS sku_10,
  p0_.in_stock AS in_stock_11,
  p0_.weight AS weight_12,
  p0_.product_cost AS product_cost_13,
  p0_.url_title AS url_title_14,
  p0_.hs_code AS hs_code_15,
  p0_.return_rate AS return_rate_16,
  p0_.default_currency AS default_currency_17,
  p0_.recommend_retail_price AS recommend_retail_price_18,
  p0_.active_languages AS active_languages_19,
  p0_.active AS active_20,
  p0_.main_product AS main_product_21,
  p0_.thanks_page AS thanks_page_22,
  p0_.description AS description_23,
  p0_.shipping_cost AS shipping_cost_24,
  p0_.min_free_shipping_value AS min_free_shipping_value_25,
  p0_.error_page AS error_page_26,
  p0_.conversion_realtime AS conversion_realtime_27,
  p0_.recently_purchased_popup AS recently_purchased_popup_28,
  p0_.reserved_time AS reserved_time_29,
  p0_.number_bought_product AS number_bought_product_30,
  p0_.number_customers_online AS number_customers_online_31,
  p0_.max_quantity AS max_quantity_32,
  p0_.subscription_mandate AS subscription_mandate_33,
  p0_.auto_cart_add AS auto_cart_add_34,
  p0_.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_35,
  p0_.free_shipping_progress_bar AS free_shipping_progress_bar_36,
  p0_.push_to_higher_variant AS push_to_higher_variant_37,
  p0_.active_upsell_checkout_page AS active_upsell_checkout_page_38,
  p0_.upsell_page_discount_percentage AS upsell_page_discount_percentage_39,
  p0_.upsell_page_progress_timer AS upsell_page_progress_timer_40,
  p0_.upsell_page_description AS upsell_page_description_41,
  p0_.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_42,
  d1_.id AS id_43,
  d1_.name AS name_44,
  d1_.url AS url_45,
  d1_.homepage AS homepage_46,
  d1_.logo AS logo_47,
  d1_.favicon AS favicon_48,
  d1_.company_name AS company_name_49,
  d1_.address AS address_50,
  d1_.zip_code AS zip_code_51,
  d1_.city AS city_52,
  d1_.phone AS phone_53,
  d1_.registration_nr AS registration_nr_54,
  d1_.email AS email_55,
  d1_.seo_title AS seo_title_56,
  d1_.seo_description AS seo_description_57,
  d1_.terms_and_conditions_page AS terms_and_conditions_page_58,
  d1_.privacy_policy_page AS privacy_policy_page_59,
  d1_.active AS active_60,
  d1_.instagram_url AS instagram_url_61,
  d1_.facebook_url AS facebook_url_62,
  d1_.facebook_pixel_id AS facebook_pixel_id_63,
  d1_.facebook_access_token AS facebook_access_token_64,
  d1_.test_event_code AS test_event_code_65,
  d1_.sale_supply_shop_id AS sale_supply_shop_id_66,
  d1_.changed_url AS changed_url_67,
  d1_.changed_translation AS changed_translation_68,
  d1_.google_tag_manager_code AS google_tag_manager_code_69,
  d1_.klaviyo_api_key AS klaviyo_api_key_70,
  d1_.klaviyo_list_id AS klaviyo_list_id_71,
  d1_.google_api_secret AS google_api_secret_72,
  d1_.google_tag_code AS google_tag_code_73,
  d1_.default_event_providers AS default_event_providers_74,
  p2_.id AS id_75,
  p2_.image_path AS image_path_76,
  p2_.title AS title_77,
  p2_.description AS description_78,
  p2_.brand AS brand_79,
  p2_.ean_code AS ean_code_80,
  p2_.sku AS sku_81,
  p2_.hs_code AS hs_code_82,
  p2_.product_cost AS product_cost_83,
  p2_.return_rate AS return_rate_84,
  p2_.recommend_retail_price AS recommend_retail_price_85,
  p2_.weight AS weight_86,
  p2_.out_of_stock AS out_of_stock_87,
  p2_.voucher AS voucher_88,
  p2_.expected_date AS expected_date_89,
  p3_.id AS id_90,
  p3_.name AS name_91,
  p3_.quantity AS quantity_92,
  p3_.discount AS discount_93,
  p3_.unit_price AS unit_price_94,
  p3_.total_price AS total_price_95,
  p3_.label AS label_96,
  p3_.active AS active_97,
  p3_.preselected AS preselected_98,
  p3_.position AS position_99,
  p3_.subscription AS subscription_100,
  p3_.subscription_description AS subscription_description_101,
  p3_.subscription_discount AS subscription_discount_102,
  p3_.subscription_sku AS subscription_sku_103,
  p3_.subscription_price AS subscription_price_104,
  p3_.subscription_trial_period AS subscription_trial_period_105,
  p3_.subscription_preselected AS subscription_preselected_106,
  p3_.image_path AS image_path_107,
  p3_.out_of_stock AS out_of_stock_108,
  w4_.id AS id_109,
  w4_.name AS name_110,
  w4_.username AS username_111,
  w4_.password AS password_112,
  c5_.id AS id_113,
  c5_.template_type AS template_type_114,
  c5_.primary_color AS primary_color_115,
  c5_.secondary_color AS secondary_color_116,
  c5_.primary_bg_color AS primary_bg_color_117,
  c5_.browser_tab_color AS browser_tab_color_118,
  c5_.is_single_page AS is_single_page_119,
  s6_.id AS id_120,
  s6_.name AS name_121,
  s6_.carrier_id AS carrier_id_122,
  s6_.image_path AS image_path_123,
  s6_.active AS active_124,
  p7_.id AS id_125,
  p7_.position AS position_126,
  p8_.id AS id_127,
  p8_.name AS name_128,
  p8_.cms_title AS cms_title_129,
  p8_.title AS title_130,
  p8_.meta_title AS meta_title_131,
  p8_.meta_description AS meta_description_132,
  p8_.usp_info AS usp_info_133,
  p8_.usp_days_to_return AS usp_days_to_return_134,
  p8_.usp_shipping AS usp_shipping_135,
  p8_.ean_code AS ean_code_136,
  p8_.sku AS sku_137,
  p8_.in_stock AS in_stock_138,
  p8_.weight AS weight_139,
  p8_.product_cost AS product_cost_140,
  p8_.url_title AS url_title_141,
  p8_.hs_code AS hs_code_142,
  p8_.return_rate AS return_rate_143,
  p8_.default_currency AS default_currency_144,
  p8_.recommend_retail_price AS recommend_retail_price_145,
  p8_.active_languages AS active_languages_146,
  p8_.active AS active_147,
  p8_.main_product AS main_product_148,
  p8_.thanks_page AS thanks_page_149,
  p8_.description AS description_150,
  p8_.shipping_cost AS shipping_cost_151,
  p8_.min_free_shipping_value AS min_free_shipping_value_152,
  p8_.error_page AS error_page_153,
  p8_.conversion_realtime AS conversion_realtime_154,
  p8_.recently_purchased_popup AS recently_purchased_popup_155,
  p8_.reserved_time AS reserved_time_156,
  p8_.number_bought_product AS number_bought_product_157,
  p8_.number_customers_online AS number_customers_online_158,
  p8_.max_quantity AS max_quantity_159,
  p8_.subscription_mandate AS subscription_mandate_160,
  p8_.auto_cart_add AS auto_cart_add_161,
  p8_.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_162,
  p8_.free_shipping_progress_bar AS free_shipping_progress_bar_163,
  p8_.push_to_higher_variant AS push_to_higher_variant_164,
  p8_.active_upsell_checkout_page AS active_upsell_checkout_page_165,
  p8_.upsell_page_discount_percentage AS upsell_page_discount_percentage_166,
  p8_.upsell_page_progress_timer AS upsell_page_progress_timer_167,
  p8_.upsell_page_description AS upsell_page_description_168,
  p8_.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_169,
  p9_.id AS id_170,
  p9_.image_path AS image_path_171,
  p9_.title AS title_172,
  p9_.description AS description_173,
  p9_.brand AS brand_174,
  p9_.ean_code AS ean_code_175,
  p9_.sku AS sku_176,
  p9_.hs_code AS hs_code_177,
  p9_.product_cost AS product_cost_178,
  p9_.return_rate AS return_rate_179,
  p9_.recommend_retail_price AS recommend_retail_price_180,
  p9_.weight AS weight_181,
  p9_.out_of_stock AS out_of_stock_182,
  p9_.voucher AS voucher_183,
  p9_.expected_date AS expected_date_184,
  p0_.product_type_id AS product_type_id_185,
  p0_.product_detail_id AS product_detail_id_186,
  p0_.warehouse_id AS warehouse_id_187,
  d1_.customer_id AS customer_id_188,
  d1_.active_email_provider_id AS active_email_provider_id_189,
  d1_.country_id AS country_id_190,
  p2_.type_id AS type_id_191,
  p2_.customer_id AS customer_id_192,
  p3_.product_id AS product_id_193,
  c5_.product_id AS product_id_194,
  s6_.country_id AS country_id_195,
  s6_.warehouse_id AS warehouse_id_196,
  p7_.product_id AS product_id_197,
  p7_.upsell_id AS upsell_id_198,
  p8_.product_type_id AS product_type_id_199,
  p8_.product_detail_id AS product_detail_id_200,
  p8_.warehouse_id AS warehouse_id_201,
  p9_.type_id AS type_id_202,
  p9_.customer_id AS customer_id_203
FROM
  product p0_
  LEFT JOIN product_domain p10_ ON p0_.id = p10_.product_id
  LEFT JOIN domain d1_ ON d1_.id = p10_.domain_id
  LEFT JOIN product_detail p2_ ON p0_.product_detail_id = p2_.id
  LEFT JOIN product_variant p3_ ON p0_.id = p3_.product_id
  LEFT JOIN warehouse w4_ ON p0_.warehouse_id = w4_.id
  LEFT JOIN checkout_configuration c5_ ON p0_.id = c5_.product_id
  LEFT JOIN products_shipping_providers p11_ ON p0_.id = p11_.product_id
  LEFT JOIN shipping_provider s6_ ON s6_.id = p11_.shipping_provider_id
  LEFT JOIN products_upsells p7_ ON p0_.id = p7_.product_id
  LEFT JOIN product p8_ ON p7_.upsell_id = p8_.id
  LEFT JOIN product_detail p9_ ON p8_.product_detail_id = p9_.id
WHERE
  p0_.url_title = ?
  AND p0_.active = ?
ORDER BY
  p3_.position ASC,
  p7_.position ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.cms_title AS cms_title_2, p0_.title AS title_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.usp_info AS usp_info_6, p0_.usp_days_to_return AS usp_days_to_return_7, p0_.usp_shipping AS usp_shipping_8, p0_.ean_code AS ean_code_9, p0_.sku AS sku_10, p0_.in_stock AS in_stock_11, p0_.weight AS weight_12, p0_.product_cost AS product_cost_13, p0_.url_title AS url_title_14, p0_.hs_code AS hs_code_15, p0_.return_rate AS return_rate_16, p0_.default_currency AS default_currency_17, p0_.recommend_retail_price AS recommend_retail_price_18, p0_.active_languages AS active_languages_19, p0_.active AS active_20, p0_.main_product AS main_product_21, p0_.thanks_page AS thanks_page_22, p0_.description AS description_23, p0_.shipping_cost AS shipping_cost_24, p0_.min_free_shipping_value AS min_free_shipping_value_25, p0_.error_page AS error_page_26, p0_.conversion_realtime AS conversion_realtime_27, p0_.recently_purchased_popup AS recently_purchased_popup_28, p0_.reserved_time AS reserved_time_29, p0_.number_bought_product AS number_bought_product_30, p0_.number_customers_online AS number_customers_online_31, p0_.max_quantity AS max_quantity_32, p0_.subscription_mandate AS subscription_mandate_33, p0_.auto_cart_add AS auto_cart_add_34, p0_.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_35, p0_.free_shipping_progress_bar AS free_shipping_progress_bar_36, p0_.push_to_higher_variant AS push_to_higher_variant_37, p0_.active_upsell_checkout_page AS active_upsell_checkout_page_38, p0_.upsell_page_discount_percentage AS upsell_page_discount_percentage_39, p0_.upsell_page_progress_timer AS upsell_page_progress_timer_40, p0_.upsell_page_description AS upsell_page_description_41, p0_.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_42, d1_.id AS id_43, d1_.name AS name_44, d1_.url AS url_45, d1_.homepage AS homepage_46, d1_.logo AS logo_47, d1_.favicon AS favicon_48, d1_.company_name AS company_name_49, d1_.address AS address_50, d1_.zip_code AS zip_code_51, d1_.city AS city_52, d1_.phone AS phone_53, d1_.registration_nr AS registration_nr_54, d1_.email AS email_55, d1_.seo_title AS seo_title_56, d1_.seo_description AS seo_description_57, d1_.terms_and_conditions_page AS terms_and_conditions_page_58, d1_.privacy_policy_page AS privacy_policy_page_59, d1_.active AS active_60, d1_.instagram_url AS instagram_url_61, d1_.facebook_url AS facebook_url_62, d1_.facebook_pixel_id AS facebook_pixel_id_63, d1_.facebook_access_token AS facebook_access_token_64, d1_.test_event_code AS test_event_code_65, d1_.sale_supply_shop_id AS sale_supply_shop_id_66, d1_.changed_url AS changed_url_67, d1_.changed_translation AS changed_translation_68, d1_.google_tag_manager_code AS google_tag_manager_code_69, d1_.klaviyo_api_key AS klaviyo_api_key_70, d1_.klaviyo_list_id AS klaviyo_list_id_71, d1_.google_api_secret AS google_api_secret_72, d1_.google_tag_code AS google_tag_code_73, d1_.default_event_providers AS default_event_providers_74, p2_.id AS id_75, p2_.image_path AS image_path_76, p2_.title AS title_77, p2_.description AS description_78, p2_.brand AS brand_79, p2_.ean_code AS ean_code_80, p2_.sku AS sku_81, p2_.hs_code AS hs_code_82, p2_.product_cost AS product_cost_83, p2_.return_rate AS return_rate_84, p2_.recommend_retail_price AS recommend_retail_price_85, p2_.weight AS weight_86, p2_.out_of_stock AS out_of_stock_87, p2_.voucher AS voucher_88, p2_.expected_date AS expected_date_89, p3_.id AS id_90, p3_.name AS name_91, p3_.quantity AS quantity_92, p3_.discount AS discount_93, p3_.unit_price AS unit_price_94, p3_.total_price AS total_price_95, p3_.label AS label_96, p3_.active AS active_97, p3_.preselected AS preselected_98, p3_.position AS position_99, p3_.subscription AS subscription_100, p3_.subscription_description AS subscription_description_101, p3_.subscription_discount AS subscription_discount_102, p3_.subscription_sku AS subscription_sku_103, p3_.subscription_price AS subscription_price_104, p3_.subscription_trial_period AS subscription_trial_period_105, p3_.subscription_preselected AS subscription_preselected_106, p3_.image_path AS image_path_107, p3_.out_of_stock AS out_of_stock_108, w4_.id AS id_109, w4_.name AS name_110, w4_.username AS username_111, w4_.password AS password_112, c5_.id AS id_113, c5_.template_type AS template_type_114, c5_.primary_color AS primary_color_115, c5_.secondary_color AS secondary_color_116, c5_.primary_bg_color AS primary_bg_color_117, c5_.browser_tab_color AS browser_tab_color_118, c5_.is_single_page AS is_single_page_119, s6_.id AS id_120, s6_.name AS name_121, s6_.carrier_id AS carrier_id_122, s6_.image_path AS image_path_123, s6_.active AS active_124, p7_.id AS id_125, p7_.position AS position_126, p8_.id AS id_127, p8_.name AS name_128, p8_.cms_title AS cms_title_129, p8_.title AS title_130, p8_.meta_title AS meta_title_131, p8_.meta_description AS meta_description_132, p8_.usp_info AS usp_info_133, p8_.usp_days_to_return AS usp_days_to_return_134, p8_.usp_shipping AS usp_shipping_135, p8_.ean_code AS ean_code_136, p8_.sku AS sku_137, p8_.in_stock AS in_stock_138, p8_.weight AS weight_139, p8_.product_cost AS product_cost_140, p8_.url_title AS url_title_141, p8_.hs_code AS hs_code_142, p8_.return_rate AS return_rate_143, p8_.default_currency AS default_currency_144, p8_.recommend_retail_price AS recommend_retail_price_145, p8_.active_languages AS active_languages_146, p8_.active AS active_147, p8_.main_product AS main_product_148, p8_.thanks_page AS thanks_page_149, p8_.description AS description_150, p8_.shipping_cost AS shipping_cost_151, p8_.min_free_shipping_value AS min_free_shipping_value_152, p8_.error_page AS error_page_153, p8_.conversion_realtime AS conversion_realtime_154, p8_.recently_purchased_popup AS recently_purchased_popup_155, p8_.reserved_time AS reserved_time_156, p8_.number_bought_product AS number_bought_product_157, p8_.number_customers_online AS number_customers_online_158, p8_.max_quantity AS max_quantity_159, p8_.subscription_mandate AS subscription_mandate_160, p8_.auto_cart_add AS auto_cart_add_161, p8_.is_checkout_warehouse_enabled AS is_checkout_warehouse_enabled_162, p8_.free_shipping_progress_bar AS free_shipping_progress_bar_163, p8_.push_to_higher_variant AS push_to_higher_variant_164, p8_.active_upsell_checkout_page AS active_upsell_checkout_page_165, p8_.upsell_page_discount_percentage AS upsell_page_discount_percentage_166, p8_.upsell_page_progress_timer AS upsell_page_progress_timer_167, p8_.upsell_page_description AS upsell_page_description_168, p8_.upsell_page_desc_for_new_customers AS upsell_page_desc_for_new_customers_169, p9_.id AS id_170, p9_.image_path AS image_path_171, p9_.title AS title_172, p9_.description AS description_173, p9_.brand AS brand_174, p9_.ean_code AS ean_code_175, p9_.sku AS sku_176, p9_.hs_code AS hs_code_177, p9_.product_cost AS product_cost_178, p9_.return_rate AS return_rate_179, p9_.recommend_retail_price AS recommend_retail_price_180, p9_.weight AS weight_181, p9_.out_of_stock AS out_of_stock_182, p9_.voucher AS voucher_183, p9_.expected_date AS expected_date_184, p0_.product_type_id AS product_type_id_185, p0_.product_detail_id AS product_detail_id_186, p0_.warehouse_id AS warehouse_id_187, d1_.customer_id AS customer_id_188, d1_.active_email_provider_id AS active_email_provider_id_189, d1_.country_id AS country_id_190, p2_.type_id AS type_id_191, p2_.customer_id AS customer_id_192, p3_.product_id AS product_id_193, c5_.product_id AS product_id_194, s6_.country_id AS country_id_195, s6_.warehouse_id AS warehouse_id_196, p7_.product_id AS product_id_197, p7_.upsell_id AS upsell_id_198, p8_.product_type_id AS product_type_id_199, p8_.product_detail_id AS product_detail_id_200, p8_.warehouse_id AS warehouse_id_201, p9_.type_id AS type_id_202, p9_.customer_id AS customer_id_203 FROM product p0_ LEFT JOIN product_domain p10_ ON p0_.id = p10_.product_id LEFT JOIN domain d1_ ON d1_.id = p10_.domain_id LEFT JOIN product_detail p2_ ON p0_.product_detail_id = p2_.id LEFT JOIN product_variant p3_ ON p0_.id = p3_.product_id LEFT JOIN warehouse w4_ ON p0_.warehouse_id = w4_.id LEFT JOIN checkout_configuration c5_ ON p0_.id = c5_.product_id LEFT JOIN products_shipping_providers p11_ ON p0_.id = p11_.product_id LEFT JOIN shipping_provider s6_ ON s6_.id = p11_.shipping_provider_id LEFT JOIN products_upsells p7_ ON p0_.id = p7_.product_id LEFT JOIN product p8_ ON p7_.upsell_id = p8_.id LEFT JOIN product_detail p9_ ON p8_.product_detail_id = p9_.id WHERE p0_.url_title = 'ecowash' AND p0_.active = 1 ORDER BY p3_.position ASC, p7_.position ASC;

SELECT
  t0.id AS id_1,
  t0.account_id AS account_id_2,
  t0.conversion_token AS conversion_token_3,
  t0.pinterest_tag AS pinterest_tag_4,
  t0.domain_id AS domain_id_5
FROM
  pinterest_event_provider t0
WHERE
  t0.domain_id = ?

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.conversion_token AS conversion_token_3, t0.pinterest_tag AS pinterest_tag_4, t0.domain_id AS domain_id_5 FROM pinterest_event_provider t0 WHERE t0.domain_id = 2;

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 = '1' AND e0_.locale = 'nl' AND e0_.object_class = 'App\\Entity\\Product';