| 1 |
0.55 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.broadcast_date AS broadcast_date_6, t0.schedule_day AS schedule_day_7, t0.schedule_time AS schedule_time_8, t0.duration AS duration_9, t0.host_name AS host_name_10, t0.production_team AS production_team_11, t0.audio_file AS audio_file_12, t0.file_size AS file_size_13, t0.is_active AS is_active_14, t0.audio_url AS audio_url_15, t0.plays_count AS plays_count_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM emission t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"journal-de-18h-du-03-decembre-2025"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.broadcast_date AS broadcast_date_6, t0.schedule_day AS schedule_day_7, t0.schedule_time AS schedule_time_8, t0.duration AS duration_9, t0.host_name AS host_name_10, t0.production_team AS production_team_11, t0.audio_file AS audio_file_12, t0.file_size AS file_size_13, t0.is_active AS is_active_14, t0.audio_url AS audio_url_15, t0.plays_count AS plays_count_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM emission t0 WHERE t0.slug = 'journal-de-18h-du-03-decembre-2025' LIMIT 1;
|
| 2 |
0.23 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 3 |
0.38 ms |
UPDATE emission SET plays_count = ?, updated_at = ? WHERE id = ?
Parameters: [
15
"2025-12-19 15:19:33"
4
]
UPDATE emission SET plays_count = 15, updated_at = '2025-12-19 15:19:33' WHERE id = 4;
|
| 4 |
0.27 ms |
"COMMIT"
|
| 5 |
0.53 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.image AS image_4, e0_.broadcast_date AS broadcast_date_5, e0_.schedule_day AS schedule_day_6, e0_.schedule_time AS schedule_time_7, e0_.duration AS duration_8, e0_.host_name AS host_name_9, e0_.production_team AS production_team_10, e0_.audio_file AS audio_file_11, e0_.file_size AS file_size_12, e0_.is_active AS is_active_13, e0_.audio_url AS audio_url_14, e0_.plays_count AS plays_count_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e0_.category_id AS category_id_18 FROM emission e0_ WHERE e0_.is_active = ? AND e0_.category_id = ? AND e0_.id <> ? ORDER BY e0_.broadcast_date DESC LIMIT 4
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.slug AS slug_2, e0_.description AS description_3, e0_.image AS image_4, e0_.broadcast_date AS broadcast_date_5, e0_.schedule_day AS schedule_day_6, e0_.schedule_time AS schedule_time_7, e0_.duration AS duration_8, e0_.host_name AS host_name_9, e0_.production_team AS production_team_10, e0_.audio_file AS audio_file_11, e0_.file_size AS file_size_12, e0_.is_active AS is_active_13, e0_.audio_url AS audio_url_14, e0_.plays_count AS plays_count_15, e0_.created_at AS created_at_16, e0_.updated_at AS updated_at_17, e0_.category_id AS category_id_18 FROM emission e0_ WHERE e0_.is_active = 1 AND e0_.category_id = 7 AND e0_.id <> 4 ORDER BY e0_.broadcast_date DESC LIMIT 4;
|
| 6 |
0.35 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.broadcast_date AS broadcast_date_6, t0.schedule_day AS schedule_day_7, t0.schedule_time AS schedule_time_8, t0.duration AS duration_9, t0.host_name AS host_name_10, t0.production_team AS production_team_11, t0.audio_file AS audio_file_12, t0.file_size AS file_size_13, t0.is_active AS is_active_14, t0.audio_url AS audio_url_15, t0.plays_count AS plays_count_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM emission t0 WHERE t0.is_active = ? ORDER BY t0.broadcast_date DESC, t0.schedule_time DESC LIMIT 6
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.broadcast_date AS broadcast_date_6, t0.schedule_day AS schedule_day_7, t0.schedule_time AS schedule_time_8, t0.duration AS duration_9, t0.host_name AS host_name_10, t0.production_team AS production_team_11, t0.audio_file AS audio_file_12, t0.file_size AS file_size_13, t0.is_active AS is_active_14, t0.audio_url AS audio_url_15, t0.plays_count AS plays_count_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM emission t0 WHERE t0.is_active = 1 ORDER BY t0.broadcast_date DESC, t0.schedule_time DESC LIMIT 6;
|
| 7 |
0.25 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.description AS description_5, t0.updated_at AS updated_at_6 FROM setting t0
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.description AS description_5, t0.updated_at AS updated_at_6 FROM setting t0;
|
| 8 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.is_active AS is_active_7, t0.display_order AS display_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM emission_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.icon AS icon_6, t0.is_active AS is_active_7, t0.display_order AS display_order_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM emission_category t0 WHERE t0.id = 7;
|