Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.adresse AS adresse_2,
  c0_.code_postal AS code_postal_3,
  c0_.ville AS ville_4,
  c0_.telephone AS telephone_5,
  c0_.adresse_email AS adresse_email_6,
  c0_.forme_juridique AS forme_juridique_7,
  c0_.dirigent AS dirigent_8,
  c0_.immatriculation AS immatriculation_9,
  c0_.siren AS siren_10,
  c0_.ape AS ape_11,
  c0_.annee_ca AS annee_ca_12,
  c0_.ca AS ca_13,
  c0_.resultat AS resultat_14,
  c0_.effectif AS effectif_15,
  c0_.naf AS naf_16,
  c0_.siret AS siret_17,
  c0_.effectif_min AS effectif_min_18,
  c0_.effectif_max AS effectif_max_19,
  c0_.latitude AS latitude_20,
  c0_.longitude AS longitude_21,
  c0_.invalid AS invalid_22,
  c0_.slug AS slug_23,
  (
    (c0_.longitude - ?) * (c0_.longitude - ?) + (c0_.latitude - ?) * (c0_.latitude - ?)
  ) AS sclr_24
FROM
  center_imported c0_
WHERE
  (
    c0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    c0_.latitude BETWEEN ?
    AND ?
  )
ORDER BY
  sclr_24 ASC
LIMIT
  80

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.adresse AS adresse_2, c0_.code_postal AS code_postal_3, c0_.ville AS ville_4, c0_.telephone AS telephone_5, c0_.adresse_email AS adresse_email_6, c0_.forme_juridique AS forme_juridique_7, c0_.dirigent AS dirigent_8, c0_.immatriculation AS immatriculation_9, c0_.siren AS siren_10, c0_.ape AS ape_11, c0_.annee_ca AS annee_ca_12, c0_.ca AS ca_13, c0_.resultat AS resultat_14, c0_.effectif AS effectif_15, c0_.naf AS naf_16, c0_.siret AS siret_17, c0_.effectif_min AS effectif_min_18, c0_.effectif_max AS effectif_max_19, c0_.latitude AS latitude_20, c0_.longitude AS longitude_21, c0_.invalid AS invalid_22, c0_.slug AS slug_23, ((c0_.longitude - '7.752111299999999') * (c0_.longitude - '7.752111299999999') + (c0_.latitude - '48.5734053') * (c0_.latitude - '48.5734053')) AS sclr_24 FROM center_imported c0_ WHERE (c0_.longitude BETWEEN 7.3521113 AND 8.1521113) AND (c0_.latitude BETWEEN 48.1734053 AND 48.9734053) ORDER BY sclr_24 ASC LIMIT 80;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  center_imported c0_
WHERE
  (
    c0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    c0_.latitude BETWEEN ?
    AND ?
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM center_imported c0_ WHERE (c0_.longitude BETWEEN 7.3521113 AND 8.1521113) AND (c0_.latitude BETWEEN 48.1734053 AND 48.9734053);

SELECT
  c0_.id AS id_0,
  c0_.address AS address_1,
  c0_.postale AS postale_2,
  c0_.numero AS numero_3,
  c0_.voie AS voie_4,
  c0_.rue AS rue_5,
  c0_.city AS city_6,
  c0_.description AS description_7,
  c0_.finess AS finess_8,
  c0_.siret AS siret_9,
  c0_.website AS website_10,
  c0_.phone AS phone_11,
  c0_.is_handicap AS is_handicap_12,
  c0_.latitude AS latitude_13,
  c0_.longitude AS longitude_14,
  c0_.name AS name_15,
  c0_.img_url AS img_url_16,
  c0_.finess_url AS finess_url_17,
  c0_.is_rdv_domicile AS is_rdv_domicile_18,
  c0_.horaire AS horaire_19,
  c0_.is_valid AS is_valid_20,
  c0_.id_dockage AS id_dockage_21,
  c0_.document_id AS document_id_22,
  c0_.facture_id AS facture_id_23,
  c0_.transaction_id AS transaction_id_24,
  c0_.is_sign AS is_sign_25,
  c0_.is_blocked AS is_blocked_26,
  c0_.mandat AS mandat_27,
  c0_.signup_date AS signup_date_28,
  c0_.calendar_color AS calendar_color_29,
  c0_.initial AS initial_30,
  c0_.slug AS slug_31,
  c0_.aditionnel_info AS aditionnel_info_32,
  c0_.horaires_holiday AS horaires_holiday_33,
  c0_.url_rdv AS url_rdv_34,
  c0_.is_visible AS is_visible_35,
  c0_.social_name AS social_name_36,
  c0_.contract_signup_date AS contract_signup_date_37,
  c0_.zone_km AS zone_km_38,
  c0_.marketing_ad_status AS marketing_ad_status_39,
  c0_.accord_use_mark_name AS accord_use_mark_name_40,
  c0_.accord_use_audio_name AS accord_use_audio_name_41,
  c0_.partner_code AS partner_code_42,
  c0_.lien_doctolib AS lien_doctolib_43,
  (
    (c0_.longitude - ?) * (c0_.longitude - ?) + (c0_.latitude - ?) * (c0_.latitude - ?)
  ) AS sclr_44,
  c0_.id_gerant_id AS id_gerant_id_45
FROM
  centre c0_
WHERE
  (
    c0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    c0_.latitude BETWEEN ?
    AND ?
  )
ORDER BY
  sclr_44 ASC
LIMIT
  80

SELECT c0_.id AS id_0, c0_.address AS address_1, c0_.postale AS postale_2, c0_.numero AS numero_3, c0_.voie AS voie_4, c0_.rue AS rue_5, c0_.city AS city_6, c0_.description AS description_7, c0_.finess AS finess_8, c0_.siret AS siret_9, c0_.website AS website_10, c0_.phone AS phone_11, c0_.is_handicap AS is_handicap_12, c0_.latitude AS latitude_13, c0_.longitude AS longitude_14, c0_.name AS name_15, c0_.img_url AS img_url_16, c0_.finess_url AS finess_url_17, c0_.is_rdv_domicile AS is_rdv_domicile_18, c0_.horaire AS horaire_19, c0_.is_valid AS is_valid_20, c0_.id_dockage AS id_dockage_21, c0_.document_id AS document_id_22, c0_.facture_id AS facture_id_23, c0_.transaction_id AS transaction_id_24, c0_.is_sign AS is_sign_25, c0_.is_blocked AS is_blocked_26, c0_.mandat AS mandat_27, c0_.signup_date AS signup_date_28, c0_.calendar_color AS calendar_color_29, c0_.initial AS initial_30, c0_.slug AS slug_31, c0_.aditionnel_info AS aditionnel_info_32, c0_.horaires_holiday AS horaires_holiday_33, c0_.url_rdv AS url_rdv_34, c0_.is_visible AS is_visible_35, c0_.social_name AS social_name_36, c0_.contract_signup_date AS contract_signup_date_37, c0_.zone_km AS zone_km_38, c0_.marketing_ad_status AS marketing_ad_status_39, c0_.accord_use_mark_name AS accord_use_mark_name_40, c0_.accord_use_audio_name AS accord_use_audio_name_41, c0_.partner_code AS partner_code_42, c0_.lien_doctolib AS lien_doctolib_43, ((c0_.longitude - 7.7521113) * (c0_.longitude - 7.7521113) + (c0_.latitude - 48.5734053) * (c0_.latitude - 48.5734053)) AS sclr_44, c0_.id_gerant_id AS id_gerant_id_45 FROM centre c0_ WHERE (c0_.longitude BETWEEN 7.3521113 AND 8.1521113) AND (c0_.latitude BETWEEN 48.1734053 AND 48.9734053) ORDER BY sclr_44 ASC LIMIT 80;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.address AS address_2,
  l0_.postale AS postale_3,
  l0_.city AS city_4,
  l0_.finess AS finess_5,
  l0_.siret AS siret_6,
  l0_.website AS website_7,
  l0_.phone AS phone_8,
  l0_.is_handicap AS is_handicap_9,
  l0_.latitude AS latitude_10,
  l0_.longitude AS longitude_11,
  l0_.horaire AS horaire_12,
  l0_.img_url AS img_url_13,
  l0_.id_gerant_id AS id_gerant_id_14
FROM
  lieu l0_
WHERE
  (
    l0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    l0_.latitude BETWEEN ?
    AND ?
  )

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.address AS address_2, l0_.postale AS postale_3, l0_.city AS city_4, l0_.finess AS finess_5, l0_.siret AS siret_6, l0_.website AS website_7, l0_.phone AS phone_8, l0_.is_handicap AS is_handicap_9, l0_.latitude AS latitude_10, l0_.longitude AS longitude_11, l0_.horaire AS horaire_12, l0_.img_url AS img_url_13, l0_.id_gerant_id AS id_gerant_id_14 FROM lieu l0_ WHERE (l0_.longitude BETWEEN 7.6521113 AND 7.8521113) AND (l0_.latitude BETWEEN 48.4734053 AND 48.6734053);