Query Metrics
5
Database Queries
5
Different statements
2.87 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.13 ms (39.31%) |
1 |
SELECT c.id AS construction_id, c.name AS construction_name, ct.id AS type_id, ct.name AS type_name, ce.id AS element_id, ce.code AS element_code, ce.name AS element_name, ce.count_requests AS count_requests FROM constructions c LEFT JOIN construction_types ct ON (ct.construction_id = c.id) LEFT JOIN construction_elements ce ON (ce.construction_type_id = ct.id ) WHERE construction_type_id IN ( SELECT ct.id FROM construction_types ct WHERE construction_id = 1 ) ORDER BY count_requests DESC LIMIT 2
Parameters:
[] |
0.55 ms (19.08%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.construction_id AS construction_id_3 FROM construction_types t0 WHERE t0.construction_id = ?
Parameters:
[
1
]
|
0.53 ms (18.55%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM constructions t0
Parameters:
[] |
0.35 ms (12.17%) |
1 |
SELECT c0_.id AS id_0 FROM constructions c0_
Parameters:
[] |
0.31 ms (10.88%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.construction_id AS construction_id_3 FROM construction_types t0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
user | doctrine.dbal.user_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
user | doctrine.orm.user_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
Mm\Beton\Planungsatlas\AtlasBundle\Entity\Main\Construction | No errors. |
Mm\Beton\Planungsatlas\AtlasBundle\Entity\Main\ConstructionType | No errors. |
Mm\Beton\Planungsatlas\AtlasBundle\Entity\Main\ConstructionElement | No errors. |
user entity manager
No loaded entities.