GET https://transfer.createch.tn/tarifs

Query Metrics

73 Database Queries
5 Different statements
13.68 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 ORDER BY t0.id ASC
Parameters:
[]
2 0.20 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM excursion_location t0 ORDER BY t0.id ASC
Parameters:
[]
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.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:
[
  2
]
5 0.21 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 WHERE t0.path_id = ?
Parameters:
[
  1
]
6 0.21 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
]
7 0.24 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 WHERE t0.path_id = ?
Parameters:
[
  3
]
8 0.16 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
]
9 0.19 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 WHERE t0.path_id = ?
Parameters:
[
  5
]
10 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  9
]
11 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  10
]
12 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  11
]
13 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:
[
  6
]
14 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  12
]
15 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  13
]
16 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  14
]
17 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:
[
  7
]
18 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  15
]
19 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  16
]
20 0.20 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 WHERE t0.path_id = ?
Parameters:
[
  17
]
21 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:
[
  8
]
22 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  18
]
23 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  19
]
24 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  20
]
25 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:
[
  10
]
26 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  21
]
27 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  22
]
28 0.19 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 WHERE t0.path_id = ?
Parameters:
[
  23
]
29 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:
[
  11
]
30 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  24
]
31 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  25
]
32 0.22 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 WHERE t0.path_id = ?
Parameters:
[
  26
]
33 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
]
34 0.15 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 WHERE t0.path_id = ?
Parameters:
[
  27
]
35 0.22 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 WHERE t0.path_id = ?
Parameters:
[
  28
]
36 0.37 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 WHERE t0.path_id = ?
Parameters:
[
  29
]
37 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:
[
  13
]
38 0.24 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 WHERE t0.path_id = ?
Parameters:
[
  30
]
39 0.26 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 WHERE t0.path_id = ?
Parameters:
[
  31
]
40 0.22 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 WHERE t0.path_id = ?
Parameters:
[
  32
]
41 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:
[
  14
]
42 0.19 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 WHERE t0.path_id = ?
Parameters:
[
  33
]
43 0.25 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 WHERE t0.path_id = ?
Parameters:
[
  34
]
44 0.21 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 WHERE t0.path_id = ?
Parameters:
[
  35
]
45 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:
[
  15
]
46 0.19 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 WHERE t0.path_id = ?
Parameters:
[
  36
]
47 0.19 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 WHERE t0.path_id = ?
Parameters:
[
  37
]
48 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  38
]
49 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:
[
  16
]
50 0.15 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 WHERE t0.path_id = ?
Parameters:
[
  39
]
51 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  40
]
52 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  41
]
53 0.16 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
]
54 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  42
]
55 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  44
]
56 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  45
]
57 0.17 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 WHERE t0.path_id = ?
Parameters:
[
  46
]
58 0.22 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 WHERE t0.path_id = ?
Parameters:
[
  47
]
59 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:
[
  18
]
60 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  48
]
61 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:
[
  19
]
62 0.16 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 WHERE t0.path_id = ?
Parameters:
[
  49
]
63 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:
[
  3
]
64 0.18 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 WHERE t0.path_id = ?
Parameters:
[
  2
]
65 0.20 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 WHERE t0.path_id = ?
Parameters:
[
  4
]
66 0.19 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 WHERE t0.path_id = ?
Parameters:
[
  6
]
67 0.20 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 WHERE t0.path_id = ?
Parameters:
[
  7
]
68 0.19 ms
SELECT t0.id AS id_1, t0.hours_number AS hours_number_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.excursion_id AS excursion_id_5 FROM excursion_rate t0 WHERE t0.excursion_id = ?
Parameters:
[
  1
]
69 0.18 ms
SELECT t0.id AS id_1, t0.hours_number AS hours_number_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.excursion_id AS excursion_id_5 FROM excursion_rate t0 WHERE t0.excursion_id = ?
Parameters:
[
  2
]
70 0.22 ms
SELECT t0.id AS id_1, t0.hours_number AS hours_number_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.excursion_id AS excursion_id_5 FROM excursion_rate t0 WHERE t0.excursion_id = ?
Parameters:
[
  3
]
71 0.17 ms
SELECT t0.id AS id_1, t0.hours_number AS hours_number_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.excursion_id AS excursion_id_5 FROM excursion_rate t0 WHERE t0.excursion_id = ?
Parameters:
[
  4
]
72 0.20 ms
SELECT t0.id AS id_1, t0.hours_number AS hours_number_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.excursion_id AS excursion_id_5 FROM excursion_rate t0 WHERE t0.excursion_id = ?
Parameters:
[
  5
]
73 0.18 ms
SELECT t0.id AS id_1, t0.hours_number AS hours_number_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.excursion_id AS excursion_id_5 FROM excursion_rate t0 WHERE t0.excursion_id = ?
Parameters:
[
  6
]

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