https://senacs.symfyp.fr/index.php/structure/map

Query Metrics

4 Database Queries
4 Different statements
1.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.