Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug_web AS slug_web_3,
  t0.old_slug_web AS old_slug_web_4,
  t0.enabled AS enabled_5,
  t0.holes_number AS holes_number_6,
  t0.type AS type_7,
  t0.code AS code_8,
  t0.token AS token_9,
  t0.creation_date AS creation_date_10,
  t0.update_date AS update_date_11,
  t0.ffg_slug AS ffg_slug_12,
  t0.slug AS slug_13,
  t0.golf_name AS golf_name_14,
  t0.update_needed AS update_needed_15,
  t0.golf_id AS golf_id_16,
  t0.owner_id AS owner_id_17
FROM
  course t0
WHERE
  t0.slug_web = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug_web AS slug_web_3, t0.old_slug_web AS old_slug_web_4, t0.enabled AS enabled_5, t0.holes_number AS holes_number_6, t0.type AS type_7, t0.code AS code_8, t0.token AS token_9, t0.creation_date AS creation_date_10, t0.update_date AS update_date_11, t0.ffg_slug AS ffg_slug_12, t0.slug AS slug_13, t0.golf_name AS golf_name_14, t0.update_needed AS update_needed_15, t0.golf_id AS golf_id_16, t0.owner_id AS owner_id_17 FROM course t0 WHERE t0.slug_web = 'golf-de-garcelles-le-parc-9-trous' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.enabled AS enabled_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.departement AS departement_7,
  t0.country AS country_8,
  t0.postal_code AS postal_code_9,
  t0.phone AS phone_10,
  t0.site AS site_11,
  t0.longitude AS longitude_12,
  t0.latitude AS latitude_13,
  t0.email AS email_14,
  t0.creation_date AS creation_date_15,
  t0.update_date AS update_date_16,
  t0.ffg_slug AS ffg_slug_17,
  t0.old_ffg_code AS old_ffg_code_18,
  t0.view AS view_19
FROM
  golf t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.address AS address_5, t0.city AS city_6, t0.departement AS departement_7, t0.country AS country_8, t0.postal_code AS postal_code_9, t0.phone AS phone_10, t0.site AS site_11, t0.longitude AS longitude_12, t0.latitude AS latitude_13, t0.email AS email_14, t0.creation_date AS creation_date_15, t0.update_date AS update_date_16, t0.ffg_slug AS ffg_slug_17, t0.old_ffg_code AS old_ffg_code_18, t0.view AS view_19 FROM golf t0 WHERE t0.id = 184;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.subtitle AS subtitle_2,
  a0_.link AS link_3,
  a0_.click_number AS click_number_4,
  a0_.view_number AS view_number_5,
  a0_.state AS state_6,
  a0_.start_date AS start_date_7,
  a0_.latitude AS latitude_8,
  a0_.longitude AS longitude_9,
  a0_.end_date AS end_date_10,
  a0_.end_date_enabled AS end_date_enabled_11,
  a0_.line1 AS line1_12,
  a0_.line2 AS line2_13,
  a0_.line3 AS line3_14,
  a0_.online AS online_15,
  a0_.radius AS radius_16,
  a0_.text_buton AS text_buton_17,
  a0_.slug AS slug_18,
  a0_.cpm AS cpm_19,
  a0_.pro_id AS pro_id_20
FROM
  ad a0_
WHERE
  (
    a0_.latitude BETWEEN ?
    AND ?
  )
  AND (
    a0_.longitude BETWEEN ?
    AND ?
  )
  AND a0_.online = ?

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.subtitle AS subtitle_2, a0_.link AS link_3, a0_.click_number AS click_number_4, a0_.view_number AS view_number_5, a0_.state AS state_6, a0_.start_date AS start_date_7, a0_.latitude AS latitude_8, a0_.longitude AS longitude_9, a0_.end_date AS end_date_10, a0_.end_date_enabled AS end_date_enabled_11, a0_.line1 AS line1_12, a0_.line2 AS line2_13, a0_.line3 AS line3_14, a0_.online AS online_15, a0_.radius AS radius_16, a0_.text_buton AS text_buton_17, a0_.slug AS slug_18, a0_.cpm AS cpm_19, a0_.pro_id AS pro_id_20 FROM ad a0_ WHERE (a0_.latitude BETWEEN 48.191043543543 AND 49.992845345345) AND (a0_.longitude BETWEEN -1.6787979727915 AND 1.0726868616803) AND a0_.online = 1;

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.published_at AS published_at_2,
  o0_.type AS type_3,
  o0_.number AS number_4,
  o0_.token AS token_5,
  o0_.state AS state_6,
  o0_.index_max AS index_max_7,
  o0_.index_min AS index_min_8,
  o0_.age_max AS age_max_9,
  o0_.age_min AS age_min_10,
  o0_.sexe AS sexe_11,
  o0_.weekend_am AS weekend_am_12,
  o0_.weekend_pm AS weekend_pm_13,
  o0_.week_am AS week_am_14,
  o0_.week_pm AS week_pm_15,
  o0_.week_e AS week_e_16,
  o0_.weekend_e AS weekend_e_17,
  o0_.ip AS ip_18,
  o0_.update_at AS update_at_19,
  o0_.departments AS departments_20,
  o0_.owner_id AS owner_id_21
FROM
  offer o0_
  INNER JOIN offer_course o2_ ON o0_.id = o2_.offer_id
  INNER JOIN course c1_ ON c1_.id = o2_.course_id
WHERE
  o0_.state = ?
  AND EXISTS (
    SELECT
      1
    FROM
      offer_course o3_
    WHERE
      o3_.offer_id = o0_.id
      AND o3_.course_id IN (?)
  )
ORDER BY
  o0_.update_at ASC
LIMIT
  3

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.published_at AS published_at_2, o0_.type AS type_3, o0_.number AS number_4, o0_.token AS token_5, o0_.state AS state_6, o0_.index_max AS index_max_7, o0_.index_min AS index_min_8, o0_.age_max AS age_max_9, o0_.age_min AS age_min_10, o0_.sexe AS sexe_11, o0_.weekend_am AS weekend_am_12, o0_.weekend_pm AS weekend_pm_13, o0_.week_am AS week_am_14, o0_.week_pm AS week_pm_15, o0_.week_e AS week_e_16, o0_.weekend_e AS weekend_e_17, o0_.ip AS ip_18, o0_.update_at AS update_at_19, o0_.departments AS departments_20, o0_.owner_id AS owner_id_21 FROM offer o0_ INNER JOIN offer_course o2_ ON o0_.id = o2_.offer_id INNER JOIN course c1_ ON c1_.id = o2_.course_id WHERE o0_.state = 'published' AND EXISTS (SELECT 1 FROM offer_course o3_ WHERE o3_.offer_id = o0_.id AND o3_.course_id IN (307)) ORDER BY o0_.update_at ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.name AS name_3,
  t0.slope_m AS slope_m_4,
  t0.slope_w AS slope_w_5,
  t0.sss_m AS sss_m_6,
  t0.sss_w AS sss_w_7,
  t0.slope_mf AS slope_mf_8,
  t0.slope_wf AS slope_wf_9,
  t0.sss_mf AS sss_mf_10,
  t0.sss_wf AS sss_wf_11,
  t0.slope_mb AS slope_mb_12,
  t0.slope_wb AS slope_wb_13,
  t0.sss_mb AS sss_mb_14,
  t0.sss_wb AS sss_wb_15,
  t0.holes_number AS holes_number_16,
  t0.distance AS distance_17,
  t0.creation_date AS creation_date_18,
  t0.update_date AS update_date_19,
  t0.distances AS distances_20,
  t0.pars AS pars_21,
  t0.handicap_fbs AS handicap_fbs_22,
  t0.handicap_fs AS handicap_fs_23,
  t0.handicap_bs AS handicap_bs_24,
  t0.distance_by_hole AS distance_by_hole_25,
  t0.course_id AS course_id_26
FROM
  tee t0
WHERE
  t0.course_id = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.slope_m AS slope_m_4, t0.slope_w AS slope_w_5, t0.sss_m AS sss_m_6, t0.sss_w AS sss_w_7, t0.slope_mf AS slope_mf_8, t0.slope_wf AS slope_wf_9, t0.sss_mf AS sss_mf_10, t0.sss_wf AS sss_wf_11, t0.slope_mb AS slope_mb_12, t0.slope_wb AS slope_wb_13, t0.sss_mb AS sss_mb_14, t0.sss_wb AS sss_wb_15, t0.holes_number AS holes_number_16, t0.distance AS distance_17, t0.creation_date AS creation_date_18, t0.update_date AS update_date_19, t0.distances AS distances_20, t0.pars AS pars_21, t0.handicap_fbs AS handicap_fbs_22, t0.handicap_fs AS handicap_fs_23, t0.handicap_bs AS handicap_bs_24, t0.distance_by_hole AS distance_by_hole_25, t0.course_id AS course_id_26 FROM tee t0 WHERE t0.course_id = 307;