Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.deleted_by_id AS deleted_by_id_10
FROM
  day_in_week t0
  INNER JOIN course_day_in_week ON t0.id = course_day_in_week.day_in_week_id
WHERE
  course_day_in_week.course_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM day_in_week t0 INNER JOIN course_day_in_week ON t0.id = course_day_in_week.day_in_week_id WHERE course_day_in_week.course_id = 3505;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.show_in_base_search AS show_in_base_search_7,
  t0.show_in_homepage_search AS show_in_homepage_search_8,
  t0.show_in_related_form AS show_in_related_form_9,
  t0.show_in_similar_courses_search AS show_in_similar_courses_search_10,
  t0.show_in_course_topic_search AS show_in_course_topic_search_11,
  t0.lft AS lft_12,
  t0.lvl AS lvl_13,
  t0.rgt AS rgt_14,
  t0.position AS position_15,
  t0.show_in_submenu AS show_in_submenu_16,
  t0.seo_title AS seo_title_17,
  t0.seo_keywords AS seo_keywords_18,
  t0.seo_description AS seo_description_19,
  t0.identifier AS identifier_20,
  t0.created_by_id AS created_by_id_21,
  t0.updated_by_id AS updated_by_id_22,
  t0.deleted_by_id AS deleted_by_id_23,
  t0.image_id AS image_id_24,
  t0.tree_root AS tree_root_25,
  t0.parent_id AS parent_id_26
FROM
  attribute_group t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.show_in_base_search AS show_in_base_search_7, t0.show_in_homepage_search AS show_in_homepage_search_8, t0.show_in_related_form AS show_in_related_form_9, t0.show_in_similar_courses_search AS show_in_similar_courses_search_10, t0.show_in_course_topic_search AS show_in_course_topic_search_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.position AS position_15, t0.show_in_submenu AS show_in_submenu_16, t0.seo_title AS seo_title_17, t0.seo_keywords AS seo_keywords_18, t0.seo_description AS seo_description_19, t0.identifier AS identifier_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22, t0.deleted_by_id AS deleted_by_id_23, t0.image_id AS image_id_24, t0.tree_root AS tree_root_25, t0.parent_id AS parent_id_26 FROM attribute_group t0 WHERE t0.identifier = 'management-courses' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.deleted_at AS deleted_at_3,
  c0_.is_created_by_admin AS is_created_by_admin_4,
  c0_.name AS name_5,
  c0_.price AS price_6,
  c0_.price_description AS price_description_7,
  c0_.short_description AS short_description_8,
  c0_.description AS description_9,
  c0_.requirements AS requirements_10,
  c0_.published_at AS published_at_11,
  c0_.end_at AS end_at_12,
  c0_.length AS length_13,
  c0_.can_customize AS can_customize_14,
  c0_.is_preparation_for_certification AS is_preparation_for_certification_15,
  c0_.is_with_certificate AS is_with_certificate_16,
  c0_.can_buy AS can_buy_17,
  c0_.can_register AS can_register_18,
  c0_.email AS email_19,
  c0_.can_paid AS can_paid_20,
  c0_.frequency_text AS frequency_text_21,
  c0_.lesson_start AS lesson_start_22,
  c0_.lesson_end AS lesson_end_23,
  c0_.is_confirmation_of_participation AS is_confirmation_of_participation_24,
  c0_.certification_price_not_included AS certification_price_not_included_25,
  c0_.certification_price AS certification_price_26,
  c0_.confirmation_name AS confirmation_name_27,
  c0_.url AS url_28,
  c0_.code AS code_29,
  c0_.is_recommended AS is_recommended_30,
  c0_.rating AS rating_31,
  c0_.is_native_speaker AS is_native_speaker_32,
  c0_.is_customized AS is_customized_33,
  c0_.only_for_adults AS only_for_adults_34,
  c0_.last_step AS last_step_35,
  c0_.place_description AS place_description_36,
  c0_.latitude AS latitude_37,
  c0_.longitude AS longitude_38,
  c0_.identifier AS identifier_39,
  c0_.created_by_id AS created_by_id_40,
  c0_.updated_by_id AS updated_by_id_41,
  c0_.deleted_by_id AS deleted_by_id_42,
  c0_.organizer_id AS organizer_id_43,
  c0_.place_id AS place_id_44,
  c0_.state_id AS state_id_45,
  c0_.type_id AS type_id_46,
  c0_.certificate_id AS certificate_id_47,
  c0_.frequency_id AS frequency_id_48,
  c0_.place_type_id AS place_type_id_49,
  c0_.topic_id AS topic_id_50,
  c0_.length_type_id AS length_type_id_51,
  c0_.progress_level_id AS progress_level_id_52,
  c0_.language_level_input_id AS language_level_input_id_53,
  c0_.language_level_output_id AS language_level_output_id_54,
  c0_.city_id AS city_id_55,
  c0_.teaching_type_id AS teaching_type_id_56,
  c0_.retraining_type_id AS retraining_type_id_57,
  c0_.target_group_id AS target_group_id_58
FROM
  course c0_
WHERE
  (c0_.topic_id = ?)
  AND (
    c0_.organizer_id IN (
      SELECT
        o.id
      FROM
        organizer o
        JOIN fos_user__user u ON o.user_account_id = u.id
        JOIN account_state s ON u.account_state_id = s.id
      WHERE
        s.identifier = 'active'
        AND u.deleted_at IS NULL
    )
  )

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.deleted_at AS deleted_at_3, c0_.is_created_by_admin AS is_created_by_admin_4, c0_.name AS name_5, c0_.price AS price_6, c0_.price_description AS price_description_7, c0_.short_description AS short_description_8, c0_.description AS description_9, c0_.requirements AS requirements_10, c0_.published_at AS published_at_11, c0_.end_at AS end_at_12, c0_.length AS length_13, c0_.can_customize AS can_customize_14, c0_.is_preparation_for_certification AS is_preparation_for_certification_15, c0_.is_with_certificate AS is_with_certificate_16, c0_.can_buy AS can_buy_17, c0_.can_register AS can_register_18, c0_.email AS email_19, c0_.can_paid AS can_paid_20, c0_.frequency_text AS frequency_text_21, c0_.lesson_start AS lesson_start_22, c0_.lesson_end AS lesson_end_23, c0_.is_confirmation_of_participation AS is_confirmation_of_participation_24, c0_.certification_price_not_included AS certification_price_not_included_25, c0_.certification_price AS certification_price_26, c0_.confirmation_name AS confirmation_name_27, c0_.url AS url_28, c0_.code AS code_29, c0_.is_recommended AS is_recommended_30, c0_.rating AS rating_31, c0_.is_native_speaker AS is_native_speaker_32, c0_.is_customized AS is_customized_33, c0_.only_for_adults AS only_for_adults_34, c0_.last_step AS last_step_35, c0_.place_description AS place_description_36, c0_.latitude AS latitude_37, c0_.longitude AS longitude_38, c0_.identifier AS identifier_39, c0_.created_by_id AS created_by_id_40, c0_.updated_by_id AS updated_by_id_41, c0_.deleted_by_id AS deleted_by_id_42, c0_.organizer_id AS organizer_id_43, c0_.place_id AS place_id_44, c0_.state_id AS state_id_45, c0_.type_id AS type_id_46, c0_.certificate_id AS certificate_id_47, c0_.frequency_id AS frequency_id_48, c0_.place_type_id AS place_type_id_49, c0_.topic_id AS topic_id_50, c0_.length_type_id AS length_type_id_51, c0_.progress_level_id AS progress_level_id_52, c0_.language_level_input_id AS language_level_input_id_53, c0_.language_level_output_id AS language_level_output_id_54, c0_.city_id AS city_id_55, c0_.teaching_type_id AS teaching_type_id_56, c0_.retraining_type_id AS retraining_type_id_57, c0_.target_group_id AS target_group_id_58 FROM course c0_ WHERE (c0_.topic_id = 5) AND (c0_.organizer_id IN (
                SELECT o.id
                FROM organizer o
                JOIN fos_user__user u ON o.user_account_id = u.id
                JOIN account_state s ON u.account_state_id = s.id
                WHERE s.identifier = 'active' AND u.deleted_at IS NULL
            ));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.email AS email_7,
  t0.phone AS phone_8,
  t0.identifier AS identifier_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.deleted_by_id AS deleted_by_id_12,
  t0.address_id AS address_id_13,
  t0.organizer_id AS organizer_id_14
FROM
  place t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.email AS email_7, t0.phone AS phone_8, t0.identifier AS identifier_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.deleted_by_id AS deleted_by_id_12, t0.address_id AS address_id_13, t0.organizer_id AS organizer_id_14 FROM place t0 WHERE t0.id = 29;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.line1 AS line1_5,
  t0.line2 AS line2_6,
  t0.postal_code AS postal_code_7,
  t0.city AS city_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.identifier AS identifier_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13,
  t0.deleted_by_id AS deleted_by_id_14
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.line1 AS line1_5, t0.line2 AS line2_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.identifier AS identifier_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13, t0.deleted_by_id AS deleted_by_id_14 FROM address t0 WHERE t0.id = 117;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.identifier AS identifier_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.deleted_by_id AS deleted_by_id_10
FROM
  course_place_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.identifier AS identifier_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.deleted_by_id AS deleted_by_id_10 FROM course_place_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.is_created_by_admin AS is_created_by_admin_5,
  t0.name AS name_6,
  t0.price AS price_7,
  t0.price_description AS price_description_8,
  t0.short_description AS short_description_9,
  t0.description AS description_10,
  t0.requirements AS requirements_11,
  t0.published_at AS published_at_12,
  t0.end_at AS end_at_13,
  t0.length AS length_14,
  t0.can_customize AS can_customize_15,
  t0.is_preparation_for_certification AS is_preparation_for_certification_16,
  t0.is_with_certificate AS is_with_certificate_17,
  t0.can_buy AS can_buy_18,
  t0.can_register AS can_register_19,
  t0.email AS email_20,
  t0.can_paid AS can_paid_21,
  t0.frequency_text AS frequency_text_22,
  t0.lesson_start AS lesson_start_23,
  t0.lesson_end AS lesson_end_24,
  t0.is_confirmation_of_participation AS is_confirmation_of_participation_25,
  t0.certification_price_not_included AS certification_price_not_included_26,
  t0.certification_price AS certification_price_27,
  t0.confirmation_name AS confirmation_name_28,
  t0.url AS url_29,
  t0.code AS code_30,
  t0.is_recommended AS is_recommended_31,
  t0.rating AS rating_32,
  t0.is_native_speaker AS is_native_speaker_33,
  t0.is_customized AS is_customized_34,
  t0.only_for_adults AS only_for_adults_35,
  t0.last_step AS last_step_36,
  t0.place_description AS place_description_37,
  t0.latitude AS latitude_38,
  t0.longitude AS longitude_39,
  t0.identifier AS identifier_40,
  t0.created_by_id AS created_by_id_41,
  t0.updated_by_id AS updated_by_id_42,
  t0.deleted_by_id AS deleted_by_id_43,
  t0.organizer_id AS organizer_id_44,
  t0.place_id AS place_id_45,
  t0.state_id AS state_id_46,
  t0.type_id AS type_id_47,
  t0.certificate_id AS certificate_id_48,
  t0.frequency_id AS frequency_id_49,
  t0.place_type_id AS place_type_id_50,
  t0.topic_id AS topic_id_51,
  t0.length_type_id AS length_type_id_52,
  t0.progress_level_id AS progress_level_id_53,
  t0.language_level_input_id AS language_level_input_id_54,
  t0.language_level_output_id AS language_level_output_id_55,
  t0.city_id AS city_id_56,
  t0.teaching_type_id AS teaching_type_id_57,
  t0.retraining_type_id AS retraining_type_id_58,
  t0.target_group_id AS target_group_id_59
FROM
  course t0
WHERE
  t0.id = ?
  AND (
    (
      t0.organizer_id IN (
        SELECT
          o.id
        FROM
          organizer o
          JOIN fos_user__user u ON o.user_account_id = u.id
          JOIN account_state s ON u.account_state_id = s.id
        WHERE
          s.identifier = 'active'
          AND u.deleted_at IS NULL
      )
    )
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.is_created_by_admin AS is_created_by_admin_5, t0.name AS name_6, t0.price AS price_7, t0.price_description AS price_description_8, t0.short_description AS short_description_9, t0.description AS description_10, t0.requirements AS requirements_11, t0.published_at AS published_at_12, t0.end_at AS end_at_13, t0.length AS length_14, t0.can_customize AS can_customize_15, t0.is_preparation_for_certification AS is_preparation_for_certification_16, t0.is_with_certificate AS is_with_certificate_17, t0.can_buy AS can_buy_18, t0.can_register AS can_register_19, t0.email AS email_20, t0.can_paid AS can_paid_21, t0.frequency_text AS frequency_text_22, t0.lesson_start AS lesson_start_23, t0.lesson_end AS lesson_end_24, t0.is_confirmation_of_participation AS is_confirmation_of_participation_25, t0.certification_price_not_included AS certification_price_not_included_26, t0.certification_price AS certification_price_27, t0.confirmation_name AS confirmation_name_28, t0.url AS url_29, t0.code AS code_30, t0.is_recommended AS is_recommended_31, t0.rating AS rating_32, t0.is_native_speaker AS is_native_speaker_33, t0.is_customized AS is_customized_34, t0.only_for_adults AS only_for_adults_35, t0.last_step AS last_step_36, t0.place_description AS place_description_37, t0.latitude AS latitude_38, t0.longitude AS longitude_39, t0.identifier AS identifier_40, t0.created_by_id AS created_by_id_41, t0.updated_by_id AS updated_by_id_42, t0.deleted_by_id AS deleted_by_id_43, t0.organizer_id AS organizer_id_44, t0.place_id AS place_id_45, t0.state_id AS state_id_46, t0.type_id AS type_id_47, t0.certificate_id AS certificate_id_48, t0.frequency_id AS frequency_id_49, t0.place_type_id AS place_type_id_50, t0.topic_id AS topic_id_51, t0.length_type_id AS length_type_id_52, t0.progress_level_id AS progress_level_id_53, t0.language_level_input_id AS language_level_input_id_54, t0.language_level_output_id AS language_level_output_id_55, t0.city_id AS city_id_56, t0.teaching_type_id AS teaching_type_id_57, t0.retraining_type_id AS retraining_type_id_58, t0.target_group_id AS target_group_id_59 FROM course t0 WHERE t0.id = '3920' AND ((t0.organizer_id IN (
                SELECT o.id
                FROM organizer o
                JOIN fos_user__user u ON o.user_account_id = u.id
                JOIN account_state s ON u.account_state_id = s.id
                WHERE s.identifier = 'active' AND u.deleted_at IS NULL
            )));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.menu_title AS menu_title_7,
  t0.seo_title AS seo_title_8,
  t0.seo_keywords AS seo_keywords_9,
  t0.seo_description AS seo_description_10,
  t0.form_label AS form_label_11,
  t0.identifier AS identifier_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.deleted_by_id AS deleted_by_id_15
FROM
  course_topic t0

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.description AS description_6, t0.menu_title AS menu_title_7, t0.seo_title AS seo_title_8, t0.seo_keywords AS seo_keywords_9, t0.seo_description AS seo_description_10, t0.form_label AS form_label_11, t0.identifier AS identifier_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.deleted_by_id AS deleted_by_id_15 FROM course_topic t0;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.source AS source_5,
  t0.target AS target_6,
  t0.comment AS comment_7,
  t0.identifier AS identifier_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.deleted_by_id AS deleted_by_id_11
FROM
  redirect t0
WHERE
  t0.source = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.source AS source_5, t0.target AS target_6, t0.comment AS comment_7, t0.identifier AS identifier_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.deleted_by_id AS deleted_by_id_11 FROM redirect t0 WHERE t0.source = 'kurzy/3920/podobne' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.is_created_by_admin AS is_created_by_admin_6,
  t0.support_expiration AS support_expiration_7,
  t0.support_level_type AS support_level_type_8,
  t0.identifier AS identifier_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.deleted_by_id AS deleted_by_id_12,
  t0.user_account_id AS user_account_id_13,
  t0.logo_id AS logo_id_14,
  t0.logo_invoice_id AS logo_invoice_id_15,
  t0.support_level_id AS support_level_id_16,
  t0.address_id AS address_id_17
FROM
  organizer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.is_created_by_admin AS is_created_by_admin_6, t0.support_expiration AS support_expiration_7, t0.support_level_type AS support_level_type_8, t0.identifier AS identifier_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.deleted_by_id AS deleted_by_id_12, t0.user_account_id AS user_account_id_13, t0.logo_id AS logo_id_14, t0.logo_invoice_id AS logo_invoice_id_15, t0.support_level_id AS support_level_id_16, t0.address_id AS address_id_17 FROM organizer t0 WHERE t0.id = 31;