Symfony Profiler

SELECT 
  i0_.id AS id_0, 
  i0_.name AS name_1, 
  i0_.major AS major_2, 
  i0_.minor AS minor_3, 
  i0_.create_ts AS create_ts_4, 
  i0_.create_by AS create_by_5, 
  i0_.update_ts AS update_ts_6, 
  i0_.update_by AS update_by_7, 
  i0_.delete_ts AS delete_ts_8, 
  i0_.delete_by AS delete_by_9, 
  i0_.ibeaconType_id AS ibeaconType_id_10 
FROM 
  ibeacon i0_ 
WHERE 
  i0_.major = ? 
  AND i0_.minor = ? 
ORDER BY 
  i0_.id ASC 
LIMIT 
  999

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.major AS major_2, i0_.minor AS minor_3, i0_.create_ts AS create_ts_4, i0_.create_by AS create_by_5, i0_.update_ts AS update_ts_6, i0_.update_by AS update_by_7, i0_.delete_ts AS delete_ts_8, i0_.delete_by AS delete_by_9, i0_.ibeaconType_id AS ibeaconType_id_10 FROM ibeacon i0_ WHERE i0_.major = '44' AND i0_.minor = '467' ORDER BY i0_.id ASC LIMIT 999;

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.ibeaconMap_id = ?

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.ibeaconMap_id = 18607;

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;

SELECT 
  count(i0_.id) AS sclr_0 
FROM 
  ibeacon i0_ 
WHERE 
  i0_.major = ? 
  AND i0_.minor = ?

SELECT count(i0_.id) AS sclr_0 FROM ibeacon i0_ WHERE i0_.major = '44' AND i0_.minor = '467';