http://test-www.comparabus.it/sitemap.xml

Query Metrics

3 Database Queries
2 Different statements
2591.99 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2586.11 ms
(99.77%)
1
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 = ?
Parameters:
[
  [
    1
    2
    3
    9
    13
    19
  ]
  "fr"
  "fr"
]
5.88 ms
(0.23%)
2
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 = ?
Parameters:
[
  "10"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Stop No errors.
App\Entity\Block No errors.
App\Entity\Route No errors.
App\Entity\model\RouteSeo No errors.
App\Entity\StopInfo No errors.
App\Entity\PictureStop No errors.
App\Entity\StopLang No errors.
App\Entity\StopAlias No errors.