No Longer Spongebob look-a-like!

Home Review Detail Page

Inquiry

James k

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

Category :
Clinic Name : NAMU Plastic Surgery
Doctor : In Soo Kirk
Surgery Date : 2020.12.02

I am relatively satisfied with my features but have one and only critical complex! My square jaws. Unfortunately, my square jaws stand out as my first impression which totally hides my appealing eyes and nose. One great thing after the surgery is that I can freely change my hair styles. I no longer have to limit my hair style in order to disguise my jaws! Being able to freely communicate with the medical director about the direction of surgery helped me settle down my emotions and truly think about my desires. I am so glad I have chosen Namu as my guidance to this natural looking beauty.

0
4
2401

After 15 days

after

Login OR Sign Up

123

2021-11-23 11:28:18

test

2021-11-04 13:34:31

2020-12-30 17:10:00

2020-12-30 17:08:24

Other Reviews

Written by 123456456

Written by iooseo

Written by girinplasticsurgery

Written by Timmy Kim

K-Beauty

Customers who saw this also saw these promotions

Tc Clinic

Secondary Eye Surgery

$ 847

20%

$ 678

BK Plastic Surgery

Eyelid (incisional) + Ptosis Correction

$ 3,265

30%

$ 2,291

BK Plastic Surgery

Eyelid (incisional) + Epicanthoplasty

$ 3,265

30%

$ 2,291

Jewelry Plastic Surgery

Face off! Eyes+ Nose +Fat Graft (Contact MISOODA for price)

$ 0

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

7.2.34146ms10MBGET {lang}/review/{clinic}/{slug}

Booting (43.84ms)
Application (102ms)
1 x Application (69.79%)
102.03ms
1 x Booting (29.99%)
43.84ms

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)32blade


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`id`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`cat_id`
32	`not_id`
33	`limit`
34	`cat`
35	`clinic_id`
36	`type`
37	`reviews`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`limit`
32	`list`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`category_id`
32	`limit`
33	`rMenuType`
34	`title`
35	`clinic_id`
36	`cat`
37	`type`
38	`not_id`
39	`list`
40	`showCats`
41	`totalPromotion`
42	`showBest`
43	`showHotDeal`
44	`showAll`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`

partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`
33	`footer`

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


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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`
33	`footer`
34	`group`
35	`showImg`
36	`limit`
37	`list`
38	`showTitle`
39	`showExcerpt`

partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`
33	`footer`

partials.frontend.login-modal (resources/views/partials/frontend/login-modal.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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`
33	`footer`

partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`
33	`footer`

partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.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
c
cdate
today
diff
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	`c`
28	`cdate`
29	`today`
30	`diff`
31	`mainImage`
32	`header`
33	`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 executed28.79ms

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.9ms/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` desc660μ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` desc640μ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 1560μsmiddleware::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` = '-2' limit 1

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

Metadata
Bindings	0. -2
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` = 2401, `mi_review`.`updated_at` = '2025-04-15 10:06:41' where `id` = 4572.12ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev

Metadata
Bindings	0. 2401 1. 2025-04-15 10:06:41 2. 457
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` = 46 limit 1720μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 46
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` = 457 and `lang_id` = 'en' limit 1750μs/app/Http/Controllers/Frontend/ReviewController.php:126lv_misooda_dev

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

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

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

Metadata
Bindings	0. 46 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` = 177 and `lang_id` = 'en' limit 1750μs/app/Http/Controllers/Frontend/ReviewController.php:152lv_misooda_dev

Metadata
Bindings	0. 177 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: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_doctor` where `mi_doctor`.`id` = 177 limit 1870μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 177
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:153 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_images_review` where `review_id` = 457550μs/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev

Metadata
Bindings	0. 457
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` = 457 order by `d_date` desc730μs/app/Http/Controllers/Frontend/ReviewController.php:199lv_misooda_dev

Metadata
Bindings	0. 457
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 (1369)700μ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` = 1369 and `lang_id` = 'en' limit 1670μs/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

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

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

Metadata
Bindings	0. en 1. 457
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_comments_review` where `mi_comments_review`.`parent_id` in (6178, 6179, 6227, 6239) order by `date` desc

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

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/ReviewController.php:241 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_user` where `mi_user`.`id` = 482 limit 1700μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 482
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

5.82ms/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` = 25 and `mi_review`.`id` <> 457 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 4

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

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

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

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

Metadata
Bindings	0. en 1. en 2. 25
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`470μ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

870μs/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\Clinic: 1
App\Model\ReviewTrans: 1
App\Model\CategoryTrans: 1
App\Model\Category: 1
App\Model\ClinicTrans: 1
App\Model\DoctorTrans: 1
App\Model\Review: 5
App\Model\Doctor: 1
App\Model\ReviewDiary: 1
App\Model\ImagesDiary: 2
App\Model\ReviewDiaryTrans: 1
App\Model\CommentsReview: 4
App\Model\User: 1
App\Model\Promotion: 5
App\Model\ImagesReview: 2
App\Model\Language: 18

web: null
api: null

_token: oV0IOlkQie4qRsQHwa5ALSB0Yz27t6eWwYe6rKoI
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/review/namu-plastic-surgery/-2

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.191.50.203"
  "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" => "62295"
  "REDIRECT_URL" => "/en/review/namu-plastic-surgery/-2"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/review/namu-plastic-surgery/-2"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744679201.895
  "REQUEST_TIME" => 1744679201
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 15 Apr 2025 01:06:41 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlNkcHE3RUEyN1lwTGVwYXFPWjlBSHc9PSIsInZhbHVlIjoiXC9lYTdKNkY5WEFac0J3YmVkaE0zdXpYcXVsZkFrXC84cU1KaW9penhHRGl5a204WFBzcVBOT2hRdE96XC9JcUZNUiIsIm1hYyI6IjNlZjVhZGYwZjlkOWQ1ZjAwNzQzZjNkNWQzMTIyMmE3Mzk4NDQ1NDFiNGFkYWJlNzBkMzMxZjQwY2ViNmU1NzkifQ%3D%3D; expires=Tue, 15-Apr-2025 03:06:42 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlNkcHE3RUEyN1lwTGVwYXFPWjlBSHc9PSIsInZhbHVlIjoiXC9lYTdKNkY5WEFac0J3YmVkaE0zdXpYcXVsZkFrXC84cU1KaW9penhHRGl5a204WFBzcVBOT2hRdE96XC9JcUZNUiIsI ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlNkcHE3RUEyN1lwTGVwYXFPWjlBSHc9PSIsInZhbHVlIjoiXC9lYTdKNkY5WEFac0J3YmVkaE0zdXpYcXVsZkFrXC84cU1KaW9penhHRGl5a204WFBzcVBOT2hRdE96XC9JcUZNUiIsIm1hYyI6IjNlZjVhZGYwZjlkOWQ1ZjAwNzQzZjNkNWQzMTIyMmE3Mzk4NDQ1NDFiNGFkYWJlNzBkMzMxZjQwY2ViNmU1NzkifQ%3D%3D; expires=Tue, 15-Apr-2025 03:06:42 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlNkcHE3RUEyN1lwTGVwYXFPWjlBSHc9PSIsInZhbHVlIjoiXC9lYTdKNkY5WEFac0J3YmVkaE0zdXpYcXVsZkFrXC84cU1KaW9penhHRGl5a204WFBzcVBOT2hRdE96XC9JcUZNUiIsI ▶"
  ]
]

session_attributes

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

1 x Application (69.79%)	102.03ms
1 x Booting (29.99%)	43.84ms