Query Metrics
4
Database Queries
4
Different statements
1.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.37 ms (31.43%) |
1 |
SELECT s.id, s.nom, s.adresse, s.code_postal, s.telephone, s.email, s.departement_id, s.region_id, IF(s.latitude IS NOT NULL, CONCAT(s.latitude,',',s.longitude), CONCAT(c.latitude,',',c.longitude) ) as coordinate, c.nom as commune FROM Structure s LEFT JOIN Commune c ON s.commune_implementation_id=c.id WHERE s.is_actif=1 AND s.is_delete!=1 AND s.type_structure_id = 4 AND s.type_structure_id IN(0)
Parameters:
[] |
|
0.28 ms (23.86%) |
1 |
SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.num AS num_2, d0_.region_id AS region_id_3 FROM Departement d0_ ORDER BY d0_.nom ASC
Parameters:
[] |
|
0.27 ms (22.79%) |
1 |
SELECT s.id, s.nom, s.adresse, s.code_postal, s.telephone, s.email, s.departement_id, s.region_id, IF(s.latitude IS NOT NULL, CONCAT(s.latitude,',',s.longitude), CONCAT(c.latitude,',',c.longitude) ) as coordinate, c.nom as commune FROM Structure s LEFT JOIN Commune c ON s.commune_implementation_id=c.id WHERE s.is_actif=1 AND s.is_delete!=1 AND s.type_structure_id = 2 AND s.type_structure_id IN(0)
Parameters:
[] |
|
0.26 ms (21.92%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.grandeRegion_id AS grandeRegion_id_3 FROM Region 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\Departement | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\FiltreStructure | No errors. |
| App\Entity\GrandeRegion | No errors. |
| App\Entity\User | No errors. |