Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.meta_description AS meta_description_4,
  t0.resume AS resume_5,
  t0.texte_description AS texte_description_6,
  t0.site_id AS site_id_7,
  t0.categorie_parent_id AS categorie_parent_id_8
FROM
  categorie t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.meta_description AS meta_description_4, t0.resume AS resume_5, t0.texte_description AS texte_description_6, t0.site_id AS site_id_7, t0.categorie_parent_id AS categorie_parent_id_8 FROM categorie t0 WHERE t0.slug = 'economie' 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 = ?
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;

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;

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;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.bio AS bio_7,
  t0.photo AS photo_8,
  t0.linkedin AS linkedin_9,
  t0.facebook AS facebook_10,
  t0.instagram AS instagram_11,
  t0.site_web AS site_web_12,
  t0.mastodon AS mastodon_13,
  t0.titre AS titre_14,
  t0.twitter AS twitter_15,
  t0.github AS github_16,
  t0.slug AS slug_17,
  t0.affiche_auteur AS affiche_auteur_18
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.photo AS photo_8, t0.linkedin AS linkedin_9, t0.facebook AS facebook_10, t0.instagram AS instagram_11, t0.site_web AS site_web_12, t0.mastodon AS mastodon_13, t0.titre AS titre_14, t0.twitter AS twitter_15, t0.github AS github_16, t0.slug AS slug_17, t0.affiche_auteur AS affiche_auteur_18 FROM utilisateur t0 WHERE t0.id = 2;

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 site s2_ ON a0_.site_id = s2_.id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND a0_.categorie_id = ?
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 site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= '2026-06-17 22:08:40' AND s2_.url_site = 'la-buse.fr' AND a0_.categorie_id = 291 ORDER BY a0_.published_at DESC LIMIT 30;

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,
  a0_.author_id AS author_id_40,
  a0_.categorie_id AS categorie_id_41,
  a0_.site_id AS site_id_42,
  a0_.flux_rss_id AS flux_rss_id_43
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN site s2_ ON a0_.site_id = s2_.id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND a0_.categorie_id = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.published_at DESC

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, a0_.author_id AS author_id_40, a0_.categorie_id AS categorie_id_41, a0_.site_id AS site_id_42, a0_.flux_rss_id AS flux_rss_id_43 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= '2026-06-17 22:08:40' AND s2_.url_site = 'la-buse.fr' AND a0_.categorie_id = 291 AND a0_.id IN (3709, 3689, 3680, 3646, 3641, 3042, 3616, 3596, 3579, 3573, 3568, 3558, 3546, 3544, 3543, 3022, 3541, 3537, 3533, 3517, 3514, 3510, 3502, 3495, 3491, 3480, 3479, 3465, 3448, 3435) ORDER BY a0_.published_at DESC;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN site s2_ ON a0_.site_id = s2_.id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND a0_.categorie_id = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id WHERE a0_.published_at <= '2026-06-17 22:08:40' AND s2_.url_site = 'la-buse.fr' AND a0_.categorie_id = 291;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3709 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3689 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3680 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3646 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3641 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
  INNER JOIN article_tag ON t0.id = article_tag.tag_id
WHERE
  article_tag.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 INNER JOIN article_tag ON t0.id = article_tag.tag_id WHERE article_tag.article_id = 3042 ORDER BY t0.name ASC;