Revision Rhinoplasty, Fat graft, Skin Injection|MISOODA

Home Review Detail Page

Revision Rhinoplasty, Fat graft, Skin Injection

Inquiry

Consultation with Doctor :
Friendliness :
Environment :
Price :
Satisfaction :

Category :
Clinic Name : JK Plastic Surgery
Doctor : -
Surgery Date : 2018.10.12

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 surgery with JK. However, they are a bit pricey so I search for a third party who will help me with the appointment and price negotiation and I found Misooda. As a foreigner, it is important for me to have someone who will negotiate and transmit information on my behalf with the clinic prior to my visit. Misooda is the the place to go to for surgery deals and if the clinic you wanted does not have any deals, they will do their best to get you one. Which in my case, they were able to get me discount with JK. Misooda was also very helpful in giving information about the surgery procedure. I will definitely ask Misooda again to assist me on my next surgery. My doctor in JK is Yoo Young Moo, he is very professional, well knowledgeable and I believe he has an extensive experience in surgery. JK team a very professional, I am very impressed with their service. They thought about all the things I need. They even wash my hair and gave me facial which they know I need. It’s only been a month after the surgery and I am already happy with the results. I feel like some part of my face and nose is still swollen but I already see the difference and I am very happy about it. JK for me is top of the line and this clinic has zero accident. My over all experience with JK plastic surgery excellent!

42
0
2389

After 30 days

1 month post surgery

After 14 days

1-2 weeks post surgery

After 3 days

3 days post surgery

Login OR Sign Up

Other Reviews

Written by Velvet

Written by minkkko93

Written by nomont

Written by foxshot

K-Beauty

Customers who saw this also saw these promotions

BK Plastic Surgery

Rhinoplasty (bridge augmentation)

$ 4,093

10%

$ 3,703

ITEM Plastic Surgery

Korean Nose Surgery

$ 3,390

18%

$ 2,797

Apgujeong Seoul Plastic Surgery

Non-incision Nose Threading MISKO

$ 1,271

33%

$ 847

O&YOUNG Plastic Surgery

O&Young Prestige Rib Rhinoplasty

$ 12,182

20%

$ 9,746

Messages Timeline Exceptions Views14 Route Queries26 Models50 Mails Auth Gate Session Request

7.2.34299ms9MBGET {lang}/review/{clinic}/{slug}

Booting (71.45ms)
Application (228ms)
1 x Application (76.04%)
227.64ms
1 x Booting (23.87%)
71.45ms

14 templates were rendered

frontend.review.detail (resources/views/frontend/review/detail.blade.php)12blade
Params
0
ac
1
conf
2
langs
3
data
4
images
5
diary
6
wished
7
user
8
comments
9
pageTitle
10
pageDesc
11
pageImage

Params
0	`ac`
1	`conf`
2	`langs`
3	`data`
4	`images`
5	`diary`
6	`wished`
7	`user`
8	`comments`
9	`pageTitle`
10	`pageDesc`
11	`pageImage`

partials.shortcode.promotion_show (resources/views/partials/shortcode/promotion_show.blade.php)28blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
id

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`id`

partials.shortcode.review_sidebar (resources/views/partials/shortcode/review_sidebar.blade.php)34blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
cat_id
not_id
limit
cat
clinic_id
type
reviews

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`cat_id`
28	`not_id`
29	`limit`
30	`cat`
31	`clinic_id`
32	`type`
33	`reviews`

partials.shortcode.post_module (resources/views/partials/shortcode/post_module.blade.php)29blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
limit
list

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`limit`
28	`list`

partials.shortcode.promotion_list (resources/views/partials/shortcode/promotion_list.blade.php)41blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
category_id
limit
rMenuType
title
clinic_id
cat
type
not_id
list
showCats
totalPromotion
showBest
showHotDeal
showAll

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`category_id`
28	`limit`
29	`rMenuType`
30	`title`
31	`clinic_id`
32	`cat`
33	`type`
34	`not_id`
35	`list`
36	`showCats`
37	`totalPromotion`
38	`showBest`
39	`showHotDeal`
40	`showAll`

layouts.frontend (resources/views/layouts/frontend.blade.php)28blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`

partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)28blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`

partials.frontend.header (resources/views/partials/frontend/header.blade.php)29blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`

partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)30blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`
29	`footer`

partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)36blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header
footer
group
showImg
limit
list
showTitle
showExcerpt

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`
29	`footer`
30	`group`
31	`showImg`
32	`limit`
33	`list`
34	`showTitle`
35	`showExcerpt`

partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)30blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`
29	`footer`

partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)30blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`
29	`footer`

partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)30blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`
29	`footer`

partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)30blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
img
loop
d
ddate
pdate
datediff
dayafter
mainImage
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`data`
10	`images`
11	`diary`
12	`wished`
13	`user`
14	`comments`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`i`
19	`__currentLoopData`
20	`img`
21	`loop`
22	`d`
23	`ddate`
24	`pdate`
25	`datediff`
26	`dayafter`
27	`mainImage`
28	`header`
29	`footer`

uri: GET {lang}/review/{clinic}/{slug}
middleware: web, lang, redirect.tomobile
controller: App\Http\Controllers\Frontend\ReviewController@show
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/ReviewController.php:171-250

26 statements were executed104ms

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'

13.23ms/app/Http/Controllers/FrontendController.php:33lv_misooda_dev

Metadata
Bindings	0. en
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	13. /app/Http/Controllers/FrontendController.php:33 14. /app/Http/Controllers/Frontend/ReviewController.php:26 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:667 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:615

select * from `mi_language` order by `id` desc2.65ms/app/Http/Controllers/Shared/TransController.php:38lv_misooda_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/Shared/TransController.php:38 15. /app/Http/Controllers/Shared/TransController.php:20 16. /app/Http/Controllers/FrontendController.php:39 17. /app/Http/Controllers/Frontend/ReviewController.php:26 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 order by `id` desc930μs/app/Http/Controllers/Shared/TransController.php:45lv_misooda_dev

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Shared/TransController.php:45 15. /app/Http/Controllers/Shared/TransController.php:21 16. /app/Http/Controllers/FrontendController.php:39 17. /app/Http/Controllers/Frontend/ReviewController.php:26 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 and `code` = 'en' limit 18.76msmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. middleware::lang:27 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 18. middleware::bindings:41 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select `mi_review`.*, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` where `slug` = 'revision-rhinoplasty-fat-graft-skin-injection' limit 1

11.68ms/app/Http/Controllers/Frontend/ReviewController.php:175lv_misooda_dev

Metadata
Bindings	0. revision-rhinoplasty-fat-graft-skin-injection
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:175 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

update `mi_review` set `hit` = 2389, `mi_review`.`updated_at` = '2025-05-06 18:42:33' where `id` = 3686.76ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev

Metadata
Bindings	0. 2389 1. 2025-05-06 18:42:33 2. 368
Backtrace	13. /app/Http/Controllers/Frontend/ReviewController.php:183 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_clinic` where `mi_clinic`.`id` = 1 limit 16.06ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	18. /app/Model/Base/BaseModel.php:236 20. /app/Http/Controllers/Frontend/ReviewController.php:186 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_review_trans` where `review_id` = 368 and `lang_id` = 'en' limit 12.23ms/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev

Metadata
Bindings	0. 368 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:126 16. /app/Http/Controllers/Frontend/ReviewController.php:191 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_category_trans` where `cat_id` = 27 and `lang_id` = 'en' limit 15.84ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev

Metadata
Bindings	0. 27 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:140 16. /app/Http/Controllers/Frontend/ReviewController.php:191 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_category` where `mi_category`.`id` = 27 limit 12.72ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 27
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	18. /app/Model/Base/BaseModel.php:236 20. /app/Http/Controllers/Frontend/ReviewController.php:141 21. /app/Http/Controllers/Frontend/ReviewController.php:191 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `mi_clinic_trans` where `clinic_id` = 1 and `lang_id` = 'en' limit 11.41ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev

Metadata
Bindings	0. 1 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:146 16. /app/Http/Controllers/Frontend/ReviewController.php:191 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_doctor_trans` where `doctor_id` is null and `lang_id` = 'en' limit 1530μs/app/Http/Controllers/Frontend/ReviewController.php:152lv_misooda_dev

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:152 16. /app/Http/Controllers/Frontend/ReviewController.php:191 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_images_review` where `review_id` = 3682.13ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev

Metadata
Bindings	0. 368
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/ReviewController.php:194 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_review_diary` where `review_id` = 368 order by `d_date` desc5.02ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev

Metadata
Bindings	0. 368
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/ReviewController.php:199 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` in (1071, 1072, 1073)840μs/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/ReviewController.php:199 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_review_diary_trans` where `review_diary_id` = 1073 and `lang_id` = 'en' limit 1630μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 1073 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:164 16. /app/Http/Controllers/Frontend/ReviewController.php:201 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_review_diary_trans` where `review_diary_id` = 1072 and `lang_id` = 'en' limit 1530μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 1072 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:164 16. /app/Http/Controllers/Frontend/ReviewController.php:201 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `mi_review_diary_trans` where `review_diary_id` = 1071 and `lang_id` = 'en' limit 15.03ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 1071 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ReviewController.php:164 16. /app/Http/Controllers/Frontend/ReviewController.php:201 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `mi_comments_review`.`id`, `mi_comments_review`.`name`, `mi_comments_review`.`comment`, `mi_tr`.`comment`, `mi_comments_review`.`like_count`, `mi_comments_review`.`dislike_count`, `mi_comments_review`.`date`, `mi_user`.`username`, `mi_user`.`profile_image`, COUNT(mi_sub.id) AS reply_count from `mi_comments_review` left join `mi_user` on `mi_user`.`id` = `mi_comments_review`.`user_id` left join `mi_comments_review` as `mi_sub` on `mi_sub`.`parent_id` = `mi_comments_review`.`id` left join `mi_comments_review_trans` as `mi_tr` on `mi_tr`.`comment_id` = `mi_comments_review`.`id` where `mi_tr`.`lang_id` = 'en' and `mi_comments_review`.`post_id` = 368 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc

930μs/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev

Metadata
Bindings	0. en 1. 368
Backtrace	14. /app/Http/Controllers/Frontend/ReviewController.php:241 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_user` where `mi_user`.`id` = 1020 limit 11.9ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1020
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	18. /app/Model/Base/BaseModel.php:236 20. view::frontend.review.detail:42 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 23. /vendor/laravel/framework/src/Illuminate/View/View.php:142 24. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select `mi_promotion`.*, IFNULL(`mi_tr`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_tr`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_tr`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, `mi_tr`.`title`, `mi_tr`.`description`, `mi_tr`.`caution_before`, `mi_tr`.`caution_after`, `mi_u`.`name` as `user_name`, `mi_c`.`slug` as `clinic_slug` from `mi_promotion` left join `mi_promotion_trans` as `mi_tr` on `mi_tr`.`promotion_id` = `mi_promotion`.`id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_promotion`.`user_id` left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_promotion`.`clinic_id` where `mi_tr`.`lang_id` = 'en' and `mi_promotion`.`id` = 26 limit 1

1.14ms/app/Composers/PromotionComposer.php:114lv_misooda_dev

Metadata
Bindings	0. en 1. 26
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Composers/PromotionComposer.php:114 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90 23. view::frontend.review.detail:379

select `mi_review`.`id`, `mi_review`.`slug`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`slug` as `clinic_slug`, `mi_u`.`username` as `user_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_images_review` as `mi_img2` on `mi_img2`.`review_id` = `mi_review`.`id` and `mi_img2`.`flag` = 'after' 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` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_review`.`user_id` where `mi_review`.`category_id` = 27 and `mi_review`.`id` <> 368 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 4

1.43ms/app/Composers/ReviewComposer.php:413lv_misooda_dev

Metadata
Bindings	0. before 1. after 2. en 3. 27 4. 368
Backtrace	14. /app/Composers/ReviewComposer.php:413 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::frontend.review.detail:383

select `mi_post`.`id`, `mi_post`.`slug`, `mi_post`.`image`, `mi_post`.`user_id`, `mi_post`.`category_id`, `mi_post`.`hit`, `mi_post`.`order_no`, `mi_post`.`meta_title`, `mi_post`.`meta_desc`, `mi_post`.`created_at`, `mi_post`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_post`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_post`.`content`) as `content` from `mi_post` left join `mi_post_trans` as `mi_trans` on `mi_trans`.`post_id` = `mi_post`.`id` and `mi_trans`.`lang_id` = 'en' limit 3

5.84ms/app/Composers/MainComposer.php:236lv_misooda_dev

Metadata
Bindings	0. en
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /app/Composers/MainComposer.php:236 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::frontend.review.detail:387

select `mi_promotion`.*, IFNULL(`mi_pt`.`img_thumb`,`mi_promotion`.`img_thumb`) AS `img_thumb`, IFNULL(`mi_pt`.`img_detail_thumb`,`mi_promotion`.`img_detail_thumb`) AS `img_detail_thumb`, IFNULL(`mi_pt`.`img_detail`,`mi_promotion`.`img_detail`) AS `img_detail`, IFNULL(`mi_pt`.`title`,`mi_promotion`.`title`) AS `title`, IFNULL(`mi_pt`.`description`,`mi_promotion`.`description`) AS `description`, IFNULL(`mi_pt`.`caution_before`,`mi_promotion`.`caution_before`) AS `caution_before`, IFNULL(`mi_pt`.`caution_after`,`mi_promotion`.`caution_after`) AS `caution_after`, `mi_clinic`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`,`mi_clinic`.`name`) AS `clinic_name` from `mi_promotion` left join `mi_promotion_trans` as `mi_pt` on `mi_pt`.`promotion_id` = `mi_promotion`.`id` and `mi_pt`.`lang_id` = 'en' inner join `mi_clinic` on `mi_clinic`.`id` = `mi_promotion`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'en' where `mi_promotion`.`category_id` = 27 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 4

7.03ms/app/Composers/PromotionComposer.php:66lv_misooda_dev

Metadata
Bindings	0. en 1. en 2. 27
Backtrace	14. /app/Composers/PromotionComposer.php:66 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::frontend.review.detail:397

select count(*) as aggregate from `mi_promotion`430μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23lv_misooda_dev

Metadata
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/Composers/PromotionComposer.php:82 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90

select `mi_banner`.`id`, `mi_banner`.`group_code`, `mi_banner`.`order_no`, `mi_banner`.`created_at`, `mi_banner`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_banner`.`title`) as `title`, IFNULL(`mi_trans`.`excerpt`,`mi_banner`.`excerpt`) as `excerpt`, IFNULL(`mi_trans`.`link`,`mi_banner`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_banner`.`image`) as `image` from `mi_banner` left join `mi_banner_trans` as `mi_trans` on `mi_trans`.`banner_id` = `mi_banner`.`id` and `mi_trans`.`lang_id` = 'en' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

7.88ms/app/Composers/BannerComposer.php:20lv_misooda_dev

Metadata
Bindings	0. en 1. banner-footer-dark
Backtrace	14. /app/Composers/BannerComposer.php:20 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::partials.frontend.footer-dark:66

App\Model\Post: 3
App\Model\Promotion: 5
App\Model\User: 1
App\Model\ImagesDiary: 8
App\Model\ReviewDiary: 3
App\Model\ImagesReview: 2
App\Model\ClinicTrans: 1
App\Model\Category: 1
App\Model\CategoryTrans: 1
App\Model\ReviewTrans: 1
App\Model\Clinic: 1
App\Model\Review: 5
App\Model\Language: 18

web: null
api: null

_token: oJoyuX4lUCKia0aZkZsI543rQ1UdCMGFjnHbRiZp
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/review/jk-plastic-surgery/revision-rhinoplasty-fat-graft-skin-injection

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:8 [▶
  "host" => array:1 [▶
    0 => "dev.misooda.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => 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"
  ]
]

request_server

  0 of 0   
array:33 [▶
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "dev.misooda.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "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"
  "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" => "18.223.102.30"
  "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" => "48780"
  "REDIRECT_URL" => "/en/review/jk-plastic-surgery/revision-rhinoplasty-fat-graft-skin-injection"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/review/jk-plastic-surgery/revision-rhinoplasty-fat-graft-skin-injection"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746524553.648
  "REQUEST_TIME" => 1746524553
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 09:42:33 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkcycG9UbmxMbW01cVVFUkRTRDRNOEE9PSIsInZhbHVlIjoiQ2JzSHo5bXIwV0xyVEcyU1kydmdVbEMyOHdWYmgrWjRxSDBYTFwvRnpiZkJNVFM2cGRiRDU5QmllOTdXMmRjWjUiLCJtYWMiOiI3MGYyOGQyZGJlNjc2M2MwZjAzNzRkYjIzZDYyMmNjN2Q2ZGVjNTgxNDRjYjRiNzhjOWMzMDM0N2Q1YjljMGRmIn0%3D; expires=Tue, 06-May-2025 11:42:33 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkcycG9UbmxMbW01cVVFUkRTRDRNOEE9PSIsInZhbHVlIjoiQ2JzSHo5bXIwV0xyVEcyU1kydmdVbEMyOHdWYmgrWjRxSDBYTFwvRnpiZkJNVFM2cGRiRDU5QmllOTdXMmRjWjUiLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkcycG9UbmxMbW01cVVFUkRTRDRNOEE9PSIsInZhbHVlIjoiQ2JzSHo5bXIwV0xyVEcyU1kydmdVbEMyOHdWYmgrWjRxSDBYTFwvRnpiZkJNVFM2cGRiRDU5QmllOTdXMmRjWjUiLCJtYWMiOiI3MGYyOGQyZGJlNjc2M2MwZjAzNzRkYjIzZDYyMmNjN2Q2ZGVjNTgxNDRjYjRiNzhjOWMzMDM0N2Q1YjljMGRmIn0%3D; expires=Tue, 06-May-2025 11:42:33 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkcycG9UbmxMbW01cVVFUkRTRDRNOEE9PSIsInZhbHVlIjoiQ2JzSHo5bXIwV0xyVEcyU1kydmdVbEMyOHdWYmgrWjRxSDBYTFwvRnpiZkJNVFM2cGRiRDU5QmllOTdXMmRjWjUiLCJtY ▶"
  ]
]

session_attributes

  0 of 0   
array:2 [▶
  "_token" => "oJoyuX4lUCKia0aZkZsI543rQ1UdCMGFjnHbRiZp"
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (76.04%)	227.64ms
1 x Booting (23.87%)	71.45ms