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 360

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

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 (283, 281, 269, 244, 278, 397, 51, 274, 273, 254, 265, 272, 266, 233, 367, 261, 396, 250, 240, 242, 236, 409, 253, 249) 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 = 283;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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