| 1 |
11.80 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.photo AS photo_16, c1_.description AS description_17, u2_.id AS id_18, u2_.email AS email_19, u2_.roles AS roles_20, u2_.password AS password_21, u2_.name AS name_22, u2_.gender AS gender_23, p0_.created_by_id AS created_by_id_24, c1_.parent_id AS parent_id_25 FROM post p0_ LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN user u2_ ON p0_.created_by_id = u2_.id WHERE p0_.published = 1 AND p0_.slug = ?
Parameters: [
"installation-electrique-sur-toiture"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.name AS name_14, c1_.slug AS slug_15, c1_.photo AS photo_16, c1_.description AS description_17, u2_.id AS id_18, u2_.email AS email_19, u2_.roles AS roles_20, u2_.password AS password_21, u2_.name AS name_22, u2_.gender AS gender_23, p0_.created_by_id AS created_by_id_24, c1_.parent_id AS parent_id_25 FROM post p0_ LEFT JOIN post_category p3_ ON p0_.id = p3_.post_id LEFT JOIN category c1_ ON c1_.id = p3_.category_id LEFT JOIN user u2_ ON p0_.created_by_id = u2_.id WHERE p0_.published = 1 AND p0_.slug = 'installation-electrique-sur-toiture';
|
| 2 |
0.82 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at > ? AND p0_.published = 1 ORDER BY p0_.updated_at ASC LIMIT 1
Parameters: [
"2025-08-21 16:27:39"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at > '2025-08-21 16:27:39' AND p0_.published = 1 ORDER BY p0_.updated_at ASC LIMIT 1;
|
| 3 |
0.46 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at < ? AND p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 1
Parameters: [
"2025-08-21 16:27:39"
]
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.updated_at < '2025-08-21 16:27:39' AND p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 1;
|
| 5 |
0.62 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 5
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.brief AS brief_3, p0_.content AS content_4, p0_.source AS source_5, p0_.photo AS photo_6, p0_.seo_title AS seo_title_7, p0_.seo_desc AS seo_desc_8, p0_.published AS published_9, p0_.deleted_at AS deleted_at_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.created_by_id AS created_by_id_13 FROM post p0_ WHERE p0_.published = 1 ORDER BY p0_.updated_at DESC LIMIT 5;
|