Query Metrics
7
Database Queries
5
Different statements
6.95 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.31 ms (33.29%) |
2 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.length AS length_5, t0.departure AS departure_6, t0.arrival AS arrival_7, t0.plan AS plan_8, t0.is_open AS is_open_9, t0.description AS description_10, t0.color AS color_11, t0.sponsor_id AS sponsor_id_12, t0.created_by_id AS created_by_id_13, t0.secondary_sponsors_id AS secondary_sponsors_id_14, t0.third_sponsor_id AS third_sponsor_id_15 FROM piste t0 WHERE t0.color = ? LIMIT 1
Parameters:
[
"Rouge"
]
|
2.04 ms (29.32%) |
2 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.name AS name_3, p0_.length AS length_4, p0_.departure AS departure_5, p0_.arrival AS arrival_6, p0_.plan AS plan_7, p0_.is_open AS is_open_8, p0_.description AS description_9, p0_.color AS color_10, p0_.sponsor_id AS sponsor_id_11, p0_.created_by_id AS created_by_id_12, p0_.secondary_sponsors_id AS secondary_sponsors_id_13, p0_.third_sponsor_id AS third_sponsor_id_14 FROM piste p0_ WHERE p0_.color = ?
Parameters:
[
"Bleu"
]
|
0.91 ms (13.06%) |
1 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.name AS name_3, p0_.length AS length_4, p0_.departure AS departure_5, p0_.arrival AS arrival_6, p0_.plan AS plan_7, p0_.is_open AS is_open_8, p0_.description AS description_9, p0_.color AS color_10, p0_.sponsor_id AS sponsor_id_11, p0_.created_by_id AS created_by_id_12, p0_.secondary_sponsors_id AS secondary_sponsors_id_13, p0_.third_sponsor_id AS third_sponsor_id_14 FROM piste p0_ WHERE p0_.is_open = 1 LIMIT 3
Parameters:
[] |
0.87 ms (12.47%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.link AS link_5, t0.logo AS logo_6 FROM sponsors t0
Parameters:
[] |
0.82 ms (11.86%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.length AS length_5, t0.departure AS departure_6, t0.arrival AS arrival_7, t0.plan AS plan_8, t0.is_open AS is_open_9, t0.description AS description_10, t0.color AS color_11, t0.sponsor_id AS sponsor_id_12, t0.created_by_id AS created_by_id_13, t0.secondary_sponsors_id AS secondary_sponsors_id_14, t0.third_sponsor_id AS third_sponsor_id_15 FROM piste t0
Parameters:
[] |
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\Piste | No errors. |
App\Entity\Sponsors | No errors. |
App\Entity\User | No errors. |
App\Entity\TimePistes | No errors. |