Symfony Profiler

SELECT
  c.idCourse,
  c.title,
  c.is_active,
  c.on_sale,
  c.image,
  c.city_default,
  c.country_default,
  cs.id_course,
  cs.course_date as courseDate,
  cs.price,
  cs.location
FROM
  course c
  JOIN course_session cs ON c.idCourse = cs.id_course
  JOIN category ca ON c.categorie_id = ca.idCategory
WHERE
  cs.course_date >= NOW()
  AND c.is_active = 1
  AND ca.name = 'intra'
  AND cs.enabled = 1
ORDER BY
  cs.course_date ASC

SELECT c.idCourse, c.title, c.is_active, c.on_sale, c.image, c.city_default, c.country_default, cs.id_course, cs.course_date as courseDate, cs.price, cs.location
                    FROM course c 
                    JOIN course_session cs ON c.idCourse = cs.id_course
                    JOIN category ca ON c.categorie_id = ca.idCategory
                    WHERE cs.course_date >= NOW()
                    AND c.is_active = 1
                    AND ca.name = 'intra' 
                    AND cs.enabled = 1
                    ORDER BY cs.course_date ASC;

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC,
  w1_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'acoa.fr' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'acoa' ORDER BY w0_.id ASC, w1_.id ASC;

SELECT
  DISTINCT(cs.location) as `location`
FROM
  course c
  JOIN course_session cs ON c.idCourse = cs.id_course
  LEFT JOIN category ca ON c.categorie_id = ca.idCategory
WHERE
  cs.course_date >= NOW()
  AND ca.name LIKE 'intra'
  AND c.is_active = 1
  and cs.is_active = 1
ORDER BY
  cs.location ASC

SELECT DISTINCT(cs.location) as `location`
                        FROM course c 
                        JOIN course_session cs ON c.idCourse = cs.id_course
                        LEFT JOIN category ca ON c.categorie_id = ca.idCategory
                        WHERE cs.course_date >= NOW()
                        AND ca.name LIKE 'intra'
                        AND c.is_active = 1
                        and cs.is_active = 1
                        ORDER BY cs.location ASC;

SELECT
  DISTINCT(cs.duration) as duration
FROM
  course c
  LEfT JOIN course_session cs ON c.idCourse = cs.id_course
  LEFT JOIN category ca ON c.categorie_id = ca.idCategory
WHERE
  cs.course_date >= NOW()
  AND ca.name LIKE 'intra'
  AND c.is_active = 1
  and cs.is_active = 1
ORDER BY
  cs.duration ASC

SELECT DISTINCT(cs.duration) as duration
                        FROM course c 
                        LEfT JOIN course_session cs ON c.idCourse = cs.id_course
                        LEFT JOIN category ca ON c.categorie_id = ca.idCategory
                        WHERE cs.course_date >= NOW()
                        AND ca.name LIKE 'intra'
                        AND c.is_active = 1
                        and cs.is_active = 1
                        ORDER BY cs.duration ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  competence t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM competence t0 ORDER BY t0.id ASC;