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 120

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

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 (569, 583, 584, 511, 575, 578, 576, 462, 162, 422, 570, 567, 93, 565, 557, 562, 30, 44, 563, 384, 71, 496, 555, 517) 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 = 569;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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