Symfony Profiler

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
  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_.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_.end_time >= '2024-11-24 11:14:27' 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 >= '2024-11-24 11:14:27' 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
  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 >= 2024 - 11 - 24
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 >= 2024 - 11 - 24 ORDER BY a1_.timestamp ASC LIMIT 10;

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
  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_.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_.end_time >= '2024-11-24 11:14:27' ORDER BY e0_.start_time ASC LIMIT 100;

SELECT
  t0.id AS id_7,
  t0.list_order AS list_order_8,
  t0.event_id AS event_id_9,
  t0.section_type,
  t1.headline AS headline_10,
  t1.headline_ar AS headline_ar_11,
  t2.image_id AS image_id_12,
  t3.url AS url_13,
  t3.embed_url AS embed_url_14,
  t4.text AS text_15,
  t4.text_ar AS text_ar_16,
  t6.gallery_id AS gallery_id_17
FROM
  section t0
  LEFT JOIN headline_section t1 ON t0.id = t1.id
  LEFT JOIN image_section t2 ON t0.id = t2.id
  LEFT JOIN video_section t3 ON t0.id = t3.id
  LEFT JOIN text_section t4 ON t0.id = t4.id
  LEFT JOIN uploads_section t5 ON t0.id = t5.id
  LEFT JOIN gallery_section t6 ON t0.id = t6.id
WHERE
  t0.event_id IN (?)
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_7, t0.list_order AS list_order_8, t0.event_id AS event_id_9, t0.section_type, t1.headline AS headline_10, t1.headline_ar AS headline_ar_11, t2.image_id AS image_id_12, t3.url AS url_13, t3.embed_url AS embed_url_14, t4.text AS text_15, t4.text_ar AS text_ar_16, t6.gallery_id AS gallery_id_17 FROM section t0 LEFT JOIN headline_section t1 ON t0.id = t1.id LEFT JOIN image_section t2 ON t0.id = t2.id LEFT JOIN video_section t3 ON t0.id = t3.id LEFT JOIN text_section t4 ON t0.id = t4.id LEFT JOIN uploads_section t5 ON t0.id = t5.id LEFT JOIN gallery_section t6 ON t0.id = t6.id WHERE t0.event_id IN (37697) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.provider_reference AS provider_reference_2,
  t0.context AS context_3,
  t0.updated_at AS updated_at_4,
  t0.created_at AS created_at_5
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.provider_reference AS provider_reference_2, t0.context AS context_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5 FROM media__media t0 WHERE t0.id = 67120;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.titleAr AS titleAr_4,
  t0.contentAr AS contentAr_5,
  t0.event_id AS event_id_6
FROM
  description t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.titleAr AS titleAr_4, t0.contentAr AS contentAr_5, t0.event_id AS event_id_6 FROM description t0 WHERE t0.event_id = 37697;

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
  INNER JOIN activity_category ON t0.id = activity_category.category_id
WHERE
  activity_category.activity_id = ?

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 INNER JOIN activity_category ON t0.id = activity_category.category_id WHERE activity_category.activity_id = 79831;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.nameAr AS nameAr_3,
  t0.start_time AS start_time_4,
  t0.end_time AS end_time_5,
  t0.location_name AS location_name_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.event_id AS event_id_11
FROM
  activity t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.nameAr AS nameAr_3, t0.start_time AS start_time_4, t0.end_time AS end_time_5, t0.location_name AS location_name_6, t0.city AS city_7, t0.country AS country_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.event_id AS event_id_11 FROM activity t0 WHERE t0.event_id = 37697;

SELECT
  t0.id AS id_1,
  t0.date_from AS date_from_2,
  t0.date_to AS date_to_3,
  t0.cost AS cost_4,
  t0.comment AS comment_5,
  t0.status AS status_6,
  t0.event_id AS event_id_7
FROM
  promotion t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.date_from AS date_from_2, t0.date_to AS date_to_3, t0.cost AS cost_4, t0.comment AS comment_5, t0.status AS status_6, t0.event_id AS event_id_7 FROM promotion t0 WHERE t0.event_id = 37697;