| 1 |
6.35 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.capital AS capital_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.about AS about_7, t8.id AS id_9, t8.info AS info_10, t8.imgage1_url AS imgage1_url_11, t8.image2_url AS image2_url_12, t8.image3_url AS image3_url_13, t8.created_at AS created_at_14, t8.updated_at AS updated_at_15, t8.seo_title AS seo_title_16, t8.seo_description AS seo_description_17, t8.seo_keywords AS seo_keywords_18, t8.hit_count AS hit_count_19, t8.county_id AS county_id_20 FROM county t0 LEFT JOIN county_information t8 ON t8.county_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.capital AS capital_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.about AS about_7, t8.id AS id_9, t8.info AS info_10, t8.imgage1_url AS imgage1_url_11, t8.image2_url AS image2_url_12, t8.image3_url AS image3_url_13, t8.created_at AS created_at_14, t8.updated_at AS updated_at_15, t8.seo_title AS seo_title_16, t8.seo_description AS seo_description_17, t8.seo_keywords AS seo_keywords_18, t8.hit_count AS hit_count_19, t8.county_id AS county_id_20 FROM county t0 LEFT JOIN county_information t8 ON t8.county_id = t0.id WHERE t0.id = '39';
|
| 2 |
20.24 ms |
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.county_id AS county_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM county_view_stats t0 WHERE t0.county_id = ? AND t0.start_day_time = ? LIMIT 1
Parameters: [
40
"2026-04-15"
]
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.county_id AS county_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM county_view_stats t0 WHERE t0.county_id = 40 AND t0.start_day_time = '2026-04-15' LIMIT 1;
|
| 3 |
0.23 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 4 |
0.94 ms |
UPDATE county_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters: [
4
"2026-04-15 05:26:08"
28961
]
UPDATE county_view_stats SET hit_count = 4, updated_at = '2026-04-15 05:26:08' WHERE id = 28961;
|
| 5 |
0.53 ms |
SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2;
|
| 6 |
0.71 ms |
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"post-update"
"App\Entity\CountyViewStats"
"28961"
null
"2026-04-15 05:26:08"
"No user"
""[]""
]
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES ('post-update', 'App\\Entity\\CountyViewStats', '28961', NULL, '2026-04-15 05:26:08', 'No user', '\"[]\"');
|
| 7 |
0.36 ms |
RELEASE SAVEPOINT DOCTRINE_2
RELEASE SAVEPOINT DOCTRINE_2;
|
| 8 |
0.47 ms |
"COMMIT"
|
| 9 |
18.42 ms |
SELECT t0.id AS id_1, t0.start_day_time AS start_day_time_2, t0.county_id AS county_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM county_view_stats t0 WHERE t0.county_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.county_id AS county_id_3, t0.hit_count AS hit_count_4, t0.updated_at AS updated_at_5 FROM county_view_stats t0 WHERE t0.county_id = 39 AND t0.start_day_time = '2026-04-15' LIMIT 1;
|
| 10 |
0.27 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 11 |
0.40 ms |
UPDATE county_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters: [
2
"2026-04-15 05:26:08"
28983
]
UPDATE county_view_stats SET hit_count = 2, updated_at = '2026-04-15 05:26:08' WHERE id = 28983;
|
| 12 |
0.24 ms |
SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2;
|
| 13 |
0.36 ms |
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: [
"post-update"
"App\Entity\CountyViewStats"
"28983"
null
"2026-04-15 05:26:08"
"No user"
""[]""
]
INSERT INTO audit_log (action, entity, entity_id, user, log_time, action_description, value_object) VALUES ('post-update', 'App\\Entity\\CountyViewStats', '28983', NULL, '2026-04-15 05:26:08', 'No user', '\"[]\"');
|
| 14 |
0.20 ms |
RELEASE SAVEPOINT DOCTRINE_2
RELEASE SAVEPOINT DOCTRINE_2;
|
| 15 |
0.25 ms |
"COMMIT"
|
| 16 |
22.73 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;
|
| 17 |
0.32 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 18 |
0.46 ms |
UPDATE post_view_stats SET hit_count = ?, updated_at = ? WHERE id = ?
Parameters: [
50904
"2026-04-15 05:26:09"
59953
]
UPDATE post_view_stats SET hit_count = 50904, updated_at = '2026-04-15 05:26:09' WHERE id = 59953;
|
| 19 |
0.30 ms |
SAVEPOINT DOCTRINE_2
SAVEPOINT DOCTRINE_2;
|
| 20 |
0.39 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 05:26:09"
"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 05:26:09', 'No user', '\"[]\"');
|
| 21 |
0.27 ms |
RELEASE SAVEPOINT DOCTRINE_2
RELEASE SAVEPOINT DOCTRINE_2;
|
| 22 |
0.26 ms |
"COMMIT"
|