2.27 ms (48.46%)
|
1 |
"COMMIT"
|
0.66 ms (14.01%)
|
1 |
INSERT INTO relay_button_camera_setting (relay_button_id, camera_setting_id) VALUES (?, ?)
INSERT INTO relay_button_camera_setting (relay_button_id, camera_setting_id) VALUES (3, 1);
|
0.54 ms (11.62%)
|
2 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.rtsp_url AS rtsp_url_3, c0_.stream_url AS stream_url_4, c0_.stream_type AS stream_type_5, c0_.poster_url AS poster_url_6, c0_.ffmpeg_enabled AS ffmpeg_enabled_7, c0_.ffmpeg_path AS ffmpeg_path_8, c0_.ffmpeg_transport AS ffmpeg_transport_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11 FROM camera_setting c0_ WHERE c0_.id IN (?)
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.rtsp_url AS rtsp_url_3, c0_.stream_url AS stream_url_4, c0_.stream_type AS stream_type_5, c0_.poster_url AS poster_url_6, c0_.ffmpeg_enabled AS ffmpeg_enabled_7, c0_.ffmpeg_path AS ffmpeg_path_8, c0_.ffmpeg_transport AS ffmpeg_transport_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11 FROM camera_setting c0_ WHERE c0_.id IN ('1');
|
0.28 ms (6.04%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.rtsp_url AS rtsp_url_4, t0.stream_url AS stream_url_5, t0.stream_type AS stream_type_6, t0.poster_url AS poster_url_7, t0.ffmpeg_enabled AS ffmpeg_enabled_8, t0.ffmpeg_path AS ffmpeg_path_9, t0.ffmpeg_transport AS ffmpeg_transport_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM camera_setting t0 INNER JOIN relay_button_camera_setting ON t0.id = relay_button_camera_setting.camera_setting_id WHERE relay_button_camera_setting.relay_button_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.rtsp_url AS rtsp_url_4, t0.stream_url AS stream_url_5, t0.stream_type AS stream_type_6, t0.poster_url AS poster_url_7, t0.ffmpeg_enabled AS ffmpeg_enabled_8, t0.ffmpeg_path AS ffmpeg_path_9, t0.ffmpeg_transport AS ffmpeg_transport_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM camera_setting t0 INNER JOIN relay_button_camera_setting ON t0.id = relay_button_camera_setting.camera_setting_id WHERE relay_button_camera_setting.relay_button_id = 3;
|
0.26 ms (5.60%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM "user" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM "user" t0 WHERE t0.id = 1;
|
0.26 ms (5.49%)
|
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.color AS color_4, t0.enabled AS enabled_5, t0.position AS position_6, t0.type AS type_7, t0.address AS address_8, t0.value AS value_9, t0.off_value AS off_value_10, t0.pulse_ms AS pulse_ms_11, t0.unit_id AS unit_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM relay_button t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.color AS color_4, t0.enabled AS enabled_5, t0.position AS position_6, t0.type AS type_7, t0.address AS address_8, t0.value AS value_9, t0.off_value AS off_value_10, t0.pulse_ms AS pulse_ms_11, t0.unit_id AS unit_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM relay_button t0 WHERE t0.id = '3';
|
0.25 ms (5.36%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM "user" t0 INNER JOIN relay_button_allowed_user ON t0.id = relay_button_allowed_user.user_id WHERE relay_button_allowed_user.relay_button_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM "user" t0 INNER JOIN relay_button_allowed_user ON t0.id = relay_button_allowed_user.user_id WHERE relay_button_allowed_user.relay_button_id = 3;
|
0.16 ms (3.42%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|