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 = 'coach-sportif' 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 = 'toulouse' 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 = 7 AND t0.city_id = 1 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(43.6006737)
    ) + COS(
      RADIANS(p0_.address_coord_y)
    ) * COS(
      RADIANS(43.6006737)
    ) * COS(
      RADIANS(p0_.address_coord_x) - RADIANS(1.3504422)
    )
  ) * 6380 AS sclr_37,
  ACOS(
    SIN(
      RADIANS(p1_.address_coord_y)
    ) * SIN(
      RADIANS(43.6006737)
    ) + COS(
      RADIANS(p1_.address_coord_y)
    ) * COS(
      RADIANS(43.6006737)
    ) * COS(
      RADIANS(p1_.address_coord_x) - RADIANS(1.3504422)
    )
  ) * 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 ?
    )
    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(43.6006737)) + COS(RADIANS(p0_.address_coord_y)) * COS(RADIANS(43.6006737)) * COS(RADIANS(p0_.address_coord_x) - RADIANS(1.3504422))) * 6380 AS sclr_37, ACOS(SIN(RADIANS(p1_.address_coord_y)) * SIN(RADIANS(43.6006737)) + COS(RADIANS(p1_.address_coord_y)) * COS(RADIANS(43.6006737)) * COS(RADIANS(p1_.address_coord_x) - RADIANS(1.3504422))) * 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 '%Coaching%' OR p0_.first_name LIKE '%Coaching%' OR p0_.slogan LIKE '%Coaching%' OR n2_.label LIKE '%Coaching%' OR n2_.tags LIKE '%Coaching%' OR s4_.label LIKE '%Coaching%' OR s4_.tags LIKE '%Coaching%' OR p6_.description LIKE '%Coaching%') AND (p0_.last_name LIKE '%sportif%' OR p0_.first_name LIKE '%sportif%' OR p0_.slogan LIKE '%sportif%' OR n2_.label LIKE '%sportif%' OR n2_.tags LIKE '%sportif%' OR s4_.label LIKE '%sportif%' OR s4_.tags LIKE '%sportif%' OR p6_.description LIKE '%sportif%')) HAVING sclr_37 <= 50 OR sclr_38 <= 50 ORDER BY sclr_37 ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.enabled AS enabled_5,
  t0.roles AS roles_6,
  t0.registration_date AS registration_date_7,
  t0.last_login AS last_login_8,
  t0.password_request_date AS password_request_date_9,
  t0.password_request AS password_request_10,
  t0.stripe_customer_id AS stripe_customer_id_11,
  t0.user_id AS user_id_12,
  t0.partner_id AS partner_id_13
FROM
  account t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = 7;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.enabled AS enabled_5,
  t0.roles AS roles_6,
  t0.registration_date AS registration_date_7,
  t0.last_login AS last_login_8,
  t0.password_request_date AS password_request_date_9,
  t0.password_request AS password_request_10,
  t0.stripe_customer_id AS stripe_customer_id_11,
  t0.user_id AS user_id_12,
  t0.partner_id AS partner_id_13
FROM
  account t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = 36;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.enabled AS enabled_5,
  t0.roles AS roles_6,
  t0.registration_date AS registration_date_7,
  t0.last_login AS last_login_8,
  t0.password_request_date AS password_request_date_9,
  t0.password_request AS password_request_10,
  t0.stripe_customer_id AS stripe_customer_id_11,
  t0.user_id AS user_id_12,
  t0.partner_id AS partner_id_13
FROM
  account t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = 32;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.enabled AS enabled_5,
  t0.roles AS roles_6,
  t0.registration_date AS registration_date_7,
  t0.last_login AS last_login_8,
  t0.password_request_date AS password_request_date_9,
  t0.password_request AS password_request_10,
  t0.stripe_customer_id AS stripe_customer_id_11,
  t0.user_id AS user_id_12,
  t0.partner_id AS partner_id_13
FROM
  account t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.registration_date AS registration_date_7, t0.last_login AS last_login_8, t0.password_request_date AS password_request_date_9, t0.password_request AS password_request_10, t0.stripe_customer_id AS stripe_customer_id_11, t0.user_id AS user_id_12, t0.partner_id AS partner_id_13 FROM account t0 WHERE t0.partner_id = 39;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.canceled AS canceled_5,
  t0.duration AS duration_6,
  t0.payment_type AS payment_type_7,
  t0.stripe_sub_id AS stripe_sub_id_8,
  t0.partner_id AS partner_id_9
FROM
  partner_subscription t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.canceled AS canceled_5, t0.duration AS duration_6, t0.payment_type AS payment_type_7, t0.stripe_sub_id AS stripe_sub_id_8, t0.partner_id AS partner_id_9 FROM partner_subscription t0 WHERE t0.partner_id = 7;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.canceled AS canceled_5,
  t0.duration AS duration_6,
  t0.payment_type AS payment_type_7,
  t0.stripe_sub_id AS stripe_sub_id_8,
  t0.partner_id AS partner_id_9
FROM
  partner_subscription t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.canceled AS canceled_5, t0.duration AS duration_6, t0.payment_type AS payment_type_7, t0.stripe_sub_id AS stripe_sub_id_8, t0.partner_id AS partner_id_9 FROM partner_subscription t0 WHERE t0.partner_id = 36;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.canceled AS canceled_5,
  t0.duration AS duration_6,
  t0.payment_type AS payment_type_7,
  t0.stripe_sub_id AS stripe_sub_id_8,
  t0.partner_id AS partner_id_9
FROM
  partner_subscription t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.canceled AS canceled_5, t0.duration AS duration_6, t0.payment_type AS payment_type_7, t0.stripe_sub_id AS stripe_sub_id_8, t0.partner_id AS partner_id_9 FROM partner_subscription t0 WHERE t0.partner_id = 32;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.canceled AS canceled_5,
  t0.duration AS duration_6,
  t0.payment_type AS payment_type_7,
  t0.stripe_sub_id AS stripe_sub_id_8,
  t0.partner_id AS partner_id_9
FROM
  partner_subscription t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.canceled AS canceled_5, t0.duration AS duration_6, t0.payment_type AS payment_type_7, t0.stripe_sub_id AS stripe_sub_id_8, t0.partner_id AS partner_id_9 FROM partner_subscription t0 WHERE t0.partner_id = 39;

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;

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
  INNER JOIN partner_has_speciality ON t0.id = partner_has_speciality.speciality_id
WHERE
  partner_has_speciality.partner_id = ?

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 INNER JOIN partner_has_speciality ON t0.id = partner_has_speciality.speciality_id WHERE partner_has_speciality.partner_id = 32;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.address2 AS address2_4,
  t0.zip_code AS zip_code_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.address_coord_y AS address_coord_y_8,
  t0.address_coord_x AS address_coord_x_9,
  t0.active AS active_10,
  t0.partner_id AS partner_id_11
FROM
  partner_secondary_location t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.address2 AS address2_4, t0.zip_code AS zip_code_5, t0.city AS city_6, t0.country AS country_7, t0.address_coord_y AS address_coord_y_8, t0.address_coord_x AS address_coord_x_9, t0.active AS active_10, t0.partner_id AS partner_id_11 FROM partner_secondary_location t0 WHERE t0.partner_id = 32;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.price AS price_3,
  t0.discount AS discount_4,
  t0.duration AS duration_5,
  t0.enabled AS enabled_6,
  t0.is_coaching AS is_coaching_7,
  t0.first_reservation_only AS first_reservation_only_8,
  t0.second_reservation_only AS second_reservation_only_9,
  t0.partner_id AS partner_id_10,
  t0.history_service_id AS history_service_id_11
FROM
  service_delivery t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.discount AS discount_4, t0.duration AS duration_5, t0.enabled AS enabled_6, t0.is_coaching AS is_coaching_7, t0.first_reservation_only AS first_reservation_only_8, t0.second_reservation_only AS second_reservation_only_9, t0.partner_id AS partner_id_10, t0.history_service_id AS history_service_id_11 FROM service_delivery t0 WHERE t0.partner_id = 32;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.picture AS picture_3,
  t0.page_content AS page_content_4,
  t0.tags AS tags_5,
  t0.slug AS slug_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8
FROM
  need t0
  INNER JOIN partner_has_need ON t0.id = partner_has_need.need_id
WHERE
  partner_has_need.partner_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.picture AS picture_3, t0.page_content AS page_content_4, t0.tags AS tags_5, t0.slug AS slug_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8 FROM need t0 INNER JOIN partner_has_need ON t0.id = partner_has_need.need_id WHERE partner_has_need.partner_id = 32;

SELECT
  t0.id AS id_1,
  t0.note AS note_2,
  t0.opinion AS opinion_3,
  t0.created_at AS created_at_4,
  t0.partner_id AS partner_id_5,
  t0.user_id AS user_id_6
FROM
  partner_note t0
WHERE
  t0.partner_id = ?

SELECT t0.id AS id_1, t0.note AS note_2, t0.opinion AS opinion_3, t0.created_at AS created_at_4, t0.partner_id AS partner_id_5, t0.user_id AS user_id_6 FROM partner_note t0 WHERE t0.partner_id = 32;