Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.mobile AS mobile_2, 
  t0.name AS name_3, 
  t0.user_type AS user_type_4, 
  t0.password AS password_5, 
  t0.relationship AS relationship_6, 
  t0.relationship_other AS relationship_other_7, 
  t0.other_name_1 AS other_name_1_8, 
  t0.other_mobile_1 AS other_mobile_1_9, 
  t0.other_name_2 AS other_name_2_10, 
  t0.other_mobile_2 AS other_mobile_2_11, 
  t0.other_name_3 AS other_name_3_12, 
  t0.other_mobile_3 AS other_mobile_3_13, 
  t0.organization AS organization_14, 
  t0.record_status AS record_status_15, 
  t0.districts AS districts_16, 
  t0.locked AS locked_17, 
  t0.apiToken AS apiToken_18, 
  t0.longitude AS longitude_19, 
  t0.latitude AS latitude_20, 
  t0.pre_test_completed AS pre_test_completed_21, 
  t0.post_test_completed AS post_test_completed_22, 
  t0.post_test_completed_ts AS post_test_completed_ts_23, 
  t0.pre_test_completed_ts AS pre_test_completed_ts_24, 
  t0.reset_password AS reset_password_25, 
  t0.create_ts AS create_ts_26, 
  t0.create_by AS create_by_27, 
  t0.update_ts AS update_ts_28, 
  t0.update_by AS update_by_29, 
  t0.delete_ts AS delete_ts_30, 
  t0.delete_by AS delete_by_31, 
  t32.id AS id_33, 
  t32.device_sn AS device_sn_34, 
  t32.device_os AS device_os_35, 
  t32.push_id AS push_id_36, 
  t32.record_status AS record_status_37, 
  t32.create_ts AS create_ts_38, 
  t32.create_by AS create_by_39, 
  t32.update_ts AS update_ts_40, 
  t32.update_by AS update_by_41, 
  t32.delete_ts AS delete_ts_42, 
  t32.delete_by AS delete_by_43, 
  t32.caregiver_id AS caregiver_id_44, 
  t32.angel_id AS angel_id_45 
FROM 
  user t0 
  LEFT JOIN registered_mobile_device t32 ON t32.caregiver_id = t0.id 
WHERE 
  t0.mobile = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.mobile AS mobile_2, t0.name AS name_3, t0.user_type AS user_type_4, t0.password AS password_5, t0.relationship AS relationship_6, t0.relationship_other AS relationship_other_7, t0.other_name_1 AS other_name_1_8, t0.other_mobile_1 AS other_mobile_1_9, t0.other_name_2 AS other_name_2_10, t0.other_mobile_2 AS other_mobile_2_11, t0.other_name_3 AS other_name_3_12, t0.other_mobile_3 AS other_mobile_3_13, t0.organization AS organization_14, t0.record_status AS record_status_15, t0.districts AS districts_16, t0.locked AS locked_17, t0.apiToken AS apiToken_18, t0.longitude AS longitude_19, t0.latitude AS latitude_20, t0.pre_test_completed AS pre_test_completed_21, t0.post_test_completed AS post_test_completed_22, t0.post_test_completed_ts AS post_test_completed_ts_23, t0.pre_test_completed_ts AS pre_test_completed_ts_24, t0.reset_password AS reset_password_25, t0.create_ts AS create_ts_26, t0.create_by AS create_by_27, t0.update_ts AS update_ts_28, t0.update_by AS update_by_29, t0.delete_ts AS delete_ts_30, t0.delete_by AS delete_by_31, t32.id AS id_33, t32.device_sn AS device_sn_34, t32.device_os AS device_os_35, t32.push_id AS push_id_36, t32.record_status AS record_status_37, t32.create_ts AS create_ts_38, t32.create_by AS create_by_39, t32.update_ts AS update_ts_40, t32.update_by AS update_by_41, t32.delete_ts AS delete_ts_42, t32.delete_by AS delete_by_43, t32.caregiver_id AS caregiver_id_44, t32.angel_id AS angel_id_45 FROM user t0 LEFT JOIN registered_mobile_device t32 ON t32.caregiver_id = t0.id WHERE t0.mobile = '61794776' LIMIT 1;

SELECT 
  p0_.id AS id_0, 
  p0_.firstname AS firstname_1, 
  p0_.lastname AS lastname_2, 
  p0_.birth_year AS birth_year_3, 
  p0_.gender AS gender_4, 
  p0_.language AS language_5, 
  p0_.language_other AS language_other_6, 
  p0_.height AS height_7, 
  p0_.weight AS weight_8, 
  p0_.record_status AS record_status_9, 
  p0_.patient_status AS patient_status_10, 
  p0_.last_api_location AS last_api_location_11, 
  p0_.last_api_seen_time AS last_api_seen_time_12, 
  p0_.quit_reason AS quit_reason_13, 
  p0_.quit_ts AS quit_ts_14, 
  p0_.version AS version_15, 
  p0_.create_ts AS create_ts_16, 
  p0_.create_by AS create_by_17, 
  p0_.update_ts AS update_ts_18, 
  p0_.update_by AS update_by_19, 
  p0_.delete_ts AS delete_ts_20, 
  p0_.delete_by AS delete_by_21, 
  p0_.body AS body_22, 
  p0_.hair AS hair_23, 
  p0_.skin AS skin_24, 
  p0_.face AS face_25, 
  p0_.other AS other_26, 
  p0_.top AS top_27, 
  p0_.bottom AS bottom_28, 
  p0_.shoes AS shoes_29, 
  p0_.outfit AS outfit_30, 
  p0_.accessory AS accessory_31, 
  p0_.accessory_other AS accessory_other_32, 
  p0_.identity AS identity_33, 
  p0_.identity_value AS identity_value_34, 
  p0_.movement AS movement_35, 
  p0_.tool AS tool_36, 
  p0_.tool_main AS tool_main_37, 
  p0_.tool_sub AS tool_sub_38, 
  p0_.location AS location_39, 
  p0_.location_other AS location_other_40, 
  p0_.characteristic AS characteristic_41, 
  p0_.communication AS communication_42, 
  p0_.health AS health_43, 
  p0_.contact_info AS contact_info_44, 
  p0_.imageName AS imageName_45, 
  p0_.imageSize AS imageSize_46, 
  p0_.detailImageName AS detailImageName_47, 
  p0_.detailImageSize AS detailImageSize_48, 
  p0_.caregiver_id AS caregiver_id_49 
FROM 
  patient p0_ 
WHERE 
  p0_.caregiver_id = 122 
  AND p0_.id = 370

SELECT p0_.id AS id_0, p0_.firstname AS firstname_1, p0_.lastname AS lastname_2, p0_.birth_year AS birth_year_3, p0_.gender AS gender_4, p0_.language AS language_5, p0_.language_other AS language_other_6, p0_.height AS height_7, p0_.weight AS weight_8, p0_.record_status AS record_status_9, p0_.patient_status AS patient_status_10, p0_.last_api_location AS last_api_location_11, p0_.last_api_seen_time AS last_api_seen_time_12, p0_.quit_reason AS quit_reason_13, p0_.quit_ts AS quit_ts_14, p0_.version AS version_15, p0_.create_ts AS create_ts_16, p0_.create_by AS create_by_17, p0_.update_ts AS update_ts_18, p0_.update_by AS update_by_19, p0_.delete_ts AS delete_ts_20, p0_.delete_by AS delete_by_21, p0_.body AS body_22, p0_.hair AS hair_23, p0_.skin AS skin_24, p0_.face AS face_25, p0_.other AS other_26, p0_.top AS top_27, p0_.bottom AS bottom_28, p0_.shoes AS shoes_29, p0_.outfit AS outfit_30, p0_.accessory AS accessory_31, p0_.accessory_other AS accessory_other_32, p0_.identity AS identity_33, p0_.identity_value AS identity_value_34, p0_.movement AS movement_35, p0_.tool AS tool_36, p0_.tool_main AS tool_main_37, p0_.tool_sub AS tool_sub_38, p0_.location AS location_39, p0_.location_other AS location_other_40, p0_.characteristic AS characteristic_41, p0_.communication AS communication_42, p0_.health AS health_43, p0_.contact_info AS contact_info_44, p0_.imageName AS imageName_45, p0_.imageSize AS imageSize_46, p0_.detailImageName AS detailImageName_47, p0_.detailImageSize AS detailImageSize_48, p0_.caregiver_id AS caregiver_id_49 FROM patient p0_ WHERE p0_.caregiver_id = 122 AND p0_.id = 370;

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.patient_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.patient_id = 370;

SELECT 
  t0.id AS id_1, 
  t0.lost_time AS lost_time_2, 
  t0.unknown_lost_time AS unknown_lost_time_3, 
  t0.contact_number AS contact_number_4, 
  t0.contact_number_other AS contact_number_other_5, 
  t0.contact_info AS contact_info_6, 
  t0.last_district AS last_district_7, 
  t0.last_location AS last_location_8, 
  t0.lost_details AS lost_details_9, 
  t0.lost_message AS lost_message_10, 
  t0.lost_appearance AS lost_appearance_11, 
  t0.found AS found_12, 
  t0.close_reason AS close_reason_13, 
  t0.thanks_message AS thanks_message_14, 
  t0.thanks_message_time AS thanks_message_time_15, 
  t0.thanks_message_approved AS thanks_message_approved_16, 
  t0.hide AS hide_17, 
  t0.last_api_location AS last_api_location_18, 
  t0.last_api_seen_time AS last_api_seen_time_19, 
  t0.last_push AS last_push_20, 
  t0.push AS push_21, 
  t0.create_ts AS create_ts_22, 
  t0.create_by AS create_by_23, 
  t0.update_ts AS update_ts_24, 
  t0.update_by AS update_by_25, 
  t0.delete_ts AS delete_ts_26, 
  t0.delete_by AS delete_by_27, 
  t0.patient_id AS patient_id_28, 
  t29.id AS id_30, 
  t29.title AS title_31, 
  t29.body AS body_32, 
  t29.options AS options_33, 
  t29.jobStatus AS jobStatus_34, 
  t29.pid AS pid_35, 
  t29.publishAt AS publishAt_36, 
  t29.completeAt AS completeAt_37, 
  t29.lastActionAt AS lastActionAt_38, 
  t29.data AS data_39, 
  t29.create_ts AS create_ts_40, 
  t29.create_by AS create_by_41, 
  t29.update_ts AS update_ts_42, 
  t29.update_by AS update_by_43, 
  t29.delete_ts AS delete_ts_44, 
  t29.delete_by AS delete_by_45, 
  t29.lost_id AS lost_id_46 
FROM 
  patient_lost t0 
  LEFT JOIN mobile_lost_push_msg t29 ON t29.lost_id = t0.id 
WHERE 
  t0.patient_id = ?

SELECT t0.id AS id_1, t0.lost_time AS lost_time_2, t0.unknown_lost_time AS unknown_lost_time_3, t0.contact_number AS contact_number_4, t0.contact_number_other AS contact_number_other_5, t0.contact_info AS contact_info_6, t0.last_district AS last_district_7, t0.last_location AS last_location_8, t0.lost_details AS lost_details_9, t0.lost_message AS lost_message_10, t0.lost_appearance AS lost_appearance_11, t0.found AS found_12, t0.close_reason AS close_reason_13, t0.thanks_message AS thanks_message_14, t0.thanks_message_time AS thanks_message_time_15, t0.thanks_message_approved AS thanks_message_approved_16, t0.hide AS hide_17, t0.last_api_location AS last_api_location_18, t0.last_api_seen_time AS last_api_seen_time_19, t0.last_push AS last_push_20, t0.push AS push_21, t0.create_ts AS create_ts_22, t0.create_by AS create_by_23, t0.update_ts AS update_ts_24, t0.update_by AS update_by_25, t0.delete_ts AS delete_ts_26, t0.delete_by AS delete_by_27, t0.patient_id AS patient_id_28, t29.id AS id_30, t29.title AS title_31, t29.body AS body_32, t29.options AS options_33, t29.jobStatus AS jobStatus_34, t29.pid AS pid_35, t29.publishAt AS publishAt_36, t29.completeAt AS completeAt_37, t29.lastActionAt AS lastActionAt_38, t29.data AS data_39, t29.create_ts AS create_ts_40, t29.create_by AS create_by_41, t29.update_ts AS update_ts_42, t29.update_by AS update_by_43, t29.delete_ts AS delete_ts_44, t29.delete_by AS delete_by_45, t29.lost_id AS lost_id_46 FROM patient_lost t0 LEFT JOIN mobile_lost_push_msg t29 ON t29.lost_id = t0.id WHERE t0.patient_id = 370;

SELECT 
  t0.id AS id_1, 
  t0.created_at AS created_at_2, 
  t0.content AS content_3, 
  t0.job_id AS job_id_4 
FROM 
  mobile_lost_push_msg_log t0 
WHERE 
  t0.job_id = ? 
ORDER BY 
  t0.created_at DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.content AS content_3, t0.job_id AS job_id_4 FROM mobile_lost_push_msg_log t0 WHERE t0.job_id = 764 ORDER BY t0.created_at DESC;