Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

36 Database Queries

12 Different statements

6.76 ms Query time

1 Invalid entities

Queries

Group similar statements


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.slug = ? LIMIT 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 = 2 ORDER BY a0_.position ASC
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 (?, ?, ?)
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 = ?
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 = ?
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 = ?
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 = ?
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
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 = ?
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
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 (?, ?, ?)
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 = ?
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 = ?
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 = ?
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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
SELECT COUNT(*) FROM article t0 WHERE t0.category_id = ?
SELECT COUNT(*) FROM article t0 WHERE t0.category_id = ?
SELECT COUNT(*) FROM article t0 WHERE t0.category_id = ?
SELECT COUNT(*) FROM article t0 WHERE t0.category_id = ?

#▲	Time	Info
1	0.46 ms	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.slug = ? LIMIT 1 Parameters: [`"enjeux-fonciers"`] View formatted query View runnable query Explain query 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.slug = ? LIMIT 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.slug = 'enjeux-fonciers' LIMIT 1;
2	0.44 ms	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 ORDER BY a0_.position ASC Parameters: [] View formatted query View runnable query Explain query 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 ORDER BY a0_.position ASC 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 ORDER BY a0_.position ASC;
3	0.30 ms	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: [`63 114 50`] View formatted query View runnable query Explain query 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 (?, ?, ?) 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 (63, 114, 50);
4	0.34 ms	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: [`50`] View formatted query View runnable query Explain query 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 = ? 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 = 50;
5	0.31 ms	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: [`63`] View formatted query View runnable query Explain query 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 = ? 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 = 63;
6	0.25 ms	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: [`114`] View formatted query View runnable query Explain query 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 = ? 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 = 114;
7	0.16 ms	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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'enjeux-fonciers';
8	0.16 ms	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: [] View formatted query View runnable query Explain query 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 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;
9	0.15 ms	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: [`"dynamiques-institutionnelles"`] View formatted query View runnable query Explain query 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 = ? 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 = 'dynamiques-institutionnelles';
10	0.15 ms	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: [] View formatted query View runnable query Explain query 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 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;
11	0.14 ms	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: [`35 37 48`] View formatted query View runnable query Explain query 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 (?, ?, ?) 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 (35, 37, 48);
12	0.17 ms	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: [`35`] View formatted query View runnable query Explain query 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 = ? 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 = 35;
13	0.19 ms	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: [`37`] View formatted query View runnable query Explain query 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 = ? 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 = 37;
14	0.20 ms	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: [`48`] View formatted query View runnable query Explain query 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 = ? 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 = 48;
15	0.14 ms	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: [`"ressources-documentaires"`] View formatted query View runnable query Explain query 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 = ? 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 = 'ressources-documentaires';
16	0.15 ms	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: [] View formatted query View runnable query Explain query 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 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;
17	0.13 ms	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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'enjeux-fonciers';
18	0.14 ms	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: [] View formatted query View runnable query Explain query 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 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;
19	0.17 ms	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: [`"dynamiques-institutionnelles"`] View formatted query View runnable query Explain query 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 = ? 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 = 'dynamiques-institutionnelles';
20	0.14 ms	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: [] View formatted query View runnable query Explain query 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 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;
21	0.12 ms	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: [`"ressources-documentaires"`] View formatted query View runnable query Explain query 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 = ? 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 = 'ressources-documentaires';
22	0.12 ms	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: [] View formatted query View runnable query Explain query 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 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;
23	0.14 ms	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: [`62`] View formatted query View runnable query Explain query 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 = ? 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 = 62;
24	0.17 ms	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: [`62`] View formatted query View runnable query Explain query 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 = ? 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 = 62;
25	0.13 ms	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: [`63`] View formatted query View runnable query Explain query 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 = ? 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 = 63;
26	0.12 ms	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: [`113`] View formatted query View runnable query Explain query 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 = ? 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 = 113;
27	0.17 ms	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: [`113`] View formatted query View runnable query Explain query 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 = ? 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 = 113;
28	0.14 ms	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: [`114`] View formatted query View runnable query Explain query 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 = ? 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 = 114;
29	0.12 ms	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: [`49`] View formatted query View runnable query Explain query 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 = ? 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 = 49;
30	0.16 ms	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: [`49`] View formatted query View runnable query Explain query 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 = ? 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 = 49;
31	0.13 ms	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: [`50`] View formatted query View runnable query Explain query 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 = ? 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 = 50;
32	0.11 ms	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: [] View formatted query View runnable query Explain query 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 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;
33	0.28 ms	SELECT COUNT() FROM article t0 WHERE t0.category_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT COUNT() FROM article t0 WHERE t0.category_id = ? SELECT COUNT(*) FROM article t0 WHERE t0.category_id = 1;
34	0.26 ms	SELECT COUNT() FROM article t0 WHERE t0.category_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT COUNT() FROM article t0 WHERE t0.category_id = ? SELECT COUNT(*) FROM article t0 WHERE t0.category_id = 2;
35	0.16 ms	SELECT COUNT() FROM article t0 WHERE t0.category_id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT COUNT() FROM article t0 WHERE t0.category_id = ? SELECT COUNT(*) FROM article t0 WHERE t0.category_id = 3;
36	0.15 ms	SELECT COUNT() FROM article t0 WHERE t0.category_id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT COUNT() FROM article t0 WHERE t0.category_id = ? SELECT COUNT(*) FROM article t0 WHERE t0.category_id = 4;

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\Category	No errors.
App\Entity\Article	No errors.
App\Entity\Media	The field App\Entity\Media#markers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VideoMarker#attachments does not contain the required 'inversedBy="markers"' attribute. The field App\Entity\Media#articles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Article#video does not contain the required 'inversedBy="articles"' attribute.
App\Entity\Comment	No errors.
App\Entity\VideoMarker	No errors.
App\Entity\Tag	No errors.
App\Entity\MediaMetaTag	No errors.

Symfony Profiler

https://cirad.dev-djaka.fr/category/enjeux-fonciers

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping