1
0.29 ms
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 ;
Copy
2
0.36 ms
SELECT DISTINCT r0_ . id AS id_0 , r0_ . position AS position_1 , r0_ . id AS id_2 FROM relay_button r0_ ORDER BY r0_ . position ASC , r0_ . id ASC LIMIT 20
SELECT DISTINCT r0_ . id AS id_0 , r0_ . position AS position_1 , r0_ . id AS id_2 FROM relay_button r0_ ORDER BY r0_ . position ASC , r0_ . id ASC LIMIT 20 ;
Copy
3
0.32 ms
SELECT r0_ . id AS id_0 , r0_ . code AS code_1 , r0_ . label AS label_2 , r0_ . color AS color_3 , r0_ . enabled AS enabled_4 , r0_ . position AS position_5 , r0_ . type AS type_6 , r0_ . address AS address_7 , r0_ . value AS value_8 , r0_ . off_value AS off_value_9 , r0_ . pulse_ms AS pulse_ms_10 , r0_ . unit_id AS unit_id_11 , r0_ . created_at AS created_at_12 , r0_ . updated_at AS updated_at_13 FROM relay_button r0_ WHERE r0_ . id IN (? , ? , ? , ? ) ORDER BY r0_ . position ASC , r0_ . id ASC
SELECT r0_ . id AS id_0 , r0_ . code AS code_1 , r0_ . label AS label_2 , r0_ . color AS color_3 , r0_ . enabled AS enabled_4 , r0_ . position AS position_5 , r0_ . type AS type_6 , r0_ . address AS address_7 , r0_ . value AS value_8 , r0_ . off_value AS off_value_9 , r0_ . pulse_ms AS pulse_ms_10 , r0_ . unit_id AS unit_id_11 , r0_ . created_at AS created_at_12 , r0_ . updated_at AS updated_at_13 FROM relay_button r0_ WHERE r0_ . id IN (1 , 2 , 3 , 4 ) ORDER BY r0_ . position ASC , r0_ . id ASC ;
Copy
4
0.32 ms
SELECT count (* ) AS sclr_0 FROM relay_button r0_
SELECT count (* ) AS sclr_0 FROM relay_button r0_ ;
Copy
5
0.32 ms
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 = 1 ;
Copy
6
0.29 ms
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 = 2 ;
Copy
7
0.31 ms
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 ;
Copy
8
0.31 ms
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 ;
Copy