| 1 x Application (78.03%) | 178.11ms |
| 1 x Booting (21.87%) | 49.92ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
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` = 'id'2.13ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` order by `id` desc930μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 order by `id` desc740μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `mi_language` where `is_active` = 1 and `code` = 'id' limit 1820μ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` = 'id' where `mi_clinic`.`slug` = 'ruby-plastic-surgery' limit 11.47ms/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` = 37 and `mi_gr`.`code` = 'top-image'1.33ms/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` = 37 group by `clinic_id` limit 1960μ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` = 371.09ms/app/Http/Controllers/Mobile/ClinicController.php:484lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `mi_review` left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'id' 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` = 'id' left join (select `post_id`, COUNT(`user_id`) AS `like_count` from `mi_user_like` where `post_type` = 'review' and `type` = 0 group by `post_id`) as `mi_rl` on `mi_rl`.`post_id` = `mi_review`.`id` where `mi_review`.`clinic_id` = 371.84ms/app/Http/Controllers/Mobile/ClinicController.php:297lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `mi_review`.`id`, `mi_review`.`img_before`, `mi_review`.`img_after`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`content`, `mi_review`.`content`) AS `content`, `mi_review`.`show_type`, `mi_clinic`.`slug` as `clinic_slug`, `mi_category`.`id` as `category_id`, IFNULL(`mi_ct`.`title`, `mi_category`.`title`) AS `category_title`, `mi_rl`.`like_count`, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'id' 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` = 'id' left join (select `post_id`, COUNT(`user_id`) AS `like_count` from `mi_user_like` where `post_type` = 'review' and `type` = 0 group by `post_id`) as `mi_rl` on `mi_rl`.`post_id` = `mi_review`.`id` where `mi_review`.`clinic_id` = 37 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 5 offset 02.85ms/app/Http/Controllers/Mobile/ClinicController.php:297lv_misooda_dev| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `mi_review_diary` where `mi_review_diary`.`review_id` in (448)850μs/app/Http/Controllers/Mobile/ClinicController.php:297lv_misooda_dev| Metadata | |
|---|---|
| Hints |
|
| 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 => "_fbp=fb.1.1762866897256.158637366952145499; misooda=SKccT0tAOTOrOXcG17iu0k4L38l20jFiZAzvMUvF; XSRF-TOKEN=eyJpdiI6IjBBSHBWS204dnVYeXZnYXhhZm9JcHc9PSIsInZhbHVlIjoiRkxiK1NVd3BVNWluUnBRV0lOTEFYU1graFB0WksxZVJxNWxxaTBzcnpXN3hNdXJ5QWNOSDk0eDRZZFRTRmlocyIsIm1hYyI6ImUzMzMxMTdkYTZiNjYyM2U1ZjI0Njg2ZmQwMmRmN2NiOGNlMDBhOGM4ZThkY2ZiMDk3YWU0MDk0MTc5ZGQ2MGUifQ%3D%3D ◀_fbp=fb.1.1762866897256.158637366952145499; misooda=SKccT0tAOTOrOXcG17iu0k4L38l20jFiZAzvMUvF; XSRF-TOKEN=eyJpdiI6IjBBSHBWS204dnVYeXZnYXhhZm9JcHc9PSIsInZhbHVlIjo ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-f6lwq (squid/6.13)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.9.139.249" ] "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" => "_fbp=fb.1.1762866897256.158637366952145499; misooda=SKccT0tAOTOrOXcG17iu0k4L38l20jFiZAzvMUvF; XSRF-TOKEN=eyJpdiI6IjBBSHBWS204dnVYeXZnYXhhZm9JcHc9PSIsInZhbHVlIjoiRkxiK1NVd3BVNWluUnBRV0lOTEFYU1graFB0WksxZVJxNWxxaTBzcnpXN3hNdXJ5QWNOSDk0eDRZZFRTRmlocyIsIm1hYyI6ImUzMzMxMTdkYTZiNjYyM2U1ZjI0Njg2ZmQwMmRmN2NiOGNlMDBhOGM4ZThkY2ZiMDk3YWU0MDk0MTc5ZGQ2MGUifQ%3D%3D ◀_fbp=fb.1.1762866897256.158637366952145499; misooda=SKccT0tAOTOrOXcG17iu0k4L38l20jFiZAzvMUvF; XSRF-TOKEN=eyJpdiI6IjBBSHBWS204dnVYeXZnYXhhZm9JcHc9PSIsInZhbHVlIjo ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-f6lwq (squid/6.13)" "HTTP_X_FORWARDED_FOR" => "10.9.139.249" "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.158" "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" => "46456" "REDIRECT_URL" => "/m/id/clinic/ruby-plastic-surgery/reviews" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/m/id/clinic/ruby-plastic-surgery/reviews" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1762866902.582 "REQUEST_TIME" => 1762866902 ]
0 of 0array:3 [▶ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "nWn47KoUeuf6ukkc3xGdfWgJFnGJDJM9i0uyhbvp" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Tue, 11 Nov 2025 13:15:02 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxHK3dvZWpsVnFRTk5QRkhtSE9kRlE9PSIsInZhbHVlIjoiZjEzY052Z2c5bnFQcTJncE4xa04zblp4cWJ2RDJGQUEwZG5hTGlBbmpiQjhvdndLUE1BK2piR2ZiakFvY0VvTSIsIm1hYyI6IjIwODAyZThmMjM5ZmEwY2I5NzU0NDEzZDI4MzY3NjMwZjg3YjFlZTJjYTgwODc0ZjkwMDY0YjEzZmI2Yjk3ZjUifQ%3D%3D; expires=Tue, 11-Nov-2025 15:15:02 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxHK3dvZWpsVnFRTk5QRkhtSE9kRlE9PSIsInZhbHVlIjoiZjEzY052Z2c5bnFQcTJncE4xa04zblp4cWJ2RDJGQUEwZG5hTGlBbmpiQjhvdndLUE1BK2piR2ZiakFvY0VvTSIsIm1hY ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxHK3dvZWpsVnFRTk5QRkhtSE9kRlE9PSIsInZhbHVlIjoiZjEzY052Z2c5bnFQcTJncE4xa04zblp4cWJ2RDJGQUEwZG5hTGlBbmpiQjhvdndLUE1BK2piR2ZiakFvY0VvTSIsIm1hYyI6IjIwODAyZThmMjM5ZmEwY2I5NzU0NDEzZDI4MzY3NjMwZjg3YjFlZTJjYTgwODc0ZjkwMDY0YjEzZmI2Yjk3ZjUifQ%3D%3D; expires=Tue, 11-Nov-2025 15:15:02 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxHK3dvZWpsVnFRTk5QRkhtSE9kRlE9PSIsInZhbHVlIjoiZjEzY052Z2c5bnFQcTJncE4xa04zblp4cWJ2RDJGQUEwZG5hTGlBbmpiQjhvdndLUE1BK2piR2ZiakFvY0VvTSIsIm1hY ▶" ] ]
0 of 0array:4 [▶ "_token" => "nWn47KoUeuf6ukkc3xGdfWgJFnGJDJM9i0uyhbvp" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/m/vi/gallery/s/3839" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]