https://zestedecom.sagpc.agence58.com/service/4

Method
GET
HTTP Status
200
IP
216.73.216.81
Profiled on
Token
30b3be

Query Metrics

25 Database Queries
4 Different statements
8.57 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.89 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.rank AS rank_4, t0.enable AS enable_5, t0.color AS color_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "4"
]
View formatted query    View runnable query    Explain query
2 0.43 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.enable AS enable_3, t0.sub AS sub_4, t0.category_id AS category_id_5, t0.sub_category_id AS sub_category_id_6 FROM service t0 WHERE t0.category_id = ? AND t0.enable = ?
Parameters: 
[
  4
  "1"
]
View formatted query    View runnable query    Explain query
3 0.34 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
4 0.29 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
5 0.29 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
6 0.28 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query
7 0.29 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
8 0.29 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
9 0.29 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
10 0.30 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
11 0.30 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query
12 0.27 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
13 0.26 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query
14 0.30 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.enable AS enable_3, t0.sub AS sub_4, t0.category_id AS category_id_5, t0.sub_category_id AS sub_category_id_6 FROM service t0 WHERE t0.category_id = ? AND t0.enable = ? AND t0.sub = ?
Parameters: 
[
  4
  "1"
  "1"
]
View formatted query    View runnable query    Explain query
15 0.48 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
16 0.34 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
17 0.33 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
18 0.33 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query
19 0.33 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
20 0.33 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
21 0.32 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
22 0.32 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
23 0.33 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query
24 0.32 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
25 0.31 ms 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.format AS format_3, t0.under_service AS under_service_4, t0.mention AS mention_5, t0.service_id AS service_id_6 FROM numero t0 WHERE t0.service_id = ?
Parameters: 
[
  33
]
View formatted query    View runnable query    Explain query

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\Category No errors.
App\Entity\Service No errors.
App\Entity\Numero No errors.