test
Ali children clinic adiala road Rawalpindi, Adyala Road, Ali Town Munawar Colony, Rawalpindi, Pakistan
Total experience 5 years.
| 1 x Application (78.98%) | 292.70ms |
| 1 x Booting (21.01%) | 77.85ms |
| 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.111" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-q8vc7 (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.111" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-q8vc7 (squid/6.10)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "DOCUMENT_ROOT" => "/home/labsmfga/public_html/tibimalumat.com/public" "REMOTE_ADDR" => "216.73.216.111" "REMOTE_PORT" => "38578" "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/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIyZjQ4MDBjZTAxMzk3MjdhNDE0NjQ2YzA1ZmQyYzNkYjJlNWJjMTZmYzYxMSIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIy ▶" "REDIRECT_URL" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIyZjQ4MDBjZTAxMzk3MjdhNDE0NjQ2YzA1ZmQyYzNkYjJlNWJjMTZmYzYxMSIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIy ▶" "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/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIyZjQ4MDBjZTAxMzk3MjdhNDE0NjQ2YzA1ZmQyYzNkYjJlNWJjMTZmYzYxMSIsInRhZyI6IiJ9 ◀http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZT ▶" "SCRIPT_URL" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIyZjQ4MDBjZTAxMzk3MjdhNDE0NjQ2YzA1ZmQyYzNkYjJlNWJjMTZmYzYxMSIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIy ▶" "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" => 1755102889.407 "REQUEST_TIME" => 1755102889 ]
[]
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 => "Wed, 13 Aug 2025 16:34:49 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InREWW40cTNPWVNUOE5QVG1lQzBPbHc9PSIsInZhbHVlIjoiRTlSR1BiRHRhNmlmWW9IaWpZeDhBY3k5SWJnY05CR0dtb2tUK0pTcE12NGJXa0pIVjltNm1Zbk5sVkRNYkZsWTcrY21kQ3JyejVXdnZQWnVCU2d3WWtoUUhLSG4wTW9Fako3WWJMcjFTeXNxSGhpL08xbVB6YWFtakZjQ2JqU1oiLCJtYWMiOiJjNWI5NzJhYzk4YWVkODc1MzI4MTQ2ZGIxMDJkNzdjNWYyMTY0YzQ3NDVlMmVmYTIyOGNmZjk5ODE2NTY2NDdmIiwidGFnIjoiIn0%3D; expires=Wed, 13 Aug 2025 18:34:49 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InREWW40cTNPWVNUOE5QVG1lQzBPbHc9PSIsInZhbHVlIjoiRTlSR1BiRHRhNmlmWW9IaWpZeDhBY3k5SWJnY05CR0dtb2tUK0pTcE12NGJXa0pIVjltNm1Zbk5sVkRNYkZsWTcrY21kQ ▶" 1 => "tibimalumat_session=eyJpdiI6IkxGUWxBNmw2RkJlYk5uaWRkVnBNaHc9PSIsInZhbHVlIjoiZE1iWHM0OW40emF6SDdFZUtOMEloYkt4SWdzamVxT2ZxOFptckZHZXc1VHZnbUQ5L3NtTlVrZkxVeVVVOXpSNHl0c2xtZ0RUenVkdE9CbCthQ2g2a2loelVXYmdOWmljZ0dyYW1jWnN5cjIwUTEwNVUyNUF2bjgxVUs1NXBrQkMiLCJtYWMiOiI4MDQ0MTE0OWQyNDI2OTliYzFjOTQ5NGMyOTg3N2RiNGIxMTdiNDg1NjU0MTBhZTM5ZmNjYTc2ZmExY2QxNjM1IiwidGFnIjoiIn0%3D; expires=Wed, 13 Aug 2025 18:34:49 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀tibimalumat_session=eyJpdiI6IkxGUWxBNmw2RkJlYk5uaWRkVnBNaHc9PSIsInZhbHVlIjoiZE1iWHM0OW40emF6SDdFZUtOMEloYkt4SWdzamVxT2ZxOFptckZHZXc1VHZnbUQ5L3NtTlVrZkxVeVVVOXpS ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InREWW40cTNPWVNUOE5QVG1lQzBPbHc9PSIsInZhbHVlIjoiRTlSR1BiRHRhNmlmWW9IaWpZeDhBY3k5SWJnY05CR0dtb2tUK0pTcE12NGJXa0pIVjltNm1Zbk5sVkRNYkZsWTcrY21kQ3JyejVXdnZQWnVCU2d3WWtoUUhLSG4wTW9Fako3WWJMcjFTeXNxSGhpL08xbVB6YWFtakZjQ2JqU1oiLCJtYWMiOiJjNWI5NzJhYzk4YWVkODc1MzI4MTQ2ZGIxMDJkNzdjNWYyMTY0YzQ3NDVlMmVmYTIyOGNmZjk5ODE2NTY2NDdmIiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 18:34:49 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InREWW40cTNPWVNUOE5QVG1lQzBPbHc9PSIsInZhbHVlIjoiRTlSR1BiRHRhNmlmWW9IaWpZeDhBY3k5SWJnY05CR0dtb2tUK0pTcE12NGJXa0pIVjltNm1Zbk5sVkRNYkZsWTcrY21kQ ▶" 1 => "tibimalumat_session=eyJpdiI6IkxGUWxBNmw2RkJlYk5uaWRkVnBNaHc9PSIsInZhbHVlIjoiZE1iWHM0OW40emF6SDdFZUtOMEloYkt4SWdzamVxT2ZxOFptckZHZXc1VHZnbUQ5L3NtTlVrZkxVeVVVOXpSNHl0c2xtZ0RUenVkdE9CbCthQ2g2a2loelVXYmdOWmljZ0dyYW1jWnN5cjIwUTEwNVUyNUF2bjgxVUs1NXBrQkMiLCJtYWMiOiI4MDQ0MTE0OWQyNDI2OTliYzFjOTQ5NGMyOTg3N2RiNGIxMTdiNDg1NjU0MTBhZTM5ZmNjYTc2ZmExY2QxNjM1IiwidGFnIjoiIn0%3D; expires=Wed, 13-Aug-2025 18:34:49 GMT; path=/; httponly ◀tibimalumat_session=eyJpdiI6IkxGUWxBNmw2RkJlYk5uaWRkVnBNaHc9PSIsInZhbHVlIjoiZE1iWHM0OW40emF6SDdFZUtOMEloYkt4SWdzamVxT2ZxOFptckZHZXc1VHZnbUQ5L3NtTlVrZkxVeVVVOXpS ▶" ] ]
0 of 0array:4 [▼ "_token" => "NeZId2zAJBnCYuZ83jvTRWQqc4IbunWaixItgAQK" "_previous" => array:1 [▶ "url" => "http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZTdhZTJlZTkwYWQ0MmE2OTE3YzIyZjQ4MDBjZTAxMzk3MjdhNDE0NjQ2YzA1ZmQyYzNkYjJlNWJjMTZmYzYxMSIsInRhZyI6IiJ9 ◀http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6IjcrZGtDc0xEL09Lb3U5bENzR29HVkE9PSIsInZhbHVlIjoibVRvdWY1K0Y1ZWxVQnA0MzZOVFNidz09IiwibWFjIjoiZT ▶" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]