Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.enable AS enable_4,
  c0_.code AS code_5,
  c0_.commission AS commission_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.currency_id AS currency_id_8
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.enable AS enable_4, c0_.code AS code_5, c0_.commission AS commission_6, c0_.deleted_at AS deleted_at_7, c0_.currency_id AS currency_id_8 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

SELECT
  e0_.id AS id_0,
  e0_.hash AS hash_1,
  e0_.location_confirm AS location_confirm_2,
  e0_.split_type AS split_type_3,
  e0_.commission AS commission_4,
  e0_.type AS type_5,
  e0_.count_artists AS count_artists_6,
  e0_.count_musicians AS count_musicians_7,
  e0_.live AS live_8,
  e0_.pre_sale AS pre_sale_9,
  e0_.duration AS duration_10,
  e0_.status AS status_11,
  e0_.sell_status AS sell_status_12,
  e0_.recommended_age AS recommended_age_13,
  e0_.age_restrictions AS age_restrictions_14,
  e0_.social AS social_15,
  e0_.locale AS locale_16,
  e0_.tax AS tax_17,
  e0_.free_places AS free_places_18,
  e0_.buyed_tickets AS buyed_tickets_19,
  e0_.favorites_count AS favorites_count_20,
  e0_.min_sell_goal AS min_sell_goal_21,
  e0_.max_sell_goal AS max_sell_goal_22,
  e0_.active AS active_23,
  e0_.sell AS sell_24,
  e0_.date AS date_25,
  e0_.start_date AS start_date_26,
  e0_.end_date AS end_date_27,
  e0_.doors AS doors_28,
  e0_.start_sale_at AS start_sale_at_29,
  e0_.end_sale_at AS end_sale_at_30,
  e0_.created_at AS created_at_31,
  e0_.slug AS slug_32,
  e0_.deleted_at AS deleted_at_33,
  e0_.moderation_status AS moderation_status_34,
  e0_.creator_id AS creator_id_35,
  e0_.location_id AS location_id_36,
  e0_.country_id AS country_id_37,
  e0_.city_id AS city_id_38,
  e0_.currency_id AS currency_id_39,
  e0_.cover_id AS cover_id_40,
  e0_.gallery_id AS gallery_id_41,
  e0_.video_gallery_id AS video_gallery_id_42
FROM
  event e0_
WHERE
  (
    e0_.slug = ?
    OR e0_.hash = ?
  )
  AND (e0_.deleted_at IS NULL)

SELECT e0_.id AS id_0, e0_.hash AS hash_1, e0_.location_confirm AS location_confirm_2, e0_.split_type AS split_type_3, e0_.commission AS commission_4, e0_.type AS type_5, e0_.count_artists AS count_artists_6, e0_.count_musicians AS count_musicians_7, e0_.live AS live_8, e0_.pre_sale AS pre_sale_9, e0_.duration AS duration_10, e0_.status AS status_11, e0_.sell_status AS sell_status_12, e0_.recommended_age AS recommended_age_13, e0_.age_restrictions AS age_restrictions_14, e0_.social AS social_15, e0_.locale AS locale_16, e0_.tax AS tax_17, e0_.free_places AS free_places_18, e0_.buyed_tickets AS buyed_tickets_19, e0_.favorites_count AS favorites_count_20, e0_.min_sell_goal AS min_sell_goal_21, e0_.max_sell_goal AS max_sell_goal_22, e0_.active AS active_23, e0_.sell AS sell_24, e0_.date AS date_25, e0_.start_date AS start_date_26, e0_.end_date AS end_date_27, e0_.doors AS doors_28, e0_.start_sale_at AS start_sale_at_29, e0_.end_sale_at AS end_sale_at_30, e0_.created_at AS created_at_31, e0_.slug AS slug_32, e0_.deleted_at AS deleted_at_33, e0_.moderation_status AS moderation_status_34, e0_.creator_id AS creator_id_35, e0_.location_id AS location_id_36, e0_.country_id AS country_id_37, e0_.city_id AS city_id_38, e0_.currency_id AS currency_id_39, e0_.cover_id AS cover_id_40, e0_.gallery_id AS gallery_id_41, e0_.video_gallery_id AS video_gallery_id_42 FROM event e0_ WHERE (e0_.slug = 'concert-in-lisbon-25-september-2024-lissabon-portugaliya' OR e0_.hash = 'concert-in-lisbon-25-september-2024-lissabon-portugaliya') AND (e0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.legal_status AS legal_status_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.yandex AS yandex_7,
  t0.last_name AS last_name_8,
  t0.phone AS phone_9,
  t0.bank_account AS bank_account_10,
  t0.created_at AS created_at_11,
  t0.active AS active_12,
  t0.verified AS verified_13,
  t0.locale AS locale_14,
  t0.payment_account_id AS payment_account_id_15,
  t0.deleted_at AS deleted_at_16,
  t0.hash AS hash_17,
  t0.photo_id AS photo_id_18,
  t0.city_id AS city_id_19,
  t0.country_id AS country_id_20,
  t0.type,
  t0.artist_role AS artist_role_21,
  t0.age AS age_22,
  t0.social AS social_23,
  t0.social AS social_24
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'system', 'new', 'artist', 'location',
    'manager', 'organizer', 'label'
  )
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.legal_status AS legal_status_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.yandex AS yandex_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.bank_account AS bank_account_10, t0.created_at AS created_at_11, t0.active AS active_12, t0.verified AS verified_13, t0.locale AS locale_14, t0.payment_account_id AS payment_account_id_15, t0.deleted_at AS deleted_at_16, t0.hash AS hash_17, t0.photo_id AS photo_id_18, t0.city_id AS city_id_19, t0.country_id AS country_id_20, t0.type, t0.artist_role AS artist_role_21, t0.age AS age_22, t0.social AS social_23, t0.social AS social_24 FROM user t0 WHERE t0.id = 64 AND t0.type IN ('system', 'new', 'artist', 'location', 'manager', 'organizer', 'label') AND ((t0.deleted_at IS NULL));

SELECT
  e0_.id AS id_0,
  e0_.start_at AS start_at_1,
  e0_.end_at AS end_at_2,
  e0_.archive AS archive_3,
  e0_.deleted_at AS deleted_at_4,
  e1_.id AS id_5,
  e1_.active AS active_6,
  e1_.archive AS archive_7,
  e1_.places AS places_8,
  e1_.used_places AS used_places_9,
  e2_.id AS id_10,
  e2_.united AS united_11,
  e2_.archive AS archive_12,
  e3_.id AS id_13,
  e3_.row_name AS row_name_14,
  e3_.number AS number_15,
  e3_.active AS active_16,
  e3_.reserve AS reserve_17,
  e3_.archive AS archive_18,
  e4_.id AS id_19,
  e4_.max AS max_20,
  e4_.used AS used_21,
  e4_.free AS free_22,
  e4_.active AS active_23,
  e4_.type AS type_24,
  e4_.deleted_at AS deleted_at_25,
  e0_.event_id AS event_id_26,
  e0_.event_zone_id AS event_zone_id_27,
  e0_.ticket_type_id AS ticket_type_id_28,
  e0_.event_seat_group_id AS event_seat_group_id_29,
  e0_.event_seat_id AS event_seat_id_30,
  e1_.event_hall_id AS event_hall_id_31,
  e1_.zone_id AS zone_id_32,
  e1_.event_id AS event_id_33,
  e3_.event_id AS event_id_34,
  e3_.event_zone_id AS event_zone_id_35,
  e3_.seat_id AS seat_id_36,
  e3_.event_seat_group_id AS event_seat_group_id_37,
  e4_.event_id AS event_id_38
FROM
  event_price e0_
  LEFT JOIN event_zone e1_ ON e0_.event_zone_id = e1_.id
  LEFT JOIN event_seat_group e2_ ON e0_.event_seat_group_id = e2_.id
  LEFT JOIN event_seat e3_ ON e0_.event_seat_id = e3_.id
  LEFT JOIN event_ticket_type e4_ ON e0_.ticket_type_id = e4_.id
  AND (e4_.deleted_at IS NULL)
WHERE
  (
    e2_.archive = ?
    OR e2_.archive IS NULL
  )
  AND e0_.event_id = ?
  AND e0_.deleted_at IS NULL
  AND (
    (
      e0_.start_at <= ?
      OR e0_.start_at IS NULL
    )
    AND (
      e0_.end_at >= ?
      OR e0_.end_at IS NULL
    )
  )
ORDER BY
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.start_at AS start_at_1, e0_.end_at AS end_at_2, e0_.archive AS archive_3, e0_.deleted_at AS deleted_at_4, e1_.id AS id_5, e1_.active AS active_6, e1_.archive AS archive_7, e1_.places AS places_8, e1_.used_places AS used_places_9, e2_.id AS id_10, e2_.united AS united_11, e2_.archive AS archive_12, e3_.id AS id_13, e3_.row_name AS row_name_14, e3_.number AS number_15, e3_.active AS active_16, e3_.reserve AS reserve_17, e3_.archive AS archive_18, e4_.id AS id_19, e4_.max AS max_20, e4_.used AS used_21, e4_.free AS free_22, e4_.active AS active_23, e4_.type AS type_24, e4_.deleted_at AS deleted_at_25, e0_.event_id AS event_id_26, e0_.event_zone_id AS event_zone_id_27, e0_.ticket_type_id AS ticket_type_id_28, e0_.event_seat_group_id AS event_seat_group_id_29, e0_.event_seat_id AS event_seat_id_30, e1_.event_hall_id AS event_hall_id_31, e1_.zone_id AS zone_id_32, e1_.event_id AS event_id_33, e3_.event_id AS event_id_34, e3_.event_zone_id AS event_zone_id_35, e3_.seat_id AS seat_id_36, e3_.event_seat_group_id AS event_seat_group_id_37, e4_.event_id AS event_id_38 FROM event_price e0_ LEFT JOIN event_zone e1_ ON e0_.event_zone_id = e1_.id LEFT JOIN event_seat_group e2_ ON e0_.event_seat_group_id = e2_.id LEFT JOIN event_seat e3_ ON e0_.event_seat_id = e3_.id LEFT JOIN event_ticket_type e4_ ON e0_.ticket_type_id = e4_.id AND (e4_.deleted_at IS NULL) WHERE (e2_.archive = 0 OR e2_.archive IS NULL) AND e0_.event_id = 65 AND e0_.deleted_at IS NULL AND ((e0_.start_at <= '2024-09-28 20:17:58' OR e0_.start_at IS NULL) AND (e0_.end_at >= '2024-09-28 20:17:58' OR e0_.end_at IS NULL)) ORDER BY e0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.event_seat_id AS event_seat_id_3,
  t0.sub_seat_id AS sub_seat_id_4
FROM
  event_sub_seat t0
WHERE
  t0.event_seat_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.event_seat_id AS event_seat_id_3, t0.sub_seat_id AS sub_seat_id_4 FROM event_sub_seat t0 WHERE t0.event_seat_id IN (344, 345, 346, 347, 348, 349, 350, 351, 352, 353);

SELECT
  t0.id AS id_1,
  t0.row_name AS row_name_2,
  t0.number AS number_3,
  t0.scheme_id AS scheme_id_4,
  t0.active AS active_5,
  t0.zone_id AS zone_id_6
FROM
  seat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.row_name AS row_name_2, t0.number AS number_3, t0.scheme_id AS scheme_id_4, t0.active AS active_5, t0.zone_id AS zone_id_6 FROM seat t0 WHERE t0.id = 198;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.seat_id AS seat_id_4
FROM
  sub_seat t0
WHERE
  t0.seat_id IN (?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.seat_id AS seat_id_4 FROM sub_seat t0 WHERE t0.seat_id IN (198);

SELECT
  t0.id AS id_1,
  t0.row_name AS row_name_2,
  t0.number AS number_3,
  t0.scheme_id AS scheme_id_4,
  t0.active AS active_5,
  t0.zone_id AS zone_id_6
FROM
  seat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.row_name AS row_name_2, t0.number AS number_3, t0.scheme_id AS scheme_id_4, t0.active AS active_5, t0.zone_id AS zone_id_6 FROM seat t0 WHERE t0.id = 200;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.seat_id AS seat_id_4
FROM
  sub_seat t0
WHERE
  t0.seat_id IN (?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.seat_id AS seat_id_4 FROM sub_seat t0 WHERE t0.seat_id IN (200);

SELECT
  t0.id AS id_1,
  t0.row_name AS row_name_2,
  t0.number AS number_3,
  t0.scheme_id AS scheme_id_4,
  t0.active AS active_5,
  t0.zone_id AS zone_id_6
FROM
  seat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.row_name AS row_name_2, t0.number AS number_3, t0.scheme_id AS scheme_id_4, t0.active AS active_5, t0.zone_id AS zone_id_6 FROM seat t0 WHERE t0.id = 201;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.seat_id AS seat_id_4
FROM
  sub_seat t0
WHERE
  t0.seat_id IN (?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.seat_id AS seat_id_4 FROM sub_seat t0 WHERE t0.seat_id IN (201);

SELECT
  t0.id AS id_1,
  t0.row_name AS row_name_2,
  t0.number AS number_3,
  t0.scheme_id AS scheme_id_4,
  t0.active AS active_5,
  t0.zone_id AS zone_id_6
FROM
  seat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.row_name AS row_name_2, t0.number AS number_3, t0.scheme_id AS scheme_id_4, t0.active AS active_5, t0.zone_id AS zone_id_6 FROM seat t0 WHERE t0.id = 203;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.seat_id AS seat_id_4
FROM
  sub_seat t0
WHERE
  t0.seat_id IN (?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.seat_id AS seat_id_4 FROM sub_seat t0 WHERE t0.seat_id IN (203);

SELECT
  t0.id AS id_1,
  t0.row_name AS row_name_2,
  t0.number AS number_3,
  t0.scheme_id AS scheme_id_4,
  t0.active AS active_5,
  t0.zone_id AS zone_id_6
FROM
  seat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.row_name AS row_name_2, t0.number AS number_3, t0.scheme_id AS scheme_id_4, t0.active AS active_5, t0.zone_id AS zone_id_6 FROM seat t0 WHERE t0.id = 205;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.seat_id AS seat_id_4
FROM
  sub_seat t0
WHERE
  t0.seat_id IN (?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.seat_id AS seat_id_4 FROM sub_seat t0 WHERE t0.seat_id IN (205);

SELECT
  t0.id AS id_1,
  t0.row_name AS row_name_2,
  t0.number AS number_3,
  t0.scheme_id AS scheme_id_4,
  t0.active AS active_5,
  t0.zone_id AS zone_id_6
FROM
  seat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.row_name AS row_name_2, t0.number AS number_3, t0.scheme_id AS scheme_id_4, t0.active AS active_5, t0.zone_id AS zone_id_6 FROM seat t0 WHERE t0.id = 207;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.seat_id AS seat_id_4
FROM
  sub_seat t0
WHERE
  t0.seat_id IN (?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.seat_id AS seat_id_4 FROM sub_seat t0 WHERE t0.seat_id IN (207);