| 1 x Application (84.73%) | 95.46ms |
| 1 x Booting (15.15%) | 17.07ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
| 39 | |
| 40 | |
| 41 | |
| 42 | |
| 43 | |
| 44 | |
| 45 | |
| 46 | |
| 47 | |
select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'en'1.44ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` order by `id` desc560μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 order by `id` desc490μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 and `code` = 'en' limit 1860μsmiddleware::lang:27lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `mi_clinic`.`id`, `mi_clinic`.`slug`, `mi_clinic`.`hit`, `mi_clinic`.`gold`, `mi_clinic`.`featured`, `mi_clinic`.`logo`, `mi_clinic`.`image`, `mi_clinic`.`small_image`, `mi_clinic`.`meta_title`, `mi_clinic`.`meta_desc`, `mi_clinic`.`status`, `mi_clinic`.`show_type`, `mi_clinic`.`order_no`, `mi_clinic`.`inq_alert`, `mi_clinic`.`language_codes`, `mi_clinic`.`service_item_codes`, `mi_clinic`.`guarantee_item_codes`, `mi_clinic`.`business_time_table`, `mi_clinic`.`landing_images`, `mi_clinic`.`created_at`, `mi_clinic`.`updated_at`, IFNULL(`mi_trans`.`name`,`mi_clinic`.`name`) as `name`, IFNULL(`mi_trans`.`address`,`mi_clinic`.`address`) as `address`, IFNULL(`mi_trans`.`description`,`mi_clinic`.`description`) as `description`, IFNULL(`mi_trans`.`business_time`,`mi_clinic`.`business_time`) as `business_time`, IFNULL(`mi_trans`.`business_hour`,`mi_clinic`.`business_hour`) as `business_hour` from `mi_clinic` left join `mi_clinic_trans` as `mi_trans` on `mi_trans`.`clinic_id` = `mi_clinic`.`id` and `mi_trans`.`lang_id` = 'en' where `mi_clinic`.`slug` = 'hyundal-mlhak-plastic-surgery' limit 1940μs/app/Http/Controllers/Mobile/ClinicController.php:430lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `mi_cl_image`.*, `mi_gr`.`code` from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `mi_cl_image`.`clinic_id` = 61 and `mi_gr`.`code` = 'top-image'920μs/app/Http/Controllers/Mobile/ClinicController.php:441lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select COUNT(id) AS review_count, AVG(rating_01) AS rating_01, AVG(rating_02) AS rating_02, AVG(rating_03) AS rating_03, AVG(rating_04) AS rating_04, AVG(rating_05) AS rating_05 from `mi_review` where `clinic_id` = 61 group by `clinic_id` limit 1510μs/app/Http/Controllers/Mobile/ClinicController.php:452lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `mi_user_follow` where `post_type` = 'clinic' and `post_id` = 61390μs/app/Http/Controllers/Mobile/ClinicController.php:484lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `mi_review`.`id`, `mi_review`.`slug`, `mi_review`.`created_at`, `mi_review`.`review_type`, `mi_user`.`name` as `username`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`content`, `mi_review`.`content`) AS `content`, `mi_review`.`show_type`, `mi_img1`.`path` as `before_path`, `mi_clinic`.`slug` as `clinic_slug`, `mi_category`.`id` as `category_id`, IFNULL(`mi_ct`.`title`, `mi_category`.`title`) AS `category_title` from `mi_review` left join `mi_images_review` as `mi_img1` on `mi_img1`.`review_id` = `mi_review`.`id` and `mi_img1`.`flag` = 'before' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'en' left join `mi_clinic` on `mi_clinic`.`id` = `mi_review`.`clinic_id` left join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_ct` on `mi_ct`.`cat_id` = `mi_category`.`id` and `mi_ct`.`lang_id` = 'en' left join `mi_user` on `mi_user`.`id` = `mi_review`.`user_id` where `mi_review`.`review_type` in ('treat', 'consult', 'livechat') and `mi_review`.`clinic_id` = 61 order by `mi_review`.`created_at` asc1.09ms/app/Http/Controllers/Mobile/ClinicController.php:201lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `mi_clinic_review`.*, `mi_user`.`username`, `mi_user`.`profile_image` from `mi_clinic_review` left join `mi_user` on `mi_user`.`id` = `mi_clinic_review`.`user_id` where `clinic_id` = 61 order by `created_at` desc1.55ms/app/Http/Controllers/Mobile/ClinicController.php:215lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select COUNT(id) AS review_count, AVG(rating_05) AS rating, `review_type` from `mi_review` where `clinic_id` = 61 group by `review_type`610μs/app/Http/Controllers/Mobile/ClinicController.php:229lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select avg(`rating`) as aggregate from `mi_clinic_review` where `clinic_id` = 61 and `type` = 'livechat'340μs/app/Http/Controllers/Mobile/ClinicController.php:232lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select avg(`rating`) as aggregate from `mi_clinic_review` where `clinic_id` = 61 and `type` = 'consult'600μs/app/Http/Controllers/Mobile/ClinicController.php:233lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:11 [▶ "host" => array:1 [▶ 0 => "dev.misooda.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "cookie" => array:1 [▶ 0 => "misooda=men1F9KLoA4Z6rI14swwwRfGbYzOZTUangKY7YSB; XSRF-TOKEN=eyJpdiI6IkdsZ3AyQzBQSm93ZnluWGl4S2FCXC9RPT0iLCJ2YWx1ZSI6IkJ4N28xdFBsa3NDMWdWc2FXVmJCSnBJYVJWTk1SbXJNUkcyZXRiVCtHNEI3MEh4aFQrYjhLSmI0V0ZNcFNZZ3YiLCJtYWMiOiJiNzY3YzVhZTUwOWMzOWFmZjdkYmQzZmQ5ZGEwNzM1N2UzNGFlMDQ3Mzg0OGUyOTUyOTJjMTdjY2UzZDdkOGMwIn0%3D; _fbp=fb.1.1750543033685.846983996910278637 ◀misooda=men1F9KLoA4Z6rI14swwwRfGbYzOZTUangKY7YSB; XSRF-TOKEN=eyJpdiI6IkdsZ3AyQzBQSm93ZnluWGl4S2FCXC9RPT0iLCJ2YWx1ZSI6IkJ4N28xdFBsa3NDMWdWc2FXVmJCSnBJYVJWTk1SbXJ ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.3.59.54" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] ]
0 of 0array:36 [▶ "REDIRECT_STATUS" => "200" "HTTP_HOST" => "dev.misooda.com" "HTTP_PRAGMA" => "no-cache" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_COOKIE" => "misooda=men1F9KLoA4Z6rI14swwwRfGbYzOZTUangKY7YSB; XSRF-TOKEN=eyJpdiI6IkdsZ3AyQzBQSm93ZnluWGl4S2FCXC9RPT0iLCJ2YWx1ZSI6IkJ4N28xdFBsa3NDMWdWc2FXVmJCSnBJYVJWTk1SbXJNUkcyZXRiVCtHNEI3MEh4aFQrYjhLSmI0V0ZNcFNZZ3YiLCJtYWMiOiJiNzY3YzVhZTUwOWMzOWFmZjdkYmQzZmQ5ZGEwNzM1N2UzNGFlMDQ3Mzg0OGUyOTUyOTJjMTdjY2UzZDdkOGMwIn0%3D; _fbp=fb.1.1750543033685.846983996910278637 ◀misooda=men1F9KLoA4Z6rI14swwwRfGbYzOZTUangKY7YSB; XSRF-TOKEN=eyJpdiI6IkdsZ3AyQzBQSm93ZnluWGl4S2FCXC9RPT0iLCJ2YWx1ZSI6IkJ4N28xdFBsa3NDMWdWc2FXVmJCSnBJYVJWTk1SbXJ ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.3.59.54" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)" "SERVER_NAME" => "dev.misooda.com" "SERVER_ADDR" => "139.59.109.168" "SERVER_PORT" => "80" "REMOTE_ADDR" => "216.73.216.254" "DOCUMENT_ROOT" => "/var/www/dev/html" "REQUEST_SCHEME" => "http" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/dev/html" "SERVER_ADMIN" => "webmaster@localhost" "SCRIPT_FILENAME" => "/var/www/dev/html/index.php" "REMOTE_PORT" => "25679" "REDIRECT_URL" => "/m/en/clinic/hyundal-mlhak-plastic-surgery/rating" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/en/clinic/hyundal-mlhak-plastic-surgery/rating" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750543035.855 "REQUEST_TIME" => 1750543035 ]
0 of 0array:3 [▶ "misooda" => null "XSRF-TOKEN" => "LuhWcHZJMgazF77hYjraos3x7f7LO3KiG2LnqL3H" "_fbp" => null ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 21 Jun 2025 21:57:15 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtrYm8reGFXbXpEUWFOOGNlamo1SGc9PSIsInZhbHVlIjoienEza09aaElqYWw1OTV2Rkh4QmlRZHNpUDJXdG9JbWM1OGdIVDQ5QWdWenJnSG83aEJqd0x6SXd3ZXlKZnU5TyIsIm1hYyI6IjVjNDdjMzlkNzQyZWU3ZTU4NjUyNGQ2ZTkwMjAzODE3ZGFmYjRmOGIzNWQwZjYyNjkyNzg1ZTY1YTliOWJlZmQifQ%3D%3D; expires=Sat, 21-Jun-2025 23:57:15 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImtrYm8reGFXbXpEUWFOOGNlamo1SGc9PSIsInZhbHVlIjoienEza09aaElqYWw1OTV2Rkh4QmlRZHNpUDJXdG9JbWM1OGdIVDQ5QWdWenJnSG83aEJqd0x6SXd3ZXlKZnU5TyIsIm1hY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtrYm8reGFXbXpEUWFOOGNlamo1SGc9PSIsInZhbHVlIjoienEza09aaElqYWw1OTV2Rkh4QmlRZHNpUDJXdG9JbWM1OGdIVDQ5QWdWenJnSG83aEJqd0x6SXd3ZXlKZnU5TyIsIm1hYyI6IjVjNDdjMzlkNzQyZWU3ZTU4NjUyNGQ2ZTkwMjAzODE3ZGFmYjRmOGIzNWQwZjYyNjkyNzg1ZTY1YTliOWJlZmQifQ%3D%3D; expires=Sat, 21-Jun-2025 23:57:15 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImtrYm8reGFXbXpEUWFOOGNlamo1SGc9PSIsInZhbHVlIjoienEza09aaElqYWw1OTV2Rkh4QmlRZHNpUDJXdG9JbWM1OGdIVDQ5QWdWenJnSG83aEJqd0x6SXd3ZXlKZnU5TyIsIm1hY ▶" ] ]
0 of 0array:5 [▶ "_token" => "LuhWcHZJMgazF77hYjraos3x7f7LO3KiG2LnqL3H" "login_after_url" => "http://dev.misooda.com/add/follow/user/1326" "_flash" => array:2 [▶ "new" => [] "old" => [] ] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/_debugbar/assets/javascript?v=1627809542" ] "PHPDEBUGBAR_STACK_DATA" => [] ]