Symfony Profiler

SELECT
  sA.name AS stop_name_dep,
  sA.id AS stop_id_dep,
  sB.name AS stop_name_arr,
  sB.id AS stop_id_arr
FROM
  (
    SELECT
      DISTINCT stop_id_dep,
      stop_id_arr
    FROM
      route
    WHERE
      company_id IN (?)
  ) r
  JOIN stop sA ON r.stop_id_dep = sA.id
  JOIN stop sB ON r.stop_id_arr = sB.id
WHERE
  sA.country = ?
  and sB.country = ?

SELECT
                    sA.name AS stop_name_dep,
                    sA.id AS stop_id_dep,
                    sB.name AS stop_name_arr,
                    sB.id AS stop_id_arr
               FROM (
                   SELECT DISTINCT stop_id_dep, stop_id_arr
                   FROM route
                   WHERE company_id IN (1, 2, 3, 9, 13, 19)
               ) r
               JOIN stop sA ON r.stop_id_dep = sA.id
               JOIN stop sB ON r.stop_id_arr = sB.id
               WHERE sA.country = 'fr' and sB.country = 'fr'
               ;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.lat AS lat_4,
  t0.lon AS lon_5,
  t0.geoname_id AS geoname_id_6,
  t0.population AS population_7,
  t8.id AS id_9,
  t8.population AS population_10,
  t8.stop_id AS stop_id_11
FROM
  stop t0
  LEFT JOIN stop_info t8 ON t8.stop_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.lat AS lat_4, t0.lon AS lon_5, t0.geoname_id AS geoname_id_6, t0.population AS population_7, t8.id AS id_9, t8.population AS population_10, t8.stop_id AS stop_id_11 FROM stop t0 LEFT JOIN stop_info t8 ON t8.stop_id = t0.id WHERE t0.id = '10';