Cheaper rates with Misooda

Home Review Detail Page

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

Category :
Clinic Name : Seoul 365mc
Doctor : -
Surgery Date : 2018.10.11

I went for a consultation at 365mc. Miu was able to get me a better rate for LAMS than what 365mc quoted me (email). Miu was also able to get me an appointment within the next day (free consultation) as contrast to 365mc requiring me to pay for a deposit if i want to have a face-to-face consultation. I would recommend Miu and Misooda. Miu is responsive to queries. Thumbs up!

0
0
1891

Login OR Sign Up

Other Reviews

Written by ramsey

Written by dimoset

Written by msnin

Written by PilotG

K-Beauty

Customers who saw this also saw these promotions

Clinic Plate

Inner & Outer Beauty Therapy

$ 5,593

Clinic Plate

Body Contouring

$ 9,322

Apgujeong Seoul Plastic Surgery

Premium Liposuction

$ 17,712

Apgujeong Seoul Plastic Surgery

Standard Liposuction

$ 10,254

Messages Timeline Exceptions Views14 Route Queries22 Models37 Mails Auth Gate Session Request

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

Booting (44.03ms)
Application (81.61ms)
1 x Application (64.87%)
81.61ms
1 x Booting (35%)
44.03ms

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
partials.shortcode.promotion_show (resources/views/partials/shortcode/promotion_show.blade.php)20blade
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
id
partials.shortcode.review_sidebar (resources/views/partials/shortcode/review_sidebar.blade.php)26blade
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
cat_id
20
not_id
21
limit
22
cat
23
clinic_id
24
type
25
reviews
partials.shortcode.post_module (resources/views/partials/shortcode/post_module.blade.php)21blade
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
limit
20
list

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	`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	`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	`cat_id`
20	`not_id`
21	`limit`
22	`cat`
23	`clinic_id`
24	`type`
25	`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	`limit`
20	`list`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
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	`category_id`
20	`limit`
21	`rMenuType`
22	`title`
23	`clinic_id`
24	`cat`
25	`type`
26	`not_id`
27	`list`
28	`showCats`
29	`totalPromotion`
30	`showBest`
31	`showHotDeal`
32	`showAll`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
mainImage

partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)22blade
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
loop
21
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	`loop`
21	`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	`loop`
21	`mainImage`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`
23	`footer`
24	`group`
25	`showImg`
26	`limit`
27	`list`
28	`showTitle`
29	`showExcerpt`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
data
images
diary
wished
user
comments
pageTitle
pageDesc
pageImage
i
__currentLoopData
loop
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	`loop`
21	`mainImage`
22	`header`
23	`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

22 statements were executed22.57ms

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.8ms/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` desc960μ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` desc750μ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 1780μ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` = 'cheaper-rates-with-misooda' limit 1

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

Metadata
Bindings	0. cheaper-rates-with-misooda
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` = 1891, `mi_review`.`updated_at` = '2025-06-07 23:25:20' where `id` = 3621.94ms/app/Http/Controllers/Frontend/ReviewController.php:183lv_misooda_dev

Metadata
Bindings	0. 1891 1. 2025-06-07 23:25:20 2. 362
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` = 2 limit 1820μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

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

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

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

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

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

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

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

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

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

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

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

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

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

select `mi_review`.`id`, `mi_review`.`slug`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`slug` as `clinic_slug`, `mi_u`.`username` as `user_name` from `mi_review` left join `mi_images_review` as `mi_img1` on `mi_img1`.`review_id` = `mi_review`.`id` and `mi_img1`.`flag` = 'before' left join `mi_images_review` as `mi_img2` on `mi_img2`.`review_id` = `mi_review`.`id` and `mi_img2`.`flag` = 'after' left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'en' left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_user` as `mi_u` on `mi_u`.`id` = `mi_review`.`user_id` where `mi_review`.`category_id` = 40 and `mi_review`.`id` <> 362 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 4

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

Metadata
Bindings	0. before 1. after 2. en 3. 40 4. 362
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.22ms/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` = 40 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 4

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

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

780μ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\Promotion: 5
App\Model\User: 1
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: yrmTT06nzRfoCnUXkBaQgbW1Q5uKTO4uDppPR5kS
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://dev.misooda.com/vi/profile/jackgo2/reviews" ]
_flash: array:2 [ "old" => [] "new" => [] ]
user: array:1 [ "promotions" => array:1 [ 0 => 135 ] ]

path_info

/en/review/seoul-365mc/cheaper-rates-with-misooda

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:11 [▶
  "host" => array:1 [▶
    0 => "dev.misooda.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "cookie" => array:1 [▶
    0 => "_fbp=fb.1.1749306317168.770018675388558488; misooda=UzbkjQRj7KUY1CSBoZBc0H1dvtyyWDB4JhBynwOS; XSRF-TOKEN=eyJpdiI6Ikp3cThlZGw5UmRDTW1pcDhrMlwvQTFRPT0iLCJ2YWx1ZSI6Iis1WStibFwvUVg3ZXB2VkZ1RGhvMTZwNTBOeUhkMnFsTnFkSE15Y1MxcjZyNUNyRXNRRE9ua1NkaFQrM0lIUldJIiwibWFjIjoiMDFjMDU4YzgyYWY1MjhhOGYxYTNhNDE2NTUyMWZkNTFmNjFjZWFmY2FhZmQxODdlZTVhZGZlNmRiZWE4NGVjYyJ9 ◀_fbp=fb.1.1749306317168.770018675388558488; misooda=UzbkjQRj7KUY1CSBoZBc0H1dvtyyWDB4JhBynwOS; XSRF-TOKEN=eyJpdiI6Ikp3cThlZGw5UmRDTW1pcDhrMlwvQTFRPT0iLCJ2YWx1ZSI ▶"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-87jfg (squid/6.10)"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.7.20"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
]

request_server

  0 of 0   
array:36 [▶
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "dev.misooda.com"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate"
  "HTTP_COOKIE" => "_fbp=fb.1.1749306317168.770018675388558488; misooda=UzbkjQRj7KUY1CSBoZBc0H1dvtyyWDB4JhBynwOS; XSRF-TOKEN=eyJpdiI6Ikp3cThlZGw5UmRDTW1pcDhrMlwvQTFRPT0iLCJ2YWx1ZSI6Iis1WStibFwvUVg3ZXB2VkZ1RGhvMTZwNTBOeUhkMnFsTnFkSE15Y1MxcjZyNUNyRXNRRE9ua1NkaFQrM0lIUldJIiwibWFjIjoiMDFjMDU4YzgyYWY1MjhhOGYxYTNhNDE2NTUyMWZkNTFmNjFjZWFmY2FhZmQxODdlZTVhZGZlNmRiZWE4NGVjYyJ9 ◀_fbp=fb.1.1749306317168.770018675388558488; misooda=UzbkjQRj7KUY1CSBoZBc0H1dvtyyWDB4JhBynwOS; XSRF-TOKEN=eyJpdiI6Ikp3cThlZGw5UmRDTW1pcDhrMlwvQTFRPT0iLCJ2YWx1ZSI ▶"
  "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-87jfg (squid/6.10)"
  "HTTP_X_FORWARDED_FOR" => "10.1.7.20"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)"
  "SERVER_NAME" => "dev.misooda.com"
  "SERVER_ADDR" => "139.59.109.168"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "216.73.216.243"
  "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" => "2601"
  "REDIRECT_URL" => "/en/review/seoul-365mc/cheaper-rates-with-misooda"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/en/review/seoul-365mc/cheaper-rates-with-misooda"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1749306320.731
  "REQUEST_TIME" => 1749306320
]

request_cookies

  0 of 0   
array:3 [▶
  "_fbp" => null
  "misooda" => null
  "XSRF-TOKEN" => "yrmTT06nzRfoCnUXkBaQgbW1Q5uKTO4uDppPR5kS"
]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 07 Jun 2025 14:25:20 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImhnMGdibUhsMm5jdjZ6WnBqT2RrNmc9PSIsInZhbHVlIjoiejl5ZFRpMXpHT3hvRnRpczg5OGtmYzVPaGtzbjZiQmdIYVlEc0JtRHI1bEI1ajYyOVhVNmpYV0pvZ0tZdFJoOSIsIm1hYyI6IjFhYzJlODc2NGQ2ODgxYWI1MjA5Y2RjZDU4M2RhYTAwMTJlNjljNDRjNTI0ZDNmNjVmZWFlZjg1YmUxOTY0N2UifQ%3D%3D; expires=Sat, 07-Jun-2025 16:25:20 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImhnMGdibUhsMm5jdjZ6WnBqT2RrNmc9PSIsInZhbHVlIjoiejl5ZFRpMXpHT3hvRnRpczg5OGtmYzVPaGtzbjZiQmdIYVlEc0JtRHI1bEI1ajYyOVhVNmpYV0pvZ0tZdFJoOSIsIm1hY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImhnMGdibUhsMm5jdjZ6WnBqT2RrNmc9PSIsInZhbHVlIjoiejl5ZFRpMXpHT3hvRnRpczg5OGtmYzVPaGtzbjZiQmdIYVlEc0JtRHI1bEI1ajYyOVhVNmpYV0pvZ0tZdFJoOSIsIm1hYyI6IjFhYzJlODc2NGQ2ODgxYWI1MjA5Y2RjZDU4M2RhYTAwMTJlNjljNDRjNTI0ZDNmNjVmZWFlZjg1YmUxOTY0N2UifQ%3D%3D; expires=Sat, 07-Jun-2025 16:25:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImhnMGdibUhsMm5jdjZ6WnBqT2RrNmc9PSIsInZhbHVlIjoiejl5ZFRpMXpHT3hvRnRpczg5OGtmYzVPaGtzbjZiQmdIYVlEc0JtRHI1bEI1ajYyOVhVNmpYV0pvZ0tZdFJoOSIsIm1hY ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "yrmTT06nzRfoCnUXkBaQgbW1Q5uKTO4uDppPR5kS"
  "PHPDEBUGBAR_STACK_DATA" => []
  "_previous" => array:1 [▶
    "url" => "http://dev.misooda.com/vi/profile/jackgo2/reviews"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "user" => array:1 [▶
    "promotions" => array:1 [▶
      0 => 135
    ]
  ]
]

1 x Application (64.87%)	81.61ms
1 x Booting (35%)	44.03ms