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 = 'letnij-vajb-28-august-2024-lissabon-portugal' OR e0_.hash = 'letnij-vajb-28-august-2024-lissabon-portugal') 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 = 120 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 = 56 AND e0_.deleted_at IS NULL AND ((e0_.start_at <= '2024-09-28 18:14:35' OR e0_.start_at IS NULL) AND (e0_.end_at >= '2024-09-28 18:14:35' OR e0_.end_at IS NULL)) ORDER BY e0_.id ASC;

SELECT
  e0_.id AS id_0,
  e0_.row_name AS row_name_1,
  e0_.number AS number_2,
  e0_.active AS active_3,
  e0_.reserve AS reserve_4,
  e0_.archive AS archive_5,
  e0_.event_id AS event_id_6,
  e0_.event_zone_id AS event_zone_id_7,
  e0_.seat_id AS seat_id_8,
  e0_.event_seat_group_id AS event_seat_group_id_9
FROM
  event_seat e0_
WHERE
  e0_.event_id = ?
  AND e0_.archive = ?

SELECT e0_.id AS id_0, e0_.row_name AS row_name_1, e0_.number AS number_2, e0_.active AS active_3, e0_.reserve AS reserve_4, e0_.archive AS archive_5, e0_.event_id AS event_id_6, e0_.event_zone_id AS event_zone_id_7, e0_.seat_id AS seat_id_8, e0_.event_seat_group_id AS event_seat_group_id_9 FROM event_seat e0_ WHERE e0_.event_id = 56 AND e0_.archive = 0;

SELECT
  e0_.id AS id_0,
  e0_.united AS united_1,
  e0_.archive AS archive_2
FROM
  event_seat_group e0_
  LEFT JOIN event_seat e1_ ON e0_.id = e1_.event_seat_group_id
WHERE
  e1_.event_id = ?
  AND e0_.archive = ?
GROUP BY
  e0_.id

SELECT e0_.id AS id_0, e0_.united AS united_1, e0_.archive AS archive_2 FROM event_seat_group e0_ LEFT JOIN event_seat e1_ ON e0_.id = e1_.event_seat_group_id WHERE e1_.event_id = 56 AND e0_.archive = 0 GROUP BY e0_.id;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.archive AS archive_3,
  t0.places AS places_4,
  t0.used_places AS used_places_5,
  t0.event_hall_id AS event_hall_id_6,
  t0.zone_id AS zone_id_7,
  t0.event_id AS event_id_8
FROM
  event_zone t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.archive AS archive_3, t0.places AS places_4, t0.used_places AS used_places_5, t0.event_hall_id AS event_hall_id_6, t0.zone_id AS zone_id_7, t0.event_id AS event_id_8 FROM event_zone t0 WHERE t0.event_id = 56;

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 = 56 AND e0_.deleted_at IS NULL AND ((e0_.start_at <= '2024-09-28 18:14:35' OR e0_.start_at IS NULL) AND (e0_.end_at >= '2024-09-28 18:14:35' OR e0_.end_at IS NULL)) ORDER BY e0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.locales AS locales_3,
  t0.active AS active_4,
  t0.enable AS enable_5,
  t0.code AS code_6,
  t0.commission AS commission_7,
  t0.deleted_at AS deleted_at_8,
  t0.currency_id AS currency_id_9
FROM
  country t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.locales AS locales_3, t0.active AS active_4, t0.enable AS enable_5, t0.code AS code_6, t0.commission AS commission_7, t0.deleted_at AS deleted_at_8, t0.currency_id AS currency_id_9 FROM country t0 WHERE t0.id = 2 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  country_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM country_translation t0 WHERE t0.translatable_id = 2;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sign AS sign_3,
  t0.active AS active_4,
  t0.deleted_at AS deleted_at_5
FROM
  currency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.contact_group AS contact_group_2,
  t0.active AS active_3,
  t0.deleted_at AS deleted_at_4,
  t0.event_id AS event_id_5
FROM
  event_contact t0
WHERE
  t0.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.contact_group AS contact_group_2, t0.active AS active_3, t0.deleted_at AS deleted_at_4, t0.event_id AS event_id_5 FROM event_contact t0 WHERE t0.event_id = 56 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2
FROM
  genre t0
  INNER JOIN event_genre ON t0.id = event_genre.genre_id
WHERE
  event_genre.event_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2 FROM genre t0 INNER JOIN event_genre ON t0.id = event_genre.genre_id WHERE event_genre.event_id = 56 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.use_photo_gallery AS use_photo_gallery_3,
  t0.use_video_gallery AS use_video_gallery_4,
  t0.confirmed AS confirmed_5,
  t0.hash AS hash_6,
  t0.event_id AS event_id_7,
  t0.band_id AS band_id_8
FROM
  event_band t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.use_photo_gallery AS use_photo_gallery_3, t0.use_video_gallery AS use_video_gallery_4, t0.confirmed AS confirmed_5, t0.hash AS hash_6, t0.event_id AS event_id_7, t0.band_id AS band_id_8 FROM event_band t0 WHERE t0.event_id = 56;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.pos AS pos_3,
  t0.event_id AS event_id_4,
  t0.logo_id AS logo_id_5
FROM
  event_partner t0
WHERE
  t0.event_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.id AS id_1, t0.active AS active_2, t0.pos AS pos_3, t0.event_id AS event_id_4, t0.logo_id AS logo_id_5 FROM event_partner t0 WHERE t0.event_id = 56 ORDER BY t0.pos ASC;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.archive AS archive_3,
  t0.places AS places_4,
  t0.used_places AS used_places_5,
  t0.free_places AS free_places_6,
  t0.event_id AS event_id_7,
  t0.hall_id AS hall_id_8,
  t9.id AS id_10,
  t9.event_hall_id AS event_hall_id_11,
  t9.layout_id AS layout_id_12
FROM
  event_hall t0
  LEFT JOIN event_layout t9 ON t9.event_hall_id = t0.id
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.archive AS archive_3, t0.places AS places_4, t0.used_places AS used_places_5, t0.free_places AS free_places_6, t0.event_id AS event_id_7, t0.hall_id AS hall_id_8, t9.id AS id_10, t9.event_hall_id AS event_hall_id_11, t9.layout_id AS layout_id_12 FROM event_hall t0 LEFT JOIN event_layout t9 ON t9.event_hall_id = t0.id WHERE t0.event_id = 56;