test
Ali children clinic adiala road Rawalpindi, Adyala Road, Ali Town Munawar Colony, Rawalpindi, Pakistan
Total experience 5 years.
| 1 x Application (70.76%) | 21.88ms |
| 1 x Booting (28.99%) | 8.97ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
select `name`, `id` from `treatments` where `treatments`.`deleted_at` is null| Metadata | |
|---|---|
| Backtrace |
|
select `staff`.*, `job_titles`.`name` as `job_title`, `staff_locations`.`location_id`, `locations`.`name` as `location_name`, `locations`.`address` as `location_address`, `locations`.`city` as `location_city`, `locations`.`consultation_fee`, GROUP_CONCAT(DISTINCT treatments.name) as treatments, AVG(staff_location_reviews.star) as average_rating, COUNT(DISTINCT staff_location_reviews.id) as total_reviews from `staff` inner join `staff_locations` on `staff`.`id` = `staff_locations`.`staff_id` inner join `locations` on `locations`.`id` = `staff_locations`.`location_id` left join `job_titles` on `staff`.`job_title_id` = `job_titles`.`id` left join `staff_treatments` on `staff`.`id` = `staff_treatments`.`staff_id` and `staff_locations`.`location_id` = `staff_treatments`.`location_id` left join `treatments` on `staff_treatments`.`treatment_id` = `treatments`.`id` left join `staff_location_reviews` on `staff`.`id` = `staff_location_reviews`.`staff_id` and `staff_locations`.`location_id` = `staff_location_reviews`.`location_id` and `staff_location_reviews`.`status` = 1 where `staff`.`status` = 1 and `staff`.`id` = 2038 and `locations`.`id` = '3939' and `staff`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `locations`.*, `job_titles`.`name` as `job_title`, `staff`.`id` as `staff_id`, `staff`.`name` as `doc_name`, `staff_locations`.`location_id`, `staff`.`job_title_id`, `staff`.`specialization_ids`, GROUP_CONCAT(DISTINCT treatments.name) as treatments, AVG(staff_location_reviews.star) as average_rating, COUNT(DISTINCT staff_location_reviews.id) as total_reviews from `locations` inner join `staff_locations` on `locations`.`id` = `staff_locations`.`location_id` inner join `staff` on `staff`.`id` = `staff_locations`.`staff_id` left join `job_titles` on `staff`.`job_title_id` = `job_titles`.`id` left join `staff_treatments` on `staff`.`id` = `staff_treatments`.`staff_id` and `staff_locations`.`location_id` = `staff_treatments`.`location_id` left join `treatments` on `staff_treatments`.`treatment_id` = `treatments`.`id` left join `staff_location_reviews` on `staff`.`id` = `staff_location_reviews`.`staff_id` and `staff_locations`.`location_id` = `staff_location_reviews`.`location_id` and `staff_location_reviews`.`status` = 1 where `staff`.`status` = 1 and `staff`.`id` = 2038 and `locations`.`deleted_at` is null group by `locations`.`id`, `job_titles`.`name`, `staff`.`id`, `staff`.`name`, `staff_locations`.`location_id`, `staff`.`job_title_id`, `staff`.`specialization_ids` order by `locations`.`id` desc limit 10| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `locations`.*, `staff_locations`.`staff_id` as `pivot_staff_id`, `staff_locations`.`location_id` as `pivot_location_id` from `locations` inner join `staff_locations` on `locations`.`id` = `staff_locations`.`location_id` where `staff_locations`.`staff_id` in (2038) and `locations`.`deleted_at` is null| Metadata | |
|---|---|
| Backtrace |
|
select * from `staff_treatments` where `staff_id` = 2038 and `location_id` in (2038, 3939)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `locations` where `locations`.`id` = '3939' and `locations`.`deleted_at` is null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_timings` where `staff_id` = 2038 and `location_id` = '3939'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `staff_location_reviews` where `status` = '1' and `staff_id` = 2038 and `location_id` = 3939 and `staff_location_reviews`.`deleted_at` is null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `name`, `id` from `specializations` where `specializations`.`deleted_at` is null| Metadata | |
|---|---|
| Backtrace |
|
200
[]
[]
0 of 0array:9 [▼ "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate" ] "host" => array:1 [▶ 0 => "www.tibimalumat.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "x-forwarded-for" => array:1 [▶ 0 => "216.73.216.167" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-hdhg5 (squid/6.10)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] ]
0 of 0array:35 [▼ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, deflate" "HTTP_HOST" => "www.tibimalumat.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_X_FORWARDED_FOR" => "216.73.216.167" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-hdhg5 (squid/6.10)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "DOCUMENT_ROOT" => "/home/labsmfga/public_html/tibimalumat.com/public" "REMOTE_ADDR" => "216.73.216.167" "REMOTE_PORT" => "52666" "SERVER_ADDR" => "66.29.146.27" "SERVER_NAME" => "www.tibimalumat.com" "SERVER_ADMIN" => "webmaster@tibimalumat.com.labstestprices.com" "SERVER_PORT" => "80" "REQUEST_SCHEME" => "http" "REQUEST_URI" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNhMjNiYWFkYzM5Zjc0ZjgyNDcyYTQ3ZDBmOWMzNjA1ZGU1YWJiNWY5YTk5NiIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNh ▶" "REDIRECT_URL" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNhMjNiYWFkYzM5Zjc0ZjgyNDcyYTQ3ZDBmOWMzNjA1ZGU1YWJiNWY5YTk5NiIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNh ▶" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "66.29.146.27" "REDIRECT_STATUS" => "200" "SCRIPT_FILENAME" => "/home/labsmfga/public_html/tibimalumat.com/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNhMjNiYWFkYzM5Zjc0ZjgyNDcyYTQ3ZDBmOWMzNjA1ZGU1YWJiNWY5YTk5NiIsInRhZyI6IiJ9 ◀http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiOD ▶" "SCRIPT_URL" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNhMjNiYWFkYzM5Zjc0ZjgyNDcyYTQ3ZDBmOWMzNjA1ZGU1YWJiNWY5YTk5NiIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNh ▶" "SCRIPT_NAME" => "/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755196707.9615 "REQUEST_TIME" => 1755196707 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 14 Aug 2025 18:38:27 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ilk3THROR0Z5aFhERVkybTFUTlJTU1E9PSIsInZhbHVlIjoiVHJUcTVBQ3gyQ3ZPNVpjSGJvb3RqTFk3bkF0eVpUa2lKdlVidnNLOFBSWG5WOUFHQ3NqYTQzN3ZUaEdIZlBwWGF1Sm54NXlycjZMTy9LUnJtT2gyM2oxR1hUczVaa2FIMUgvbU0rYTc5ZW4ybFhGYVpUZ3BEUDQwdUNLbktsc3IiLCJtYWMiOiJlZjM5YWM5N2U1ZWYwMzkwNDRhNzE1M2U0MGJkNjMwNWQ5ZjkxZGYxNWQxNDllZjFhOTJhM2FhMGI1NTgwZjIyIiwidGFnIjoiIn0%3D; expires=Thu, 14 Aug 2025 20:38:27 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ilk3THROR0Z5aFhERVkybTFUTlJTU1E9PSIsInZhbHVlIjoiVHJUcTVBQ3gyQ3ZPNVpjSGJvb3RqTFk3bkF0eVpUa2lKdlVidnNLOFBSWG5WOUFHQ3NqYTQzN3ZUaEdIZlBwWGF1Sm54N ▶" 1 => "tibimalumat_session=eyJpdiI6IjVMNnA0SGNEVS9nVXJUZHZHVUYrL1E9PSIsInZhbHVlIjoiMDF0bHRqOFprR3R3aXNxb1d1bEpZMHpWejJpTWZVQk9sdzZ3bXdxL21zc3A2N202OVkwVjdRdzlaZlc1MzcrbldJOURELzhGRXp0ZFdJVjFnTGREK0ZKb0gvd2JHRFZ0RFg5ZDcrVUtrVnNoMmYwdEd0UkQ2VDduM0hoRXREeG4iLCJtYWMiOiI1YjQ4ODlkZDkxMzgwZjIyZmE5YzIzODNjMmE3NjQ2ZmVlZjg2NzkyNmUzNWIwODZkYjUzZWVhNWEwNzY4NTQzIiwidGFnIjoiIn0%3D; expires=Thu, 14 Aug 2025 20:38:27 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀tibimalumat_session=eyJpdiI6IjVMNnA0SGNEVS9nVXJUZHZHVUYrL1E9PSIsInZhbHVlIjoiMDF0bHRqOFprR3R3aXNxb1d1bEpZMHpWejJpTWZVQk9sdzZ3bXdxL21zc3A2N202OVkwVjdRdzlaZlc1Mzcr ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ilk3THROR0Z5aFhERVkybTFUTlJTU1E9PSIsInZhbHVlIjoiVHJUcTVBQ3gyQ3ZPNVpjSGJvb3RqTFk3bkF0eVpUa2lKdlVidnNLOFBSWG5WOUFHQ3NqYTQzN3ZUaEdIZlBwWGF1Sm54NXlycjZMTy9LUnJtT2gyM2oxR1hUczVaa2FIMUgvbU0rYTc5ZW4ybFhGYVpUZ3BEUDQwdUNLbktsc3IiLCJtYWMiOiJlZjM5YWM5N2U1ZWYwMzkwNDRhNzE1M2U0MGJkNjMwNWQ5ZjkxZGYxNWQxNDllZjFhOTJhM2FhMGI1NTgwZjIyIiwidGFnIjoiIn0%3D; expires=Thu, 14-Aug-2025 20:38:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ilk3THROR0Z5aFhERVkybTFUTlJTU1E9PSIsInZhbHVlIjoiVHJUcTVBQ3gyQ3ZPNVpjSGJvb3RqTFk3bkF0eVpUa2lKdlVidnNLOFBSWG5WOUFHQ3NqYTQzN3ZUaEdIZlBwWGF1Sm54N ▶" 1 => "tibimalumat_session=eyJpdiI6IjVMNnA0SGNEVS9nVXJUZHZHVUYrL1E9PSIsInZhbHVlIjoiMDF0bHRqOFprR3R3aXNxb1d1bEpZMHpWejJpTWZVQk9sdzZ3bXdxL21zc3A2N202OVkwVjdRdzlaZlc1MzcrbldJOURELzhGRXp0ZFdJVjFnTGREK0ZKb0gvd2JHRFZ0RFg5ZDcrVUtrVnNoMmYwdEd0UkQ2VDduM0hoRXREeG4iLCJtYWMiOiI1YjQ4ODlkZDkxMzgwZjIyZmE5YzIzODNjMmE3NjQ2ZmVlZjg2NzkyNmUzNWIwODZkYjUzZWVhNWEwNzY4NTQzIiwidGFnIjoiIn0%3D; expires=Thu, 14-Aug-2025 20:38:27 GMT; path=/; httponly ◀tibimalumat_session=eyJpdiI6IjVMNnA0SGNEVS9nVXJUZHZHVUYrL1E9PSIsInZhbHVlIjoiMDF0bHRqOFprR3R3aXNxb1d1bEpZMHpWejJpTWZVQk9sdzZ3bXdxL21zc3A2N202OVkwVjdRdzlaZlc1Mzcr ▶" ] ]
0 of 0array:4 [▼ "_token" => "BpdcBo8evrc1G2C3nAQBwaPl6mmGAxxxh8NtYLvq" "_previous" => array:1 [▶ "url" => "http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiODIxMzA5MzUwMGYxZDAwNzU5MzNhMjNiYWFkYzM5Zjc0ZjgyNDcyYTQ3ZDBmOWMzNjA1ZGU1YWJiNWY5YTk5NiIsInRhZyI6IiJ9 ◀http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IklEK2IwRENpVkpobVJDUWZmc0d4QUE9PSIsInZhbHVlIjoibDRyMC9WOEQ4MUNEZ3FTSFJFSkp1UT09IiwibWFjIjoiOD ▶" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]