test
Ali children clinic adiala road Rawalpindi, Adyala Road, Ali Town Munawar Colony, Rawalpindi, Pakistan
Total experience 5 years.
| 1 x Application (74.6%) | 1.11s |
| 1 x Booting (25.39%) | 376.28ms |
| 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.217" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-c57bj (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.217" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-c57bj (squid/6.10)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "DOCUMENT_ROOT" => "/home/labsmfga/public_html/tibimalumat.com/public" "REMOTE_ADDR" => "216.73.216.217" "REMOTE_PORT" => "55926" "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/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5ZjlhZTE5OGZmN2YxYWUxMjFhMTA1MThkMmQ5YmNhOTMwNTZkMjE1NTg5MzU5MCIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5Zjlh ▶" "REDIRECT_URL" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5ZjlhZTE5OGZmN2YxYWUxMjFhMTA1MThkMmQ5YmNhOTMwNTZkMjE1NTg5MzU5MCIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5Zjlh ▶" "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/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5ZjlhZTE5OGZmN2YxYWUxMjFhMTA1MThkMmQ5YmNhOTMwNTZkMjE1NTg5MzU5MCIsInRhZyI6IiJ9 ◀http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNT ▶" "SCRIPT_URL" => "/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5ZjlhZTE5OGZmN2YxYWUxMjFhMTA1MThkMmQ5YmNhOTMwNTZkMjE1NTg5MzU5MCIsInRhZyI6IiJ9 ◀/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5Zjlh ▶" "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" => 1753495228.069 "REQUEST_TIME" => 1753495228 ]
[]
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 => "Sat, 26 Jul 2025 02:00:29 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkYzTzBBYlA2eTJlaGZOSmNCTTloaUE9PSIsInZhbHVlIjoiNlh1Z1lscG0wdko3MVVWOWg1NXNpYkxOY2F0YlBNZDNoc0ZtMktFNGFMdzkxSEppa0EwcFJvTm1oamRYQTU4NXB1aU9YQVUrNXZ4c1RwUGlJR3I1UU5wQTJic00zOFV4eCtKRXQrdzlHVGZ0UC9aVEhDeC9KaWZRbUF1d1cyVTIiLCJtYWMiOiI5ZTJiMjVhZjE3MDIzOTdmYmFjNTkzNzY5NzNiZDE5Mzk3ZWZhNDJiMjI2YzU1NjRhNzAxZjlkYTI2YzY4MTE4IiwidGFnIjoiIn0%3D; expires=Sat, 26 Jul 2025 04:00:29 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkYzTzBBYlA2eTJlaGZOSmNCTTloaUE9PSIsInZhbHVlIjoiNlh1Z1lscG0wdko3MVVWOWg1NXNpYkxOY2F0YlBNZDNoc0ZtMktFNGFMdzkxSEppa0EwcFJvTm1oamRYQTU4NXB1aU9YQ ▶" 1 => "tibimalumat_session=eyJpdiI6IkZqUmpkMUg3ZVc3YU9OaXVKT3I0T0E9PSIsInZhbHVlIjoiK0lZTmV4RkpUa1hTdFlDZ21sNFFiY2k0MjMyWTNjNkJXUVVJYWpma0dEN2M4ZVNvT1FjWTVFN2RKRjNneDliQUN4blBvMGJJS2xkV0JFVFJXYXN4RVZuV2NkNlFDL0hUQ3dmMVVLK3h1R1BKRjIvTnNaOTFraCtBTldydUMydEMiLCJtYWMiOiJmZjc3MmRkY2ZkZTgwZmQ2ODFmYTI4Mzc4NTQzNjVjMTk3OTcwYzQwYzJlNWM1NjExOGEyYjhjYmJjYmRjN2M5IiwidGFnIjoiIn0%3D; expires=Sat, 26 Jul 2025 04:00:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀tibimalumat_session=eyJpdiI6IkZqUmpkMUg3ZVc3YU9OaXVKT3I0T0E9PSIsInZhbHVlIjoiK0lZTmV4RkpUa1hTdFlDZ21sNFFiY2k0MjMyWTNjNkJXUVVJYWpma0dEN2M4ZVNvT1FjWTVFN2RKRjNneDli ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkYzTzBBYlA2eTJlaGZOSmNCTTloaUE9PSIsInZhbHVlIjoiNlh1Z1lscG0wdko3MVVWOWg1NXNpYkxOY2F0YlBNZDNoc0ZtMktFNGFMdzkxSEppa0EwcFJvTm1oamRYQTU4NXB1aU9YQVUrNXZ4c1RwUGlJR3I1UU5wQTJic00zOFV4eCtKRXQrdzlHVGZ0UC9aVEhDeC9KaWZRbUF1d1cyVTIiLCJtYWMiOiI5ZTJiMjVhZjE3MDIzOTdmYmFjNTkzNzY5NzNiZDE5Mzk3ZWZhNDJiMjI2YzU1NjRhNzAxZjlkYTI2YzY4MTE4IiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 04:00:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkYzTzBBYlA2eTJlaGZOSmNCTTloaUE9PSIsInZhbHVlIjoiNlh1Z1lscG0wdko3MVVWOWg1NXNpYkxOY2F0YlBNZDNoc0ZtMktFNGFMdzkxSEppa0EwcFJvTm1oamRYQTU4NXB1aU9YQ ▶" 1 => "tibimalumat_session=eyJpdiI6IkZqUmpkMUg3ZVc3YU9OaXVKT3I0T0E9PSIsInZhbHVlIjoiK0lZTmV4RkpUa1hTdFlDZ21sNFFiY2k0MjMyWTNjNkJXUVVJYWpma0dEN2M4ZVNvT1FjWTVFN2RKRjNneDliQUN4blBvMGJJS2xkV0JFVFJXYXN4RVZuV2NkNlFDL0hUQ3dmMVVLK3h1R1BKRjIvTnNaOTFraCtBTldydUMydEMiLCJtYWMiOiJmZjc3MmRkY2ZkZTgwZmQ2ODFmYTI4Mzc4NTQzNjVjMTk3OTcwYzQwYzJlNWM1NjExOGEyYjhjYmJjYmRjN2M5IiwidGFnIjoiIn0%3D; expires=Sat, 26-Jul-2025 04:00:29 GMT; path=/; httponly ◀tibimalumat_session=eyJpdiI6IkZqUmpkMUg3ZVc3YU9OaXVKT3I0T0E9PSIsInZhbHVlIjoiK0lZTmV4RkpUa1hTdFlDZ21sNFFiY2k0MjMyWTNjNkJXUVVJYWpma0dEN2M4ZVNvT1FjWTVFN2RKRjNneDli ▶" ] ]
0 of 0array:4 [▼ "_token" => "DGduQyVBOEBhTzxRnOqqm3P8s6g9dGBfFfjq9vd3" "_previous" => array:1 [▶ "url" => "http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNTU3MjFmNWMyNTgyN2YwM2U5ZjlhZTE5OGZmN2YxYWUxMjFhMTA1MThkMmQ5YmNhOTMwNTZkMjE1NTg5MzU5MCIsInRhZyI6IiJ9 ◀http://www.tibimalumat.com/doctors/test/aaishah-riaz/3939/eyJpdiI6Ik5XNzdWT1dPZUlMSDdoM25NOTc4Ymc9PSIsInZhbHVlIjoiSVN3dTA1RU9CVXlsOXYvQXRoTE1CUT09IiwibWFjIjoiNT ▶" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]