Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  article_type t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_type t0 WHERE t0.slug = 'a-la-une' LIMIT 1;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.type_id = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.type_id = 3;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
FROM
  article a0_
WHERE
  a0_.type_id = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  24 OFFSET 336

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM article a0_ WHERE a0_.type_id = 3 ORDER BY a0_.created_at DESC LIMIT 24 OFFSET 336;

SELECT
  a0_.important AS important_0,
  a0_.id AS id_1,
  a0_.tmp_old_ids AS tmp_old_ids_2,
  a0_.name AS name_3,
  a0_.title AS title_4,
  a0_.slug AS slug_5,
  a0_.chapo AS chapo_6,
  a0_.content AS content_7,
  a0_.tmp_keywords AS tmp_keywords_8,
  a0_.priority AS priority_9,
  a0_.published AS published_10,
  a0_.created_at AS created_at_11,
  a0_.updated_at AS updated_at_12,
  a0_.type_id AS type_id_13
FROM
  article a0_
WHERE
  a0_.type_id = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.created_at DESC

SELECT a0_.important AS important_0, a0_.id AS id_1, a0_.tmp_old_ids AS tmp_old_ids_2, a0_.name AS name_3, a0_.title AS title_4, a0_.slug AS slug_5, a0_.chapo AS chapo_6, a0_.content AS content_7, a0_.tmp_keywords AS tmp_keywords_8, a0_.priority AS priority_9, a0_.published AS published_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.type_id AS type_id_13 FROM article a0_ WHERE a0_.type_id = 3 AND a0_.id IN (319, 320, 315, 286, 313, 312, 153, 309, 307, 531, 239, 199, 256, 352, 300, 295, 296, 167, 430, 292, 291, 289, 76, 97) ORDER BY a0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 319;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 320;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 315;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 286;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 313;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 312;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 153;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 309;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 307;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 531;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 239;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 199;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 256;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 352;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 300;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 295;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 296;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 167;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 430;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 292;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 291;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 289;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 76;

SELECT
  t0.id AS id_1,
  t0.tmp_old_id AS tmp_old_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.size AS size_5,
  t0.role AS role_6,
  t0.types AS types_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.picto_theme AS picto_theme_10
FROM
  media t0
  INNER JOIN media_article ON t0.id = media_article.media_id
WHERE
  media_article.article_id = ?

SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = 97;