Symfony Profiler

Query Metrics

194 Database Queries
6 Different statements
62.31 ms Query time
0 Invalid entities
Queries


select count(*) as numrows from elprice where date(time_start) = :dato
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ?, price = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ?, price = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ?, price = ? WHERE id = ?
"COMMIT"
select count(*) as numrows from elprice where date(time_start) = :dato
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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 = ?
"START TRANSACTION"
UPDATE elprice SET time_start = ?, time_end = ? WHERE id = ?
"COMMIT"
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.
Symfony Profiler

GET http://185.101.35.107/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
