Symfony Profiler

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
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  age a0_

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM age a0_;

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

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

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
  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 = ?
  AND s0_.id IN (?)
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' AND s0_.id IN ('4') ORDER BY s0_.appearance ASC;

SELECT
  c0_.id AS id_0,
  c0_.logistic AS logistic_1,
  c0_.frequency AS frequency_2,
  c0_.status AS status_3,
  c0_.created_at AS created_at_4,
  c0_.token AS token_5,
  c0_.country_code AS country_code_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.hide_club_info AS hide_club_info_9,
  c0_.hide_coach_info AS hide_coach_info_10,
  c0_.step_saved AS step_saved_11,
  c0_.sended_alert AS sended_alert_12,
  c0_.cover AS cover_13,
  c0_.visible_to_club AS visible_to_club_14,
  c0_.visible_to_coach AS visible_to_coach_15,
  c0_.visible_to_operator AS visible_to_operator_16,
  c0_.published_at AS published_at_17,
  c0_.updated_at AS updated_at_18,
  c0_.club_id AS club_id_19,
  c0_.address_id AS address_id_20,
  c0_.owner_id AS owner_id_21,
  c0_.operator_id AS operator_id_22
FROM
  course c0_
  INNER JOIN user u1_ ON c0_.owner_id = u1_.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
  INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id
  INNER JOIN course_sport c9_ ON c0_.id = c9_.course_id
  INNER JOIN sport s8_ ON s8_.id = c9_.sport_id
WHERE
  c0_.status LIKE 'active'
  AND u1_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND s8_.id IN (?)
  AND p7_.is_hidden = ?

SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ INNER JOIN user u1_ ON c0_.owner_id = u1_.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 INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id INNER JOIN course_sport c9_ ON c0_.id = c9_.course_id INNER JOIN sport s8_ ON s8_.id = c9_.sport_id WHERE c0_.status LIKE 'active' AND u1_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 AND s8_.id IN (4) AND p7_.is_hidden = 0;

SELECT
  c0_.id AS id_0,
  c0_.logistic AS logistic_1,
  c0_.frequency AS frequency_2,
  c0_.status AS status_3,
  c0_.created_at AS created_at_4,
  c0_.token AS token_5,
  c0_.country_code AS country_code_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.hide_club_info AS hide_club_info_9,
  c0_.hide_coach_info AS hide_coach_info_10,
  c0_.step_saved AS step_saved_11,
  c0_.sended_alert AS sended_alert_12,
  c0_.cover AS cover_13,
  c0_.visible_to_club AS visible_to_club_14,
  c0_.visible_to_coach AS visible_to_coach_15,
  c0_.visible_to_operator AS visible_to_operator_16,
  c0_.published_at AS published_at_17,
  c0_.updated_at AS updated_at_18,
  c0_.club_id AS club_id_19,
  c0_.address_id AS address_id_20,
  c0_.owner_id AS owner_id_21,
  c0_.operator_id AS operator_id_22
FROM
  course c0_
  INNER JOIN user u1_ ON c0_.owner_id = u1_.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
  INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id
  INNER JOIN featured_course f8_ ON c0_.id = f8_.course_id
  INNER JOIN featured_offer f9_ ON f8_.featured_offer_id = f9_.id
WHERE
  c0_.status LIKE 'active'
  AND u1_.status = ?
  AND p7_.have_subscription = ?
  AND p7_.is_hidden = ?
  AND f9_.type = ?
  AND f8_.status = ?
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ INNER JOIN user u1_ ON c0_.owner_id = u1_.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 INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id INNER JOIN featured_course f8_ ON c0_.id = f8_.course_id INNER JOIN featured_offer f9_ ON f8_.featured_offer_id = f9_.id WHERE c0_.status LIKE 'active' AND u1_.status = 'online' AND p7_.have_subscription = 1 AND p7_.is_hidden = 0 AND f9_.type = 'research' AND f8_.status = 'active' ORDER BY c0_.created_at DESC;