Nose
Before going to Korea for my surgery, I did an extensive research. After a lot of inquiry through online consultation. I decide I will have my surger...
1 x Application (67.63%) | 34.77ms |
1 x Booting (32.12%) | 16.52ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
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.49ms/app/Http/Controllers/FrontendController.php:33lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_language` order by `id` desc
540μs/app/Http/Controllers/Shared/TransController.php:38lv_misooda_devMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `mi_language` where `is_active` = 1 order by `id` desc
510μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_language` where `is_active` = 1 and `code` = 'en' limit 1
560μsmiddleware::lang:27lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`content`, `mi_review`.`content`) AS `content`, IFNULL(`mi_rt`.`rating_01`, `mi_review`.`rating_01`) AS `rating_01`, IFNULL(`mi_rt`.`rating_02`, `mi_review`.`rating_02`) AS `rating_02`, IFNULL(`mi_rt`.`rating_03`, `mi_review`.`rating_03`) AS `rating_03`, IFNULL(`mi_rt`.`rating_04`, `mi_review`.`rating_04`) AS `rating_04`, IFNULL(`mi_rt`.`rating_05`, `mi_review`.`rating_05`) AS `rating_05`, `mi_img1`.`path` as `before_path`, `mi_c`.`id` as `clinic_id`, `mi_c`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`, `mi_c`.`name`) AS `clinic_name`, `mi_user`.`id` as `user_id`, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`country`, `mi_user`.`profile_image`, `mi_category`.`id` as `cat_id`, IFNULL(`mi_cat_t`.`title`, `mi_category`.`title`) AS `cat_name` 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' inner join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_c`.`id` and `mi_ct`.`lang_id` = 'en' left join `mi_user` on `mi_user`.`id` = `mi_review`.`user_id` inner join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_cat_t` on `mi_cat_t`.`cat_id` = `mi_category`.`id` and `mi_cat_t`.`lang_id` = 'en' where `mi_review`.`clinic_id` = '1' order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 2 offset 2
1.4ms/app/Http/Controllers/Mobile/ReviewController.php:536lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `mi_images_review` where `review_id` = 368 and `flag` = 'after' limit 7
640μs/app/Http/Controllers/Mobile/ReviewController.php:542lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_images_review` where `review_id` = 140 and `flag` = 'after' limit 7
520μs/app/Http/Controllers/Mobile/ReviewController.php:542lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_category_trans` where `cat_id` = 27 and `lang_id` = 'en' limit 1
500μs/app/Http/Controllers/Mobile/ReviewController.php:124lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_clinic_trans` where `clinic_id` = 1 and `lang_id` = 'en' limit 1
570μs/app/Http/Controllers/Mobile/ReviewController.php:130lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_review_trans` where `review_id` = 368 and `lang_id` = 'en' limit 1
560μs/app/Http/Controllers/Mobile/ReviewController.php:136lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_images_review` where `review_id` = 368 and `flag` = 'after' limit 7
510μs/app/Http/Controllers/Mobile/ReviewController.php:145lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_category_trans` where `cat_id` = 27 and `lang_id` = 'en' limit 1
490μs/app/Http/Controllers/Mobile/ReviewController.php:124lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_clinic_trans` where `clinic_id` = 1 and `lang_id` = 'en' limit 1
560μs/app/Http/Controllers/Mobile/ReviewController.php:130lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_review_trans` where `review_id` = 140 and `lang_id` = 'en' limit 1
510μs/app/Http/Controllers/Mobile/ReviewController.php:136lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `mi_images_review` where `review_id` = 140 and `flag` = 'after' limit 7
550μs/app/Http/Controllers/Mobile/ReviewController.php:145lv_misooda_devMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 368
670μs/app/Model/Review.php:75lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 368 and `mi_comments_review`.`post_id` is not null
370μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `mi_user_like` where `post_type` = 'review' and `type` = 0 and `post_id` = 140
400μs/app/Model/Review.php:75lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `mi_comments_review` where `mi_comments_review`.`post_id` = 140 and `mi_comments_review`.`post_id` is not null
350μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_devMetadata | |
---|---|
Bindings |
|
Backtrace |
|
200
0 of 0array:2 [▶ "clinic_id" => "1" "page" => "2" ]
0 of 0array:2 [▶ "clinic_id" => "1" "page" => "2" ]
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.1751924930248.291057861496780325; misooda=4bopeuKpxxvcIkHgZtpyWL0mbKkKbQf9xdYFlpTG; XSRF-TOKEN=eyJpdiI6Imd6RmUzNlhja0hkUDdmazNsS1hWN3c9PSIsInZhbHVlIjoiVTFOWGw5UlNFMTZ2a2V5ak9CdHN6cDdQbjVYNkJwdVpscnpwOXVHYzNYcFNDSkdXc2NraktDU1pnVnJRTkVncyIsIm1hYyI6IjUyMTI1ZmY0MTU4NTZlYTc1ZmY3OTkwMDg0Y2NhODcwM2M0OWFmNGE5Yzg2MDIyMGViYTZlYmNmYWNjMGE5MzQifQ%3D%3D ◀_fbp=fb.1.1751924930248.291057861496780325; misooda=4bopeuKpxxvcIkHgZtpyWL0mbKkKbQf9xdYFlpTG; XSRF-TOKEN=eyJpdiI6Imd6RmUzNlhja0hkUDdmazNsS1hWN3c9PSIsInZhbHVlIjo ▶" ] "via" => array:1 [▶ 0 => "1.1 squid-proxy-5b5d847c96-j4wzp (squid/6.10)" ] "x-forwarded-for" => array:1 [▶ 0 => "10.1.97.91" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] ]
0 of 0array:37 [▶ "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.1751924930248.291057861496780325; misooda=4bopeuKpxxvcIkHgZtpyWL0mbKkKbQf9xdYFlpTG; XSRF-TOKEN=eyJpdiI6Imd6RmUzNlhja0hkUDdmazNsS1hWN3c9PSIsInZhbHVlIjoiVTFOWGw5UlNFMTZ2a2V5ak9CdHN6cDdQbjVYNkJwdVpscnpwOXVHYzNYcFNDSkdXc2NraktDU1pnVnJRTkVncyIsIm1hYyI6IjUyMTI1ZmY0MTU4NTZlYTc1ZmY3OTkwMDg0Y2NhODcwM2M0OWFmNGE5Yzg2MDIyMGViYTZlYmNmYWNjMGE5MzQifQ%3D%3D ◀_fbp=fb.1.1751924930248.291057861496780325; misooda=4bopeuKpxxvcIkHgZtpyWL0mbKkKbQf9xdYFlpTG; XSRF-TOKEN=eyJpdiI6Imd6RmUzNlhja0hkUDdmazNsS1hWN3c9PSIsInZhbHVlIjo ▶" "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-j4wzp (squid/6.10)" "HTTP_X_FORWARDED_FOR" => "10.1.97.91" "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.222" "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" => "6812" "REDIRECT_URL" => "/m/en/review/ajax" "REDIRECT_QUERY_STRING" => "clinic_id=1&page=2" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "clinic_id=1&page=2" "REQUEST_URI" => "/m/en/review/ajax?clinic_id=1&page=2" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1751924932.596 "REQUEST_TIME" => 1751924932 ]
0 of 0array:3 [▶ "_fbp" => null "misooda" => null "XSRF-TOKEN" => "X1YWGqvM3STI77ykccAcTOPm1r5qvWGLq5AyJZoy" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 07 Jul 2025 21:48:52 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkpOWTBmb3RKMFFudFhzbGNZXC9HU0JnPT0iLCJ2YWx1ZSI6ImxCeDIzNzF3Q3ByWm5ka2llaG5rdVFHMFArYkRHVG1cL1dGUXBLblwvTXJhQ2pnTUZySVVDVkhCYUNmM2ZFN0hWTCIsIm1hYyI6IjcyOTIyODQwOTNhN2VlZWMzNzBlZGY0YjBkYzU5MzE4ZmNhYjU4YTAwNTA0NDc3NjQ2OTAwMDU1ZDQ5ZDkwOGYifQ%3D%3D; expires=Mon, 07-Jul-2025 23:48:52 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkpOWTBmb3RKMFFudFhzbGNZXC9HU0JnPT0iLCJ2YWx1ZSI6ImxCeDIzNzF3Q3ByWm5ka2llaG5rdVFHMFArYkRHVG1cL1dGUXBLblwvTXJhQ2pnTUZySVVDVkhCYUNmM2ZFN0hWTCIsI ▶" ] "Set-Cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkpOWTBmb3RKMFFudFhzbGNZXC9HU0JnPT0iLCJ2YWx1ZSI6ImxCeDIzNzF3Q3ByWm5ka2llaG5rdVFHMFArYkRHVG1cL1dGUXBLblwvTXJhQ2pnTUZySVVDVkhCYUNmM2ZFN0hWTCIsIm1hYyI6IjcyOTIyODQwOTNhN2VlZWMzNzBlZGY0YjBkYzU5MzE4ZmNhYjU4YTAwNTA0NDc3NjQ2OTAwMDU1ZDQ5ZDkwOGYifQ%3D%3D; expires=Mon, 07-Jul-2025 23:48:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkpOWTBmb3RKMFFudFhzbGNZXC9HU0JnPT0iLCJ2YWx1ZSI6ImxCeDIzNzF3Q3ByWm5ka2llaG5rdVFHMFArYkRHVG1cL1dGUXBLblwvTXJhQ2pnTUZySVVDVkhCYUNmM2ZFN0hWTCIsI ▶" ] ]
0 of 0array:5 [▶ "_token" => "X1YWGqvM3STI77ykccAcTOPm1r5qvWGLq5AyJZoy" "login_after_url" => "http://dev.misooda.com/add/like/gallery/3101" "_flash" => array:2 [▶ "new" => [] "old" => [] ] "_previous" => array:1 [▶ "url" => "http://dev.misooda.com/ja/profile/biki/reviews" ] "PHPDEBUGBAR_STACK_DATA" => [] ]