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.name AS name_2,
  t0.slug AS slug_3,
  t0.contact AS contact_4,
  t0.official_website AS official_website_5,
  t0.facebook_profile AS facebook_profile_6,
  t0.twitter_profile AS twitter_profile_7,
  t0.instagram_profile AS instagram_profile_8,
  t0.company_description AS company_description_9,
  t0.contact_phone AS contact_phone_10,
  t0.contact_email AS contact_email_11,
  t0.stripe_confirm_token AS stripe_confirm_token_12,
  t0.stripe_account_id AS stripe_account_id_13,
  t0.account_type AS account_type_14,
  t0.vat_number AS vat_number_15,
  t0.company_business_name AS company_business_name_16,
  t0.country AS country_17,
  t0.address_line1 AS address_line1_18,
  t0.address_line2 AS address_line2_19,
  t0.postal_code AS postal_code_20,
  t0.city AS city_21,
  t0.active AS active_22,
  t0.company_avatar_id AS company_avatar_id_23,
  t0.additional_images_gallery_id AS additional_images_gallery_id_24
FROM
  organizer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.contact AS contact_4, t0.official_website AS official_website_5, t0.facebook_profile AS facebook_profile_6, t0.twitter_profile AS twitter_profile_7, t0.instagram_profile AS instagram_profile_8, t0.company_description AS company_description_9, t0.contact_phone AS contact_phone_10, t0.contact_email AS contact_email_11, t0.stripe_confirm_token AS stripe_confirm_token_12, t0.stripe_account_id AS stripe_account_id_13, t0.account_type AS account_type_14, t0.vat_number AS vat_number_15, t0.company_business_name AS company_business_name_16, t0.country AS country_17, t0.address_line1 AS address_line1_18, t0.address_line2 AS address_line2_19, t0.postal_code AS postal_code_20, t0.city AS city_21, t0.active AS active_22, t0.company_avatar_id AS company_avatar_id_23, t0.additional_images_gallery_id AS additional_images_gallery_id_24 FROM organizer t0 WHERE t0.id = 37958;

SELECT
  t0.currency AS currency_1,
  t0.amount AS amount_2,
  t0.date AS date_3,
  t0.base AS base_4,
  t0.id AS id_5,
  t0.rate_id AS rate_id_6
FROM
  symbol t0
WHERE
  t0.currency = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.currency AS currency_1, t0.amount AS amount_2, t0.date AS date_3, t0.base AS base_4, t0.id AS id_5, t0.rate_id AS rate_id_6 FROM symbol t0 WHERE t0.currency = 'AED' ORDER BY t0.id DESC LIMIT 1;

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.date AS date_1,
  t0.id AS id_2
FROM
  rate t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.date AS date_1, t0.id AS id_2 FROM rate t0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.reset_password_token AS reset_password_token_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.avatar AS avatar_8,
  t0.timezone AS timezone_9,
  t0.currency AS currency_10,
  t0.birth_date AS birth_date_11,
  t0.facebook_id AS facebook_id_12,
  t0.facebook_access_token AS facebook_access_token_13,
  t0.google_id AS google_id_14,
  t0.google_access_token AS google_access_token_15,
  t0.enabled AS enabled_16,
  t0.last_login AS last_login_17,
  t0.confirmation_token AS confirmation_token_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.organizer_id AS organizer_id_21
FROM
  user t0
WHERE
  t0.organizer_id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.email AS email_3, t0.password AS password_4, t0.reset_password_token AS reset_password_token_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.avatar AS avatar_8, t0.timezone AS timezone_9, t0.currency AS currency_10, t0.birth_date AS birth_date_11, t0.facebook_id AS facebook_id_12, t0.facebook_access_token AS facebook_access_token_13, t0.google_id AS google_id_14, t0.google_access_token AS google_access_token_15, t0.enabled AS enabled_16, t0.last_login AS last_login_17, t0.confirmation_token AS confirmation_token_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.organizer_id AS organizer_id_21 FROM user t0 WHERE t0.organizer_id = 37958;

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;

SELECT
  t0.currency AS currency_1,
  t0.amount AS amount_2,
  t0.date AS date_3,
  t0.base AS base_4,
  t0.id AS id_5,
  t0.rate_id AS rate_id_6
FROM
  symbol t0
WHERE
  t0.rate_id = ?

SELECT t0.currency AS currency_1, t0.amount AS amount_2, t0.date AS date_3, t0.base AS base_4, t0.id AS id_5, t0.rate_id AS rate_id_6 FROM symbol t0 WHERE t0.rate_id = 2;