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

Messages Timeline Exceptions Views21 Route Queries20 Models80 Mails Auth Gate Session Request

7.2.3480.87ms9MBGET m/{lang}

Booting (16.12ms)
Application (64.63ms)
1 x Application (79.92%)
64.63ms
1 x Booting (19.93%)
16.12ms

21 templates were rendered

mobile.page.home (resources/views/mobile/page/home.blade.php)5blade
Params
0
ac
1
conf
2
langs
3
pageTitle
4
pageDesc
partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)18blade
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
showImg
13
is_mobile
14
limit
15
list
16
showTitle
17
showExcerpt
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.mobile.video_consult_module (resources/views/partials/shortcode/mobile/video_consult_module.blade.php)11blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
partials.shortcode.mobile.model_module (resources/views/partials/shortcode/mobile/model_module.blade.php)17blade
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
title
13
is_home
14
url
15
totalCount
16
list
partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)18blade
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
showImg
13
is_mobile
14
limit
15
list
16
showTitle
17
showExcerpt
partials.shortcode.mobile.advice_home_list (resources/views/partials/shortcode/mobile/advice_home_list.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
advices
partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.blade.php)18blade
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
showImg
13
is_mobile
14
limit
15
list
16
showTitle
17
showExcerpt
partials.shortcode.mobile.promotion_module (resources/views/partials/shortcode/mobile/promotion_module.blade.php)21blade
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
title
14
url
15
showCats
16
clinic_id
17
type
18
not_id
19
list
20
totalPromotion
partials.shortcode.mobile.review_module (resources/views/partials/shortcode/mobile/review_module.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
limit
12
cat
13
clinic_id
14
doctor_id
15
type
16
list
17
totalCount
18
category_id
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
mobile
12
pc
13
popups
layouts.mobile_layout (resources/views/layouts/mobile_layout.blade.php)11blade
Params
0
obLevel
1
__env
2
app
3
cl
4
lang
5
errors
6
ac
7
conf
8
langs
9
pageTitle
10
pageDesc
partials.mobile.header-meta (resources/views/partials/mobile/header-meta.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
footer
12
header
13
tawk
partials.mobile.menu (resources/views/partials/mobile/menu.blade.php)17blade
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
tawk
14
request
15
isWebView
16
userData
partials.mobile.header (resources/views/partials/mobile/header.blade.php)18blade
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
tawk
14
request
15
isWebView
16
userData
17
params
partials.mobile.messages (resources/views/partials/mobile/messages.blade.php)18blade
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
tawk
14
request
15
isWebView
16
userData
17
params
partials.mobile.footer (resources/views/partials/mobile/footer.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
tawk
14
request
15
isWebView
16
userData
17
params
18
footerParams
partials.mobile.modal.login (resources/views/partials/mobile/modal/login.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
tawk
14
request
15
isWebView
16
userData
17
params
18
footerParams
partials.mobile.modal.how_it_works (resources/views/partials/mobile/modal/how_it_works.blade.php)21blade
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
tawk
14
request
15
isWebView
16
userData
17
params
18
footerParams
19
advices
20
guides
partials.mobile.modal.shop_alert (resources/views/partials/mobile/modal/shop_alert.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
tawk
14
request
15
isWebView
16
userData
17
params
18
footerParams
partials.mobile.footer-meta (resources/views/partials/mobile/footer-meta.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
tawk
14
request
15
isWebView
16
userData
17
params
18
footerParams

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	`showImg`
13	`is_mobile`
14	`limit`
15	`list`
16	`showTitle`
17	`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	`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`

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	`title`
13	`is_home`
14	`url`
15	`totalCount`
16	`list`

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	`showImg`
13	`is_mobile`
14	`limit`
15	`list`
16	`showTitle`
17	`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	`advices`

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	`showImg`
13	`is_mobile`
14	`limit`
15	`list`
16	`showTitle`
17	`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	`limit`
12	`cat`
13	`title`
14	`url`
15	`showCats`
16	`clinic_id`
17	`type`
18	`not_id`
19	`list`
20	`totalPromotion`

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	`clinic_id`
14	`doctor_id`
15	`type`
16	`list`
17	`totalCount`
18	`category_id`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`pageTitle`
10	`pageDesc`
11	`mobile`
12	`pc`
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`

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	`tawk`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`
18	`footerParams`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`
18	`footerParams`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`
18	`footerParams`
19	`advices`
20	`guides`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`
18	`footerParams`

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	`tawk`
14	`request`
15	`isWebView`
16	`userData`
17	`params`
18	`footerParams`

uri: GET m/{lang}
middleware: web, redirect.topc, lang
controller: App\Http\Controllers\Mobile\PageController@showHome
namespace: App\Http\Controllers\Mobile
prefix: m/{lang}
where
file: app/Http/Controllers/Mobile/PageController.php:15-23

20 statements were executed, 2 of which were duplicated, 18 unique22.17ms

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.37ms/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/Mobile/PageController.php:12 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` desc560μ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/Mobile/PageController.php:12 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

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

select * from `mi_language` where `is_active` = 1 and `code` = 'th' limit 1700μ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::redirect.topc:25 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

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` = 'post_surgery_package' order by `mi_banner`.`order_no` desc limit 1

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

Metadata
Bindings	0. th 1. post_surgery_package
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::mobile.page.home:10

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_mobile' order by `mi_slider`.`order_no` asc

810μs/app/Composers/MainComposer.php:117lv_misooda_dev

Metadata
Bindings	0. th 1. main_mobile
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::mobile.page.home:21

select count(*) as aggregate from `mi_model_rec`760μ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.98ms/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::mobile.page.home:36

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` = 'mobile-front-event' order by `mi_banner`.`order_no` desc

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

Metadata
Bindings	0. th 1. mobile-front-event
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::mobile.page.home:44

select `mi_advice`.`id`, `mi_advice`.`cat_id`, `mi_advice`.`slug`, `mi_advice`.`order_no`, `mi_advice`.`created_at`, `mi_advice`.`updated_at`, `mi_advice`.`meta_title`, `mi_advice`.`meta_desc`, IFNULL(`mi_trans`.`title`,`mi_advice`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_advice`.`content`) as `content`, IFNULL(`mi_act`.`name`, `mi_ac`.`name`) AS `cat_name` from `mi_advice` left join `mi_advice_trans` as `mi_trans` on `mi_trans`.`advice_id` = `mi_advice`.`id` and `mi_trans`.`lang_id` = 'th' left join `mi_advice_cat` as `mi_ac` on `mi_ac`.`id` = `mi_advice`.`cat_id` left join `mi_advice_cat_trans` as `mi_act` on `mi_act`.`adv_cat_id` = `mi_ac`.`id` and `mi_act`.`lang_id` = 'th' group by `mi_advice`.`cat_id`

1.71ms/app/Composers/MainComposer.php:332lv_misooda_dev

Metadata
Bindings	0. th 1. th
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Composers/MainComposer.php:332 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::mobile.page.home:48

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` = 'mobile-clinic-comparison' order by `mi_banner`.`order_no` desc

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

Metadata
Bindings	0. th 1. mobile-clinic-comparison
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::mobile.page.home:55

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 6

1.71ms/app/Composers/PromotionComposer.php:171lv_misooda_dev

Metadata
Bindings	0. th 1. th 2. 1
Backtrace	14. /app/Composers/PromotionComposer.php:171 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::mobile.page.home:65

select count(*) as aggregate from `mi_promotion`390μ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:173 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_clinic_review`.*, `mi_user`.`username`, `mi_user`.`profile_image` from `mi_clinic_review` left join `mi_user` on `mi_user`.`id` = `mi_clinic_review`.`user_id` where `mi_clinic_review`.`type` = 'livechat' order by `created_at` desc limit 10

1ms/app/Composers/ReviewComposer.php:328lv_misooda_dev

Metadata
Bindings	0. livechat
Backtrace	14. /app/Composers/ReviewComposer.php:328 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::mobile.page.home:70

select `mi_review`.`id`, `mi_review`.`created_at`, `mi_review`.`slug`, IFNULL(`mi_rt`.`title`, `mi_review`.`title`) AS `title`, IFNULL(`mi_rt`.`content`, `mi_review`.`content`) AS `content`, `mi_review`.`show_type`, `mi_clinic`.`slug` as `clinic_slug`, `mi_category`.`id` as `category_id`, IFNULL(`mi_ct`.`title`, `mi_category`.`title`) AS `category_title`, `mi_rl`.`like_count`, (select count(*) from `mi_comments_review` where `mi_review`.`id` = `mi_comments_review`.`post_id`) as `comments_count` from `mi_review` left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'th' left join `mi_clinic` on `mi_clinic`.`id` = `mi_review`.`clinic_id` left join `mi_category` on `mi_category`.`id` = `mi_review`.`category_id` left join `mi_category_trans` as `mi_ct` on `mi_ct`.`cat_id` = `mi_category`.`id` and `mi_ct`.`lang_id` = 'th' left join (select `post_id`, COUNT(`user_id`) AS `like_count` from `mi_user_like` where `post_type` = 'review' and `type` = 0 group by `post_id`) as `mi_rl` on `mi_rl`.`post_id` = `mi_review`.`id` where `mi_review`.`show_type` = 1 order by `mi_review`.`created_at` desc, `mi_review`.`order_no` desc limit 10

2.54ms/app/Composers/ReviewComposer.php:333lv_misooda_dev

Metadata
Bindings	0. th 1. th 2. review 3. 0 4. 1
Backtrace	14. /app/Composers/ReviewComposer.php:333 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::mobile.page.home:70

select * from `mi_images_review` where `mi_images_review`.`review_id` in (395, 406, 408, 420, 430, 433, 451, 456, 457, 484)

710μs/app/Composers/ReviewComposer.php:333lv_misooda_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Composers/ReviewComposer.php:333 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::mobile.page.home:70

select count(*) as aggregate from `mi_review`640μ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:358 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_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-06-05' and `mi_popup`.`end_date` >= '2025-06-05' and `mi_popup`.`is_mobile` = 1

980μs/app/Composers/MainComposer.php:279lv_misooda_dev

Metadata
Bindings	0. th 1. 2025-06-05 2. 2025-06-05 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::mobile.page.home:78

select `mi_advice`.`id`, `mi_advice`.`cat_id`, `mi_advice`.`slug`, `mi_advice`.`order_no`, `mi_advice`.`created_at`, `mi_advice`.`updated_at`, `mi_advice`.`meta_title`, `mi_advice`.`meta_desc`, IFNULL(`mi_trans`.`title`,`mi_advice`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_advice`.`content`) as `content`, IFNULL(`mi_act`.`name`, `mi_ac`.`name`) AS `cat_name` from `mi_advice` left join `mi_advice_trans` as `mi_trans` on `mi_trans`.`advice_id` = `mi_advice`.`id` and `mi_trans`.`lang_id` = 'th' left join `mi_advice_cat` as `mi_ac` on `mi_ac`.`id` = `mi_advice`.`cat_id` left join `mi_advice_cat_trans` as `mi_act` on `mi_act`.`adv_cat_id` = `mi_ac`.`id` and `mi_act`.`lang_id` = 'th' group by `mi_advice`.`cat_id`

1.23ms/app/Composers/MainComposer.php:310lv_misooda_dev

Metadata
Bindings	0. th 1. th
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Composers/MainComposer.php:310 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::layouts.mobile_layout:72

select `mi_guide`.`id`, `mi_guide`.`cat_id`, `mi_guide`.`slug`, `mi_guide`.`icon`, `mi_guide`.`order_no`, `mi_guide`.`created_at`, `mi_guide`.`updated_at`, `mi_guide`.`meta_title`, `mi_guide`.`meta_desc`, IFNULL(`mi_trans`.`title`,`mi_guide`.`title`) as `title`, IFNULL(`mi_trans`.`content`,`mi_guide`.`content`) as `content`, `mi_gct`.`name` as `cat_name` from `mi_guide` left join `mi_guide_trans` as `mi_trans` on `mi_trans`.`guide_id` = `mi_guide`.`id` and `mi_trans`.`lang_id` = 'th' left join `mi_guide_cat` as `mi_gc` on `mi_gc`.`id` = `mi_guide`.`cat_id` left join `mi_guide_cat_trans` as `mi_gct` on `mi_gct`.`guide_cat_id` = `mi_gc`.`id` and `mi_gct`.`lang_id` = 'th' order by `mi_guide`.`order_no` desc, `mi_guide`.`id` asc

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

Metadata
Bindings	0. th 1. th
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Composers/MainComposer.php:311 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::layouts.mobile_layout:72

App\Model\Guide: 3
App\Model\ImagesReview: 21
App\Model\Review: 10
App\Model\ClinicReview: 6
App\Model\Promotion: 6
App\Model\Advice: 6
App\Model\ModelRec: 6
App\Model\Slider: 1
App\Model\Banner: 3
App\Model\Language: 18

web: null
api: null

_token: 1SpsjNIlvRdeN5OOVMOCRAQLqxgDUQKp5s3UxyQK
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://dev.misooda.com/id/profile/minnie%20kitty/comments" ]
_flash: array:2 [ "old" => [] "new" => [] ]
review_last_date: 2018-12-17 08:52:11

path_info

/m/th

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:9 [▶
  "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"
  ]
  "cookie" => array:1 [▶
    0 => "_fbp=fb.1.1749107202360.110044678438138064; misooda=CroCpWkGaLYH1jafcXZANFzuQC3GYl00Lhj4jnc4; XSRF-TOKEN=eyJpdiI6IitPMFwvNEs2R2l6UmVrUnk3ZUFEaHBRPT0iLCJ2YWx1ZSI6IjVcL3JlSE9IY29qeGsxRUFtU2QrTjJWNzhuVk9DZ1krRlh0VFlsUWk0b2ZXRmgxY0ptdmh4MlwvRDFpWDg3bERtMSIsIm1hYyI6IjcxZTYwMzcyMDY2ZmRlMGQ2YjIzNTQ3OTIzMzQwZjFjM2ZlMzg3ZjFlZDViYmVlMjFhMzgyYWU3Y2RjN2RjYTcifQ%3D%3D ◀_fbp=fb.1.1749107202360.110044678438138064; misooda=CroCpWkGaLYH1jafcXZANFzuQC3GYl00Lhj4jnc4; XSRF-TOKEN=eyJpdiI6IitPMFwvNEs2R2l6UmVrUnk3ZUFEaHBRPT0iLCJ2YWx1ZSI ▶"
  ]
]

request_server

  0 of 0   
array:34 [▶
  "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"
  "HTTP_COOKIE" => "_fbp=fb.1.1749107202360.110044678438138064; misooda=CroCpWkGaLYH1jafcXZANFzuQC3GYl00Lhj4jnc4; XSRF-TOKEN=eyJpdiI6IitPMFwvNEs2R2l6UmVrUnk3ZUFEaHBRPT0iLCJ2YWx1ZSI6IjVcL3JlSE9IY29qeGsxRUFtU2QrTjJWNzhuVk9DZ1krRlh0VFlsUWk0b2ZXRmgxY0ptdmh4MlwvRDFpWDg3bERtMSIsIm1hYyI6IjcxZTYwMzcyMDY2ZmRlMGQ2YjIzNTQ3OTIzMzQwZjFjM2ZlMzg3ZjFlZDViYmVlMjFhMzgyYWU3Y2RjN2RjYTcifQ%3D%3D ◀_fbp=fb.1.1749107202360.110044678438138064; misooda=CroCpWkGaLYH1jafcXZANFzuQC3GYl00Lhj4jnc4; XSRF-TOKEN=eyJpdiI6IitPMFwvNEs2R2l6UmVrUnk3ZUFEaHBRPT0iLCJ2YWx1ZSI ▶"
  "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.220.26.188"
  "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" => "41450"
  "REDIRECT_URL" => "/m/th"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/m/th"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1749107207.303
  "REQUEST_TIME" => 1749107207
]

request_cookies

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

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 05 Jun 2025 07:06:47 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InREUkpoa2srY1pLelFMVnMyV24rbnc9PSIsInZhbHVlIjoieXMrcjE0RnlabHEzckFZYU53cGhpRDhkOFQrUGtzbEl6bm92d0paNzZFK1c4Y1ZXb21NWlQybEt2eE1obXFOcyIsIm1hYyI6IjliMTY0ZDM5ZjIzMjQ1MjBkNDFkYjU3ZmE0ZGRmN2JjN2I2NDVmZmFjMWI1N2E3Yzk1NjIxNzU5NTZlOTYzMTUifQ%3D%3D; expires=Thu, 05-Jun-2025 09:06:47 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InREUkpoa2srY1pLelFMVnMyV24rbnc9PSIsInZhbHVlIjoieXMrcjE0RnlabHEzckFZYU53cGhpRDhkOFQrUGtzbEl6bm92d0paNzZFK1c4Y1ZXb21NWlQybEt2eE1obXFOcyIsIm1hY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InREUkpoa2srY1pLelFMVnMyV24rbnc9PSIsInZhbHVlIjoieXMrcjE0RnlabHEzckFZYU53cGhpRDhkOFQrUGtzbEl6bm92d0paNzZFK1c4Y1ZXb21NWlQybEt2eE1obXFOcyIsIm1hYyI6IjliMTY0ZDM5ZjIzMjQ1MjBkNDFkYjU3ZmE0ZGRmN2JjN2I2NDVmZmFjMWI1N2E3Yzk1NjIxNzU5NTZlOTYzMTUifQ%3D%3D; expires=Thu, 05-Jun-2025 09:06:47 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InREUkpoa2srY1pLelFMVnMyV24rbnc9PSIsInZhbHVlIjoieXMrcjE0RnlabHEzckFZYU53cGhpRDhkOFQrUGtzbEl6bm92d0paNzZFK1c4Y1ZXb21NWlQybEt2eE1obXFOcyIsIm1hY ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "1SpsjNIlvRdeN5OOVMOCRAQLqxgDUQKp5s3UxyQK"
  "PHPDEBUGBAR_STACK_DATA" => []
  "_previous" => array:1 [▶
    "url" => "http://dev.misooda.com/id/profile/minnie%20kitty/comments"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "review_last_date" => "2018-12-17 08:52:11"
]

Trust	What kind of company is Misooda?
Safe/Trust	How are partner hospitals selected?
Fees	What are the reasons for the price adjustment?

Trust	What kind of company is Misooda?
Safe/Trust	How are partner hospitals selected?
Fees	What are the reasons for the price adjustment?

Our Customer`s
Video Consultation

Dr. Byung Gun Kim

Dr. Young Il Ko

Dr. Kyul Hee Kim

Dr. Su Yeon Cho

Select Your Doctor

Dr. Park Jong Lim

Dr. Hu Jung Wu

Dr. Lee Hyuck Jae

Dr. Lee Sang Kyun

Dr. Ko Young Il

Dr. Han Dae Hee

Good to know

Time Limited Promotion

Dual Fix Malar Reduction

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

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

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

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

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

Recent Review

1 x Application (79.92%)	64.63ms
1 x Booting (19.93%)	16.12ms

﻿Our Customer`s Video Consultation

Select Your Doctor

Good to know

Time Limited Promotion

Recent Review

Our Customer`s
Video Consultation