Hyundai Aesthetics, Reviews, Images, Promotions

Địa chỉ :

Mức độ hài lòng :

Lĩnh vực chuyên môn : Mắt Mũi Mặt chảy xệ Ngực Cấy mỡ Hút mỡ Da Toxin

Chat Now

tư vấn

Lời bình được ưa thích

FVelvet

Hyundai Aesthetics
lalalabel

Hyundai Aesthetics
trudey2

Hyundai Aesthetics
emilly102

Hyundai Aesthetics
hiyome

Hyundai Aesthetics
hellisw

Hyundai Aesthetics
Chery

Hyundai Aesthetics
Elysia_dn

Hyundai Aesthetics
Denver_27

Hyundai Aesthetics
Caley97

Hyundai Aesthetics

Sự kiện ưu đãi

Hyundai Aesthetics

Philtrum Correction

₫ 2,051

45%

₫ 1,119

Hyundai Aesthetics

Breast Augmentation Surgery Bespoke

₫ 7,178

35%

₫ 4,652

Hyundai Aesthetics

BABY FACE FAT GRAFTING

₫ 3,233

49%

₫ 1,663

Thông tin

Giải thích chi tiết

1. Safety

2. Surgery

3. Post Surgery Care

4. Pre/Post Surgery Customer Information Management

5. Patient' Surgery Record

6. Provided Service

7. Medical Reimbursement Insurance

8. Certification

9. Language

Bác sĩ

Khoa chuyên môn

Lĩnh vực chuyên môn

Số năm kinh nghiệm

: 19

Ho Hwang

Khoa chuyên môn

Lĩnh vực chuyên môn

Số năm kinh nghiệm

: 14

Jin Wook Jeong

Khoa chuyên môn

Lĩnh vực chuyên môn

Số năm kinh nghiệm

: 14

Seong Jae Hong

Khoa chuyên môn

Lĩnh vực chuyên môn

Số năm kinh nghiệm

: 11

Jong Min Lim

Khoa chuyên môn

Lĩnh vực chuyên môn

Số năm kinh nghiệm

Gwang Seok Jeong

Hình ảnh trước sau

thêm

266

230

242

196

118

119

159

445

thêm

Thời gian điều trị/bản đồ

Ngày làm việc

Thời gian làm việc

Theo dõi

Xem tất cả

lilmi

Bạn có phải là chủ sở hữu phòng khám này không?

Thêm hoặc cập nhập thông tin bệnh viện

Đăng nhập phòng khám

Có phải thông tin bị sai không?

Hãy liên hệ với chúng tôi

Bản báo cáo

Messages Timeline Exceptions Views15 Route Queries34 Models143 Mails Auth Gate Session Request

7.2.34259ms10MBGET {lang}/clinic/{slug}

Booting (30.61ms)
Application (229ms)
1 x Application (88.13%)
228.56ms
1 x Booting (11.8%)
30.61ms

15 templates were rendered

frontend.clinic.show (resources/views/frontend/clinic/show.blade.php)20blade


ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions

Params
0	`ac`
1	`conf`
2	`langs`
3	`clinic_ac`
4	`data`
5	`cats`
6	`cat`
7	`category`
8	`tomImages`
9	`rating`
10	`reviewCount`
11	`promotionCount`
12	`followed`
13	`pageTitle`
14	`pageDesc`
15	`pageImage`
16	`imageGroups`
17	`images`
18	`galleryImages`
19	`questions`

partials.frontend.clinic-top-section (resources/views/partials/frontend/clinic-top-section.blade.php)26blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
limit
clinic_id
showBest
showAll
url
promotion_id
doctor_id
type
category_id
list
rMenuType
showCats

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`limit`
27	`clinic_id`
28	`showBest`
29	`showAll`
30	`url`
31	`promotion_id`
32	`doctor_id`
33	`type`
34	`category_id`
35	`list`
36	`rMenuType`
37	`showCats`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
clinic_id
limit
showBest
showAll
url
category_id
type
not_id
list
rMenuType
showCats
showHotDeal

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`clinic_id`
27	`limit`
28	`showBest`
29	`showAll`
30	`url`
31	`category_id`
32	`type`
33	`not_id`
34	`list`
35	`rMenuType`
36	`showCats`
37	`showHotDeal`

partials.shortcode.doctor_list (resources/views/partials/shortcode/doctor_list.blade.php)35blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
clinic_id
limit
list

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`clinic_id`
33	`limit`
34	`list`

partials.shortcode.follow_list (resources/views/partials/shortcode/follow_list.blade.php)41blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
post_type
post_id
limit
showTitle
url
user_id
follows

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`post_type`
35	`post_id`
36	`limit`
37	`showTitle`
38	`url`
39	`user_id`
40	`follows`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`

partials.frontend.header2 (resources/views/partials/frontend/header2.blade.php)35blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
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	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`
36	`group`
37	`showImg`
38	`limit`
39	`list`
40	`showTitle`
41	`showExcerpt`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
imageGroups
images
galleryImages
questions
q_index
first_col
__currentLoopData
item
loop
q
gr
img
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`clinic_ac`
10	`data`
11	`cats`
12	`cat`
13	`category`
14	`tomImages`
15	`rating`
16	`reviewCount`
17	`promotionCount`
18	`followed`
19	`pageTitle`
20	`pageDesc`
21	`pageImage`
22	`imageGroups`
23	`images`
24	`galleryImages`
25	`questions`
26	`q_index`
27	`first_col`
28	`__currentLoopData`
29	`item`
30	`loop`
31	`q`
32	`gr`
33	`img`
34	`header`
35	`footer`

uri: GET {lang}/clinic/{slug}
middleware: web, lang, redirect.tomobile
controller: App\Http\Controllers\Frontend\ClinicController@show
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/ClinicController.php:108-192

34 statements were executed, 2 of which were duplicated, 32 unique31.37ms

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

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

Metadata
Bindings	0. vi
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/ClinicController.php:24 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` desc520μ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/ClinicController.php:24 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/ClinicController.php:24 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

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

Metadata
Bindings	0. 1 1. vi
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_clinic`.*, `mi_tr`.`name`, `mi_tr`.`address`, `mi_tr`.`description`, `mi_tr`.`business_time`, `mi_tr`.`business_hour` from `mi_clinic` left join `mi_clinic_trans` as `mi_tr` on `mi_tr`.`clinic_id` = `mi_clinic`.`id` where `mi_tr`.`lang_id` = 'vi' and `slug` = 'hyundal-mlhak-plastic-surgery' limit 1

1.22ms/app/Http/Controllers/Frontend/ClinicController.php:358lv_misooda_dev

Metadata
Bindings	0. vi 1. hyundal-mlhak-plastic-surgery
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:358 16. /app/Http/Controllers/Frontend/ClinicController.php:110 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `mi_cat`.*, `mi_tr`.`title` from `mi_clinic_category` left join `mi_category` as `mi_cat` on `mi_cat`.`id` = `mi_clinic_category`.`category_id` left join `mi_category_trans` as `mi_tr` on `mi_tr`.`cat_id` = `mi_cat`.`id` where `mi_clinic_category`.`clinic_id` = 61 and `mi_tr`.`lang_id` = 'vi'

910μs/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev

Metadata
Bindings	0. 61 1. vi
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:371 15. /app/Http/Controllers/Frontend/ClinicController.php:110 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

select * from `mi_cl_image_gr` where `code` = 'top-image' limit 1530μs/app/Http/Controllers/Frontend/ClinicController.php:387lv_misooda_dev

Metadata
Bindings	0. top-image
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/ClinicController.php:387 16. /app/Http/Controllers/Frontend/ClinicController.php:110 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_cl_image` where `clinic_id` = 61 and `group_id` = 2740μs/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev

Metadata
Bindings	0. 61 1. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:392 15. /app/Http/Controllers/Frontend/ClinicController.php:110 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

select COUNT(id) AS review_count, AVG(rating_01) AS rating_01, AVG(rating_02) AS rating_02, AVG(rating_03) AS rating_03, AVG(rating_04) AS rating_04, AVG(rating_05) AS rating_05 from `mi_review` where `clinic_id` = 61 group by `clinic_id` limit 1

660μs/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev

Metadata
Bindings	0. 61
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:405 16. /app/Http/Controllers/Frontend/ClinicController.php:110 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 count(*) as aggregate from `mi_promotion` where `clinic_id` = 61530μs/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev

Metadata
Bindings	0. 61
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:415 16. /app/Http/Controllers/Frontend/ClinicController.php:110 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `mi_cl_image_gr`.`id`, `mi_cl_image_gr`.`code`, `mi_cl_image_gr`.`order_no`, `mi_cl_image_gr`.`static`, `mi_cl_image_gr`.`created_at`, `mi_cl_image_gr`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_cl_image_gr`.`title`) as `title` from `mi_cl_image_gr` inner join `mi_cl_image` as `mi_cl_img` on `clinic_id` = 61 and `mi_cl_image_gr`.`id` = `mi_cl_img`.`group_id` left join `mi_cl_image_gr_trans` as `mi_trans` on `mi_trans`.`cl_image_gid` = `mi_cl_image_gr`.`id` and `mi_trans`.`lang_id` = 'vi' where `mi_cl_image_gr`.`static` = 0 group by `mi_cl_image_gr`.`id`

960μs/app/Http/Controllers/Frontend/ClinicController.php:124lv_misooda_dev

Metadata
Bindings	0. 61 1. vi 2. 0
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:124 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 count(*) as aggregate from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `clinic_id` = 61 and `mi_gr`.`static` = 0

510μs/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev

Metadata
Bindings	0. 61 1. 0
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:131 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

select `mi_cl_image`.* from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `clinic_id` = 61 and `mi_gr`.`static` = 0 order by `order_no` desc, `created_at` desc limit 8 offset 0

670μs/app/Http/Controllers/Frontend/ClinicController.php:131lv_misooda_dev

Metadata
Bindings	0. 61 1. 0
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:131 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

select count(*) as aggregate from `mi_gallery` left join `mi_images_gallery` as `mi_img_left` on `mi_img_left`.`flag` = 'left' and `mi_img_left`.`gallery_id` = `mi_gallery`.`id` left join `mi_images_gallery` as `mi_img_right` on `mi_img_right`.`flag` = 'right' and `mi_img_right`.`gallery_id` = `mi_gallery`.`id` left join `mi_user_like` as `mi_ul` on `mi_ul`.`post_type` = 'gallery' and `mi_ul`.`post_id` = `mi_gallery`.`id` left join `mi_gallery_trans` as `mi_tr` on `mi_tr`.`gallery_id` = `mi_gallery`.`id` where `mi_tr`.`lang_id` = 'vi' and `mi_gallery`.`clinic_id` = 61 group by `mi_gallery`.`id`

2.78ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev

Metadata
Bindings	0. left 1. right 2. gallery 3. vi 4. 61
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:157 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

select `mi_gallery`.*, `mi_tr`.`title`, `mi_tr`.`description`, `mi_img_left`.`path` as `left_path`, `mi_img_right`.`path` as `right_path`, COUNT(mi_ul.user_id) AS like_count from `mi_gallery` left join `mi_images_gallery` as `mi_img_left` on `mi_img_left`.`flag` = 'left' and `mi_img_left`.`gallery_id` = `mi_gallery`.`id` left join `mi_images_gallery` as `mi_img_right` on `mi_img_right`.`flag` = 'right' and `mi_img_right`.`gallery_id` = `mi_gallery`.`id` left join `mi_user_like` as `mi_ul` on `mi_ul`.`post_type` = 'gallery' and `mi_ul`.`post_id` = `mi_gallery`.`id` left join `mi_gallery_trans` as `mi_tr` on `mi_tr`.`gallery_id` = `mi_gallery`.`id` where `mi_tr`.`lang_id` = 'vi' and `mi_gallery`.`clinic_id` = 61 group by `mi_gallery`.`id` order by `mi_gallery`.`created_at` desc limit 20 offset 0

3.72ms/app/Http/Controllers/Frontend/ClinicController.php:157lv_misooda_dev

Metadata
Bindings	0. left 1. right 2. gallery 3. vi 4. 61
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:157 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

select `mi_cl_question_gr`.`id`, IFNULL(`mi_qgt`.`title`,`mi_cl_question_gr`.`title`) as `title` from `mi_cl_question_gr` left join `mi_cl_question_gr_trans` as `mi_qgt` on `mi_qgt`.`cl_q_gid` = `mi_cl_question_gr`.`id` and `mi_qgt`.`lang_id` = 'vi'

920μs/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev

Metadata
Bindings	0. vi
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:187 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_cl_question`.`id`, `mi_cl_question`.`group_id`, `mi_cl_question`.`order_no`, IFNULL(`mi_qt`.`question`,`mi_cl_question`.`question`) as `question`, `mi_at`.`answer` from `mi_cl_question` left join `mi_cl_question_trans` as `mi_qt` on `mi_cl_question`.`id` = `mi_qt`.`cl_q_id` and `mi_qt`.`lang_id` = 'vi' left join `mi_cl_answer` as `mi_ca` on `mi_ca`.`question_id` = `mi_cl_question`.`id` left join `mi_cl_answer_trans` as `mi_at` on `mi_at`.`cl_answer_id` = `mi_ca`.`id` and `mi_at`.`lang_id` = 'vi' where `mi_cl_question`.`group_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10) and `mi_ca`.`clinic_id` = 61 order by `mi_cl_question`.`order_no` asc

1.58ms/app/Http/Controllers/Frontend/ClinicController.php:187lv_misooda_dev

Metadata
Bindings	0. vi 1. vi 2. 61
Backtrace	19. /app/Http/Controllers/Frontend/ClinicController.php:187 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `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` = 'vi' 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` = 'vi' 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` = 'vi' where `mi_review`.`clinic_id` = 61 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 10

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

Metadata
Bindings	0. before 1. after 2. vi 3. vi 4. vi 5. 61
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.clinic.show:222

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

Metadata
Bindings	0. 349 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.clinic.show:222

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

Metadata
Bindings	0. 435 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.clinic.show:222

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

Metadata
Bindings	0. 432 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.clinic.show:222

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

Metadata
Bindings	0. 425 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.clinic.show:222

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

Metadata
Bindings	0. 424 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.clinic.show:222

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

Metadata
Bindings	0. 421 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.clinic.show:222

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

Metadata
Bindings	0. 413 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.clinic.show:222

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

Metadata
Bindings	0. 386 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.clinic.show:222

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

Metadata
Bindings	0. 385 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.clinic.show:222

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

Metadata
Bindings	0. 384 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.clinic.show:222

select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'vi' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

730μs/app/Composers/ReviewComposer.php:121lv_misooda_dev

Metadata
Bindings	0. vi 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Composers/ReviewComposer.php:121 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.clinic.show:222

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` = 'vi' 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` = 'vi' where `mi_promotion`.`clinic_id` = 61 order by `mi_promotion`.`order_no` desc, `mi_promotion`.`created_at` desc limit 12

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

Metadata
Bindings	0. vi 1. vi 2. 61
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.clinic.show:230

select * from `mi_category` left join `mi_category_trans` as `mi_tr2` on `mi_tr2`.`cat_id` = `mi_category`.`id` where `mi_tr2`.`lang_id` = 'vi' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

700μs/app/Composers/PromotionComposer.php:79lv_misooda_dev

Metadata
Bindings	0. vi 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Composers/PromotionComposer.php:79 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.clinic.show:230

select `mi_doctor`.`id`, `mi_doctor`.`email`, `mi_doctor`.`gender`, `mi_doctor`.`board_of_specialty`, `mi_doctor`.`years_of_experiences`, `mi_doctor`.`active_clinic`, `mi_doctor`.`created_at`, `mi_doctor`.`updated_at`, `mi_doctor`.`meta_title`, `mi_doctor`.`meta_desc`, `mi_doctor`.`image`, `mi_doctor`.`cover_image`, IFNULL(`mi_trans`.`name`,`mi_doctor`.`name`) as `name`, IFNULL(`mi_trans`.`title`,`mi_doctor`.`title`) as `title`, IFNULL(`mi_trans`.`school_name`,`mi_doctor`.`school_name`) as `school_name`, IFNULL(`mi_trans`.`internship`,`mi_doctor`.`internship`) as `internship`, IFNULL(`mi_trans`.`residentship`,`mi_doctor`.`residentship`) as `residentship`, IFNULL(`mi_trans`.`academic_activity`,`mi_doctor`.`academic_activity`) as `academic_activity`, IFNULL(`mi_trans`.`awards`,`mi_doctor`.`awards`) as `awards`, IFNULL(`mi_trans`.`thesis`,`mi_doctor`.`thesis`) as `thesis`, AVG(`rating_01`) AS `rating_01`, AVG(`rating_02`) AS `rating_02`, AVG(`rating_03`) AS `rating_03`, AVG(`rating_04`) AS `rating_04`, AVG(`rating_05`) AS `rating_05`, IFNULL(`mi_cdbt`.`title`, `mi_cdb`.`title`) AS `board_specialty_title`, `mi_doc_cat`.`cat_title` as `specialty_title`, `mi_doc_cat`.`cat_percent` as `specialty_percent`, `mi_doc_cat`.`sub_title1`, `mi_doc_cat`.`sub_title2`, `mi_doc_cat`.`sub_title3` from `mi_doctor` left join `mi_doctor_trans` as `mi_trans` on `mi_trans`.`doctor_id` = `mi_doctor`.`id` and `mi_trans`.`lang_id` = 'vi' left join `mi_review` on `mi_review`.`doctor_id` = `mi_doctor`.`id` left join `mi_category_doctor_board` as `mi_cdb` on `mi_cdb`.`id` = `mi_doctor`.`board_of_specialty` left join `mi_category_doctor_board_trans` as `mi_cdbt` on `mi_cdbt`.`cat_id` = `mi_cdb`.`id` and `mi_cdbt`.`lang_id` = 'vi' left join (select `mi_doctor_category`.`doctor_id`, GROUP_CONCAT(IFNULL(`mi_dct`.`title`, `mi_dc`.`title`)) AS `cat_title`, GROUP_CONCAT(IFNULL(`mi_doctor_category`.`percent`, 0)) AS `cat_percent`, GROUP_CONCAT(`mi_dccs1`.`title`) AS `sub_title1`, GROUP_CONCAT(`mi_dccs2`.`title`) AS `sub_title2`, GROUP_CONCAT(`mi_dccs3`.`title`) AS `sub_title3` from `mi_doctor_category` left join `mi_dc_category` as `mi_dc` on `mi_dc`.`id` = `mi_doctor_category`.`category_id` left join `mi_dc_category_trans` as `mi_dct` on `mi_dct`.`cat_id` = `mi_dc`.`id` and `mi_dct`.`lang_id` = 'vi' left join `mi_dc_category_sub` as `mi_dccs1` on `mi_dccs1`.`id` = `mi_doctor_category`.`sub_1` left join `mi_dc_category_sub` as `mi_dccs2` on `mi_dccs2`.`id` = `mi_doctor_category`.`sub_2` left join `mi_dc_category_sub` as `mi_dccs3` on `mi_dccs3`.`id` = `mi_doctor_category`.`sub_3` group by `mi_doctor_category`.`doctor_id`) as `mi_doc_cat` on `mi_doc_cat`.`doctor_id` = `mi_doctor`.`id` where `active_clinic` = 61 group by `mi_doctor`.`id` order by `mi_doctor`.`created_at` desc, `mi_doctor`.`id` asc limit 8

2.59ms/app/Composers/MainComposer.php:223lv_misooda_dev

Metadata
Bindings	0. vi 1. vi 2. vi 3. 61
Backtrace	14. /app/Composers/MainComposer.php:223 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.clinic.show:294

select `mi_user_follow`.*, `mi_user`.`name` as `user_name`, `mi_user`.`username`, `mi_user`.`profile_image` from `mi_user_follow` left join `mi_user` on `mi_user`.`id` = `mi_user_follow`.`user_id` where `post_type` = 'clinic' and `post_id` = 61 order by `mi_user_follow`.`created_at` desc

830μs/app/Composers/MainComposer.php:264lv_misooda_dev

Metadata
Bindings	0. clinic 1. 61
Backtrace	14. /app/Composers/MainComposer.php:264 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.clinic.show:423

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

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

Metadata
Bindings	0. vi 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\UserFollow: 1
App\Model\Doctor: 5
App\Model\Promotion: 3
App\Model\Category: 22
App\Model\ImagesReview: 10
App\Model\ClinicQuestion: 24
App\Model\ClinicQuestionGroup: 9
App\Model\Gallery: 20
App\Model\Review: 11
App\Model\ClinicImage: 9
App\Model\ClinicImageGroup: 2
App\Model\ClinicCategory: 8
App\Model\Clinic: 1
App\Model\Language: 18

web: null
api: null

_token: 9q8xL5SdTo3mf8M9G4DIFubLrZ7MOWb2HZd7SLdF
PHPDEBUGBAR_STACK_DATA: []

path_info

/vi/clinic/hyundal-mlhak-plastic-surgery

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:8 [▶
  "host" => array:1 [▶
    0 => "dev.misooda.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
]

request_server

  0 of 0   
array:33 [▶
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "dev.misooda.com"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)"
  "SERVER_NAME" => "dev.misooda.com"
  "SERVER_ADDR" => "139.59.109.168"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "3.145.77.42"
  "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" => "55790"
  "REDIRECT_URL" => "/vi/clinic/hyundal-mlhak-plastic-surgery"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/vi/clinic/hyundal-mlhak-plastic-surgery"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744921539.439
  "REQUEST_TIME" => 1744921539
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 17 Apr 2025 20:25:39 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRIa0lXaXJJMHQ3aEIrMk9BYzNVbkE9PSIsInZhbHVlIjoiQkROVVExdGJXbGVnVjg1OTFCWUhtK3hhWDFRVHM3Wkw4SnloaVBKYjY3bTY5bFZUcjc5dUVEMm1BNzY1NXFvayIsIm1hYyI6IjEwZTNiZjI5YTRiMjZhMDVkYmZiNWQwZGFmNDE5MTY3ZThkYmQ1OTMzM2VlYTUzNzQwNGJhZDZjZWFjOTY1NjEifQ%3D%3D; expires=Thu, 17-Apr-2025 22:25:39 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlRIa0lXaXJJMHQ3aEIrMk9BYzNVbkE9PSIsInZhbHVlIjoiQkROVVExdGJXbGVnVjg1OTFCWUhtK3hhWDFRVHM3Wkw4SnloaVBKYjY3bTY5bFZUcjc5dUVEMm1BNzY1NXFvayIsIm1hY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRIa0lXaXJJMHQ3aEIrMk9BYzNVbkE9PSIsInZhbHVlIjoiQkROVVExdGJXbGVnVjg1OTFCWUhtK3hhWDFRVHM3Wkw4SnloaVBKYjY3bTY5bFZUcjc5dUVEMm1BNzY1NXFvayIsIm1hYyI6IjEwZTNiZjI5YTRiMjZhMDVkYmZiNWQwZGFmNDE5MTY3ZThkYmQ1OTMzM2VlYTUzNzQwNGJhZDZjZWFjOTY1NjEifQ%3D%3D; expires=Thu, 17-Apr-2025 22:25:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlRIa0lXaXJJMHQ3aEIrMk9BYzNVbkE9PSIsInZhbHVlIjoiQkROVVExdGJXbGVnVjg1OTFCWUhtK3hhWDFRVHM3Wkw4SnloaVBKYjY3bTY5bFZUcjc5dUVEMm1BNzY1NXFvayIsIm1hY ▶"
  ]
]

session_attributes

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

1 x Application (88.13%)	228.56ms
1 x Booting (11.8%)	30.61ms