PRETTY BODY CLINIC,Reviews,Images, Promotions

美线整形医院

地址 : 501 Cheongdong-ro, Gangnam-gu, Seoul, South Korea

满意度 :

专业 : 脂肪移植吸脂术

Chat Now

咨询

最佳评论

ramsey

美线整形医院
PilotG

美线整形医院
Josejose

美线整形医院
Bonbonlee

美线整形医院
yy1996

美线整形医院
Tinanguyen

美线整形医院
piggy6

美线整形医院
lright

美线整形医院
dorong

美线整形医院
jinnyjenny

美线整形医院
frayen

美线整形医院
yumyum

美线整形医院
Tinanguyen

美线整形医院

Messages Timeline Exceptions Views12 Route Queries28 Models62 Mails Auth Gate Session Request

7.2.34757ms16MBGET {lang}/clinic/{slug}/reviews/{cat?}

Booting (436ms)
Application (308ms)
1 x Booting (57.63%)
436.42ms
1 x Application (40.7%)
308.25ms

12 templates were rendered

frontend.clinic.reviews (resources/views/frontend/clinic/reviews.blade.php)16blade


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

partials.frontend.clinic-top-section (resources/views/partials/frontend/clinic-top-section.blade.php)22blade
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

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`

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`

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


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

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	`clinic_id`
23	`showBest`
24	`showAll`
25	`url`
26	`limit`
27	`promotion_id`
28	`doctor_id`
29	`type`
30	`list`
31	`rMenuType`
32	`showCats`
33	`category_id`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`
23	`footer`
24	`group`
25	`showImg`
26	`limit`
27	`list`
28	`showTitle`
29	`showExcerpt`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`
23	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
clinic_ac
data
cats
cat
category
tomImages
rating
reviewCount
promotionCount
followed
pageTitle
pageDesc
pageImage
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	`header`
23	`footer`

uri: GET {lang}/clinic/{slug}/reviews/{cat?}
middleware: web, lang, redirect.tomobile
controller: App\Http\Controllers\Frontend\ClinicController@reviews
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/ClinicController.php:195-205

28 statements were executed63.69ms

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` = 'zh-CN'

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

Metadata
Bindings	0. zh-CN
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` desc2.75ms/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` desc2.17ms/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` = 'zh-CN' limit 11.36msmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. zh-CN
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` = 'zh-CN' and `slug` = 'pretty-body-clinic' limit 1

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

Metadata
Bindings	0. zh-CN 1. pretty-body-clinic
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:197 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` = 169 and `mi_tr`.`lang_id` = 'zh-CN'

2.42ms/app/Http/Controllers/Frontend/ClinicController.php:371lv_misooda_dev

Metadata
Bindings	0. 169 1. zh-CN
Backtrace	14. /app/Http/Controllers/Frontend/ClinicController.php:371 15. /app/Http/Controllers/Frontend/ClinicController.php:197 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 `mi_category`.*, `mi_tr`.`title` from `mi_category` left join `mi_category_trans` as `mi_tr` on `mi_tr`.`cat_id` = `mi_category`.`id` where `mi_tr`.`lang_id` = 'zh-CN' and `code` = 'liposuction' limit 1

1ms/app/Http/Controllers/Frontend/ClinicController.php:379lv_misooda_dev

Metadata
Bindings	0. zh-CN 1. liposuction
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Http/Controllers/Frontend/ClinicController.php:379 16. /app/Http/Controllers/Frontend/ClinicController.php:197 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_gr` where `code` = 'top-image' limit 11.25ms/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:197 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` = 169 and `group_id` = 21.64ms/app/Http/Controllers/Frontend/ClinicController.php:392lv_misooda_dev

Metadata
Bindings	0. 169 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:197 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` = 169 group by `clinic_id` limit 1

4.92ms/app/Http/Controllers/Frontend/ClinicController.php:405lv_misooda_dev

Metadata
Bindings	0. 169
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:197 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` = 1691.18ms/app/Http/Controllers/Frontend/ClinicController.php:415lv_misooda_dev

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

select * from `mi_category` where `code` = 'liposuction' limit 12.39ms/app/Composers/ReviewComposer.php:89lv_misooda_dev

Metadata
Bindings	0. liposuction
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/Composers/ReviewComposer.php:89 20. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 21. /vendor/laravel/framework/src/Illuminate/View/View.php:123 22. /vendor/laravel/framework/src/Illuminate/View/View.php:90 23. view::frontend.clinic.reviews:21

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` = 'zh-CN' 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` = 'zh-CN' 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` = 'zh-CN' where `mi_review`.`clinic_id` = 169 and `mi_review`.`category_id` = 40 order by `mi_review`.`order_no` desc, `mi_review`.`created_at` desc limit 100

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

Metadata
Bindings	0. before 1. after 2. zh-CN 3. zh-CN 4. zh-CN 5. 169 6. 40
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.reviews:21

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

Metadata
Bindings	0. 339 1. after
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. /app/Composers/ReviewComposer.php:104 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::frontend.clinic.reviews:21

select * from `mi_images_review` where `review_id` = 445 and `flag` = 'after' limit 72.08ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 445 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.reviews:21

select * from `mi_images_review` where `review_id` = 438 and `flag` = 'after' limit 71.98ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 438 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.reviews:21

select * from `mi_images_review` where `review_id` = 405 and `flag` = 'after' limit 71.24ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 405 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.reviews:21

select * from `mi_images_review` where `review_id` = 400 and `flag` = 'after' limit 72.08ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 400 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.reviews:21

select * from `mi_images_review` where `review_id` = 367 and `flag` = 'after' limit 71.32ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 367 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.reviews:21

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

Metadata
Bindings	0. 341 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.reviews:21

select * from `mi_images_review` where `review_id` = 340 and `flag` = 'after' limit 77.26ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 340 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.reviews:21

select * from `mi_images_review` where `review_id` = 338 and `flag` = 'after' limit 75.59ms/app/Composers/ReviewComposer.php:104lv_misooda_dev

Metadata
Bindings	0. 338 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.reviews:21

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

Metadata
Bindings	0. 337 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.reviews:21

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

Metadata
Bindings	0. 336 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.reviews:21

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

Metadata
Bindings	0. 334 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.reviews:21

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

Metadata
Bindings	0. 366 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.reviews:21

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` = 'zh-CN' and `mi_category`.`menu_type` = 1 order by `mi_category`.`order_no` desc, `mi_category`.`id` asc

1.11ms/app/Composers/ReviewComposer.php:121lv_misooda_dev

Metadata
Bindings	0. zh-CN 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.reviews:21

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

2.73ms/app/Composers/BannerComposer.php:20lv_misooda_dev

Metadata
Bindings	0. zh-CN 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\ImagesReview: 12
App\Model\Review: 14
App\Model\ClinicImage: 1
App\Model\ClinicImageGroup: 1
App\Model\Category: 13
App\Model\ClinicCategory: 2
App\Model\Clinic: 1
App\Model\Language: 18

web: null
api: null

_token: RN3ltLjbAI1jVpNdu5t4pWHTMMLzEUlqleQLoVhb
PHPDEBUGBAR_STACK_DATA: []

path_info

/zh-CN/clinic/pretty-body-clinic/reviews/liposuction

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_server

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

request_cookies

[]

response_headers

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

session_attributes

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

1 x Booting (57.63%)	436.42ms
1 x Application (40.7%)	308.25ms