1 |
1.79 ms |
select count(*) as numrows from elprice where date(time_start) = :dato
Parameters: [
"dato" => "2025/08-22"
]
select count(*) as numrows from elprice where date(time_start) = '2025/08-22';
|
2 |
0.70 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-22 00:00:00"
]
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 = '2025-08-22 00:00:00';
|
3 |
0.15 ms |
"START TRANSACTION"
"START TRANSACTION";
|
4 |
0.87 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 00:00:00"
"2025-08-22 01:00:00"
961
]
UPDATE elprice SET time_start = '2025-08-22 00:00:00', time_end = '2025-08-22 01:00:00' WHERE id = 961;
|
5 |
0.15 ms |
"COMMIT"
|
6 |
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-22 01:00:00"
]
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 = '2025-08-22 01:00:00';
|
7 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
8 |
0.22 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 01:00:00"
"2025-08-22 02:00:00"
962
]
UPDATE elprice SET time_start = '2025-08-22 01:00:00', time_end = '2025-08-22 02:00:00' WHERE id = 962;
|
9 |
0.11 ms |
"COMMIT"
|
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-22 02:00:00"
]
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 = '2025-08-22 02:00:00';
|
11 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
12 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 02:00:00"
"2025-08-22 03:00:00"
963
]
UPDATE elprice SET time_start = '2025-08-22 02:00:00', time_end = '2025-08-22 03:00:00' WHERE id = 963;
|
13 |
0.11 ms |
"COMMIT"
|
14 |
0.49 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-22 03:00:00"
]
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 = '2025-08-22 03:00:00';
|
15 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
16 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 03:00:00"
"2025-08-22 04:00:00"
964
]
UPDATE elprice SET time_start = '2025-08-22 03:00:00', time_end = '2025-08-22 04:00:00' WHERE id = 964;
|
17 |
0.11 ms |
"COMMIT"
|
18 |
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-22 04:00:00"
]
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 = '2025-08-22 04:00:00';
|
19 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
20 |
0.21 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 04:00:00"
"2025-08-22 05:00:00"
965
]
UPDATE elprice SET time_start = '2025-08-22 04:00:00', time_end = '2025-08-22 05:00:00' WHERE id = 965;
|
21 |
0.13 ms |
"COMMIT"
|
22 |
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-22 05:00:00"
]
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 = '2025-08-22 05:00:00';
|
23 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
24 |
0.23 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 05:00:00"
"2025-08-22 06:00:00"
966
]
UPDATE elprice SET time_start = '2025-08-22 05:00:00', time_end = '2025-08-22 06:00:00' WHERE id = 966;
|
25 |
0.11 ms |
"COMMIT"
|
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-22 06:00:00"
]
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 = '2025-08-22 06:00:00';
|
27 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
28 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 06:00:00"
"2025-08-22 07:00:00"
967
]
UPDATE elprice SET time_start = '2025-08-22 06:00:00', time_end = '2025-08-22 07:00:00' WHERE id = 967;
|
29 |
0.11 ms |
"COMMIT"
|
30 |
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-22 07:00:00"
]
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 = '2025-08-22 07:00:00';
|
31 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
32 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 07:00:00"
"2025-08-22 08:00:00"
968
]
UPDATE elprice SET time_start = '2025-08-22 07:00:00', time_end = '2025-08-22 08:00:00' WHERE id = 968;
|
33 |
0.11 ms |
"COMMIT"
|
34 |
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-22 08:00:00"
]
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 = '2025-08-22 08:00:00';
|
35 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
36 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 08:00:00"
"2025-08-22 09:00:00"
969
]
UPDATE elprice SET time_start = '2025-08-22 08:00:00', time_end = '2025-08-22 09:00:00' WHERE id = 969;
|
37 |
0.12 ms |
"COMMIT"
|
38 |
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-22 09:00:00"
]
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 = '2025-08-22 09:00:00';
|
39 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
40 |
0.23 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 09:00:00"
"2025-08-22 10:00:00"
970
]
UPDATE elprice SET time_start = '2025-08-22 09:00:00', time_end = '2025-08-22 10:00:00' WHERE id = 970;
|
41 |
0.13 ms |
"COMMIT"
|
42 |
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-22 10:00:00"
]
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 = '2025-08-22 10:00:00';
|
43 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
44 |
0.22 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 10:00:00"
"2025-08-22 11:00:00"
971
]
UPDATE elprice SET time_start = '2025-08-22 10:00:00', time_end = '2025-08-22 11:00:00' WHERE id = 971;
|
45 |
0.11 ms |
"COMMIT"
|
46 |
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-22 11:00:00"
]
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 = '2025-08-22 11:00:00';
|
47 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
48 |
0.21 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 11:00:00"
"2025-08-22 12:00:00"
972
]
UPDATE elprice SET time_start = '2025-08-22 11:00:00', time_end = '2025-08-22 12:00:00' WHERE id = 972;
|
49 |
0.11 ms |
"COMMIT"
|
50 |
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-22 12:00:00"
]
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 = '2025-08-22 12:00:00';
|
51 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
52 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 12:00:00"
"2025-08-22 13:00:00"
973
]
UPDATE elprice SET time_start = '2025-08-22 12:00:00', time_end = '2025-08-22 13:00:00' WHERE id = 973;
|
53 |
0.11 ms |
"COMMIT"
|
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-22 13:00:00"
]
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 = '2025-08-22 13:00:00';
|
55 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
56 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 13:00:00"
"2025-08-22 14:00:00"
974
]
UPDATE elprice SET time_start = '2025-08-22 13:00:00', time_end = '2025-08-22 14:00:00' WHERE id = 974;
|
57 |
0.13 ms |
"COMMIT"
|
58 |
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-22 14:00:00"
]
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 = '2025-08-22 14:00:00';
|
59 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
60 |
0.22 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 14:00:00"
"2025-08-22 15:00:00"
975
]
UPDATE elprice SET time_start = '2025-08-22 14:00:00', time_end = '2025-08-22 15:00:00' WHERE id = 975;
|
61 |
0.12 ms |
"COMMIT"
|
62 |
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-22 15:00:00"
]
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 = '2025-08-22 15:00:00';
|
63 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
64 |
0.24 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 15:00:00"
"2025-08-22 16:00:00"
976
]
UPDATE elprice SET time_start = '2025-08-22 15:00:00', time_end = '2025-08-22 16:00:00' WHERE id = 976;
|
65 |
0.16 ms |
"COMMIT"
|
66 |
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-22 16:00:00"
]
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 = '2025-08-22 16:00:00';
|
67 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
68 |
0.26 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 16:00:00"
"2025-08-22 17:00:00"
977
]
UPDATE elprice SET time_start = '2025-08-22 16:00:00', time_end = '2025-08-22 17:00:00' WHERE id = 977;
|
69 |
0.14 ms |
"COMMIT"
|
70 |
0.65 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-22 17:00:00"
]
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 = '2025-08-22 17:00:00';
|
71 |
0.14 ms |
"START TRANSACTION"
"START TRANSACTION";
|
72 |
0.37 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 17:00:00"
"2025-08-22 18:00:00"
978
]
UPDATE elprice SET time_start = '2025-08-22 17:00:00', time_end = '2025-08-22 18:00:00' WHERE id = 978;
|
73 |
0.13 ms |
"COMMIT"
|
74 |
0.58 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-22 18:00:00"
]
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 = '2025-08-22 18:00:00';
|
75 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
76 |
0.21 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 18:00:00"
"2025-08-22 19:00:00"
979
]
UPDATE elprice SET time_start = '2025-08-22 18:00:00', time_end = '2025-08-22 19:00:00' WHERE id = 979;
|
77 |
0.11 ms |
"COMMIT"
|
78 |
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-22 19:00:00"
]
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 = '2025-08-22 19:00:00';
|
79 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
80 |
0.19 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 19:00:00"
"2025-08-22 20:00:00"
980
]
UPDATE elprice SET time_start = '2025-08-22 19:00:00', time_end = '2025-08-22 20:00:00' WHERE id = 980;
|
81 |
0.11 ms |
"COMMIT"
|
82 |
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-22 20:00:00"
]
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 = '2025-08-22 20:00:00';
|
83 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
84 |
0.19 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 20:00:00"
"2025-08-22 21:00:00"
981
]
UPDATE elprice SET time_start = '2025-08-22 20:00:00', time_end = '2025-08-22 21:00:00' WHERE id = 981;
|
85 |
0.12 ms |
"COMMIT"
|
86 |
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-22 21:00:00"
]
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 = '2025-08-22 21:00:00';
|
87 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
88 |
0.20 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 21:00:00"
"2025-08-22 22:00:00"
982
]
UPDATE elprice SET time_start = '2025-08-22 21:00:00', time_end = '2025-08-22 22:00:00' WHERE id = 982;
|
89 |
0.11 ms |
"COMMIT"
|
90 |
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-22 22:00:00"
]
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 = '2025-08-22 22:00:00';
|
91 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
92 |
0.22 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 22:00:00"
"2025-08-22 23:00:00"
983
]
UPDATE elprice SET time_start = '2025-08-22 22:00:00', time_end = '2025-08-22 23:00:00' WHERE id = 983;
|
93 |
0.11 ms |
"COMMIT"
|
94 |
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-22 23:00:00"
]
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 = '2025-08-22 23:00:00';
|
95 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
96 |
0.19 ms |
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
Parameters: [
"2025-08-22 23:00:00"
"2025-08-23 00:00:00"
984
]
UPDATE elprice SET time_start = '2025-08-22 23:00:00', time_end = '2025-08-23 00:00:00' WHERE id = 984;
|
97 |
0.11 ms |
"COMMIT"
|
98 |
0.43 ms |
select count(*) as numrows from elprice where date(time_start) = :dato
Parameters: [
"dato" => "2025/08-23"
]
select count(*) as numrows from elprice where date(time_start) = '2025/08-23';
|