Symfony Profiler

SELECT
  DISTINCT 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
  route r
  JOIN stop sA ON r.stop_id_dep = sA.id
  and sA.country = 'fr'
  JOIN stop sB ON r.stop_id_arr = sB.id
  and sB.country = 'fr'
WHERE
  stop_id_dep = :depStopId
  AND company_id IN (:companies)

SELECT DISTINCT
              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 route r
              JOIN stop sA ON r.stop_id_dep = sA.id and sA.country = 'fr'
              JOIN stop sB ON r.stop_id_arr = sB.id and sB.country = 'fr'
            WHERE stop_id_dep = 10 AND company_id IN (1, 2, 3, 6, 13, 14, 15, 18, 19, 21, 22, 23, 25, 28, 29, 31, 32, 33, 34, 35, 36, 38, 39, 40, 41, 42, 43, 44, 49, 51, 52, 53, 54, 56, 57, 59, 60, 61, 62, 63, 64, 66, 67, 70, 71, 72, 74, 75, 76, 77, 78, 79, 82, 86, 89, 91, 94, 95, 96, 98, 99, 100, 102, 103, 104, 105, 107, 109, 110, 111, 112, 113, 115, 117, 119, 121, 123, 124, 125, 126, 127, 128, 129, 130, 132, 133, 134, 135, 138, 139, 140, 141, 142, 143, 144, 145, 147, 148, 149, 150, 151, 152, 153, 155, 156, 157, 159, 160, 162, 163, 164, 165, 166, 169, 170, 171, 172, 173, 174, 176, 177, 178, 179, 180, 181, 182, 184, 185, 187, 192, 194, 195, 999);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lang AS lang_3,
  t0.stop_id AS stop_id_4
FROM
  stop_lang t0
WHERE
  t0.stop_id = ?
  AND t0.lang = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.lang AS lang_3, t0.stop_id AS stop_id_4 FROM stop_lang t0 WHERE t0.stop_id = 10 AND t0.lang = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.content AS content_3,
  t0.meta AS meta_4
FROM
  block t0
WHERE
  t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.content AS content_3, t0.meta AS meta_4 FROM block t0 WHERE t0.path = '/fr/bus-o-d-10-359' LIMIT 1;

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;

SELECT
  p0_.carrier_name AS carrier_name_0,
  count(p0_.carrier_name) AS sclr_1
FROM
  price p0_
WHERE
  p0_.stop_id_dep = ?
  AND p0_.stop_id_arr = ?
  AND p0_.type = ?
  AND p0_.carrier_name IS NOT NULL
GROUP BY
  p0_.carrier_name
ORDER BY
  sclr_1 DESC
LIMIT
  10

SELECT p0_.carrier_name AS carrier_name_0, count(p0_.carrier_name) AS sclr_1 FROM price p0_ WHERE p0_.stop_id_dep = 10 AND p0_.stop_id_arr = 359 AND p0_.type = 0 AND p0_.carrier_name IS NOT NULL GROUP BY p0_.carrier_name ORDER BY sclr_1 DESC LIMIT 10;

select
  p.*
from
  price p
where
  stop_id_dep = :dep
  and stop_id_arr = :arr
  and type = :type
  and cents > 0
  and currency is not null
order by
  id desc
limit
  15

select p.*
                from price p
                where stop_id_dep = 10
                and stop_id_arr = 359
                and type = 0
                and cents > 0
                and currency is not null
                order by id desc
                limit 15;

select
  avg(duration) as avg_dur,
  min(duration) as min_dur,
  max(duration) as max_dur,
  avg(cents) as avg_cents,
  min(cents) as min_cents,
  max(cents) as max_cents
FROM
  (
    select
      duration,
      (
        CASE WHEN currency = 'EUR' THEN cents * :EUR END
      ) as cents
    from
      price p
    where
      stop_id_dep = :dep
      and stop_id_arr = :arr
      and duration is not null
      and type = :type
      and dep_datetime > NOW()
      and created_at > NOW() - INTERVAL :daysold DAY
      and currency is not null
      and currency in (:currencies)
      and cents > 0
  ) t;

select
                  avg(duration) as avg_dur,
                  min(duration) as min_dur,
                  max(duration) as max_dur,
                  avg(cents) as avg_cents,
                  min(cents) as min_cents,
                  max(cents) as max_cents
                FROM (
                  select
                    duration,
                    (
                      CASE
                      
WHEN currency = 'EUR' THEN cents * 1
                      END
                    ) as cents
                  from price p
                  where stop_id_dep = 10
                  and stop_id_arr = 359
                  and duration is not null
                  and type = 0
                  and dep_datetime > NOW()
                  and created_at > NOW() - INTERVAL 7 DAY
                  and currency is not null
                  and currency in ('EUR')
                  and cents > 0
                  
                ) t;;

SELECT
  DISTINCT p0_.currency AS currency_0
FROM
  price p0_
WHERE
  p0_.stop_id_dep = ?
  AND p0_.stop_id_arr = ?
  AND p0_.type = ?
  AND p0_.created_at > ?
  AND p0_.currency IS NOT NULL
  AND p0_.currency <> ''
  AND p0_.cents > 0

SELECT DISTINCT p0_.currency AS currency_0 FROM price p0_ WHERE p0_.stop_id_dep = 10 AND p0_.stop_id_arr = 359 AND p0_.type = 0 AND p0_.created_at > '2025-03-29 04:13:01' AND p0_.currency IS NOT NULL AND p0_.currency <> '' AND p0_.cents > 0;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.author AS author_3,
  t0.flickr_id AS flickr_id_4,
  t0.stop_id AS stop_id_5
FROM
  picture_stop t0
WHERE
  t0.stop_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.author AS author_3, t0.flickr_id AS flickr_id_4, t0.stop_id AS stop_id_5 FROM picture_stop t0 WHERE t0.stop_id = '359';