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

Query Metrics

49 Database Queries
4 Different statements
30.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.81 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:
[
  "14"
]
2 2.41 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:
[
  14
  "1"
]
3 1.81 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:
[
  81
]
4 0.41 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:
[
  82
]
5 0.37 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:
[
  83
]
6 0.36 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:
[
  84
]
7 0.36 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:
[
  85
]
8 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:
[
  86
]
9 0.35 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:
[
  87
]
10 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:
[
  88
]
11 0.37 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:
[
  89
]
12 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:
[
  90
]
13 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:
[
  91
]
14 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:
[
  92
]
15 0.37 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:
[
  93
]
16 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:
[
  94
]
17 0.37 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:
[
  95
]
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:
[
  96
]
19 0.35 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:
[
  97
]
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:
[
  98
]
21 0.35 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:
[
  99
]
22 0.36 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:
[
  100
]
23 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:
[
  101
]
24 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:
[
  102
]
25 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:
[
  103
]
26 0.40 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:
[
  14
  "1"
  "1"
]
27 0.51 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:
[
  81
]
28 0.47 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:
[
  82
]
29 0.43 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:
[
  83
]
30 0.46 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:
[
  84
]
31 0.62 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:
[
  85
]
32 0.80 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:
[
  86
]
33 0.52 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:
[
  87
]
34 0.42 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:
[
  88
]
35 0.56 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:
[
  89
]
36 0.43 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:
[
  90
]
37 0.42 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:
[
  91
]
38 0.41 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:
[
  92
]
39 0.41 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:
[
  93
]
40 1.04 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:
[
  94
]
41 0.40 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:
[
  95
]
42 2.25 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:
[
  96
]
43 0.47 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:
[
  97
]
44 0.43 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:
[
  98
]
45 0.45 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:
[
  99
]
46 0.63 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:
[
  100
]
47 1.11 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:
[
  101
]
48 0.39 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:
[
  102
]
49 2.47 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:
[
  103
]

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.