Hyundai Aesthetics, Reviews, Images, Promotions

Messages Timeline Exceptions Views8 Route Queries26 Models71 Mails Auth Gate Session Request

7.2.34116ms9MBGET m/{lang}/clinic/{slug}/reviews/{cat?}

Booting (15.25ms)
Application (100ms)
1 x Application (86.72%)
100.29ms
1 x Booting (13.19%)
15.25ms

8 templates were rendered

mobile.clinic.reviews (resources/views/mobile/clinic/reviews.blade.php)20blade


ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list

Params
0	`ac`
1	`conf`
2	`langs`
3	`clinic_ac`
4	`data`
5	`topImages`
6	`rating_01`
7	`rating_02`
8	`rating_03`
9	`rating_04`
10	`rating_05`
11	`rating`
12	`reviewCount`
13	`followed`
14	`followerCount`
15	`pageTitle`
16	`pageDesc`
17	`pageImage`
18	`main_page`
19	`list`

layouts.mobile_clinic_layout (resources/views/layouts/mobile_clinic_layout.blade.php)31blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`

layouts.mobile_layout (resources/views/layouts/mobile_layout.blade.php)39blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img
firstImage
ti
k
imgPath
header
params
footer
footerParams

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`
31	`firstImage`
32	`ti`
33	`k`
34	`imgPath`
35	`header`
36	`params`
37	`footer`
38	`footerParams`

partials.mobile.header-meta (resources/views/partials/mobile/header-meta.blade.php)40blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img
firstImage
ti
k
imgPath
header
params
footer
footerParams
tawk

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`
31	`firstImage`
32	`ti`
33	`k`
34	`imgPath`
35	`header`
36	`params`
37	`footer`
38	`footerParams`
39	`tawk`

partials.mobile.messages (resources/views/partials/mobile/messages.blade.php)43blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img
firstImage
ti
k
imgPath
header
params
footer
footerParams
tawk
request
isWebView
userData

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`
31	`firstImage`
32	`ti`
33	`k`
34	`imgPath`
35	`header`
36	`params`
37	`footer`
38	`footerParams`
39	`tawk`
40	`request`
41	`isWebView`
42	`userData`

partials.mobile.footer-clinic (resources/views/partials/mobile/footer-clinic.blade.php)46blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img
firstImage
ti
k
imgPath
header
params
footer
footerParams
tawk
request
isWebView
userData
clinicId
clinicSlug
clinicName

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`
31	`firstImage`
32	`ti`
33	`k`
34	`imgPath`
35	`header`
36	`params`
37	`footer`
38	`footerParams`
39	`tawk`
40	`request`
41	`isWebView`
42	`userData`
43	`clinicId`
44	`clinicSlug`
45	`clinicName`

partials.mobile.modal.login (resources/views/partials/mobile/modal/login.blade.php)43blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img
firstImage
ti
k
imgPath
header
params
footer
footerParams
tawk
request
isWebView
userData

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`
31	`firstImage`
32	`ti`
33	`k`
34	`imgPath`
35	`header`
36	`params`
37	`footer`
38	`footerParams`
39	`tawk`
40	`request`
41	`isWebView`
42	`userData`

partials.mobile.footer-meta (resources/views/partials/mobile/footer-meta.blade.php)43blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
topImages
rating_01
rating_02
rating_03
rating_04
rating_05
rating
reviewCount
followed
followerCount
pageTitle
pageDesc
pageImage
main_page
list
__currentLoopData
item
loop
diary
img
firstImage
ti
k
imgPath
header
params
footer
footerParams
tawk
request
isWebView
userData

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	`topImages`
12	`rating_01`
13	`rating_02`
14	`rating_03`
15	`rating_04`
16	`rating_05`
17	`rating`
18	`reviewCount`
19	`followed`
20	`followerCount`
21	`pageTitle`
22	`pageDesc`
23	`pageImage`
24	`main_page`
25	`list`
26	`__currentLoopData`
27	`item`
28	`loop`
29	`diary`
30	`img`
31	`firstImage`
32	`ti`
33	`k`
34	`imgPath`
35	`header`
36	`params`
37	`footer`
38	`footerParams`
39	`tawk`
40	`request`
41	`isWebView`
42	`userData`

uri: GET m/{lang}/clinic/{slug}/reviews/{cat?}
middleware: web, redirect.topc, lang
controller: App\Http\Controllers\Mobile\ClinicController@reviews
namespace: App\Http\Controllers\Mobile
prefix: m/{lang}
where
file: app/Http/Controllers/Mobile/ClinicController.php:239-300

26 statements were executed17.59ms

select `mi_config`.`code`, IFNULL(`mi_ct`.`value`, `mi_config`.`value`) AS `value` from `mi_config` left join `mi_config_trans` as `mi_ct` on `mi_config`.`id` = `mi_ct`.`config_id` and `mi_ct`.`lang_id` = 'en'

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

Metadata
Bindings	0. en
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	13. /app/Http/Controllers/FrontendController.php:33 14. /app/Http/Controllers/Mobile/ClinicController.php:29 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/Mobile/ClinicController.php:29 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

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

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

Metadata
Bindings	0. 1 1. en
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. middleware::lang:27 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 18. middleware::redirect.topc:25 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select `mi_clinic`.`id`, `mi_clinic`.`slug`, `mi_clinic`.`hit`, `mi_clinic`.`gold`, `mi_clinic`.`featured`, `mi_clinic`.`logo`, `mi_clinic`.`image`, `mi_clinic`.`small_image`, `mi_clinic`.`meta_title`, `mi_clinic`.`meta_desc`, `mi_clinic`.`status`, `mi_clinic`.`show_type`, `mi_clinic`.`order_no`, `mi_clinic`.`inq_alert`, `mi_clinic`.`language_codes`, `mi_clinic`.`service_item_codes`, `mi_clinic`.`guarantee_item_codes`, `mi_clinic`.`business_time_table`, `mi_clinic`.`landing_images`, `mi_clinic`.`created_at`, `mi_clinic`.`updated_at`, IFNULL(`mi_trans`.`name`,`mi_clinic`.`name`) as `name`, IFNULL(`mi_trans`.`address`,`mi_clinic`.`address`) as `address`, IFNULL(`mi_trans`.`description`,`mi_clinic`.`description`) as `description`, IFNULL(`mi_trans`.`business_time`,`mi_clinic`.`business_time`) as `business_time`, IFNULL(`mi_trans`.`business_hour`,`mi_clinic`.`business_hour`) as `business_hour` from `mi_clinic` left join `mi_clinic_trans` as `mi_trans` on `mi_trans`.`clinic_id` = `mi_clinic`.`id` and `mi_trans`.`lang_id` = 'en' where `mi_clinic`.`slug` = 'hyundal-mlhak-plastic-surgery' limit 1

800μs/app/Http/Controllers/Mobile/ClinicController.php:430lv_misooda_dev

Metadata
Bindings	0. en 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/Mobile/ClinicController.php:430 16. /app/Http/Controllers/Mobile/ClinicController.php:241 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`.*, `mi_gr`.`code` from `mi_cl_image` left join `mi_cl_image_gr` as `mi_gr` on `mi_gr`.`id` = `mi_cl_image`.`group_id` where `mi_cl_image`.`clinic_id` = 61 and `mi_gr`.`code` = 'top-image'

730μs/app/Http/Controllers/Mobile/ClinicController.php:441lv_misooda_dev

Metadata
Bindings	0. 61 1. top-image
Backtrace	14. /app/Http/Controllers/Mobile/ClinicController.php:441 15. /app/Http/Controllers/Mobile/ClinicController.php:241 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

560μs/app/Http/Controllers/Mobile/ClinicController.php:452lv_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/Mobile/ClinicController.php:452 16. /app/Http/Controllers/Mobile/ClinicController.php:241 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_user_follow` where `post_type` = 'clinic' and `post_id` = 61470μs/app/Http/Controllers/Mobile/ClinicController.php:484lv_misooda_dev

Metadata
Bindings	0. clinic 1. 61
Backtrace	15. /app/Http/Controllers/Mobile/ClinicController.php:484 16. /app/Http/Controllers/Mobile/ClinicController.php:241 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_review` left join `mi_review_trans` as `mi_rt` on `mi_rt`.`review_id` = `mi_review`.`id` and `mi_rt`.`lang_id` = 'en' left join `mi_clinic` 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` = 'en' 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`.`clinic_id` = 61

1.75ms/app/Http/Controllers/Mobile/ClinicController.php:297lv_misooda_dev

Metadata
Bindings	0. en 1. en 2. review 3. 0 4. 61
Backtrace	15. /app/Http/Controllers/Mobile/ClinicController.php:297 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_review`.`id`, `mi_review`.`img_before`, `mi_review`.`img_after`, `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` = 'en' 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` = 'en' 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`.`clinic_id` = 61 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 5 offset 0

2.01ms/app/Http/Controllers/Mobile/ClinicController.php:297lv_misooda_dev

Metadata
Bindings	0. en 1. en 2. review 3. 0 4. 61
Backtrace	15. /app/Http/Controllers/Mobile/ClinicController.php:297 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 * from `mi_review_diary` where `mi_review_diary`.`review_id` in (349, 424, 425, 432, 435)840μs/app/Http/Controllers/Mobile/ClinicController.php:297lv_misooda_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Http/Controllers/Mobile/ClinicController.php:297 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1011 and `mi_images_diary`.`diary_id` is not null850μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1011
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1012 and `mi_images_diary`.`diary_id` is not null600μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1012
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1013 and `mi_images_diary`.`diary_id` is not null530μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1013
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1014 and `mi_images_diary`.`diary_id` is not null490μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1014
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1015 and `mi_images_diary`.`diary_id` is not null490μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1015
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1016 and `mi_images_diary`.`diary_id` is not null450μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1016
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1018 and `mi_images_diary`.`diary_id` is not null460μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1018
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1303 and `mi_images_diary`.`diary_id` is not null470μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1303
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1304 and `mi_images_diary`.`diary_id` is not null370μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1304
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1286 and `mi_images_diary`.`diary_id` is not null370μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1286
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1264 and `mi_images_diary`.`diary_id` is not null400μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1264
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1260 and `mi_images_diary`.`diary_id` is not null430μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1260
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1261 and `mi_images_diary`.`diary_id` is not null390μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1261
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1262 and `mi_images_diary`.`diary_id` is not null400μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1262
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

select * from `mi_images_diary` where `mi_images_diary`.`diary_id` = 1263 and `mi_images_diary`.`diary_id` is not null500μs/app/Model/Base/BaseModel.php:236lv_misooda_dev

Metadata
Bindings	0. 1263
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /app/Model/Base/BaseModel.php:236 19. view::mobile.clinic.reviews:37 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125

App\Model\ImagesDiary: 30
App\Model\ReviewDiary: 15
App\Model\Review: 6
App\Model\ClinicImage: 1
App\Model\Clinic: 1
App\Model\Language: 18

web: null
api: null

_token: UjrdxcItlpxQJmyH3PDrst3d5KLTS96MhqbC1y9l
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://dev.misooda.com/ja/clinic/ren-plastic-surgery/promotions/two-jaw" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/m/en/clinic/hyundal-mlhak-plastic-surgery/reviews

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_server

  0 of 0   
array:36 [▶
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "dev.misooda.com"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate"
  "HTTP_COOKIE" => "_fbp=fb.1.1750590573663.187169401673224995; misooda=RhKSFRGmaEcTS3bzgeo1MG9CMOU4rKXWII3vSZJS; XSRF-TOKEN=eyJpdiI6InVTb2FPUjViRDRzdVNaT1F4VlpPZVE9PSIsInZhbHVlIjoiXC85SGs0T1FhZkFaNG1wbFZmUnpRTm1TaDh3YnBcL2JTVjR0dm5uNnNSVlhCOFNwYm1pTUROcTlXMW9YWHptQzExIiwibWFjIjoiYmRmYzA3NWFmNGM2ODNiYjA0YmEwNGVkOGQyNmI2ZDcxOGRmZjA2NmU3NTI2NDM5NjUwNzgzNjY2NDE4YmY0MSJ9 ◀_fbp=fb.1.1750590573663.187169401673224995; misooda=RhKSFRGmaEcTS3bzgeo1MG9CMOU4rKXWII3vSZJS; XSRF-TOKEN=eyJpdiI6InVTb2FPUjViRDRzdVNaT1F4VlpPZVE9PSIsInZhbHVlIjo ▶"
  "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-5tmmn (squid/6.10)"
  "HTTP_X_FORWARDED_FOR" => "10.2.165.113"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.18 (Ubuntu) Server at dev.misooda.com Port 80</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.18 (Ubuntu)"
  "SERVER_NAME" => "dev.misooda.com"
  "SERVER_ADDR" => "139.59.109.168"
  "SERVER_PORT" => "80"
  "REMOTE_ADDR" => "216.73.216.244"
  "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" => "55231"
  "REDIRECT_URL" => "/m/en/clinic/hyundal-mlhak-plastic-surgery/reviews"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/m/en/clinic/hyundal-mlhak-plastic-surgery/reviews"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1750590578.276
  "REQUEST_TIME" => 1750590578
]

request_cookies

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

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 22 Jun 2025 11:09:38 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlUcHc4ekxDXC9KTU9NbVZ3blFhbkhRPT0iLCJ2YWx1ZSI6ImZGbzhMakczSGF1RStcL01abkhEYll1ZHhpWGl2bnZzSEFEaWdSUFFnUit3UThLdmNGbFRndkVSaWpNKzFWcmZsIiwibWFjIjoiOGZiOGMyZWU3NjA1YzAxNWMxOThjZjJkMGVkOWEwNTAwNjk1NTg5ZGVmZDk3NzViZjU2NDY3ZTc2YzI5YjdmMiJ9; expires=Sun, 22-Jun-2025 13:09:38 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InlUcHc4ekxDXC9KTU9NbVZ3blFhbkhRPT0iLCJ2YWx1ZSI6ImZGbzhMakczSGF1RStcL01abkhEYll1ZHhpWGl2bnZzSEFEaWdSUFFnUit3UThLdmNGbFRndkVSaWpNKzFWcmZsIiwib ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InlUcHc4ekxDXC9KTU9NbVZ3blFhbkhRPT0iLCJ2YWx1ZSI6ImZGbzhMakczSGF1RStcL01abkhEYll1ZHhpWGl2bnZzSEFEaWdSUFFnUit3UThLdmNGbFRndkVSaWpNKzFWcmZsIiwibWFjIjoiOGZiOGMyZWU3NjA1YzAxNWMxOThjZjJkMGVkOWEwNTAwNjk1NTg5ZGVmZDk3NzViZjU2NDY3ZTc2YzI5YjdmMiJ9; expires=Sun, 22-Jun-2025 13:09:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InlUcHc4ekxDXC9KTU9NbVZ3blFhbkhRPT0iLCJ2YWx1ZSI6ImZGbzhMakczSGF1RStcL01abkhEYll1ZHhpWGl2bnZzSEFEaWdSUFFnUit3UThLdmNGbFRndkVSaWpNKzFWcmZsIiwib ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "UjrdxcItlpxQJmyH3PDrst3d5KLTS96MhqbC1y9l"
  "PHPDEBUGBAR_STACK_DATA" => []
  "_previous" => array:1 [▶
    "url" => "http://dev.misooda.com/ja/clinic/ren-plastic-surgery/promotions/two-jaw"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

Nose

before

after

鼻形成術+脂肪移植+ PRP +涙袋の除去+スレッドリフト+唇フィラー

Likes · Comment 0

Like Comment

Eye

Beautiful eyelids with Hyundai Aesthetics

Beautiful eyelids with Hyundai Aesthetics

Lip

Philtrum Reduction, Lovely Smile Balanced, Cupid’s bow lip Surgery

Philtrum Reduction, Lovely Smile Balanced, Cupid’s bow lip Surgery

Breast

Breast augmentation After 2 weeks

Endotine thread lifting, Epicanthoplasty, Nose revision surgery, lip tip lift

Endotine thread lifting, Epicanthoplasty, Nose revision surgery, lip tip lift

1 x Application (86.72%)	100.29ms
1 x Booting (13.19%)	15.25ms