Netherlander Laser Treatment

Home Review Detail Page

Inquiry

Maan

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

Category :
Clinic Name : HERSHE Plastic Surgery
Doctor : -
Surgery Date : 2016.10.28

Being in the country of extreme make-overs I wanted to experience one of these clinics first hand and since friends recommended Hershe I plucked up some courage and emailed them for an appointment. So, just to be clear: I did not have any surgery, but went in to experience dermatology department. Korea is way ahead of Europe in terms of skin care and my skin has never been flawless. They emailed me back quickly and I felt excited to try their advised treatments although I quickly ran into differences in beauty standards ("we'll laser all your freckles for you" - "Wait, what? No need for that really!"). I got invited in by Junho, the marketing manager and a fluent english speaker that put me at ease right away. The atmosphere in the clinic was more relaxed and less hospital-like then I expected, which made me a little less nervous. After discussing my blog-idea with Junho we made an appointment for my laser-treatment on friday (LASERS! PEW!) and I left the clinic to explore gangnam a bit more (more about Seoul & Okinawa soon! I promise!). I had come to Hershe because I have had zits since I was 15 and while I am now 27 - the zits are still there. I also recently developed some redness, and some scars in my face :( All in all, I wanted a smooth even skin. Hershe offers skin treatments that achieves that, although they did emphasise that I had to come back in a couple of times for the best results (while I was only in Seoul for a few more days). The treatment started with an exfoliating dead skin procedure (cleaning of my face), which was followed by vitamin C care (a superintense mask) and cream anaesthesia (I could not feel my face. Bad pun stolen from Cheryl hehe). After a proper numbing period (40 mins!) we got to the laser part! I had the IPL (intense pulse laser) against age spots and small blood vessels showing, and NG YAG (against wrinkles and red area's) treatment, both also work against zits and rejuvenate the skin by zapping the layer underneath (if I understood correctly). While I was afraid it would hurt like hell, it actually felt pretty ok. My skin got warm and it stung a little, accompanied by a lot of bright white flashes, but it's pretty comparable to tattooing - just not so evenly. It's more a "ZAP - stinging" - move to next spot - "ZAP - little sting" - move - kinda feels. (Yes, I feel very literate today). After the lasers were done (took 10 mins max!) I had duoderm tape stuck to the places where they zapped my moles (right side of my face) and I was taken to the cooling masks & aftercare department. The cooling down was really appreciated, since my skin felt like it had been in the sun for days too long. After cooling down for a longggg time I got the aftercare-explanation by Junho, explaining that I should avoid the sun for the next five days and had to use a lot of sunscreen for at least the next two weeks (but preferably forever, as sun is really bad for your skin). And that was it. I walked out Hershe looking a little reddish and taped down, but I was told results wouldn't show until a few days later. About the procedure: To be honest I found it harder to lie down for such a long time (total procedure took about 2,5 hours) then I found it to endure the pain. And for your reference: I have an pretty OK pain resistance but not wonderful. I am very impatient though :) During the procedure (and the waiting) I was thinking "what kind of crazy person undergoes all this voluntarily?!" but I must admit that now we're a week later (and my skin is a lot better) I would totally go to Hershe again when I'm in Korea. One long post later, this was my adventure with lasers in Korea! Follow me on Facebook or Instagram for more adventures, I'm currently on a roadtrip in the USA <3

97
1
4582

After 0 days

it same day treatment. And my my skin got better immediately^^

Login OR Sign Up

Other Reviews

Written by pancakepixie

Written by Aiel345

Written by sunami

Written by yang yang

K-Beauty

Customers who saw this also saw these promotions

Chaum

K-Beauty One day Anti-aging Check-up & Therapy

$ 4,237

Chaum

Premium Stem Cell Regeneration

$ 25,424

Chaum

K-Beauty One day Wellness Anti-aging Therapy

$ 2,542

The Plan Plastic Surgery and Dermatology

Rejuran Skin Repair and Ulthera Shurink Lift

$ 1,525

44%

$ 847

Messages Timeline Exceptions Views14 Route Queries24 Models43 Mails Auth Gate Session Request

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

Booting (81.55ms)
Application (170ms)
1 x Application (67.57%)
170.28ms
1 x Booting (32.36%)
81.55ms

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

24 statements were executed46.67ms

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'

4.53ms/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` desc1.16ms/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` desc880μ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 11.67msmiddleware::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` = 'netherlander-laser-treatment' limit 1

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

Metadata
Bindings	0. netherlander-laser-treatment
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` = 4582, `mi_review`.`updated_at` = '2025-05-05 07:20:00' where `id` = 2371.4ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev

Metadata
Bindings	0. 4582 1. 2025-05-05 07:20:00 2. 237
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` = 8 limit 1560μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

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

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

Metadata
Bindings	0. 41 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` = 41 limit 11.35ms/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 41
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` = 8 and `lang_id` = 'en' limit 11.05ms/app/Http/Controllers/Frontend/ReviewController.php:146lv_misooda_dev

Metadata
Bindings	0. 8 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 1680μ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` = 2373.08ms/app/Http/Controllers/Frontend/ReviewController.php:194lv_misooda_dev

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

Metadata
Bindings	0. 237
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 (611)1.08ms/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` = 611 and `lang_id` = 'en' limit 11.22ms/app/Http/Controllers/Frontend/ReviewController.php:164lv_misooda_dev

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

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

Metadata
Bindings	0. en 1. 237
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` = 687 limit 1940μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 687
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.44ms/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` = 41 and `mi_review`.`id` <> 237 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 4

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

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

950μs/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` = 41 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 4

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

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

5.54ms/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: 4
App\Model\ReviewDiary: 1
App\Model\ImagesReview: 2
App\Model\ClinicTrans: 1
App\Model\Category: 1
App\Model\CategoryTrans: 1
App\Model\Clinic: 1
App\Model\Review: 5
App\Model\Language: 18

web: null
api: null

_token: jkpmPrmHESQCF7TQNSDTD9p3SfYrnoY9saT1Y2yf
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/review/hershe-plastic-surgery/netherlander-laser-treatment

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.16.66.183"
  "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" => "63508"
  "REDIRECT_URL" => "/en/review/hershe-plastic-surgery/netherlander-laser-treatment"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/review/hershe-plastic-surgery/netherlander-laser-treatment"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746397200.608
  "REQUEST_TIME" => 1746397200
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 04 May 2025 22:20:00 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImlFOFppM1loNFhrMStwZURINERRWnc9PSIsInZhbHVlIjoibXdhMGEydFpcLzdEeUZObGNrOWtHajRFT3ArbTA5dm5QYlF2TFwvT0czS0VpOFJkS1F2cFdwaW1VcEw5UUZhN0t6IiwibWFjIjoiNDliYzBmNGEzNmE5YmNmZmNlYjA0Nzk5YjZkNTBkNTFhMTE5YjEyNTAyODc2ZDAxMzdkYjU4MDhjMWFmMWNmZCJ9; expires=Mon, 05-May-2025 00:20:00 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImlFOFppM1loNFhrMStwZURINERRWnc9PSIsInZhbHVlIjoibXdhMGEydFpcLzdEeUZObGNrOWtHajRFT3ArbTA5dm5QYlF2TFwvT0czS0VpOFJkS1F2cFdwaW1VcEw5UUZhN0t6Iiwib ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImlFOFppM1loNFhrMStwZURINERRWnc9PSIsInZhbHVlIjoibXdhMGEydFpcLzdEeUZObGNrOWtHajRFT3ArbTA5dm5QYlF2TFwvT0czS0VpOFJkS1F2cFdwaW1VcEw5UUZhN0t6IiwibWFjIjoiNDliYzBmNGEzNmE5YmNmZmNlYjA0Nzk5YjZkNTBkNTFhMTE5YjEyNTAyODc2ZDAxMzdkYjU4MDhjMWFmMWNmZCJ9; expires=Mon, 05-May-2025 00:20:00 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImlFOFppM1loNFhrMStwZURINERRWnc9PSIsInZhbHVlIjoibXdhMGEydFpcLzdEeUZObGNrOWtHajRFT3ArbTA5dm5QYlF2TFwvT0czS0VpOFJkS1F2cFdwaW1VcEw5UUZhN0t6Iiwib ▶"
  ]
]

session_attributes

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

1 x Application (67.57%)	170.28ms
1 x Booting (32.36%)	81.55ms