Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.hastus AS hastus_2,
  t0.stop_id AS stop_id_3,
  t0.routes AS routes_4
FROM
  stop_route t0
WHERE
  t0.hastus = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.hastus AS hastus_2, t0.stop_id AS stop_id_3, t0.routes AS routes_4 FROM stop_route t0 WHERE t0.hastus = '11NOVE_1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.route_id AS route_id_2,
  t0.route_short_name AS route_short_name_3,
  t0.route_long_name AS route_long_name_4,
  t0.route_desc AS route_desc_5,
  t0.route_type AS route_type_6,
  t0.route_url AS route_url_7,
  t0.route_color AS route_color_8,
  t0.route_text_color AS route_text_color_9,
  t0.route_sort_order AS route_sort_order_10
FROM
  routes_scolaris t0
WHERE
  t0.route_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_id AS route_id_2, t0.route_short_name AS route_short_name_3, t0.route_long_name AS route_long_name_4, t0.route_desc AS route_desc_5, t0.route_type AS route_type_6, t0.route_url AS route_url_7, t0.route_color AS route_color_8, t0.route_text_color AS route_text_color_9, t0.route_sort_order AS route_sort_order_10 FROM routes_scolaris t0 WHERE t0.route_id = 'Ligne_100' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.route_id AS route_id_2,
  t0.ligne_name AS ligne_name_3,
  t0.couleur AS couleur_4,
  t0.etablissement AS etablissement_5
FROM
  ligne_scolaris t0

SELECT t0.id AS id_1, t0.route_id AS route_id_2, t0.ligne_name AS ligne_name_3, t0.couleur AS couleur_4, t0.etablissement AS etablissement_5 FROM ligne_scolaris t0;

SELECT
  stop_times.stop_id,
  COUNT(trips.id) AS count
FROM
  trips
  INNER JOIN stop_times ON trips.trip_id = stop_times.trip_id
WHERE
  trips.trip_id IS NOT NULL
  AND service_id = :serviceId
  AND departure_time >= :current_date
  AND departure_time <= :date_max
GROUP BY
  trips.service_id,
  stop_times.stop_id

SELECT stop_times.stop_id, COUNT(trips.id)AS count 
        FROM trips
        INNER JOIN stop_times ON trips.trip_id=stop_times.trip_id
        WHERE trips.trip_id IS NOT NULL AND service_id= '25_DIM-M25DIM-7-jours-05' AND departure_time >= '00:54:11' AND departure_time <= '01:54:11' GROUP BY trips.service_id, stop_times.stop_id;

SELECT
  t0.id AS id_1,
  t0.stop_id AS stop_id_2,
  t0.stop_code AS stop_code_3,
  t0.stop_name AS stop_name_4,
  t0.stop_desc AS stop_desc_5,
  t0.stop_lat AS stop_lat_6,
  t0.stop_lon AS stop_lon_7,
  t0.zone_id AS zone_id_8,
  t0.stop_url AS stop_url_9,
  t0.location_type AS location_type_10,
  t0.parent_station AS parent_station_11,
  t0.wheelchair_boarding AS wheelchair_boarding_12,
  t0.stop_timezone AS stop_timezone_13,
  t0.hastus AS hastus_14
FROM
  stops t0

SELECT t0.id AS id_1, t0.stop_id AS stop_id_2, t0.stop_code AS stop_code_3, t0.stop_name AS stop_name_4, t0.stop_desc AS stop_desc_5, t0.stop_lat AS stop_lat_6, t0.stop_lon AS stop_lon_7, t0.zone_id AS zone_id_8, t0.stop_url AS stop_url_9, t0.location_type AS location_type_10, t0.parent_station AS parent_station_11, t0.wheelchair_boarding AS wheelchair_boarding_12, t0.stop_timezone AS stop_timezone_13, t0.hastus AS hastus_14 FROM stops t0;

SELECT
  t0.id AS id_1,
  t0.service_id AS service_id_2,
  t0.date AS date_3,
  t0.exception_type AS exception_type_4
FROM
  calendar_dates t0
WHERE
  t0.service_id = ?
  AND t0.date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.service_id AS service_id_2, t0.date AS date_3, t0.exception_type AS exception_type_4 FROM calendar_dates t0 WHERE t0.service_id = '25_DIM-M25DIM-7-jours-05' AND t0.date = '2026-02-08' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.meta AS meta_2,
  t0.value AS value_3
FROM
  parametre t0
WHERE
  t0.meta = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.meta AS meta_2, t0.value AS value_3 FROM parametre t0 WHERE t0.meta = 'alerte_perte_api' LIMIT 1;

SELECT
  service_id
FROM
  calendar
WHERE
  sunday = 1
  AND start_date <= :dateJour
  AND end_start >= :dateJour

SELECT service_id FROM calendar WHERE sunday=1 AND start_date<= '2026-02-08' AND end_start>= '2026-02-08';

SELECT
  t0.id AS id_1,
  t0.ville AS ville_2,
  t0.code_postal AS code_postal_3,
  t0.adresse AS adresse_4,
  t0.enseigne AS enseigne_5,
  t0.horaires AS horaires_6,
  t0.type AS type_7,
  t0.coordonnees AS coordonnees_8,
  t0.picto AS picto_9
FROM
  point_de_vente t0
ORDER BY
  t0.enseigne ASC

SELECT t0.id AS id_1, t0.ville AS ville_2, t0.code_postal AS code_postal_3, t0.adresse AS adresse_4, t0.enseigne AS enseigne_5, t0.horaires AS horaires_6, t0.type AS type_7, t0.coordonnees AS coordonnees_8, t0.picto AS picto_9 FROM point_de_vente t0 ORDER BY t0.enseigne ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3
FROM
  image t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM image t0;

SELECT
  MIN(r0_.route_short_name) AS sclr_0,
  MIN(r0_.route_color) AS sclr_1,
  MIN(r0_.route_text_color) AS sclr_2
FROM
  routes r0_
GROUP BY
  r0_.route_short_name

SELECT MIN(r0_.route_short_name) AS sclr_0, MIN(r0_.route_color) AS sclr_1, MIN(r0_.route_text_color) AS sclr_2 FROM routes r0_ GROUP BY r0_.route_short_name;

SELECT
  COUNT(frequencies.id) as count
FROM
  trips
  INNER JOIN frequencies ON trips.trip_id = frequencies.trip_id
WHERE
  trips.trip_id IS NOT NULL
  AND service_id = :serviceId
  AND frequencies.start_time <= :date_max
  AND frequencies.end_time >= :current_date

SELECT COUNT(frequencies.id) as count
        FROM trips
        INNER JOIN frequencies ON trips.trip_id=frequencies.trip_id
        WHERE trips.trip_id IS NOT NULL AND service_id = '25_DIM-M25DIM-7-jours-05'
         AND frequencies.start_time <= '01:54:11'
            AND frequencies.end_time >= '00:54:11';

SELECT
  t0.id AS id_1,
  t0.station_id AS station_id_2,
  t0.coordonnees AS coordonnees_3,
  t0.nom AS nom_4,
  t0.adresse AS adresse_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.emplacements AS emplacements_8,
  t0.picto AS picto_9
FROM
  idecycle t0

SELECT t0.id AS id_1, t0.station_id AS station_id_2, t0.coordonnees AS coordonnees_3, t0.nom AS nom_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.emplacements AS emplacements_8, t0.picto AS picto_9 FROM idecycle t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.coordonnees AS coordonnees_3,
  t0.ville AS ville_4,
  t0.adresse AS adresse_5,
  t0.hotaires AS hotaires_6,
  t0.places AS places_7,
  t0.places_pmr AS places_pmr_8,
  t0.picto AS picto_9
FROM
  parking_relais t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.coordonnees AS coordonnees_3, t0.ville AS ville_4, t0.adresse AS adresse_5, t0.hotaires AS hotaires_6, t0.places AS places_7, t0.places_pmr AS places_pmr_8, t0.picto AS picto_9 FROM parking_relais t0;