GET https://dev-school.dev-4.sksp.site/api/student/course/list

Query Metrics

10 Database Queries
10 Different statements
2.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.29 ms
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
Parameters:
[
  "dev-school"
  "dev-school"
]
2 0.46 ms
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 = ?
Parameters:
[
  1
]
3 0.55 ms
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 = ?
Parameters:
[
  1
  0
  1
  "opened"
]
4 0.27 ms
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 = ?
Parameters:
[
  1
]
5 0.12 ms
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 = ?
Parameters:
[
  1
]
6 0.32 ms
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 = ?
Parameters:
[
  1
]
7 0.21 ms
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
Parameters:
[
  1
  0
]
8 0.15 ms
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 = ?
Parameters:
[
  1
  "published"
  "published-draw"
  0
]
9 0.06 ms
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 = ?
Parameters:
[
  1
]
10 0.06 ms
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
Parameters:
[
  2
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\School\School No errors.
App\Entity\UserToken No errors.
App\Entity\User No errors.
App\Entity\File No errors.
App\Entity\Subscription\Plan No errors.
App\Entity\Subscription\Subscription No errors.
App\Entity\Chat\Chat No errors.
App\Entity\Subscription\Discount\Discount No errors.
App\Entity\Course\Course No errors.
App\Entity\Homework\HomeworkUser No errors.
App\Entity\PublicApi\SchoolToken No errors.
App\Entity\Settings\School No errors.
App\Entity\Notifications No errors.
App\Entity\School\UserFields\UserField No errors.
App\Entity\Landing\Landing No errors.
App\Entity\Course\Category No errors.
App\Entity\Settings\SchoolWebhook No errors.
App\Entity\Course\LessonAccess No errors.
App\Entity\Course\CourseUser No errors.
App\Entity\School\SchoolUser No errors.
App\Entity\Lesson\Lesson No errors.
App\Entity\Lesson\LessonPage No errors.
App\Entity\LessonModule\LessonModule No errors.
App\Entity\Lesson\LessonHistory No errors.
App\Entity\Step No errors.
App\Entity\Test\Question\ParentType No errors.
App\Entity\Test\TestDeadline No errors.
App\Entity\Test\Test No errors.
App\Entity\Test\Answer\ParentTypeNew No errors.
App\Entity\School\Discount\Discount No errors.
App\Entity\Homework\HomeworkDeadline No errors.
App\Entity\Homework\Homework No errors.
App\Entity\Subscription\PlanFeature No errors.
App\Entity\Subscription\SubscriptionUsage No errors.
App\Entity\Course\CourseCategory No errors.
App\Entity\Chat\Recipient No errors.
App\Entity\Chat\Message\Message No errors.
App\Entity\Group\LessonAccess No errors.
App\Entity\Group\Flow No errors.
App\Entity\Payment\Transaction\Transaction No errors.
App\Entity\UserLessonComplete No errors.
App\Entity\Settings\SchoolUser No errors.
App\Entity\FileUpload No errors.
App\Entity\RichTextImage No errors.
App\Entity\UserLessonDeadline No errors.
App\Entity\Webinar\Webinar No errors.
App\Entity\Webinar\WebinarFlow No errors.
App\Entity\Test\Attempt\TestAttempt No errors.
App\Entity\Payment\Gateway\Gateway No errors.
App\Entity\Course\Certificate\CertificateTemplate No errors.
App\Entity\Course\CoursePlan No errors.
App\Entity\Course\CourseFinishRule No errors.
App\Entity\Course\CourseCertificateRule No errors.
App\Entity\Landing\Block\ParentType No errors.
App\Entity\School\UserFields\LandingField No errors.