Query Metrics
4
Database Queries
4
Different statements
4.74 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.60 ms (54.93%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.director AS director_5, t0.producer AS producer_6, t0.year AS year_7, t0.format AS format_8, t0.amount AS amount_9, t0.runtime AS runtime_10, t0.bonus_runtime AS bonus_runtime_11, t0.genres AS genres_12, t0.countries AS countries_13, t0.regions AS regions_14, t0.languages AS languages_15, t0.subtitles AS subtitles_16, t0.price AS price_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM videos t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"dr-zoch-kutt"
]
|
1.18 ms (24.81%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM cities t0 INNER JOIN video_city ON t0.id = video_city.city_id WHERE video_city.video_id = ?
Parameters:
[
19
]
|
0.49 ms (10.42%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.video_id AS video_id_4 FROM video_links t0 WHERE t0.video_id = ?
Parameters:
[
19
]
|
0.47 ms (9.84%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.video_id AS video_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM video_images t0 WHERE t0.video_id = ?
Parameters:
[
19
]
|
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\Video | No errors. |
App\Entity\User | No errors. |
App\Entity\City | No errors. |
App\Entity\VideoImage | No errors. |
App\Entity\VideoLink | No errors. |
App\Entity\Book | No errors. |