Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.name AS name_3, 
  t0.first_name AS first_name_4, 
  t0.email_per AS email_per_5, 
  t0.email_pro AS email_pro_6, 
  t0.ent AS ent_7, 
  t0.phoniatricians AS phoniatricians_8, 
  t0.free_field AS free_field_9, 
  t0.degrees AS degrees_10, 
  t0.status_grade AS status_grade_11, 
  t0.audiometry AS audiometry_12, 
  t0.audiometry_ff AS audiometry_ff_13, 
  t0.phoniatry AS phoniatry_14, 
  t0.phoniatry_ff AS phoniatry_ff_15, 
  t0.speech_therapy AS speech_therapy_16, 
  t0.speech_therapy_ff AS speech_therapy_ff_17, 
  t0.specific_phone_number AS specific_phone_number_18, 
  t0.specific_fax AS specific_fax_19, 
  t0.created AS created_20, 
  t0.updated AS updated_21, 
  t0.nouvelle_fiche AS nouvelle_fiche_22, 
  t0.controle AS controle_23, 
  t0.validate_with_modif AS validate_with_modif_24, 
  t0.type_validate AS type_validate_25, 
  t0.observation AS observation_26, 
  t0.training_center AS training_center_27, 
  t0.visible AS visible_28, 
  t0.department AS department_29 
FROM 
  doctors t0 
WHERE 
  t0.id = ? 
  AND t0.visible = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.first_name AS first_name_4, t0.email_per AS email_per_5, t0.email_pro AS email_pro_6, t0.ent AS ent_7, t0.phoniatricians AS phoniatricians_8, t0.free_field AS free_field_9, t0.degrees AS degrees_10, t0.status_grade AS status_grade_11, t0.audiometry AS audiometry_12, t0.audiometry_ff AS audiometry_ff_13, t0.phoniatry AS phoniatry_14, t0.phoniatry_ff AS phoniatry_ff_15, t0.speech_therapy AS speech_therapy_16, t0.speech_therapy_ff AS speech_therapy_ff_17, t0.specific_phone_number AS specific_phone_number_18, t0.specific_fax AS specific_fax_19, t0.created AS created_20, t0.updated AS updated_21, t0.nouvelle_fiche AS nouvelle_fiche_22, t0.controle AS controle_23, t0.validate_with_modif AS validate_with_modif_24, t0.type_validate AS type_validate_25, t0.observation AS observation_26, t0.training_center AS training_center_27, t0.visible AS visible_28, t0.department AS department_29 FROM doctors t0 WHERE t0.id = '338' AND t0.visible = 1 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.address AS address_3, 
  t0.additional_address AS additional_address_4, 
  t0.po_box AS po_box_5, 
  t0.zip_cedex AS zip_cedex_6, 
  t0.city_cedex AS city_cedex_7, 
  t0.zip AS zip_8, 
  t0.city AS city_9, 
  t0.phone AS phone_10, 
  t0.phone_2 AS phone_2_11, 
  t0.fax AS fax_12, 
  t0.email AS email_13, 
  t0.description AS description_14, 
  t0.created AS created_15, 
  t0.updated AS updated_16, 
  t0.nouvelle_fiche AS nouvelle_fiche_17, 
  t0.controle AS controle_18, 
  t0.validate_with_modif AS validate_with_modif_19, 
  t0.type_validate AS type_validate_20, 
  t0.observation AS observation_21, 
  t0.type_id AS type_id_22, 
  t0.website AS website_23, 
  t0.localisation_id AS localisation_id_24 
FROM 
  practices t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.additional_address AS additional_address_4, t0.po_box AS po_box_5, t0.zip_cedex AS zip_cedex_6, t0.city_cedex AS city_cedex_7, t0.zip AS zip_8, t0.city AS city_9, t0.phone AS phone_10, t0.phone_2 AS phone_2_11, t0.fax AS fax_12, t0.email AS email_13, t0.description AS description_14, t0.created AS created_15, t0.updated AS updated_16, t0.nouvelle_fiche AS nouvelle_fiche_17, t0.controle AS controle_18, t0.validate_with_modif AS validate_with_modif_19, t0.type_validate AS type_validate_20, t0.observation AS observation_21, t0.type_id AS type_id_22, t0.website AS website_23, t0.localisation_id AS localisation_id_24 FROM practices t0 WHERE t0.id = '279';

SELECT 
  p0_.id AS id_0, 
  p0_.name AS name_1, 
  p0_.address AS address_2, 
  p0_.additional_address AS additional_address_3, 
  p0_.po_box AS po_box_4, 
  p0_.zip_cedex AS zip_cedex_5, 
  p0_.city_cedex AS city_cedex_6, 
  p0_.zip AS zip_7, 
  p0_.city AS city_8, 
  p0_.phone AS phone_9, 
  p0_.phone_2 AS phone_2_10, 
  p0_.fax AS fax_11, 
  p0_.email AS email_12, 
  p0_.description AS description_13, 
  p0_.created AS created_14, 
  p0_.updated AS updated_15, 
  p0_.nouvelle_fiche AS nouvelle_fiche_16, 
  p0_.controle AS controle_17, 
  p0_.validate_with_modif AS validate_with_modif_18, 
  p0_.type_validate AS type_validate_19, 
  p0_.observation AS observation_20, 
  p0_.type_id AS type_id_21, 
  p0_.website AS website_22, 
  p0_.localisation_id AS localisation_id_23 
FROM 
  practices p0_ 
  LEFT JOIN doctor_practices d1_ ON (p0_.id = d1_.practice_id) 
  LEFT JOIN doctors d2_ ON (d2_.id = d1_.doctor_id) 
WHERE 
  d2_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.address AS address_2, p0_.additional_address AS additional_address_3, p0_.po_box AS po_box_4, p0_.zip_cedex AS zip_cedex_5, p0_.city_cedex AS city_cedex_6, p0_.zip AS zip_7, p0_.city AS city_8, p0_.phone AS phone_9, p0_.phone_2 AS phone_2_10, p0_.fax AS fax_11, p0_.email AS email_12, p0_.description AS description_13, p0_.created AS created_14, p0_.updated AS updated_15, p0_.nouvelle_fiche AS nouvelle_fiche_16, p0_.controle AS controle_17, p0_.validate_with_modif AS validate_with_modif_18, p0_.type_validate AS type_validate_19, p0_.observation AS observation_20, p0_.type_id AS type_id_21, p0_.website AS website_22, p0_.localisation_id AS localisation_id_23 FROM practices p0_ LEFT JOIN doctor_practices d1_ ON (p0_.id = d1_.practice_id) LEFT JOIN doctors d2_ ON (d2_.id = d1_.doctor_id) WHERE d2_.id = '338';

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 = 2554 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.doctor_id AS doctor_id_2, 
  t0.phone AS phone_3, 
  t0.fax AS fax_4, 
  t0.email AS email_5, 
  t0.doctolib_iframe AS doctolib_iframe_6, 
  t0.created AS created_7, 
  t0.updated AS updated_8, 
  t0.doctor_id AS doctor_id_9, 
  t0.practice_id AS practice_id_10 
FROM 
  doctor_practices t0 
WHERE 
  t0.doctor_id = ? 
  AND t0.practice_id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.doctor_id AS doctor_id_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.email AS email_5, t0.doctolib_iframe AS doctolib_iframe_6, t0.created AS created_7, t0.updated AS updated_8, t0.doctor_id AS doctor_id_9, t0.practice_id AS practice_id_10 FROM doctor_practices t0 WHERE t0.doctor_id = '338' AND t0.practice_id = 279 LIMIT 1;

SELECT 
  s0_.id AS id_0, 
  s0_.name AS name_1, 
  s0_.cochlear_implant AS cochlear_implant_2, 
  s0_.title_1 AS title_1_3, 
  s0_.description_1 AS description_1_4, 
  s0_.email_1 AS email_1_5, 
  s0_.title_2 AS title_2_6, 
  s0_.description_2 AS description_2_7, 
  s0_.email_2 AS email_2_8, 
  s0_.title_3 AS title_3_9, 
  s0_.description_3 AS description_3_10, 
  s0_.email_3 AS email_3_11, 
  s0_.ranking AS ranking_12, 
  s0_.created AS created_13, 
  s0_.updated AS updated_14, 
  s0_.nouvelle_fiche AS nouvelle_fiche_15, 
  s0_.controle AS controle_16, 
  s0_.validate_with_modif AS validate_with_modif_17, 
  s0_.type_validate AS type_validate_18, 
  s0_.observation AS observation_19, 
  s0_.other AS other_20, 
  s0_.hospital_id AS hospital_id_21 
FROM 
  services s0_ 
  LEFT JOIN service_doctors s1_ ON (s0_.id = s1_.service_id) 
  LEFT JOIN doctors d2_ ON (d2_.id = s1_.doctor_id) 
  LEFT JOIN hospitals h3_ ON (h3_.id = s0_.hospital_id) 
WHERE 
  d2_.id = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.cochlear_implant AS cochlear_implant_2, s0_.title_1 AS title_1_3, s0_.description_1 AS description_1_4, s0_.email_1 AS email_1_5, s0_.title_2 AS title_2_6, s0_.description_2 AS description_2_7, s0_.email_2 AS email_2_8, s0_.title_3 AS title_3_9, s0_.description_3 AS description_3_10, s0_.email_3 AS email_3_11, s0_.ranking AS ranking_12, s0_.created AS created_13, s0_.updated AS updated_14, s0_.nouvelle_fiche AS nouvelle_fiche_15, s0_.controle AS controle_16, s0_.validate_with_modif AS validate_with_modif_17, s0_.type_validate AS type_validate_18, s0_.observation AS observation_19, s0_.other AS other_20, s0_.hospital_id AS hospital_id_21 FROM services s0_ LEFT JOIN service_doctors s1_ ON (s0_.id = s1_.service_id) LEFT JOIN doctors d2_ ON (d2_.id = s1_.doctor_id) LEFT JOIN hospitals h3_ ON (h3_.id = s0_.hospital_id) WHERE d2_.id = '338';

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.zipcode = ? 
  AND t0.city = ? 
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.zipcode = '92250' AND t0.city = 'LA-GARENNE-COLOMBES' 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.zipcode = ? 
  AND t0.city = ? 
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.zipcode = '92250' AND t0.city = 'LA GARENNE COLOMBES' 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 = ? 
  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 = 'Doctors' AND t0.entity_id = '338' AND t0.cover = 1 LIMIT 1;

SELECT 
  d0_.id AS id_0, 
  d0_.name AS name_1, 
  d0_.category_id AS category_id_2, 
  d0_.principal AS principal_3, 
  d0_.alias AS alias_4, 
  d0_.created AS created_5, 
  d0_.updated AS updated_6, 
  d0_.nouvelle_fiche AS nouvelle_fiche_7, 
  d0_.controle AS controle_8, 
  d0_.validate_with_modif AS validate_with_modif_9, 
  d0_.type_validate AS type_validate_10, 
  d0_.observation AS observation_11 
FROM 
  degrees d0_ 
  LEFT JOIN doctor_degrees d1_ ON (d0_.id = d1_.degree_id) 
  LEFT JOIN doctors d2_ ON (d2_.id = d1_.doctor_id) 
WHERE 
  d2_.id = ?

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.category_id AS category_id_2, d0_.principal AS principal_3, d0_.alias AS alias_4, d0_.created AS created_5, d0_.updated AS updated_6, d0_.nouvelle_fiche AS nouvelle_fiche_7, d0_.controle AS controle_8, d0_.validate_with_modif AS validate_with_modif_9, d0_.type_validate AS type_validate_10, d0_.observation AS observation_11 FROM degrees d0_ LEFT JOIN doctor_degrees d1_ ON (d0_.id = d1_.degree_id) LEFT JOIN doctors d2_ ON (d2_.id = d1_.doctor_id) WHERE d2_.id = '338';

SELECT 
  t0.id AS id_1, 
  t0.zip_code AS zip_code_2, 
  t0.ville AS ville_3, 
  t0.region AS region_4, 
  t0.dept_txt AS dept_txt_5, 
  t0.dept_code AS dept_code_6, 
  t0.lat AS lat_7, 
  t0.lng AS lng_8 
FROM 
  cities t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.ville AS ville_3, t0.region AS region_4, t0.dept_txt AS dept_txt_5, t0.dept_code AS dept_code_6, t0.lat AS lat_7, t0.lng AS lng_8 FROM cities t0 WHERE t0.id = 3139;

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 = 2554 AND t0.advertiser = 1 AND t0.visible = 1;

SELECT 
  t0.center_id AS center_id_1, 
  t0.zipcode_id AS zipcode_id_2 
FROM 
  center_zipcode t0 
WHERE 
  t0.zipcode_id = ?

SELECT t0.center_id AS center_id_1, t0.zipcode_id AS zipcode_id_2 FROM center_zipcode t0 WHERE t0.zipcode_id = 2554;

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.advertiser = ? 
  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 = 104413 AND t0.advertiser = 1 AND t0.visible = 1 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.advertiser = ? 
  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 = 107551 AND t0.advertiser = 1 AND t0.visible = 1 LIMIT 1;