2.79 ms (48.29%)
|
1 |
"COMMIT"
|
0.77 ms (13.22%)
|
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 (4, 1);
|
0.66 ms (11.45%)
|
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.39 ms (6.72%)
|
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.35 ms (5.98%)
|
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 = '4';
|
0.33 ms (5.65%)
|
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 = 4;
|
0.31 ms (5.41%)
|
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 = 4;
|
0.19 ms (3.28%)
|
1 |
"START TRANSACTION"
"START TRANSACTION";
|