Symfony Profiler

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,
  0 AS sclr_37,
  p0_.monday AS monday_38,
  p0_.sunday AS sunday_39,
  p0_.wednesday AS wednesday_40,
  p0_.partner_page_id AS partner_page_id_41,
  p0_.thursday AS thursday_42,
  p0_.friday AS friday_43,
  p0_.saturday AS saturday_44,
  p0_.tuesday AS tuesday_45
FROM
  partner p0_
  LEFT JOIN partner_has_need p2_ ON p0_.id = p2_.partner_id
  LEFT JOIN need n1_ ON n1_.id = p2_.need_id
  LEFT JOIN partner_has_speciality p4_ ON p0_.id = p4_.partner_id
  LEFT JOIN speciality s3_ ON s3_.id = p4_.speciality_id
  LEFT JOIN partner_page p5_ ON p0_.partner_page_id = p5_.id
WHERE
  p0_.isPractitioner = 1
  AND (
    p0_.last_name LIKE ?
    OR p0_.first_name LIKE ?
    OR p0_.slogan LIKE ?
    OR n1_.label LIKE ?
    OR n1_.tags LIKE ?
    OR s3_.label LIKE ?
    OR s3_.tags LIKE ?
    OR p5_.description LIKE ?
  )
ORDER BY
  RAND() 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, 0 AS sclr_37, p0_.monday AS monday_38, p0_.sunday AS sunday_39, p0_.wednesday AS wednesday_40, p0_.partner_page_id AS partner_page_id_41, p0_.thursday AS thursday_42, p0_.friday AS friday_43, p0_.saturday AS saturday_44, p0_.tuesday AS tuesday_45 FROM partner p0_ LEFT JOIN partner_has_need p2_ ON p0_.id = p2_.partner_id LEFT JOIN need n1_ ON n1_.id = p2_.need_id LEFT JOIN partner_has_speciality p4_ ON p0_.id = p4_.partner_id LEFT JOIN speciality s3_ ON s3_.id = p4_.speciality_id LEFT JOIN partner_page p5_ ON p0_.partner_page_id = p5_.id WHERE p0_.isPractitioner = 1 AND (p0_.last_name LIKE '%Pilates%' OR p0_.first_name LIKE '%Pilates%' OR p0_.slogan LIKE '%Pilates%' OR n1_.label LIKE '%Pilates%' OR n1_.tags LIKE '%Pilates%' OR s3_.label LIKE '%Pilates%' OR s3_.tags LIKE '%Pilates%' OR p5_.description LIKE '%Pilates%') ORDER BY RAND() 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.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 = 'professeur-de-pilates' LIMIT 1;