GET https://swimviz.com/city/index

Query Metrics

2 Database Queries
2 Different statements
0.72 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_ffn AS name_ffn_2, c0_.country_id AS country_id_3 FROM city c0_ LEFT JOIN country c1_ ON c0_.country_id = c1_.id ORDER BY c0_.name ASC
Parameters:
[]
2 0.12 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.id AS id_2, c1_.name AS name_3, COUNT(c2_.id) AS sclr_4 FROM competition c2_ INNER JOIN competition_type c0_ ON c2_.competition_type_id = c0_.id INNER JOIN competition_discipline c1_ ON c2_.competition_discipline_id = c1_.id GROUP BY c0_.id, c0_.name, c1_.id, c1_.name ORDER BY c1_.id ASC, c0_.id ASC
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping