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
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.created_date AS created_date_3,
  a0_.slug AS slug_4,
  a0_.cover AS cover_5,
  a0_.views AS views_6,
  a0_.published AS published_7,
  a0_.status AS status_8,
  a0_.featured AS featured_9,
  a0_.featured_at AS featured_at_10,
  a0_.original AS original_11,
  a0_.unit AS unit_12,
  a0_.alt_cover AS alt_cover_13,
  a0_.title_seo AS title_seo_14,
  a0_.description_seo AS description_seo_15,
  a0_.published_at AS published_at_16,
  a0_.author_id AS author_id_17,
  a0_.reviewer_id AS reviewer_id_18,
  a0_.website_language_id AS website_language_id_19
FROM
  article a0_
  INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id
WHERE
  a0_.published = ?
  AND w1_.slug = ?
ORDER BY
  a0_.created_date DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.created_date AS created_date_3, a0_.slug AS slug_4, a0_.cover AS cover_5, a0_.views AS views_6, a0_.published AS published_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.featured_at AS featured_at_10, a0_.original AS original_11, a0_.unit AS unit_12, a0_.alt_cover AS alt_cover_13, a0_.title_seo AS title_seo_14, a0_.description_seo AS description_seo_15, a0_.published_at AS published_at_16, a0_.author_id AS author_id_17, a0_.reviewer_id AS reviewer_id_18, a0_.website_language_id AS website_language_id_19 FROM article a0_ INNER JOIN website_language w1_ ON a0_.website_language_id = w1_.id WHERE a0_.published = 1 AND w1_.slug = 'fr' ORDER BY a0_.created_date DESC LIMIT 4;

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1,
  h0_.description AS description_2,
  h0_.image AS image_3,
  h0_.link AS link_4,
  h0_.unit AS unit_5,
  h0_.original AS original_6,
  h0_.number AS number_7,
  h0_.website_language_id AS website_language_id_8
FROM
  home_slider h0_
  INNER JOIN website_language w1_ ON h0_.website_language_id = w1_.id
WHERE
  w1_.slug = ?
ORDER BY
  h0_.number + 0 ASC

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.image AS image_3, h0_.link AS link_4, h0_.unit AS unit_5, h0_.original AS original_6, h0_.number AS number_7, h0_.website_language_id AS website_language_id_8 FROM home_slider h0_ INNER JOIN website_language w1_ ON h0_.website_language_id = w1_.id WHERE w1_.slug = 'fr' ORDER BY h0_.number + 0 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 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
LIMIT
  12

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 = 'homepage' AND f8_.status = 'active' ORDER BY c0_.created_at DESC LIMIT 12;

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
WHERE
  u1_.status = ?
  AND p7_.is_hidden = ?
  AND p7_.have_subscription = ?
  AND c0_.status LIKE 'active'
ORDER BY
  c0_.created_at DESC
LIMIT
  12

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 WHERE u1_.status = 'online' AND p7_.is_hidden = 0 AND p7_.have_subscription = 1 AND c0_.status LIKE 'active' ORDER BY c0_.created_at DESC LIMIT 12;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.image AS image_2,
  m0_.original AS original_3,
  m0_.unit AS unit_4,
  m0_.link AS link_5,
  m0_.website_language_id AS website_language_id_6
FROM
  media m0_
  INNER JOIN website_language w1_ ON m0_.website_language_id = w1_.id
WHERE
  w1_.slug = ?

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.original AS original_3, m0_.unit AS unit_4, m0_.link AS link_5, m0_.website_language_id AS website_language_id_6 FROM media m0_ INNER JOIN website_language w1_ ON m0_.website_language_id = w1_.id WHERE w1_.slug = 'fr';

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.image AS image_2,
  m0_.original AS original_3,
  m0_.unit AS unit_4,
  m0_.link AS link_5,
  m0_.website_language_id AS website_language_id_6
FROM
  media m0_
  INNER JOIN website_language w1_ ON m0_.website_language_id = w1_.id
WHERE
  w1_.slug = ?

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.image AS image_2, m0_.original AS original_3, m0_.unit AS unit_4, m0_.link AS link_5, m0_.website_language_id AS website_language_id_6 FROM media m0_ INNER JOIN website_language w1_ ON m0_.website_language_id = w1_.id WHERE w1_.slug = 'en';