Query Metrics
4
Database Queries
4
Different statements
14,06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4,62 ms (32,89%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_region_production t0_
Parameters:
[] |
|
3,30 ms (23,49%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_site_activity t0_
Parameters:
[] |
|
3,25 ms (23,10%) |
1 |
SELECT t0_.id AS id_0, t0_.isActive AS isActive_1, t0_.reference AS reference_2, t0_.reference AS reference_3, t0_.name AS name_4, t0_.zipCode AS zipCode_5, t1_.id AS id_6, t2_.id AS id_7, t3_.id AS id_8 FROM tbl_site t0_ LEFT JOIN tbl_site_typology t1_ ON t0_.typology_id = t1_.id LEFT JOIN tbl_site_activity t3_ ON t0_.activity_id = t3_.id LEFT JOIN tbl_region_production t2_ ON t0_.region_id = t2_.id
Parameters:
[] |
|
2,88 ms (20,51%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_site_typology t0_
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Region\RegionProduction | No errors. |
| App\Entity\Site\SiteTypology | No errors. |
| App\Entity\Site\SiteActivity | No errors. |
| App\Entity\Site\Site | No errors. |