158.18 ms
(28.99%)
|
82 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id WHERE t0.category_id = ?
SELECT
t0.id AS id_1,
t0.is_active AS is_active_2,
t0.is_premium AS is_premium_3,
t0.name AS name_4,
t0.short_body AS short_body_5,
t0.slug AS slug_6,
t0.default_price AS default_price_7,
t0.duration_hours AS duration_hours_8,
t0.duration_months AS duration_months_9,
t0.inscriptions AS inscriptions_10,
t0.product_for_cos AS product_for_cos_11,
t0.filepath AS filepath_12,
t0.is_continuous AS is_continuous_13,
t0.share_date AS share_date_14,
t0.meta_title AS meta_title_15,
t0.meta_description AS meta_description_16,
t0.landing_page AS landing_page_17,
t0.action_number AS action_number_18,
t0.from_source AS from_source_19,
t0.created_at AS created_at_20,
t0.updated_at AS updated_at_21,
t0.hide_after AS hide_after_22,
t0.start_date AS start_date_23,
t0.all_lessons_access AS all_lessons_access_24,
t0.is_no_index AS is_no_index_25,
t0.is_orbico_agreement AS is_orbico_agreement_26,
t0.is_partner_agreement AS is_partner_agreement_27,
t0.is_online_conference AS is_online_conference_28,
t0.image_name AS image_name_29,
t0.ad_image_name AS ad_image_name_30,
t0.ad_redirect_to_url AS ad_redirect_to_url_31,
t0.ad_start_date AS ad_start_date_32,
t0.ad_end_date AS ad_end_date_33,
t0.module_background_image_name AS module_background_image_name_34,
t0.redirect_to_url AS redirect_to_url_35,
t0.catalog_position AS catalog_position_36,
t0.duration_weeks AS duration_weeks_37,
t0.duration_per_week AS duration_per_week_38,
t0.has_medical_content AS has_medical_content_39,
t0.next_course_id AS next_course_id_40,
t0.main_keyword_id AS main_keyword_id_41,
t42.id AS id_43,
t42.is_active AS is_active_44,
t42.custom_scripts AS custom_scripts_45,
t42.template AS template_46,
t42.created_at AS created_at_47,
t42.updated_at AS updated_at_48,
t42.course_id AS course_id_49,
t0.course_type_id AS course_type_id_50,
t0.category_id AS category_id_51,
t0.cooperator_id AS cooperator_id_52,
t0.portal_settings_id AS portal_settings_id_53,
t54.id AS id_55,
t54.name AS name_56,
t54.page_orientation_landscape AS page_orientation_landscape_57,
t54.pdf_name AS pdf_name_58,
t54.created_at AS created_at_59,
t54.updated_at AS updated_at_60,
t54.course_id AS course_id_61,
t62.id AS id_63,
t62.is_active AS is_active_64,
t62.is_premium AS is_premium_65,
t62.name AS name_66,
t62.short_body AS short_body_67,
t62.slug AS slug_68,
t62.default_price AS default_price_69,
t62.duration_hours AS duration_hours_70,
t62.duration_months AS duration_months_71,
t62.inscriptions AS inscriptions_72,
t62.product_for_cos AS product_for_cos_73,
t62.filepath AS filepath_74,
t62.is_continuous AS is_continuous_75,
t62.share_date AS share_date_76,
t62.meta_title AS meta_title_77,
t62.meta_description AS meta_description_78,
t62.landing_page AS landing_page_79,
t62.action_number AS action_number_80,
t62.from_source AS from_source_81,
t62.created_at AS created_at_82,
t62.updated_at AS updated_at_83,
t62.hide_after AS hide_after_84,
t62.start_date AS start_date_85,
t62.all_lessons_access AS all_lessons_access_86,
t62.is_no_index AS is_no_index_87,
t62.is_orbico_agreement AS is_orbico_agreement_88,
t62.is_partner_agreement AS is_partner_agreement_89,
t62.is_online_conference AS is_online_conference_90,
t62.image_name AS image_name_91,
t62.ad_image_name AS ad_image_name_92,
t62.ad_redirect_to_url AS ad_redirect_to_url_93,
t62.ad_start_date AS ad_start_date_94,
t62.ad_end_date AS ad_end_date_95,
t62.module_background_image_name AS module_background_image_name_96,
t62.redirect_to_url AS redirect_to_url_97,
t62.catalog_position AS catalog_position_98,
t62.duration_weeks AS duration_weeks_99,
t62.duration_per_week AS duration_per_week_100,
t62.has_medical_content AS has_medical_content_101,
t62.next_course_id AS next_course_id_102,
t62.main_keyword_id AS main_keyword_id_103,
t62.course_type_id AS course_type_id_104,
t62.category_id AS category_id_105,
t62.cooperator_id AS cooperator_id_106,
t62.portal_settings_id AS portal_settings_id_107,
t62.original_course_id AS original_course_id_108,
t0.original_course_id AS original_course_id_109
FROM
course t0
LEFT JOIN landing t42 ON t42.course_id = t0.id
LEFT JOIN voucher t54 ON t54.course_id = t0.id
LEFT JOIN course t62 ON t62.original_course_id = t0.id
WHERE
t0.category_id = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id WHERE t0.category_id = 95;
|
128.29 ms
(23.51%)
|
82 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id INNER JOIN courses_additional_categories ON t0.id = courses_additional_categories.course_id WHERE courses_additional_categories.category_id = ?
SELECT
t0.id AS id_1,
t0.is_active AS is_active_2,
t0.is_premium AS is_premium_3,
t0.name AS name_4,
t0.short_body AS short_body_5,
t0.slug AS slug_6,
t0.default_price AS default_price_7,
t0.duration_hours AS duration_hours_8,
t0.duration_months AS duration_months_9,
t0.inscriptions AS inscriptions_10,
t0.product_for_cos AS product_for_cos_11,
t0.filepath AS filepath_12,
t0.is_continuous AS is_continuous_13,
t0.share_date AS share_date_14,
t0.meta_title AS meta_title_15,
t0.meta_description AS meta_description_16,
t0.landing_page AS landing_page_17,
t0.action_number AS action_number_18,
t0.from_source AS from_source_19,
t0.created_at AS created_at_20,
t0.updated_at AS updated_at_21,
t0.hide_after AS hide_after_22,
t0.start_date AS start_date_23,
t0.all_lessons_access AS all_lessons_access_24,
t0.is_no_index AS is_no_index_25,
t0.is_orbico_agreement AS is_orbico_agreement_26,
t0.is_partner_agreement AS is_partner_agreement_27,
t0.is_online_conference AS is_online_conference_28,
t0.image_name AS image_name_29,
t0.ad_image_name AS ad_image_name_30,
t0.ad_redirect_to_url AS ad_redirect_to_url_31,
t0.ad_start_date AS ad_start_date_32,
t0.ad_end_date AS ad_end_date_33,
t0.module_background_image_name AS module_background_image_name_34,
t0.redirect_to_url AS redirect_to_url_35,
t0.catalog_position AS catalog_position_36,
t0.duration_weeks AS duration_weeks_37,
t0.duration_per_week AS duration_per_week_38,
t0.has_medical_content AS has_medical_content_39,
t0.next_course_id AS next_course_id_40,
t0.main_keyword_id AS main_keyword_id_41,
t42.id AS id_43,
t42.is_active AS is_active_44,
t42.custom_scripts AS custom_scripts_45,
t42.template AS template_46,
t42.created_at AS created_at_47,
t42.updated_at AS updated_at_48,
t42.course_id AS course_id_49,
t0.course_type_id AS course_type_id_50,
t0.category_id AS category_id_51,
t0.cooperator_id AS cooperator_id_52,
t0.portal_settings_id AS portal_settings_id_53,
t54.id AS id_55,
t54.name AS name_56,
t54.page_orientation_landscape AS page_orientation_landscape_57,
t54.pdf_name AS pdf_name_58,
t54.created_at AS created_at_59,
t54.updated_at AS updated_at_60,
t54.course_id AS course_id_61,
t62.id AS id_63,
t62.is_active AS is_active_64,
t62.is_premium AS is_premium_65,
t62.name AS name_66,
t62.short_body AS short_body_67,
t62.slug AS slug_68,
t62.default_price AS default_price_69,
t62.duration_hours AS duration_hours_70,
t62.duration_months AS duration_months_71,
t62.inscriptions AS inscriptions_72,
t62.product_for_cos AS product_for_cos_73,
t62.filepath AS filepath_74,
t62.is_continuous AS is_continuous_75,
t62.share_date AS share_date_76,
t62.meta_title AS meta_title_77,
t62.meta_description AS meta_description_78,
t62.landing_page AS landing_page_79,
t62.action_number AS action_number_80,
t62.from_source AS from_source_81,
t62.created_at AS created_at_82,
t62.updated_at AS updated_at_83,
t62.hide_after AS hide_after_84,
t62.start_date AS start_date_85,
t62.all_lessons_access AS all_lessons_access_86,
t62.is_no_index AS is_no_index_87,
t62.is_orbico_agreement AS is_orbico_agreement_88,
t62.is_partner_agreement AS is_partner_agreement_89,
t62.is_online_conference AS is_online_conference_90,
t62.image_name AS image_name_91,
t62.ad_image_name AS ad_image_name_92,
t62.ad_redirect_to_url AS ad_redirect_to_url_93,
t62.ad_start_date AS ad_start_date_94,
t62.ad_end_date AS ad_end_date_95,
t62.module_background_image_name AS module_background_image_name_96,
t62.redirect_to_url AS redirect_to_url_97,
t62.catalog_position AS catalog_position_98,
t62.duration_weeks AS duration_weeks_99,
t62.duration_per_week AS duration_per_week_100,
t62.has_medical_content AS has_medical_content_101,
t62.next_course_id AS next_course_id_102,
t62.main_keyword_id AS main_keyword_id_103,
t62.course_type_id AS course_type_id_104,
t62.category_id AS category_id_105,
t62.cooperator_id AS cooperator_id_106,
t62.portal_settings_id AS portal_settings_id_107,
t62.original_course_id AS original_course_id_108,
t0.original_course_id AS original_course_id_109
FROM
course t0
LEFT JOIN landing t42 ON t42.course_id = t0.id
LEFT JOIN voucher t54 ON t54.course_id = t0.id
LEFT JOIN course t62 ON t62.original_course_id = t0.id
INNER JOIN courses_additional_categories ON t0.id = courses_additional_categories.course_id
WHERE
courses_additional_categories.category_id = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id INNER JOIN courses_additional_categories ON t0.id = courses_additional_categories.course_id WHERE courses_additional_categories.category_id = 95;
|
70.96 ms
(13.01%)
|
41 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.custom_scripts AS custom_scripts_3, t0.template AS template_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.course_id AS course_id_7 FROM landing t0 WHERE t0.course_id = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.custom_scripts AS custom_scripts_3, t0.template AS template_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.course_id AS course_id_7 FROM landing t0 WHERE t0.course_id = 783;
|
64.38 ms
(11.80%)
|
41 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id WHERE t0.original_course_id = ?
SELECT
t0.id AS id_1,
t0.is_active AS is_active_2,
t0.is_premium AS is_premium_3,
t0.name AS name_4,
t0.short_body AS short_body_5,
t0.slug AS slug_6,
t0.default_price AS default_price_7,
t0.duration_hours AS duration_hours_8,
t0.duration_months AS duration_months_9,
t0.inscriptions AS inscriptions_10,
t0.product_for_cos AS product_for_cos_11,
t0.filepath AS filepath_12,
t0.is_continuous AS is_continuous_13,
t0.share_date AS share_date_14,
t0.meta_title AS meta_title_15,
t0.meta_description AS meta_description_16,
t0.landing_page AS landing_page_17,
t0.action_number AS action_number_18,
t0.from_source AS from_source_19,
t0.created_at AS created_at_20,
t0.updated_at AS updated_at_21,
t0.hide_after AS hide_after_22,
t0.start_date AS start_date_23,
t0.all_lessons_access AS all_lessons_access_24,
t0.is_no_index AS is_no_index_25,
t0.is_orbico_agreement AS is_orbico_agreement_26,
t0.is_partner_agreement AS is_partner_agreement_27,
t0.is_online_conference AS is_online_conference_28,
t0.image_name AS image_name_29,
t0.ad_image_name AS ad_image_name_30,
t0.ad_redirect_to_url AS ad_redirect_to_url_31,
t0.ad_start_date AS ad_start_date_32,
t0.ad_end_date AS ad_end_date_33,
t0.module_background_image_name AS module_background_image_name_34,
t0.redirect_to_url AS redirect_to_url_35,
t0.catalog_position AS catalog_position_36,
t0.duration_weeks AS duration_weeks_37,
t0.duration_per_week AS duration_per_week_38,
t0.has_medical_content AS has_medical_content_39,
t0.next_course_id AS next_course_id_40,
t0.main_keyword_id AS main_keyword_id_41,
t42.id AS id_43,
t42.is_active AS is_active_44,
t42.custom_scripts AS custom_scripts_45,
t42.template AS template_46,
t42.created_at AS created_at_47,
t42.updated_at AS updated_at_48,
t42.course_id AS course_id_49,
t0.course_type_id AS course_type_id_50,
t0.category_id AS category_id_51,
t0.cooperator_id AS cooperator_id_52,
t0.portal_settings_id AS portal_settings_id_53,
t54.id AS id_55,
t54.name AS name_56,
t54.page_orientation_landscape AS page_orientation_landscape_57,
t54.pdf_name AS pdf_name_58,
t54.created_at AS created_at_59,
t54.updated_at AS updated_at_60,
t54.course_id AS course_id_61,
t62.id AS id_63,
t62.is_active AS is_active_64,
t62.is_premium AS is_premium_65,
t62.name AS name_66,
t62.short_body AS short_body_67,
t62.slug AS slug_68,
t62.default_price AS default_price_69,
t62.duration_hours AS duration_hours_70,
t62.duration_months AS duration_months_71,
t62.inscriptions AS inscriptions_72,
t62.product_for_cos AS product_for_cos_73,
t62.filepath AS filepath_74,
t62.is_continuous AS is_continuous_75,
t62.share_date AS share_date_76,
t62.meta_title AS meta_title_77,
t62.meta_description AS meta_description_78,
t62.landing_page AS landing_page_79,
t62.action_number AS action_number_80,
t62.from_source AS from_source_81,
t62.created_at AS created_at_82,
t62.updated_at AS updated_at_83,
t62.hide_after AS hide_after_84,
t62.start_date AS start_date_85,
t62.all_lessons_access AS all_lessons_access_86,
t62.is_no_index AS is_no_index_87,
t62.is_orbico_agreement AS is_orbico_agreement_88,
t62.is_partner_agreement AS is_partner_agreement_89,
t62.is_online_conference AS is_online_conference_90,
t62.image_name AS image_name_91,
t62.ad_image_name AS ad_image_name_92,
t62.ad_redirect_to_url AS ad_redirect_to_url_93,
t62.ad_start_date AS ad_start_date_94,
t62.ad_end_date AS ad_end_date_95,
t62.module_background_image_name AS module_background_image_name_96,
t62.redirect_to_url AS redirect_to_url_97,
t62.catalog_position AS catalog_position_98,
t62.duration_weeks AS duration_weeks_99,
t62.duration_per_week AS duration_per_week_100,
t62.has_medical_content AS has_medical_content_101,
t62.next_course_id AS next_course_id_102,
t62.main_keyword_id AS main_keyword_id_103,
t62.course_type_id AS course_type_id_104,
t62.category_id AS category_id_105,
t62.cooperator_id AS cooperator_id_106,
t62.portal_settings_id AS portal_settings_id_107,
t62.original_course_id AS original_course_id_108,
t0.original_course_id AS original_course_id_109
FROM
course t0
LEFT JOIN landing t42 ON t42.course_id = t0.id
LEFT JOIN voucher t54 ON t54.course_id = t0.id
LEFT JOIN course t62 ON t62.original_course_id = t0.id
WHERE
t0.original_course_id = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_premium AS is_premium_3, t0.name AS name_4, t0.short_body AS short_body_5, t0.slug AS slug_6, t0.default_price AS default_price_7, t0.duration_hours AS duration_hours_8, t0.duration_months AS duration_months_9, t0.inscriptions AS inscriptions_10, t0.product_for_cos AS product_for_cos_11, t0.filepath AS filepath_12, t0.is_continuous AS is_continuous_13, t0.share_date AS share_date_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.landing_page AS landing_page_17, t0.action_number AS action_number_18, t0.from_source AS from_source_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hide_after AS hide_after_22, t0.start_date AS start_date_23, t0.all_lessons_access AS all_lessons_access_24, t0.is_no_index AS is_no_index_25, t0.is_orbico_agreement AS is_orbico_agreement_26, t0.is_partner_agreement AS is_partner_agreement_27, t0.is_online_conference AS is_online_conference_28, t0.image_name AS image_name_29, t0.ad_image_name AS ad_image_name_30, t0.ad_redirect_to_url AS ad_redirect_to_url_31, t0.ad_start_date AS ad_start_date_32, t0.ad_end_date AS ad_end_date_33, t0.module_background_image_name AS module_background_image_name_34, t0.redirect_to_url AS redirect_to_url_35, t0.catalog_position AS catalog_position_36, t0.duration_weeks AS duration_weeks_37, t0.duration_per_week AS duration_per_week_38, t0.has_medical_content AS has_medical_content_39, t0.next_course_id AS next_course_id_40, t0.main_keyword_id AS main_keyword_id_41, t42.id AS id_43, t42.is_active AS is_active_44, t42.custom_scripts AS custom_scripts_45, t42.template AS template_46, t42.created_at AS created_at_47, t42.updated_at AS updated_at_48, t42.course_id AS course_id_49, t0.course_type_id AS course_type_id_50, t0.category_id AS category_id_51, t0.cooperator_id AS cooperator_id_52, t0.portal_settings_id AS portal_settings_id_53, t54.id AS id_55, t54.name AS name_56, t54.page_orientation_landscape AS page_orientation_landscape_57, t54.pdf_name AS pdf_name_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.course_id AS course_id_61, t62.id AS id_63, t62.is_active AS is_active_64, t62.is_premium AS is_premium_65, t62.name AS name_66, t62.short_body AS short_body_67, t62.slug AS slug_68, t62.default_price AS default_price_69, t62.duration_hours AS duration_hours_70, t62.duration_months AS duration_months_71, t62.inscriptions AS inscriptions_72, t62.product_for_cos AS product_for_cos_73, t62.filepath AS filepath_74, t62.is_continuous AS is_continuous_75, t62.share_date AS share_date_76, t62.meta_title AS meta_title_77, t62.meta_description AS meta_description_78, t62.landing_page AS landing_page_79, t62.action_number AS action_number_80, t62.from_source AS from_source_81, t62.created_at AS created_at_82, t62.updated_at AS updated_at_83, t62.hide_after AS hide_after_84, t62.start_date AS start_date_85, t62.all_lessons_access AS all_lessons_access_86, t62.is_no_index AS is_no_index_87, t62.is_orbico_agreement AS is_orbico_agreement_88, t62.is_partner_agreement AS is_partner_agreement_89, t62.is_online_conference AS is_online_conference_90, t62.image_name AS image_name_91, t62.ad_image_name AS ad_image_name_92, t62.ad_redirect_to_url AS ad_redirect_to_url_93, t62.ad_start_date AS ad_start_date_94, t62.ad_end_date AS ad_end_date_95, t62.module_background_image_name AS module_background_image_name_96, t62.redirect_to_url AS redirect_to_url_97, t62.catalog_position AS catalog_position_98, t62.duration_weeks AS duration_weeks_99, t62.duration_per_week AS duration_per_week_100, t62.has_medical_content AS has_medical_content_101, t62.next_course_id AS next_course_id_102, t62.main_keyword_id AS main_keyword_id_103, t62.course_type_id AS course_type_id_104, t62.category_id AS category_id_105, t62.cooperator_id AS cooperator_id_106, t62.portal_settings_id AS portal_settings_id_107, t62.original_course_id AS original_course_id_108, t0.original_course_id AS original_course_id_109 FROM course t0 LEFT JOIN landing t42 ON t42.course_id = t0.id LEFT JOIN voucher t54 ON t54.course_id = t0.id LEFT JOIN course t62 ON t62.original_course_id = t0.id WHERE t0.original_course_id = 783;
|
54.02 ms
(9.90%)
|
41 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_orientation_landscape AS page_orientation_landscape_3, t0.pdf_name AS pdf_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.course_id AS course_id_7 FROM voucher t0 WHERE t0.course_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_orientation_landscape AS page_orientation_landscape_3, t0.pdf_name AS pdf_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.course_id AS course_id_7 FROM voucher t0 WHERE t0.course_id = 783;
|
20.33 ms
(3.73%)
|
12 |
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.parent_id = ? ORDER BY t0.position ASC
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.parent_id = ?
ORDER BY
t0.position ASC
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.parent_id = 95 ORDER BY t0.position ASC;
|
14.41 ms
(2.64%)
|
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 LEFT JOIN category c4_ ON c1_.parent_id = c4_.id LEFT JOIN courses_additional_categories c6_ ON c0_.id = c6_.course_id LEFT JOIN category c5_ ON c5_.id = c6_.category_id LEFT JOIN category c7_ ON c5_.parent_id = c7_.id WHERE c0_.original_course_id IS NULL AND c0_.portal_settings_id = ? AND (c1_.category_slug = (?) OR c4_.category_slug = (?) OR c5_.category_slug = (?) OR c7_.category_slug = (?)) 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
"WARECKA"
"WARECKA"
"WARECKA"
"WARECKA"
"pl"
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
LEFT JOIN category c4_ ON c1_.parent_id = c4_.id
LEFT JOIN courses_additional_categories c6_ ON c0_.id = c6_.course_id
LEFT JOIN category c5_ ON c5_.id = c6_.category_id
LEFT JOIN category c7_ ON c5_.parent_id = c7_.id
WHERE
c0_.original_course_id IS NULL
AND c0_.portal_settings_id = ?
AND (
c1_.category_slug = (?)
OR c4_.category_slug = (?)
OR c5_.category_slug = (?)
OR c7_.category_slug = (?)
)
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 LEFT JOIN category c4_ ON c1_.parent_id = c4_.id LEFT JOIN courses_additional_categories c6_ ON c0_.id = c6_.course_id LEFT JOIN category c5_ ON c5_.id = c6_.category_id LEFT JOIN category c7_ ON c5_.parent_id = c7_.id WHERE c0_.original_course_id IS NULL AND c0_.portal_settings_id = 113 AND (c1_.category_slug = ('WARECKA') OR c4_.category_slug = ('WARECKA') OR c5_.category_slug = ('WARECKA') OR c7_.category_slug = ('WARECKA')) AND l2_.code = ('pl') 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;
|
11.37 ms
(2.08%)
|
12 |
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.id = ?
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.id = ?
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.id = 95;
|
5.39 ms
(0.99%)
|
1 |
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 = ?) AND ((c4_.category_name = ? OR c5_.category_name = ?))
Parameters: [
"pl"
"pl"
"WARECKA"
"WARECKA"
]
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 = 'pl' OR l7_.code = 'pl') AND ((c4_.category_name = 'WARECKA' OR c5_.category_name = 'WARECKA'));
|
5.33 ms
(0.98%)
|
2 |
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 = ? LIMIT 1
Parameters: [
"medycyna"
]
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 = ?
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 = 'medycyna' LIMIT 1;
|
4.83 ms
(0.89%)
|
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
Parameters: [
"pl"
113
113
113
113
]
SELECT
c.id
FROM
category c
LEFT JOIN
language l ON c.language_id = l.id
WHERE
l.code = 'pl' 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;
|
4.35 ms
(0.80%)
|
2 |
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
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;
|
2.16 ms
(0.40%)
|
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 = ? AND t0.portal_settings_id = ? AND t0.is_active = ? LIMIT 1
Parameters: [
"WARECKA"
113
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 = ?
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 = 'WARECKA' AND t0.portal_settings_id = 113 AND t0.is_active = 1 LIMIT 1;
|
1.59 ms
(0.29%)
|
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;
|