Query Metrics
4
Database Queries
4
Different statements
7.87 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.85 ms (36.21%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM geo_continents t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"NA"
]
|
2.26 ms (28.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.media AS media_5, t0.url AS url_6, t0.frequence AS frequence_7, t0.slug AS slug_8, t0.pays_id AS pays_id_9 FROM station t0
Parameters:
[] |
2.08 ms (26.39%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.image AS image_3, s0_.media AS media_4, s0_.url AS url_5, s0_.frequence AS frequence_6, s0_.slug AS slug_7, s0_.pays_id AS pays_id_8 FROM station s0_ INNER JOIN geo_countries g1_ ON s0_.pays_id = g1_.id WHERE g1_.cca2 = ?
Parameters:
[
"US"
]
|
0.68 ms (8.69%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.cca2 AS cca2_3, t0.cca3 AS cca3_4, t0.ccn3 AS ccn3_5, t0.sub_continent_id AS sub_continent_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.slug AS slug_9, t0.continent_id AS continent_id_10 FROM geo_countries t0 WHERE t0.continent_id = ?
Parameters:
[
1
]
|
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\Station | No errors. |
App\Entity\GeoContinents | No errors. |
App\Entity\GeoCountries | No errors. |