GET https://grandalsmyra.com/

Query Metrics

98 Database Queries
6 Different statements
23.36 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.26 ms
select count(*) as numrows from elprice where date(time_start) = :dato
Parameters:
[
  "dato" => "2025/08-21"
]
2 0.73 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 00:00:00"
]
3 0.13 ms
"START TRANSACTION"
Parameters:
[]
4 0.36 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 00:00:00"
  "2025-08-21 01:00:00"
  937
]
5 0.13 ms
"COMMIT"
Parameters:
[]
6 0.45 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 01:00:00"
]
7 0.11 ms
"START TRANSACTION"
Parameters:
[]
8 0.22 ms
UPDATE elprice SET time_start = ?, time_end = ?, price = ? WHERE id = ?
Parameters:
[
  "2025-08-21 01:00:00"
  "2025-08-21 02:00:00"
  "1.0734"
  938
]
9 0.12 ms
"COMMIT"
Parameters:
[]
10 0.45 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 02:00:00"
]
11 0.11 ms
"START TRANSACTION"
Parameters:
[]
12 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 02:00:00"
  "2025-08-21 03:00:00"
  939
]
13 0.11 ms
"COMMIT"
Parameters:
[]
14 0.45 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 03:00:00"
]
15 0.11 ms
"START TRANSACTION"
Parameters:
[]
16 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 03:00:00"
  "2025-08-21 04:00:00"
  940
]
17 0.15 ms
"COMMIT"
Parameters:
[]
18 0.42 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 04:00:00"
]
19 0.11 ms
"START TRANSACTION"
Parameters:
[]
20 0.22 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 04:00:00"
  "2025-08-21 05:00:00"
  941
]
21 0.11 ms
"COMMIT"
Parameters:
[]
22 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 05:00:00"
]
23 0.10 ms
"START TRANSACTION"
Parameters:
[]
24 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 05:00:00"
  "2025-08-21 06:00:00"
  942
]
25 0.11 ms
"COMMIT"
Parameters:
[]
26 0.42 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 06:00:00"
]
27 0.11 ms
"START TRANSACTION"
Parameters:
[]
28 0.19 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 06:00:00"
  "2025-08-21 07:00:00"
  943
]
29 0.11 ms
"COMMIT"
Parameters:
[]
30 0.47 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 07:00:00"
]
31 0.11 ms
"START TRANSACTION"
Parameters:
[]
32 0.22 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 07:00:00"
  "2025-08-21 08:00:00"
  944
]
33 0.12 ms
"COMMIT"
Parameters:
[]
34 0.44 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 08:00:00"
]
35 0.11 ms
"START TRANSACTION"
Parameters:
[]
36 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 08:00:00"
  "2025-08-21 09:00:00"
  945
]
37 0.11 ms
"COMMIT"
Parameters:
[]
38 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 09:00:00"
]
39 0.12 ms
"START TRANSACTION"
Parameters:
[]
40 0.19 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 09:00:00"
  "2025-08-21 10:00:00"
  946
]
41 0.12 ms
"COMMIT"
Parameters:
[]
42 0.41 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 10:00:00"
]
43 0.10 ms
"START TRANSACTION"
Parameters:
[]
44 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 10:00:00"
  "2025-08-21 11:00:00"
  947
]
45 0.11 ms
"COMMIT"
Parameters:
[]
46 0.44 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 11:00:00"
]
47 0.15 ms
"START TRANSACTION"
Parameters:
[]
48 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ?, price = ? WHERE id = ?
Parameters:
[
  "2025-08-21 11:00:00"
  "2025-08-21 12:00:00"
  "1.0103"
  948
]
49 0.11 ms
"COMMIT"
Parameters:
[]
50 0.47 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 12:00:00"
]
51 0.11 ms
"START TRANSACTION"
Parameters:
[]
52 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 12:00:00"
  "2025-08-21 13:00:00"
  949
]
53 0.12 ms
"COMMIT"
Parameters:
[]
54 0.47 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 13:00:00"
]
55 0.11 ms
"START TRANSACTION"
Parameters:
[]
56 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 13:00:00"
  "2025-08-21 14:00:00"
  950
]
57 0.11 ms
"COMMIT"
Parameters:
[]
58 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 14:00:00"
]
59 0.12 ms
"START TRANSACTION"
Parameters:
[]
60 0.24 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 14:00:00"
  "2025-08-21 15:00:00"
  951
]
61 0.12 ms
"COMMIT"
Parameters:
[]
62 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 15:00:00"
]
63 0.11 ms
"START TRANSACTION"
Parameters:
[]
64 0.22 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 15:00:00"
  "2025-08-21 16:00:00"
  952
]
65 0.11 ms
"COMMIT"
Parameters:
[]
66 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 16:00:00"
]
67 0.11 ms
"START TRANSACTION"
Parameters:
[]
68 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 16:00:00"
  "2025-08-21 17:00:00"
  953
]
69 0.11 ms
"COMMIT"
Parameters:
[]
70 0.44 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 17:00:00"
]
71 0.11 ms
"START TRANSACTION"
Parameters:
[]
72 0.26 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 17:00:00"
  "2025-08-21 18:00:00"
  954
]
73 0.11 ms
"COMMIT"
Parameters:
[]
74 0.47 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 18:00:00"
]
75 0.12 ms
"START TRANSACTION"
Parameters:
[]
76 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 18:00:00"
  "2025-08-21 19:00:00"
  955
]
77 0.12 ms
"COMMIT"
Parameters:
[]
78 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 19:00:00"
]
79 0.11 ms
"START TRANSACTION"
Parameters:
[]
80 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 19:00:00"
  "2025-08-21 20:00:00"
  956
]
81 0.11 ms
"COMMIT"
Parameters:
[]
82 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 20:00:00"
]
83 0.11 ms
"START TRANSACTION"
Parameters:
[]
84 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 20:00:00"
  "2025-08-21 21:00:00"
  957
]
85 0.11 ms
"COMMIT"
Parameters:
[]
86 0.47 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 21:00:00"
]
87 0.11 ms
"START TRANSACTION"
Parameters:
[]
88 0.23 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 21:00:00"
  "2025-08-21 22:00:00"
  958
]
89 0.11 ms
"COMMIT"
Parameters:
[]
90 0.43 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 22:00:00"
]
91 0.11 ms
"START TRANSACTION"
Parameters:
[]
92 0.21 ms
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters:
[
  "2025-08-21 22:00:00"
  "2025-08-21 23:00:00"
  959
]
93 0.13 ms
"COMMIT"
Parameters:
[]
94 0.46 ms
SELECT t0.id AS id_1, t0.time_start AS time_start_2, t0.time_end AS time_end_3, t0.price AS price_4 FROM elprice t0 WHERE t0.time_start = ?
Parameters:
[
  "2025-08-21 23:00:00"
]
95 0.11 ms
"START TRANSACTION"
Parameters:
[]
96 0.20 ms
UPDATE elprice SET time_start = ?, time_end = ?, price = ? WHERE id = ?
Parameters:
[
  "2025-08-21 23:00:00"
  "2025-08-22 00:00:00"
  "1.1297"
  960
]
97 0.11 ms
"COMMIT"
Parameters:
[]
98 0.44 ms
select count(*) as numrows from elprice where date(time_start) = :dato
Parameters:
[
  "dato" => "2025/08-22"
]

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\Elprice No errors.