Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.job AS job_3,
  t0.jobs AS jobs_4,
  t0.picture AS picture_5,
  t0.page_content AS page_content_6,
  t0.tags AS tags_7,
  t0.slug AS slug_8,
  t0.slug_job AS slug_job_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11
FROM
  speciality t0
WHERE
  t0.slug_job = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.job AS job_3, t0.jobs AS jobs_4, t0.picture AS picture_5, t0.page_content AS page_content_6, t0.tags AS tags_7, t0.slug AS slug_8, t0.slug_job AS slug_job_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11 FROM speciality t0 WHERE t0.slug_job = 'dieteticien' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lat AS lat_3,
  t0.lon AS lon_4,
  t0.slug AS slug_5
FROM
  city t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.slug AS slug_5 FROM city t0 WHERE t0.slug = 'bordeaux' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.speciality_id AS speciality_id_3,
  t0.city_id AS city_id_4
FROM
  speciality_has_city t0
WHERE
  t0.speciality_id = ?
  AND t0.city_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2, t0.speciality_id AS speciality_id_3, t0.city_id AS city_id_4 FROM speciality_has_city t0 WHERE t0.speciality_id = 37 AND t0.city_id = 2 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.last_name AS last_name_1,
  p0_.first_name AS first_name_2,
  p0_.public_email AS public_email_3,
  p0_.phone AS phone_4,
  p0_.avatar AS avatar_5,
  p0_.slogan AS slogan_6,
  p0_.address_name AS address_name_7,
  p0_.address AS address_8,
  p0_.address2 AS address2_9,
  p0_.zip_code AS zip_code_10,
  p0_.city AS city_11,
  p0_.country AS country_12,
  p0_.address_coord_y AS address_coord_y_13,
  p0_.address_coord_x AS address_coord_x_14,
  p0_.siret AS siret_15,
  p0_.legal_form AS legal_form_16,
  p0_.assurance_name AS assurance_name_17,
  p0_.isCoach AS isCoach_18,
  p0_.isPractitioner AS isPractitioner_19,
  p0_.allow_teleconsultation AS allow_teleconsultation_20,
  p0_.allow_office AS allow_office_21,
  p0_.allow_home_visit AS allow_home_visit_22,
  p0_.nb_days_before_reservation AS nb_days_before_reservation_23,
  p0_.nb_days_available AS nb_days_available_24,
  p0_.stripe_account_id AS stripe_account_id_25,
  p0_.stripe_account_verified AS stripe_account_verified_26,
  p0_.stripe_charges_enabled AS stripe_charges_enabled_27,
  p0_.stripe_payouts_enabled AS stripe_payouts_enabled_28,
  p0_.subscription_discount AS subscription_discount_29,
  p0_.subscription_discount_type AS subscription_discount_type_30,
  p0_.subscription_discount_duration AS subscription_discount_duration_31,
  p0_.validated_practitioner AS validated_practitioner_32,
  p0_.validated_coach AS validated_coach_33,
  p0_.slug AS slug_34,
  p0_.google_calendar_status AS google_calendar_status_35,
  p0_.partnership_code AS partnership_code_36,
  ACOS(
    SIN(
      RADIANS(p0_.address_coord_y)
    ) * SIN(
      RADIANS(44.8636118)
    ) + COS(
      RADIANS(p0_.address_coord_y)
    ) * COS(
      RADIANS(44.8636118)
    ) * COS(
      RADIANS(p0_.address_coord_x) - RADIANS(-0.7418988)
    )
  ) * 6380 AS sclr_37,
  ACOS(
    SIN(
      RADIANS(p1_.address_coord_y)
    ) * SIN(
      RADIANS(44.8636118)
    ) + COS(
      RADIANS(p1_.address_coord_y)
    ) * COS(
      RADIANS(44.8636118)
    ) * COS(
      RADIANS(p1_.address_coord_x) - RADIANS(-0.7418988)
    )
  ) * 6380 AS sclr_38,
  p0_.monday AS monday_39,
  p0_.sunday AS sunday_40,
  p0_.wednesday AS wednesday_41,
  p0_.partner_page_id AS partner_page_id_42,
  p0_.thursday AS thursday_43,
  p0_.friday AS friday_44,
  p0_.saturday AS saturday_45,
  p0_.tuesday AS tuesday_46
FROM
  partner p0_
  LEFT JOIN partner_has_need p3_ ON p0_.id = p3_.partner_id
  LEFT JOIN need n2_ ON n2_.id = p3_.need_id
  LEFT JOIN partner_has_speciality p5_ ON p0_.id = p5_.partner_id
  LEFT JOIN speciality s4_ ON s4_.id = p5_.speciality_id
  LEFT JOIN partner_page p6_ ON p0_.partner_page_id = p6_.id
  LEFT JOIN partner_secondary_location p1_ ON p0_.id = p1_.partner_id
WHERE
  p0_.isPractitioner = 1
  AND (
    p0_.last_name LIKE ?
    OR p0_.first_name LIKE ?
    OR p0_.slogan LIKE ?
    OR n2_.label LIKE ?
    OR n2_.tags LIKE ?
    OR s4_.label LIKE ?
    OR s4_.tags LIKE ?
    OR p6_.description LIKE ?
  )
HAVING
  sclr_37 <= 50
  OR sclr_38 <= 50
ORDER BY
  sclr_37 ASC

SELECT p0_.id AS id_0, p0_.last_name AS last_name_1, p0_.first_name AS first_name_2, p0_.public_email AS public_email_3, p0_.phone AS phone_4, p0_.avatar AS avatar_5, p0_.slogan AS slogan_6, p0_.address_name AS address_name_7, p0_.address AS address_8, p0_.address2 AS address2_9, p0_.zip_code AS zip_code_10, p0_.city AS city_11, p0_.country AS country_12, p0_.address_coord_y AS address_coord_y_13, p0_.address_coord_x AS address_coord_x_14, p0_.siret AS siret_15, p0_.legal_form AS legal_form_16, p0_.assurance_name AS assurance_name_17, p0_.isCoach AS isCoach_18, p0_.isPractitioner AS isPractitioner_19, p0_.allow_teleconsultation AS allow_teleconsultation_20, p0_.allow_office AS allow_office_21, p0_.allow_home_visit AS allow_home_visit_22, p0_.nb_days_before_reservation AS nb_days_before_reservation_23, p0_.nb_days_available AS nb_days_available_24, p0_.stripe_account_id AS stripe_account_id_25, p0_.stripe_account_verified AS stripe_account_verified_26, p0_.stripe_charges_enabled AS stripe_charges_enabled_27, p0_.stripe_payouts_enabled AS stripe_payouts_enabled_28, p0_.subscription_discount AS subscription_discount_29, p0_.subscription_discount_type AS subscription_discount_type_30, p0_.subscription_discount_duration AS subscription_discount_duration_31, p0_.validated_practitioner AS validated_practitioner_32, p0_.validated_coach AS validated_coach_33, p0_.slug AS slug_34, p0_.google_calendar_status AS google_calendar_status_35, p0_.partnership_code AS partnership_code_36, ACOS(SIN(RADIANS(p0_.address_coord_y)) * SIN(RADIANS(44.8636118)) + COS(RADIANS(p0_.address_coord_y)) * COS(RADIANS(44.8636118)) * COS(RADIANS(p0_.address_coord_x) - RADIANS(-0.7418988))) * 6380 AS sclr_37, ACOS(SIN(RADIANS(p1_.address_coord_y)) * SIN(RADIANS(44.8636118)) + COS(RADIANS(p1_.address_coord_y)) * COS(RADIANS(44.8636118)) * COS(RADIANS(p1_.address_coord_x) - RADIANS(-0.7418988))) * 6380 AS sclr_38, p0_.monday AS monday_39, p0_.sunday AS sunday_40, p0_.wednesday AS wednesday_41, p0_.partner_page_id AS partner_page_id_42, p0_.thursday AS thursday_43, p0_.friday AS friday_44, p0_.saturday AS saturday_45, p0_.tuesday AS tuesday_46 FROM partner p0_ LEFT JOIN partner_has_need p3_ ON p0_.id = p3_.partner_id LEFT JOIN need n2_ ON n2_.id = p3_.need_id LEFT JOIN partner_has_speciality p5_ ON p0_.id = p5_.partner_id LEFT JOIN speciality s4_ ON s4_.id = p5_.speciality_id LEFT JOIN partner_page p6_ ON p0_.partner_page_id = p6_.id LEFT JOIN partner_secondary_location p1_ ON p0_.id = p1_.partner_id WHERE p0_.isPractitioner = 1 AND (p0_.last_name LIKE '%Diététique%' OR p0_.first_name LIKE '%Diététique%' OR p0_.slogan LIKE '%Diététique%' OR n2_.label LIKE '%Diététique%' OR n2_.tags LIKE '%Diététique%' OR s4_.label LIKE '%Diététique%' OR s4_.tags LIKE '%Diététique%' OR p6_.description LIKE '%Diététique%') HAVING sclr_37 <= 50 OR sclr_38 <= 50 ORDER BY sclr_37 ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.job AS job_3,
  t0.jobs AS jobs_4,
  t0.picture AS picture_5,
  t0.page_content AS page_content_6,
  t0.tags AS tags_7,
  t0.slug AS slug_8,
  t0.slug_job AS slug_job_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11
FROM
  speciality t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.job AS job_3, t0.jobs AS jobs_4, t0.picture AS picture_5, t0.page_content AS page_content_6, t0.tags AS tags_7, t0.slug AS slug_8, t0.slug_job AS slug_job_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11 FROM speciality t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lat AS lat_3,
  t0.lon AS lon_4,
  t0.slug AS slug_5
FROM
  city t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.slug AS slug_5 FROM city t0;