GET https://locacar.ovh/help/videos?category=Setup

Query Metrics

3 Database Queries
3 Different statements
2.58 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.98 ms
(37.80%)
1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.video_url AS video_url_3, t0_.thumbnail_url AS thumbnail_url_4, t0_.duration AS duration_5, t0_.category AS category_6, t0_.tags AS tags_7, t0_.created_at AS created_at_8, t0_.is_published AS is_published_9, t0_.view_count AS view_count_10 FROM tutorial_video t0_ WHERE t0_.category = ? AND t0_.is_published = ? ORDER BY t0_.created_at DESC
Parameters:
[
  "Setup"
  1
]
0.81 ms
(31.36%)
1
SELECT DISTINCT t0_.category AS category_0 FROM tutorial_video t0_ WHERE t0_.is_published = ? ORDER BY t0_.category ASC
Parameters:
[
  1
]
0.80 ms
(30.85%)
1
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.video_url AS video_url_3, t0_.thumbnail_url AS thumbnail_url_4, t0_.duration AS duration_5, t0_.category AS category_6, t0_.tags AS tags_7, t0_.created_at AS created_at_8, t0_.is_published AS is_published_9, t0_.view_count AS view_count_10 FROM tutorial_video t0_ WHERE t0_.is_published = ? ORDER BY t0_.view_count DESC LIMIT 5
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\TutorialVideo 4

Entities Mapping

Class Mapping errors
App\Entity\TutorialVideo No errors.