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 288

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

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 (506, 204, 504, 398, 404, 501, 380, 290, 434, 487, 74, 389, 386, 467, 400, 357, 376, 381, 482, 293, 377, 374, 370, 341) 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 = 506;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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