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

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

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

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 = 'grands-temoins' 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 = 3
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 = 3 ORDER BY a0_.position ASC;

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.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 (116, 118, 120, 122, 78, 80, 82, 84, 86, 88, 90, 92, 94, 96, 98, 100, 102, 104, 106, 108, 110);

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

SELECT COUNT(*) FROM article t0 WHERE t0.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 = 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 = 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 = 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.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.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;