Suggested appointment:
Wednesday, 3 September 2025
at 3:30 pm
52 Bellmore Avenue, Mountview Estate, Lansdowne
Wednesday, 3 September 2025
© DocNearby 2013
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `UserPractice`.`id`, `UserPractice`.`user_id`, `UserPractice`.`practice_id`, `UserPractice`.`role_id`, `UserPractice`.`is_bookable`, `UserPractice`.`consultation_duration_minutes`, `UserPractice`.`is_verified`, `UserPractice`.`is_active`, `UserPractice`.`created`, `UserPractice`.`modified`, `UserPractice`.`deleted`, `UserPractice`.`deleted_date`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`timezone`, `User`.`group_id`, `User`.`is_verified`, `User`.`verification_code`, `User`.`remember_me`, `User`.`primary_practice_id`, `User`.`activated`, `User`.`created`, `User`.`modified`, `User`.`deleted`, `User`.`deleted_date`, `Practice`.`id`, `Practice`.`city_id`, `Practice`.`name`, `Practice`.`picture_url`, `Practice`.`practice_type_id`, `Practice`.`practice_number`, `Practice`.`utc_open_time_hh_mm_ss`, `Practice`.`utc_close_time_hh_mm_ss`, `Practice`.`consultation_duration_minutes`, `Practice`.`address_1`, `Practice`.`address_2`, `Practice`.`address_3`, `Practice`.`city`, `Practice`.`suburb`, `Practice`.`province`, `Practice`.`postal_address_1`, `Practice`.`postal_address_2`, `Practice`.`postal_address_3`, `Practice`.`postal_postal_code`, `Practice`.`postal_city`, `Practice`.`postal_province`, `Practice`.`postal_code`, `Practice`.`tel`, `Practice`.`fax`, `Practice`.`email`, `Practice`.`lat`, `Practice`.`lng`, `Practice`.`timezone`, `Practice`.`geo`, `Practice`.`accuracy`, `Practice`.`created`, `Practice`.`modified`, `Practice`.`source`, `Practice`.`is_verified`, `Practice`.`is_active`, `Practice`.`deleted`, `Practice`.`deleted_date`, `Role`.`id`, `Role`.`name`, `Role`.`label`, `Role`.`display_order`, `Role`.`created`, `Role`.`modified`, `Role`.`deleted`, `Role`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_practices` AS `UserPractice` LEFT JOIN `docnecpr_southafrica_live1`.`users` AS `User` ON (`UserPractice`.`user_id` = `User`.`id`) LEFT JOIN `docnecpr_southafrica_live1`.`practices` AS `Practice` ON (`UserPractice`.`practice_id` = `Practice`.`id`) LEFT JOIN `docnecpr_southafrica_live1`.`roles` AS `Role` ON (`UserPractice`.`role_id` = `Role`.`id`) WHERE `UserPractice`.`id` = 47 AND `UserPractice`.`deleted` = '' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Group`.`deleted`, `Group`.`deleted_date` FROM `docnecpr_southafrica_live1`.`groups` AS `Group` WHERE `Group`.`id` = 2 | 1 | 1 | 0 | |
| 3 | SELECT `Profile`.`id`, `Profile`.`firstname`, `Profile`.`surname`, `Profile`.`public_name`, `Profile`.`picture_url`, `Profile`.`details`, `Profile`.`user_id`, `Profile`.`title_id`, `Profile`.`gender_id`, `Profile`.`language_id`, `Profile`.`id_no`, `Profile`.`created`, `Profile`.`modified`, `Profile`.`picture`, `Profile`.`deleted`, `Profile`.`deleted_date` FROM `docnecpr_southafrica_live1`.`profiles` AS `Profile` WHERE `Profile`.`user_id` = 76 | 1 | 1 | 3 | |
| 4 | SELECT `UserAddressDetail`.`id`, `UserAddressDetail`.`user_id`, `UserAddressDetail`.`address_1`, `UserAddressDetail`.`address_2`, `UserAddressDetail`.`address_3`, `UserAddressDetail`.`suburb`, `UserAddressDetail`.`city`, `UserAddressDetail`.`province`, `UserAddressDetail`.`postal_code`, `UserAddressDetail`.`post_address_1`, `UserAddressDetail`.`post_address_2`, `UserAddressDetail`.`post_address_3`, `UserAddressDetail`.`post_city`, `UserAddressDetail`.`post_province`, `UserAddressDetail`.`post_postal_code`, `UserAddressDetail`.`lat`, `UserAddressDetail`.`long`, `UserAddressDetail`.`created`, `UserAddressDetail`.`modified`, `UserAddressDetail`.`deleted`, `UserAddressDetail`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_address_details` AS `UserAddressDetail` WHERE `UserAddressDetail`.`user_id` = 76 | 0 | 0 | 0 | |
| 5 | SELECT `UserPractice`.`id`, `UserPractice`.`user_id`, `UserPractice`.`practice_id`, `UserPractice`.`role_id`, `UserPractice`.`is_bookable`, `UserPractice`.`consultation_duration_minutes`, `UserPractice`.`is_verified`, `UserPractice`.`is_active`, `UserPractice`.`created`, `UserPractice`.`modified`, `UserPractice`.`deleted`, `UserPractice`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_practices` AS `UserPractice` WHERE `UserPractice`.`deleted` = '' AND `UserPractice`.`user_id` = (76) | 1 | 1 | 2 | |
| 6 | SELECT `Event`.`id`, `Event`.`event_type_id`, `Event`.`event_status_id`, `Event`.`user_id`, `Event`.`user_practice_id`, `Event`.`title`, `Event`.`details`, `Event`.`start_date`, `Event`.`end_date`, `Event`.`is_all_day`, `Event`.`is_active`, `Event`.`created`, `Event`.`modified`, `Event`.`deleted`, `Event`.`deleted_date` FROM `docnecpr_southafrica_live1`.`events` AS `Event` WHERE `Event`.`user_id` = (76) | 0 | 0 | 0 | |
| 7 | SELECT `UserMedicalAidDependant`.`id`, `UserMedicalAidDependant`.`user_id`, `UserMedicalAidDependant`.`full_name`, `UserMedicalAidDependant`.`gender_id`, `UserMedicalAidDependant`.`dependant_code`, `UserMedicalAidDependant`.`dependant_dob`, `UserMedicalAidDependant`.`id_number`, `UserMedicalAidDependant`.`created`, `UserMedicalAidDependant`.`modified`, `UserMedicalAidDependant`.`deleted`, `UserMedicalAidDependant`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_medical_aid_dependants` AS `UserMedicalAidDependant` WHERE `UserMedicalAidDependant`.`user_id` = (76) | 0 | 0 | 0 | |
| 8 | SELECT `PracticeType`.`id`, `PracticeType`.`name`, `PracticeType`.`slug`, `PracticeType`.`is_general`, `PracticeType`.`ordering`, `PracticeType`.`is_active`, `PracticeType`.`created`, `PracticeType`.`modified`, `PracticeType`.`deleted`, `PracticeType`.`deleted_date` FROM `docnecpr_southafrica_live1`.`practice_types` AS `PracticeType` WHERE `PracticeType`.`id` = 1 | 1 | 1 | 0 | |
| 9 | SELECT `UserPractice`.`id`, `UserPractice`.`user_id`, `UserPractice`.`practice_id`, `UserPractice`.`role_id`, `UserPractice`.`is_bookable`, `UserPractice`.`consultation_duration_minutes`, `UserPractice`.`is_verified`, `UserPractice`.`is_active`, `UserPractice`.`created`, `UserPractice`.`modified`, `UserPractice`.`deleted`, `UserPractice`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_practices` AS `UserPractice` WHERE `UserPractice`.`deleted` = '' AND `UserPractice`.`role_id` = (1) | 4211 | 4211 | 7 | |
| 10 | SELECT `PractitionerPracticesAvailability`.`id`, `PractitionerPracticesAvailability`.`user_practices_id`, `PractitionerPracticesAvailability`.`mon`, `PractitionerPracticesAvailability`.`tue`, `PractitionerPracticesAvailability`.`wed`, `PractitionerPracticesAvailability`.`thu`, `PractitionerPracticesAvailability`.`fri`, `PractitionerPracticesAvailability`.`sat`, `PractitionerPracticesAvailability`.`sun`, `PractitionerPracticesAvailability`.`repeat_every_weeks`, `PractitionerPracticesAvailability`.`repeat_from_date`, `PractitionerPracticesAvailability`.`utc_start_time_hh_mm_ss`, `PractitionerPracticesAvailability`.`utc_end_time_hh_mm_ss`, `PractitionerPracticesAvailability`.`created`, `PractitionerPracticesAvailability`.`modified`, `PractitionerPracticesAvailability`.`deleted`, `PractitionerPracticesAvailability`.`deleted_date` FROM `docnecpr_southafrica_live1`.`practitioner_practices_availability` AS `PractitionerPracticesAvailability` WHERE `PractitionerPracticesAvailability`.`user_practices_id` = (47) | 1 | 1 | 2 | |
| 11 | SELECT `UserPractices`.`id`, `UserPractices`.`user_id`, `UserPractices`.`practice_id`, `UserPractices`.`role_id`, `UserPractices`.`is_bookable`, `UserPractices`.`consultation_duration_minutes`, `UserPractices`.`is_verified`, `UserPractices`.`is_active`, `UserPractices`.`created`, `UserPractices`.`modified`, `UserPractices`.`deleted`, `UserPractices`.`deleted_date` FROM `docnecpr_southafrica_live1`.`user_practices` AS `UserPractices` WHERE `UserPractices`.`id` = 47 | 1 | 1 | 0 | |
| 12 | SELECT `PractitionerPracticesBreak`.`id`, `PractitionerPracticesBreak`.`user_practices_id`, `PractitionerPracticesBreak`.`mon`, `PractitionerPracticesBreak`.`tue`, `PractitionerPracticesBreak`.`wed`, `PractitionerPracticesBreak`.`thu`, `PractitionerPracticesBreak`.`fri`, `PractitionerPracticesBreak`.`sat`, `PractitionerPracticesBreak`.`sun`, `PractitionerPracticesBreak`.`repeat_every_weeks`, `PractitionerPracticesBreak`.`repeat_from_date`, `PractitionerPracticesBreak`.`utc_start_time_hh_mm_ss`, `PractitionerPracticesBreak`.`utc_end_time_hh_mm_ss`, `PractitionerPracticesBreak`.`created`, `PractitionerPracticesBreak`.`modified`, `PractitionerPracticesBreak`.`deleted`, `PractitionerPracticesBreak`.`deleted_date` FROM `docnecpr_southafrica_live1`.`practitioner_practices_breaks` AS `PractitionerPracticesBreak` WHERE `PractitionerPracticesBreak`.`user_practices_id` = (47) | 0 | 0 | 0 | |
| 13 | SELECT `PractitionerPracticesLeave`.`id`, `PractitionerPracticesLeave`.`user_practices_id`, `PractitionerPracticesLeave`.`start_date`, `PractitionerPracticesLeave`.`end_date`, `PractitionerPracticesLeave`.`is_fullday`, `PractitionerPracticesLeave`.`created`, `PractitionerPracticesLeave`.`modified`, `PractitionerPracticesLeave`.`deleted`, `PractitionerPracticesLeave`.`deleted_date` FROM `docnecpr_southafrica_live1`.`practitioner_practices_leave` AS `PractitionerPracticesLeave` WHERE `PractitionerPracticesLeave`.`user_practices_id` = (47) | 0 | 0 | 0 |