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,
  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 ('operator')
  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 ('operator') 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
  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_;