Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.hash AS hash_3,
  t0.title AS title_4,
  t0.is_active AS is_active_5,
  t0.action_number AS action_number_6,
  t0.from_source AS from_source_7,
  t0.portal_css AS portal_css_8,
  t0.portal_head_scripts AS portal_head_scripts_9,
  t0.portal_start_body_scripts AS portal_start_body_scripts_10,
  t0.portal_body_scripts AS portal_body_scripts_11,
  t0.robots_txt AS robots_txt_12,
  t0.portal_number_sb AS portal_number_sb_13,
  t0.leading_color1 AS leading_color1_14,
  t0.leading_color2 AS leading_color2_15,
  t0.leading_color3 AS leading_color3_16,
  t0.logo AS logo_17,
  t0.contact_mail AS contact_mail_18,
  t0.registration_additional_content AS registration_additional_content_19,
  t0.login_additional_content AS login_additional_content_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.is_uniqskills_portal AS is_uniqskills_portal_23,
  t0.is_netflix_portal AS is_netflix_portal_24,
  t0.is_presale AS is_presale_25,
  t0.is_simple_price AS is_simple_price_26,
  t0.redirect_after_login AS redirect_after_login_27,
  t0.message_after_login AS message_after_login_28,
  t0.message_time_after_login AS message_time_after_login_29,
  t0.device_auth_needed AS device_auth_needed_30,
  t0.sender AS sender_31,
  t0.is_cms_portal AS is_cms_portal_32,
  t0.multi_access_from_max_user AS multi_access_from_max_user_33,
  t0.enable_new_basket AS enable_new_basket_34,
  t0.price_after_free_postage_cost AS price_after_free_postage_cost_35,
  t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36,
  t0.gtm AS gtm_37,
  t0.password_additional_content AS password_additional_content_38,
  t0.leading_color4 AS leading_color4_39,
  t0.userbar_color AS userbar_color_40,
  t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41,
  t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42,
  t0.userbar_html AS userbar_html_43,
  t0.display_userbar2 AS display_userbar2_44,
  t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45,
  t0.test_userbar_html AS test_userbar_html_46,
  t0.lifetime_access AS lifetime_access_47,
  t0.fb_pixel_id AS fb_pixel_id_48,
  t0.fb_pixel_access_token AS fb_pixel_access_token_49,
  t0.hide_field_position AS hide_field_position_50,
  t0.redirecting_to_focus AS redirecting_to_focus_51,
  t0.show_gross_price AS show_gross_price_52,
  t0.cs_mail AS cs_mail_53,
  t0.is_phone_required AS is_phone_required_54,
  t0.webe_mid_number AS webe_mid_number_55,
  t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56,
  t0.is_payment_before_confirmation AS is_payment_before_confirmation_57,
  t0.payment_reward AS payment_reward_58,
  t0.payment_reward_content AS payment_reward_content_59,
  t0.payment_reward_deadline AS payment_reward_deadline_60,
  t0.cart_template AS cart_template_61,
  t0.use_cache_in_access AS use_cache_in_access_62,
  t0.order_confirmation_additional_content AS order_confirmation_additional_content_63,
  t0.additional_content_for_mail AS additional_content_for_mail_64,
  t0.matomo_site_id AS matomo_site_id_65,
  t0.positions_order AS positions_order_66,
  t0.email_settings_id AS email_settings_id_67,
  t0.order_type_id AS order_type_id_68,
  t69.id AS id_70,
  t69.ord_tran_prefix AS ord_tran_prefix_71,
  t69.is_default AS is_default_72,
  t69.use_sb AS use_sb_73,
  t69.use_recaptcha_in_order AS use_recaptcha_in_order_74,
  t69.hide_catalog AS hide_catalog_75,
  t69.hide_nip_in_orders AS hide_nip_in_orders_76,
  t69.show_only_regulations AS show_only_regulations_77,
  t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78,
  t69.facebook_event_type AS facebook_event_type_79,
  t69.footer_copyright AS footer_copyright_80,
  t69.contact_form_recipient AS contact_form_recipient_81,
  t69.text_contact_thank_you AS text_contact_thank_you_82,
  t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83,
  t69.text_acceptance_regulations AS text_acceptance_regulations_84,
  t69.text_voucher_regulations AS text_voucher_regulations_85,
  t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86,
  t69.created_at AS created_at_87,
  t69.updated_at AS updated_at_88,
  t69.portal_settings_id AS portal_settings_id_89,
  t0.virtual_currency_id AS virtual_currency_id_90,
  t0.default_payment_system_id AS default_payment_system_id_91,
  t0.default_cart_client_type_id AS default_cart_client_type_id_92,
  t93.id AS id_94,
  t93.is_active AS is_active_95,
  t93.poll_link AS poll_link_96,
  t93.editorial_email AS editorial_email_97,
  t93.portal_settings_id AS portal_settings_id_98,
  t93.email_template_id AS email_template_id_99
FROM
  portal_settings t0
  LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id
  LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id
WHERE
  t0.hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.hash AS hash_3, t0.title AS title_4, t0.is_active AS is_active_5, t0.action_number AS action_number_6, t0.from_source AS from_source_7, t0.portal_css AS portal_css_8, t0.portal_head_scripts AS portal_head_scripts_9, t0.portal_start_body_scripts AS portal_start_body_scripts_10, t0.portal_body_scripts AS portal_body_scripts_11, t0.robots_txt AS robots_txt_12, t0.portal_number_sb AS portal_number_sb_13, t0.leading_color1 AS leading_color1_14, t0.leading_color2 AS leading_color2_15, t0.leading_color3 AS leading_color3_16, t0.logo AS logo_17, t0.contact_mail AS contact_mail_18, t0.registration_additional_content AS registration_additional_content_19, t0.login_additional_content AS login_additional_content_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_uniqskills_portal AS is_uniqskills_portal_23, t0.is_netflix_portal AS is_netflix_portal_24, t0.is_presale AS is_presale_25, t0.is_simple_price AS is_simple_price_26, t0.redirect_after_login AS redirect_after_login_27, t0.message_after_login AS message_after_login_28, t0.message_time_after_login AS message_time_after_login_29, t0.device_auth_needed AS device_auth_needed_30, t0.sender AS sender_31, t0.is_cms_portal AS is_cms_portal_32, t0.multi_access_from_max_user AS multi_access_from_max_user_33, t0.enable_new_basket AS enable_new_basket_34, t0.price_after_free_postage_cost AS price_after_free_postage_cost_35, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36, t0.gtm AS gtm_37, t0.password_additional_content AS password_additional_content_38, t0.leading_color4 AS leading_color4_39, t0.userbar_color AS userbar_color_40, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42, t0.userbar_html AS userbar_html_43, t0.display_userbar2 AS display_userbar2_44, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45, t0.test_userbar_html AS test_userbar_html_46, t0.lifetime_access AS lifetime_access_47, t0.fb_pixel_id AS fb_pixel_id_48, t0.fb_pixel_access_token AS fb_pixel_access_token_49, t0.hide_field_position AS hide_field_position_50, t0.redirecting_to_focus AS redirecting_to_focus_51, t0.show_gross_price AS show_gross_price_52, t0.cs_mail AS cs_mail_53, t0.is_phone_required AS is_phone_required_54, t0.webe_mid_number AS webe_mid_number_55, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56, t0.is_payment_before_confirmation AS is_payment_before_confirmation_57, t0.payment_reward AS payment_reward_58, t0.payment_reward_content AS payment_reward_content_59, t0.payment_reward_deadline AS payment_reward_deadline_60, t0.cart_template AS cart_template_61, t0.use_cache_in_access AS use_cache_in_access_62, t0.order_confirmation_additional_content AS order_confirmation_additional_content_63, t0.additional_content_for_mail AS additional_content_for_mail_64, t0.matomo_site_id AS matomo_site_id_65, t0.positions_order AS positions_order_66, t0.email_settings_id AS email_settings_id_67, t0.order_type_id AS order_type_id_68, t69.id AS id_70, t69.ord_tran_prefix AS ord_tran_prefix_71, t69.is_default AS is_default_72, t69.use_sb AS use_sb_73, t69.use_recaptcha_in_order AS use_recaptcha_in_order_74, t69.hide_catalog AS hide_catalog_75, t69.hide_nip_in_orders AS hide_nip_in_orders_76, t69.show_only_regulations AS show_only_regulations_77, t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78, t69.facebook_event_type AS facebook_event_type_79, t69.footer_copyright AS footer_copyright_80, t69.contact_form_recipient AS contact_form_recipient_81, t69.text_contact_thank_you AS text_contact_thank_you_82, t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83, t69.text_acceptance_regulations AS text_acceptance_regulations_84, t69.text_voucher_regulations AS text_voucher_regulations_85, t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86, t69.created_at AS created_at_87, t69.updated_at AS updated_at_88, t69.portal_settings_id AS portal_settings_id_89, t0.virtual_currency_id AS virtual_currency_id_90, t0.default_payment_system_id AS default_payment_system_id_91, t0.default_cart_client_type_id AS default_cart_client_type_id_92, t93.id AS id_94, t93.is_active AS is_active_95, t93.poll_link AS poll_link_96, t93.editorial_email AS editorial_email_97, t93.portal_settings_id AS portal_settings_id_98, t93.email_template_id AS email_template_id_99 FROM portal_settings t0 LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.native AS native_4,
  t0.slug AS slug_5,
  t0.code AS code_6,
  t0.short AS short_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  language t0
  INNER JOIN fm_company_settings_language ON t0.id = fm_company_settings_language.language_id
WHERE
  fm_company_settings_language.fm_company_settings_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.native AS native_4, t0.slug AS slug_5, t0.code AS code_6, t0.short AS short_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM language t0 INNER JOIN fm_company_settings_language ON t0.id = fm_company_settings_language.language_id WHERE fm_company_settings_language.fm_company_settings_id = 1;

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.hash AS hash_3,
  t0.title AS title_4,
  t0.is_active AS is_active_5,
  t0.action_number AS action_number_6,
  t0.from_source AS from_source_7,
  t0.portal_css AS portal_css_8,
  t0.portal_head_scripts AS portal_head_scripts_9,
  t0.portal_start_body_scripts AS portal_start_body_scripts_10,
  t0.portal_body_scripts AS portal_body_scripts_11,
  t0.robots_txt AS robots_txt_12,
  t0.portal_number_sb AS portal_number_sb_13,
  t0.leading_color1 AS leading_color1_14,
  t0.leading_color2 AS leading_color2_15,
  t0.leading_color3 AS leading_color3_16,
  t0.logo AS logo_17,
  t0.contact_mail AS contact_mail_18,
  t0.registration_additional_content AS registration_additional_content_19,
  t0.login_additional_content AS login_additional_content_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.is_uniqskills_portal AS is_uniqskills_portal_23,
  t0.is_netflix_portal AS is_netflix_portal_24,
  t0.is_presale AS is_presale_25,
  t0.is_simple_price AS is_simple_price_26,
  t0.redirect_after_login AS redirect_after_login_27,
  t0.message_after_login AS message_after_login_28,
  t0.message_time_after_login AS message_time_after_login_29,
  t0.device_auth_needed AS device_auth_needed_30,
  t0.sender AS sender_31,
  t0.is_cms_portal AS is_cms_portal_32,
  t0.multi_access_from_max_user AS multi_access_from_max_user_33,
  t0.enable_new_basket AS enable_new_basket_34,
  t0.price_after_free_postage_cost AS price_after_free_postage_cost_35,
  t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36,
  t0.gtm AS gtm_37,
  t0.password_additional_content AS password_additional_content_38,
  t0.leading_color4 AS leading_color4_39,
  t0.userbar_color AS userbar_color_40,
  t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41,
  t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42,
  t0.userbar_html AS userbar_html_43,
  t0.display_userbar2 AS display_userbar2_44,
  t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45,
  t0.test_userbar_html AS test_userbar_html_46,
  t0.lifetime_access AS lifetime_access_47,
  t0.fb_pixel_id AS fb_pixel_id_48,
  t0.fb_pixel_access_token AS fb_pixel_access_token_49,
  t0.hide_field_position AS hide_field_position_50,
  t0.redirecting_to_focus AS redirecting_to_focus_51,
  t0.show_gross_price AS show_gross_price_52,
  t0.cs_mail AS cs_mail_53,
  t0.is_phone_required AS is_phone_required_54,
  t0.webe_mid_number AS webe_mid_number_55,
  t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56,
  t0.is_payment_before_confirmation AS is_payment_before_confirmation_57,
  t0.payment_reward AS payment_reward_58,
  t0.payment_reward_content AS payment_reward_content_59,
  t0.payment_reward_deadline AS payment_reward_deadline_60,
  t0.cart_template AS cart_template_61,
  t0.use_cache_in_access AS use_cache_in_access_62,
  t0.order_confirmation_additional_content AS order_confirmation_additional_content_63,
  t0.additional_content_for_mail AS additional_content_for_mail_64,
  t0.matomo_site_id AS matomo_site_id_65,
  t0.positions_order AS positions_order_66,
  t0.email_settings_id AS email_settings_id_67,
  t0.order_type_id AS order_type_id_68,
  t69.id AS id_70,
  t69.ord_tran_prefix AS ord_tran_prefix_71,
  t69.is_default AS is_default_72,
  t69.use_sb AS use_sb_73,
  t69.use_recaptcha_in_order AS use_recaptcha_in_order_74,
  t69.hide_catalog AS hide_catalog_75,
  t69.hide_nip_in_orders AS hide_nip_in_orders_76,
  t69.show_only_regulations AS show_only_regulations_77,
  t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78,
  t69.facebook_event_type AS facebook_event_type_79,
  t69.footer_copyright AS footer_copyright_80,
  t69.contact_form_recipient AS contact_form_recipient_81,
  t69.text_contact_thank_you AS text_contact_thank_you_82,
  t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83,
  t69.text_acceptance_regulations AS text_acceptance_regulations_84,
  t69.text_voucher_regulations AS text_voucher_regulations_85,
  t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86,
  t69.created_at AS created_at_87,
  t69.updated_at AS updated_at_88,
  t69.portal_settings_id AS portal_settings_id_89,
  t0.virtual_currency_id AS virtual_currency_id_90,
  t0.default_payment_system_id AS default_payment_system_id_91,
  t0.default_cart_client_type_id AS default_cart_client_type_id_92,
  t93.id AS id_94,
  t93.is_active AS is_active_95,
  t93.poll_link AS poll_link_96,
  t93.editorial_email AS editorial_email_97,
  t93.portal_settings_id AS portal_settings_id_98,
  t93.email_template_id AS email_template_id_99
FROM
  portal_settings t0
  LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id
  LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id
WHERE
  t0.hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.hash AS hash_3, t0.title AS title_4, t0.is_active AS is_active_5, t0.action_number AS action_number_6, t0.from_source AS from_source_7, t0.portal_css AS portal_css_8, t0.portal_head_scripts AS portal_head_scripts_9, t0.portal_start_body_scripts AS portal_start_body_scripts_10, t0.portal_body_scripts AS portal_body_scripts_11, t0.robots_txt AS robots_txt_12, t0.portal_number_sb AS portal_number_sb_13, t0.leading_color1 AS leading_color1_14, t0.leading_color2 AS leading_color2_15, t0.leading_color3 AS leading_color3_16, t0.logo AS logo_17, t0.contact_mail AS contact_mail_18, t0.registration_additional_content AS registration_additional_content_19, t0.login_additional_content AS login_additional_content_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_uniqskills_portal AS is_uniqskills_portal_23, t0.is_netflix_portal AS is_netflix_portal_24, t0.is_presale AS is_presale_25, t0.is_simple_price AS is_simple_price_26, t0.redirect_after_login AS redirect_after_login_27, t0.message_after_login AS message_after_login_28, t0.message_time_after_login AS message_time_after_login_29, t0.device_auth_needed AS device_auth_needed_30, t0.sender AS sender_31, t0.is_cms_portal AS is_cms_portal_32, t0.multi_access_from_max_user AS multi_access_from_max_user_33, t0.enable_new_basket AS enable_new_basket_34, t0.price_after_free_postage_cost AS price_after_free_postage_cost_35, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36, t0.gtm AS gtm_37, t0.password_additional_content AS password_additional_content_38, t0.leading_color4 AS leading_color4_39, t0.userbar_color AS userbar_color_40, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42, t0.userbar_html AS userbar_html_43, t0.display_userbar2 AS display_userbar2_44, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45, t0.test_userbar_html AS test_userbar_html_46, t0.lifetime_access AS lifetime_access_47, t0.fb_pixel_id AS fb_pixel_id_48, t0.fb_pixel_access_token AS fb_pixel_access_token_49, t0.hide_field_position AS hide_field_position_50, t0.redirecting_to_focus AS redirecting_to_focus_51, t0.show_gross_price AS show_gross_price_52, t0.cs_mail AS cs_mail_53, t0.is_phone_required AS is_phone_required_54, t0.webe_mid_number AS webe_mid_number_55, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56, t0.is_payment_before_confirmation AS is_payment_before_confirmation_57, t0.payment_reward AS payment_reward_58, t0.payment_reward_content AS payment_reward_content_59, t0.payment_reward_deadline AS payment_reward_deadline_60, t0.cart_template AS cart_template_61, t0.use_cache_in_access AS use_cache_in_access_62, t0.order_confirmation_additional_content AS order_confirmation_additional_content_63, t0.additional_content_for_mail AS additional_content_for_mail_64, t0.matomo_site_id AS matomo_site_id_65, t0.positions_order AS positions_order_66, t0.email_settings_id AS email_settings_id_67, t0.order_type_id AS order_type_id_68, t69.id AS id_70, t69.ord_tran_prefix AS ord_tran_prefix_71, t69.is_default AS is_default_72, t69.use_sb AS use_sb_73, t69.use_recaptcha_in_order AS use_recaptcha_in_order_74, t69.hide_catalog AS hide_catalog_75, t69.hide_nip_in_orders AS hide_nip_in_orders_76, t69.show_only_regulations AS show_only_regulations_77, t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78, t69.facebook_event_type AS facebook_event_type_79, t69.footer_copyright AS footer_copyright_80, t69.contact_form_recipient AS contact_form_recipient_81, t69.text_contact_thank_you AS text_contact_thank_you_82, t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83, t69.text_acceptance_regulations AS text_acceptance_regulations_84, t69.text_voucher_regulations AS text_voucher_regulations_85, t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86, t69.created_at AS created_at_87, t69.updated_at AS updated_at_88, t69.portal_settings_id AS portal_settings_id_89, t0.virtual_currency_id AS virtual_currency_id_90, t0.default_payment_system_id AS default_payment_system_id_91, t0.default_cart_client_type_id AS default_cart_client_type_id_92, t93.id AS id_94, t93.is_active AS is_active_95, t93.poll_link AS poll_link_96, t93.editorial_email AS editorial_email_97, t93.portal_settings_id AS portal_settings_id_98, t93.email_template_id AS email_template_id_99 FROM portal_settings t0 LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.model AS model_3,
  t0.has_multi_discount AS has_multi_discount_4,
  t0.selected_discount AS selected_discount_5,
  t0.extended_payment_time AS extended_payment_time_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.sent_to_sm AS sent_to_sm_9,
  t0.bur_assigned_support_id AS bur_assigned_support_id_10,
  t0.sales_manago2_event_id AS sales_manago2_event_id_11,
  t0.coupon_id AS coupon_id_12,
  t0.address_id AS address_id_13,
  t0.user_id AS user_id_14,
  t0.user_temporary_id AS user_temporary_id_15,
  t0.country_id AS country_id_16,
  t0.payment_method_id AS payment_method_id_17,
  t0.payment_system_id AS payment_system_id_18,
  t0.portal_settings_id AS portal_settings_id_19,
  t0.shipping_type_id AS shipping_type_id_20
FROM
  cart t0
WHERE
  t0.hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.model AS model_3, t0.has_multi_discount AS has_multi_discount_4, t0.selected_discount AS selected_discount_5, t0.extended_payment_time AS extended_payment_time_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.sent_to_sm AS sent_to_sm_9, t0.bur_assigned_support_id AS bur_assigned_support_id_10, t0.sales_manago2_event_id AS sales_manago2_event_id_11, t0.coupon_id AS coupon_id_12, t0.address_id AS address_id_13, t0.user_id AS user_id_14, t0.user_temporary_id AS user_temporary_id_15, t0.country_id AS country_id_16, t0.payment_method_id AS payment_method_id_17, t0.payment_system_id AS payment_system_id_18, t0.portal_settings_id AS portal_settings_id_19, t0.shipping_type_id AS shipping_type_id_20 FROM cart t0 WHERE t0.hash = '051cc562179e97d7ba5650265930fa' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.is_gift AS is_gift_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.lifetime_landing AS lifetime_landing_6,
  t0.upselling_type AS upselling_type_7,
  t0.omit_shipping_costs AS omit_shipping_costs_8,
  t0.selected_discount AS selected_discount_9,
  t0.product_duplication_message_displayed AS product_duplication_message_displayed_10,
  t0.cart_id AS cart_id_11,
  t0.product_variant_id AS product_variant_id_12,
  t0.product_pack_id AS product_pack_id_13,
  t0.payment_method_id AS payment_method_id_14,
  t15.id AS id_16,
  t15.is_active AS is_active_17,
  t15.recipient_first_name AS recipient_first_name_18,
  t15.recipient_last_name AS recipient_last_name_19,
  t15.recipient_email AS recipient_email_20,
  t15.is_temporary AS is_temporary_21,
  t15.created_at AS created_at_22,
  t15.updated_at AS updated_at_23,
  t15.signature AS signature_24,
  t15.message AS message_25,
  t15.send_at AS send_at_26,
  t15.buyer_order_id AS buyer_order_id_27,
  t15.recipient_order_id AS recipient_order_id_28,
  t15.gift_discount_code_id AS gift_discount_code_id_29,
  t15.product_cart_id AS product_cart_id_30,
  t15.order_product_variant_id AS order_product_variant_id_31,
  t0.coupon_id AS coupon_id_32,
  t0.product_association_id AS product_association_id_33,
  t0.cycle_product_pack_id AS cycle_product_pack_id_34,
  t0.course_id AS course_id_35,
  t0.parent_id AS parent_id_36
FROM
  product_cart t0
  LEFT JOIN gift t15 ON t15.product_cart_id = t0.id
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.is_gift AS is_gift_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.lifetime_landing AS lifetime_landing_6, t0.upselling_type AS upselling_type_7, t0.omit_shipping_costs AS omit_shipping_costs_8, t0.selected_discount AS selected_discount_9, t0.product_duplication_message_displayed AS product_duplication_message_displayed_10, t0.cart_id AS cart_id_11, t0.product_variant_id AS product_variant_id_12, t0.product_pack_id AS product_pack_id_13, t0.payment_method_id AS payment_method_id_14, t15.id AS id_16, t15.is_active AS is_active_17, t15.recipient_first_name AS recipient_first_name_18, t15.recipient_last_name AS recipient_last_name_19, t15.recipient_email AS recipient_email_20, t15.is_temporary AS is_temporary_21, t15.created_at AS created_at_22, t15.updated_at AS updated_at_23, t15.signature AS signature_24, t15.message AS message_25, t15.send_at AS send_at_26, t15.buyer_order_id AS buyer_order_id_27, t15.recipient_order_id AS recipient_order_id_28, t15.gift_discount_code_id AS gift_discount_code_id_29, t15.product_cart_id AS product_cart_id_30, t15.order_product_variant_id AS order_product_variant_id_31, t0.coupon_id AS coupon_id_32, t0.product_association_id AS product_association_id_33, t0.cycle_product_pack_id AS cycle_product_pack_id_34, t0.course_id AS course_id_35, t0.parent_id AS parent_id_36 FROM product_cart t0 LEFT JOIN gift t15 ON t15.product_cart_id = t0.id WHERE t0.cart_id = 72075611;

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.hash AS hash_3,
  t0.title AS title_4,
  t0.is_active AS is_active_5,
  t0.action_number AS action_number_6,
  t0.from_source AS from_source_7,
  t0.portal_css AS portal_css_8,
  t0.portal_head_scripts AS portal_head_scripts_9,
  t0.portal_start_body_scripts AS portal_start_body_scripts_10,
  t0.portal_body_scripts AS portal_body_scripts_11,
  t0.robots_txt AS robots_txt_12,
  t0.portal_number_sb AS portal_number_sb_13,
  t0.leading_color1 AS leading_color1_14,
  t0.leading_color2 AS leading_color2_15,
  t0.leading_color3 AS leading_color3_16,
  t0.logo AS logo_17,
  t0.contact_mail AS contact_mail_18,
  t0.registration_additional_content AS registration_additional_content_19,
  t0.login_additional_content AS login_additional_content_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.is_uniqskills_portal AS is_uniqskills_portal_23,
  t0.is_netflix_portal AS is_netflix_portal_24,
  t0.is_presale AS is_presale_25,
  t0.is_simple_price AS is_simple_price_26,
  t0.redirect_after_login AS redirect_after_login_27,
  t0.message_after_login AS message_after_login_28,
  t0.message_time_after_login AS message_time_after_login_29,
  t0.device_auth_needed AS device_auth_needed_30,
  t0.sender AS sender_31,
  t0.is_cms_portal AS is_cms_portal_32,
  t0.multi_access_from_max_user AS multi_access_from_max_user_33,
  t0.enable_new_basket AS enable_new_basket_34,
  t0.price_after_free_postage_cost AS price_after_free_postage_cost_35,
  t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36,
  t0.gtm AS gtm_37,
  t0.password_additional_content AS password_additional_content_38,
  t0.leading_color4 AS leading_color4_39,
  t0.userbar_color AS userbar_color_40,
  t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41,
  t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42,
  t0.userbar_html AS userbar_html_43,
  t0.display_userbar2 AS display_userbar2_44,
  t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45,
  t0.test_userbar_html AS test_userbar_html_46,
  t0.lifetime_access AS lifetime_access_47,
  t0.fb_pixel_id AS fb_pixel_id_48,
  t0.fb_pixel_access_token AS fb_pixel_access_token_49,
  t0.hide_field_position AS hide_field_position_50,
  t0.redirecting_to_focus AS redirecting_to_focus_51,
  t0.show_gross_price AS show_gross_price_52,
  t0.cs_mail AS cs_mail_53,
  t0.is_phone_required AS is_phone_required_54,
  t0.webe_mid_number AS webe_mid_number_55,
  t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56,
  t0.is_payment_before_confirmation AS is_payment_before_confirmation_57,
  t0.payment_reward AS payment_reward_58,
  t0.payment_reward_content AS payment_reward_content_59,
  t0.payment_reward_deadline AS payment_reward_deadline_60,
  t0.cart_template AS cart_template_61,
  t0.use_cache_in_access AS use_cache_in_access_62,
  t0.order_confirmation_additional_content AS order_confirmation_additional_content_63,
  t0.additional_content_for_mail AS additional_content_for_mail_64,
  t0.matomo_site_id AS matomo_site_id_65,
  t0.positions_order AS positions_order_66,
  t0.email_settings_id AS email_settings_id_67,
  t0.order_type_id AS order_type_id_68,
  t69.id AS id_70,
  t69.ord_tran_prefix AS ord_tran_prefix_71,
  t69.is_default AS is_default_72,
  t69.use_sb AS use_sb_73,
  t69.use_recaptcha_in_order AS use_recaptcha_in_order_74,
  t69.hide_catalog AS hide_catalog_75,
  t69.hide_nip_in_orders AS hide_nip_in_orders_76,
  t69.show_only_regulations AS show_only_regulations_77,
  t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78,
  t69.facebook_event_type AS facebook_event_type_79,
  t69.footer_copyright AS footer_copyright_80,
  t69.contact_form_recipient AS contact_form_recipient_81,
  t69.text_contact_thank_you AS text_contact_thank_you_82,
  t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83,
  t69.text_acceptance_regulations AS text_acceptance_regulations_84,
  t69.text_voucher_regulations AS text_voucher_regulations_85,
  t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86,
  t69.created_at AS created_at_87,
  t69.updated_at AS updated_at_88,
  t69.portal_settings_id AS portal_settings_id_89,
  t0.virtual_currency_id AS virtual_currency_id_90,
  t0.default_payment_system_id AS default_payment_system_id_91,
  t0.default_cart_client_type_id AS default_cart_client_type_id_92,
  t93.id AS id_94,
  t93.is_active AS is_active_95,
  t93.poll_link AS poll_link_96,
  t93.editorial_email AS editorial_email_97,
  t93.portal_settings_id AS portal_settings_id_98,
  t93.email_template_id AS email_template_id_99
FROM
  portal_settings t0
  LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id
  LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id
WHERE
  t0.hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.hash AS hash_3, t0.title AS title_4, t0.is_active AS is_active_5, t0.action_number AS action_number_6, t0.from_source AS from_source_7, t0.portal_css AS portal_css_8, t0.portal_head_scripts AS portal_head_scripts_9, t0.portal_start_body_scripts AS portal_start_body_scripts_10, t0.portal_body_scripts AS portal_body_scripts_11, t0.robots_txt AS robots_txt_12, t0.portal_number_sb AS portal_number_sb_13, t0.leading_color1 AS leading_color1_14, t0.leading_color2 AS leading_color2_15, t0.leading_color3 AS leading_color3_16, t0.logo AS logo_17, t0.contact_mail AS contact_mail_18, t0.registration_additional_content AS registration_additional_content_19, t0.login_additional_content AS login_additional_content_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.is_uniqskills_portal AS is_uniqskills_portal_23, t0.is_netflix_portal AS is_netflix_portal_24, t0.is_presale AS is_presale_25, t0.is_simple_price AS is_simple_price_26, t0.redirect_after_login AS redirect_after_login_27, t0.message_after_login AS message_after_login_28, t0.message_time_after_login AS message_time_after_login_29, t0.device_auth_needed AS device_auth_needed_30, t0.sender AS sender_31, t0.is_cms_portal AS is_cms_portal_32, t0.multi_access_from_max_user AS multi_access_from_max_user_33, t0.enable_new_basket AS enable_new_basket_34, t0.price_after_free_postage_cost AS price_after_free_postage_cost_35, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36, t0.gtm AS gtm_37, t0.password_additional_content AS password_additional_content_38, t0.leading_color4 AS leading_color4_39, t0.userbar_color AS userbar_color_40, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42, t0.userbar_html AS userbar_html_43, t0.display_userbar2 AS display_userbar2_44, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45, t0.test_userbar_html AS test_userbar_html_46, t0.lifetime_access AS lifetime_access_47, t0.fb_pixel_id AS fb_pixel_id_48, t0.fb_pixel_access_token AS fb_pixel_access_token_49, t0.hide_field_position AS hide_field_position_50, t0.redirecting_to_focus AS redirecting_to_focus_51, t0.show_gross_price AS show_gross_price_52, t0.cs_mail AS cs_mail_53, t0.is_phone_required AS is_phone_required_54, t0.webe_mid_number AS webe_mid_number_55, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56, t0.is_payment_before_confirmation AS is_payment_before_confirmation_57, t0.payment_reward AS payment_reward_58, t0.payment_reward_content AS payment_reward_content_59, t0.payment_reward_deadline AS payment_reward_deadline_60, t0.cart_template AS cart_template_61, t0.use_cache_in_access AS use_cache_in_access_62, t0.order_confirmation_additional_content AS order_confirmation_additional_content_63, t0.additional_content_for_mail AS additional_content_for_mail_64, t0.matomo_site_id AS matomo_site_id_65, t0.positions_order AS positions_order_66, t0.email_settings_id AS email_settings_id_67, t0.order_type_id AS order_type_id_68, t69.id AS id_70, t69.ord_tran_prefix AS ord_tran_prefix_71, t69.is_default AS is_default_72, t69.use_sb AS use_sb_73, t69.use_recaptcha_in_order AS use_recaptcha_in_order_74, t69.hide_catalog AS hide_catalog_75, t69.hide_nip_in_orders AS hide_nip_in_orders_76, t69.show_only_regulations AS show_only_regulations_77, t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78, t69.facebook_event_type AS facebook_event_type_79, t69.footer_copyright AS footer_copyright_80, t69.contact_form_recipient AS contact_form_recipient_81, t69.text_contact_thank_you AS text_contact_thank_you_82, t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83, t69.text_acceptance_regulations AS text_acceptance_regulations_84, t69.text_voucher_regulations AS text_voucher_regulations_85, t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86, t69.created_at AS created_at_87, t69.updated_at AS updated_at_88, t69.portal_settings_id AS portal_settings_id_89, t0.virtual_currency_id AS virtual_currency_id_90, t0.default_payment_system_id AS default_payment_system_id_91, t0.default_cart_client_type_id AS default_cart_client_type_id_92, t93.id AS id_94, t93.is_active AS is_active_95, t93.poll_link AS poll_link_96, t93.editorial_email AS editorial_email_97, t93.portal_settings_id AS portal_settings_id_98, t93.email_template_id AS email_template_id_99 FROM portal_settings t0 LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.hash AS hash_3,
  t0.title AS title_4,
  t0.is_active AS is_active_5,
  t0.action_number AS action_number_6,
  t0.from_source AS from_source_7,
  t0.portal_css AS portal_css_8,
  t0.portal_head_scripts AS portal_head_scripts_9,
  t0.portal_start_body_scripts AS portal_start_body_scripts_10,
  t0.portal_body_scripts AS portal_body_scripts_11,
  t0.robots_txt AS robots_txt_12,
  t0.portal_number_sb AS portal_number_sb_13,
  t0.leading_color1 AS leading_color1_14,
  t0.leading_color2 AS leading_color2_15,
  t0.leading_color3 AS leading_color3_16,
  t0.logo AS logo_17,
  t0.contact_mail AS contact_mail_18,
  t0.registration_additional_content AS registration_additional_content_19,
  t0.login_additional_content AS login_additional_content_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.is_uniqskills_portal AS is_uniqskills_portal_23,
  t0.is_netflix_portal AS is_netflix_portal_24,
  t0.is_presale AS is_presale_25,
  t0.is_simple_price AS is_simple_price_26,
  t0.redirect_after_login AS redirect_after_login_27,
  t0.message_after_login AS message_after_login_28,
  t0.message_time_after_login AS message_time_after_login_29,
  t0.device_auth_needed AS device_auth_needed_30,
  t0.sender AS sender_31,
  t0.is_cms_portal AS is_cms_portal_32,
  t0.multi_access_from_max_user AS multi_access_from_max_user_33,
  t0.enable_new_basket AS enable_new_basket_34,
  t0.price_after_free_postage_cost AS price_after_free_postage_cost_35,
  t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_36,
  t0.gtm AS gtm_37,
  t0.password_additional_content AS password_additional_content_38,
  t0.leading_color4 AS leading_color4_39,
  t0.userbar_color AS userbar_color_40,
  t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_41,
  t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_42,
  t0.userbar_html AS userbar_html_43,
  t0.display_userbar2 AS display_userbar2_44,
  t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_45,
  t0.test_userbar_html AS test_userbar_html_46,
  t0.lifetime_access AS lifetime_access_47,
  t0.fb_pixel_id AS fb_pixel_id_48,
  t0.fb_pixel_access_token AS fb_pixel_access_token_49,
  t0.hide_field_position AS hide_field_position_50,
  t0.redirecting_to_focus AS redirecting_to_focus_51,
  t0.show_gross_price AS show_gross_price_52,
  t0.cs_mail AS cs_mail_53,
  t0.is_phone_required AS is_phone_required_54,
  t0.webe_mid_number AS webe_mid_number_55,
  t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_56,
  t0.is_payment_before_confirmation AS is_payment_before_confirmation_57,
  t0.payment_reward AS payment_reward_58,
  t0.payment_reward_content AS payment_reward_content_59,
  t0.payment_reward_deadline AS payment_reward_deadline_60,
  t0.cart_template AS cart_template_61,
  t0.use_cache_in_access AS use_cache_in_access_62,
  t0.order_confirmation_additional_content AS order_confirmation_additional_content_63,
  t0.additional_content_for_mail AS additional_content_for_mail_64,
  t0.matomo_site_id AS matomo_site_id_65,
  t0.positions_order AS positions_order_66,
  t0.email_settings_id AS email_settings_id_67,
  t0.order_type_id AS order_type_id_68,
  t69.id AS id_70,
  t69.ord_tran_prefix AS ord_tran_prefix_71,
  t69.is_default AS is_default_72,
  t69.use_sb AS use_sb_73,
  t69.use_recaptcha_in_order AS use_recaptcha_in_order_74,
  t69.hide_catalog AS hide_catalog_75,
  t69.hide_nip_in_orders AS hide_nip_in_orders_76,
  t69.show_only_regulations AS show_only_regulations_77,
  t69.send_order_welcome_mail_only AS send_order_welcome_mail_only_78,
  t69.facebook_event_type AS facebook_event_type_79,
  t69.footer_copyright AS footer_copyright_80,
  t69.contact_form_recipient AS contact_form_recipient_81,
  t69.text_contact_thank_you AS text_contact_thank_you_82,
  t69.text_footer_cooperator_headers AS text_footer_cooperator_headers_83,
  t69.text_acceptance_regulations AS text_acceptance_regulations_84,
  t69.text_voucher_regulations AS text_voucher_regulations_85,
  t69.text_consent_processing_personal_data AS text_consent_processing_personal_data_86,
  t69.created_at AS created_at_87,
  t69.updated_at AS updated_at_88,
  t69.portal_settings_id AS portal_settings_id_89,
  t0.virtual_currency_id AS virtual_currency_id_90,
  t0.default_payment_system_id AS default_payment_system_id_91,
  t0.default_cart_client_type_id AS default_cart_client_type_id_92,
  t93.id AS id_94,
  t93.is_active AS is_active_95,
  t93.poll_link AS poll_link_96,
  t93.editorial_email AS editorial_email_97,
  t93.portal_settings_id AS portal_settings_id_98,
  t93.email_template_id AS email_template_id_99
FROM
  portal_settings t0
  LEFT JOIN fm_company_settings t69 ON t69.portal_settings_id = t0.id
  LEFT JOIN onboarding_settings t93 ON t93.portal_settings_id = t0.id
WHERE
  t0.hash = ?
LIMIT
  1