Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.start_at AS start_at_2,
  e0_.end_at AS end_at_3,
  e0_.duration AS duration_4,
  e0_.content AS content_5,
  e0_.has_rrule AS has_rrule_6,
  e0_.image_name AS image_name_7,
  e0_.is_private AS is_private_8,
  e0_.available_for AS available_for_9,
  e0_.location AS location_10,
  e0_.theme AS theme_11,
  e0_.extra_info_organisation AS extra_info_organisation_12,
  e0_.is_finished AS is_finished_13,
  e0_.discord_link AS discord_link_14,
  e0_.created_at AS created_at_15,
  e0_.updated_at AS updated_at_16,
  e1_.id AS id_17,
  e1_.start_at AS start_at_18,
  e1_.end_at AS end_at_19,
  e2_.id AS id_20,
  e2_.is_infinite AS is_infinite_21,
  e2_.frequency AS frequency_22,
  e2_.dtstart AS dtstart_23,
  e2_.frequency_interval AS frequency_interval_24,
  e2_.wkst AS wkst_25,
  e2_.count AS count_26,
  e2_.until AS until_27,
  e2_.bymonth AS bymonth_28,
  e2_.byweekno AS byweekno_29,
  e2_.byyearday AS byyearday_30,
  e2_.bymonthday AS bymonthday_31,
  e2_.byday AS byday_32,
  e2_.byhour AS byhour_33,
  e2_.byminute AS byminute_34,
  e2_.bysecond AS bysecond_35,
  e2_.bysetpos AS bysetpos_36,
  e0_.rrule_id AS rrule_id_37,
  e0_.type_id AS type_id_38,
  e0_.created_by AS created_by_39,
  e0_.updated_by AS updated_by_40,
  e1_.event_id AS event_id_41
FROM
  event e0_
  LEFT JOIN event_date e1_ ON e0_.id = e1_.event_id
  LEFT JOIN event_rrule e2_ ON e0_.rrule_id = e2_.id
WHERE
  (
    (
      e0_.has_rrule = 0
      AND (
        e0_.end_at BETWEEN ?
        AND ?
      )
    )
    OR (
      e0_.has_rrule = 1
      AND (
        e2_.is_infinite = 1
        OR (
          e2_.is_infinite = 0
          AND (
            e1_.end_at BETWEEN ?
            AND ?
          )
        )
      )
    )
  )
  AND e0_.is_private = 0
ORDER BY
  e0_.start_at ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.start_at AS start_at_2, e0_.end_at AS end_at_3, e0_.duration AS duration_4, e0_.content AS content_5, e0_.has_rrule AS has_rrule_6, e0_.image_name AS image_name_7, e0_.is_private AS is_private_8, e0_.available_for AS available_for_9, e0_.location AS location_10, e0_.theme AS theme_11, e0_.extra_info_organisation AS extra_info_organisation_12, e0_.is_finished AS is_finished_13, e0_.discord_link AS discord_link_14, e0_.created_at AS created_at_15, e0_.updated_at AS updated_at_16, e1_.id AS id_17, e1_.start_at AS start_at_18, e1_.end_at AS end_at_19, e2_.id AS id_20, e2_.is_infinite AS is_infinite_21, e2_.frequency AS frequency_22, e2_.dtstart AS dtstart_23, e2_.frequency_interval AS frequency_interval_24, e2_.wkst AS wkst_25, e2_.count AS count_26, e2_.until AS until_27, e2_.bymonth AS bymonth_28, e2_.byweekno AS byweekno_29, e2_.byyearday AS byyearday_30, e2_.bymonthday AS bymonthday_31, e2_.byday AS byday_32, e2_.byhour AS byhour_33, e2_.byminute AS byminute_34, e2_.bysecond AS bysecond_35, e2_.bysetpos AS bysetpos_36, e0_.rrule_id AS rrule_id_37, e0_.type_id AS type_id_38, e0_.created_by AS created_by_39, e0_.updated_by AS updated_by_40, e1_.event_id AS event_id_41 FROM event e0_ LEFT JOIN event_date e1_ ON e0_.id = e1_.event_id LEFT JOIN event_rrule e2_ ON e0_.rrule_id = e2_.id WHERE ((e0_.has_rrule = 0 AND (e0_.end_at BETWEEN '2025-08-16 18:19:15' AND '2025-10-16 18:19:15')) OR (e0_.has_rrule = 1 AND (e2_.is_infinite = 1 OR (e2_.is_infinite = 0 AND (e1_.end_at BETWEEN '2025-08-16 18:19:15' AND '2025-10-16 18:19:15'))))) AND e0_.is_private = 0 ORDER BY e0_.start_at ASC;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.is_enabled AS is_enabled_2,
  m0_.is_actual_to_display AS is_actual_to_display_3,
  m0_.displayed_at AS displayed_at_4
FROM
  member_referral m0_
WHERE
  m0_.is_enabled = ?
  AND m0_.is_actual_to_display = ?
ORDER BY
  m0_.displayed_at ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.is_enabled AS is_enabled_2, m0_.is_actual_to_display AS is_actual_to_display_3, m0_.displayed_at AS displayed_at_4 FROM member_referral m0_ WHERE m0_.is_enabled = 1 AND m0_.is_actual_to_display = 1 ORDER BY m0_.displayed_at ASC;

SELECT
  e0_.id AS id_0,
  e0_.image_name AS image_name_1,
  e0_.is_active AS is_active_2,
  e0_.hightlight AS hightlight_3,
  e0_.display_order AS display_order_4,
  e0_.created_at AS created_at_5,
  e0_.updated_at AS updated_at_6,
  r1_.id AS id_7,
  r1_.rsi_id AS rsi_id_8,
  r1_.name AS name_9,
  r1_.type AS type_10,
  r1_.banner_image AS banner_image_11,
  r1_.link AS link_12,
  r1_.created_at AS created_at_13,
  r1_.updated_at AS updated_at_14,
  t2_.id AS id_15,
  t2_.name AS name_16,
  t2_.created_at AS created_at_17,
  t2_.updated_at AS updated_at_18,
  r3_.id AS id_19,
  r3_.rsi_id AS rsi_id_20,
  r3_.name AS name_21,
  r3_.rsi_image_name AS rsi_image_name_22,
  r3_.image_name AS image_name_23,
  r3_.created_at AS created_at_24,
  r3_.updated_at AS updated_at_25,
  e0_.taken_by_id AS taken_by_id_26,
  e0_.created_by AS created_by_27,
  e0_.updated_by AS updated_by_28,
  r1_.manufacturer_id AS manufacturer_id_29,
  t2_.created_by AS created_by_30,
  t2_.updated_by AS updated_by_31
FROM
  exploit e0_
  LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id
  LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id
  LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id
  LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id
  LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id
WHERE
  e0_.hightlight = ?
ORDER BY
  e0_.display_order ASC
LIMIT
  8

SELECT e0_.id AS id_0, e0_.image_name AS image_name_1, e0_.is_active AS is_active_2, e0_.hightlight AS hightlight_3, e0_.display_order AS display_order_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, r1_.id AS id_7, r1_.rsi_id AS rsi_id_8, r1_.name AS name_9, r1_.type AS type_10, r1_.banner_image AS banner_image_11, r1_.link AS link_12, r1_.created_at AS created_at_13, r1_.updated_at AS updated_at_14, t2_.id AS id_15, t2_.name AS name_16, t2_.created_at AS created_at_17, t2_.updated_at AS updated_at_18, r3_.id AS id_19, r3_.rsi_id AS rsi_id_20, r3_.name AS name_21, r3_.rsi_image_name AS rsi_image_name_22, r3_.image_name AS image_name_23, r3_.created_at AS created_at_24, r3_.updated_at AS updated_at_25, e0_.taken_by_id AS taken_by_id_26, e0_.created_by AS created_by_27, e0_.updated_by AS updated_by_28, r1_.manufacturer_id AS manufacturer_id_29, t2_.created_by AS created_by_30, t2_.updated_by AS updated_by_31 FROM exploit e0_ LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id WHERE e0_.hightlight = 1 ORDER BY e0_.display_order ASC LIMIT 8;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.content AS content_2,
  a0_.image_name AS image_name_3,
  a0_.display_order AS display_order_4,
  a0_.is_active AS is_active_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.created_by AS created_by_8,
  a0_.updated_by AS updated_by_9
FROM
  activity a0_
WHERE
  a0_.is_active = 1
ORDER BY
  a0_.display_order ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.image_name AS image_name_3, a0_.display_order AS display_order_4, a0_.is_active AS is_active_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.created_by AS created_by_8, a0_.updated_by AS updated_by_9 FROM activity a0_ WHERE a0_.is_active = 1 ORDER BY a0_.display_order ASC;

SELECT
  e0_.id AS id_0,
  e0_.image_name AS image_name_1,
  e0_.is_active AS is_active_2,
  e0_.hightlight AS hightlight_3,
  e0_.display_order AS display_order_4,
  e0_.created_at AS created_at_5,
  e0_.updated_at AS updated_at_6,
  r1_.id AS id_7,
  r1_.rsi_id AS rsi_id_8,
  r1_.name AS name_9,
  r1_.type AS type_10,
  r1_.banner_image AS banner_image_11,
  r1_.link AS link_12,
  r1_.created_at AS created_at_13,
  r1_.updated_at AS updated_at_14,
  t2_.id AS id_15,
  t2_.name AS name_16,
  t2_.created_at AS created_at_17,
  t2_.updated_at AS updated_at_18,
  r3_.id AS id_19,
  r3_.rsi_id AS rsi_id_20,
  r3_.name AS name_21,
  r3_.rsi_image_name AS rsi_image_name_22,
  r3_.image_name AS image_name_23,
  r3_.created_at AS created_at_24,
  r3_.updated_at AS updated_at_25,
  e0_.taken_by_id AS taken_by_id_26,
  e0_.created_by AS created_by_27,
  e0_.updated_by AS updated_by_28,
  r1_.manufacturer_id AS manufacturer_id_29,
  t2_.created_by AS created_by_30,
  t2_.updated_by AS updated_by_31
FROM
  exploit e0_
  LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id
  LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id
  LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id
  LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id
  LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id
WHERE
  e0_.hightlight = ?
ORDER BY
  e0_.display_order ASC
LIMIT
  8

SELECT e0_.id AS id_0, e0_.image_name AS image_name_1, e0_.is_active AS is_active_2, e0_.hightlight AS hightlight_3, e0_.display_order AS display_order_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, r1_.id AS id_7, r1_.rsi_id AS rsi_id_8, r1_.name AS name_9, r1_.type AS type_10, r1_.banner_image AS banner_image_11, r1_.link AS link_12, r1_.created_at AS created_at_13, r1_.updated_at AS updated_at_14, t2_.id AS id_15, t2_.name AS name_16, t2_.created_at AS created_at_17, t2_.updated_at AS updated_at_18, r3_.id AS id_19, r3_.rsi_id AS rsi_id_20, r3_.name AS name_21, r3_.rsi_image_name AS rsi_image_name_22, r3_.image_name AS image_name_23, r3_.created_at AS created_at_24, r3_.updated_at AS updated_at_25, e0_.taken_by_id AS taken_by_id_26, e0_.created_by AS created_by_27, e0_.updated_by AS updated_by_28, r1_.manufacturer_id AS manufacturer_id_29, t2_.created_by AS created_by_30, t2_.updated_by AS updated_by_31 FROM exploit e0_ LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id WHERE e0_.hightlight = 1 ORDER BY e0_.display_order ASC LIMIT 8;