0.37 ms (9.43%)
|
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 WHERE a0_.published_at <= ? AND s2_.url_site = ? AND a0_.categorie_id = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.published_at DESC
Parameters: [
"2026-06-17 23:32:51"
"la-buse.fr"
302
3245
3383
3233
3211
3210
3208
3382
3160
3095
3364
3362
3347
3339
3337
3331
3327
3318
3314
3311
3306
3305
3293
3281
3283
3282
3266
3269
3262
3257
3255
]
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 23:32:51' AND s2_.url_site = 'la-buse.fr' AND a0_.categorie_id = 302 AND a0_.id IN (3245, 3383, 3233, 3211, 3210, 3208, 3382, 3160, 3095, 3364, 3362, 3347, 3339, 3337, 3331, 3327, 3318, 3314, 3311, 3306, 3305, 3293, 3281, 3283, 3282, 3266, 3269, 3262, 3257, 3255) ORDER BY a0_.published_at DESC;
|
0.14 ms (3.49%)
|
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;
|