Symfony Profiler

SELECT 
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(c0_.lat)
      ) * COS(
        RADIANS(c0_.lng) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(c0_.lat)
      )
    )
  ) AS sclr_0, 
  z1_.id AS id_1, 
  z1_.zipcode AS zipcode_2, 
  z1_.city AS city_3, 
  z1_.country AS country_4, 
  z1_.region AS region_5, 
  z1_.department AS department_6, 
  z1_.parent_id AS parent_id_7, 
  z1_.created AS created_8, 
  z1_.updated AS updated_9, 
  z1_.centers_title_seo AS centers_title_seo_10, 
  z1_.professionals_title_seo AS professionals_title_seo_11, 
  z1_.doctors_title_seo AS doctors_title_seo_12, 
  z1_.suppliers_title_seo AS suppliers_title_seo_13, 
  z1_.speechtherapists_title_seo AS speechtherapists_title_seo_14, 
  z1_.networks_title_seo AS networks_title_seo_15, 
  z1_.services_title_seo AS services_title_seo_16, 
  z1_.special_schools_title_seo AS special_schools_title_seo_17, 
  z1_.agencies_title_seo AS agencies_title_seo_18, 
  z1_.training_centers_title_seo AS training_centers_title_seo_19, 
  z1_.centers_description_seo AS centers_description_seo_20, 
  z1_.professionals_description_seo AS professionals_description_seo_21, 
  z1_.doctors_description_seo AS doctors_description_seo_22, 
  z1_.suppliers_description_seo AS suppliers_description_seo_23, 
  z1_.speechtherapists_description_seo AS speechtherapists_description_seo_24, 
  z1_.networks_description_seo AS networks_description_seo_25, 
  z1_.services_description_seo AS services_description_seo_26, 
  z1_.special_schools_description_seo AS special_schools_description_seo_27, 
  z1_.agencies_description_seo AS agencies_description_seo_28, 
  z1_.training_centers_description_seo AS training_centers_description_seo_29, 
  c0_.id AS id_30, 
  c0_.zip_code AS zip_code_31, 
  c0_.ville AS ville_32, 
  c0_.region AS region_33, 
  c0_.dept_txt AS dept_txt_34, 
  c0_.dept_code AS dept_code_35, 
  c0_.lat AS lat_36, 
  c0_.lng AS lng_37, 
  z1_.cities_id AS cities_id_38 
FROM 
  zipcode z1_ 
  LEFT JOIN cities c0_ ON z1_.cities_id = c0_.id 
WHERE 
  c0_.id = z1_.cities_id 
  AND c0_.id <> ? 
  AND (
    z1_.parent_id IS NULL 
    OR z1_.parent_id = ?
  ) 
GROUP BY 
  z1_.city 
HAVING 
  sclr_0 < 1000 
ORDER BY 
  sclr_0 ASC 
LIMIT 
  100

SELECT (6371 * ACOS(COS(RADIANS(43.1835)) * COS(RADIANS(c0_.lat)) * COS(RADIANS(c0_.lng) - RADIANS(5.7091)) + SIN(RADIANS(43.1835)) * SIN(RADIANS(c0_.lat)))) AS sclr_0, z1_.id AS id_1, z1_.zipcode AS zipcode_2, z1_.city AS city_3, z1_.country AS country_4, z1_.region AS region_5, z1_.department AS department_6, z1_.parent_id AS parent_id_7, z1_.created AS created_8, z1_.updated AS updated_9, z1_.centers_title_seo AS centers_title_seo_10, z1_.professionals_title_seo AS professionals_title_seo_11, z1_.doctors_title_seo AS doctors_title_seo_12, z1_.suppliers_title_seo AS suppliers_title_seo_13, z1_.speechtherapists_title_seo AS speechtherapists_title_seo_14, z1_.networks_title_seo AS networks_title_seo_15, z1_.services_title_seo AS services_title_seo_16, z1_.special_schools_title_seo AS special_schools_title_seo_17, z1_.agencies_title_seo AS agencies_title_seo_18, z1_.training_centers_title_seo AS training_centers_title_seo_19, z1_.centers_description_seo AS centers_description_seo_20, z1_.professionals_description_seo AS professionals_description_seo_21, z1_.doctors_description_seo AS doctors_description_seo_22, z1_.suppliers_description_seo AS suppliers_description_seo_23, z1_.speechtherapists_description_seo AS speechtherapists_description_seo_24, z1_.networks_description_seo AS networks_description_seo_25, z1_.services_description_seo AS services_description_seo_26, z1_.special_schools_description_seo AS special_schools_description_seo_27, z1_.agencies_description_seo AS agencies_description_seo_28, z1_.training_centers_description_seo AS training_centers_description_seo_29, c0_.id AS id_30, c0_.zip_code AS zip_code_31, c0_.ville AS ville_32, c0_.region AS region_33, c0_.dept_txt AS dept_txt_34, c0_.dept_code AS dept_code_35, c0_.lat AS lat_36, c0_.lng AS lng_37, z1_.cities_id AS cities_id_38 FROM zipcode z1_ LEFT JOIN cities c0_ ON z1_.cities_id = c0_.id WHERE c0_.id = z1_.cities_id AND c0_.id <> 50667 AND (z1_.parent_id IS NULL OR z1_.parent_id = 0) GROUP BY z1_.city HAVING sclr_0 < 1000 ORDER BY sclr_0 ASC LIMIT 100;

SELECT 
  g0_.class AS class_0, 
  g0_.id AS id_1, 
  g0_.lat AS lat_2, 
  g0_.lng AS lng_3, 
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(g0_.lat)
      ) * COS(
        RADIANS(g0_.lng) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(g0_.lat)
      )
    )
  ) AS sclr_4 
FROM 
  geocode g0_ 
  LEFT JOIN centers c1_ ON (c1_.id = g0_.id) 
  LEFT JOIN zipcode z2_ ON (c1_.localisation_id = z2_.id) 
WHERE 
  g0_.class = ? 
  AND c1_.localisation_id <> ? 
  AND c1_.advertiser = ? 
  AND c1_.visible = 1 
  AND z2_.country = 'FRANCE' 
ORDER BY 
  sclr_4 ASC 
LIMIT 
  6

SELECT g0_.class AS class_0, g0_.id AS id_1, g0_.lat AS lat_2, g0_.lng AS lng_3, (6371 * ACOS(COS(RADIANS(43.1835)) * COS(RADIANS(g0_.lat)) * COS(RADIANS(g0_.lng) - RADIANS(5.7091)) + SIN(RADIANS(43.1835)) * SIN(RADIANS(g0_.lat)))) AS sclr_4 FROM geocode g0_ LEFT JOIN centers c1_ ON (c1_.id = g0_.id) LEFT JOIN zipcode z2_ ON (c1_.localisation_id = z2_.id) WHERE g0_.class = 'Centers' AND c1_.localisation_id <> 2324 AND c1_.advertiser = 1 AND c1_.visible = 1 AND z2_.country = 'FRANCE' ORDER BY sclr_4 ASC LIMIT 6;

SELECT 
  t0.id AS id_1, 
  t0.corporate_name AS corporate_name_2, 
  t0.status AS status_3, 
  t0.corporate_name_2 AS corporate_name_2_4, 
  t0.advertiser AS advertiser_5, 
  t0.categories AS categories_6, 
  t0.networks AS networks_7, 
  t0.sign AS sign_8, 
  t0.purchase_center AS purchase_center_9, 
  t0.address AS address_10, 
  t0.additional_address AS additional_address_11, 
  t0.po_box AS po_box_12, 
  t0.zip_cedex AS zip_cedex_13, 
  t0.city_cedex AS city_cedex_14, 
  t0.city AS city_15, 
  t0.zip AS zip_16, 
  t0.country AS country_17, 
  t0.phone AS phone_18, 
  t0.phone_2 AS phone_2_19, 
  t0.fax AS fax_20, 
  t0.fax_2 AS fax_2_21, 
  t0.email AS email_22, 
  t0.email_2 AS email_2_23, 
  t0.email_3 AS email_3_24, 
  t0.website AS website_25, 
  t0.website_2 AS website_2_26, 
  t0.grip AS grip_27, 
  t0.description AS description_28, 
  t0.opening_hours AS opening_hours_29, 
  t0.tarifs AS tarifs_30, 
  t0.image AS image_31, 
  t0.banner_listing AS banner_listing_32, 
  t0.logo AS logo_33, 
  t0.note AS note_34, 
  t0.created AS created_35, 
  t0.updated AS updated_36, 
  t0.nouvelle_fiche AS nouvelle_fiche_37, 
  t0.controle AS controle_38, 
  t0.validate_with_modif AS validate_with_modif_39, 
  t0.type_validate AS type_validate_40, 
  t0.observation AS observation_41, 
  t0.nom_bouton_rdv AS nom_bouton_rdv_42, 
  t0.url_bouton_rdv AS url_bouton_rdv_43, 
  t0.horaire_id AS horaire_id_44, 
  t0.show_reviews AS show_reviews_45, 
  t0.reviews_average AS reviews_average_46, 
  t0.count_reviews AS count_reviews_47, 
  t0.visible AS visible_48, 
  t0.obfuscation_telephone AS obfuscation_telephone_49, 
  t0.localisation_id AS localisation_id_50 
FROM 
  centers t0 
WHERE 
  t0.localisation_id = ? 
  AND t0.advertiser = ? 
  AND t0.visible = ?

SELECT t0.id AS id_1, t0.corporate_name AS corporate_name_2, t0.status AS status_3, t0.corporate_name_2 AS corporate_name_2_4, t0.advertiser AS advertiser_5, t0.categories AS categories_6, t0.networks AS networks_7, t0.sign AS sign_8, t0.purchase_center AS purchase_center_9, t0.address AS address_10, t0.additional_address AS additional_address_11, t0.po_box AS po_box_12, t0.zip_cedex AS zip_cedex_13, t0.city_cedex AS city_cedex_14, t0.city AS city_15, t0.zip AS zip_16, t0.country AS country_17, t0.phone AS phone_18, t0.phone_2 AS phone_2_19, t0.fax AS fax_20, t0.fax_2 AS fax_2_21, t0.email AS email_22, t0.email_2 AS email_2_23, t0.email_3 AS email_3_24, t0.website AS website_25, t0.website_2 AS website_2_26, t0.grip AS grip_27, t0.description AS description_28, t0.opening_hours AS opening_hours_29, t0.tarifs AS tarifs_30, t0.image AS image_31, t0.banner_listing AS banner_listing_32, t0.logo AS logo_33, t0.note AS note_34, t0.created AS created_35, t0.updated AS updated_36, t0.nouvelle_fiche AS nouvelle_fiche_37, t0.controle AS controle_38, t0.validate_with_modif AS validate_with_modif_39, t0.type_validate AS type_validate_40, t0.observation AS observation_41, t0.nom_bouton_rdv AS nom_bouton_rdv_42, t0.url_bouton_rdv AS url_bouton_rdv_43, t0.horaire_id AS horaire_id_44, t0.show_reviews AS show_reviews_45, t0.reviews_average AS reviews_average_46, t0.count_reviews AS count_reviews_47, t0.visible AS visible_48, t0.obfuscation_telephone AS obfuscation_telephone_49, t0.localisation_id AS localisation_id_50 FROM centers t0 WHERE t0.localisation_id = 2324 AND t0.advertiser = 1 AND t0.visible = 1;

SELECT 
  t0.id AS id_1, 
  t0.class AS class_2, 
  t0.entity_id AS entity_id_3, 
  t0.cover AS cover_4, 
  t0.title AS title_5, 
  t0.created AS created_6, 
  t0.updated AS updated_7 
FROM 
  image t0 
WHERE 
  t0.class = ? 
  AND t0.entity_id = ? 
  AND t0.cover = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.class AS class_2, t0.entity_id AS entity_id_3, t0.cover AS cover_4, t0.title AS title_5, t0.created AS created_6, t0.updated AS updated_7 FROM image t0 WHERE t0.class = 'SpeechTherapist' AND t0.entity_id = '7501' AND t0.cover = 1 LIMIT 1;

SELECT 
  z0_.id AS id_0, 
  z0_.zipcode AS zipcode_1, 
  z0_.city AS city_2, 
  z0_.country AS country_3, 
  z0_.region AS region_4, 
  z0_.department AS department_5, 
  z0_.parent_id AS parent_id_6, 
  z0_.created AS created_7, 
  z0_.updated AS updated_8, 
  z0_.centers_title_seo AS centers_title_seo_9, 
  z0_.professionals_title_seo AS professionals_title_seo_10, 
  z0_.doctors_title_seo AS doctors_title_seo_11, 
  z0_.suppliers_title_seo AS suppliers_title_seo_12, 
  z0_.speechtherapists_title_seo AS speechtherapists_title_seo_13, 
  z0_.networks_title_seo AS networks_title_seo_14, 
  z0_.services_title_seo AS services_title_seo_15, 
  z0_.special_schools_title_seo AS special_schools_title_seo_16, 
  z0_.agencies_title_seo AS agencies_title_seo_17, 
  z0_.training_centers_title_seo AS training_centers_title_seo_18, 
  z0_.centers_description_seo AS centers_description_seo_19, 
  z0_.professionals_description_seo AS professionals_description_seo_20, 
  z0_.doctors_description_seo AS doctors_description_seo_21, 
  z0_.suppliers_description_seo AS suppliers_description_seo_22, 
  z0_.speechtherapists_description_seo AS speechtherapists_description_seo_23, 
  z0_.networks_description_seo AS networks_description_seo_24, 
  z0_.services_description_seo AS services_description_seo_25, 
  z0_.special_schools_description_seo AS special_schools_description_seo_26, 
  z0_.agencies_description_seo AS agencies_description_seo_27, 
  z0_.training_centers_description_seo AS training_centers_description_seo_28, 
  z0_.cities_id AS cities_id_29 
FROM 
  zipcode z0_ 
WHERE 
  z0_.zipcode = ? 
  AND LOWER(
    REPLACE(
      REPLACE(z0_.city, '\'', '-'), 
      ' ', 
      '-'
    )
  ) LIKE ? 
ORDER BY 
  z0_.zipcode ASC 
LIMIT 
  1

SELECT z0_.id AS id_0, z0_.zipcode AS zipcode_1, z0_.city AS city_2, z0_.country AS country_3, z0_.region AS region_4, z0_.department AS department_5, z0_.parent_id AS parent_id_6, z0_.created AS created_7, z0_.updated AS updated_8, z0_.centers_title_seo AS centers_title_seo_9, z0_.professionals_title_seo AS professionals_title_seo_10, z0_.doctors_title_seo AS doctors_title_seo_11, z0_.suppliers_title_seo AS suppliers_title_seo_12, z0_.speechtherapists_title_seo AS speechtherapists_title_seo_13, z0_.networks_title_seo AS networks_title_seo_14, z0_.services_title_seo AS services_title_seo_15, z0_.special_schools_title_seo AS special_schools_title_seo_16, z0_.agencies_title_seo AS agencies_title_seo_17, z0_.training_centers_title_seo AS training_centers_title_seo_18, z0_.centers_description_seo AS centers_description_seo_19, z0_.professionals_description_seo AS professionals_description_seo_20, z0_.doctors_description_seo AS doctors_description_seo_21, z0_.suppliers_description_seo AS suppliers_description_seo_22, z0_.speechtherapists_description_seo AS speechtherapists_description_seo_23, z0_.networks_description_seo AS networks_description_seo_24, z0_.services_description_seo AS services_description_seo_25, z0_.special_schools_description_seo AS special_schools_description_seo_26, z0_.agencies_description_seo AS agencies_description_seo_27, z0_.training_centers_description_seo AS training_centers_description_seo_28, z0_.cities_id AS cities_id_29 FROM zipcode z0_ WHERE z0_.zipcode = '83270' AND LOWER(REPLACE(REPLACE(z0_.city, '\'', '-'), ' ', '-')) LIKE 'saint-cyr-sur-mer%' ORDER BY z0_.zipcode ASC LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.corporate_name AS corporate_name_2, 
  t0.status AS status_3, 
  t0.corporate_name_2 AS corporate_name_2_4, 
  t0.advertiser AS advertiser_5, 
  t0.categories AS categories_6, 
  t0.networks AS networks_7, 
  t0.sign AS sign_8, 
  t0.purchase_center AS purchase_center_9, 
  t0.address AS address_10, 
  t0.additional_address AS additional_address_11, 
  t0.po_box AS po_box_12, 
  t0.zip_cedex AS zip_cedex_13, 
  t0.city_cedex AS city_cedex_14, 
  t0.city AS city_15, 
  t0.zip AS zip_16, 
  t0.country AS country_17, 
  t0.phone AS phone_18, 
  t0.phone_2 AS phone_2_19, 
  t0.fax AS fax_20, 
  t0.fax_2 AS fax_2_21, 
  t0.email AS email_22, 
  t0.email_2 AS email_2_23, 
  t0.email_3 AS email_3_24, 
  t0.website AS website_25, 
  t0.website_2 AS website_2_26, 
  t0.grip AS grip_27, 
  t0.description AS description_28, 
  t0.opening_hours AS opening_hours_29, 
  t0.tarifs AS tarifs_30, 
  t0.image AS image_31, 
  t0.banner_listing AS banner_listing_32, 
  t0.logo AS logo_33, 
  t0.note AS note_34, 
  t0.created AS created_35, 
  t0.updated AS updated_36, 
  t0.nouvelle_fiche AS nouvelle_fiche_37, 
  t0.controle AS controle_38, 
  t0.validate_with_modif AS validate_with_modif_39, 
  t0.type_validate AS type_validate_40, 
  t0.observation AS observation_41, 
  t0.nom_bouton_rdv AS nom_bouton_rdv_42, 
  t0.url_bouton_rdv AS url_bouton_rdv_43, 
  t0.horaire_id AS horaire_id_44, 
  t0.show_reviews AS show_reviews_45, 
  t0.reviews_average AS reviews_average_46, 
  t0.count_reviews AS count_reviews_47, 
  t0.visible AS visible_48, 
  t0.obfuscation_telephone AS obfuscation_telephone_49, 
  t0.localisation_id AS localisation_id_50 
FROM 
  centers t0 
WHERE 
  t0.id = ? 
  AND t0.visible = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.corporate_name AS corporate_name_2, t0.status AS status_3, t0.corporate_name_2 AS corporate_name_2_4, t0.advertiser AS advertiser_5, t0.categories AS categories_6, t0.networks AS networks_7, t0.sign AS sign_8, t0.purchase_center AS purchase_center_9, t0.address AS address_10, t0.additional_address AS additional_address_11, t0.po_box AS po_box_12, t0.zip_cedex AS zip_cedex_13, t0.city_cedex AS city_cedex_14, t0.city AS city_15, t0.zip AS zip_16, t0.country AS country_17, t0.phone AS phone_18, t0.phone_2 AS phone_2_19, t0.fax AS fax_20, t0.fax_2 AS fax_2_21, t0.email AS email_22, t0.email_2 AS email_2_23, t0.email_3 AS email_3_24, t0.website AS website_25, t0.website_2 AS website_2_26, t0.grip AS grip_27, t0.description AS description_28, t0.opening_hours AS opening_hours_29, t0.tarifs AS tarifs_30, t0.image AS image_31, t0.banner_listing AS banner_listing_32, t0.logo AS logo_33, t0.note AS note_34, t0.created AS created_35, t0.updated AS updated_36, t0.nouvelle_fiche AS nouvelle_fiche_37, t0.controle AS controle_38, t0.validate_with_modif AS validate_with_modif_39, t0.type_validate AS type_validate_40, t0.observation AS observation_41, t0.nom_bouton_rdv AS nom_bouton_rdv_42, t0.url_bouton_rdv AS url_bouton_rdv_43, t0.horaire_id AS horaire_id_44, t0.show_reviews AS show_reviews_45, t0.reviews_average AS reviews_average_46, t0.count_reviews AS count_reviews_47, t0.visible AS visible_48, t0.obfuscation_telephone AS obfuscation_telephone_49, t0.localisation_id AS localisation_id_50 FROM centers t0 WHERE t0.id = 100510 AND t0.visible = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.zipcode AS zipcode_2, 
  t0.city AS city_3, 
  t0.country AS country_4, 
  t0.region AS region_5, 
  t0.department AS department_6, 
  t0.parent_id AS parent_id_7, 
  t0.created AS created_8, 
  t0.updated AS updated_9, 
  t0.centers_title_seo AS centers_title_seo_10, 
  t0.professionals_title_seo AS professionals_title_seo_11, 
  t0.doctors_title_seo AS doctors_title_seo_12, 
  t0.suppliers_title_seo AS suppliers_title_seo_13, 
  t0.speechtherapists_title_seo AS speechtherapists_title_seo_14, 
  t0.networks_title_seo AS networks_title_seo_15, 
  t0.services_title_seo AS services_title_seo_16, 
  t0.special_schools_title_seo AS special_schools_title_seo_17, 
  t0.agencies_title_seo AS agencies_title_seo_18, 
  t0.training_centers_title_seo AS training_centers_title_seo_19, 
  t0.centers_description_seo AS centers_description_seo_20, 
  t0.professionals_description_seo AS professionals_description_seo_21, 
  t0.doctors_description_seo AS doctors_description_seo_22, 
  t0.suppliers_description_seo AS suppliers_description_seo_23, 
  t0.speechtherapists_description_seo AS speechtherapists_description_seo_24, 
  t0.networks_description_seo AS networks_description_seo_25, 
  t0.services_description_seo AS services_description_seo_26, 
  t0.special_schools_description_seo AS special_schools_description_seo_27, 
  t0.agencies_description_seo AS agencies_description_seo_28, 
  t0.training_centers_description_seo AS training_centers_description_seo_29, 
  t0.cities_id AS cities_id_30 
FROM 
  zipcode t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.zipcode AS zipcode_2, t0.city AS city_3, t0.country AS country_4, t0.region AS region_5, t0.department AS department_6, t0.parent_id AS parent_id_7, t0.created AS created_8, t0.updated AS updated_9, t0.centers_title_seo AS centers_title_seo_10, t0.professionals_title_seo AS professionals_title_seo_11, t0.doctors_title_seo AS doctors_title_seo_12, t0.suppliers_title_seo AS suppliers_title_seo_13, t0.speechtherapists_title_seo AS speechtherapists_title_seo_14, t0.networks_title_seo AS networks_title_seo_15, t0.services_title_seo AS services_title_seo_16, t0.special_schools_title_seo AS special_schools_title_seo_17, t0.agencies_title_seo AS agencies_title_seo_18, t0.training_centers_title_seo AS training_centers_title_seo_19, t0.centers_description_seo AS centers_description_seo_20, t0.professionals_description_seo AS professionals_description_seo_21, t0.doctors_description_seo AS doctors_description_seo_22, t0.suppliers_description_seo AS suppliers_description_seo_23, t0.speechtherapists_description_seo AS speechtherapists_description_seo_24, t0.networks_description_seo AS networks_description_seo_25, t0.services_description_seo AS services_description_seo_26, t0.special_schools_description_seo AS special_schools_description_seo_27, t0.agencies_description_seo AS agencies_description_seo_28, t0.training_centers_description_seo AS training_centers_description_seo_29, t0.cities_id AS cities_id_30 FROM zipcode t0 WHERE t0.id = 2324 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.name AS name_3, 
  t0.firstname AS firstname_4, 
  t0.degrees AS degrees_5, 
  t0.status_grade AS status_grade_6, 
  t0.specialty_hospitals AS specialty_hospitals_7, 
  t0.free_link AS free_link_8, 
  t0.advertisers AS advertisers_9, 
  t0.specialty_if_advertisers AS specialty_if_advertisers_10, 
  t0.specialty AS specialty_11, 
  t0.phone_1 AS phone_1_12, 
  t0.phone_2 AS phone_2_13, 
  t0.fax AS fax_14, 
  t0.email_1 AS email_1_15, 
  t0.email_2 AS email_2_16, 
  t0.website AS website_17, 
  t0.created AS created_18, 
  t0.updated AS updated_19, 
  t0.department AS department_20, 
  t0.nouvelle_fiche AS nouvelle_fiche_21, 
  t0.controle AS controle_22, 
  t0.validate_with_modif AS validate_with_modif_23, 
  t0.type_validate AS type_validate_24, 
  t0.observation AS observation_25, 
  t0.advertisers_0 AS advertisers_0_26, 
  t0.advertisers_1 AS advertisers_1_27, 
  t0.advertisers_2 AS advertisers_2_28, 
  t0.advertisers_3 AS advertisers_3_29, 
  t0.advertisers_4 AS advertisers_4_30, 
  t0.advertisers_5 AS advertisers_5_31, 
  t0.advertisers_6 AS advertisers_6_32, 
  t0.advertisers_7 AS advertisers_7_33, 
  t0.advertisers_8 AS advertisers_8_34, 
  t0.advertisers_9 AS advertisers_9_35, 
  t0.advertisers_10 AS advertisers_10_36, 
  t0.advertisers_11 AS advertisers_11_37, 
  t0.advertisers_12 AS advertisers_12_38, 
  t0.advertisers_13 AS advertisers_13_39, 
  t0.advertisers_14 AS advertisers_14_40, 
  t0.advertisers_15 AS advertisers_15_41, 
  t0.advertisers_16 AS advertisers_16_42, 
  t0.advertisers_17 AS advertisers_17_43, 
  t0.advertisers_18 AS advertisers_18_44, 
  t0.advertisers_19 AS advertisers_19_45, 
  t0.advertisers_20 AS advertisers_20_46, 
  t0.advertisers_21 AS advertisers_21_47, 
  t0.advertisers_22 AS advertisers_22_48, 
  t0.advertisers_23 AS advertisers_23_49, 
  t0.advertisers_24 AS advertisers_24_50, 
  t0.advertisers_25 AS advertisers_25_51, 
  t0.advertisers_25_text AS advertisers_25_text_52, 
  t0.training_center AS training_center_53 
FROM 
  speech_therapist t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.firstname AS firstname_4, t0.degrees AS degrees_5, t0.status_grade AS status_grade_6, t0.specialty_hospitals AS specialty_hospitals_7, t0.free_link AS free_link_8, t0.advertisers AS advertisers_9, t0.specialty_if_advertisers AS specialty_if_advertisers_10, t0.specialty AS specialty_11, t0.phone_1 AS phone_1_12, t0.phone_2 AS phone_2_13, t0.fax AS fax_14, t0.email_1 AS email_1_15, t0.email_2 AS email_2_16, t0.website AS website_17, t0.created AS created_18, t0.updated AS updated_19, t0.department AS department_20, t0.nouvelle_fiche AS nouvelle_fiche_21, t0.controle AS controle_22, t0.validate_with_modif AS validate_with_modif_23, t0.type_validate AS type_validate_24, t0.observation AS observation_25, t0.advertisers_0 AS advertisers_0_26, t0.advertisers_1 AS advertisers_1_27, t0.advertisers_2 AS advertisers_2_28, t0.advertisers_3 AS advertisers_3_29, t0.advertisers_4 AS advertisers_4_30, t0.advertisers_5 AS advertisers_5_31, t0.advertisers_6 AS advertisers_6_32, t0.advertisers_7 AS advertisers_7_33, t0.advertisers_8 AS advertisers_8_34, t0.advertisers_9 AS advertisers_9_35, t0.advertisers_10 AS advertisers_10_36, t0.advertisers_11 AS advertisers_11_37, t0.advertisers_12 AS advertisers_12_38, t0.advertisers_13 AS advertisers_13_39, t0.advertisers_14 AS advertisers_14_40, t0.advertisers_15 AS advertisers_15_41, t0.advertisers_16 AS advertisers_16_42, t0.advertisers_17 AS advertisers_17_43, t0.advertisers_18 AS advertisers_18_44, t0.advertisers_19 AS advertisers_19_45, t0.advertisers_20 AS advertisers_20_46, t0.advertisers_21 AS advertisers_21_47, t0.advertisers_22 AS advertisers_22_48, t0.advertisers_23 AS advertisers_23_49, t0.advertisers_24 AS advertisers_24_50, t0.advertisers_25 AS advertisers_25_51, t0.advertisers_25_text AS advertisers_25_text_52, t0.training_center AS training_center_53 FROM speech_therapist t0 WHERE t0.id = '7501';

SELECT 
  t0.id AS id_1, 
  t0.entite AS entite_2, 
  t0.monday_open AS monday_open_3, 
  t0.tuesday_open AS tuesday_open_4, 
  t0.wednesday_open AS wednesday_open_5, 
  t0.thursday_open AS thursday_open_6, 
  t0.friday_open AS friday_open_7, 
  t0.saturday_open AS saturday_open_8, 
  t0.sunday_open AS sunday_open_9, 
  t0.monday_morning_startTime AS monday_morning_startTime_10, 
  t0.monday_morning_endTime AS monday_morning_endTime_11, 
  t0.monday_afternoon_startTime AS monday_afternoon_startTime_12, 
  t0.monday_afternoon_endTime AS monday_afternoon_endTime_13, 
  t0.tuesday_morning_startTime AS tuesday_morning_startTime_14, 
  t0.tuesday_morning_endTime AS tuesday_morning_endTime_15, 
  t0.tuesday_afternoon_startTime AS tuesday_afternoon_startTime_16, 
  t0.tuesday_afternoon_endTime AS tuesday_afternoon_endTime_17, 
  t0.wednesday_morning_startTime AS wednesday_morning_startTime_18, 
  t0.wednesday_morning_endTime AS wednesday_morning_endTime_19, 
  t0.wednesday_afternoon_startTime AS wednesday_afternoon_startTime_20, 
  t0.wednesday_afternoon_endTime AS wednesday_afternoon_endTime_21, 
  t0.thursday_morning_startTime AS thursday_morning_startTime_22, 
  t0.thursday_morning_endTime AS thursday_morning_endTime_23, 
  t0.thursday_afternoon_startTime AS thursday_afternoon_startTime_24, 
  t0.thursday_afternoon_endTime AS thursday_afternoon_endTime_25, 
  t0.friday_morning_startTime AS friday_morning_startTime_26, 
  t0.friday_morning_endTime AS friday_morning_endTime_27, 
  t0.friday_afternoon_startTime AS friday_afternoon_startTime_28, 
  t0.friday_afternoon_endTime AS friday_afternoon_endTime_29, 
  t0.saturday_morning_startTime AS saturday_morning_startTime_30, 
  t0.saturday_morning_endTime AS saturday_morning_endTime_31, 
  t0.saturday_afternoon_startTime AS saturday_afternoon_startTime_32, 
  t0.saturday_afternoon_endTime AS saturday_afternoon_endTime_33, 
  t0.sunday_morning_startTime AS sunday_morning_startTime_34, 
  t0.sunday_morning_endTime AS sunday_morning_endTime_35, 
  t0.sunday_afternoon_startTime AS sunday_afternoon_startTime_36, 
  t0.sunday_afternoon_endTime AS sunday_afternoon_endTime_37, 
  t0.monday_more_details AS monday_more_details_38, 
  t0.tuesday_more_details AS tuesday_more_details_39, 
  t0.wednesday_more_details AS wednesday_more_details_40, 
  t0.thursday_more_details AS thursday_more_details_41, 
  t0.friday_more_details AS friday_more_details_42, 
  t0.saturday_more_details AS saturday_more_details_43, 
  t0.sunday_more_details AS sunday_more_details_44, 
  t0.source AS source_45, 
  t0.date AS date_46 
FROM 
  horaire t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.entite AS entite_2, t0.monday_open AS monday_open_3, t0.tuesday_open AS tuesday_open_4, t0.wednesday_open AS wednesday_open_5, t0.thursday_open AS thursday_open_6, t0.friday_open AS friday_open_7, t0.saturday_open AS saturday_open_8, t0.sunday_open AS sunday_open_9, t0.monday_morning_startTime AS monday_morning_startTime_10, t0.monday_morning_endTime AS monday_morning_endTime_11, t0.monday_afternoon_startTime AS monday_afternoon_startTime_12, t0.monday_afternoon_endTime AS monday_afternoon_endTime_13, t0.tuesday_morning_startTime AS tuesday_morning_startTime_14, t0.tuesday_morning_endTime AS tuesday_morning_endTime_15, t0.tuesday_afternoon_startTime AS tuesday_afternoon_startTime_16, t0.tuesday_afternoon_endTime AS tuesday_afternoon_endTime_17, t0.wednesday_morning_startTime AS wednesday_morning_startTime_18, t0.wednesday_morning_endTime AS wednesday_morning_endTime_19, t0.wednesday_afternoon_startTime AS wednesday_afternoon_startTime_20, t0.wednesday_afternoon_endTime AS wednesday_afternoon_endTime_21, t0.thursday_morning_startTime AS thursday_morning_startTime_22, t0.thursday_morning_endTime AS thursday_morning_endTime_23, t0.thursday_afternoon_startTime AS thursday_afternoon_startTime_24, t0.thursday_afternoon_endTime AS thursday_afternoon_endTime_25, t0.friday_morning_startTime AS friday_morning_startTime_26, t0.friday_morning_endTime AS friday_morning_endTime_27, t0.friday_afternoon_startTime AS friday_afternoon_startTime_28, t0.friday_afternoon_endTime AS friday_afternoon_endTime_29, t0.saturday_morning_startTime AS saturday_morning_startTime_30, t0.saturday_morning_endTime AS saturday_morning_endTime_31, t0.saturday_afternoon_startTime AS saturday_afternoon_startTime_32, t0.saturday_afternoon_endTime AS saturday_afternoon_endTime_33, t0.sunday_morning_startTime AS sunday_morning_startTime_34, t0.sunday_morning_endTime AS sunday_morning_endTime_35, t0.sunday_afternoon_startTime AS sunday_afternoon_startTime_36, t0.sunday_afternoon_endTime AS sunday_afternoon_endTime_37, t0.monday_more_details AS monday_more_details_38, t0.tuesday_more_details AS tuesday_more_details_39, t0.wednesday_more_details AS wednesday_more_details_40, t0.thursday_more_details AS thursday_more_details_41, t0.friday_more_details AS friday_more_details_42, t0.saturday_more_details AS saturday_more_details_43, t0.sunday_more_details AS sunday_more_details_44, t0.source AS source_45, t0.date AS date_46 FROM horaire t0 WHERE t0.id = 208;

SELECT 
  t0.id AS id_1, 
  t0.corporate_name AS corporate_name_2, 
  t0.grip AS grip_3, 
  t0.description AS description_4, 
  t0.grip_related_centers AS grip_related_centers_5, 
  t0.description_related_centers AS description_related_centers_6, 
  t0.tarif_related_centers AS tarif_related_centers_7, 
  t0.advertiser AS advertiser_8, 
  t0.address_1 AS address_1_9, 
  t0.additional_address AS additional_address_10, 
  t0.po_box AS po_box_11, 
  t0.zip_cedex_address_1 AS zip_cedex_address_1_12, 
  t0.city_cedex_address_1 AS city_cedex_address_1_13, 
  t0.city_1 AS city_1_14, 
  t0.zip_1 AS zip_1_15, 
  t0.phone_number_1a AS phone_number_1a_16, 
  t0.phone_1b AS phone_1b_17, 
  t0.fax_1a AS fax_1a_18, 
  t0.fax_1b AS fax_1b_19, 
  t0.a_email_1a AS a_email_1a_20, 
  t0.email_1b AS email_1b_21, 
  t0.website_1a AS website_1a_22, 
  t0.website_1b AS website_1b_23, 
  t0.address_2 AS address_2_24, 
  t0.additional_address_2 AS additional_address_2_25, 
  t0.po_box_address_2 AS po_box_address_2_26, 
  t0.zip_cedes_address_2 AS zip_cedes_address_2_27, 
  t0.city_cedex_address AS city_cedex_address_28, 
  t0.city_2 AS city_2_29, 
  t0.zip_2 AS zip_2_30, 
  t0.phone_2a AS phone_2a_31, 
  t0.phone_2b AS phone_2b_32, 
  t0.fax_2a AS fax_2a_33, 
  t0.fax_2b AS fax_2b_34, 
  t0.email_2a AS email_2a_35, 
  t0.email_2b AS email_2b_36, 
  t0.website_2a AS website_2a_37, 
  t0.website_2b AS website_2b_38, 
  t0.banner_listing AS banner_listing_39, 
  t0.logo AS logo_40, 
  t0.created AS created_41, 
  t0.updated AS updated_42, 
  t0.purchase_center AS purchase_center_43, 
  t0.nouvelle_fiche AS nouvelle_fiche_44, 
  t0.controle AS controle_45, 
  t0.validate_with_modif AS validate_with_modif_46, 
  t0.type_validate AS type_validate_47, 
  t0.observation AS observation_48, 
  t0.nom_bouton_rdv AS nom_bouton_rdv_49, 
  t0.url_bouton_rdv AS url_bouton_rdv_50, 
  t0.localisation_id_1 AS localisation_id_1_51, 
  t0.localisation_id_2 AS localisation_id_2_52 
FROM 
  networks t0 
WHERE 
  t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.corporate_name AS corporate_name_2, t0.grip AS grip_3, t0.description AS description_4, t0.grip_related_centers AS grip_related_centers_5, t0.description_related_centers AS description_related_centers_6, t0.tarif_related_centers AS tarif_related_centers_7, t0.advertiser AS advertiser_8, t0.address_1 AS address_1_9, t0.additional_address AS additional_address_10, t0.po_box AS po_box_11, t0.zip_cedex_address_1 AS zip_cedex_address_1_12, t0.city_cedex_address_1 AS city_cedex_address_1_13, t0.city_1 AS city_1_14, t0.zip_1 AS zip_1_15, t0.phone_number_1a AS phone_number_1a_16, t0.phone_1b AS phone_1b_17, t0.fax_1a AS fax_1a_18, t0.fax_1b AS fax_1b_19, t0.a_email_1a AS a_email_1a_20, t0.email_1b AS email_1b_21, t0.website_1a AS website_1a_22, t0.website_1b AS website_1b_23, t0.address_2 AS address_2_24, t0.additional_address_2 AS additional_address_2_25, t0.po_box_address_2 AS po_box_address_2_26, t0.zip_cedes_address_2 AS zip_cedes_address_2_27, t0.city_cedex_address AS city_cedex_address_28, t0.city_2 AS city_2_29, t0.zip_2 AS zip_2_30, t0.phone_2a AS phone_2a_31, t0.phone_2b AS phone_2b_32, t0.fax_2a AS fax_2a_33, t0.fax_2b AS fax_2b_34, t0.email_2a AS email_2a_35, t0.email_2b AS email_2b_36, t0.website_2a AS website_2a_37, t0.website_2b AS website_2b_38, t0.banner_listing AS banner_listing_39, t0.logo AS logo_40, t0.created AS created_41, t0.updated AS updated_42, t0.purchase_center AS purchase_center_43, t0.nouvelle_fiche AS nouvelle_fiche_44, t0.controle AS controle_45, t0.validate_with_modif AS validate_with_modif_46, t0.type_validate AS type_validate_47, t0.observation AS observation_48, t0.nom_bouton_rdv AS nom_bouton_rdv_49, t0.url_bouton_rdv AS url_bouton_rdv_50, t0.localisation_id_1 AS localisation_id_1_51, t0.localisation_id_2 AS localisation_id_2_52 FROM networks t0 WHERE t0.id = 400006 LIMIT 1;