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-cornouaille-cornouaille-18-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 = 241;

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 47.004629099099 AND 48.806430900901) AND (a0_.longitude BETWEEN -5.3204961297775 AND -2.6326638702225) 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 (43)) 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 = 43;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.username AS username_6,
  t0.salt AS salt_7,
  t0.google_id AS google_id_8,
  t0.facebook_id AS facebook_id_9,
  t0.old_id AS old_id_10,
  t0.creation_date AS creation_date_11,
  t0.last_login AS last_login_12,
  t0.newsletter AS newsletter_13,
  t0.state AS state_14,
  t0.period_grace AS period_grace_15,
  t0.deleted_at AS deleted_at_16,
  t0.apple_id AS apple_id_17,
  t0.longitude AS longitude_18,
  t0.latitude AS latitude_19,
  t20.id AS id_21,
  t20.image_name AS image_name_22,
  t20.updated_at AS updated_at_23,
  t20.first_name AS first_name_24,
  t20.last_name AS last_name_25,
  t20.sex AS sex_26,
  t20.index_r AS index_r_27,
  t20.index_v AS index_v_28,
  t20.year_of_birth AS year_of_birth_29,
  t20.newsletter AS newsletter_30,
  t20.colors AS colors_31,
  t20.border AS border_32,
  t20.text_colors AS text_colors_33,
  t20.nb_shoot AS nb_shoot_34,
  t20.distance AS distance_35,
  t20.nb_card AS nb_card_36,
  t20.nb_competition AS nb_competition_37,
  t20.used_in_mean_r AS used_in_mean_r_38,
  t20.avatar AS avatar_39,
  t20.stableford_setting AS stableford_setting_40,
  t20.last_for_mean_r AS last_for_mean_r_41,
  t20.share_public_enabled AS share_public_enabled_42,
  t20.share_public_slug AS share_public_slug_43,
  t20.test_sg AS test_sg_44,
  t20.user_id AS user_id_45,
  t46.id AS id_47,
  t46.name AS name_48,
  t46.line1 AS line1_49,
  t46.line2 AS line2_50,
  t46.line3 AS line3_51,
  t46.city AS city_52,
  t46.country AS country_53,
  t46.longitude AS longitude_54,
  t46.latitude AS latitude_55,
  t46.state AS state_56,
  t46.last_name AS last_name_57,
  t46.first_name AS first_name_58,
  t46.postal_code AS postal_code_59,
  t46.public_name AS public_name_60,
  t46.user_id AS user_id_61,
  t46.golf_id AS golf_id_62
FROM
  `user` t0
  LEFT JOIN player t20 ON t20.user_id = t0.id
  LEFT JOIN pro t46 ON t46.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.username AS username_6, t0.salt AS salt_7, t0.google_id AS google_id_8, t0.facebook_id AS facebook_id_9, t0.old_id AS old_id_10, t0.creation_date AS creation_date_11, t0.last_login AS last_login_12, t0.newsletter AS newsletter_13, t0.state AS state_14, t0.period_grace AS period_grace_15, t0.deleted_at AS deleted_at_16, t0.apple_id AS apple_id_17, t0.longitude AS longitude_18, t0.latitude AS latitude_19, t20.id AS id_21, t20.image_name AS image_name_22, t20.updated_at AS updated_at_23, t20.first_name AS first_name_24, t20.last_name AS last_name_25, t20.sex AS sex_26, t20.index_r AS index_r_27, t20.index_v AS index_v_28, t20.year_of_birth AS year_of_birth_29, t20.newsletter AS newsletter_30, t20.colors AS colors_31, t20.border AS border_32, t20.text_colors AS text_colors_33, t20.nb_shoot AS nb_shoot_34, t20.distance AS distance_35, t20.nb_card AS nb_card_36, t20.nb_competition AS nb_competition_37, t20.used_in_mean_r AS used_in_mean_r_38, t20.avatar AS avatar_39, t20.stableford_setting AS stableford_setting_40, t20.last_for_mean_r AS last_for_mean_r_41, t20.share_public_enabled AS share_public_enabled_42, t20.share_public_slug AS share_public_slug_43, t20.test_sg AS test_sg_44, t20.user_id AS user_id_45, t46.id AS id_47, t46.name AS name_48, t46.line1 AS line1_49, t46.line2 AS line2_50, t46.line3 AS line3_51, t46.city AS city_52, t46.country AS country_53, t46.longitude AS longitude_54, t46.latitude AS latitude_55, t46.state AS state_56, t46.last_name AS last_name_57, t46.first_name AS first_name_58, t46.postal_code AS postal_code_59, t46.public_name AS public_name_60, t46.user_id AS user_id_61, t46.golf_id AS golf_id_62 FROM `user` t0 LEFT JOIN player t20 ON t20.user_id = t0.id LEFT JOIN pro t46 ON t46.user_id = t0.id WHERE t0.id = 6;

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
  INNER JOIN offer_course ON t0.id = offer_course.course_id
WHERE
  offer_course.offer_id = ?

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 INNER JOIN offer_course ON t0.id = offer_course.course_id WHERE offer_course.offer_id = 1739;

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 = 205;