Symfony Profiler

SELECT
  COUNT(1) AS sclr_0
FROM
  review r0_
WHERE
  r0_.event_id = ?

SELECT COUNT(1) AS sclr_0 FROM review r0_ WHERE r0_.event_id = 37697;

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.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.price AS price_4,
  t0.currency AS currency_5,
  t0.name AS name_6,
  t0.name_ar AS name_ar_7,
  t0.url AS url_8,
  t0.amount AS amount_9,
  t0.amount_sold AS amount_sold_10,
  t0.with_tshirt AS with_tshirt_11,
  t0.activity_id AS activity_id_12
FROM
  ticket t0
WHERE
  t0.activity_id = ?

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.price AS price_4, t0.currency AS currency_5, t0.name AS name_6, t0.name_ar AS name_ar_7, t0.url AS url_8, t0.amount AS amount_9, t0.amount_sold AS amount_sold_10, t0.with_tshirt AS with_tshirt_11, t0.activity_id AS activity_id_12 FROM ticket t0 WHERE t0.activity_id = 79831;

SELECT
  t0.id AS id_1,
  t0.score_overall AS score_overall_2,
  t0.score_organization AS score_organization_3,
  t0.score_course AS score_course_4,
  t0.score_price AS score_price_5,
  t0.comment AS comment_6,
  t0.created_at AS created_at_7,
  t0.event_id AS event_id_8,
  t0.user_id AS user_id_9
FROM
  review t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.score_overall AS score_overall_2, t0.score_organization AS score_organization_3, t0.score_course AS score_course_4, t0.score_price AS score_price_5, t0.comment AS comment_6, t0.created_at AS created_at_7, t0.event_id AS event_id_8, t0.user_id AS user_id_9 FROM review t0 WHERE t0.event_id = 37697;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_ar AS name_ar_3,
  t0.slug AS slug_4,
  t0.active AS active_5,
  t0.for_beginner AS for_beginner_6,
  t0.is_highly_rated AS is_highly_rated_7,
  t0.start_time AS start_time_8,
  t0.end_time AS end_time_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.internal_tickets AS internal_tickets_12,
  t0.facebook_tracking_id AS facebook_tracking_id_13,
  t0.google_analytics_tracking_id AS google_analytics_tracking_id_14,
  t0.organizer_id AS organizer_id_15,
  t0.cover_image_id AS cover_image_id_16,
  t0.gallery_id AS gallery_id_17
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_ar AS name_ar_3, t0.slug AS slug_4, t0.active AS active_5, t0.for_beginner AS for_beginner_6, t0.is_highly_rated AS is_highly_rated_7, t0.start_time AS start_time_8, t0.end_time AS end_time_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.internal_tickets AS internal_tickets_12, t0.facebook_tracking_id AS facebook_tracking_id_13, t0.google_analytics_tracking_id AS google_analytics_tracking_id_14, t0.organizer_id AS organizer_id_15, t0.cover_image_id AS cover_image_id_16, t0.gallery_id AS gallery_id_17 FROM event t0 WHERE t0.slug = 'test-with-mahdi' LIMIT 1;

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.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.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.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
  AVG(r0_.score_organization) AS sclr_0
FROM
  review r0_
WHERE
  r0_.event_id = ?

SELECT AVG(r0_.score_organization) AS sclr_0 FROM review r0_ WHERE r0_.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

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
  AVG(r0_.score_overall) AS sclr_0
FROM
  review r0_
WHERE
  r0_.event_id = ?

SELECT AVG(r0_.score_overall) AS sclr_0 FROM review r0_ WHERE r0_.event_id = 37697;

SELECT
  AVG(
    (
      r0_.score_organization + r0_.score_overall + r0_.score_course + r0_.score_price
    ) / 4
  ) AS sclr_0
FROM
  review r0_
WHERE
  r0_.event_id = ?

SELECT AVG((r0_.score_organization + r0_.score_overall + r0_.score_course + r0_.score_price) / 4) AS sclr_0 FROM review r0_ WHERE r0_.event_id = 37697;

SELECT
  AVG(r0_.score_course) AS sclr_0
FROM
  review r0_
WHERE
  r0_.event_id = ?

SELECT AVG(r0_.score_course) AS sclr_0 FROM review r0_ WHERE r0_.event_id = 37697;

SELECT
  AVG(r0_.score_price) AS sclr_0
FROM
  review r0_
WHERE
  r0_.event_id = ?

SELECT AVG(r0_.score_price) AS sclr_0 FROM review r0_ WHERE r0_.event_id = 37697;