Query Metrics
2
Database Queries
2
Different statements
32.77 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.71 ms (63.19%) |
1 |
SELECT COUNT(t0_.id) AS sclr_0, p1_.id AS id_1, p1_.slug AS slug_2, p1_.views AS views_3, i2_.slug AS slug_4, i2_.name AS name_5, p1_.webp AS webp_6 FROM trend t0_ INNER JOIN photo p1_ ON t0_.photo_id = p1_.id INNER JOIN influencer i2_ ON p1_.influencer_id = i2_.id WHERE t0_.photo_id IS NOT NULL GROUP BY t0_.photo_id ORDER BY sclr_0 DESC LIMIT 8
Parameters:
[] |
|
12.06 ms (36.81%) |
1 |
SELECT COUNT(t0_.id) AS sclr_0, v1_.id AS id_1, v1_.slug AS slug_2, v1_.views AS views_3, i2_.slug AS slug_4, i2_.name AS name_5, v1_.webp AS webp_6, v1_.preview_url AS preview_url_7 FROM trend_video t0_ INNER JOIN video v1_ ON t0_.video_id = v1_.id INNER JOIN influencer i2_ ON v1_.influencer_id = i2_.id GROUP BY t0_.video_id ORDER BY sclr_0 DESC LIMIT 19
Parameters:
[] |
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\Trend | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Influencer |
|
| App\Entity\TrendVideo | No errors. |
| App\Entity\Video | No errors. |