Symfony Profiler

SELECT
  e0_.id AS id_0,
  u1_.id AS id_1,
  u2_.type AS type_2,
  e3_.parameter_types AS parameter_types_3,
  e3_.id AS id_4,
  e3_.value AS value_5
FROM
  user u1_
  LEFT JOIN user_event_subscribe u2_ ON u1_.id = u2_.user_id
  LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id
  LEFT JOIN event e0_ ON u2_.event_id = e0_.id
  LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id
  LEFT JOIN season s5_ ON u4_.season_id = s5_.id
  LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id
  LEFT JOIN event e7_ ON b6_.id = e7_.brand_id
WHERE
  (
    e0_.id IN (?)
    OR e0_.id IS NULL
  )
  AND (
    e0_.brand_id = b6_.id
    OR e0_.brand_id IS NULL
  )
  AND (
    e0_.event_date >= s5_.start_at
    OR e0_.event_date IS NULL
  )
  AND (
    e0_.event_date <= s5_.end_at
    OR e0_.event_date IS NULL
  )
  AND e7_.event_date >= s5_.start_at
  AND e7_.event_date <= s5_.end_at
  AND e7_.id = ?
  AND u2_.validate = 1
GROUP BY
  e0_.id,
  u1_.id,
  u2_.type,
  e3_.parameter_types,
  e3_.id

SELECT e0_.id AS id_0, u1_.id AS id_1, u2_.type AS type_2, e3_.parameter_types AS parameter_types_3, e3_.id AS id_4, e3_.value AS value_5 FROM user u1_ LEFT JOIN user_event_subscribe u2_ ON u1_.id = u2_.user_id LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id LEFT JOIN event e0_ ON u2_.event_id = e0_.id LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id LEFT JOIN season s5_ ON u4_.season_id = s5_.id LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id LEFT JOIN event e7_ ON b6_.id = e7_.brand_id WHERE (e0_.id IN (405) OR e0_.id IS NULL) AND (e0_.brand_id = b6_.id OR e0_.brand_id IS NULL) AND (e0_.event_date >= s5_.start_at OR e0_.event_date IS NULL) AND (e0_.event_date <= s5_.end_at OR e0_.event_date IS NULL) AND e7_.event_date >= s5_.start_at AND e7_.event_date <= s5_.end_at AND e7_.id = 405 AND u2_.validate = 1 GROUP BY e0_.id, u1_.id, u2_.type, e3_.parameter_types, e3_.id;

SELECT
  e0_.id AS id_0,
  u1_.id AS id_1,
  u2_.type AS type_2,
  e3_.parameter_types AS parameter_types_3,
  e3_.id AS id_4,
  e3_.value AS value_5
FROM
  user u1_
  LEFT JOIN user_final_event_subscribe u2_ ON u1_.id = u2_.user_id
  LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id
  LEFT JOIN event e0_ ON u2_.event_id = e0_.id
  LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id
  LEFT JOIN season s5_ ON u4_.season_id = s5_.id
  LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id
  LEFT JOIN event e7_ ON b6_.id = e7_.brand_id
WHERE
  (
    e0_.id IN (?)
    OR e0_.id IS NULL
  )
  AND (
    e0_.brand_id = b6_.id
    OR e0_.brand_id IS NULL
  )
  AND (
    e0_.event_date >= s5_.start_at
    OR e0_.event_date IS NULL
  )
  AND (
    e0_.event_date <= s5_.end_at
    OR e0_.event_date IS NULL
  )
  AND e7_.event_date >= s5_.start_at
  AND e7_.event_date <= s5_.end_at
  AND e7_.id = ?
  AND u2_.validate = 1
GROUP BY
  e0_.id,
  u1_.id,
  u2_.type,
  e3_.parameter_types,
  e3_.id

SELECT e0_.id AS id_0, u1_.id AS id_1, u2_.type AS type_2, e3_.parameter_types AS parameter_types_3, e3_.id AS id_4, e3_.value AS value_5 FROM user u1_ LEFT JOIN user_final_event_subscribe u2_ ON u1_.id = u2_.user_id LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id LEFT JOIN event e0_ ON u2_.event_id = e0_.id LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id LEFT JOIN season s5_ ON u4_.season_id = s5_.id LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id LEFT JOIN event e7_ ON b6_.id = e7_.brand_id WHERE (e0_.id IN (405) OR e0_.id IS NULL) AND (e0_.brand_id = b6_.id OR e0_.brand_id IS NULL) AND (e0_.event_date >= s5_.start_at OR e0_.event_date IS NULL) AND (e0_.event_date <= s5_.end_at OR e0_.event_date IS NULL) AND e7_.event_date >= s5_.start_at AND e7_.event_date <= s5_.end_at AND e7_.id = 405 AND u2_.validate = 1 GROUP BY e0_.id, u1_.id, u2_.type, e3_.parameter_types, e3_.id;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.price_list AS price_list_3,
  t0.booking_link AS booking_link_4,
  t0.event_date AS event_date_5,
  t0.event_end_date AS event_end_date_6,
  t0.gauge_limitation AS gauge_limitation_7,
  t0.post_intended_show AS post_intended_show_8,
  t0.post_intended_show_date_start AS post_intended_show_date_start_9,
  t0.post_intended_show_date_end AS post_intended_show_date_end_10,
  t0.post_prevision_show AS post_prevision_show_11,
  t0.post_prevision_show_date_start AS post_prevision_show_date_start_12,
  t0.post_prevision_show_date_end AS post_prevision_show_date_end_13,
  t0.id AS id_14,
  t0.deleted_at AS deleted_at_15,
  t0.base_information_content AS base_information_content_16,
  t0.base_information_name AS base_information_name_17,
  t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_18,
  t0.base_information_published_end AS base_information_published_end_19,
  t0.base_information_status AS base_information_status_20,
  t0.base_information_slug AS base_information_slug_21,
  t0.base_information_source AS base_information_source_22,
  t0.auditorium_id AS auditorium_id_23,
  t0.brand_id AS brand_id_24,
  t0.characteristic_id AS characteristic_id_25,
  t0.event_group_id AS event_group_id_26,
  t0.brand_guest_id AS brand_guest_id_27,
  t28.admin_token AS admin_token_29,
  t28.guest_token AS guest_token_30,
  t28.main_color AS main_color_31,
  t28.back_color AS back_color_32,
  t28.font_color AS font_color_33,
  t28.global_theme AS global_theme_34,
  t28.square_digit AS square_digit_35,
  t28.period_number AS period_number_36,
  t28.period_time AS period_time_37,
  t28.round_use_chrono AS round_use_chrono_38,
  t28.caucus_duration AS caucus_duration_39,
  t28.hymn_title AS hymn_title_40,
  t28.pause_duration AS pause_duration_41,
  t28.training_duration AS training_duration_42,
  t28.vote_title AS vote_title_43,
  t28.id AS id_44,
  t28.created_at AS created_at_45,
  t28.updated_at AS updated_at_46,
  t28.event_id AS event_id_47,
  t0.public_content_id AS public_content_id_48,
  t0.author_id AS author_id_49,
  t0.creator_id AS creator_id_50,
  t0.update_by_id AS update_by_id_51,
  t0.cms_description_id AS cms_description_id_52,
  t0.cms_organisation_id AS cms_organisation_id_53
FROM
  event t0
  LEFT JOIN historic t28 ON t28.event_id = t0.id
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.price_list AS price_list_3, t0.booking_link AS booking_link_4, t0.event_date AS event_date_5, t0.event_end_date AS event_end_date_6, t0.gauge_limitation AS gauge_limitation_7, t0.post_intended_show AS post_intended_show_8, t0.post_intended_show_date_start AS post_intended_show_date_start_9, t0.post_intended_show_date_end AS post_intended_show_date_end_10, t0.post_prevision_show AS post_prevision_show_11, t0.post_prevision_show_date_start AS post_prevision_show_date_start_12, t0.post_prevision_show_date_end AS post_prevision_show_date_end_13, t0.id AS id_14, t0.deleted_at AS deleted_at_15, t0.base_information_content AS base_information_content_16, t0.base_information_name AS base_information_name_17, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_18, t0.base_information_published_end AS base_information_published_end_19, t0.base_information_status AS base_information_status_20, t0.base_information_slug AS base_information_slug_21, t0.base_information_source AS base_information_source_22, t0.auditorium_id AS auditorium_id_23, t0.brand_id AS brand_id_24, t0.characteristic_id AS characteristic_id_25, t0.event_group_id AS event_group_id_26, t0.brand_guest_id AS brand_guest_id_27, t28.admin_token AS admin_token_29, t28.guest_token AS guest_token_30, t28.main_color AS main_color_31, t28.back_color AS back_color_32, t28.font_color AS font_color_33, t28.global_theme AS global_theme_34, t28.square_digit AS square_digit_35, t28.period_number AS period_number_36, t28.period_time AS period_time_37, t28.round_use_chrono AS round_use_chrono_38, t28.caucus_duration AS caucus_duration_39, t28.hymn_title AS hymn_title_40, t28.pause_duration AS pause_duration_41, t28.training_duration AS training_duration_42, t28.vote_title AS vote_title_43, t28.id AS id_44, t28.created_at AS created_at_45, t28.updated_at AS updated_at_46, t28.event_id AS event_id_47, t0.public_content_id AS public_content_id_48, t0.author_id AS author_id_49, t0.creator_id AS creator_id_50, t0.update_by_id AS update_by_id_51, t0.cms_description_id AS cms_description_id_52, t0.cms_organisation_id AS cms_organisation_id_53 FROM event t0 LEFT JOIN historic t28 ON t28.event_id = t0.id WHERE t0.id = '405';

SELECT
  e0_.id AS id_0,
  u1_.id AS id_1,
  u2_.type AS type_2,
  e3_.parameter_types AS parameter_types_3,
  e3_.id AS id_4,
  e3_.value AS value_5
FROM
  user u1_
  LEFT JOIN user_event_group_subscribe u2_ ON u1_.id = u2_.user_id
  LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id
  LEFT JOIN event_group e0_ ON u2_.event_id = e0_.id
  LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id
  LEFT JOIN season s5_ ON u4_.season_id = s5_.id
  LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id
  LEFT JOIN event e7_ ON b6_.id = e7_.brand_id
WHERE
  (
    e0_.id IN (?)
    OR e0_.id IS NULL
  )
  AND (
    e0_.brand_id = b6_.id
    OR e0_.brand_id IS NULL
  )
  AND (
    e0_.event_date >= s5_.start_at
    OR e0_.event_date IS NULL
  )
  AND (
    e0_.event_date <= s5_.end_at
    OR e0_.event_date IS NULL
  )
  AND e7_.event_date >= s5_.start_at
  AND e7_.event_date <= s5_.end_at
  AND e7_.id = ?
  AND u2_.validate = 1
GROUP BY
  e0_.id,
  u1_.id,
  u2_.type,
  e3_.parameter_types,
  e3_.id

SELECT e0_.id AS id_0, u1_.id AS id_1, u2_.type AS type_2, e3_.parameter_types AS parameter_types_3, e3_.id AS id_4, e3_.value AS value_5 FROM user u1_ LEFT JOIN user_event_group_subscribe u2_ ON u1_.id = u2_.user_id LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id LEFT JOIN event_group e0_ ON u2_.event_id = e0_.id LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id LEFT JOIN season s5_ ON u4_.season_id = s5_.id LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id LEFT JOIN event e7_ ON b6_.id = e7_.brand_id WHERE (e0_.id IN (405) OR e0_.id IS NULL) AND (e0_.brand_id = b6_.id OR e0_.brand_id IS NULL) AND (e0_.event_date >= s5_.start_at OR e0_.event_date IS NULL) AND (e0_.event_date <= s5_.end_at OR e0_.event_date IS NULL) AND e7_.event_date >= s5_.start_at AND e7_.event_date <= s5_.end_at AND e7_.id = 405 AND u2_.validate = 1 GROUP BY e0_.id, u1_.id, u2_.type, e3_.parameter_types, e3_.id;

SELECT
  u0_.is_active AS is_active_0,
  u0_.username AS username_1,
  u0_.user_token AS user_token_2,
  u0_.user_token_type AS user_token_type_3,
  u0_.email AS email_4,
  u0_.password AS password_5,
  u0_.roles AS roles_6,
  u0_.surname AS surname_7,
  u0_.short_description AS short_description_8,
  u0_.slug AS slug_9,
  u0_.test_user_type AS test_user_type_10,
  u0_.id AS id_11,
  u0_.deleted_at AS deleted_at_12,
  u0_.created_at AS created_at_13,
  u0_.updated_at AS updated_at_14,
  u0_.image_id AS image_id_15,
  u0_.contact_id AS contact_id_16,
  u0_.current_season_id AS current_season_id_17,
  u0_.author_id AS author_id_18,
  u0_.creator_id AS creator_id_19,
  u0_.update_by_id AS update_by_id_20
FROM
  user u0_
  INNER JOIN user_season u1_ ON u0_.id = u1_.user_id
  INNER JOIN season s2_ ON u1_.season_id = s2_.id
  INNER JOIN brand b3_ ON s2_.brand_id = b3_.id
  INNER JOIN event e4_ ON b3_.id = e4_.brand_id
WHERE
  e4_.brand_id = b3_.id
  AND e4_.event_date >= s2_.start_at
  AND e4_.event_date <= s2_.end_at
  AND e4_.id = ?
ORDER BY
  u0_.surname ASC

SELECT u0_.is_active AS is_active_0, u0_.username AS username_1, u0_.user_token AS user_token_2, u0_.user_token_type AS user_token_type_3, u0_.email AS email_4, u0_.password AS password_5, u0_.roles AS roles_6, u0_.surname AS surname_7, u0_.short_description AS short_description_8, u0_.slug AS slug_9, u0_.test_user_type AS test_user_type_10, u0_.id AS id_11, u0_.deleted_at AS deleted_at_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.image_id AS image_id_15, u0_.contact_id AS contact_id_16, u0_.current_season_id AS current_season_id_17, u0_.author_id AS author_id_18, u0_.creator_id AS creator_id_19, u0_.update_by_id AS update_by_id_20 FROM user u0_ INNER JOIN user_season u1_ ON u0_.id = u1_.user_id INNER JOIN season s2_ ON u1_.season_id = s2_.id INNER JOIN brand b3_ ON s2_.brand_id = b3_.id INNER JOIN event e4_ ON b3_.id = e4_.brand_id WHERE e4_.brand_id = b3_.id AND e4_.event_date >= s2_.start_at AND e4_.event_date <= s2_.end_at AND e4_.id = 405 ORDER BY u0_.surname ASC;

SELECT
  t0.content AS content_1,
  t0.id AS id_2,
  t0.deleted_at AS deleted_at_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.author_id AS author_id_6,
  t0.creator_id AS creator_id_7,
  t0.update_by_id AS update_by_id_8
FROM
  cms_content t0
WHERE
  t0.id = ?

SELECT t0.content AS content_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.author_id AS author_id_6, t0.creator_id AS creator_id_7, t0.update_by_id AS update_by_id_8 FROM cms_content t0 WHERE t0.id = 266;

SELECT
  t0.active AS active_1,
  t0.parameter_types AS parameter_types_2,
  t0.choice_types AS choice_types_3,
  t0.value AS value_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7,
  t0.deleted_at AS deleted_at_8,
  t0.brand_id AS brand_id_9
FROM
  brand_parameters t0
  INNER JOIN user_season_brand_parameters ON t0.id = user_season_brand_parameters.brand_parameters_id
WHERE
  user_season_brand_parameters.user_season_id = ?

SELECT t0.active AS active_1, t0.parameter_types AS parameter_types_2, t0.choice_types AS choice_types_3, t0.value AS value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.brand_id AS brand_id_9 FROM brand_parameters t0 INNER JOIN user_season_brand_parameters ON t0.id = user_season_brand_parameters.brand_parameters_id WHERE user_season_brand_parameters.user_season_id = 702;

SELECT
  t0.is_active AS is_active_1,
  t0.username AS username_2,
  t0.user_token AS user_token_3,
  t0.user_token_type AS user_token_type_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.surname AS surname_8,
  t0.short_description AS short_description_9,
  t0.slug AS slug_10,
  t0.test_user_type AS test_user_type_11,
  t0.id AS id_12,
  t0.deleted_at AS deleted_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.image_id AS image_id_16,
  t0.contact_id AS contact_id_17,
  t0.current_season_id AS current_season_id_18,
  t0.author_id AS author_id_19,
  t0.creator_id AS creator_id_20,
  t0.update_by_id AS update_by_id_21
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.is_active AS is_active_1, t0.username AS username_2, t0.user_token AS user_token_3, t0.user_token_type AS user_token_type_4, t0.email AS email_5, t0.password AS password_6, t0.roles AS roles_7, t0.surname AS surname_8, t0.short_description AS short_description_9, t0.slug AS slug_10, t0.test_user_type AS test_user_type_11, t0.id AS id_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.image_id AS image_id_16, t0.contact_id AS contact_id_17, t0.current_season_id AS current_season_id_18, t0.author_id AS author_id_19, t0.creator_id AS creator_id_20, t0.update_by_id AS update_by_id_21 FROM user t0 WHERE t0.username = 'davidduhem@gmail.com' LIMIT 1;

SELECT
  s0_.name AS name_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  s0_.id AS id_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.brand_id AS brand_id_7
FROM
  season s0_
  INNER JOIN brand b1_ ON s0_.brand_id = b1_.id
WHERE
  b1_.base_information_slug = 'defaut'
LIMIT
  1

SELECT s0_.name AS name_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.id AS id_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.brand_id AS brand_id_7 FROM season s0_ INNER JOIN brand b1_ ON s0_.brand_id = b1_.id WHERE b1_.base_information_slug = 'defaut' LIMIT 1;

SELECT
  t0.color_background AS color_background_1,
  t0.color_text AS color_text_2,
  t0.extra_type AS extra_type_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.deleted_at AS deleted_at_7,
  t0.base_information_content AS base_information_content_8,
  t0.base_information_name AS base_information_name_9,
  t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_10,
  t0.base_information_published_end AS base_information_published_end_11,
  t0.base_information_status AS base_information_status_12,
  t0.base_information_slug AS base_information_slug_13,
  t0.base_information_source AS base_information_source_14,
  t0.brand_id AS brand_id_15,
  t0.author_id AS author_id_16,
  t0.creator_id AS creator_id_17,
  t0.update_by_id AS update_by_id_18,
  t0.cms_description_id AS cms_description_id_19,
  t0.cms_organisation_id AS cms_organisation_id_20
FROM
  event_characteristic t0
WHERE
  t0.id = ?

SELECT t0.color_background AS color_background_1, t0.color_text AS color_text_2, t0.extra_type AS extra_type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.base_information_content AS base_information_content_8, t0.base_information_name AS base_information_name_9, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_10, t0.base_information_published_end AS base_information_published_end_11, t0.base_information_status AS base_information_status_12, t0.base_information_slug AS base_information_slug_13, t0.base_information_source AS base_information_source_14, t0.brand_id AS brand_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18, t0.cms_description_id AS cms_description_id_19, t0.cms_organisation_id AS cms_organisation_id_20 FROM event_characteristic t0 WHERE t0.id = 24;

SELECT
  e0_.id AS id_0,
  u1_.id AS id_1,
  u2_.type AS type_2,
  e3_.parameter_types AS parameter_types_3,
  e3_.id AS id_4,
  e3_.value AS value_5
FROM
  user u1_
  LEFT JOIN user_final_event_group_subscribe u2_ ON u1_.id = u2_.user_id
  LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id
  LEFT JOIN event_group e0_ ON u2_.event_id = e0_.id
  LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id
  LEFT JOIN season s5_ ON u4_.season_id = s5_.id
  LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id
  LEFT JOIN event e7_ ON b6_.id = e7_.brand_id
WHERE
  (
    e0_.id IN (?)
    OR e0_.id IS NULL
  )
  AND (
    e0_.brand_id = b6_.id
    OR e0_.brand_id IS NULL
  )
  AND (
    e0_.event_date >= s5_.start_at
    OR e0_.event_date IS NULL
  )
  AND (
    e0_.event_date <= s5_.end_at
    OR e0_.event_date IS NULL
  )
  AND e7_.event_date >= s5_.start_at
  AND e7_.event_date <= s5_.end_at
  AND e7_.id = ?
  AND u2_.validate = 1
GROUP BY
  e0_.id,
  u1_.id,
  u2_.type,
  e3_.parameter_types,
  e3_.id

SELECT e0_.id AS id_0, u1_.id AS id_1, u2_.type AS type_2, e3_.parameter_types AS parameter_types_3, e3_.id AS id_4, e3_.value AS value_5 FROM user u1_ LEFT JOIN user_final_event_group_subscribe u2_ ON u1_.id = u2_.user_id LEFT JOIN event_parameters e3_ ON u2_.choice_id = e3_.id LEFT JOIN event_group e0_ ON u2_.event_id = e0_.id LEFT JOIN user_season u4_ ON u1_.id = u4_.user_id LEFT JOIN season s5_ ON u4_.season_id = s5_.id LEFT JOIN brand b6_ ON s5_.brand_id = b6_.id LEFT JOIN event e7_ ON b6_.id = e7_.brand_id WHERE (e0_.id IN (405) OR e0_.id IS NULL) AND (e0_.brand_id = b6_.id OR e0_.brand_id IS NULL) AND (e0_.event_date >= s5_.start_at OR e0_.event_date IS NULL) AND (e0_.event_date <= s5_.end_at OR e0_.event_date IS NULL) AND e7_.event_date >= s5_.start_at AND e7_.event_date <= s5_.end_at AND e7_.id = 405 AND u2_.validate = 1 GROUP BY e0_.id, u1_.id, u2_.type, e3_.parameter_types, e3_.id;

SELECT
  t0.active AS active_1,
  t0.parameter_types AS parameter_types_2,
  t0.choice_types AS choice_types_3,
  t0.value AS value_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7,
  t0.deleted_at AS deleted_at_8,
  t0.brand_id AS brand_id_9
FROM
  event_parameters t0
WHERE
  t0.id = ?

SELECT t0.active AS active_1, t0.parameter_types AS parameter_types_2, t0.choice_types AS choice_types_3, t0.value AS value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.brand_id AS brand_id_9 FROM event_parameters t0 WHERE t0.id = 21;

SELECT
  t0.lang AS lang_1,
  t0.asso_planner_active AS asso_planner_active_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.base_information_content AS base_information_content_7,
  t0.base_information_name AS base_information_name_8,
  t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9,
  t0.base_information_published_end AS base_information_published_end_10,
  t0.base_information_status AS base_information_status_11,
  t0.base_information_slug AS base_information_slug_12,
  t0.base_information_source AS base_information_source_13,
  t0.address_id AS address_id_14,
  t0.cms_content_id AS cms_content_id_15,
  t0.author_id AS author_id_16,
  t0.creator_id AS creator_id_17,
  t0.update_by_id AS update_by_id_18
FROM
  brand t0
  INNER JOIN event_brand ON t0.id = event_brand.brand_id
WHERE
  event_brand.event_id = ?

SELECT t0.lang AS lang_1, t0.asso_planner_active AS asso_planner_active_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base_information_content AS base_information_content_7, t0.base_information_name AS base_information_name_8, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9, t0.base_information_published_end AS base_information_published_end_10, t0.base_information_status AS base_information_status_11, t0.base_information_slug AS base_information_slug_12, t0.base_information_source AS base_information_source_13, t0.address_id AS address_id_14, t0.cms_content_id AS cms_content_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18 FROM brand t0 INNER JOIN event_brand ON t0.id = event_brand.brand_id WHERE event_brand.event_id = 405;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.type AS type_3,
  t0.validate AS validate_4,
  t0.id AS id_5,
  t0.deleted_at AS deleted_at_6,
  t0.event_id AS event_id_7,
  t0.choice_id AS choice_id_8,
  t0.user_id AS user_id_9
FROM
  user_final_event_subscribe t0
WHERE
  t0.event_id = ?
  AND t0.user_id = ?
  AND t0.validate = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.type AS type_3, t0.validate AS validate_4, t0.id AS id_5, t0.deleted_at AS deleted_at_6, t0.event_id AS event_id_7, t0.choice_id AS choice_id_8, t0.user_id AS user_id_9 FROM user_final_event_subscribe t0 WHERE t0.event_id = 405 AND t0.user_id = 353 AND t0.validate = 1;

SELECT
  t0.id AS id_1,
  t0.event_id AS event_id_2,
  t0.proposal_event_date_id AS proposal_event_date_id_3,
  t0.post_id AS post_id_4
FROM
  post_intended_event t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.event_id AS event_id_2, t0.proposal_event_date_id AS proposal_event_date_id_3, t0.post_id AS post_id_4 FROM post_intended_event t0 WHERE t0.event_id = 405;

SELECT
  t0.common_password AS common_password_1,
  t0.slug AS slug_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.season_id AS season_id_7,
  t0.author_id AS author_id_8,
  t0.creator_id AS creator_id_9,
  t0.update_by_id AS update_by_id_10
FROM
  seminar t0
WHERE
  t0.season_id = ?

SELECT t0.common_password AS common_password_1, t0.slug AS slug_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.season_id AS season_id_7, t0.author_id AS author_id_8, t0.creator_id AS creator_id_9, t0.update_by_id AS update_by_id_10 FROM seminar t0 WHERE t0.season_id = 4;

SELECT
  t0.id AS id_1,
  t0.event_id AS event_id_2,
  t0.post_id AS post_id_3
FROM
  post_prevision_event t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.event_id AS event_id_2, t0.post_id AS post_id_3 FROM post_prevision_event t0 WHERE t0.event_id = 405;

SELECT
  t0.validated_date AS validated_date_1,
  t0.proposal_start AS proposal_start_2,
  t0.proposal_end AS proposal_end_3,
  t0.id AS id_4,
  t0.deleted_at AS deleted_at_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.event_id AS event_id_8,
  t0.author_id AS author_id_9,
  t0.creator_id AS creator_id_10,
  t0.update_by_id AS update_by_id_11
FROM
  proposal_event_date t0
WHERE
  t0.event_id = ?

SELECT t0.validated_date AS validated_date_1, t0.proposal_start AS proposal_start_2, t0.proposal_end AS proposal_end_3, t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_id AS event_id_8, t0.author_id AS author_id_9, t0.creator_id AS creator_id_10, t0.update_by_id AS update_by_id_11 FROM proposal_event_date t0 WHERE t0.event_id = 405;

SELECT
  t0.lang AS lang_1,
  t0.asso_planner_active AS asso_planner_active_2,
  t0.id AS id_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.base_information_content AS base_information_content_7,
  t0.base_information_name AS base_information_name_8,
  t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9,
  t0.base_information_published_end AS base_information_published_end_10,
  t0.base_information_status AS base_information_status_11,
  t0.base_information_slug AS base_information_slug_12,
  t0.base_information_source AS base_information_source_13,
  t0.address_id AS address_id_14,
  t0.cms_content_id AS cms_content_id_15,
  t0.author_id AS author_id_16,
  t0.creator_id AS creator_id_17,
  t0.update_by_id AS update_by_id_18
FROM
  brand t0
WHERE
  t0.id = ?