0.72 ms (14.85%)
|
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, COUNT(b1_.id) AS sclr_5, b0_.parent_id AS parent_id_6, b0_.created_by_id AS created_by_id_7, b0_.updated_by_id AS updated_by_id_8 FROM blog_category b0_ LEFT JOIN blog_article b1_ ON b0_.id = b1_.category_id WHERE b1_.published_at <= ? GROUP BY b0_.id ORDER BY sclr_5 DESC
Parameters: [
"2026-02-13 09:59:06"
]
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, COUNT(b1_.id) AS sclr_5, b0_.parent_id AS parent_id_6, b0_.created_by_id AS created_by_id_7, b0_.updated_by_id AS updated_by_id_8 FROM blog_category b0_ LEFT JOIN blog_article b1_ ON b0_.id = b1_.category_id WHERE b1_.published_at <= '2026-02-13 09:59:06' GROUP BY b0_.id ORDER BY sclr_5 DESC;
|
0.71 ms (14.66%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"strategy"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = 'strategy' LIMIT 1;
|
0.69 ms (14.39%)
|
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(b1_.id) AS sclr_3 FROM blog_tag b0_ LEFT JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_tag_id LEFT JOIN blog_article b1_ ON b1_.id = b2_.blog_article_id WHERE b1_.published_at <= ? GROUP BY b0_.id ORDER BY sclr_3 DESC
Parameters: [
"2026-02-13 09:59:06"
]
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, COUNT(b1_.id) AS sclr_3 FROM blog_tag b0_ LEFT JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_tag_id LEFT JOIN blog_article b1_ ON b1_.id = b2_.blog_article_id WHERE b1_.published_at <= '2026-02-13 09:59:06' GROUP BY b0_.id ORDER BY sclr_3 DESC;
|
0.62 ms (12.78%)
|
1 |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = ? AND b0_.published_at <= ?
Parameters: [
"strategy"
"2026-02-13 09:59:06"
]
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_article b0_ INNER JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = 'strategy' AND b0_.published_at <= '2026-02-13 09:59:06';
|
0.58 ms (12.01%)
|
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.intro AS intro_3, b0_.content AS content_4, b0_.published_at AS published_at_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.photo_name AS photo_name_8, b0_.meta_keywords AS meta_keywords_9, b0_.meta_description AS meta_description_10, b0_.content_text AS content_text_11, b0_.category_id AS category_id_12, b0_.created_by_id AS created_by_id_13, b0_.updated_by_id AS updated_by_id_14 FROM blog_article b0_ WHERE b0_.id <> ? AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 3
Parameters: [
0
"2026-02-13 09:59:06"
]
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.intro AS intro_3, b0_.content AS content_4, b0_.published_at AS published_at_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.photo_name AS photo_name_8, b0_.meta_keywords AS meta_keywords_9, b0_.meta_description AS meta_description_10, b0_.content_text AS content_text_11, b0_.category_id AS category_id_12, b0_.created_by_id AS created_by_id_13, b0_.updated_by_id AS updated_by_id_14 FROM blog_article b0_ WHERE b0_.id <> 0 AND b0_.published_at <= '2026-02-13 09:59:06' ORDER BY b0_.published_at DESC LIMIT 3;
|
0.57 ms (11.92%)
|
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.intro AS intro_3, b0_.content AS content_4, b0_.published_at AS published_at_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.photo_name AS photo_name_8, b0_.meta_keywords AS meta_keywords_9, b0_.meta_description AS meta_description_10, b0_.content_text AS content_text_11, b0_.category_id AS category_id_12, b0_.created_by_id AS created_by_id_13, b0_.updated_by_id AS updated_by_id_14 FROM blog_article b0_ INNER JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = ? AND b0_.published_at <= ? AND b0_.id IN (?) ORDER BY b0_.published_at DESC
Parameters: [
"strategy"
"2026-02-13 09:59:06"
2
]
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.intro AS intro_3, b0_.content AS content_4, b0_.published_at AS published_at_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.photo_name AS photo_name_8, b0_.meta_keywords AS meta_keywords_9, b0_.meta_description AS meta_description_10, b0_.content_text AS content_text_11, b0_.category_id AS category_id_12, b0_.created_by_id AS created_by_id_13, b0_.updated_by_id AS updated_by_id_14 FROM blog_article b0_ INNER JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = 'strategy' AND b0_.published_at <= '2026-02-13 09:59:06' AND b0_.id IN (2) ORDER BY b0_.published_at DESC;
|
0.48 ms (9.96%)
|
1 |
SELECT DISTINCT b0_.id AS id_0, b0_.published_at AS published_at_1 FROM blog_article b0_ INNER JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = ? AND b0_.published_at <= ? ORDER BY b0_.published_at DESC LIMIT 6
Parameters: [
"strategy"
"2026-02-13 09:59:06"
]
SELECT DISTINCT b0_.id AS id_0, b0_.published_at AS published_at_1 FROM blog_article b0_ INNER JOIN blog_article_blog_tag b2_ ON b0_.id = b2_.blog_article_id INNER JOIN blog_tag b1_ ON b1_.id = b2_.blog_tag_id WHERE b1_.slug = 'strategy' AND b0_.published_at <= '2026-02-13 09:59:06' ORDER BY b0_.published_at DESC LIMIT 6;
|
0.46 ms (9.44%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.created_at AS created_at_7, t0.is_actif AS is_actif_8, t0.mobile AS mobile_9, t0.reference AS reference_10, t0.photo_name AS photo_name_11, t0.updated_at AS updated_at_12, t0.token_password AS token_password_13 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.created_at AS created_at_7, t0.is_actif AS is_actif_8, t0.mobile AS mobile_9, t0.reference AS reference_10, t0.photo_name AS photo_name_11, t0.updated_at AS updated_at_12, t0.token_password AS token_password_13 FROM user t0 WHERE t0.id = 1;
|