Symfony Profiler

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.published_at AS published_at_1
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN article_tag a3_ ON a0_.id = a3_.article_id
  LEFT JOIN mot_cle m2_ ON m2_.id = a3_.tag_id
  LEFT JOIN site s4_ ON a0_.site_id = s4_.id
WHERE
  a0_.published_at <= ?
  AND (
    s4_.url_site = ?
    OR s4_.url_site = ?
  )
ORDER BY
  a0_.published_at DESC
LIMIT
  30

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN article_tag a3_ ON a0_.id = a3_.article_id LEFT JOIN mot_cle m2_ ON m2_.id = a3_.tag_id LEFT JOIN site s4_ ON a0_.site_id = s4_.id WHERE a0_.published_at <= '2026-06-17 23:25:27' AND (s4_.url_site = 'la-buse.fr' OR s4_.url_site = 1) ORDER BY a0_.published_at DESC LIMIT 30;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN article_tag a3_ ON a0_.id = a3_.article_id
  LEFT JOIN mot_cle m2_ ON m2_.id = a3_.tag_id
  LEFT JOIN site s4_ ON a0_.site_id = s4_.id
WHERE
  a0_.published_at <= ?
  AND (
    s4_.url_site = ?
    OR s4_.url_site = ?
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN article_tag a3_ ON a0_.id = a3_.article_id LEFT JOIN mot_cle m2_ ON m2_.id = a3_.tag_id LEFT JOIN site s4_ ON a0_.site_id = s4_.id WHERE a0_.published_at <= '2026-06-17 23:25:27' AND (s4_.url_site = 'la-buse.fr' OR s4_.url_site = 1);

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.summary AS summary_3,
  a0_.content AS content_4,
  a0_.published_at AS published_at_5,
  a0_.link AS link_6,
  a0_.image AS image_7,
  a0_.old_slug AS old_slug_8,
  a0_.dossier AS dossier_9,
  a0_.fichier_image AS fichier_image_10,
  a0_.publie AS publie_11,
  a0_.date_modif_at AS date_modif_at_12,
  a0_.en_avant AS en_avant_13,
  a0_.editeur AS editeur_14,
  a0_.credit AS credit_15,
  a0_.meta_description AS meta_description_16,
  a0_.note AS note_17,
  a0_.source AS source_18,
  a0_.guid AS guid_19,
  a0_.instagram_published_at AS instagram_published_at_20,
  a0_.image_format AS image_format_21,
  u1_.id AS id_22,
  u1_.full_name AS full_name_23,
  u1_.username AS username_24,
  u1_.email AS email_25,
  u1_.password AS password_26,
  u1_.roles AS roles_27,
  u1_.bio AS bio_28,
  u1_.photo AS photo_29,
  u1_.linkedin AS linkedin_30,
  u1_.facebook AS facebook_31,
  u1_.instagram AS instagram_32,
  u1_.site_web AS site_web_33,
  u1_.mastodon AS mastodon_34,
  u1_.titre AS titre_35,
  u1_.twitter AS twitter_36,
  u1_.github AS github_37,
  u1_.slug AS slug_38,
  u1_.affiche_auteur AS affiche_auteur_39,
  m2_.id AS id_40,
  m2_.name AS name_41,
  m2_.slug AS slug_42,
  a0_.author_id AS author_id_43,
  a0_.categorie_id AS categorie_id_44,
  a0_.site_id AS site_id_45,
  a0_.flux_rss_id AS flux_rss_id_46
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN article_tag a3_ ON a0_.id = a3_.article_id
  LEFT JOIN mot_cle m2_ ON m2_.id = a3_.tag_id
  LEFT JOIN site s4_ ON a0_.site_id = s4_.id
WHERE
  a0_.published_at <= ?
  AND (
    s4_.url_site = ?
    OR s4_.url_site = ?
  )
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.published_at DESC,
  m2_.name ASC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.summary AS summary_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.link AS link_6, a0_.image AS image_7, a0_.old_slug AS old_slug_8, a0_.dossier AS dossier_9, a0_.fichier_image AS fichier_image_10, a0_.publie AS publie_11, a0_.date_modif_at AS date_modif_at_12, a0_.en_avant AS en_avant_13, a0_.editeur AS editeur_14, a0_.credit AS credit_15, a0_.meta_description AS meta_description_16, a0_.note AS note_17, a0_.source AS source_18, a0_.guid AS guid_19, a0_.instagram_published_at AS instagram_published_at_20, a0_.image_format AS image_format_21, u1_.id AS id_22, u1_.full_name AS full_name_23, u1_.username AS username_24, u1_.email AS email_25, u1_.password AS password_26, u1_.roles AS roles_27, u1_.bio AS bio_28, u1_.photo AS photo_29, u1_.linkedin AS linkedin_30, u1_.facebook AS facebook_31, u1_.instagram AS instagram_32, u1_.site_web AS site_web_33, u1_.mastodon AS mastodon_34, u1_.titre AS titre_35, u1_.twitter AS twitter_36, u1_.github AS github_37, u1_.slug AS slug_38, u1_.affiche_auteur AS affiche_auteur_39, m2_.id AS id_40, m2_.name AS name_41, m2_.slug AS slug_42, a0_.author_id AS author_id_43, a0_.categorie_id AS categorie_id_44, a0_.site_id AS site_id_45, a0_.flux_rss_id AS flux_rss_id_46 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN article_tag a3_ ON a0_.id = a3_.article_id LEFT JOIN mot_cle m2_ ON m2_.id = a3_.tag_id LEFT JOIN site s4_ ON a0_.site_id = s4_.id WHERE a0_.published_at <= '2026-06-17 23:25:27' AND (s4_.url_site = 'la-buse.fr' OR s4_.url_site = 1) AND a0_.id IN (4384, 4385, 4358, 3759, 3758, 3753, 3757, 3750, 4386, 4387, 3748, 3747, 3746, 3745, 3744, 3743, 3742, 3741, 3740, 3739, 3738, 3737, 3736, 3735, 3734, 3733, 3732, 3731, 3730, 3729) ORDER BY a0_.published_at DESC, m2_.name ASC;

SELECT
  t0.id AS id_1,
  t0.nom_site AS nom_site_2,
  t0.url_site AS url_site_3,
  t0.meta_description AS meta_description_4,
  t0.meta_mots_cles AS meta_mots_cles_5,
  t0.description AS description_6,
  t0.meta_title AS meta_title_7,
  t0.a_propos AS a_propos_8,
  t0.titre_apropos AS titre_apropos_9,
  t0.slug_apropos AS slug_apropos_10,
  t0.resume_apropos AS resume_apropos_11,
  t0.instagram_user_id AS instagram_user_id_12,
  t0.instagram_access_token AS instagram_access_token_13,
  t0.image_format_default AS image_format_default_14,
  t0.auteur_principal_id AS auteur_principal_id_15
FROM
  site t0
WHERE
  t0.url_site = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url_site AS url_site_3, t0.meta_description AS meta_description_4, t0.meta_mots_cles AS meta_mots_cles_5, t0.description AS description_6, t0.meta_title AS meta_title_7, t0.a_propos AS a_propos_8, t0.titre_apropos AS titre_apropos_9, t0.slug_apropos AS slug_apropos_10, t0.resume_apropos AS resume_apropos_11, t0.instagram_user_id AS instagram_user_id_12, t0.instagram_access_token AS instagram_access_token_13, t0.image_format_default AS image_format_default_14, t0.auteur_principal_id AS auteur_principal_id_15 FROM site t0 WHERE t0.url_site = 'la-buse.fr' LIMIT 1;