| 1 |
0.84 ms |
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: [
"startup"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = 'startup' LIMIT 1;
|
| 2 |
0.76 ms |
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:58:08"
]
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:58:08' GROUP BY b0_.id ORDER BY sclr_5 DESC;
|
| 3 |
0.60 ms |
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:58:08"
]
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:58:08' ORDER BY b0_.published_at DESC LIMIT 3;
|
| 4 |
0.72 ms |
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:58:08"
]
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:58:08' GROUP BY b0_.id ORDER BY sclr_3 DESC;
|
| 5 |
0.64 ms |
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: [
"startup"
"2026-02-13 09:58:08"
]
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 = 'startup' AND b0_.published_at <= '2026-02-13 09:58:08';
|
| 6 |
0.54 ms |
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: [
"startup"
"2026-02-13 09:58:08"
]
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 = 'startup' AND b0_.published_at <= '2026-02-13 09:58:08' ORDER BY b0_.published_at DESC LIMIT 6;
|
| 7 |
0.97 ms |
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: [
"startup"
"2026-02-13 09:58:08"
1
2
4
5
]
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 = 'startup' AND b0_.published_at <= '2026-02-13 09:58:08' AND b0_.id IN (1, 2, 4, 5) ORDER BY b0_.published_at DESC;
|
| 8 |
0.46 ms |
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;
|