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.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 = 'US' LIMIT 1;

SELECT
  c.id
FROM
  category c
  LEFT JOIN language l ON c.language_id = l.id
WHERE
  l.code = ?
  AND c.is_active = 1
  AND c.parent_id IS NULL
  AND (
    (
      SELECT
        COUNT(1)
      FROM
        course categoryCourses
      WHERE
        categoryCourses.portal_settings_id = ?
        AND categoryCourses.category_id = c.id
        AND categoryCourses.is_active = TRUE
        AND (
          (
            CURRENT_DATE() < categoryCourses.hide_after
            OR categoryCourses.hide_after IS NULL
          )
          OR (
            categoryCourses.is_active = false
            AND categoryCourses.id IN (NULL)
          )
        )
      GROUP BY
        categoryCourses.category_id
    ) > 0
    OR (
      SELECT
        COUNT(1)
      FROM
        courses_additional_categories cac
        INNER JOIN course categoryAdditionalCourses ON categoryAdditionalCourses.id = cac.course_id
      WHERE
        cac.category_id = c.id
        AND categoryAdditionalCourses.portal_settings_id = ?
        AND categoryAdditionalCourses.is_active = TRUE
        AND (
          (
            CURRENT_DATE() < categoryAdditionalCourses.hide_after
            OR categoryAdditionalCourses.hide_after IS NULL
          )
          OR (
            categoryAdditionalCourses.is_active = false
            AND categoryAdditionalCourses.id IN (NULL)
          )
        )
      GROUP BY
        categoryAdditionalCourses.category_id
    ) > 0
    OR (
      SELECT
        COUNT(1)
      FROM
        category childrenCategory
        INNER JOIN course childrenCourses ON childrenCategory.id = childrenCourses.category_id
      WHERE
        childrenCategory.parent_id = c.id
        AND childrenCourses.portal_settings_id = ?
        AND childrenCourses.is_active = TRUE
        AND (
          (
            CURRENT_DATE() < childrenCourses.hide_after
            OR childrenCourses.hide_after IS NULL
          )
          OR (
            childrenCourses.is_active = false
            AND childrenCourses.id IN (NULL)
          )
        )
      GROUP BY
        childrenCategory.parent_id
    ) > 0
    OR (
      SELECT
        COUNT(1)
      FROM
        category childrenCategory
        INNER JOIN courses_additional_categories childrencac ON childrenCategory.id = childrencac.category_id
        INNER JOIN course childrenAdditionalCourses ON childrencac.course_id = childrenAdditionalCourses.id
      WHERE
        childrenCategory.parent_id = c.id
        AND childrenAdditionalCourses.portal_settings_id = ?
        AND childrenAdditionalCourses.is_active = TRUE
        AND (
          (
            CURRENT_DATE() < childrenAdditionalCourses.hide_after
            OR childrenAdditionalCourses.hide_after IS NULL
          )
          OR (
            childrenAdditionalCourses.is_active = false
            AND childrenAdditionalCourses.id IN (NULL)
          )
        )
      GROUP BY
        childrenCategory.parent_id
    )
  )
ORDER BY
  c.position ASC

SELECT 
                        c.id
                    FROM
                        category c
                            LEFT JOIN
                        language l ON c.language_id = l.id
                    WHERE
                        l.code = 'phpinfo' AND c.is_active = 1
                            AND c.parent_id IS NULL
                            AND ((SELECT 
                                COUNT(1)
                            FROM
                                course categoryCourses
                            WHERE
                                categoryCourses.portal_settings_id = 113
                                    AND categoryCourses.category_id = c.id
                                    AND categoryCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < categoryCourses.hide_after
                                            OR categoryCourses.hide_after IS NULL)
                                                OR
                                        ( categoryCourses.is_active = false
                                          AND categoryCourses.id IN (NULL)
                                        ))
                            GROUP BY categoryCourses.category_id) > 0
                            OR (SELECT 
                                COUNT(1)
                            FROM
                                courses_additional_categories cac
                                    INNER JOIN
                                course categoryAdditionalCourses ON categoryAdditionalCourses.id = cac.course_id
                            WHERE
                                cac.category_id = c.id
                                    AND categoryAdditionalCourses.portal_settings_id = 113
                                    AND categoryAdditionalCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < categoryAdditionalCourses.hide_after
                                            OR categoryAdditionalCourses.hide_after IS NULL)
                                                OR
                                        ( categoryAdditionalCourses.is_active = false
                                          AND categoryAdditionalCourses.id IN (NULL)
                                        ))
                            GROUP BY categoryAdditionalCourses.category_id) > 0
                            OR (SELECT 
                                COUNT(1)
                            FROM
                                category childrenCategory
                                    INNER JOIN
                                course childrenCourses ON childrenCategory.id = childrenCourses.category_id
                            WHERE
                                childrenCategory.parent_id = c.id
                                    AND childrenCourses.portal_settings_id = 113
                                    AND childrenCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < childrenCourses.hide_after
                                            OR childrenCourses.hide_after IS NULL)
                                                OR
                                        (childrenCourses.is_active = false
                                         AND childrenCourses.id IN (NULL)
                                        ))
                            GROUP BY childrenCategory.parent_id) > 0
                            OR (SELECT 
                                COUNT(1)
                            FROM
                                category childrenCategory
                                    INNER JOIN
                                courses_additional_categories childrencac ON childrenCategory.id = childrencac.category_id
                                    INNER JOIN
                                course childrenAdditionalCourses ON childrencac.course_id = childrenAdditionalCourses.id
                            WHERE
                                childrenCategory.parent_id = c.id
                                    AND childrenAdditionalCourses.portal_settings_id = 113
                                    AND childrenAdditionalCourses.is_active = TRUE
                                    AND ((CURRENT_DATE() < childrenAdditionalCourses.hide_after
                                         OR childrenAdditionalCourses.hide_after IS NULL)
                                                OR
                                        (childrenAdditionalCourses.is_active = false
                                         AND childrenAdditionalCourses.id IN (NULL)
                                        ))
                            GROUP BY childrenCategory.parent_id))
                    ORDER BY c.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.is_active AS is_active_1,
  c0_.is_premium AS is_premium_2,
  c0_.name AS name_3,
  c0_.short_body AS short_body_4,
  c0_.slug AS slug_5,
  c0_.default_price AS default_price_6,
  c0_.duration_hours AS duration_hours_7,
  c0_.duration_months AS duration_months_8,
  c0_.inscriptions AS inscriptions_9,
  c0_.product_for_cos AS product_for_cos_10,
  c0_.filepath AS filepath_11,
  c0_.is_continuous AS is_continuous_12,
  c0_.share_date AS share_date_13,
  c0_.meta_title AS meta_title_14,
  c0_.meta_description AS meta_description_15,
  c0_.landing_page AS landing_page_16,
  c0_.action_number AS action_number_17,
  c0_.from_source AS from_source_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.hide_after AS hide_after_21,
  c0_.start_date AS start_date_22,
  c0_.all_lessons_access AS all_lessons_access_23,
  c0_.is_no_index AS is_no_index_24,
  c0_.is_orbico_agreement AS is_orbico_agreement_25,
  c0_.is_partner_agreement AS is_partner_agreement_26,
  c0_.is_online_conference AS is_online_conference_27,
  c0_.image_name AS image_name_28,
  c0_.ad_image_name AS ad_image_name_29,
  c0_.ad_redirect_to_url AS ad_redirect_to_url_30,
  c0_.ad_start_date AS ad_start_date_31,
  c0_.ad_end_date AS ad_end_date_32,
  c0_.module_background_image_name AS module_background_image_name_33,
  c0_.redirect_to_url AS redirect_to_url_34,
  c0_.catalog_position AS catalog_position_35,
  c0_.duration_weeks AS duration_weeks_36,
  c0_.duration_per_week AS duration_per_week_37,
  c0_.has_medical_content AS has_medical_content_38,
  - c0_.catalog_position AS sclr_39,
  c0_.next_course_id AS next_course_id_40,
  c0_.main_keyword_id AS main_keyword_id_41,
  c0_.course_type_id AS course_type_id_42,
  c0_.category_id AS category_id_43,
  c0_.cooperator_id AS cooperator_id_44,
  c0_.portal_settings_id AS portal_settings_id_45,
  c0_.original_course_id AS original_course_id_46
FROM
  course c0_
  LEFT JOIN category c1_ ON c0_.category_id = c1_.id
  LEFT JOIN language l2_ ON c1_.language_id = l2_.id
  LEFT JOIN course_type c3_ ON c0_.course_type_id = c3_.id
WHERE
  c0_.original_course_id IS NULL
  AND c0_.portal_settings_id = ?
  AND l2_.code = (?)
  AND (
    (
      c0_.is_active = (?)
      OR (
        c0_.is_active = 0
        AND c0_.id IN (NULL)
      )
    )
  )
  AND (
    (
      CURRENT_DATE < c0_.hide_after
      OR c0_.hide_after IS NULL
    )
  )
ORDER BY
  sclr_39 DESC,
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.is_active AS is_active_1, c0_.is_premium AS is_premium_2, c0_.name AS name_3, c0_.short_body AS short_body_4, c0_.slug AS slug_5, c0_.default_price AS default_price_6, c0_.duration_hours AS duration_hours_7, c0_.duration_months AS duration_months_8, c0_.inscriptions AS inscriptions_9, c0_.product_for_cos AS product_for_cos_10, c0_.filepath AS filepath_11, c0_.is_continuous AS is_continuous_12, c0_.share_date AS share_date_13, c0_.meta_title AS meta_title_14, c0_.meta_description AS meta_description_15, c0_.landing_page AS landing_page_16, c0_.action_number AS action_number_17, c0_.from_source AS from_source_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.hide_after AS hide_after_21, c0_.start_date AS start_date_22, c0_.all_lessons_access AS all_lessons_access_23, c0_.is_no_index AS is_no_index_24, c0_.is_orbico_agreement AS is_orbico_agreement_25, c0_.is_partner_agreement AS is_partner_agreement_26, c0_.is_online_conference AS is_online_conference_27, c0_.image_name AS image_name_28, c0_.ad_image_name AS ad_image_name_29, c0_.ad_redirect_to_url AS ad_redirect_to_url_30, c0_.ad_start_date AS ad_start_date_31, c0_.ad_end_date AS ad_end_date_32, c0_.module_background_image_name AS module_background_image_name_33, c0_.redirect_to_url AS redirect_to_url_34, c0_.catalog_position AS catalog_position_35, c0_.duration_weeks AS duration_weeks_36, c0_.duration_per_week AS duration_per_week_37, c0_.has_medical_content AS has_medical_content_38, -c0_.catalog_position AS sclr_39, c0_.next_course_id AS next_course_id_40, c0_.main_keyword_id AS main_keyword_id_41, c0_.course_type_id AS course_type_id_42, c0_.category_id AS category_id_43, c0_.cooperator_id AS cooperator_id_44, c0_.portal_settings_id AS portal_settings_id_45, c0_.original_course_id AS original_course_id_46 FROM course c0_ LEFT JOIN category c1_ ON c0_.category_id = c1_.id LEFT JOIN language l2_ ON c1_.language_id = l2_.id LEFT JOIN course_type c3_ ON c0_.course_type_id = c3_.id WHERE c0_.original_course_id IS NULL AND c0_.portal_settings_id = 113 AND l2_.code = ('phpinfo') AND ((c0_.is_active = (1) OR (c0_.is_active = 0 AND c0_.id IN (NULL)))) AND ((CURRENT_DATE < c0_.hide_after OR c0_.hide_after IS NULL)) ORDER BY sclr_39 DESC, c0_.id DESC;

SELECT
  DISTINCT c0_.name AS name_0
FROM
  course_keyword c0_
  LEFT JOIN course c1_ ON c0_.id = c1_.main_keyword_id
  LEFT JOIN courses_additional_keywords c3_ ON c0_.id = c3_.course_keyword_id
  LEFT JOIN course c2_ ON c2_.id = c3_.course_id
  LEFT JOIN category c4_ ON c1_.category_id = c4_.id
  LEFT JOIN category c5_ ON c2_.category_id = c5_.id
  LEFT JOIN language l6_ ON c4_.language_id = l6_.id
  LEFT JOIN language l7_ ON c5_.language_id = l7_.id
WHERE
  l6_.code = ?
  OR l7_.code = ?

SELECT DISTINCT c0_.name AS name_0 FROM course_keyword c0_ LEFT JOIN course c1_ ON c0_.id = c1_.main_keyword_id LEFT JOIN courses_additional_keywords c3_ ON c0_.id = c3_.course_keyword_id LEFT JOIN course c2_ ON c2_.id = c3_.course_id LEFT JOIN category c4_ ON c1_.category_id = c4_.id LEFT JOIN category c5_ ON c2_.category_id = c5_.id LEFT JOIN language l6_ ON c4_.language_id = l6_.id LEFT JOIN language l7_ ON c5_.language_id = l7_.id WHERE l6_.code = 'phpinfo' OR l7_.code = 'phpinfo';

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.short_body AS short_body_3,
  t0.body AS body_4,
  t0.testimonials_custom AS testimonials_custom_5,
  t0.category_name AS category_name_6,
  t0.category_slug AS category_slug_7,
  t0.position AS position_8,
  t0.image_name AS image_name_9,
  t0.banner_name AS banner_name_10,
  t0.banner_link AS banner_link_11,
  t0.banner_html AS banner_html_12,
  t0.updated_at AS updated_at_13,
  t0.default_for_us AS default_for_us_14,
  t0.parent_id AS parent_id_15,
  t16.id AS id_17,
  t16.is_active AS is_active_18,
  t16.name AS name_19,
  t16.portal_settings_id AS portal_settings_id_20,
  t16.category_id AS category_id_21,
  t16.product_association_id AS product_association_id_22,
  t16.product_main_type_id AS product_main_type_id_23,
  t16.template_type_id AS template_type_id_24,
  t0.portal_settings_id AS portal_settings_id_25,
  t0.recommended_product_association_id AS recommended_product_association_id_26,
  t0.language_id AS language_id_27,
  t28.id AS id_29,
  t28.is_active AS is_active_30,
  t28.name AS name_31,
  t28.native AS native_32,
  t28.slug AS slug_33,
  t28.code AS code_34,
  t28.short AS short_35,
  t28.created_at AS created_at_36,
  t28.updated_at AS updated_at_37,
  t38.id AS id_39,
  t38.title AS title_40,
  t38.description AS description_41,
  t38.head_scripts AS head_scripts_42,
  t38.body_scripts AS body_scripts_43,
  t38.created_at AS created_at_44,
  t38.updated_at AS updated_at_45,
  t38.product_association_id AS product_association_id_46,
  t38.category_id AS category_id_47,
  t38.template_type_id AS template_type_id_48
FROM
  category t0
  LEFT JOIN templates t16 ON t16.category_id = t0.id
  LEFT JOIN language t28 ON t0.language_id = t28.id
  LEFT JOIN meta_tags t38 ON t38.category_id = t0.id
WHERE
  t0.category_slug IS NULL
  AND t0.portal_settings_id = ?
  AND t0.is_active = ?
LIMIT
  1