Symfony Profiler

SELECT
  c0_.name AS name_0,
  c0_.slug AS slug_1,
  c0_.short_description AS short_description_2,
  c0_.description AS description_3,
  c0_.published AS published_4,
  c0_.closed AS closed_5,
  c0_.price AS price_6,
  c0_.old_price AS old_price_7,
  c0_.custom_payment_link AS custom_payment_link_8,
  c0_.free_first_step AS free_first_step_9,
  c0_.private_status AS private_status_10,
  c0_.includes AS includes_11,
  c0_.show_reviews AS show_reviews_12,
  c0_.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_13,
  c0_.hard_sequence AS hard_sequence_14,
  c0_.use_landing_external_url AS use_landing_external_url_15,
  c0_.landing_external_url AS landing_external_url_16,
  c0_.copy_protected AS copy_protected_17,
  c0_.video_protected AS video_protected_18,
  c0_.enable_certificate AS enable_certificate_19,
  c0_.deleted AS deleted_20,
  c0_.deleted_at AS deleted_at_21,
  c0_.calculation_in_progress AS calculation_in_progress_22,
  c0_.background_dimming AS background_dimming_23,
  c0_.background_mobile_dimming AS background_mobile_dimming_24,
  c0_.mobile_background_type AS mobile_background_type_25,
  c0_.id AS id_26,
  c0_.create_at AS create_at_27,
  c0_.update_at AS update_at_28,
  c0_.sort AS sort_29,
  c0_.uuid AS uuid_30,
  c0_.cover_id AS cover_id_31,
  c0_.background_id AS background_id_32,
  c0_.mobile_background_id AS mobile_background_id_33,
  c0_.school_id AS school_id_34,
  c0_.flow_to_add_id AS flow_to_add_id_35,
  c0_.payment_gateway_id AS payment_gateway_id_36,
  c0_.installment_gateway_id AS installment_gateway_id_37,
  c0_.certificate_template_id AS certificate_template_id_38,
  c0_.draw_certificate_template_id AS draw_certificate_template_id_39,
  c0_.course_certificate_template_id AS course_certificate_template_id_40
FROM
  course c0_
WHERE
  c0_.school_id = ?
  AND c0_.deleted = ?
  AND c0_.published = ?
  AND c0_.private_status = ?

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.published AS published_4, c0_.closed AS closed_5, c0_.price AS price_6, c0_.old_price AS old_price_7, c0_.custom_payment_link AS custom_payment_link_8, c0_.free_first_step AS free_first_step_9, c0_.private_status AS private_status_10, c0_.includes AS includes_11, c0_.show_reviews AS show_reviews_12, c0_.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_13, c0_.hard_sequence AS hard_sequence_14, c0_.use_landing_external_url AS use_landing_external_url_15, c0_.landing_external_url AS landing_external_url_16, c0_.copy_protected AS copy_protected_17, c0_.video_protected AS video_protected_18, c0_.enable_certificate AS enable_certificate_19, c0_.deleted AS deleted_20, c0_.deleted_at AS deleted_at_21, c0_.calculation_in_progress AS calculation_in_progress_22, c0_.background_dimming AS background_dimming_23, c0_.background_mobile_dimming AS background_mobile_dimming_24, c0_.mobile_background_type AS mobile_background_type_25, c0_.id AS id_26, c0_.create_at AS create_at_27, c0_.update_at AS update_at_28, c0_.sort AS sort_29, c0_.uuid AS uuid_30, c0_.cover_id AS cover_id_31, c0_.background_id AS background_id_32, c0_.mobile_background_id AS mobile_background_id_33, c0_.school_id AS school_id_34, c0_.flow_to_add_id AS flow_to_add_id_35, c0_.payment_gateway_id AS payment_gateway_id_36, c0_.installment_gateway_id AS installment_gateway_id_37, c0_.certificate_template_id AS certificate_template_id_38, c0_.draw_certificate_template_id AS draw_certificate_template_id_39, c0_.course_certificate_template_id AS course_certificate_template_id_40 FROM course c0_ WHERE c0_.school_id = 1 AND c0_.deleted = 0 AND c0_.published = 1 AND c0_.private_status = 'opened';

SELECT
  t0.chat_schoolwide_channel AS chat_schoolwide_channel_1,
  t0.chat_schoolwide_group AS chat_schoolwide_group_2,
  t0.chat_flow_autocreate_channel AS chat_flow_autocreate_channel_3,
  t0.chat_flow_autocreate_group AS chat_flow_autocreate_group_4,
  t0.white_label_hide_logo AS white_label_hide_logo_5,
  t0.hide_app_links_from_email AS hide_app_links_from_email_6,
  t0.request_missing_user_data AS request_missing_user_data_7,
  t0.smtp_enabled AS smtp_enabled_8,
  t0.smtp_host AS smtp_host_9,
  t0.smtp_port AS smtp_port_10,
  t0.smtp_username AS smtp_username_11,
  t0.smtp_password AS smtp_password_12,
  t0.smtp_from AS smtp_from_13,
  t0.close_from_search_engines AS close_from_search_engines_14,
  t0.close_from_search_engine_custom_domain AS close_from_search_engine_custom_domain_15,
  t0.custom_css AS custom_css_16,
  t0.language AS language_17,
  t0.id AS id_18,
  t0.create_at AS create_at_19,
  t0.update_at AS update_at_20,
  t0.school_id AS school_id_21
FROM
  school_settings t0
WHERE
  t0.school_id = ?

SELECT t0.chat_schoolwide_channel AS chat_schoolwide_channel_1, t0.chat_schoolwide_group AS chat_schoolwide_group_2, t0.chat_flow_autocreate_channel AS chat_flow_autocreate_channel_3, t0.chat_flow_autocreate_group AS chat_flow_autocreate_group_4, t0.white_label_hide_logo AS white_label_hide_logo_5, t0.hide_app_links_from_email AS hide_app_links_from_email_6, t0.request_missing_user_data AS request_missing_user_data_7, t0.smtp_enabled AS smtp_enabled_8, t0.smtp_host AS smtp_host_9, t0.smtp_port AS smtp_port_10, t0.smtp_username AS smtp_username_11, t0.smtp_password AS smtp_password_12, t0.smtp_from AS smtp_from_13, t0.close_from_search_engines AS close_from_search_engines_14, t0.close_from_search_engine_custom_domain AS close_from_search_engine_custom_domain_15, t0.custom_css AS custom_css_16, t0.language AS language_17, t0.id AS id_18, t0.create_at AS create_at_19, t0.update_at AS update_at_20, t0.school_id AS school_id_21 FROM school_settings t0 WHERE t0.school_id = 1;

SELECT
  t0.slug AS slug_1,
  t0.yandex_metrika_code AS yandex_metrika_code_2,
  t0.google_analytics_code AS google_analytics_code_3,
  t0.facebook_pixel AS facebook_pixel_4,
  t0.vk_pixel AS vk_pixel_5,
  t0.primary_color AS primary_color_6,
  t0.landing_type AS landing_type_7,
  t0.hide_price_at_start AS hide_price_at_start_8,
  t0.plans_payment AS plans_payment_9,
  t0.order_title AS order_title_10,
  t0.order_subtitle AS order_subtitle_11,
  t0.published AS published_12,
  t0.price AS price_13,
  t0.price_old AS price_old_14,
  t0.currency AS currency_15,
  t0.social_networks_urls AS social_networks_urls_16,
  t0.id AS id_17,
  t0.create_at AS create_at_18,
  t0.update_at AS update_at_19,
  t0.sort AS sort_20,
  t0.uuid AS uuid_21,
  t0.course_id AS course_id_22,
  t23.name AS name_24,
  t23.slug AS slug_25,
  t23.short_description AS short_description_26,
  t23.description AS description_27,
  t23.published AS published_28,
  t23.closed AS closed_29,
  t23.price AS price_30,
  t23.old_price AS old_price_31,
  t23.custom_payment_link AS custom_payment_link_32,
  t23.free_first_step AS free_first_step_33,
  t23.private_status AS private_status_34,
  t23.includes AS includes_35,
  t23.show_reviews AS show_reviews_36,
  t23.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_37,
  t23.hard_sequence AS hard_sequence_38,
  t23.use_landing_external_url AS use_landing_external_url_39,
  t23.landing_external_url AS landing_external_url_40,
  t23.copy_protected AS copy_protected_41,
  t23.video_protected AS video_protected_42,
  t23.enable_certificate AS enable_certificate_43,
  t23.deleted AS deleted_44,
  t23.deleted_at AS deleted_at_45,
  t23.calculation_in_progress AS calculation_in_progress_46,
  t23.background_dimming AS background_dimming_47,
  t23.background_mobile_dimming AS background_mobile_dimming_48,
  t23.mobile_background_type AS mobile_background_type_49,
  t23.id AS id_50,
  t23.create_at AS create_at_51,
  t23.update_at AS update_at_52,
  t23.sort AS sort_53,
  t23.uuid AS uuid_54,
  t23.cover_id AS cover_id_55,
  t23.background_id AS background_id_56,
  t23.mobile_background_id AS mobile_background_id_57,
  t23.school_id AS school_id_58,
  t23.flow_to_add_id AS flow_to_add_id_59,
  t23.payment_gateway_id AS payment_gateway_id_60,
  t23.installment_gateway_id AS installment_gateway_id_61,
  t23.certificate_template_id AS certificate_template_id_62,
  t23.draw_certificate_template_id AS draw_certificate_template_id_63,
  t23.course_certificate_template_id AS course_certificate_template_id_64,
  t0.school_id AS school_id_65,
  t66.name AS name_67,
  t66.default_slug AS default_slug_68,
  t66.slug AS slug_69,
  t66.domain AS domain_70,
  t66.description AS description_71,
  t66.primary_color AS primary_color_72,
  t66.balance AS balance_73,
  t66.amo_company_id AS amo_company_id_74,
  t66.amo_register_deal_id AS amo_register_deal_id_75,
  t66.roistat AS roistat_76,
  t66.tagline AS tagline_77,
  t66.kinescope_project_id AS kinescope_project_id_78,
  t66.generate_invite_user_id AS generate_invite_user_id_79,
  t66.kinescope_player_id AS kinescope_player_id_80,
  t66.allow_self_register AS allow_self_register_81,
  t66.confirm_registration_code AS confirm_registration_code_82,
  t66.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_83,
  t66.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_84,
  t66.confirm_registration_finished AS confirm_registration_finished_85,
  t66.confirm_registration_skipped AS confirm_registration_skipped_86,
  t66.active AS active_87,
  t66.storage_size AS storage_size_88,
  t66.last_storage_size_calculation AS last_storage_size_calculation_89,
  t66.clear_storage_files AS clear_storage_files_90,
  t66.cover_dimming AS cover_dimming_91,
  t66.cover_mobile_dimming AS cover_mobile_dimming_92,
  t66.mobile_cover_type AS mobile_cover_type_93,
  t66.disable_clear_storage AS disable_clear_storage_94,
  t66.id AS id_95,
  t66.create_at AS create_at_96,
  t66.update_at AS update_at_97,
  t66.sort AS sort_98,
  t66.uuid AS uuid_99,
  t66.owner_id AS owner_id_100,
  t66.logo_id AS logo_id_101,
  t66.favicon_id AS favicon_id_102,
  t66.avatar_id AS avatar_id_103,
  t66.cover_id AS cover_id_104,
  t66.mobile_cover_id AS mobile_cover_id_105,
  t66.cover_change_id AS cover_change_id_106,
  t66.plan_id AS plan_id_107,
  t66.subscription_id AS subscription_id_108,
  t66.schoolChannel AS schoolChannel_109,
  t66.schoolGroup AS schoolGroup_110,
  t66.discount_id AS discount_id_111,
  t0.published_landing_id AS published_landing_id_112
FROM
  landing t0
  LEFT JOIN course t23 ON t0.course_id = t23.id
  LEFT JOIN schools t66 ON t0.school_id = t66.id
WHERE
  t0.course_id = ?

SELECT t0.slug AS slug_1, t0.yandex_metrika_code AS yandex_metrika_code_2, t0.google_analytics_code AS google_analytics_code_3, t0.facebook_pixel AS facebook_pixel_4, t0.vk_pixel AS vk_pixel_5, t0.primary_color AS primary_color_6, t0.landing_type AS landing_type_7, t0.hide_price_at_start AS hide_price_at_start_8, t0.plans_payment AS plans_payment_9, t0.order_title AS order_title_10, t0.order_subtitle AS order_subtitle_11, t0.published AS published_12, t0.price AS price_13, t0.price_old AS price_old_14, t0.currency AS currency_15, t0.social_networks_urls AS social_networks_urls_16, t0.id AS id_17, t0.create_at AS create_at_18, t0.update_at AS update_at_19, t0.sort AS sort_20, t0.uuid AS uuid_21, t0.course_id AS course_id_22, t23.name AS name_24, t23.slug AS slug_25, t23.short_description AS short_description_26, t23.description AS description_27, t23.published AS published_28, t23.closed AS closed_29, t23.price AS price_30, t23.old_price AS old_price_31, t23.custom_payment_link AS custom_payment_link_32, t23.free_first_step AS free_first_step_33, t23.private_status AS private_status_34, t23.includes AS includes_35, t23.show_reviews AS show_reviews_36, t23.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_37, t23.hard_sequence AS hard_sequence_38, t23.use_landing_external_url AS use_landing_external_url_39, t23.landing_external_url AS landing_external_url_40, t23.copy_protected AS copy_protected_41, t23.video_protected AS video_protected_42, t23.enable_certificate AS enable_certificate_43, t23.deleted AS deleted_44, t23.deleted_at AS deleted_at_45, t23.calculation_in_progress AS calculation_in_progress_46, t23.background_dimming AS background_dimming_47, t23.background_mobile_dimming AS background_mobile_dimming_48, t23.mobile_background_type AS mobile_background_type_49, t23.id AS id_50, t23.create_at AS create_at_51, t23.update_at AS update_at_52, t23.sort AS sort_53, t23.uuid AS uuid_54, t23.cover_id AS cover_id_55, t23.background_id AS background_id_56, t23.mobile_background_id AS mobile_background_id_57, t23.school_id AS school_id_58, t23.flow_to_add_id AS flow_to_add_id_59, t23.payment_gateway_id AS payment_gateway_id_60, t23.installment_gateway_id AS installment_gateway_id_61, t23.certificate_template_id AS certificate_template_id_62, t23.draw_certificate_template_id AS draw_certificate_template_id_63, t23.course_certificate_template_id AS course_certificate_template_id_64, t0.school_id AS school_id_65, t66.name AS name_67, t66.default_slug AS default_slug_68, t66.slug AS slug_69, t66.domain AS domain_70, t66.description AS description_71, t66.primary_color AS primary_color_72, t66.balance AS balance_73, t66.amo_company_id AS amo_company_id_74, t66.amo_register_deal_id AS amo_register_deal_id_75, t66.roistat AS roistat_76, t66.tagline AS tagline_77, t66.kinescope_project_id AS kinescope_project_id_78, t66.generate_invite_user_id AS generate_invite_user_id_79, t66.kinescope_player_id AS kinescope_player_id_80, t66.allow_self_register AS allow_self_register_81, t66.confirm_registration_code AS confirm_registration_code_82, t66.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_83, t66.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_84, t66.confirm_registration_finished AS confirm_registration_finished_85, t66.confirm_registration_skipped AS confirm_registration_skipped_86, t66.active AS active_87, t66.storage_size AS storage_size_88, t66.last_storage_size_calculation AS last_storage_size_calculation_89, t66.clear_storage_files AS clear_storage_files_90, t66.cover_dimming AS cover_dimming_91, t66.cover_mobile_dimming AS cover_mobile_dimming_92, t66.mobile_cover_type AS mobile_cover_type_93, t66.disable_clear_storage AS disable_clear_storage_94, t66.id AS id_95, t66.create_at AS create_at_96, t66.update_at AS update_at_97, t66.sort AS sort_98, t66.uuid AS uuid_99, t66.owner_id AS owner_id_100, t66.logo_id AS logo_id_101, t66.favicon_id AS favicon_id_102, t66.avatar_id AS avatar_id_103, t66.cover_id AS cover_id_104, t66.mobile_cover_id AS mobile_cover_id_105, t66.cover_change_id AS cover_change_id_106, t66.plan_id AS plan_id_107, t66.subscription_id AS subscription_id_108, t66.schoolChannel AS schoolChannel_109, t66.schoolGroup AS schoolGroup_110, t66.discount_id AS discount_id_111, t0.published_landing_id AS published_landing_id_112 FROM landing t0 LEFT JOIN course t23 ON t0.course_id = t23.id LEFT JOIN schools t66 ON t0.school_id = t66.id WHERE t0.course_id = 1;

SELECT
  s0_.name AS name_0,
  s0_.default_slug AS default_slug_1,
  s0_.slug AS slug_2,
  s0_.domain AS domain_3,
  s0_.description AS description_4,
  s0_.primary_color AS primary_color_5,
  s0_.balance AS balance_6,
  s0_.amo_company_id AS amo_company_id_7,
  s0_.amo_register_deal_id AS amo_register_deal_id_8,
  s0_.roistat AS roistat_9,
  s0_.tagline AS tagline_10,
  s0_.kinescope_project_id AS kinescope_project_id_11,
  s0_.generate_invite_user_id AS generate_invite_user_id_12,
  s0_.kinescope_player_id AS kinescope_player_id_13,
  s0_.allow_self_register AS allow_self_register_14,
  s0_.confirm_registration_code AS confirm_registration_code_15,
  s0_.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_16,
  s0_.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_17,
  s0_.confirm_registration_finished AS confirm_registration_finished_18,
  s0_.confirm_registration_skipped AS confirm_registration_skipped_19,
  s0_.active AS active_20,
  s0_.storage_size AS storage_size_21,
  s0_.last_storage_size_calculation AS last_storage_size_calculation_22,
  s0_.clear_storage_files AS clear_storage_files_23,
  s0_.cover_dimming AS cover_dimming_24,
  s0_.cover_mobile_dimming AS cover_mobile_dimming_25,
  s0_.mobile_cover_type AS mobile_cover_type_26,
  s0_.disable_clear_storage AS disable_clear_storage_27,
  s0_.id AS id_28,
  s0_.create_at AS create_at_29,
  s0_.update_at AS update_at_30,
  s0_.sort AS sort_31,
  s0_.uuid AS uuid_32,
  s0_.owner_id AS owner_id_33,
  s0_.logo_id AS logo_id_34,
  s0_.favicon_id AS favicon_id_35,
  s0_.avatar_id AS avatar_id_36,
  s0_.cover_id AS cover_id_37,
  s0_.mobile_cover_id AS mobile_cover_id_38,
  s0_.cover_change_id AS cover_change_id_39,
  s0_.plan_id AS plan_id_40,
  s0_.subscription_id AS subscription_id_41,
  s0_.schoolChannel AS schoolChannel_42,
  s0_.schoolGroup AS schoolGroup_43,
  s0_.discount_id AS discount_id_44
FROM
  schools s0_
WHERE
  s0_.slug = ?
  OR s0_.default_slug = ?
LIMIT
  1

SELECT s0_.name AS name_0, s0_.default_slug AS default_slug_1, s0_.slug AS slug_2, s0_.domain AS domain_3, s0_.description AS description_4, s0_.primary_color AS primary_color_5, s0_.balance AS balance_6, s0_.amo_company_id AS amo_company_id_7, s0_.amo_register_deal_id AS amo_register_deal_id_8, s0_.roistat AS roistat_9, s0_.tagline AS tagline_10, s0_.kinescope_project_id AS kinescope_project_id_11, s0_.generate_invite_user_id AS generate_invite_user_id_12, s0_.kinescope_player_id AS kinescope_player_id_13, s0_.allow_self_register AS allow_self_register_14, s0_.confirm_registration_code AS confirm_registration_code_15, s0_.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_16, s0_.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_17, s0_.confirm_registration_finished AS confirm_registration_finished_18, s0_.confirm_registration_skipped AS confirm_registration_skipped_19, s0_.active AS active_20, s0_.storage_size AS storage_size_21, s0_.last_storage_size_calculation AS last_storage_size_calculation_22, s0_.clear_storage_files AS clear_storage_files_23, s0_.cover_dimming AS cover_dimming_24, s0_.cover_mobile_dimming AS cover_mobile_dimming_25, s0_.mobile_cover_type AS mobile_cover_type_26, s0_.disable_clear_storage AS disable_clear_storage_27, s0_.id AS id_28, s0_.create_at AS create_at_29, s0_.update_at AS update_at_30, s0_.sort AS sort_31, s0_.uuid AS uuid_32, s0_.owner_id AS owner_id_33, s0_.logo_id AS logo_id_34, s0_.favicon_id AS favicon_id_35, s0_.avatar_id AS avatar_id_36, s0_.cover_id AS cover_id_37, s0_.mobile_cover_id AS mobile_cover_id_38, s0_.cover_change_id AS cover_change_id_39, s0_.plan_id AS plan_id_40, s0_.subscription_id AS subscription_id_41, s0_.schoolChannel AS schoolChannel_42, s0_.schoolGroup AS schoolGroup_43, s0_.discount_id AS discount_id_44 FROM schools s0_ WHERE s0_.slug = 'dev-school' OR s0_.default_slug = 'dev-school' LIMIT 1;

SELECT
  t0.rules AS rules_1,
  t0.draw_rules AS draw_rules_2,
  t0.published_at AS published_at_3,
  t0.display_share_buttons AS display_share_buttons_4,
  t0.draw_display_share_buttons AS draw_display_share_buttons_5,
  t0.title AS title_6,
  t0.draw_title AS draw_title_7,
  t0.subtitle AS subtitle_8,
  t0.draw_subtitle AS draw_subtitle_9,
  t0.status AS status_10,
  t0.display_student AS display_student_11,
  t0.draw_display_student AS draw_display_student_12,
  t0.id AS id_13,
  t0.create_at AS create_at_14,
  t0.update_at AS update_at_15,
  t0.uuid AS uuid_16,
  t0.school_id AS school_id_17,
  t0.course_id AS course_id_18,
  t0.group_id AS group_id_19
FROM
  course_finish_rule t0
WHERE
  t0.course_id = ?

SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.course_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.create_at AS create_at_1,
  c0_.update_at AS update_at_2,
  c0_.sort AS sort_3,
  c0_.uuid AS uuid_4,
  c0_.school_id AS school_id_5,
  c0_.course_id AS course_id_6,
  c0_.category_id AS category_id_7
FROM
  course_category_relation c0_
  LEFT JOIN course c1_ ON c0_.course_id = c1_.id
WHERE
  c0_.course_id = ?
  AND c1_.deleted = ?
ORDER BY
  c0_.sort ASC

SELECT c0_.id AS id_0, c0_.create_at AS create_at_1, c0_.update_at AS update_at_2, c0_.sort AS sort_3, c0_.uuid AS uuid_4, c0_.school_id AS school_id_5, c0_.course_id AS course_id_6, c0_.category_id AS category_id_7 FROM course_category_relation c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c0_.course_id = 1 AND c1_.deleted = 0 ORDER BY c0_.sort ASC;

SELECT
  count(l0_.id) AS sclr_0
FROM
  lesson l0_
  LEFT JOIN step s1_ ON l0_.step_id = s1_.id
WHERE
  s1_.course_id = ?
  AND l0_.status IN (?, ?)
  AND l0_.deleted = ?

SELECT count(l0_.id) AS sclr_0 FROM lesson l0_ LEFT JOIN step s1_ ON l0_.step_id = s1_.id WHERE s1_.course_id = 1 AND l0_.status IN ('published', 'published-draw') AND l0_.deleted = 0;

SELECT
  t0.rules AS rules_1,
  t0.draw_rules AS draw_rules_2,
  t0.display_share_buttons AS display_share_buttons_3,
  t0.draw_display_share_buttons AS draw_display_share_buttons_4,
  t0.status AS status_5,
  t0.published_at AS published_at_6,
  t0.id AS id_7,
  t0.create_at AS create_at_8,
  t0.update_at AS update_at_9,
  t0.uuid AS uuid_10,
  t0.school_id AS school_id_11,
  t0.course_id AS course_id_12,
  t0.group_id AS group_id_13
FROM
  course_certificate_rule t0
WHERE
  t0.course_id = ?

SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.course_id = 1;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.update_at AS update_at_3,
  t0.sort AS sort_4,
  t0.uuid AS uuid_5,
  t0.school_id AS school_id_6,
  t0.course_id AS course_id_7,
  t0.category_id AS category_id_8
FROM
  course_category_relation t0
WHERE
  t0.course_id = ?

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.update_at AS update_at_3, t0.sort AS sort_4, t0.uuid AS uuid_5, t0.school_id AS school_id_6, t0.course_id AS course_id_7, t0.category_id AS category_id_8 FROM course_category_relation t0 WHERE t0.course_id = 1;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.update_at AS update_at_3,
  t0.uuid AS uuid_4,
  t0.sort AS sort_5,
  t0.school_id AS school_id_6,
  t0.landing_id AS landing_id_7,
  t0.user_fiel_id AS user_fiel_id_8
FROM
  user_custom_field_landing t0
WHERE
  t0.landing_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.update_at AS update_at_3, t0.uuid AS uuid_4, t0.sort AS sort_5, t0.school_id AS school_id_6, t0.landing_id AS landing_id_7, t0.user_fiel_id AS user_fiel_id_8 FROM user_custom_field_landing t0 WHERE t0.landing_id = 2 ORDER BY t0.sort ASC;