Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.battery AS battery_2, 
  t0.udid AS udid_3, 
  t0.mac AS mac_4, 
  t0.record_status AS record_status_5, 
  t0.route AS route_6, 
  t0.create_ts AS create_ts_7, 
  t0.create_by AS create_by_8, 
  t0.update_ts AS update_ts_9, 
  t0.update_by AS update_by_10, 
  t0.delete_ts AS delete_ts_11, 
  t0.delete_by AS delete_by_12, 
  t0.patient_id AS patient_id_13, 
  t14.id AS id_15, 
  t14.create_ts AS create_ts_16, 
  t14.create_by AS create_by_17, 
  t14.update_ts AS update_ts_18, 
  t14.update_by AS update_by_19, 
  t14.delete_ts AS delete_ts_20, 
  t14.delete_by AS delete_by_21, 
  t14.ibeacon_id AS ibeacon_id_22, 
  t23.id AS id_24, 
  t23.create_ts AS create_ts_25, 
  t23.create_by AS create_by_26, 
  t23.update_ts AS update_ts_27, 
  t23.update_by AS update_by_28, 
  t23.delete_ts AS delete_ts_29, 
  t23.delete_by AS delete_by_30, 
  t23.ibeacon_id AS ibeacon_id_31, 
  t32.id AS id_33, 
  t32.last_api_location AS last_api_location_34, 
  t32.last_api_seen_time AS last_api_seen_time_35, 
  t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, 
  t32.create_ts AS create_ts_37, 
  t32.create_by AS create_by_38, 
  t32.update_ts AS update_ts_39, 
  t32.update_by AS update_by_40, 
  t32.delete_ts AS delete_ts_41, 
  t32.delete_by AS delete_by_42, 
  t32.ibeacon_id AS ibeacon_id_43, 
  t0.ibeaconMap_id AS ibeaconMap_id_44 
FROM 
  patient_ibeacon t0 
  LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id 
WHERE 
  t0.mac = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.battery AS battery_2, t0.udid AS udid_3, t0.mac AS mac_4, t0.record_status AS record_status_5, t0.route AS route_6, t0.create_ts AS create_ts_7, t0.create_by AS create_by_8, t0.update_ts AS update_ts_9, t0.update_by AS update_by_10, t0.delete_ts AS delete_ts_11, t0.delete_by AS delete_by_12, t0.patient_id AS patient_id_13, t14.id AS id_15, t14.create_ts AS create_ts_16, t14.create_by AS create_by_17, t14.update_ts AS update_ts_18, t14.update_by AS update_by_19, t14.delete_ts AS delete_ts_20, t14.delete_by AS delete_by_21, t14.ibeacon_id AS ibeacon_id_22, t23.id AS id_24, t23.create_ts AS create_ts_25, t23.create_by AS create_by_26, t23.update_ts AS update_ts_27, t23.update_by AS update_by_28, t23.delete_ts AS delete_ts_29, t23.delete_by AS delete_by_30, t23.ibeacon_id AS ibeacon_id_31, t32.id AS id_33, t32.last_api_location AS last_api_location_34, t32.last_api_seen_time AS last_api_seen_time_35, t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, t32.create_ts AS create_ts_37, t32.create_by AS create_by_38, t32.update_ts AS update_ts_39, t32.update_by AS update_by_40, t32.delete_ts AS delete_ts_41, t32.delete_by AS delete_by_42, t32.ibeacon_id AS ibeacon_id_43, t0.ibeaconMap_id AS ibeaconMap_id_44 FROM patient_ibeacon t0 LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id WHERE t0.mac = 4474 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.major AS major_3, 
  t0.minor AS minor_4, 
  t0.create_ts AS create_ts_5, 
  t0.create_by AS create_by_6, 
  t0.update_ts AS update_ts_7, 
  t0.update_by AS update_by_8, 
  t0.delete_ts AS delete_ts_9, 
  t0.delete_by AS delete_by_10, 
  t11.id AS id_12, 
  t11.battery AS battery_13, 
  t11.udid AS udid_14, 
  t11.mac AS mac_15, 
  t11.record_status AS record_status_16, 
  t11.route AS route_17, 
  t11.create_ts AS create_ts_18, 
  t11.create_by AS create_by_19, 
  t11.update_ts AS update_ts_20, 
  t11.update_by AS update_by_21, 
  t11.delete_ts AS delete_ts_22, 
  t11.delete_by AS delete_by_23, 
  t11.patient_id AS patient_id_24, 
  t11.ibeaconMap_id AS ibeaconMap_id_25, 
  t0.ibeaconType_id AS ibeaconType_id_26 
FROM 
  ibeacon t0 
  LEFT JOIN patient_ibeacon t11 ON t11.ibeaconMap_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.major AS major_3, t0.minor AS minor_4, t0.create_ts AS create_ts_5, t0.create_by AS create_by_6, t0.update_ts AS update_ts_7, t0.update_by AS update_by_8, t0.delete_ts AS delete_ts_9, t0.delete_by AS delete_by_10, t11.id AS id_12, t11.battery AS battery_13, t11.udid AS udid_14, t11.mac AS mac_15, t11.record_status AS record_status_16, t11.route AS route_17, t11.create_ts AS create_ts_18, t11.create_by AS create_by_19, t11.update_ts AS update_ts_20, t11.update_by AS update_by_21, t11.delete_ts AS delete_ts_22, t11.delete_by AS delete_by_23, t11.patient_id AS patient_id_24, t11.ibeaconMap_id AS ibeaconMap_id_25, t0.ibeaconType_id AS ibeaconType_id_26 FROM ibeacon t0 LEFT JOIN patient_ibeacon t11 ON t11.ibeaconMap_id = t0.id WHERE t0.id = 18610;

SELECT 
  t0.id AS id_1, 
  t0.major AS major_2, 
  t0.type AS type_3, 
  t0.create_ts AS create_ts_4, 
  t0.create_by AS create_by_5, 
  t0.update_ts AS update_ts_6, 
  t0.update_by AS update_by_7, 
  t0.delete_ts AS delete_ts_8, 
  t0.delete_by AS delete_by_9 
FROM 
  ibeacon_type t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.major AS major_2, t0.type AS type_3, t0.create_ts AS create_ts_4, t0.create_by AS create_by_5, t0.update_ts AS update_ts_6, t0.update_by AS update_by_7, t0.delete_ts AS delete_ts_8, t0.delete_by AS delete_by_9 FROM ibeacon_type t0 WHERE t0.id = 10;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ibeacon_update_api_call_log (
  latitude, longitude, gpsacc, ibeacon_signal, 
  address, status, error, cached, created_at, 
  session_id, ibeacon_id
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ibeacon_update_api_call_log (latitude, longitude, gpsacc, ibeacon_signal, address, status, error, cached, created_at, session_id, ibeacon_id) VALUES ('22.372799998445', '114.11860000418', 1220, 'LoRa', '香港荃灣青山公路 - 荃灣段200號', 'SKIPPED', '', 1, '2025-04-07 09:20:04', '67f32844d8953', 297);

INSERT INTO revisions (timestamp, username) 
VALUES 
  (?, ?)

INSERT INTO revisions (timestamp, username) VALUES ('2025-04-07 09:20:04', 'anon.');

INSERT INTO ibeacon_update_api_call_log_audit (
  rev, revtype, ibeacon_id, id, latitude, 
  longitude, gpsacc, ibeacon_signal, 
  address, status, error, cached, created_at, 
  session_id
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ibeacon_update_api_call_log_audit (rev, revtype, ibeacon_id, id, latitude, longitude, gpsacc, ibeacon_signal, address, status, error, cached, created_at, session_id) VALUES ('1594751', 'INS', 297, 388669, '22.372799998445', '114.11860000418', 1220, 'LoRa', '香港荃灣青山公路 - 荃灣段200號', 'SKIPPED', '', 1, '2025-04-07 09:20:04', '67f32844d8953');

UPDATE 
  ibeacon_last_seen 
SET 
  last_api_location = ?, 
  last_api_seen_timestamp = ?, 
  update_ts = ? 
WHERE 
  id = ?

UPDATE ibeacon_last_seen SET last_api_location = '{\"lat\":22.37279999844525,\"long\":114.11860000417707,\"address\":\"\\u9999\\u6e2f\\u8343\\u7063\\u9752\\u5c71\\u516c\\u8def - \\u8343\\u7063\\u6bb5200\\u865f\",\"gpsacc\":1220,\"signal\":\"LoRa\"}', last_api_seen_timestamp = 1743988805, update_ts = '2025-04-07 09:20:04' WHERE id = 270;

"COMMIT"

"COMMIT";

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  latitude = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET latitude = '22.372799998445' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  longitude = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET longitude = '114.11860000418' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  gpsacc = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET gpsacc = 1220 WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  ibeacon_signal = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET ibeacon_signal = 'LoRa' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  address = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET address = '香港荃灣青山公路 - 荃灣段200號' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  status = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET status = 'SKIPPED' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  error = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET error = '' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  cached = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET cached = 1 WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  created_at = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET created_at = '2025-04-07 09:20:04' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  session_id = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET session_id = '67f32844d8953' WHERE rev = '1594751' AND id = 388669;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  ibeacon_id = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET ibeacon_id = 297 WHERE rev = '1594751' AND id = 388669;

SELECT 
  t0.id AS id_1, 
  t0.battery AS battery_2, 
  t0.udid AS udid_3, 
  t0.mac AS mac_4, 
  t0.record_status AS record_status_5, 
  t0.route AS route_6, 
  t0.create_ts AS create_ts_7, 
  t0.create_by AS create_by_8, 
  t0.update_ts AS update_ts_9, 
  t0.update_by AS update_by_10, 
  t0.delete_ts AS delete_ts_11, 
  t0.delete_by AS delete_by_12, 
  t0.patient_id AS patient_id_13, 
  t14.id AS id_15, 
  t14.create_ts AS create_ts_16, 
  t14.create_by AS create_by_17, 
  t14.update_ts AS update_ts_18, 
  t14.update_by AS update_by_19, 
  t14.delete_ts AS delete_ts_20, 
  t14.delete_by AS delete_by_21, 
  t14.ibeacon_id AS ibeacon_id_22, 
  t23.id AS id_24, 
  t23.create_ts AS create_ts_25, 
  t23.create_by AS create_by_26, 
  t23.update_ts AS update_ts_27, 
  t23.update_by AS update_by_28, 
  t23.delete_ts AS delete_ts_29, 
  t23.delete_by AS delete_by_30, 
  t23.ibeacon_id AS ibeacon_id_31, 
  t32.id AS id_33, 
  t32.last_api_location AS last_api_location_34, 
  t32.last_api_seen_time AS last_api_seen_time_35, 
  t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, 
  t32.create_ts AS create_ts_37, 
  t32.create_by AS create_by_38, 
  t32.update_ts AS update_ts_39, 
  t32.update_by AS update_by_40, 
  t32.delete_ts AS delete_ts_41, 
  t32.delete_by AS delete_by_42, 
  t32.ibeacon_id AS ibeacon_id_43, 
  t0.ibeaconMap_id AS ibeaconMap_id_44 
FROM 
  patient_ibeacon t0 
  LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id 
WHERE 
  t0.mac = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.battery AS battery_2, t0.udid AS udid_3, t0.mac AS mac_4, t0.record_status AS record_status_5, t0.route AS route_6, t0.create_ts AS create_ts_7, t0.create_by AS create_by_8, t0.update_ts AS update_ts_9, t0.update_by AS update_by_10, t0.delete_ts AS delete_ts_11, t0.delete_by AS delete_by_12, t0.patient_id AS patient_id_13, t14.id AS id_15, t14.create_ts AS create_ts_16, t14.create_by AS create_by_17, t14.update_ts AS update_ts_18, t14.update_by AS update_by_19, t14.delete_ts AS delete_ts_20, t14.delete_by AS delete_by_21, t14.ibeacon_id AS ibeacon_id_22, t23.id AS id_24, t23.create_ts AS create_ts_25, t23.create_by AS create_by_26, t23.update_ts AS update_ts_27, t23.update_by AS update_by_28, t23.delete_ts AS delete_ts_29, t23.delete_by AS delete_by_30, t23.ibeacon_id AS ibeacon_id_31, t32.id AS id_33, t32.last_api_location AS last_api_location_34, t32.last_api_seen_time AS last_api_seen_time_35, t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, t32.create_ts AS create_ts_37, t32.create_by AS create_by_38, t32.update_ts AS update_ts_39, t32.update_by AS update_by_40, t32.delete_ts AS delete_ts_41, t32.delete_by AS delete_by_42, t32.ibeacon_id AS ibeacon_id_43, t0.ibeaconMap_id AS ibeaconMap_id_44 FROM patient_ibeacon t0 LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id WHERE t0.mac = 4474 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ibeacon_last_seen_history (
  timestamp, latitude, longitude, address, 
  gpsacc, ibeacon_signal, create_ts, 
  create_by, update_ts, update_by, 
  delete_ts, delete_by, lastSeen_id
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ibeacon_last_seen_history (timestamp, latitude, longitude, address, gpsacc, ibeacon_signal, create_ts, create_by, update_ts, update_by, delete_ts, delete_by, lastSeen_id) VALUES ('1743988805', '22.372799998445', '114.11860000418', '香港荃灣青山公路 - 荃灣段200號', '1220', 'LoRa', '2025-04-07 09:20:05', NULL, '2025-04-07 09:20:05', NULL, NULL, NULL, 270);

UPDATE 
  ibeacon_last_seen 
SET 
  last_api_location = ?, 
  update_ts = ? 
WHERE 
  id = ?

UPDATE ibeacon_last_seen SET last_api_location = '{\"lat\":22.37279999844525,\"long\":114.11860000417707,\"address\":\"\\u9999\\u6e2f\\u8343\\u7063\\u9752\\u5c71\\u516c\\u8def - \\u8343\\u7063\\u6bb5200\\u865f\",\"gpsacc\":1220,\"signal\":\"LoRa\",\"type\":\"1\"}', update_ts = '2025-04-07 09:20:05' WHERE id = 270;

"COMMIT"

"COMMIT";

SELECT 
  t0.id AS id_1, 
  t0.battery AS battery_2, 
  t0.udid AS udid_3, 
  t0.mac AS mac_4, 
  t0.record_status AS record_status_5, 
  t0.route AS route_6, 
  t0.create_ts AS create_ts_7, 
  t0.create_by AS create_by_8, 
  t0.update_ts AS update_ts_9, 
  t0.update_by AS update_by_10, 
  t0.delete_ts AS delete_ts_11, 
  t0.delete_by AS delete_by_12, 
  t0.patient_id AS patient_id_13, 
  t14.id AS id_15, 
  t14.create_ts AS create_ts_16, 
  t14.create_by AS create_by_17, 
  t14.update_ts AS update_ts_18, 
  t14.update_by AS update_by_19, 
  t14.delete_ts AS delete_ts_20, 
  t14.delete_by AS delete_by_21, 
  t14.ibeacon_id AS ibeacon_id_22, 
  t23.id AS id_24, 
  t23.create_ts AS create_ts_25, 
  t23.create_by AS create_by_26, 
  t23.update_ts AS update_ts_27, 
  t23.update_by AS update_by_28, 
  t23.delete_ts AS delete_ts_29, 
  t23.delete_by AS delete_by_30, 
  t23.ibeacon_id AS ibeacon_id_31, 
  t32.id AS id_33, 
  t32.last_api_location AS last_api_location_34, 
  t32.last_api_seen_time AS last_api_seen_time_35, 
  t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, 
  t32.create_ts AS create_ts_37, 
  t32.create_by AS create_by_38, 
  t32.update_ts AS update_ts_39, 
  t32.update_by AS update_by_40, 
  t32.delete_ts AS delete_ts_41, 
  t32.delete_by AS delete_by_42, 
  t32.ibeacon_id AS ibeacon_id_43, 
  t0.ibeaconMap_id AS ibeaconMap_id_44 
FROM 
  patient_ibeacon t0 
  LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id 
WHERE 
  t0.mac = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.battery AS battery_2, t0.udid AS udid_3, t0.mac AS mac_4, t0.record_status AS record_status_5, t0.route AS route_6, t0.create_ts AS create_ts_7, t0.create_by AS create_by_8, t0.update_ts AS update_ts_9, t0.update_by AS update_by_10, t0.delete_ts AS delete_ts_11, t0.delete_by AS delete_by_12, t0.patient_id AS patient_id_13, t14.id AS id_15, t14.create_ts AS create_ts_16, t14.create_by AS create_by_17, t14.update_ts AS update_ts_18, t14.update_by AS update_by_19, t14.delete_ts AS delete_ts_20, t14.delete_by AS delete_by_21, t14.ibeacon_id AS ibeacon_id_22, t23.id AS id_24, t23.create_ts AS create_ts_25, t23.create_by AS create_by_26, t23.update_ts AS update_ts_27, t23.update_by AS update_by_28, t23.delete_ts AS delete_ts_29, t23.delete_by AS delete_by_30, t23.ibeacon_id AS ibeacon_id_31, t32.id AS id_33, t32.last_api_location AS last_api_location_34, t32.last_api_seen_time AS last_api_seen_time_35, t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, t32.create_ts AS create_ts_37, t32.create_by AS create_by_38, t32.update_ts AS update_ts_39, t32.update_by AS update_by_40, t32.delete_ts AS delete_ts_41, t32.delete_by AS delete_by_42, t32.ibeacon_id AS ibeacon_id_43, t0.ibeaconMap_id AS ibeaconMap_id_44 FROM patient_ibeacon t0 LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id WHERE t0.mac = 44120 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.battery AS battery_2, 
  t0.udid AS udid_3, 
  t0.mac AS mac_4, 
  t0.record_status AS record_status_5, 
  t0.route AS route_6, 
  t0.create_ts AS create_ts_7, 
  t0.create_by AS create_by_8, 
  t0.update_ts AS update_ts_9, 
  t0.update_by AS update_by_10, 
  t0.delete_ts AS delete_ts_11, 
  t0.delete_by AS delete_by_12, 
  t0.patient_id AS patient_id_13, 
  t14.id AS id_15, 
  t14.create_ts AS create_ts_16, 
  t14.create_by AS create_by_17, 
  t14.update_ts AS update_ts_18, 
  t14.update_by AS update_by_19, 
  t14.delete_ts AS delete_ts_20, 
  t14.delete_by AS delete_by_21, 
  t14.ibeacon_id AS ibeacon_id_22, 
  t23.id AS id_24, 
  t23.create_ts AS create_ts_25, 
  t23.create_by AS create_by_26, 
  t23.update_ts AS update_ts_27, 
  t23.update_by AS update_by_28, 
  t23.delete_ts AS delete_ts_29, 
  t23.delete_by AS delete_by_30, 
  t23.ibeacon_id AS ibeacon_id_31, 
  t32.id AS id_33, 
  t32.last_api_location AS last_api_location_34, 
  t32.last_api_seen_time AS last_api_seen_time_35, 
  t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, 
  t32.create_ts AS create_ts_37, 
  t32.create_by AS create_by_38, 
  t32.update_ts AS update_ts_39, 
  t32.update_by AS update_by_40, 
  t32.delete_ts AS delete_ts_41, 
  t32.delete_by AS delete_by_42, 
  t32.ibeacon_id AS ibeacon_id_43, 
  t0.ibeaconMap_id AS ibeaconMap_id_44 
FROM 
  patient_ibeacon t0 
  LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id 
  LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id 
WHERE 
  t0.mac = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.battery AS battery_2, t0.udid AS udid_3, t0.mac AS mac_4, t0.record_status AS record_status_5, t0.route AS route_6, t0.create_ts AS create_ts_7, t0.create_by AS create_by_8, t0.update_ts AS update_ts_9, t0.update_by AS update_by_10, t0.delete_ts AS delete_ts_11, t0.delete_by AS delete_by_12, t0.patient_id AS patient_id_13, t14.id AS id_15, t14.create_ts AS create_ts_16, t14.create_by AS create_by_17, t14.update_ts AS update_ts_18, t14.update_by AS update_by_19, t14.delete_ts AS delete_ts_20, t14.delete_by AS delete_by_21, t14.ibeacon_id AS ibeacon_id_22, t23.id AS id_24, t23.create_ts AS create_ts_25, t23.create_by AS create_by_26, t23.update_ts AS update_ts_27, t23.update_by AS update_by_28, t23.delete_ts AS delete_ts_29, t23.delete_by AS delete_by_30, t23.ibeacon_id AS ibeacon_id_31, t32.id AS id_33, t32.last_api_location AS last_api_location_34, t32.last_api_seen_time AS last_api_seen_time_35, t32.last_api_seen_timestamp AS last_api_seen_timestamp_36, t32.create_ts AS create_ts_37, t32.create_by AS create_by_38, t32.update_ts AS update_ts_39, t32.update_by AS update_by_40, t32.delete_ts AS delete_ts_41, t32.delete_by AS delete_by_42, t32.ibeacon_id AS ibeacon_id_43, t0.ibeaconMap_id AS ibeaconMap_id_44 FROM patient_ibeacon t0 LEFT JOIN ibeacon_low_battery_alert t14 ON t14.ibeacon_id = t0.id LEFT JOIN ibeacon_dispose t23 ON t23.ibeacon_id = t0.id LEFT JOIN ibeacon_last_seen t32 ON t32.ibeacon_id = t0.id WHERE t0.mac = 44220 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.major AS major_3, 
  t0.minor AS minor_4, 
  t0.create_ts AS create_ts_5, 
  t0.create_by AS create_by_6, 
  t0.update_ts AS update_ts_7, 
  t0.update_by AS update_by_8, 
  t0.delete_ts AS delete_ts_9, 
  t0.delete_by AS delete_by_10, 
  t11.id AS id_12, 
  t11.battery AS battery_13, 
  t11.udid AS udid_14, 
  t11.mac AS mac_15, 
  t11.record_status AS record_status_16, 
  t11.route AS route_17, 
  t11.create_ts AS create_ts_18, 
  t11.create_by AS create_by_19, 
  t11.update_ts AS update_ts_20, 
  t11.update_by AS update_by_21, 
  t11.delete_ts AS delete_ts_22, 
  t11.delete_by AS delete_by_23, 
  t11.patient_id AS patient_id_24, 
  t11.ibeaconMap_id AS ibeaconMap_id_25, 
  t0.ibeaconType_id AS ibeaconType_id_26 
FROM 
  ibeacon t0 
  LEFT JOIN patient_ibeacon t11 ON t11.ibeaconMap_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.major AS major_3, t0.minor AS minor_4, t0.create_ts AS create_ts_5, t0.create_by AS create_by_6, t0.update_ts AS update_ts_7, t0.update_by AS update_by_8, t0.delete_ts AS delete_ts_9, t0.delete_by AS delete_by_10, t11.id AS id_12, t11.battery AS battery_13, t11.udid AS udid_14, t11.mac AS mac_15, t11.record_status AS record_status_16, t11.route AS route_17, t11.create_ts AS create_ts_18, t11.create_by AS create_by_19, t11.update_ts AS update_ts_20, t11.update_by AS update_by_21, t11.delete_ts AS delete_ts_22, t11.delete_by AS delete_by_23, t11.patient_id AS patient_id_24, t11.ibeaconMap_id AS ibeaconMap_id_25, t0.ibeaconType_id AS ibeaconType_id_26 FROM ibeacon t0 LEFT JOIN patient_ibeacon t11 ON t11.ibeaconMap_id = t0.id WHERE t0.id = 18640;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ibeacon_update_api_call_log (
  latitude, longitude, gpsacc, ibeacon_signal, 
  address, status, error, cached, created_at, 
  session_id, ibeacon_id
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ibeacon_update_api_call_log (latitude, longitude, gpsacc, ibeacon_signal, address, status, error, cached, created_at, session_id, ibeacon_id) VALUES ('22.279641646032', '114.16594248302', 1220, 'LoRa', '香港金鐘夏愨道18號', 'OK', '', 1, '2025-04-07 09:20:05', '67f32844d8953', 286);

INSERT INTO revisions (timestamp, username) 
VALUES 
  (?, ?)

INSERT INTO revisions (timestamp, username) VALUES ('2025-04-07 09:20:05', 'anon.');

INSERT INTO ibeacon_update_api_call_log_audit (
  rev, revtype, ibeacon_id, id, latitude, 
  longitude, gpsacc, ibeacon_signal, 
  address, status, error, cached, created_at, 
  session_id
) 
VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ibeacon_update_api_call_log_audit (rev, revtype, ibeacon_id, id, latitude, longitude, gpsacc, ibeacon_signal, address, status, error, cached, created_at, session_id) VALUES ('1594752', 'INS', 286, 388670, '22.279641646032', '114.16594248302', 1220, 'LoRa', '香港金鐘夏愨道18號', 'OK', '', 1, '2025-04-07 09:20:05', '67f32844d8953');

UPDATE 
  ibeacon_last_seen 
SET 
  last_api_location = ?, 
  last_api_seen_timestamp = ?, 
  update_ts = ? 
WHERE 
  id = ?

UPDATE ibeacon_last_seen SET last_api_location = '{\"lat\":22.279641646032303,\"long\":114.16594248301683,\"address\":\"\\u9999\\u6e2f\\u91d1\\u9418\\u590f\\u6128\\u905318\\u865f\",\"gpsacc\":1220,\"signal\":\"LoRa\"}', last_api_seen_timestamp = 1743988805, update_ts = '2025-04-07 09:20:05' WHERE id = 259;

"COMMIT"

"COMMIT";

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  latitude = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET latitude = '22.279641646032' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  longitude = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET longitude = '114.16594248302' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  gpsacc = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET gpsacc = 1220 WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  ibeacon_signal = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET ibeacon_signal = 'LoRa' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  address = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET address = '香港金鐘夏愨道18號' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  status = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET status = 'OK' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  error = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET error = '' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  cached = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET cached = 1 WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  created_at = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET created_at = '2025-04-07 09:20:05' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  session_id = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET session_id = '67f32844d8953' WHERE rev = '1594752' AND id = 388670;

UPDATE 
  ibeacon_update_api_call_log_audit 
SET 
  ibeacon_id = ? 
WHERE 
  rev = ? 
  AND id = ?

UPDATE ibeacon_update_api_call_log_audit SET ibeacon_id = 286 WHERE rev = '1594752' AND id = 388670;