GET https://nutrizaza.com/api/admin/regions?itemsPerPage=30&order%5Bdesignation%5D=asc

Query Metrics

27 Database Queries
4 Different statements
13.67 ms Query time
1 Invalid entities
290 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.48 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.nom_prenom AS nom_prenom_7, t0.ebp_client_code AS ebp_client_code_8, t0.is_enabled AS is_enabled_9, t0.last_activity_at AS last_activity_at_10, t0.last_visite_at AS last_visite_at_11, t0.last_update_at AS last_update_at_12, t0.last_login_at AS last_login_at_13, t0.utilisateur_role_id AS utilisateur_role_id_14, t0.region_id AS region_id_15 FROM utilisateur t0 WHERE t0.id = ?
Parameters:
[
  19
]
2 0.54 ms
SELECT count(*) AS sclr_0 FROM region r0_
Parameters:
[]
3 1.19 ms
SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.designation AS designation_2, r0_.numero AS numero_3, r0_.surface AS surface_4, ST_AsBinary(r0_.center) AS center_5, r0_.spatial_data_id AS spatial_data_id_6 FROM region r0_ ORDER BY r0_.designation ASC LIMIT 30
Parameters:
[]
4 2.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  1
]
5 0.37 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  2
]
6 0.43 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  3
]
7 0.49 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  4
]
8 0.32 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  5
]
9 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  6
]
10 0.33 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  7
]
11 1.01 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  8
]
12 0.41 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  9
]
13 0.37 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  10
]
14 0.36 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  11
]
15 0.36 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  12
]
16 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  13
]
17 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  14
]
18 0.67 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  15
]
19 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  16
]
20 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  17
]
21 0.36 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  18
]
22 0.37 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  19
]
23 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  20
]
24 0.34 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  21
]
25 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  22
]
26 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  23
]
27 0.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?
Parameters:
[
  24
]

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\SpatialData 144
App\Entity\District 120
App\Entity\Region 24
App\Entity\Utilisateur 1
App\Entity\UtilisateurRole 1

Entities Mapping

Class Mapping errors
App\Entity\Utilisateur No errors.
App\Entity\UtilisateurRole No errors.
App\Entity\Region No errors.
App\Entity\Animatrice
  • The field App\Entity\Animatrice#statusHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AnimatriceStatusHistory#animatrice does not contain the required 'inversedBy: "statusHistories"' attribute.
App\Entity\MiscellaneousMouvement No errors.
App\Entity\ProductStockMouvement No errors.
App\Entity\Visite No errors.
App\Entity\Paiement No errors.
App\Entity\Ajustement No errors.
App\Entity\SpatialData No errors.
App\Entity\District No errors.
App\Entity\Commune No errors.