| 1 |
0.97 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo_name AS photo_name_9, t0.meta_keywords AS meta_keywords_10, t0.meta_description AS meta_description_11, t0.content_text AS content_text_12, t0.category_id AS category_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15 FROM blog_article t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"necessity-may-give-us-best-virtual-court"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.intro AS intro_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo_name AS photo_name_9, t0.meta_keywords AS meta_keywords_10, t0.meta_description AS meta_description_11, t0.content_text AS content_text_12, t0.category_id AS category_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15 FROM blog_article t0 WHERE t0.slug = 'necessity-may-give-us-best-virtual-court' LIMIT 1;
|
| 2 |
0.70 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 08:30:36"
]
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 08:30:36' GROUP BY b0_.id ORDER BY sclr_5 DESC;
|
| 3 |
0.46 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: [
2
"2026-02-13 08:30:36"
]
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 <> 2 AND b0_.published_at <= '2026-02-13 08:30:36' ORDER BY b0_.published_at DESC LIMIT 3;
|
| 4 |
0.68 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 08:30:36"
]
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 08:30:36' GROUP BY b0_.id ORDER BY sclr_3 DESC;
|
| 5 |
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;
|
| 6 |
0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_article_blog_tag ON t0.id = blog_article_blog_tag.blog_tag_id WHERE blog_article_blog_tag.blog_article_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_article_blog_tag ON t0.id = blog_article_blog_tag.blog_tag_id WHERE blog_article_blog_tag.blog_article_id = 2;
|