0.95 ms (17.79%)
|
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: [
"business"
"2026-02-13 10:01:26"
4
5
1
3
]
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 = 'business' AND b0_.published_at <= '2026-02-13 10:01:26' AND b0_.id IN (4, 5, 1, 3) ORDER BY b0_.published_at DESC;
|
0.76 ms (14.24%)
|
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: [
"business"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 WHERE t0.slug = 'business' LIMIT 1;
|
0.73 ms (13.62%)
|
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 10:01:26"
]
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 10:01:26' GROUP BY b0_.id ORDER BY sclr_5 DESC;
|
0.72 ms (13.45%)
|
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 10:01:26"
]
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 10:01:26' GROUP BY b0_.id ORDER BY sclr_3 DESC;
|
0.63 ms (11.77%)
|
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: [
"business"
"2026-02-13 10:01:26"
]
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 = 'business' AND b0_.published_at <= '2026-02-13 10:01:26';
|
0.60 ms (11.15%)
|
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 10:01:26"
]
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 10:01:26' ORDER BY b0_.published_at DESC LIMIT 3;
|
0.50 ms (9.37%)
|
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: [
"business"
"2026-02-13 10:01:26"
]
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 = 'business' AND b0_.published_at <= '2026-02-13 10:01:26' ORDER BY b0_.published_at DESC LIMIT 6;
|
0.46 ms (8.60%)
|
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;
|