Symfony Profiler

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;

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
  INNER JOIN video_markers__attachments ON t0.id = video_markers__attachments.attachment_id
WHERE
  video_markers__attachments.video_marker_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 INNER JOIN video_markers__attachments ON t0.id = video_markers__attachments.attachment_id WHERE video_markers__attachments.video_marker_id = 8;

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';

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

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 = 'trente-ans-de-dynamiques-dans-la-vallee' 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 = 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;

SELECT
  COUNT(*)
FROM
  article t0
WHERE
  t0.category_id = ?

SELECT COUNT(*) FROM article t0 WHERE t0.category_id = 1;

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 = 35;

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 = 36;

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;

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;

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 = ?

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 = 15;

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 = ?

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 = 15;

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 (50, 63, 114);

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, 48);

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;