GET http://185.25.50.116:8080/videos/why-the-spray

Query Metrics

4 Database Queries
4 Different statements
2.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.22 ms
(45.01%)
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:
[
  "why-the-spray"
]
0.70 ms
(25.86%)
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:
[
  29
]
0.42 ms
(15.32%)
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:
[
  29
]
0.38 ms
(13.81%)
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:
[
  29
]

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.