| 1 |
1.97 ms |
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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters: [
"42231b0ff8a4775b3089cbe1746f32"
]
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.cart_additional_info AS cart_additional_info_13,
t0.portal_number_sb AS portal_number_sb_14,
t0.leading_color1 AS leading_color1_15,
t0.leading_color2 AS leading_color2_16,
t0.leading_color3 AS leading_color3_17,
t0.logo AS logo_18,
t0.contact_mail AS contact_mail_19,
t0.registration_additional_content AS registration_additional_content_20,
t0.login_additional_content AS login_additional_content_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.is_uniqskills_portal AS is_uniqskills_portal_24,
t0.is_netflix_portal AS is_netflix_portal_25,
t0.is_presale AS is_presale_26,
t0.is_simple_price AS is_simple_price_27,
t0.redirect_after_login AS redirect_after_login_28,
t0.message_after_login AS message_after_login_29,
t0.message_time_after_login AS message_time_after_login_30,
t0.device_auth_needed AS device_auth_needed_31,
t0.sender AS sender_32,
t0.is_cms_portal AS is_cms_portal_33,
t0.multi_access_from_max_user AS multi_access_from_max_user_34,
t0.enable_new_basket AS enable_new_basket_35,
t0.price_after_free_postage_cost AS price_after_free_postage_cost_36,
t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37,
t0.gtm AS gtm_38,
t0.password_additional_content AS password_additional_content_39,
t0.leading_color4 AS leading_color4_40,
t0.userbar_color AS userbar_color_41,
t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42,
t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43,
t0.userbar_html AS userbar_html_44,
t0.display_userbar2 AS display_userbar2_45,
t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46,
t0.test_userbar_html AS test_userbar_html_47,
t0.lifetime_access AS lifetime_access_48,
t0.fb_pixel_id AS fb_pixel_id_49,
t0.fb_pixel_access_token AS fb_pixel_access_token_50,
t0.hide_field_position AS hide_field_position_51,
t0.redirecting_to_focus AS redirecting_to_focus_52,
t0.show_gross_price AS show_gross_price_53,
t0.cs_mail AS cs_mail_54,
t0.is_phone_required AS is_phone_required_55,
t0.webe_mid_number AS webe_mid_number_56,
t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57,
t0.is_payment_before_confirmation AS is_payment_before_confirmation_58,
t0.payment_reward AS payment_reward_59,
t0.payment_reward_content AS payment_reward_content_60,
t0.payment_reward_deadline AS payment_reward_deadline_61,
t0.cart_template AS cart_template_62,
t0.use_cache_in_access AS use_cache_in_access_63,
t0.order_confirmation_additional_content AS order_confirmation_additional_content_64,
t0.additional_content_for_mail AS additional_content_for_mail_65,
t0.matomo_site_id AS matomo_site_id_66,
t0.positions_order AS positions_order_67,
t0.email_settings_id AS email_settings_id_68,
t0.order_type_id AS order_type_id_69,
t70.id AS id_71,
t70.ord_tran_prefix AS ord_tran_prefix_72,
t70.is_default AS is_default_73,
t70.use_sb AS use_sb_74,
t70.use_recaptcha_in_order AS use_recaptcha_in_order_75,
t70.hide_catalog AS hide_catalog_76,
t70.hide_nip_in_orders AS hide_nip_in_orders_77,
t70.show_only_regulations AS show_only_regulations_78,
t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79,
t70.facebook_event_type AS facebook_event_type_80,
t70.footer_copyright AS footer_copyright_81,
t70.contact_form_recipient AS contact_form_recipient_82,
t70.text_contact_thank_you AS text_contact_thank_you_83,
t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84,
t70.text_acceptance_regulations AS text_acceptance_regulations_85,
t70.text_voucher_regulations AS text_voucher_regulations_86,
t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87,
t70.created_at AS created_at_88,
t70.updated_at AS updated_at_89,
t70.portal_settings_id AS portal_settings_id_90,
t0.virtual_currency_id AS virtual_currency_id_91,
t0.default_payment_system_id AS default_payment_system_id_92,
t0.default_cart_client_type_id AS default_cart_client_type_id_93,
t94.id AS id_95,
t94.is_active AS is_active_96,
t94.poll_link AS poll_link_97,
t94.editorial_email AS editorial_email_98,
t94.portal_settings_id AS portal_settings_id_99,
t94.email_template_id AS email_template_id_100
FROM
portal_settings t0
LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id
LEFT JOIN onboarding_settings t94 ON t94.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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;
|
| 2 |
0.85 ms |
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;
|
| 3 |
1.55 ms |
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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters: [
"42231b0ff8a4775b3089cbe1746f32"
]
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.cart_additional_info AS cart_additional_info_13,
t0.portal_number_sb AS portal_number_sb_14,
t0.leading_color1 AS leading_color1_15,
t0.leading_color2 AS leading_color2_16,
t0.leading_color3 AS leading_color3_17,
t0.logo AS logo_18,
t0.contact_mail AS contact_mail_19,
t0.registration_additional_content AS registration_additional_content_20,
t0.login_additional_content AS login_additional_content_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.is_uniqskills_portal AS is_uniqskills_portal_24,
t0.is_netflix_portal AS is_netflix_portal_25,
t0.is_presale AS is_presale_26,
t0.is_simple_price AS is_simple_price_27,
t0.redirect_after_login AS redirect_after_login_28,
t0.message_after_login AS message_after_login_29,
t0.message_time_after_login AS message_time_after_login_30,
t0.device_auth_needed AS device_auth_needed_31,
t0.sender AS sender_32,
t0.is_cms_portal AS is_cms_portal_33,
t0.multi_access_from_max_user AS multi_access_from_max_user_34,
t0.enable_new_basket AS enable_new_basket_35,
t0.price_after_free_postage_cost AS price_after_free_postage_cost_36,
t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37,
t0.gtm AS gtm_38,
t0.password_additional_content AS password_additional_content_39,
t0.leading_color4 AS leading_color4_40,
t0.userbar_color AS userbar_color_41,
t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42,
t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43,
t0.userbar_html AS userbar_html_44,
t0.display_userbar2 AS display_userbar2_45,
t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46,
t0.test_userbar_html AS test_userbar_html_47,
t0.lifetime_access AS lifetime_access_48,
t0.fb_pixel_id AS fb_pixel_id_49,
t0.fb_pixel_access_token AS fb_pixel_access_token_50,
t0.hide_field_position AS hide_field_position_51,
t0.redirecting_to_focus AS redirecting_to_focus_52,
t0.show_gross_price AS show_gross_price_53,
t0.cs_mail AS cs_mail_54,
t0.is_phone_required AS is_phone_required_55,
t0.webe_mid_number AS webe_mid_number_56,
t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57,
t0.is_payment_before_confirmation AS is_payment_before_confirmation_58,
t0.payment_reward AS payment_reward_59,
t0.payment_reward_content AS payment_reward_content_60,
t0.payment_reward_deadline AS payment_reward_deadline_61,
t0.cart_template AS cart_template_62,
t0.use_cache_in_access AS use_cache_in_access_63,
t0.order_confirmation_additional_content AS order_confirmation_additional_content_64,
t0.additional_content_for_mail AS additional_content_for_mail_65,
t0.matomo_site_id AS matomo_site_id_66,
t0.positions_order AS positions_order_67,
t0.email_settings_id AS email_settings_id_68,
t0.order_type_id AS order_type_id_69,
t70.id AS id_71,
t70.ord_tran_prefix AS ord_tran_prefix_72,
t70.is_default AS is_default_73,
t70.use_sb AS use_sb_74,
t70.use_recaptcha_in_order AS use_recaptcha_in_order_75,
t70.hide_catalog AS hide_catalog_76,
t70.hide_nip_in_orders AS hide_nip_in_orders_77,
t70.show_only_regulations AS show_only_regulations_78,
t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79,
t70.facebook_event_type AS facebook_event_type_80,
t70.footer_copyright AS footer_copyright_81,
t70.contact_form_recipient AS contact_form_recipient_82,
t70.text_contact_thank_you AS text_contact_thank_you_83,
t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84,
t70.text_acceptance_regulations AS text_acceptance_regulations_85,
t70.text_voucher_regulations AS text_voucher_regulations_86,
t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87,
t70.created_at AS created_at_88,
t70.updated_at AS updated_at_89,
t70.portal_settings_id AS portal_settings_id_90,
t0.virtual_currency_id AS virtual_currency_id_91,
t0.default_payment_system_id AS default_payment_system_id_92,
t0.default_cart_client_type_id AS default_cart_client_type_id_93,
t94.id AS id_95,
t94.is_active AS is_active_96,
t94.poll_link AS poll_link_97,
t94.editorial_email AS editorial_email_98,
t94.portal_settings_id AS portal_settings_id_99,
t94.email_template_id AS email_template_id_100
FROM
portal_settings t0
LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id
LEFT JOIN onboarding_settings t94 ON t94.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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;
|
| 4 |
1.53 ms |
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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters: [
"42231b0ff8a4775b3089cbe1746f32"
]
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.cart_additional_info AS cart_additional_info_13,
t0.portal_number_sb AS portal_number_sb_14,
t0.leading_color1 AS leading_color1_15,
t0.leading_color2 AS leading_color2_16,
t0.leading_color3 AS leading_color3_17,
t0.logo AS logo_18,
t0.contact_mail AS contact_mail_19,
t0.registration_additional_content AS registration_additional_content_20,
t0.login_additional_content AS login_additional_content_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.is_uniqskills_portal AS is_uniqskills_portal_24,
t0.is_netflix_portal AS is_netflix_portal_25,
t0.is_presale AS is_presale_26,
t0.is_simple_price AS is_simple_price_27,
t0.redirect_after_login AS redirect_after_login_28,
t0.message_after_login AS message_after_login_29,
t0.message_time_after_login AS message_time_after_login_30,
t0.device_auth_needed AS device_auth_needed_31,
t0.sender AS sender_32,
t0.is_cms_portal AS is_cms_portal_33,
t0.multi_access_from_max_user AS multi_access_from_max_user_34,
t0.enable_new_basket AS enable_new_basket_35,
t0.price_after_free_postage_cost AS price_after_free_postage_cost_36,
t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37,
t0.gtm AS gtm_38,
t0.password_additional_content AS password_additional_content_39,
t0.leading_color4 AS leading_color4_40,
t0.userbar_color AS userbar_color_41,
t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42,
t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43,
t0.userbar_html AS userbar_html_44,
t0.display_userbar2 AS display_userbar2_45,
t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46,
t0.test_userbar_html AS test_userbar_html_47,
t0.lifetime_access AS lifetime_access_48,
t0.fb_pixel_id AS fb_pixel_id_49,
t0.fb_pixel_access_token AS fb_pixel_access_token_50,
t0.hide_field_position AS hide_field_position_51,
t0.redirecting_to_focus AS redirecting_to_focus_52,
t0.show_gross_price AS show_gross_price_53,
t0.cs_mail AS cs_mail_54,
t0.is_phone_required AS is_phone_required_55,
t0.webe_mid_number AS webe_mid_number_56,
t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57,
t0.is_payment_before_confirmation AS is_payment_before_confirmation_58,
t0.payment_reward AS payment_reward_59,
t0.payment_reward_content AS payment_reward_content_60,
t0.payment_reward_deadline AS payment_reward_deadline_61,
t0.cart_template AS cart_template_62,
t0.use_cache_in_access AS use_cache_in_access_63,
t0.order_confirmation_additional_content AS order_confirmation_additional_content_64,
t0.additional_content_for_mail AS additional_content_for_mail_65,
t0.matomo_site_id AS matomo_site_id_66,
t0.positions_order AS positions_order_67,
t0.email_settings_id AS email_settings_id_68,
t0.order_type_id AS order_type_id_69,
t70.id AS id_71,
t70.ord_tran_prefix AS ord_tran_prefix_72,
t70.is_default AS is_default_73,
t70.use_sb AS use_sb_74,
t70.use_recaptcha_in_order AS use_recaptcha_in_order_75,
t70.hide_catalog AS hide_catalog_76,
t70.hide_nip_in_orders AS hide_nip_in_orders_77,
t70.show_only_regulations AS show_only_regulations_78,
t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79,
t70.facebook_event_type AS facebook_event_type_80,
t70.footer_copyright AS footer_copyright_81,
t70.contact_form_recipient AS contact_form_recipient_82,
t70.text_contact_thank_you AS text_contact_thank_you_83,
t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84,
t70.text_acceptance_regulations AS text_acceptance_regulations_85,
t70.text_voucher_regulations AS text_voucher_regulations_86,
t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87,
t70.created_at AS created_at_88,
t70.updated_at AS updated_at_89,
t70.portal_settings_id AS portal_settings_id_90,
t0.virtual_currency_id AS virtual_currency_id_91,
t0.default_payment_system_id AS default_payment_system_id_92,
t0.default_cart_client_type_id AS default_cart_client_type_id_93,
t94.id AS id_95,
t94.is_active AS is_active_96,
t94.poll_link AS poll_link_97,
t94.editorial_email AS editorial_email_98,
t94.portal_settings_id AS portal_settings_id_99,
t94.email_template_id AS email_template_id_100
FROM
portal_settings t0
LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id
LEFT JOIN onboarding_settings t94 ON t94.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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;
|
| 5 |
1.57 ms |
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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters: [
"42231b0ff8a4775b3089cbe1746f32"
]
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.cart_additional_info AS cart_additional_info_13,
t0.portal_number_sb AS portal_number_sb_14,
t0.leading_color1 AS leading_color1_15,
t0.leading_color2 AS leading_color2_16,
t0.leading_color3 AS leading_color3_17,
t0.logo AS logo_18,
t0.contact_mail AS contact_mail_19,
t0.registration_additional_content AS registration_additional_content_20,
t0.login_additional_content AS login_additional_content_21,
t0.created_at AS created_at_22,
t0.updated_at AS updated_at_23,
t0.is_uniqskills_portal AS is_uniqskills_portal_24,
t0.is_netflix_portal AS is_netflix_portal_25,
t0.is_presale AS is_presale_26,
t0.is_simple_price AS is_simple_price_27,
t0.redirect_after_login AS redirect_after_login_28,
t0.message_after_login AS message_after_login_29,
t0.message_time_after_login AS message_time_after_login_30,
t0.device_auth_needed AS device_auth_needed_31,
t0.sender AS sender_32,
t0.is_cms_portal AS is_cms_portal_33,
t0.multi_access_from_max_user AS multi_access_from_max_user_34,
t0.enable_new_basket AS enable_new_basket_35,
t0.price_after_free_postage_cost AS price_after_free_postage_cost_36,
t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37,
t0.gtm AS gtm_38,
t0.password_additional_content AS password_additional_content_39,
t0.leading_color4 AS leading_color4_40,
t0.userbar_color AS userbar_color_41,
t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42,
t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43,
t0.userbar_html AS userbar_html_44,
t0.display_userbar2 AS display_userbar2_45,
t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46,
t0.test_userbar_html AS test_userbar_html_47,
t0.lifetime_access AS lifetime_access_48,
t0.fb_pixel_id AS fb_pixel_id_49,
t0.fb_pixel_access_token AS fb_pixel_access_token_50,
t0.hide_field_position AS hide_field_position_51,
t0.redirecting_to_focus AS redirecting_to_focus_52,
t0.show_gross_price AS show_gross_price_53,
t0.cs_mail AS cs_mail_54,
t0.is_phone_required AS is_phone_required_55,
t0.webe_mid_number AS webe_mid_number_56,
t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57,
t0.is_payment_before_confirmation AS is_payment_before_confirmation_58,
t0.payment_reward AS payment_reward_59,
t0.payment_reward_content AS payment_reward_content_60,
t0.payment_reward_deadline AS payment_reward_deadline_61,
t0.cart_template AS cart_template_62,
t0.use_cache_in_access AS use_cache_in_access_63,
t0.order_confirmation_additional_content AS order_confirmation_additional_content_64,
t0.additional_content_for_mail AS additional_content_for_mail_65,
t0.matomo_site_id AS matomo_site_id_66,
t0.positions_order AS positions_order_67,
t0.email_settings_id AS email_settings_id_68,
t0.order_type_id AS order_type_id_69,
t70.id AS id_71,
t70.ord_tran_prefix AS ord_tran_prefix_72,
t70.is_default AS is_default_73,
t70.use_sb AS use_sb_74,
t70.use_recaptcha_in_order AS use_recaptcha_in_order_75,
t70.hide_catalog AS hide_catalog_76,
t70.hide_nip_in_orders AS hide_nip_in_orders_77,
t70.show_only_regulations AS show_only_regulations_78,
t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79,
t70.facebook_event_type AS facebook_event_type_80,
t70.footer_copyright AS footer_copyright_81,
t70.contact_form_recipient AS contact_form_recipient_82,
t70.text_contact_thank_you AS text_contact_thank_you_83,
t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84,
t70.text_acceptance_regulations AS text_acceptance_regulations_85,
t70.text_voucher_regulations AS text_voucher_regulations_86,
t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87,
t70.created_at AS created_at_88,
t70.updated_at AS updated_at_89,
t70.portal_settings_id AS portal_settings_id_90,
t0.virtual_currency_id AS virtual_currency_id_91,
t0.default_payment_system_id AS default_payment_system_id_92,
t0.default_cart_client_type_id AS default_cart_client_type_id_93,
t94.id AS id_95,
t94.is_active AS is_active_96,
t94.poll_link AS poll_link_97,
t94.editorial_email AS editorial_email_98,
t94.portal_settings_id AS portal_settings_id_99,
t94.email_template_id AS email_template_id_100
FROM
portal_settings t0
LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id
LEFT JOIN onboarding_settings t94 ON t94.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.cart_additional_info AS cart_additional_info_13, t0.portal_number_sb AS portal_number_sb_14, t0.leading_color1 AS leading_color1_15, t0.leading_color2 AS leading_color2_16, t0.leading_color3 AS leading_color3_17, t0.logo AS logo_18, t0.contact_mail AS contact_mail_19, t0.registration_additional_content AS registration_additional_content_20, t0.login_additional_content AS login_additional_content_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.is_uniqskills_portal AS is_uniqskills_portal_24, t0.is_netflix_portal AS is_netflix_portal_25, t0.is_presale AS is_presale_26, t0.is_simple_price AS is_simple_price_27, t0.redirect_after_login AS redirect_after_login_28, t0.message_after_login AS message_after_login_29, t0.message_time_after_login AS message_time_after_login_30, t0.device_auth_needed AS device_auth_needed_31, t0.sender AS sender_32, t0.is_cms_portal AS is_cms_portal_33, t0.multi_access_from_max_user AS multi_access_from_max_user_34, t0.enable_new_basket AS enable_new_basket_35, t0.price_after_free_postage_cost AS price_after_free_postage_cost_36, t0.price_after_free_postage_cost_type AS price_after_free_postage_cost_type_37, t0.gtm AS gtm_38, t0.password_additional_content AS password_additional_content_39, t0.leading_color4 AS leading_color4_40, t0.userbar_color AS userbar_color_41, t0.is_bookcase_visible_in_userbar AS is_bookcase_visible_in_userbar_42, t0.is_shelf_visible_in_userbar AS is_shelf_visible_in_userbar_43, t0.userbar_html AS userbar_html_44, t0.display_userbar2 AS display_userbar2_45, t0.test_price_after_free_postage_cost AS test_price_after_free_postage_cost_46, t0.test_userbar_html AS test_userbar_html_47, t0.lifetime_access AS lifetime_access_48, t0.fb_pixel_id AS fb_pixel_id_49, t0.fb_pixel_access_token AS fb_pixel_access_token_50, t0.hide_field_position AS hide_field_position_51, t0.redirecting_to_focus AS redirecting_to_focus_52, t0.show_gross_price AS show_gross_price_53, t0.cs_mail AS cs_mail_54, t0.is_phone_required AS is_phone_required_55, t0.webe_mid_number AS webe_mid_number_56, t0.use_fb_pixel_in_iframe AS use_fb_pixel_in_iframe_57, t0.is_payment_before_confirmation AS is_payment_before_confirmation_58, t0.payment_reward AS payment_reward_59, t0.payment_reward_content AS payment_reward_content_60, t0.payment_reward_deadline AS payment_reward_deadline_61, t0.cart_template AS cart_template_62, t0.use_cache_in_access AS use_cache_in_access_63, t0.order_confirmation_additional_content AS order_confirmation_additional_content_64, t0.additional_content_for_mail AS additional_content_for_mail_65, t0.matomo_site_id AS matomo_site_id_66, t0.positions_order AS positions_order_67, t0.email_settings_id AS email_settings_id_68, t0.order_type_id AS order_type_id_69, t70.id AS id_71, t70.ord_tran_prefix AS ord_tran_prefix_72, t70.is_default AS is_default_73, t70.use_sb AS use_sb_74, t70.use_recaptcha_in_order AS use_recaptcha_in_order_75, t70.hide_catalog AS hide_catalog_76, t70.hide_nip_in_orders AS hide_nip_in_orders_77, t70.show_only_regulations AS show_only_regulations_78, t70.send_order_welcome_mail_only AS send_order_welcome_mail_only_79, t70.facebook_event_type AS facebook_event_type_80, t70.footer_copyright AS footer_copyright_81, t70.contact_form_recipient AS contact_form_recipient_82, t70.text_contact_thank_you AS text_contact_thank_you_83, t70.text_footer_cooperator_headers AS text_footer_cooperator_headers_84, t70.text_acceptance_regulations AS text_acceptance_regulations_85, t70.text_voucher_regulations AS text_voucher_regulations_86, t70.text_consent_processing_personal_data AS text_consent_processing_personal_data_87, t70.created_at AS created_at_88, t70.updated_at AS updated_at_89, t70.portal_settings_id AS portal_settings_id_90, t0.virtual_currency_id AS virtual_currency_id_91, t0.default_payment_system_id AS default_payment_system_id_92, t0.default_cart_client_type_id AS default_cart_client_type_id_93, t94.id AS id_95, t94.is_active AS is_active_96, t94.poll_link AS poll_link_97, t94.editorial_email AS editorial_email_98, t94.portal_settings_id AS portal_settings_id_99, t94.email_template_id AS email_template_id_100 FROM portal_settings t0 LEFT JOIN fm_company_settings t70 ON t70.portal_settings_id = t0.id LEFT JOIN onboarding_settings t94 ON t94.portal_settings_id = t0.id WHERE t0.hash = '42231b0ff8a4775b3089cbe1746f32' LIMIT 1;
|
| 6 |
8.83 ms |
SELECT s0_.id AS id_0, s0_.is_active AS is_active_1, s0_.item_order AS item_order_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.type AS type_5, s0_.body AS body_6, s0_.show_on_main_page AS show_on_main_page_7, s0_.show_in_box_list AS show_in_box_list_8, s0_.meta_title AS meta_title_9, s0_.meta_description AS meta_description_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.portal_settings_id AS portal_settings_id_13, s0_.language_id AS language_id_14, s0_.category_id AS category_id_15, s0_.course_id AS course_id_16 FROM static_page s0_ LEFT JOIN portal_settings p1_ ON s0_.portal_settings_id = p1_.id LEFT JOIN language l2_ ON s0_.language_id = l2_.id WHERE p1_.id = ? AND l2_.code = ?
SELECT s0_.id AS id_0, s0_.is_active AS is_active_1, s0_.item_order AS item_order_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.type AS type_5, s0_.body AS body_6, s0_.show_on_main_page AS show_on_main_page_7, s0_.show_in_box_list AS show_in_box_list_8, s0_.meta_title AS meta_title_9, s0_.meta_description AS meta_description_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.portal_settings_id AS portal_settings_id_13, s0_.language_id AS language_id_14, s0_.category_id AS category_id_15, s0_.course_id AS course_id_16 FROM static_page s0_ LEFT JOIN portal_settings p1_ ON s0_.portal_settings_id = p1_.id LEFT JOIN language l2_ ON s0_.language_id = l2_.id WHERE p1_.id = 113 AND l2_.code = 'pl';
|
| 7 |
0.97 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6, t0.ioc AS ioc_7, t0.emoji AS emoji_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.currency_id AS currency_id_11, t0.language_id AS language_id_12, t0.continent_id AS continent_id_13, t14.id AS id_15, t14.isActive AS isActive_16, t14.euMember AS euMember_17, t14.signBeforePrice AS signBeforePrice_18, t14.signAfterPrice AS signAfterPrice_19, t14.price_currency AS price_currency_20, t14.vat_rate_b2b AS vat_rate_b2b_21, t14.vat_rate_b2c AS vat_rate_b2c_22, t14.payment_method_online_description AS payment_method_online_description_23, t14.payment_method_offline_description AS payment_method_offline_description_24, t14.link_to_payment_instructions AS link_to_payment_instructions_25, t14.braintree_merchant AS braintree_merchant_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.online_payment_label AS online_payment_label_29, t14.logo_filename AS logo_filename_30, t14.country_id AS country_id_31 FROM country t0 LEFT JOIN country_settings t14 ON t14.country_id = t0.id WHERE t0.alpha2 = ? LIMIT 1
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.slug AS slug_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6, t0.ioc AS ioc_7, t0.emoji AS emoji_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.currency_id AS currency_id_11, t0.language_id AS language_id_12, t0.continent_id AS continent_id_13, t14.id AS id_15, t14.isActive AS isActive_16, t14.euMember AS euMember_17, t14.signBeforePrice AS signBeforePrice_18, t14.signAfterPrice AS signAfterPrice_19, t14.price_currency AS price_currency_20, t14.vat_rate_b2b AS vat_rate_b2b_21, t14.vat_rate_b2c AS vat_rate_b2c_22, t14.payment_method_online_description AS payment_method_online_description_23, t14.payment_method_offline_description AS payment_method_offline_description_24, t14.link_to_payment_instructions AS link_to_payment_instructions_25, t14.braintree_merchant AS braintree_merchant_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.online_payment_label AS online_payment_label_29, t14.logo_filename AS logo_filename_30, t14.country_id AS country_id_31 FROM country t0 LEFT JOIN country_settings t14 ON t14.country_id = t0.id WHERE t0.alpha2 = ':443' LIMIT 1;
|
| 8 |
0.42 ms |
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 WHERE t0.code = ? 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 WHERE t0.code = ':443' LIMIT 1;
|
| 9 |
0.81 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.on_main_page AS on_main_page_3, t0.visible_in_footer AS visible_in_footer_4, t0.name AS name_5, t0.slug AS slug_6, t0.link AS link_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.not_for_uniqskills AS not_for_uniqskills_11, t0.nip AS nip_12 FROM cooperator t0 WHERE t0.visible_in_footer = ? AND t0.not_for_uniqskills = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.on_main_page AS on_main_page_3, t0.visible_in_footer AS visible_in_footer_4, t0.name AS name_5, t0.slug AS slug_6, t0.link AS link_7, t0.image_name AS image_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.not_for_uniqskills AS not_for_uniqskills_11, t0.nip AS nip_12 FROM cooperator t0 WHERE t0.visible_in_footer = 1 AND t0.not_for_uniqskills = 0;
|