GET https://circulaire.developpe.net/

Response
200 OK
IP
57.131.131.18
Profiled on
Token
a1c64a

Query Metrics

20 Database Queries
7 Different statements
16.07 ms Query time
1 Invalid entities
106 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.03 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.capital AS capital_3, t0.code_iso AS code_iso_4 FROM district t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.25 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.60 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.51 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.44 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.41 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.36 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.50 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.38 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.37 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.38 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.44 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.42 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.28 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.45 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.cheflieu AS cheflieu_4, t0.superficie AS superficie_5, t0.population AS population_6, t0.nbredepartement AS nbredepartement_7, t0.presentation AS presentation_8, t0.message AS message_9, t0.dateadd AS dateadd_10, t0.district_id AS district_id_11, t0.user_id AS user_id_12 FROM region t0 WHERE t0.district_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
16 2.82 ms 
SELECT a.*, 
                   ta.libelle as type_acteur_libelle,
                   dp.region_id as region_id,
                   r.district_id as district_id
            FROM acteur a 
            LEFT JOIN type_acteur ta ON a.type_acteur_id = ta.id 
            LEFT JOIN departement dp ON a.departement_id = dp.id
            LEFT JOIN region r ON dp.region_id = r.id
         WHERE a.latitude IS NOT NULL AND a.longitude IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17 2.04 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.27 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 1.61 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.50 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM statut_juridique t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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
App\Entity\Region 33
App\Entity\Filieres 16
App\Entity\StatutJuridique 16
App\Entity\RolePrincipal 15
App\Entity\District 14
App\Entity\TypeActeur 12

Entities Mapping

Class Mapping errors
App\Entity\District No errors.
App\Entity\Region
  • The association App\Entity\Region#district refers to the inverse side field App\Entity\District#district which does not exist.
App\Entity\User No errors.
App\Entity\Departement No errors.
App\Entity\Acteur No errors.
App\Entity\Filieres No errors.
App\Entity\TypeActeur No errors.
App\Entity\RolePrincipal No errors.
App\Entity\StatutJuridique No errors.