Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  mot_cle t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM mot_cle t0 WHERE t0.slug = 'faucon crécerelle' 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.auteur_principal_id AS auteur_principal_id_12
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.auteur_principal_id AS auteur_principal_id_12 FROM site t0 WHERE t0.url_site = 'au-jardin.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.auteur_principal_id AS auteur_principal_id_12
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.auteur_principal_id AS auteur_principal_id_12 FROM site t0 WHERE t0.url_site = 'au-jardin.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.auteur_principal_id AS auteur_principal_id_12
FROM
  site t0
  INNER JOIN mot_cle_site ON t0.id = mot_cle_site.site_id
WHERE
  mot_cle_site.tag_id = ?

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.auteur_principal_id AS auteur_principal_id_12 FROM site t0 INNER JOIN mot_cle_site ON t0.id = mot_cle_site.site_id WHERE mot_cle_site.tag_id = 189;

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.auteur_principal_id AS auteur_principal_id_12
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.auteur_principal_id AS auteur_principal_id_12 FROM site t0 WHERE t0.url_site = 'au-jardin.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 = 1;

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
  LEFT JOIN article_tag a4_ ON a0_.id = a4_.article_id
  LEFT JOIN mot_cle m3_ ON m3_.id = a4_.tag_id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND m3_.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 LEFT JOIN article_tag a4_ ON a0_.id = a4_.article_id LEFT JOIN mot_cle m3_ ON m3_.id = a4_.tag_id WHERE a0_.published_at <= '2026-06-14 18:06:59' AND s2_.url_site = 'au-jardin.fr' AND m3_.id = 189 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,
  u1_.id AS id_20,
  u1_.full_name AS full_name_21,
  u1_.username AS username_22,
  u1_.email AS email_23,
  u1_.password AS password_24,
  u1_.roles AS roles_25,
  u1_.bio AS bio_26,
  u1_.photo AS photo_27,
  u1_.linkedin AS linkedin_28,
  u1_.facebook AS facebook_29,
  u1_.instagram AS instagram_30,
  u1_.site_web AS site_web_31,
  u1_.mastodon AS mastodon_32,
  u1_.titre AS titre_33,
  u1_.twitter AS twitter_34,
  u1_.github AS github_35,
  u1_.slug AS slug_36,
  u1_.affiche_auteur AS affiche_auteur_37,
  a0_.author_id AS author_id_38,
  a0_.categorie_id AS categorie_id_39,
  a0_.site_id AS site_id_40,
  a0_.flux_rss_id AS flux_rss_id_41
FROM
  article a0_
  INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id
  LEFT JOIN site s2_ ON a0_.site_id = s2_.id
  LEFT JOIN article_tag a4_ ON a0_.id = a4_.article_id
  LEFT JOIN mot_cle m3_ ON m3_.id = a4_.tag_id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND m3_.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, u1_.id AS id_20, u1_.full_name AS full_name_21, u1_.username AS username_22, u1_.email AS email_23, u1_.password AS password_24, u1_.roles AS roles_25, u1_.bio AS bio_26, u1_.photo AS photo_27, u1_.linkedin AS linkedin_28, u1_.facebook AS facebook_29, u1_.instagram AS instagram_30, u1_.site_web AS site_web_31, u1_.mastodon AS mastodon_32, u1_.titre AS titre_33, u1_.twitter AS twitter_34, u1_.github AS github_35, u1_.slug AS slug_36, u1_.affiche_auteur AS affiche_auteur_37, a0_.author_id AS author_id_38, a0_.categorie_id AS categorie_id_39, a0_.site_id AS site_id_40, a0_.flux_rss_id AS flux_rss_id_41 FROM article a0_ INNER JOIN utilisateur u1_ ON a0_.author_id = u1_.id LEFT JOIN site s2_ ON a0_.site_id = s2_.id LEFT JOIN article_tag a4_ ON a0_.id = a4_.article_id LEFT JOIN mot_cle m3_ ON m3_.id = a4_.tag_id WHERE a0_.published_at <= '2026-06-14 18:06:59' AND s2_.url_site = 'au-jardin.fr' AND m3_.id = 189 AND a0_.id IN (692) 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
  LEFT JOIN article_tag a4_ ON a0_.id = a4_.article_id
  LEFT JOIN mot_cle m3_ ON m3_.id = a4_.tag_id
WHERE
  a0_.published_at <= ?
  AND s2_.url_site = ?
  AND m3_.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 LEFT JOIN article_tag a4_ ON a0_.id = a4_.article_id LEFT JOIN mot_cle m3_ ON m3_.id = a4_.tag_id WHERE a0_.published_at <= '2026-06-14 18:06:59' AND s2_.url_site = 'au-jardin.fr' AND m3_.id = 189;

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.id = ?

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

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 = 692 ORDER BY t0.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.auteur_principal_id AS auteur_principal_id_12
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.auteur_principal_id AS auteur_principal_id_12 FROM site t0 WHERE t0.url_site = 'au-jardin.fr' 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.site_id = ?
  AND t0.categorie_parent_id IS NULL
ORDER BY
  t0.nom DESC

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.site_id = 1 AND t0.categorie_parent_id IS NULL ORDER BY t0.nom DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.summary AS summary_4,
  t0.content AS content_5,
  t0.published_at AS published_at_6,
  t0.link AS link_7,
  t0.image AS image_8,
  t0.old_slug AS old_slug_9,
  t0.dossier AS dossier_10,
  t0.fichier_image AS fichier_image_11,
  t0.publie AS publie_12,
  t0.date_modif_at AS date_modif_at_13,
  t0.en_avant AS en_avant_14,
  t0.editeur AS editeur_15,
  t0.credit AS credit_16,
  t0.meta_description AS meta_description_17,
  t0.note AS note_18,
  t0.source AS source_19,
  t0.guid AS guid_20,
  t0.author_id AS author_id_21,
  t0.categorie_id AS categorie_id_22,
  t0.site_id AS site_id_23,
  t0.flux_rss_id AS flux_rss_id_24
FROM
  article t0
WHERE
  t0.categorie_id = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.link AS link_7, t0.image AS image_8, t0.old_slug AS old_slug_9, t0.dossier AS dossier_10, t0.fichier_image AS fichier_image_11, t0.publie AS publie_12, t0.date_modif_at AS date_modif_at_13, t0.en_avant AS en_avant_14, t0.editeur AS editeur_15, t0.credit AS credit_16, t0.meta_description AS meta_description_17, t0.note AS note_18, t0.source AS source_19, t0.guid AS guid_20, t0.author_id AS author_id_21, t0.categorie_id AS categorie_id_22, t0.site_id AS site_id_23, t0.flux_rss_id AS flux_rss_id_24 FROM article t0 WHERE t0.categorie_id = 273 ORDER BY t0.published_at DESC;