1
2.99 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 . 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
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 . 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
Copy
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 ;
Copy
2
0.99 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 ;
Copy
3
1.72 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 . 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
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 . 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
Copy
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 ;
Copy
4
1.13 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 = 'US' LIMIT 1 ;
Copy
5
2.22 ms
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
Parameters :
[
"phpinfo "
113
113
113
113
]
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 ;
Copy
6
2.16 ms
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
Parameters :
[
113
"phpinfo "
1
]
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
Copy
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 ;
Copy
7
0.87 ms
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 = ?
Parameters :
[
"phpinfo "
"phpinfo "
]
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' ;
Copy
8
0.96 ms
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
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
Copy
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 = 113 AND t0 . is_active = 1 LIMIT 1 ;
Copy