Symfony Profiler

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 = 28;

SELECT 
  t0.id AS id_1, 
  t0.create_ts AS create_ts_2, 
  t0.create_by AS create_by_3, 
  t0.update_ts AS update_ts_4, 
  t0.update_by AS update_by_5, 
  t0.delete_ts AS delete_ts_6, 
  t0.delete_by AS delete_by_7, 
  t0.ibeacon_id AS ibeacon_id_8 
FROM 
  ibeacon_dispose t0 
WHERE 
  t0.ibeacon_id = ?

SELECT t0.id AS id_1, t0.create_ts AS create_ts_2, t0.create_by AS create_by_3, t0.update_ts AS update_ts_4, t0.update_by AS update_by_5, t0.delete_ts AS delete_ts_6, t0.delete_by AS delete_by_7, t0.ibeacon_id AS ibeacon_id_8 FROM ibeacon_dispose t0 WHERE t0.ibeacon_id = 181;

SELECT 
  t0.id AS id_1, 
  t0.last_api_location AS last_api_location_2, 
  t0.last_api_seen_time AS last_api_seen_time_3, 
  t0.last_api_seen_timestamp AS last_api_seen_timestamp_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, 
  t0.ibeacon_id AS ibeacon_id_11 
FROM 
  ibeacon_last_seen t0 
WHERE 
  t0.ibeacon_id = ?

SELECT t0.id AS id_1, t0.last_api_location AS last_api_location_2, t0.last_api_seen_time AS last_api_seen_time_3, t0.last_api_seen_timestamp AS last_api_seen_timestamp_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, t0.ibeacon_id AS ibeacon_id_11 FROM ibeacon_last_seen t0 WHERE t0.ibeacon_id = 181;

SELECT 
  t0.id AS id_1, 
  t0.create_ts AS create_ts_2, 
  t0.create_by AS create_by_3, 
  t0.update_ts AS update_ts_4, 
  t0.update_by AS update_by_5, 
  t0.delete_ts AS delete_ts_6, 
  t0.delete_by AS delete_by_7, 
  t0.ibeacon_id AS ibeacon_id_8 
FROM 
  ibeacon_low_battery_alert t0 
WHERE 
  t0.ibeacon_id = ?

SELECT t0.id AS id_1, t0.create_ts AS create_ts_2, t0.create_by AS create_by_3, t0.update_ts AS update_ts_4, t0.update_by AS update_by_5, t0.delete_ts AS delete_ts_6, t0.delete_by AS delete_by_7, t0.ibeacon_id AS ibeacon_id_8 FROM ibeacon_low_battery_alert t0 WHERE t0.ibeacon_id = 181;

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 = 1;

SELECT 
  p0_.id AS id_0, 
  p0_.battery AS battery_1, 
  p0_.udid AS udid_2, 
  p0_.mac AS mac_3, 
  p0_.record_status AS record_status_4, 
  p0_.route AS route_5, 
  p0_.create_ts AS create_ts_6, 
  p0_.create_by AS create_by_7, 
  p0_.update_ts AS update_ts_8, 
  p0_.update_by AS update_by_9, 
  p0_.delete_ts AS delete_ts_10, 
  p0_.delete_by AS delete_by_11, 
  p0_.patient_id AS patient_id_12, 
  p0_.ibeaconMap_id AS ibeaconMap_id_13 
FROM 
  patient_ibeacon p0_ 
ORDER BY 
  p0_.id ASC 
LIMIT 
  999

SELECT p0_.id AS id_0, p0_.battery AS battery_1, p0_.udid AS udid_2, p0_.mac AS mac_3, p0_.record_status AS record_status_4, p0_.route AS route_5, p0_.create_ts AS create_ts_6, p0_.create_by AS create_by_7, p0_.update_ts AS update_ts_8, p0_.update_by AS update_by_9, p0_.delete_ts AS delete_ts_10, p0_.delete_by AS delete_by_11, p0_.patient_id AS patient_id_12, p0_.ibeaconMap_id AS ibeaconMap_id_13 FROM patient_ibeacon p0_ ORDER BY p0_.id ASC LIMIT 999;

SELECT 
  count(p0_.id) AS sclr_0 
FROM 
  patient_ibeacon p0_

SELECT count(p0_.id) AS sclr_0 FROM patient_ibeacon p0_;