Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.ip AS ip_1,
  c0_.date AS date_2,
  c0_.course_id AS course_id_3,
  c0_.user_id AS user_id_4,
  c0_.organizer_id AS organizer_id_5
FROM
  course_stats c0_
WHERE
  c0_.ip = ?
  AND c0_.course_id = ?
ORDER BY
  c0_.date DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.ip AS ip_1, c0_.date AS date_2, c0_.course_id AS course_id_3, c0_.user_id AS user_id_4, c0_.organizer_id AS organizer_id_5 FROM course_stats c0_ WHERE c0_.ip = '47.79.2.24' AND c0_.course_id = 3971 ORDER BY c0_.date DESC 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.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 = '3971' 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.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/3971' 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.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.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.registration_start AS registration_start_5,
  t0.published_at AS published_at_6,
  t0.registration_end AS registration_end_7,
  t0.start AS start_8,
  t0.end AS end_9,
  t0.minimum_number_of_persons AS minimum_number_of_persons_10,
  t0.maximum_number_of_persons AS maximum_number_of_persons_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,
  t0.course_id AS course_id_16,
  t0.state_id AS state_id_17
FROM
  course_term t0
WHERE
  t0.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.registration_start AS registration_start_5, t0.published_at AS published_at_6, t0.registration_end AS registration_end_7, t0.start AS start_8, t0.end AS end_9, t0.minimum_number_of_persons AS minimum_number_of_persons_10, t0.maximum_number_of_persons AS maximum_number_of_persons_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, t0.course_id AS course_id_16, t0.state_id AS state_id_17 FROM course_term t0 WHERE t0.course_id = 3971;

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

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_anonymous AS is_anonymous_5,
  t0.course_rating AS course_rating_6,
  t0.course_review AS course_review_7,
  t0.lecturer_rating AS lecturer_rating_8,
  t0.lecturer_review AS lecturer_review_9,
  t0.place_rating AS place_rating_10,
  t0.place_review AS place_review_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,
  t0.course_id AS course_id_16,
  t0.applicant_id AS applicant_id_17
FROM
  course_review t0
WHERE
  t0.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.is_anonymous AS is_anonymous_5, t0.course_rating AS course_rating_6, t0.course_review AS course_review_7, t0.lecturer_rating AS lecturer_rating_8, t0.lecturer_review AS lecturer_review_9, t0.place_rating AS place_rating_10, t0.place_review AS place_review_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, t0.course_id AS course_id_16, t0.applicant_id AS applicant_id_17 FROM course_review t0 WHERE t0.course_id = 3971;

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;

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_state 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_state t0 WHERE t0.id = 7;

INSERT INTO course_stats (
  ip, date, course_id, user_id, organizer_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO course_stats (ip, date, course_id, user_id, organizer_id) VALUES ('47.79.2.24', '2025-06-08 01:18:56', 3971, NULL, 31);

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
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.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 WHERE t0.id = 5;

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;

"START TRANSACTION"

"START TRANSACTION";