Query Metrics
3
Database Queries
3
Different statements
140.77 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 61.78 ms |
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ INNER JOIN influencer i1_ ON v0_.influencer_id = i1_.id WHERE v0_.actif = ?
Parameters:
[
1
]
|
| 2 | 64.14 ms |
SELECT DISTINCT v0_.id AS id_0, v0_.created_at AS created_at_1 FROM video v0_ INNER JOIN influencer i1_ ON v0_.influencer_id = i1_.id WHERE v0_.actif = ? ORDER BY v0_.created_at DESC LIMIT 22 OFFSET 22
Parameters:
[
1
]
|
| 3 | 14.85 ms |
SELECT v0_.id AS id_0, v0_.slug AS slug_1, v0_.views AS views_2, v0_.created_at AS created_at_3, i1_.name AS name_4, i1_.slug AS slug_5, v0_.webp AS webp_6, v0_.preview_url AS preview_url_7 FROM video v0_ INNER JOIN influencer i1_ ON v0_.influencer_id = i1_.id WHERE v0_.actif = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.created_at DESC
Parameters:
[ 1 11044 11043 11042 11041 11040 11039 11038 11037 11036 11035 11034 11033 11032 11030 11031 11029 11028 11027 11026 11025 11023 11024 ] |
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\Influencer |
|