MISOODA: Read Latest Reviews, Compare Clinic Prices, Get the Best Deals

Select Your Doctor

MORE (12)

Dr. Park Jong Lim

ยกกระชับใบหน้า, กระดูกโครงหน้า

Dr. Hu Jung Wu

ตา, จมูก

Dr. Lee Hyuck Jae

ยกกระชับใบหน้า, การปลูกถ่ายไขมัน

Dr. Lee Sang Kyun

ตา, จมูก

Dr. Ko Young Il

ตา, จมูก

Dr. Han Dae Hee

ตา, จมูก

รีวิวที่ดีที่สุด

James k

Tc Clinic
James k

NAMU Plastic Surgery
Sua

GIRIN Plastic Surgery
iooseo

NAMU Plastic Surgery
a_y987

โรงพยาบาลศัลยกรรม เร็น
minkkko93

โรงพยาบาลศัลยกรรม ท้อปเฟซ
dayni

โรงพยาบาลศัลยกรรม ซินเดอเรลลา
biki

โรงพยาบาลศัลยกรรมช่องปากและขากรรไกร นาวมี
jud_jelly86

โรงพยาบาลศัลยกรรม นานะ
uhee

โรงพยาบาลศัลยกรรม จิวเวอรี่
ramsey

พริตตี้บอดี้ คลินิก
mchaee11

โรงพยาบาลศัลยกรรม จิวเวอรี่
Yewha

GIRIN Plastic Surgery
nomont

โรงพยาบาลศัลยกรรม เร็น
tdliecap

โรงพยาบาลศัลยกรรม เร็น

Time Limited Promotion

Tc Clinic

Dual Fix Malar Reduction

฿ 847

90%

฿ 85

โรงพยาบาลศัลยกรรม วิว

View Plastic Surgery : ศัลยกรรมลดความเหลี่ยมกราม

฿ 6,263

21%

฿ 4,924

โรงพยาบาลศัลยกรรม จิวเวอรี่

เปลี่ยนหน้า! ตา + จมูก + ปลูกถ่ายไขมัน (ติดต่อ MISOODA สำหรับราคาพิเศษ)

฿ 0

โรงพยาบาลศัลยกรรมและผิวหนัง เดอะแพลน

ดึงหน้า & ดึงคอ

฿ 10,169

25%

฿ 7,627

พริตตี้บอดี้ คลินิก

PRETTY BODY CLINIC : ดูดไขมันทั่วร่าง

฿ 16,949

25%

฿ 12,712

โรงพยาบาล ฮุนได เอสเตติก

แก้ไขพื้นที่เหนือริมฝีปาก

฿ 2,051

45%

฿ 1,119

โรงพยาบาลศัลยกรรม ไอเท็ม

ศัลยกรรมจมูกเกาหลี

฿ 3,390

18%

฿ 2,797

โรงพยาบาลศัลยกรรมช่องปากและขากรรไกร นาวมี

ศัลยกรรม V-line

฿ 5,815

ไกด์ความงาม

Clinics

Messages Timeline Exceptions Views16 Route Queries30 Models82 Mails Auth Gate Session Request

7.2.34113ms9MBGET {lang}

Booting (32.52ms)
Application (80.51ms)
1 x Application (71.06%)
80.51ms
1 x Booting (28.7%)
32.52ms

16 templates were rendered

frontend.page.home (resources/views/frontend/page/home.blade.php)5blade
Params
0
ac
1
conf
2
langs
3
pageTitle
4
pageDesc
partials.shortcode.slider_main (resources/views/partials/shortcode/slider_main.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
group
12
slides
partials.shortcode.model_rec_card (resources/views/partials/shortcode/model_rec_card.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
limit
12
is_home
13
totalCount
14
list

Params
0	`ac`
1	`conf`
2	`langs`
3	`pageTitle`
4	`pageDesc`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`group`
12	`slides`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`limit`
12	`is_home`
13	`totalCount`
14	`list`

partials.shortcode.review_list (resources/views/partials/shortcode/review_list.blade.php)24blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
pageTitle
pageDesc
limit
cat
rMenuType
clinic_id
promotion_id
doctor_id
type
list
showCats
totalReview
category_id
showBest
showAll

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`limit`
12	`cat`
13	`rMenuType`
14	`clinic_id`
15	`promotion_id`
16	`doctor_id`
17	`type`
18	`list`
19	`showCats`
20	`totalReview`
21	`category_id`
22	`showBest`
23	`showAll`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
pageTitle
pageDesc
limit
cat
rMenuType
title
clinic_id
type
not_id
list
showCats
totalPromotion
category_id
showBest
showHotDeal
showAll

partials.shortcode.clinic_banner_module (resources/views/partials/shortcode/clinic_banner_module.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
type
12
totalClinic
13
clinics
partials.shortcode.popup (resources/views/partials/shortcode/popup.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
pc
12
mobile
13
popups
layouts.frontend (resources/views/layouts/frontend.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
partials.frontend.header-meta (resources/views/partials/frontend/header-meta.blade.php)12blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
partials.frontend.header (resources/views/partials/frontend/header.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header
partials.frontend.footer-dark (resources/views/partials/frontend/footer-dark.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header
partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)19blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header
13
group
14
showImg
15
limit
16
list
17
showTitle
18
showExcerpt
partials.frontend.footer-meta (resources/views/partials/frontend/footer-meta.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header
partials.frontend.login-modal (resources/views/partials/frontend/login-modal.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header
partials.frontend.signup-modal (resources/views/partials/frontend/signup-modal.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header
partials.frontend.forget-modal (resources/views/partials/frontend/forget-modal.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
11
footer
12
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`limit`
12	`cat`
13	`rMenuType`
14	`title`
15	`clinic_id`
16	`type`
17	`not_id`
18	`list`
19	`showCats`
20	`totalPromotion`
21	`category_id`
22	`showBest`
23	`showHotDeal`
24	`showAll`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`type`
12	`totalClinic`
13	`clinics`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`pc`
12	`mobile`
13	`popups`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`
13	`group`
14	`showImg`
15	`limit`
16	`list`
17	`showTitle`
18	`showExcerpt`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`footer`
12	`header`

uri: GET {lang}
middleware: web, lang, redirect.tomobile
controller: App\Http\Controllers\Frontend\PageController@showHome
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/PageController.php:13-19

30 statements were executed22.4ms

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` = 'th'

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

Metadata
Bindings	0. th
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/PageController.php:10 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` desc540μ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/PageController.php:10 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 order by `id` desc460μ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/PageController.php:10 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

select * from `mi_language` where `is_active` = 1 and `code` = 'th' limit 1430μsmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. th
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_slider`.`id`, `mi_slider`.`group_code`, `mi_slider`.`order_no`, `mi_slider`.`created_at`, `mi_slider`.`updated_at`, IFNULL(`mi_trans`.`name`,`mi_slider`.`name`) as `name`, IFNULL(`mi_trans`.`image`,`mi_slider`.`image`) as `image`, IFNULL(`mi_trans`.`link`,`mi_slider`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_slider`.`image`) as `image` from `mi_slider` left join `mi_slider_trans` as `mi_trans` on `mi_trans`.`slider_id` = `mi_slider`.`id` and `mi_trans`.`lang_id` = 'th' where `mi_slider`.`group_code` = 'main' order by `mi_slider`.`order_no` asc

1.18ms/app/Composers/MainComposer.php:117lv_misooda_dev

Metadata
Bindings	0. th 1. main
Backtrace	14. /app/Composers/MainComposer.php:117 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.page.home:4

select count(*) as aggregate from `mi_model_rec`680μ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/ModelRecComposer.php:43 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_model_rec`.`id`, `mi_model_rec`.`slug`, `mi_model_rec`.`clinic_id`, `mi_model_rec`.`period_start`, `mi_model_rec`.`period_end`, `mi_model_rec`.`sponsorship`, `mi_model_rec`.`is_home`, `mi_model_rec`.`created_at`, `mi_model_rec`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_model_rec`.`title`) as `title`, IFNULL(`mi_trans`.`eligy`,`mi_model_rec`.`eligy`) as `eligy`, IFNULL(`mi_trans`.`gender`,`mi_model_rec`.`gender`) as `gender`, IFNULL(`mi_trans`.`image_1`,`mi_model_rec`.`image_1`) as `image_1`, IFNULL(`mi_trans`.`image_2`,`mi_model_rec`.`image_2`) as `image_2`, IFNULL(`mi_trans`.`image_3`,`mi_model_rec`.`image_3`) as `image_3`, `mi_cl`.`slug` as `clinic_slug`, `mi_cq`.`cat_title` from `mi_model_rec` left join `mi_model_rec_trans` as `mi_trans` on `mi_trans`.`mrec_id` = `mi_model_rec`.`id` and `mi_trans`.`lang_id` = 'th' left join `mi_clinic` as `mi_cl` on `mi_cl`.`id` = `mi_model_rec`.`clinic_id` inner join (select `mi_model_rec_category`.`rec_id`, GROUP_CONCAT(IFNULL(`mi_ct`.`title`, `mi_cat`.`title`) SEPARATOR ', ') AS `cat_title` from `mi_model_rec_category` inner join `mi_category` as `mi_cat` on `mi_cat`.`id` = `mi_model_rec_category`.`category_id` left join `mi_category_trans` as `mi_ct` on `mi_ct`.`cat_id` = `mi_cat`.`id` and `mi_ct`.`lang_id` = 'th' group by `mi_model_rec_category`.`rec_id` order by `mi_model_rec_category`.`order_no` asc) as `mi_cq` on `mi_cq`.`rec_id` = `mi_model_rec`.`id` where `mi_model_rec`.`is_home` = 1 limit 8

2.22ms/app/Composers/ModelRecComposer.php:44lv_misooda_dev

Metadata
Bindings	0. th 1. th 2. 1
Backtrace	14. /app/Composers/ModelRecComposer.php:44 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.page.home:11

select `mi_review`.`id`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`rating_01`, `mi_review`.`rating_01`) AS `rating_01`, IFNULL(`mi_rt`.`rating_02`, `mi_review`.`rating_02`) AS `rating_02`, IFNULL(`mi_rt`.`rating_03`, `mi_review`.`rating_03`) AS `rating_03`, IFNULL(`mi_rt`.`rating_04`, `mi_review`.`rating_04`) AS `rating_04`, IFNULL(`mi_rt`.`rating_05`, `mi_review`.`rating_05`) AS `rating_05`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_c`.`id` as `clinic_id`, `mi_c`.`slug` as `clinic_slug`, IFNULL(`mi_ct`.`name`, `mi_c`.`name`) AS `clinic_name`, `mi_user`.`id` as `user_id`, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`country`, `mi_user`.`profile_image`, `mi_category`.`id` as `cat_id`, IFNULL(`mi_cat_t`.`title`, `mi_category`.`title`) AS `cat_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` = 'th' inner join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_c`.`id` and `mi_ct`.`lang_id` = 'th' left join `mi_user` on `mi_user`.`id` = `mi_review`.`user_id` inner join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_cat_t` on `mi_cat_t`.`cat_id` = `mi_category`.`id` and `mi_cat_t`.`lang_id` = 'th' where `mi_review`.`show_type` = 1 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 15

2.7ms/app/Composers/ReviewComposer.php:97lv_misooda_dev

Metadata
Bindings	0. before 1. after 2. th 3. th 4. th 5. 1
Backtrace	14. /app/Composers/ReviewComposer.php:97 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.page.home:17

select * from `mi_images_review` where `review_id` = 484 and `flag` = 'after' limit 7580μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 484 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 457 and `flag` = 'after' limit 7450μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 457 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 456 and `flag` = 'after' limit 7530μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 456 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 430 and `flag` = 'after' limit 7360μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 430 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 354 and `flag` = 'after' limit 7350μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 354 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 420 and `flag` = 'after' limit 7360μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 420 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 359 and `flag` = 'after' limit 7340μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 359 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 408 and `flag` = 'after' limit 7440μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 408 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 395 and `flag` = 'after' limit 7330μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 395 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 290 and `flag` = 'after' limit 7340μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 290 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 339 and `flag` = 'after' limit 7340μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 339 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 288 and `flag` = 'after' limit 7340μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 288 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 170 and `flag` = 'after' limit 7430μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 170 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 451 and `flag` = 'after' limit 7390μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 451 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select * from `mi_images_review` where `review_id` = 433 and `flag` = 'after' limit 7380μs/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 433 1. after
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	14. /app/Composers/ReviewComposer.php:104 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.page.home:17

select count(*) as aggregate from `mi_review`370μ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/ReviewComposer.php:124 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_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` = 'th' 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` = 'th' where `mi_promotion`.`show_type` = 1 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 8

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

Metadata
Bindings	0. th 1. th 2. 1
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.page.home:28

select count(*) as aggregate from `mi_promotion`490μ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 count(*) as aggregate from `mi_clinic` where `status` = 1550μs/app/Composers/MainComposer.php:161lv_misooda_dev

Metadata
Bindings	0. 1
Backtrace	15. /app/Composers/MainComposer.php:161 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.page.home:111

select `mi_clinic`.*, IFNULL(`mi_ct`.`name`, `mi_clinic`.`name`) AS `name` from `mi_clinic` left join `mi_clinic_trans` as `mi_ct` on `mi_ct`.`clinic_id` = `mi_clinic`.`id` and `mi_ct`.`lang_id` = 'th' where `status` = 1 and `show_type` = 2 order by `order_no` desc

1.3ms/app/Composers/MainComposer.php:162lv_misooda_dev

Metadata
Bindings	0. th 1. 1 2. 2
Backtrace	14. /app/Composers/MainComposer.php:162 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.page.home:111

select `mi_popup`.`id`, `mi_popup`.`created_at`, `mi_popup`.`updated_at`, `mi_popup`.`is_pc`, `mi_popup`.`is_mobile`, `mi_popup`.`start_date`, `mi_popup`.`end_date`, `mi_popup`.`height`, `mi_popup`.`width`, `mi_popup`.`topmargin`, `mi_popup`.`leftmargin`, `mi_popup`.`style`, `mi_popup`.`nextlink`, IFNULL(`mi_trans`.`title`,`mi_popup`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_popup`.`content`) as `content` from `mi_popup` left join `mi_popup_trans` as `mi_trans` on `mi_trans`.`popup_id` = `mi_popup`.`id` and `mi_trans`.`lang_id` = 'th' where `mi_popup`.`start_date` <= '2025-04-08' and `mi_popup`.`end_date` >= '2025-04-08' and `mi_popup`.`is_pc` = 1

1.04ms/app/Composers/MainComposer.php:279lv_misooda_dev

Metadata
Bindings	0. th 1. 2025-04-08 2. 2025-04-08 3. 1
Backtrace	14. /app/Composers/MainComposer.php:279 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.page.home:308

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` = 'th' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

930μs/app/Composers/BannerComposer.php:20lv_misooda_dev

Metadata
Bindings	0. th 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\Clinic: 18
App\Model\Promotion: 8
App\Model\ImagesReview: 15
App\Model\Review: 15
App\Model\ModelRec: 6
App\Model\Slider: 2
App\Model\Language: 18

web: null
api: null

_token: rNLXFO4PApWpjAvkN0k8Qfc6VUttjRuvIbI3Wz0T
PHPDEBUGBAR_STACK_DATA: []

path_info

/th

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.222.226.10"
  "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" => "54500"
  "REDIRECT_URL" => "/th"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/th"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744092251.443
  "REQUEST_TIME" => 1744092251
]

request_cookies

[]

response_headers

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

session_attributes

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

1 x Application (71.06%)	80.51ms
1 x Booting (28.7%)	32.52ms