| 1 |
0.42 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.publication_date AS publication_date_6, t0.visits_count AS visits_count_7, t0.video_url AS video_url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.deleted AS deleted_12, t0.category AS category_13 FROM page t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.publication_date AS publication_date_6, t0.visits_count AS visits_count_7, t0.video_url AS video_url_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.deleted AS deleted_12, t0.category AS category_13 FROM page t0 WHERE t0.id = 9;
|
| 2 |
0.11 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
0.27 ms |
UPDATE page SET visits_count = ?, updated_at = ? WHERE id = ?
Parameters: [
15
"2026-03-31 17:58:29"
9
]
UPDATE page SET visits_count = 15, updated_at = '2026-03-31 17:58:29' WHERE id = 9;
|
| 4 |
0.68 ms |
"COMMIT"
|
| 5 |
0.30 ms |
SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page_media p0_ WHERE p0_.page_id = ? AND p0_.is_enabled = true ORDER BY p0_.id ASC
SELECT p0_.id AS id_0, p0_.is_enabled AS is_enabled_1, p0_.is_default AS is_default_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.deleted AS deleted_6, p0_.original_filename AS original_filename_7, p0_.path AS path_8, p0_.mime_type AS mime_type_9, p0_.alt AS alt_10, p0_.size AS size_11, p0_.file_updated_at AS file_updated_at_12, p0_.page_id AS page_id_13 FROM page_media p0_ WHERE p0_.page_id = 9 AND p0_.is_enabled = true ORDER BY p0_.id ASC;
|
| 6 |
0.24 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.deleted AS deleted_6, t0.parent_category AS parent_category_7 FROM article_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.deleted AS deleted_6, t0.parent_category AS parent_category_7 FROM article_category t0 WHERE t0.id = 1;
|
| 7 |
0.38 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = ? ORDER BY p0_.created_at DESC LIMIT 5
Parameters: [
"article"
]
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.description AS description_3, p0_.content AS content_4, p0_.publication_date AS publication_date_5, p0_.visits_count AS visits_count_6, p0_.video_url AS video_url_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.deleted_at AS deleted_at_10, p0_.deleted AS deleted_11, p0_.category AS category_12 FROM page p0_ WHERE p0_.type = 'article' ORDER BY p0_.created_at DESC LIMIT 5;
|
| 8 |
0.26 ms |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> ? ORDER BY a0_.label ASC
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE a0_.parent_category IS NULL AND LOWER(a0_.label) <> 'autre' ORDER BY a0_.label ASC;
|
| 9 |
0.25 ms |
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = ? LIMIT 1
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, a0_.deleted_at AS deleted_at_4, a0_.deleted AS deleted_5, a0_.parent_category AS parent_category_6 FROM article_category a0_ WHERE LOWER(a0_.label) = 'autre' LIMIT 1;
|