Symfony Profiler

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 = '963174' OR s0_.default_slug = '963174' LIMIT 1;

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 = 50;

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.mime AS mime_3,
  t0.bucket AS bucket_4,
  t0.path AS path_5,
  t0.dir AS dir_6,
  t0.size AS size_7,
  t0.chunked AS chunked_8,
  t0.chunked_metadata AS chunked_metadata_9,
  t0.chunked_token AS chunked_token_10,
  t0.entity_owner_name AS entity_owner_name_11,
  t0.entity_owner_id AS entity_owner_id_12,
  t0.kinescope_id AS kinescope_id_13,
  t0.kinescope_short_id AS kinescope_short_id_14,
  t0.audio_time AS audio_time_15,
  t0.audio_average_frequency AS audio_average_frequency_16,
  t0.multipart_upload_id AS multipart_upload_id_17,
  t0.restore_information AS restore_information_18,
  t0.deleted AS deleted_19,
  t0.deleted_at AS deleted_at_20,
  t0.path_deleted AS path_deleted_21,
  t0.id AS id_22,
  t0.create_at AS create_at_23,
  t0.update_at AS update_at_24,
  t0.uuid AS uuid_25,
  t0.school_id AS school_id_26,
  t0.lesson_module_file_id AS lesson_module_file_id_27,
  t0.homework_answer_audio_id AS homework_answer_audio_id_28,
  t0.question_fail_comment_file_id AS question_fail_comment_file_id_29,
  t0.question_success_comment_file_id AS question_success_comment_file_id_30,
  t0.answer_digit_comment_file_id AS answer_digit_comment_file_id_31,
  t0.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_32,
  t0.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_33,
  t0.answer_select_comment_file_id AS answer_select_comment_file_id_34,
  t0.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_35,
  t0.answer_comment_file_id AS answer_comment_file_id_36
FROM
  file t0
WHERE
  t0.id IN (?, ?)

SELECT t0.name AS name_1, t0.type AS type_2, t0.mime AS mime_3, t0.bucket AS bucket_4, t0.path AS path_5, t0.dir AS dir_6, t0.size AS size_7, t0.chunked AS chunked_8, t0.chunked_metadata AS chunked_metadata_9, t0.chunked_token AS chunked_token_10, t0.entity_owner_name AS entity_owner_name_11, t0.entity_owner_id AS entity_owner_id_12, t0.kinescope_id AS kinescope_id_13, t0.kinescope_short_id AS kinescope_short_id_14, t0.audio_time AS audio_time_15, t0.audio_average_frequency AS audio_average_frequency_16, t0.multipart_upload_id AS multipart_upload_id_17, t0.restore_information AS restore_information_18, t0.deleted AS deleted_19, t0.deleted_at AS deleted_at_20, t0.path_deleted AS path_deleted_21, t0.id AS id_22, t0.create_at AS create_at_23, t0.update_at AS update_at_24, t0.uuid AS uuid_25, t0.school_id AS school_id_26, t0.lesson_module_file_id AS lesson_module_file_id_27, t0.homework_answer_audio_id AS homework_answer_audio_id_28, t0.question_fail_comment_file_id AS question_fail_comment_file_id_29, t0.question_success_comment_file_id AS question_success_comment_file_id_30, t0.answer_digit_comment_file_id AS answer_digit_comment_file_id_31, t0.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_32, t0.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_33, t0.answer_select_comment_file_id AS answer_select_comment_file_id_34, t0.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_35, t0.answer_comment_file_id AS answer_comment_file_id_36 FROM file t0 WHERE t0.id IN (24, 25);

SELECT
  t0_.from_url AS from_url_0,
  t0_.to_url AS to_url_1,
  t0_.comment AS comment_2,
  t0_.use_type AS use_type_3,
  t0_.id AS id_4,
  t0_.create_at AS create_at_5,
  t0_.update_at AS update_at_6,
  t0_.sort AS sort_7
FROM
  tilda_page_redirect t0_
WHERE
  t0_.from_url = ?
  AND t0_.use_type IN (?, ?)
LIMIT
  1

SELECT t0_.from_url AS from_url_0, t0_.to_url AS to_url_1, t0_.comment AS comment_2, t0_.use_type AS use_type_3, t0_.id AS id_4, t0_.create_at AS create_at_5, t0_.update_at AS update_at_6, t0_.sort AS sort_7 FROM tilda_page_redirect t0_ WHERE t0_.from_url = '/course/37/certificates' AND t0_.use_type IN ('school', 'all') LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.active AS active_5,
  t0.price AS price_6,
  t0.old_price AS old_price_7,
  t0.price1month AS price1month_8,
  t0.price3month AS price3month_9,
  t0.price6month AS price6month_10,
  t0.price12month AS price12month_11,
  t0.delete_at AS delete_at_12,
  t0.removed AS removed_13,
  t0.period AS period_14,
  t0.free AS free_15,
  t0.id AS id_16,
  t0.create_at AS create_at_17,
  t0.update_at AS update_at_18,
  t0.sort AS sort_19
FROM
  subscription_plan t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = 1;

SELECT
  t0.name AS name_1,
  t0.code AS code_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.active AS active_5,
  t0.type AS type_6,
  t0.features_limit AS features_limit_7,
  t0.delete_at AS delete_at_8,
  t0.removed AS removed_9,
  t0.display_plan_page AS display_plan_page_10,
  t0.id AS id_11,
  t0.create_at AS create_at_12,
  t0.update_at AS update_at_13,
  t0.sort AS sort_14
FROM
  subscription_plan_feature t0
  INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id
WHERE
  plan_plan_feature.plan_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = 1 ORDER BY t0.sort ASC;

SELECT
  t0.start_at AS start_at_1,
  t0.end_at AS end_at_2,
  t0.trial_activated AS trial_activated_3,
  t0.trial_end_at AS trial_end_at_4,
  t0.recurrent_payment AS recurrent_payment_5,
  t0.id AS id_6,
  t0.create_at AS create_at_7,
  t0.update_at AS update_at_8,
  t0.school_id AS school_id_9
FROM
  subscription_plan_subscription t0
WHERE
  t0.id = ?

SELECT t0.start_at AS start_at_1, t0.end_at AS end_at_2, t0.trial_activated AS trial_activated_3, t0.trial_end_at AS trial_end_at_4, t0.recurrent_payment AS recurrent_payment_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.school_id AS school_id_9 FROM subscription_plan_subscription t0 WHERE t0.id = 39;

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 = ?
LIMIT
  1

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 = 50 LIMIT 1;

SELECT
  t0.status AS status_1,
  t0.reason AS reason_2,
  t0.ambassador_fio AS ambassador_fio_3,
  t0.ambassador_birthday AS ambassador_birthday_4,
  t0.ambassador_phone AS ambassador_phone_5,
  t0.ambassador_city AS ambassador_city_6,
  t0.inn AS inn_7,
  t0.kpp AS kpp_8,
  t0.name AS name_9,
  t0.bik AS bik_10,
  t0.bank_name AS bank_name_11,
  t0.korschet AS korschet_12,
  t0.rasschet AS rasschet_13,
  t0.contact_address AS contact_address_14,
  t0.contact_phone AS contact_phone_15,
  t0.contact_email AS contact_email_16,
  t0.self_employed AS self_employed_17,
  t0.dont_use_dogovor AS dont_use_dogovor_18,
  t0.use_default_docs AS use_default_docs_19,
  t0.ogrn AS ogrn_20,
  t0.type AS type_21,
  t0.id AS id_22,
  t0.create_at AS create_at_23,
  t0.update_at AS update_at_24,
  t0.school_id AS school_id_25,
  t0.politika_id AS politika_id_26,
  t0.dogovor_id AS dogovor_id_27,
  t0.personal_consent_id AS personal_consent_id_28
FROM
  school_requisites t0
WHERE
  t0.school_id = ?
  AND t0.status = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.status AS status_1, t0.reason AS reason_2, t0.ambassador_fio AS ambassador_fio_3, t0.ambassador_birthday AS ambassador_birthday_4, t0.ambassador_phone AS ambassador_phone_5, t0.ambassador_city AS ambassador_city_6, t0.inn AS inn_7, t0.kpp AS kpp_8, t0.name AS name_9, t0.bik AS bik_10, t0.bank_name AS bank_name_11, t0.korschet AS korschet_12, t0.rasschet AS rasschet_13, t0.contact_address AS contact_address_14, t0.contact_phone AS contact_phone_15, t0.contact_email AS contact_email_16, t0.self_employed AS self_employed_17, t0.dont_use_dogovor AS dont_use_dogovor_18, t0.use_default_docs AS use_default_docs_19, t0.ogrn AS ogrn_20, t0.type AS type_21, t0.id AS id_22, t0.create_at AS create_at_23, t0.update_at AS update_at_24, t0.school_id AS school_id_25, t0.politika_id AS politika_id_26, t0.dogovor_id AS dogovor_id_27, t0.personal_consent_id  AS personal_consent_id_28 FROM school_requisites t0 WHERE t0.school_id = 50 AND t0.status = 'approved' ORDER BY t0.id DESC LIMIT 1;