| 1 |
1.93 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.content_summary AS content_summary_5, t0.tags AS tags_6, t0.main_image AS main_image_7, t0.hit_count AS hit_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_published AS is_published_11, t0.publish_at AS publish_at_12, t0.seo_description AS seo_description_13, t0.seo_title AS seo_title_14, t0.seo_keywords AS seo_keywords_15, t0.slug AS slug_16 FROM post t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.content AS content_4, t0.content_summary AS content_summary_5, t0.tags AS tags_6, t0.main_image AS main_image_7, t0.hit_count AS hit_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_published AS is_published_11, t0.publish_at AS publish_at_12, t0.seo_description AS seo_description_13, t0.seo_title AS seo_title_14, t0.seo_keywords AS seo_keywords_15, t0.slug AS slug_16 FROM post t0 WHERE t0.id = '39';
|
| 2 |
29.05 ms |
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = ? AND t0.start_day_time = ? LIMIT 1
Parameters: [
39
"2026-04-15"
]
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = 39 AND t0.start_day_time = '2026-04-15' LIMIT 1;
|
| 3 |
0.28 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 4 |
0.90 ms |
UPDATE post_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters: [
3
"2026-04-15 04:04:39"
60058
]
UPDATE post_view_stats SET hit_count = 3, updated_at = '2026-04-15 04:04:39' WHERE id = 60058;
|
| 5 |
0.32 ms |
SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2;
|
| 6 |
0.54 ms |
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"post-update"
"App\Entity\PostViewStats"
"60058"
null
"2026-04-15 04:04:39"
"No user"
""[]""
]
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES ('post-update', 'App\\Entity\\PostViewStats', '60058', NULL, '2026-04-15 04:04:39', 'No user', '\"[]\"');
|
| 7 |
0.25 ms |
RELEASE SAVEPOINT DOCTRINE_2
RELEASE SAVEPOINT DOCTRINE_2;
|
| 8 |
0.32 ms |
"COMMIT"
|
| 9 |
23.14 ms |
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = ? AND t0.start_day_time = ? LIMIT 1
Parameters: [
4
"2026-04-15"
]
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.post_id AS post_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM post_view_stats t0 WHERE t0.post_id = 4 AND t0.start_day_time = '2026-04-15' LIMIT 1;
|
| 10 |
0.26 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
0.33 ms |
UPDATE post_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters: [
37924
"2026-04-15 04:04:39"
59953
]
UPDATE post_view_stats SET hit_count = 37924, updated_at = '2026-04-15 04:04:39' WHERE id = 59953;
|
| 12 |
0.56 ms |
SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2;
|
| 13 |
0.70 ms |
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"post-update"
"App\Entity\PostViewStats"
"59953"
null
"2026-04-15 04:04:39"
"No user"
""[]""
]
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES ('post-update', 'App\\Entity\\PostViewStats', '59953', NULL, '2026-04-15 04:04:39', 'No user', '\"[]\"');
|
| 14 |
0.32 ms |
RELEASE SAVEPOINT DOCTRINE_2
RELEASE SAVEPOINT DOCTRINE_2;
|
| 15 |
0.36 ms |
"COMMIT"
|