New V-Line, Zygoma Reduction & Rhinoplasty & Fat Graft

Home Review Detail Page

Inquiry

newydewy

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

Category :
Clinic Name : GIRIN Plastic Surgery
Doctor : -
Surgery Date : 2017.01.15

Our patient here did New V-Line, Zygoma Reduction, Rhinoplasty and Fat graft at Girin Plastic Surgery. Her zygoma and mandible bone were wide & slight pug nose with hollow face. She really hoped to improve her face shape and look more feminine. During final consultation with Dr.Lee, she was worried about general anesthesia and side-effects. But we let her know we have an in-house anesthetist who takes care of patient during operation and our surgical procedures are advanced and won't cause any risk of side-effects. After reassuring her we proceeded with the surgery.

108
0
4950

After 90 days

Patient would get exact result after 3 to 6 months later. She feels quite satisfied with her natural & feminine face and nose shape.

After 59 days

2 months

After 31 days

1 Month

After 14 days

Post-Operative 2 Weeks

After 5 days

Swelling and bruising start goes down rapidly after the 5th day, and stitches are removed as well (Rhinoplasty).

After 3 days

Post-Operative 3 Days

Login OR Sign Up

Other Reviews

Written by Sua

Written by dayni

Written by biki

Written by jud_jelly86

K-Beauty

Customers who saw this also saw these promotions

Tc Clinic

Dual Fix Malar Reduction

$ 847

90%

$ 85

View Plastic Surgery

View Plastic Surgery : Square Jaw Reduction

$ 6,263

21%

$ 4,924

FRESH Plastic Surgery

V-line Surgery (W/O bone Surgery)

$ 6,323

23%

$ 4,870

NOWME Oral and Maxillofacial Surgery

4 type of Facial contour

$ 8,475

30%

$ 5,932

Messages Timeline Exceptions Views14 Route Queries29 Models57 Mails Auth Gate Session Request

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

Booting (73.43ms)
Application (241ms)
1 x Application (76.56%)
240.91ms
1 x Booting (23.33%)
73.43ms

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

29 statements were executed123ms

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'

11.86ms/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` desc700μs/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` desc600μ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 15.99msmiddleware::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` = 'new-v-line-zygoma-reduction-rhinoplasty-fat-graft' limit 1

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

Metadata
Bindings	0. new-v-line-zygoma-reduction-rhinoplasty-fat-graft
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` = 4950, `mi_review`.`updated_at` = '2025-05-10 01:43:50' where `id` = 1763.05ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev

Metadata
Bindings	0. 4950 1. 2025-05-10 01:43:50 2. 176
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` = 51 limit 12.64ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 51
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` = 176 and `lang_id` = 'en' limit 12.04ms/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev

Metadata
Bindings	0. 176 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` = 48 and `lang_id` = 'en' limit 17.72ms/app/Http/Controllers/Frontend/ReviewController.php:140lv_misooda_dev

Metadata
Bindings	0. 48 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` = 48 limit 1620μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 48
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` = 51 and `lang_id` = 'en' limit 1880μs/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev

Metadata
Bindings	0. 51 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 1570μ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` = 176560μs/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev

Metadata
Bindings	0. 176
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` = 176 order by `d_date` desc4.33ms/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev

Metadata
Bindings	0. 176
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 (421, 422, 423, 424, 425, 426)2.2ms/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` = 426 and `lang_id` = 'en' limit 1820μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 426 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` = 425 and `lang_id` = 'en' limit 16.69ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 425 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` = 424 and `lang_id` = 'en' limit 11.26ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 424 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` = 423 and `lang_id` = 'en' limit 14.98ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 423 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` = 422 and `lang_id` = 'en' limit 1660μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 422 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` = 421 and `lang_id` = 'en' limit 1560μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

Metadata
Bindings	0. 421 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` = 176 and `mi_comments_review`.`parent_id` is null group by `mi_comments_review`.`id` order by `mi_comments_review`.`date` desc

1.5ms/app/Http/Controllers/Frontend/ReviewController.php:241lv_misooda_dev

Metadata
Bindings	0. en 1. 176
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` = 574 limit 116.08ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 574
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' order by RAND() limit 1

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

Metadata
Bindings	0. en
Hints	`ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
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` = 48 and `mi_review`.`id` <> 176 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 4

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

Metadata
Bindings	0. before 1. after 2. en 3. 48 4. 176
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

2.2ms/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` = 48 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 4

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

Metadata
Bindings	0. en 1. en 2. 48
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`9.33ms/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.51ms/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: 12
App\Model\ReviewDiary: 6
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: t763bIyRKDluWeWN2ugfyYGD8Jkg9aF2tFRrFpQD
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/review/girin-plastic-surgery/new-v-line-zygoma-reduction-rhinoplasty-fat-graft

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" => "3.15.219.78"
  "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" => "65343"
  "REDIRECT_URL" => "/en/review/girin-plastic-surgery/new-v-line-zygoma-reduction-rhinoplasty-fat-graft"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/review/girin-plastic-surgery/new-v-line-zygoma-reduction-rhinoplasty-fat-graft"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746809030.608
  "REQUEST_TIME" => 1746809030
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 09 May 2025 16:43:50 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImI2NGpuQzVYR2tvYllLZzRsaWNBMmc9PSIsInZhbHVlIjoidHNnVW1hR0t3UWNRb3A2MEY1Z0FaWVlpb2NSVFRpOGlZZEFscVZxd2tEd0poSWxCR3AyTng0WFl4Qk1lQUdJNSIsIm1hYyI6IjEzNDMzNjlkOGM5ZWY4MWI0YjZiNzk3MDg3MzFiMGI5ZGJkMmZhNjFjODRmYTVmODU3MjE4NGY4NzM0ZDg2ODEifQ%3D%3D; expires=Fri, 09-May-2025 18:43:50 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImI2NGpuQzVYR2tvYllLZzRsaWNBMmc9PSIsInZhbHVlIjoidHNnVW1hR0t3UWNRb3A2MEY1Z0FaWVlpb2NSVFRpOGlZZEFscVZxd2tEd0poSWxCR3AyTng0WFl4Qk1lQUdJNSIsIm1hY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImI2NGpuQzVYR2tvYllLZzRsaWNBMmc9PSIsInZhbHVlIjoidHNnVW1hR0t3UWNRb3A2MEY1Z0FaWVlpb2NSVFRpOGlZZEFscVZxd2tEd0poSWxCR3AyTng0WFl4Qk1lQUdJNSIsIm1hYyI6IjEzNDMzNjlkOGM5ZWY4MWI0YjZiNzk3MDg3MzFiMGI5ZGJkMmZhNjFjODRmYTVmODU3MjE4NGY4NzM0ZDg2ODEifQ%3D%3D; expires=Fri, 09-May-2025 18:43:50 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImI2NGpuQzVYR2tvYllLZzRsaWNBMmc9PSIsInZhbHVlIjoidHNnVW1hR0t3UWNRb3A2MEY1Z0FaWVlpb2NSVFRpOGlZZEFscVZxd2tEd0poSWxCR3AyTng0WFl4Qk1lQUdJNSIsIm1hY ▶"
  ]
]

session_attributes

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

1 x Application (76.56%)	240.91ms
1 x Booting (23.33%)	73.43ms