Query Metrics
115
Database Queries
16
Different statements
19.48 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.22 ms (47.33%) |
48 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.timecode AS timecode_4, t0.duration AS duration_5, t0.article_id AS article_id_6, t7.id AS id_8, t7.slug AS slug_9, t7.position AS position_10, t7.meta_description AS meta_description_11, t7.status AS status_12, t7.created_at AS created_at_13, t7.updated_at AS updated_at_14, t7.video_poster_id AS video_poster_id_15, t7.category_id AS category_id_16, t7.video_id AS video_id_17 FROM video_marker t0 INNER JOIN article t7 ON t0.article_id = t7.id INNER JOIN video_markers__attachments ON t0.id = video_markers__attachments.video_marker_id WHERE video_markers__attachments.attachment_id = ?
Parameters:
[
104
]
|
|
2.99 ms (15.34%) |
21 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.src AS src_3, t0.description AS description_4, t0.mime AS mime_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
103
]
|
|
2.93 ms (15.03%) |
21 |
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.media_id AS media_id_6 FROM media_meta_tag t0 WHERE t0.media_id = ?
Parameters:
[
78
]
|
|
0.84 ms (4.30%) |
6 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ WHERE c0_.slug = ?
Parameters:
[
"enjeux-fonciers"
]
|
|
0.60 ms (3.06%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.position AS position_3, t0.meta_description AS meta_description_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.video_poster_id AS video_poster_id_8, t0.category_id AS category_id_9, t0.video_id AS video_id_10, t11.id AS id_12, t11.title AS title_13, t11.src AS src_14, t11.description AS description_15, t11.mime AS mime_16, t11.created_at AS created_at_17, t11.updated_at AS updated_at_18 FROM article t0 LEFT JOIN media t11 ON t0.video_id = t11.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
"Paul-Marie-Faye-Monte"
]
|
|
0.54 ms (2.79%) |
4 |
SELECT COUNT(*) FROM article t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
|
0.35 ms (1.78%) |
2 |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 2
Parameters:
[] |
|
0.32 ms (1.64%) |
2 |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 1
Parameters:
[] |
|
0.30 ms (1.53%) |
2 |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 4
Parameters:
[] |
|
0.29 ms (1.48%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.src AS src_3, t0.description AS description_4, t0.mime AS mime_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (?, ?, ?)
Parameters:
[ 50 63 114 ] |
|
0.28 ms (1.44%) |
1 |
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 3
Parameters:
[] |
|
0.23 ms (1.19%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.src AS src_3, t0.description AS description_4, t0.mime AS mime_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 78 80 82 84 86 88 90 92 94 96 98 100 102 106 108 110 116 118 120 122 ] |
|
0.17 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 INNER JOIN tag_article ON t0.id = tag_article.tag_id WHERE tag_article.article_id = ?
Parameters:
[
32
]
|
|
0.16 ms (0.85%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.timecode AS timecode_4, t0.duration AS duration_5, t0.article_id AS article_id_6, t7.id AS id_8, t7.slug AS slug_9, t7.position AS position_10, t7.meta_description AS meta_description_11, t7.status AS status_12, t7.created_at AS created_at_13, t7.updated_at AS updated_at_14, t7.video_poster_id AS video_poster_id_15, t7.category_id AS category_id_16, t7.video_id AS video_id_17 FROM video_marker t0 INNER JOIN article t7 ON t0.article_id = t7.id WHERE t0.article_id = ?
Parameters:
[
32
]
|
|
0.13 ms (0.69%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM category t0
Parameters:
[] |
|
0.13 ms (0.66%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM category t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Article | No errors. |
| App\Entity\Media |
|
| App\Entity\Category | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\VideoMarker | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\MediaMetaTag | No errors. |