GET https://www.transfer.createch.tn/rate/

Query Metrics

64 Database Queries
3 Different statements
12.24 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.path_id AS path_id_5 FROM rate t0
Parameters:
[]
2 0.26 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.23 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.21 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.15 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 0.23 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.15 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  4
]
10 0.17 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  5
]
11 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  5
]
12 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  6
]
13 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  7
]
14 0.23 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  9
]
15 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  10
]
16 0.17 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  11
]
17 0.17 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  12
]
18 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  6
]
19 0.15 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  13
]
20 0.17 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  14
]
21 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  15
]
22 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  7
]
23 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  16
]
24 0.15 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  17
]
25 0.21 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  18
]
26 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  8
]
27 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  19
]
28 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  20
]
29 0.28 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  21
]
30 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  10
]
31 0.20 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  22
]
32 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  23
]
33 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  24
]
34 0.17 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  11
]
35 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  25
]
36 0.15 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  26
]
37 0.14 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  27
]
38 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  12
]
39 0.14 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  28
]
40 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  29
]
41 0.15 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  30
]
42 0.22 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  13
]
43 0.23 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  31
]
44 0.25 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  32
]
45 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  33
]
46 0.14 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  14
]
47 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  34
]
48 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  35
]
49 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  36
]
50 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  15
]
51 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  37
]
52 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  38
]
53 0.17 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  39
]
54 0.19 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  16
]
55 0.20 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  40
]
56 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  41
]
57 0.22 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  42
]
58 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  9
]
59 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  44
]
60 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  45
]
61 0.19 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  46
]
62 0.18 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  47
]
63 0.16 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?
Parameters:
[
  48
]
64 0.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?
Parameters:
[
  18
]

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\Rate No errors.
App\Entity\Path No errors.
App\Entity\Location No errors.
App\Entity\Transfer No errors.