1 |
1.26 ms |
select count(*) as numrows from elprice where date(time_start) = :dato
Parameters: [
"dato" => "2025/08-21"
]
select count(*) as numrows from elprice where date(time_start) = '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"
]
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-21 00:00:00';
|
3 |
0.13 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 00:00:00', time_end = '2025-08-21 01:00:00' WHERE id = 937;
|
5 |
0.13 ms |
"COMMIT"
|
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"
]
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-21 01:00:00';
|
7 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 01:00:00', time_end = '2025-08-21 02:00:00', price = '1.0734' WHERE id = 938;
|
9 |
0.12 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-21 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-21 02:00:00';
|
11 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 02:00:00', time_end = '2025-08-21 03:00:00' WHERE id = 939;
|
13 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 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-21 03:00:00"
"2025-08-21 04:00:00"
940
]
UPDATE elprice SET time_start = '2025-08-21 03:00:00', time_end = '2025-08-21 04:00:00' WHERE id = 940;
|
17 |
0.15 ms |
"COMMIT"
|
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"
]
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-21 04:00:00';
|
19 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 04:00:00', time_end = '2025-08-21 05:00:00' WHERE id = 941;
|
21 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 05:00:00';
|
23 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 05:00:00', time_end = '2025-08-21 06:00:00' WHERE id = 942;
|
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-21 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-21 06:00:00';
|
27 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 06:00:00', time_end = '2025-08-21 07:00:00' WHERE id = 943;
|
29 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 07:00:00';
|
31 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 07:00:00', time_end = '2025-08-21 08:00:00' WHERE id = 944;
|
33 |
0.12 ms |
"COMMIT"
|
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"
]
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-21 08:00:00';
|
35 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 08:00:00', time_end = '2025-08-21 09:00:00' WHERE id = 945;
|
37 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 09:00:00';
|
39 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 09:00:00', time_end = '2025-08-21 10:00:00' WHERE id = 946;
|
41 |
0.12 ms |
"COMMIT"
|
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"
]
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-21 10:00:00';
|
43 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 10:00:00', time_end = '2025-08-21 11:00:00' WHERE id = 947;
|
45 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 11:00:00';
|
47 |
0.15 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 11:00:00', time_end = '2025-08-21 12:00:00', price = '1.0103' WHERE id = 948;
|
49 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 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-21 12:00:00"
"2025-08-21 13:00:00"
949
]
UPDATE elprice SET time_start = '2025-08-21 12:00:00', time_end = '2025-08-21 13:00:00' WHERE id = 949;
|
53 |
0.12 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-21 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-21 13:00:00';
|
55 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 13:00:00', time_end = '2025-08-21 14:00:00' WHERE id = 950;
|
57 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 14:00:00';
|
59 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 14:00:00', time_end = '2025-08-21 15:00:00' WHERE id = 951;
|
61 |
0.12 ms |
"COMMIT"
|
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"
]
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-21 15:00:00';
|
63 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 15:00:00', time_end = '2025-08-21 16:00:00' WHERE id = 952;
|
65 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 16:00:00';
|
67 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 16:00:00', time_end = '2025-08-21 17:00:00' WHERE id = 953;
|
69 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 17:00:00';
|
71 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 17:00:00', time_end = '2025-08-21 18:00:00' WHERE id = 954;
|
73 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 18:00:00';
|
75 |
0.12 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 18:00:00', time_end = '2025-08-21 19:00:00' WHERE id = 955;
|
77 |
0.12 ms |
"COMMIT"
|
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"
]
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-21 19:00:00';
|
79 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 19:00:00', time_end = '2025-08-21 20:00:00' WHERE id = 956;
|
81 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 20:00:00';
|
83 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 20:00:00', time_end = '2025-08-21 21:00:00' WHERE id = 957;
|
85 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 21:00:00';
|
87 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 21:00:00', time_end = '2025-08-21 22:00:00' WHERE id = 958;
|
89 |
0.11 ms |
"COMMIT"
|
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"
]
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-21 22:00:00';
|
91 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 22:00:00', time_end = '2025-08-21 23:00:00' WHERE id = 959;
|
93 |
0.13 ms |
"COMMIT"
|
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"
]
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-21 23:00:00';
|
95 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE elprice SET time_start = '2025-08-21 23:00:00', time_end = '2025-08-22 00:00:00', price = '1.1297' WHERE id = 960;
|
97 |
0.11 ms |
"COMMIT"
|
98 |
0.44 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';
|