Query Metrics
13
Database Queries
7
Different statements
382.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.22 ms |
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
Parameters:
[ "97680" "TSINGONI" ] |
| 2 | 0.41 ms |
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 = ?
Parameters:
[
52785
]
|
| 3 | 55.17 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.name AS name_2, s0_.firstname AS firstname_3, s0_.degrees AS degrees_4, s0_.status_grade AS status_grade_5, s0_.specialty_hospitals AS specialty_hospitals_6, s0_.free_link AS free_link_7, s0_.advertisers AS advertisers_8, s0_.specialty_if_advertisers AS specialty_if_advertisers_9, s0_.specialty AS specialty_10, s0_.phone_1 AS phone_1_11, s0_.phone_2 AS phone_2_12, s0_.fax AS fax_13, s0_.email_1 AS email_1_14, s0_.email_2 AS email_2_15, s0_.website AS website_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.department AS department_19, s0_.nouvelle_fiche AS nouvelle_fiche_20, s0_.controle AS controle_21, s0_.validate_with_modif AS validate_with_modif_22, s0_.type_validate AS type_validate_23, s0_.observation AS observation_24, s0_.advertisers_0 AS advertisers_0_25, s0_.advertisers_1 AS advertisers_1_26, s0_.advertisers_2 AS advertisers_2_27, s0_.advertisers_3 AS advertisers_3_28, s0_.advertisers_4 AS advertisers_4_29, s0_.advertisers_5 AS advertisers_5_30, s0_.advertisers_6 AS advertisers_6_31, s0_.advertisers_7 AS advertisers_7_32, s0_.advertisers_8 AS advertisers_8_33, s0_.advertisers_9 AS advertisers_9_34, s0_.advertisers_10 AS advertisers_10_35, s0_.advertisers_11 AS advertisers_11_36, s0_.advertisers_12 AS advertisers_12_37, s0_.advertisers_13 AS advertisers_13_38, s0_.advertisers_14 AS advertisers_14_39, s0_.advertisers_15 AS advertisers_15_40, s0_.advertisers_16 AS advertisers_16_41, s0_.advertisers_17 AS advertisers_17_42, s0_.advertisers_18 AS advertisers_18_43, s0_.advertisers_19 AS advertisers_19_44, s0_.advertisers_20 AS advertisers_20_45, s0_.advertisers_21 AS advertisers_21_46, s0_.advertisers_22 AS advertisers_22_47, s0_.advertisers_23 AS advertisers_23_48, s0_.advertisers_24 AS advertisers_24_49, s0_.advertisers_25 AS advertisers_25_50, s0_.advertisers_25_text AS advertisers_25_text_51, s0_.training_center AS training_center_52 FROM speech_therapist s0_ LEFT JOIN practice_speech_therapists p1_ ON (s0_.id = p1_.speech_therapists_id) LEFT JOIN practices p2_ ON (p2_.id = p1_.practice_id) LEFT JOIN zipcode z3_ ON (p2_.localisation_id = z3_.id) WHERE z3_.id = ? ORDER BY s0_.name ASC
Parameters:
[
4569
]
|
| 4 | 1.45 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.name AS name_2, s0_.firstname AS firstname_3, s0_.degrees AS degrees_4, s0_.status_grade AS status_grade_5, s0_.specialty_hospitals AS specialty_hospitals_6, s0_.free_link AS free_link_7, s0_.advertisers AS advertisers_8, s0_.specialty_if_advertisers AS specialty_if_advertisers_9, s0_.specialty AS specialty_10, s0_.phone_1 AS phone_1_11, s0_.phone_2 AS phone_2_12, s0_.fax AS fax_13, s0_.email_1 AS email_1_14, s0_.email_2 AS email_2_15, s0_.website AS website_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.department AS department_19, s0_.nouvelle_fiche AS nouvelle_fiche_20, s0_.controle AS controle_21, s0_.validate_with_modif AS validate_with_modif_22, s0_.type_validate AS type_validate_23, s0_.observation AS observation_24, s0_.advertisers_0 AS advertisers_0_25, s0_.advertisers_1 AS advertisers_1_26, s0_.advertisers_2 AS advertisers_2_27, s0_.advertisers_3 AS advertisers_3_28, s0_.advertisers_4 AS advertisers_4_29, s0_.advertisers_5 AS advertisers_5_30, s0_.advertisers_6 AS advertisers_6_31, s0_.advertisers_7 AS advertisers_7_32, s0_.advertisers_8 AS advertisers_8_33, s0_.advertisers_9 AS advertisers_9_34, s0_.advertisers_10 AS advertisers_10_35, s0_.advertisers_11 AS advertisers_11_36, s0_.advertisers_12 AS advertisers_12_37, s0_.advertisers_13 AS advertisers_13_38, s0_.advertisers_14 AS advertisers_14_39, s0_.advertisers_15 AS advertisers_15_40, s0_.advertisers_16 AS advertisers_16_41, s0_.advertisers_17 AS advertisers_17_42, s0_.advertisers_18 AS advertisers_18_43, s0_.advertisers_19 AS advertisers_19_44, s0_.advertisers_20 AS advertisers_20_45, s0_.advertisers_21 AS advertisers_21_46, s0_.advertisers_22 AS advertisers_22_47, s0_.advertisers_23 AS advertisers_23_48, s0_.advertisers_24 AS advertisers_24_49, s0_.advertisers_25 AS advertisers_25_50, s0_.advertisers_25_text AS advertisers_25_text_51, s0_.training_center AS training_center_52 FROM speech_therapist s0_ LEFT JOIN service_speech_therapists s1_ ON (s0_.id = s1_.speech_therapists_id) LEFT JOIN services s2_ ON (s2_.id = s1_.service_id) LEFT JOIN hospitals h3_ ON (h3_.id = s2_.hospital_id) LEFT JOIN zipcode z4_ ON (h3_.localisation_id = z4_.id) WHERE z4_.id = ? ORDER BY s0_.name ASC
Parameters:
[
4569
]
|
| 5 | 139.32 ms |
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
Parameters:
[ -12.7905 45.1054 -12.7905 52785 0 ] |
| 6 | 65.51 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.name AS name_2, s0_.firstname AS firstname_3, s0_.degrees AS degrees_4, s0_.status_grade AS status_grade_5, s0_.specialty_hospitals AS specialty_hospitals_6, s0_.free_link AS free_link_7, s0_.advertisers AS advertisers_8, s0_.specialty_if_advertisers AS specialty_if_advertisers_9, s0_.specialty AS specialty_10, s0_.phone_1 AS phone_1_11, s0_.phone_2 AS phone_2_12, s0_.fax AS fax_13, s0_.email_1 AS email_1_14, s0_.email_2 AS email_2_15, s0_.website AS website_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.department AS department_19, s0_.nouvelle_fiche AS nouvelle_fiche_20, s0_.controle AS controle_21, s0_.validate_with_modif AS validate_with_modif_22, s0_.type_validate AS type_validate_23, s0_.observation AS observation_24, s0_.advertisers_0 AS advertisers_0_25, s0_.advertisers_1 AS advertisers_1_26, s0_.advertisers_2 AS advertisers_2_27, s0_.advertisers_3 AS advertisers_3_28, s0_.advertisers_4 AS advertisers_4_29, s0_.advertisers_5 AS advertisers_5_30, s0_.advertisers_6 AS advertisers_6_31, s0_.advertisers_7 AS advertisers_7_32, s0_.advertisers_8 AS advertisers_8_33, s0_.advertisers_9 AS advertisers_9_34, s0_.advertisers_10 AS advertisers_10_35, s0_.advertisers_11 AS advertisers_11_36, s0_.advertisers_12 AS advertisers_12_37, s0_.advertisers_13 AS advertisers_13_38, s0_.advertisers_14 AS advertisers_14_39, s0_.advertisers_15 AS advertisers_15_40, s0_.advertisers_16 AS advertisers_16_41, s0_.advertisers_17 AS advertisers_17_42, s0_.advertisers_18 AS advertisers_18_43, s0_.advertisers_19 AS advertisers_19_44, s0_.advertisers_20 AS advertisers_20_45, s0_.advertisers_21 AS advertisers_21_46, s0_.advertisers_22 AS advertisers_22_47, s0_.advertisers_23 AS advertisers_23_48, s0_.advertisers_24 AS advertisers_24_49, s0_.advertisers_25 AS advertisers_25_50, s0_.advertisers_25_text AS advertisers_25_text_51, s0_.training_center AS training_center_52 FROM speech_therapist s0_ LEFT JOIN practice_speech_therapists p1_ ON (s0_.id = p1_.speech_therapists_id) LEFT JOIN practices p2_ ON (p2_.id = p1_.practice_id) LEFT JOIN zipcode z3_ ON (p2_.localisation_id = z3_.id) WHERE z3_.id = ? ORDER BY s0_.name ASC
Parameters:
[
4052
]
|
| 7 | 1.37 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.name AS name_2, s0_.firstname AS firstname_3, s0_.degrees AS degrees_4, s0_.status_grade AS status_grade_5, s0_.specialty_hospitals AS specialty_hospitals_6, s0_.free_link AS free_link_7, s0_.advertisers AS advertisers_8, s0_.specialty_if_advertisers AS specialty_if_advertisers_9, s0_.specialty AS specialty_10, s0_.phone_1 AS phone_1_11, s0_.phone_2 AS phone_2_12, s0_.fax AS fax_13, s0_.email_1 AS email_1_14, s0_.email_2 AS email_2_15, s0_.website AS website_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.department AS department_19, s0_.nouvelle_fiche AS nouvelle_fiche_20, s0_.controle AS controle_21, s0_.validate_with_modif AS validate_with_modif_22, s0_.type_validate AS type_validate_23, s0_.observation AS observation_24, s0_.advertisers_0 AS advertisers_0_25, s0_.advertisers_1 AS advertisers_1_26, s0_.advertisers_2 AS advertisers_2_27, s0_.advertisers_3 AS advertisers_3_28, s0_.advertisers_4 AS advertisers_4_29, s0_.advertisers_5 AS advertisers_5_30, s0_.advertisers_6 AS advertisers_6_31, s0_.advertisers_7 AS advertisers_7_32, s0_.advertisers_8 AS advertisers_8_33, s0_.advertisers_9 AS advertisers_9_34, s0_.advertisers_10 AS advertisers_10_35, s0_.advertisers_11 AS advertisers_11_36, s0_.advertisers_12 AS advertisers_12_37, s0_.advertisers_13 AS advertisers_13_38, s0_.advertisers_14 AS advertisers_14_39, s0_.advertisers_15 AS advertisers_15_40, s0_.advertisers_16 AS advertisers_16_41, s0_.advertisers_17 AS advertisers_17_42, s0_.advertisers_18 AS advertisers_18_43, s0_.advertisers_19 AS advertisers_19_44, s0_.advertisers_20 AS advertisers_20_45, s0_.advertisers_21 AS advertisers_21_46, s0_.advertisers_22 AS advertisers_22_47, s0_.advertisers_23 AS advertisers_23_48, s0_.advertisers_24 AS advertisers_24_49, s0_.advertisers_25 AS advertisers_25_50, s0_.advertisers_25_text AS advertisers_25_text_51, s0_.training_center AS training_center_52 FROM speech_therapist s0_ LEFT JOIN service_speech_therapists s1_ ON (s0_.id = s1_.speech_therapists_id) LEFT JOIN services s2_ ON (s2_.id = s1_.service_id) LEFT JOIN hospitals h3_ ON (h3_.id = s2_.hospital_id) LEFT JOIN zipcode z4_ ON (h3_.localisation_id = z4_.id) WHERE z4_.id = ? ORDER BY s0_.name ASC
Parameters:
[
4052
]
|
| 8 | 69.67 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.name AS name_2, s0_.firstname AS firstname_3, s0_.degrees AS degrees_4, s0_.status_grade AS status_grade_5, s0_.specialty_hospitals AS specialty_hospitals_6, s0_.free_link AS free_link_7, s0_.advertisers AS advertisers_8, s0_.specialty_if_advertisers AS specialty_if_advertisers_9, s0_.specialty AS specialty_10, s0_.phone_1 AS phone_1_11, s0_.phone_2 AS phone_2_12, s0_.fax AS fax_13, s0_.email_1 AS email_1_14, s0_.email_2 AS email_2_15, s0_.website AS website_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.department AS department_19, s0_.nouvelle_fiche AS nouvelle_fiche_20, s0_.controle AS controle_21, s0_.validate_with_modif AS validate_with_modif_22, s0_.type_validate AS type_validate_23, s0_.observation AS observation_24, s0_.advertisers_0 AS advertisers_0_25, s0_.advertisers_1 AS advertisers_1_26, s0_.advertisers_2 AS advertisers_2_27, s0_.advertisers_3 AS advertisers_3_28, s0_.advertisers_4 AS advertisers_4_29, s0_.advertisers_5 AS advertisers_5_30, s0_.advertisers_6 AS advertisers_6_31, s0_.advertisers_7 AS advertisers_7_32, s0_.advertisers_8 AS advertisers_8_33, s0_.advertisers_9 AS advertisers_9_34, s0_.advertisers_10 AS advertisers_10_35, s0_.advertisers_11 AS advertisers_11_36, s0_.advertisers_12 AS advertisers_12_37, s0_.advertisers_13 AS advertisers_13_38, s0_.advertisers_14 AS advertisers_14_39, s0_.advertisers_15 AS advertisers_15_40, s0_.advertisers_16 AS advertisers_16_41, s0_.advertisers_17 AS advertisers_17_42, s0_.advertisers_18 AS advertisers_18_43, s0_.advertisers_19 AS advertisers_19_44, s0_.advertisers_20 AS advertisers_20_45, s0_.advertisers_21 AS advertisers_21_46, s0_.advertisers_22 AS advertisers_22_47, s0_.advertisers_23 AS advertisers_23_48, s0_.advertisers_24 AS advertisers_24_49, s0_.advertisers_25 AS advertisers_25_50, s0_.advertisers_25_text AS advertisers_25_text_51, s0_.training_center AS training_center_52 FROM speech_therapist s0_ LEFT JOIN practice_speech_therapists p1_ ON (s0_.id = p1_.speech_therapists_id) LEFT JOIN practices p2_ ON (p2_.id = p1_.practice_id) LEFT JOIN zipcode z3_ ON (p2_.localisation_id = z3_.id) WHERE z3_.id = ? ORDER BY s0_.name ASC
Parameters:
[
3854
]
|
| 9 | 1.84 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.name AS name_2, s0_.firstname AS firstname_3, s0_.degrees AS degrees_4, s0_.status_grade AS status_grade_5, s0_.specialty_hospitals AS specialty_hospitals_6, s0_.free_link AS free_link_7, s0_.advertisers AS advertisers_8, s0_.specialty_if_advertisers AS specialty_if_advertisers_9, s0_.specialty AS specialty_10, s0_.phone_1 AS phone_1_11, s0_.phone_2 AS phone_2_12, s0_.fax AS fax_13, s0_.email_1 AS email_1_14, s0_.email_2 AS email_2_15, s0_.website AS website_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.department AS department_19, s0_.nouvelle_fiche AS nouvelle_fiche_20, s0_.controle AS controle_21, s0_.validate_with_modif AS validate_with_modif_22, s0_.type_validate AS type_validate_23, s0_.observation AS observation_24, s0_.advertisers_0 AS advertisers_0_25, s0_.advertisers_1 AS advertisers_1_26, s0_.advertisers_2 AS advertisers_2_27, s0_.advertisers_3 AS advertisers_3_28, s0_.advertisers_4 AS advertisers_4_29, s0_.advertisers_5 AS advertisers_5_30, s0_.advertisers_6 AS advertisers_6_31, s0_.advertisers_7 AS advertisers_7_32, s0_.advertisers_8 AS advertisers_8_33, s0_.advertisers_9 AS advertisers_9_34, s0_.advertisers_10 AS advertisers_10_35, s0_.advertisers_11 AS advertisers_11_36, s0_.advertisers_12 AS advertisers_12_37, s0_.advertisers_13 AS advertisers_13_38, s0_.advertisers_14 AS advertisers_14_39, s0_.advertisers_15 AS advertisers_15_40, s0_.advertisers_16 AS advertisers_16_41, s0_.advertisers_17 AS advertisers_17_42, s0_.advertisers_18 AS advertisers_18_43, s0_.advertisers_19 AS advertisers_19_44, s0_.advertisers_20 AS advertisers_20_45, s0_.advertisers_21 AS advertisers_21_46, s0_.advertisers_22 AS advertisers_22_47, s0_.advertisers_23 AS advertisers_23_48, s0_.advertisers_24 AS advertisers_24_49, s0_.advertisers_25 AS advertisers_25_50, s0_.advertisers_25_text AS advertisers_25_text_51, s0_.training_center AS training_center_52 FROM speech_therapist s0_ LEFT JOIN service_speech_therapists s1_ ON (s0_.id = s1_.speech_therapists_id) LEFT JOIN services s2_ ON (s2_.id = s1_.service_id) LEFT JOIN hospitals h3_ ON (h3_.id = s2_.hospital_id) LEFT JOIN zipcode z4_ ON (h3_.localisation_id = z4_.id) WHERE z4_.id = ? ORDER BY s0_.name ASC
Parameters:
[
3854
]
|
| 10 | 10.69 ms |
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 = ? ORDER BY z0_.zipcode ASC LIMIT 1
Parameters:
[
"97680"
]
|
| 11 | 26.40 ms |
SELECT z0_.city AS city_0, COUNT(z0_.city) AS sclr_1, z0_.zipcode AS zipcode_2 FROM practices p1_ LEFT JOIN zipcode z0_ ON (p1_.localisation_id = z0_.id) WHERE p1_.type_id = 2 AND (z0_.country = ? OR z0_.country = ?) AND z0_.department LIKE '976 %' GROUP BY z0_.city ORDER BY COUNT(z0_.city) DESC LIMIT 21
Parameters:
[
"FRANCE"
""
]
|
| 12 | 0.21 ms |
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 = ? ORDER BY z0_.zipcode ASC LIMIT 1
Parameters:
[
"97680"
]
|
| 13 | 0.18 ms |
SELECT z0_.city AS city_0, COUNT(z0_.city) AS sclr_1, z0_.zipcode AS zipcode_2 FROM practices p1_ LEFT JOIN zipcode z0_ ON (p1_.localisation_id = z0_.id) WHERE p1_.type_id = 2 AND (z0_.country = ? OR z0_.country = ?) AND z0_.department LIKE '976 %' GROUP BY z0_.city ORDER BY COUNT(z0_.city) DESC LIMIT 21
Parameters:
[
"FRANCE"
""
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Zipcode | No errors. |
| App\Entity\Cities | No errors. |
| App\Entity\SpeechTherapist | No errors. |
| App\Entity\PracticeSpeechTherapists | No errors. |
| App\Entity\Practices | No errors. |
| App\Entity\ServiceSpeechTherapists | No errors. |
| App\Entity\Services | No errors. |
| App\Entity\Hospitals | No errors. |