Symfony Profiler

SELECT
  a0_.country_code AS country_code_0
FROM
  address a0_
  INNER JOIN user u1_ ON a0_.id = u1_.address_id
  LEFT JOIN coach c2_ ON u1_.id = c2_.id
  LEFT JOIN club c3_ ON u1_.id = c3_.id
  LEFT JOIN operator o4_ ON u1_.id = o4_.id
  LEFT JOIN trainee t5_ ON u1_.id = t5_.id
  LEFT JOIN admin a6_ ON u1_.id = a6_.id
WHERE
  u1_.is_pro = 1
GROUP BY
  a0_.country_code
ORDER BY
  COUNT(a0_.country_code) DESC

SELECT a0_.country_code AS country_code_0 FROM address a0_ INNER JOIN user u1_ ON a0_.id = u1_.address_id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id WHERE u1_.is_pro = 1 GROUP BY a0_.country_code ORDER BY COUNT(a0_.country_code) DESC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.icon AS icon_3,
  s0_.status AS status_4,
  s0_.appearance AS appearance_5
FROM
  sport s0_
WHERE
  s0_.status = ?
ORDER BY
  s0_.appearance ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.icon AS icon_3, s0_.status AS status_4, s0_.appearance AS appearance_5 FROM sport s0_ WHERE s0_.status = 'visible' ORDER BY s0_.appearance ASC;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.slug AS slug_2
FROM
  language l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM language l0_;

SELECT
  u0_.id AS id_0,
  u0_.firstname AS firstname_1,
  u0_.lastname AS lastname_2,
  u0_.telephone AS telephone_3,
  u0_.email AS email_4,
  u0_.password AS password_5,
  u0_.activated AS activated_6,
  u0_.notification AS notification_7,
  u0_.registered_at AS registered_at_8,
  u0_.token AS token_9,
  u0_.photo AS photo_10,
  u0_.slug AS slug_11,
  u0_.is_pro AS is_pro_12,
  u0_.has_access AS has_access_13,
  u0_.status AS status_14,
  u0_.has_accepted_terms AS has_accepted_terms_15,
  u0_.is_ambassador AS is_ambassador_16,
  u0_.language AS language_17,
  u0_.timezone AS timezone_18,
  u0_.phone_code AS phone_code_19,
  u0_.newsletter AS newsletter_20,
  c1_.is_mobile AS is_mobile_21,
  o3_.is_mobile AS is_mobile_22,
  t4_.birth_date AS birth_date_23,
  t4_.country AS country_24,
  a5_.has_already_logged_in AS has_already_logged_in_25,
  a5_.need_review AS need_review_26,
  a5_.is_editor AS is_editor_27,
  COUNT(c6_.owner_id) AS sclr_28,
  u0_.type AS type_29,
  u0_.address_id AS address_id_30,
  u0_.pro_info_id AS pro_info_id_31,
  u0_.stripe_info_id AS stripe_info_id_32
FROM
  user u0_
  LEFT JOIN coach c1_ ON u0_.id = c1_.id
  LEFT JOIN club c2_ ON u0_.id = c2_.id
  LEFT JOIN operator o3_ ON u0_.id = o3_.id
  LEFT JOIN trainee t4_ ON u0_.id = t4_.id
  LEFT JOIN admin a5_ ON u0_.id = a5_.id
  INNER JOIN pro_info p7_ ON u0_.pro_info_id = p7_.id
  LEFT JOIN course c6_ ON u0_.id = c6_.owner_id
WHERE
  u0_.activated = ?
  AND u0_.is_pro = ?
  AND u0_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND u0_.type IN ('club')
  AND p7_.page_visible = 1
GROUP BY
  u0_.id,
  u0_.firstname,
  u0_.lastname,
  u0_.telephone,
  u0_.email,
  u0_.password,
  u0_.activated,
  u0_.notification,
  u0_.registered_at,
  u0_.token,
  u0_.photo,
  u0_.slug,
  u0_.is_pro,
  u0_.has_access,
  u0_.status,
  u0_.has_accepted_terms,
  u0_.is_ambassador,
  u0_.language,
  u0_.timezone,
  u0_.phone_code,
  u0_.newsletter,
  u0_.address_id,
  u0_.pro_info_id,
  u0_.stripe_info_id
ORDER BY
  sclr_28 DESC

SELECT u0_.id AS id_0, u0_.firstname AS firstname_1, u0_.lastname AS lastname_2, u0_.telephone AS telephone_3, u0_.email AS email_4, u0_.password AS password_5, u0_.activated AS activated_6, u0_.notification AS notification_7, u0_.registered_at AS registered_at_8, u0_.token AS token_9, u0_.photo AS photo_10, u0_.slug AS slug_11, u0_.is_pro AS is_pro_12, u0_.has_access AS has_access_13, u0_.status AS status_14, u0_.has_accepted_terms AS has_accepted_terms_15, u0_.is_ambassador AS is_ambassador_16, u0_.language AS language_17, u0_.timezone AS timezone_18, u0_.phone_code AS phone_code_19, u0_.newsletter AS newsletter_20, c1_.is_mobile AS is_mobile_21, o3_.is_mobile AS is_mobile_22, t4_.birth_date AS birth_date_23, t4_.country AS country_24, a5_.has_already_logged_in AS has_already_logged_in_25, a5_.need_review AS need_review_26, a5_.is_editor AS is_editor_27, COUNT(c6_.owner_id) AS sclr_28, u0_.type AS type_29, u0_.address_id AS address_id_30, u0_.pro_info_id AS pro_info_id_31, u0_.stripe_info_id AS stripe_info_id_32 FROM user u0_ LEFT JOIN coach c1_ ON u0_.id = c1_.id LEFT JOIN club c2_ ON u0_.id = c2_.id LEFT JOIN operator o3_ ON u0_.id = o3_.id LEFT JOIN trainee t4_ ON u0_.id = t4_.id LEFT JOIN admin a5_ ON u0_.id = a5_.id INNER JOIN pro_info p7_ ON u0_.pro_info_id = p7_.id LEFT JOIN course c6_ ON u0_.id = c6_.owner_id WHERE u0_.activated = 1 AND u0_.is_pro = 1 AND u0_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 AND u0_.type IN ('club') AND p7_.page_visible = 1 GROUP BY u0_.id, u0_.firstname, u0_.lastname, u0_.telephone, u0_.email, u0_.password, u0_.activated, u0_.notification, u0_.registered_at, u0_.token, u0_.photo, u0_.slug, u0_.is_pro, u0_.has_access, u0_.status, u0_.has_accepted_terms, u0_.is_ambassador, u0_.language, u0_.timezone, u0_.phone_code, u0_.newsletter, u0_.address_id, u0_.pro_info_id, u0_.stripe_info_id ORDER BY sclr_28 DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.swimmingpool AS swimmingpool_3,
  t0.gym AS gym_4,
  t0.restaurant AS restaurant_5,
  t0.bar AS bar_6,
  t0.seminar_room AS seminar_room_7,
  t0.insurance AS insurance_8,
  t0.description AS description_9,
  t0.created_at AS created_at_10,
  t0.image AS image_11,
  t0.owner_id AS owner_id_12,
  t0.address_id AS address_id_13,
  t0.created_by_coach_id AS created_by_coach_id_14,
  t0.created_by_operator_id AS created_by_operator_id_15
FROM
  club_info t0
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.swimmingpool AS swimmingpool_3, t0.gym AS gym_4, t0.restaurant AS restaurant_5, t0.bar AS bar_6, t0.seminar_room AS seminar_room_7, t0.insurance AS insurance_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.owner_id AS owner_id_12, t0.address_id AS address_id_13, t0.created_by_coach_id AS created_by_coach_id_14, t0.created_by_operator_id AS created_by_operator_id_15 FROM club_info t0 WHERE t0.owner_id = 209;

SELECT
  t0.id AS id_1,
  t0.cover_photo AS cover_photo_2,
  t0.fullname AS fullname_3,
  t0.website AS website_4,
  t0.facebook AS facebook_5,
  t0.twitter AS twitter_6,
  t0.instagram AS instagram_7,
  t0.linkedin AS linkedin_8,
  t0.youtube AS youtube_9,
  t0.use_stripe AS use_stripe_10,
  t0.have_subscription AS have_subscription_11,
  t0.page_visible AS page_visible_12,
  t0.is_hidden AS is_hidden_13,
  t0.twitch AS twitch_14,
  t0.tiktok AS tiktok_15,
  t0.auto_renew AS auto_renew_16,
  t0.contact_email AS contact_email_17,
  t0.is_free_subscription AS is_free_subscription_18,
  t0.have_payment_issue AS have_payment_issue_19,
  t0.payment_deadline AS payment_deadline_20
FROM
  pro_info t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cover_photo AS cover_photo_2, t0.fullname AS fullname_3, t0.website AS website_4, t0.facebook AS facebook_5, t0.twitter AS twitter_6, t0.instagram AS instagram_7, t0.linkedin AS linkedin_8, t0.youtube AS youtube_9, t0.use_stripe AS use_stripe_10, t0.have_subscription AS have_subscription_11, t0.page_visible AS page_visible_12, t0.is_hidden AS is_hidden_13, t0.twitch AS twitch_14, t0.tiktok AS tiktok_15, t0.auto_renew AS auto_renew_16, t0.contact_email AS contact_email_17, t0.is_free_subscription AS is_free_subscription_18, t0.have_payment_issue AS have_payment_issue_19, t0.payment_deadline AS payment_deadline_20 FROM pro_info t0 WHERE t0.id = 162;

SELECT
  t0.id AS id_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.telephone AS telephone_9,
  t0.email AS email_10,
  t0.password AS password_11,
  t0.activated AS activated_12,
  t0.notification AS notification_13,
  t0.registered_at AS registered_at_14,
  t0.token AS token_15,
  t0.photo AS photo_16,
  t0.slug AS slug_17,
  t0.is_pro AS is_pro_18,
  t0.has_access AS has_access_19,
  t0.status AS status_20,
  t0.has_accepted_terms AS has_accepted_terms_21,
  t0.is_ambassador AS is_ambassador_22,
  t0.language AS language_23,
  t0.timezone AS timezone_24,
  t0.phone_code AS phone_code_25,
  t0.newsletter AS newsletter_26,
  t0.address_id AS address_id_27,
  t0.pro_info_id AS pro_info_id_28,
  t0.stripe_info_id AS stripe_info_id_29,
  t0.type,
  t1.is_mobile AS is_mobile_30,
  t3.is_mobile AS is_mobile_31,
  t4.birth_date AS birth_date_32,
  t4.country AS country_33,
  t5.has_already_logged_in AS has_already_logged_in_34,
  t5.need_review AS need_review_35,
  t5.is_editor AS is_editor_36
FROM
  user t0
  LEFT JOIN coach t1 ON t0.id = t1.id
  LEFT JOIN club t2 ON t0.id = t2.id
  LEFT JOIN operator t3 ON t0.id = t3.id
  LEFT JOIN trainee t4 ON t0.id = t4.id
  LEFT JOIN admin t5 ON t0.id = t5.id
WHERE
  t0.pro_info_id = ?

SELECT t0.id AS id_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.telephone AS telephone_9, t0.email AS email_10, t0.password AS password_11, t0.activated AS activated_12, t0.notification AS notification_13, t0.registered_at AS registered_at_14, t0.token AS token_15, t0.photo AS photo_16, t0.slug AS slug_17, t0.is_pro AS is_pro_18, t0.has_access AS has_access_19, t0.status AS status_20, t0.has_accepted_terms AS has_accepted_terms_21, t0.is_ambassador AS is_ambassador_22, t0.language AS language_23, t0.timezone AS timezone_24, t0.phone_code AS phone_code_25, t0.newsletter AS newsletter_26, t0.address_id AS address_id_27, t0.pro_info_id AS pro_info_id_28, t0.stripe_info_id AS stripe_info_id_29, t0.type, t1.is_mobile AS is_mobile_30, t3.is_mobile AS is_mobile_31, t4.birth_date AS birth_date_32, t4.country AS country_33, t5.has_already_logged_in AS has_already_logged_in_34, t5.need_review AS need_review_35, t5.is_editor AS is_editor_36 FROM user t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN club t2 ON t0.id = t2.id LEFT JOIN operator t3 ON t0.id = t3.id LEFT JOIN trainee t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.pro_info_id = 162;

SELECT
  n0_.id AS id_0,
  n0_.organization AS organization_1,
  n0_.education AS education_2,
  n0_.comment AS comment_3,
  n0_.created_at AS created_at_4,
  n0_.response AS response_5,
  n0_.replied_at AS replied_at_6,
  n0_.last_reminder AS last_reminder_7,
  n0_.booking_id AS booking_id_8,
  n0_.pro_id AS pro_id_9,
  n0_.course_id AS course_id_10,
  n0_.trainee_id AS trainee_id_11,
  n0_.note_request_id AS note_request_id_12
FROM
  note n0_
WHERE
  n0_.pro_id = ?
  OR EXISTS (
    SELECT
      1
    FROM
      note_user n1_
    WHERE
      n1_.note_id = n0_.id
      AND n1_.user_id IN (?)
  )
ORDER BY
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.organization AS organization_1, n0_.education AS education_2, n0_.comment AS comment_3, n0_.created_at AS created_at_4, n0_.response AS response_5, n0_.replied_at AS replied_at_6, n0_.last_reminder AS last_reminder_7, n0_.booking_id AS booking_id_8, n0_.pro_id AS pro_id_9, n0_.course_id AS course_id_10, n0_.trainee_id AS trainee_id_11, n0_.note_request_id AS note_request_id_12 FROM note n0_ WHERE n0_.pro_id = 162 OR EXISTS (SELECT 1 FROM note_user n1_ WHERE n1_.note_id = n0_.id AND n1_.user_id IN (209)) ORDER BY n0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.longitude AS longitude_3,
  t0.latitude AS latitude_4,
  t0.country_code AS country_code_5,
  t0.full_address AS full_address_6,
  t0.place_id AS place_id_7,
  t8.id AS id_9,
  t8.logistic AS logistic_10,
  t8.frequency AS frequency_11,
  t8.status AS status_12,
  t8.created_at AS created_at_13,
  t8.token AS token_14,
  t8.country_code AS country_code_15,
  t8.latitude AS latitude_16,
  t8.longitude AS longitude_17,
  t8.hide_club_info AS hide_club_info_18,
  t8.hide_coach_info AS hide_coach_info_19,
  t8.step_saved AS step_saved_20,
  t8.sended_alert AS sended_alert_21,
  t8.cover AS cover_22,
  t8.visible_to_club AS visible_to_club_23,
  t8.visible_to_coach AS visible_to_coach_24,
  t8.visible_to_operator AS visible_to_operator_25,
  t8.published_at AS published_at_26,
  t8.updated_at AS updated_at_27,
  t8.club_id AS club_id_28,
  t8.address_id AS address_id_29,
  t8.owner_id AS owner_id_30,
  t8.operator_id AS operator_id_31,
  t0.pro_id AS pro_id_32
FROM
  address t0
  LEFT JOIN course t8 ON t8.address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.city AS city_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.country_code AS country_code_5, t0.full_address AS full_address_6, t0.place_id AS place_id_7, t8.id AS id_9, t8.logistic AS logistic_10, t8.frequency AS frequency_11, t8.status AS status_12, t8.created_at AS created_at_13, t8.token AS token_14, t8.country_code AS country_code_15, t8.latitude AS latitude_16, t8.longitude AS longitude_17, t8.hide_club_info AS hide_club_info_18, t8.hide_coach_info AS hide_coach_info_19, t8.step_saved AS step_saved_20, t8.sended_alert AS sended_alert_21, t8.cover AS cover_22, t8.visible_to_club AS visible_to_club_23, t8.visible_to_coach AS visible_to_coach_24, t8.visible_to_operator AS visible_to_operator_25, t8.published_at AS published_at_26, t8.updated_at AS updated_at_27, t8.club_id AS club_id_28, t8.address_id AS address_id_29, t8.owner_id AS owner_id_30, t8.operator_id AS operator_id_31, t0.pro_id AS pro_id_32 FROM address t0 LEFT JOIN course t8 ON t8.address_id = t0.id WHERE t0.id = 686;

SELECT
  t0.id AS id_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.telephone AS telephone_9,
  t0.email AS email_10,
  t0.password AS password_11,
  t0.activated AS activated_12,
  t0.notification AS notification_13,
  t0.registered_at AS registered_at_14,
  t0.token AS token_15,
  t0.photo AS photo_16,
  t0.slug AS slug_17,
  t0.is_pro AS is_pro_18,
  t0.has_access AS has_access_19,
  t0.status AS status_20,
  t0.has_accepted_terms AS has_accepted_terms_21,
  t0.is_ambassador AS is_ambassador_22,
  t0.language AS language_23,
  t0.timezone AS timezone_24,
  t0.phone_code AS phone_code_25,
  t0.newsletter AS newsletter_26,
  t0.address_id AS address_id_27,
  t0.pro_info_id AS pro_info_id_28,
  t0.stripe_info_id AS stripe_info_id_29,
  t0.type,
  t1.is_mobile AS is_mobile_30,
  t3.is_mobile AS is_mobile_31,
  t4.birth_date AS birth_date_32,
  t4.country AS country_33,
  t5.has_already_logged_in AS has_already_logged_in_34,
  t5.need_review AS need_review_35,
  t5.is_editor AS is_editor_36
FROM
  user t0
  LEFT JOIN coach t1 ON t0.id = t1.id
  LEFT JOIN club t2 ON t0.id = t2.id
  LEFT JOIN operator t3 ON t0.id = t3.id
  LEFT JOIN trainee t4 ON t0.id = t4.id
  LEFT JOIN admin t5 ON t0.id = t5.id
WHERE
  t0.address_id = ?

SELECT t0.id AS id_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.telephone AS telephone_9, t0.email AS email_10, t0.password AS password_11, t0.activated AS activated_12, t0.notification AS notification_13, t0.registered_at AS registered_at_14, t0.token AS token_15, t0.photo AS photo_16, t0.slug AS slug_17, t0.is_pro AS is_pro_18, t0.has_access AS has_access_19, t0.status AS status_20, t0.has_accepted_terms AS has_accepted_terms_21, t0.is_ambassador AS is_ambassador_22, t0.language AS language_23, t0.timezone AS timezone_24, t0.phone_code AS phone_code_25, t0.newsletter AS newsletter_26, t0.address_id AS address_id_27, t0.pro_info_id AS pro_info_id_28, t0.stripe_info_id AS stripe_info_id_29, t0.type, t1.is_mobile AS is_mobile_30, t3.is_mobile AS is_mobile_31, t4.birth_date AS birth_date_32, t4.country AS country_33, t5.has_already_logged_in AS has_already_logged_in_34, t5.need_review AS need_review_35, t5.is_editor AS is_editor_36 FROM user t0 LEFT JOIN coach t1 ON t0.id = t1.id LEFT JOIN club t2 ON t0.id = t2.id LEFT JOIN operator t3 ON t0.id = t3.id LEFT JOIN trainee t4 ON t0.id = t4.id LEFT JOIN admin t5 ON t0.id = t5.id WHERE t0.address_id = 686;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  language t0
  INNER JOIN user_language ON t0.id = user_language.language_id
WHERE
  user_language.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM language t0 INNER JOIN user_language ON t0.id = user_language.language_id WHERE user_language.user_id = 209;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  course c0_
WHERE
  c0_.status = ?
  AND c0_.owner_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM course c0_ WHERE c0_.status = 'active' AND c0_.owner_id = 209;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  course c0_
WHERE
  c0_.status = ?
  AND c0_.owner_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM course c0_ WHERE c0_.status = 'active' AND c0_.owner_id = 209;