Symfony Profiler

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,
  t4_.show_phone AS show_phone_25,
  t4_.show_email AS show_email_26,
  a5_.has_already_logged_in AS has_already_logged_in_27,
  a5_.need_review AS need_review_28,
  a5_.is_editor AS is_editor_29,
  COUNT(c6_.id) AS sclr_30,
  u0_.type AS type_31,
  u0_.address_id AS address_id_32,
  u0_.pro_info_id AS pro_info_id_33,
  u0_.stripe_info_id AS stripe_info_id_34
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
  AND (c6_.status = ?)
WHERE
  u0_.activated = ?
  AND u0_.is_pro = ?
  AND u0_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND p7_.page_visible = ?
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_30 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, t4_.show_phone AS show_phone_25, t4_.show_email AS show_email_26, a5_.has_already_logged_in AS has_already_logged_in_27, a5_.need_review AS need_review_28, a5_.is_editor AS is_editor_29, COUNT(c6_.id) AS sclr_30, u0_.type AS type_31, u0_.address_id AS address_id_32, u0_.pro_info_id AS pro_info_id_33, u0_.stripe_info_id AS stripe_info_id_34 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 AND (c6_.status = 'active') WHERE u0_.activated = 1 AND u0_.is_pro = 1 AND u0_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 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_30 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.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.image AS image_5,
  t0.owner_id AS owner_id_6,
  t0.address_id AS address_id_7,
  t0.created_by_club_id AS created_by_club_id_8,
  t0.created_by_operator_id AS created_by_operator_id_9
FROM
  coach_info t0
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.image AS image_5, t0.owner_id AS owner_id_6, t0.address_id AS address_id_7, t0.created_by_club_id AS created_by_club_id_8, t0.created_by_operator_id AS created_by_operator_id_9 FROM coach_info t0 WHERE t0.owner_id = 207;

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
  OR a0_.pro_id IS NOT NULL
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 OR a0_.pro_id IS NOT NULL GROUP BY a0_.country_code ORDER BY COUNT(a0_.country_code) DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.owner_id AS owner_id_4
FROM
  operator_info t0
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.owner_id AS owner_id_4 FROM operator_info t0 WHERE t0.owner_id = 211;

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_;