3.43 ms (45.44%)
|
35 |
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.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 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.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 WHERE t0.categorie_id = 282 ORDER BY t0.published_at DESC;
|
1.02 ms (13.44%)
|
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
Parameters: [
"2026-06-17 22:01:11"
"la-buse.fr"
201
]
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-17 22:01:11' AND s2_.url_site = 'la-buse.fr' AND m3_.id = 201 ORDER BY a0_.published_at DESC LIMIT 30;
|
0.78 ms (10.36%)
|
1 |
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 = ?
Parameters: [
"2026-06-17 22:01:11"
"la-buse.fr"
201
]
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-17 22:01:11' AND s2_.url_site = 'la-buse.fr' AND m3_.id = 201;
|
0.59 ms (7.80%)
|
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, a0_.author_id AS author_id_22, a0_.categorie_id AS categorie_id_23, a0_.site_id AS site_id_24, a0_.flux_rss_id AS flux_rss_id_25 FROM article a0_ WHERE a0_.site_id = ? ORDER BY a0_.published_at DESC LIMIT 5
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, a0_.author_id AS author_id_22, a0_.categorie_id AS categorie_id_23, a0_.site_id AS site_id_24, a0_.flux_rss_id AS flux_rss_id_25 FROM article a0_ WHERE a0_.site_id = 2 ORDER BY a0_.published_at DESC LIMIT 5;
|
0.47 ms (6.20%)
|
6 |
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
Parameters: [
"la-buse.fr"
]
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;
|
0.37 ms (4.91%)
|
5 |
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.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = ?
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.instagram_published_at AS instagram_published_at_21, t0.image_format AS image_format_22, t0.author_id AS author_id_23, t0.categorie_id AS categorie_id_24, t0.site_id AS site_id_25, t0.flux_rss_id AS flux_rss_id_26 FROM article t0 INNER JOIN article_tag ON t0.id = article_tag.article_id WHERE article_tag.tag_id = 284;
|
0.15 ms (1.98%)
|
2 |
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 = 297;
|
0.13 ms (1.75%)
|
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, 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 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
Parameters: [
"2026-06-17 22:01:11"
"la-buse.fr"
201
4384
4385
]
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
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, 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 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-17 22:01:11' AND s2_.url_site = 'la-buse.fr' AND m3_.id = 201 AND a0_.id IN (4384, 4385) ORDER BY a0_.published_at DESC;
|
0.13 ms (1.69%)
|
2 |
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 = 4384 ORDER BY t0.name ASC;
|
0.11 ms (1.39%)
|
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;
|
0.09 ms (1.15%)
|
1 |
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 = 'France' LIMIT 1;
|
0.08 ms (1.11%)
|
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 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.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 INNER JOIN mot_cle_site ON t0.id = mot_cle_site.site_id WHERE mot_cle_site.tag_id = 201;
|
0.08 ms (1.01%)
|
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 = 2 AND t0.categorie_parent_id IS NULL ORDER BY t0.nom DESC;
|
0.07 ms (0.95%)
|
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM mot_cle m0_ INNER JOIN mot_cle_site m2_ ON m0_.id = m2_.tag_id INNER JOIN site s1_ ON s1_.id = m2_.site_id WHERE s1_.id = ? ORDER BY m0_.name ASC
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM mot_cle m0_ INNER JOIN mot_cle_site m2_ ON m0_.id = m2_.tag_id INNER JOIN site s1_ ON s1_.id = m2_.site_id WHERE s1_.id = 2 ORDER BY m0_.name ASC;
|
0.06 ms (0.82%)
|
1 |
SELECT s0_.id AS id_0 FROM site s1_ INNER JOIN site_site s2_ ON s1_.id = s2_.site_source INNER JOIN site s0_ ON s0_.id = s2_.site_target WHERE s1_.id = ?
SELECT s0_.id AS id_0 FROM site s1_ INNER JOIN site_site s2_ ON s1_.id = s2_.site_source INNER JOIN site s0_ ON s0_.id = s2_.site_target WHERE s1_.id = 2;
|