Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.name_ar AS name_ar_2,
  e0_.slug AS slug_3,
  e0_.active AS active_4,
  e0_.for_beginner AS for_beginner_5,
  e0_.is_highly_rated AS is_highly_rated_6,
  e0_.start_time AS start_time_7,
  e0_.end_time AS end_time_8,
  e0_.created_at AS created_at_9,
  e0_.updated_at AS updated_at_10,
  e0_.internal_tickets AS internal_tickets_11,
  e0_.facebook_tracking_id AS facebook_tracking_id_12,
  e0_.google_analytics_tracking_id AS google_analytics_tracking_id_13,
  e0_.organizer_id AS organizer_id_14,
  e0_.cover_image_id AS cover_image_id_15,
  e0_.gallery_id AS gallery_id_16
FROM
  event e0_
  INNER JOIN activity_log a1_ ON e0_.id = a1_.event_id
  INNER JOIN user u2_ ON a1_.user_id = u2_.id
WHERE
  u2_.id = ?
  AND a1_.type = ?
  AND e0_.start_time >= 2025 - 04 - 02
ORDER BY
  a1_.timestamp ASC
LIMIT
  10

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.name_ar AS name_ar_2, e0_.slug AS slug_3, e0_.active AS active_4, e0_.for_beginner AS for_beginner_5, e0_.is_highly_rated AS is_highly_rated_6, e0_.start_time AS start_time_7, e0_.end_time AS end_time_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.internal_tickets AS internal_tickets_11, e0_.facebook_tracking_id AS facebook_tracking_id_12, e0_.google_analytics_tracking_id AS google_analytics_tracking_id_13, e0_.organizer_id AS organizer_id_14, e0_.cover_image_id AS cover_image_id_15, e0_.gallery_id AS gallery_id_16 FROM event e0_ INNER JOIN activity_log a1_ ON e0_.id = a1_.event_id INNER JOIN user u2_ ON a1_.user_id = u2_.id WHERE u2_.id = NULL AND a1_.type = 1 AND e0_.start_time >= 2025 - 04 - 02 ORDER BY a1_.timestamp ASC LIMIT 10;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.name_ar AS name_ar_2,
  e0_.slug AS slug_3,
  e0_.active AS active_4,
  e0_.for_beginner AS for_beginner_5,
  e0_.is_highly_rated AS is_highly_rated_6,
  e0_.start_time AS start_time_7,
  e0_.end_time AS end_time_8,
  e0_.created_at AS created_at_9,
  e0_.updated_at AS updated_at_10,
  e0_.internal_tickets AS internal_tickets_11,
  e0_.facebook_tracking_id AS facebook_tracking_id_12,
  e0_.google_analytics_tracking_id AS google_analytics_tracking_id_13,
  e0_.organizer_id AS organizer_id_14,
  e0_.cover_image_id AS cover_image_id_15,
  e0_.gallery_id AS gallery_id_16
FROM
  event e0_
  INNER JOIN promotion p1_ ON e0_.id = p1_.event_id
WHERE
  e0_.active = ?
  AND e0_.start_time >= ?
  AND e0_.end_time <= ?
ORDER BY
  e0_.start_time ASC
LIMIT
  100

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.name_ar AS name_ar_2, e0_.slug AS slug_3, e0_.active AS active_4, e0_.for_beginner AS for_beginner_5, e0_.is_highly_rated AS is_highly_rated_6, e0_.start_time AS start_time_7, e0_.end_time AS end_time_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.internal_tickets AS internal_tickets_11, e0_.facebook_tracking_id AS facebook_tracking_id_12, e0_.google_analytics_tracking_id AS google_analytics_tracking_id_13, e0_.organizer_id AS organizer_id_14, e0_.cover_image_id AS cover_image_id_15, e0_.gallery_id AS gallery_id_16 FROM event e0_ INNER JOIN promotion p1_ ON e0_.id = p1_.event_id WHERE e0_.active = 1 AND e0_.start_time >= '2025-04-02 01:56:58' AND e0_.end_time <= '2025-04-09 01:56:58' ORDER BY e0_.start_time ASC LIMIT 100;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.name_ar AS name_ar_2,
  e0_.slug AS slug_3,
  e0_.active AS active_4,
  e0_.for_beginner AS for_beginner_5,
  e0_.is_highly_rated AS is_highly_rated_6,
  e0_.start_time AS start_time_7,
  e0_.end_time AS end_time_8,
  e0_.created_at AS created_at_9,
  e0_.updated_at AS updated_at_10,
  e0_.internal_tickets AS internal_tickets_11,
  e0_.facebook_tracking_id AS facebook_tracking_id_12,
  e0_.google_analytics_tracking_id AS google_analytics_tracking_id_13,
  e0_.organizer_id AS organizer_id_14,
  e0_.cover_image_id AS cover_image_id_15,
  e0_.gallery_id AS gallery_id_16
FROM
  event e0_
WHERE
  e0_.active = ?
  AND e0_.start_time >= ?
  AND e0_.end_time <= ?
ORDER BY
  e0_.start_time ASC
LIMIT
  3

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.name_ar AS name_ar_2, e0_.slug AS slug_3, e0_.active AS active_4, e0_.for_beginner AS for_beginner_5, e0_.is_highly_rated AS is_highly_rated_6, e0_.start_time AS start_time_7, e0_.end_time AS end_time_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.internal_tickets AS internal_tickets_11, e0_.facebook_tracking_id AS facebook_tracking_id_12, e0_.google_analytics_tracking_id AS google_analytics_tracking_id_13, e0_.organizer_id AS organizer_id_14, e0_.cover_image_id AS cover_image_id_15, e0_.gallery_id AS gallery_id_16 FROM event e0_ WHERE e0_.active = 1 AND e0_.start_time >= '2025-04-02 01:56:58' AND e0_.end_time <= '2025-04-09 01:56:58' ORDER BY e0_.start_time ASC LIMIT 3;

SELECT
  a0_.country AS country_0,
  a0_.city AS city_1,
  COUNT(DISTINCT e1_.id) AS sclr_2
FROM
  activity a0_
  INNER JOIN event e1_ ON a0_.event_id = e1_.id
WHERE
  e1_.active = 1
  AND e1_.end_time >= ?
  AND (
    a0_.country IS NOT NULL
    AND a0_.country <> ''
  )
  AND (
    a0_.city IS NOT NULL
    AND a0_.city <> ''
  )
GROUP BY
  a0_.country,
  a0_.city
ORDER BY
  sclr_2 DESC
LIMIT
  4

SELECT a0_.country AS country_0, a0_.city AS city_1, COUNT(DISTINCT e1_.id) AS sclr_2 FROM activity a0_ INNER JOIN event e1_ ON a0_.event_id = e1_.id WHERE e1_.active = 1 AND e1_.end_time >= '2025-04-02 01:56:58' AND (a0_.country IS NOT NULL AND a0_.country <> '') AND (a0_.city IS NOT NULL AND a0_.city <> '') GROUP BY a0_.country, a0_.city ORDER BY sclr_2 DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.colorCode AS colorCode_4,
  t0.nameAr AS nameAr_5,
  t0.position AS position_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.colorCode AS colorCode_4,
  t0.nameAr AS nameAr_5,
  t0.position AS position_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0;

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.name AS name_2,
  COUNT(DISTINCT e1_.id) AS sclr_3,
  c0_.colorCode AS colorCode_4,
  c0_.nameAr AS nameAr_5
FROM
  category c0_
  LEFT JOIN activity_category a3_ ON c0_.id = a3_.category_id
  LEFT JOIN activity a2_ ON a2_.id = a3_.activity_id
  LEFT JOIN event e1_ ON a2_.event_id = e1_.id
WHERE
  c0_.parent_category_id IS NULL
  AND (
    e1_.active IS NOT NULL
    AND e1_.active <> 0
  )
GROUP BY
  c0_.id
ORDER BY
  SUM(e1_.active) DESC
LIMIT
  4

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.name AS name_2, COUNT(DISTINCT e1_.id) AS sclr_3, c0_.colorCode AS colorCode_4, c0_.nameAr AS nameAr_5 FROM category c0_ LEFT JOIN activity_category a3_ ON c0_.id = a3_.category_id LEFT JOIN activity a2_ ON a2_.id = a3_.activity_id LEFT JOIN event e1_ ON a2_.event_id = e1_.id WHERE c0_.parent_category_id IS NULL AND (e1_.active IS NOT NULL AND e1_.active <> 0) GROUP BY c0_.id ORDER BY SUM(e1_.active) DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.colorCode AS colorCode_4,
  t0.nameAr AS nameAr_5,
  t0.position AS position_6,
  t0.parent_category_id AS parent_category_id_7
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0;