| 1 |
0.12 ms |
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 = 'rue' LIMIT 1;
|
| 2 |
0.11 ms |
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;
|
| 3 |
0.09 ms |
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;
|
| 4 |
0.10 ms |
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 = 252;
|
| 5 |
0.10 ms |
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;
|
| 6 |
0.10 ms |
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;
|
| 7 |
1.74 ms |
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 23:32:40"
"la-buse.fr"
252
]
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 23:32:40' AND s2_.url_site = 'la-buse.fr' AND m3_.id = 252 ORDER BY a0_.published_at DESC LIMIT 30;
|
| 8 |
0.14 ms |
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 23:32:40"
"la-buse.fr"
252
3759
]
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 23:32:40' AND s2_.url_site = 'la-buse.fr' AND m3_.id = 252 AND a0_.id IN (3759) ORDER BY a0_.published_at DESC;
|
| 9 |
1.22 ms |
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 23:32:40"
"la-buse.fr"
252
]
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 23:32:40' AND s2_.url_site = 'la-buse.fr' AND m3_.id = 252;
|
| 10 |
0.11 ms |
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 = 307;
|
| 11 |
0.13 ms |
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 = 3759 ORDER BY t0.name ASC;
|