GET http://185.25.50.116:8080/videos/show-must-go-on-5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
5.88 ms
(53.06%)
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:
[
  7
]
3.58 ms
(32.32%)
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:
[
  "show-must-go-on-5"
]
0.92 ms
(8.34%)
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:
[
  7
]
0.70 ms
(6.28%)
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:
[
  7
]

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.