Misooda

bokkgg_s Lv1

レビュー

... 詳しくはこちら

最近のコメント

作成したコメントがない。

最近の気に入ったアイテム

気に入ったアイテムがない。

フォロワー

james

フォローイング

フォローイングなし。

Messages Timeline Exceptions Views11 Route Queries17 Models22 Mails Auth Gate Session Request

7.2.34108ms8MBGET {lang}/profile/{user}

Booting (26.85ms)
Application (80.57ms)
1 x Application (74.9%)
80.57ms
1 x Booting (24.96%)
26.85ms

11 templates were rendered

frontend.user.user_profile (resources/views/frontend/user/user_profile.blade.php)21blade


ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings

Params
0	`ac`
1	`conf`
2	`langs`
3	`subAc1`
4	`subAc2`
5	`subMenu`
6	`subFull`
7	`me`
8	`user`
9	`subActive`
10	`reviewCount`
11	`wishCount`
12	`commentCount`
13	`followingCount`
14	`followCount`
15	`followed`
16	`lastReviews`
17	`lastSaves`
18	`lastComments`
19	`lastFollows`
20	`lastFollowings`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`

partials.frontend.header (resources/views/partials/frontend/header.blade.php)32blade


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`
32	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
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	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`
32	`footer`
33	`group`
34	`showImg`
35	`limit`
36	`list`
37	`showTitle`
38	`showExcerpt`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`
32	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`
32	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`
32	`footer`

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
lastReviews
lastSaves
lastComments
lastFollows
lastFollowings
__currentLoopData
item
loop
f
header
footer

Params
0	`obLevel`
1	`__env`
2	`app`
3	`cl`
4	`lang`
5	`errors`
6	`ac`
7	`conf`
8	`langs`
9	`subAc1`
10	`subAc2`
11	`subMenu`
12	`subFull`
13	`me`
14	`user`
15	`subActive`
16	`reviewCount`
17	`wishCount`
18	`commentCount`
19	`followingCount`
20	`followCount`
21	`followed`
22	`lastReviews`
23	`lastSaves`
24	`lastComments`
25	`lastFollows`
26	`lastFollowings`
27	`__currentLoopData`
28	`item`
29	`loop`
30	`f`
31	`header`
32	`footer`

uri: GET {lang}/profile/{user}
middleware: web, lang
controller: App\Http\Controllers\Frontend\UserController@myProfile
namespace: App\Http\Controllers\Frontend
prefix: /{lang}
where
file: app/Http/Controllers/Frontend/UserController.php:27-114

17 statements were executed35.66ms

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

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

Metadata
Bindings	0. ja
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/UserController.php:20 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.06ms/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/UserController.php:20 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:825

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

select * from `mi_language` where `is_active` = 1 and `code` = 'ja' limit 12.54msmiddleware::lang:27lv_misooda_dev

Metadata
Bindings	0. 1 1. ja
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 * from `mi_user` where `username` = 'bokkgg_s' limit 1890μs/app/Http/Controllers/Frontend/UserController.php:306lv_misooda_dev

Metadata
Bindings	0. bokkgg_s
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/UserController.php:306 16. /app/Http/Controllers/Frontend/UserController.php:29 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_req` where `user_id` = 1098980μs/app/Http/Controllers/Frontend/UserController.php:278lv_misooda_dev

Metadata
Bindings	0. 1098
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:278 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:29 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select count(*) as aggregate from `mi_user_wish` where `user_id` = 10985.34ms/app/Http/Controllers/Frontend/UserController.php:280lv_misooda_dev

Metadata
Bindings	0. 1098
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:280 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:29 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select count(*) as aggregate from `mi_comments_review` where `user_id` = 10987.54ms/app/Http/Controllers/Frontend/UserController.php:282lv_misooda_dev

Metadata
Bindings	0. 1098
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:282 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:29 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select count(*) as aggregate from `mi_user_follow` where `user_id` = 10981.03ms/app/Http/Controllers/Frontend/UserController.php:286lv_misooda_dev

Metadata
Bindings	0. 1098
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:286 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:29 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select count(*) as aggregate from `mi_user_follow` where `post_type` = 'user' and `post_id` = 1098770μs/app/Http/Controllers/Frontend/UserController.php:289lv_misooda_dev

Metadata
Bindings	0. user 1. 1098
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:289 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:29 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `mi_user_follow` where `post_type` = 'user' and `post_id` = 1098 limit 1640μs/app/Http/Controllers/Frontend/UserController.php:293lv_misooda_dev

Metadata
Bindings	0. user 1. 1098
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/UserController.php:293 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:29 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select `mi_review`.*, `mi_c`.`slug` as `clinic_slug`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_cat`.`title` as `cat_name` from `mi_review` left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review`.`clinic_id` 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_category` as `mi_cat` on `mi_cat`.`id` = `mi_review`.`category_id` where `mi_review`.`user_id` = 1098 order by `mi_review`.`created_at` desc limit 4

1.22ms/app/Http/Controllers/Frontend/UserController.php:47lv_misooda_dev

Metadata
Bindings	0. before 1. after 2. 1098
Backtrace	14. /app/Http/Controllers/Frontend/UserController.php:47 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_user_wish`.`post_type`, `mi_review`.`title` as `review_title`, `mi_review`.`slug` as `review_slug`, `mi_review_clinic`.`slug` as `review_clinic_slug`, `mi_img1`.`path` as `before_path`, `mi_img2`.`path` as `after_path`, `mi_review`.`content` as `review_content`, `mi_promotion`.`title` as `promotion_title`, `mi_promotion`.`slug` as `promotion_slug`, `mi_promotion_clinic`.`slug` as `promotion_clinic_slug`, `mi_promotion`.`img_detail_thumb` as `promotion_image`, `mi_promotion`.`description` as `promotion_description`, `mi_clinic`.`name` as `clinic_name`, `mi_clinic`.`slug` as `clinic_slug`, `mi_clinic`.`image` as `clinic_image`, `mi_clinic`.`description` as `clinic_description`, `mi_user_wish`.`created_at` from `mi_user_wish` left join `mi_review` on `mi_review`.`id` = `mi_user_wish`.`post_id` and `mi_user_wish`.`post_type` = 'review' left join `mi_clinic` on `mi_clinic`.`id` = `mi_user_wish`.`post_id` and `mi_user_wish`.`post_type` = 'clinic' left join `mi_promotion` on `mi_promotion`.`id` = `mi_user_wish`.`post_id` and `mi_user_wish`.`post_type` = 'promotion' left join `mi_clinic` as `mi_review_clinic` on `mi_review`.`clinic_id` = `mi_review_clinic`.`id` left join `mi_clinic` as `mi_promotion_clinic` on `mi_promotion`.`clinic_id` = `mi_promotion_clinic`.`id` 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' where `mi_user_wish`.`user_id` = 1098 order by `mi_user_wish`.`created_at` desc limit 4

1.24ms/app/Http/Controllers/Frontend/UserController.php:80lv_misooda_dev

Metadata
Bindings	0. review 1. clinic 2. promotion 3. before 4. after 5. 1098
Backtrace	14. /app/Http/Controllers/Frontend/UserController.php:80 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_comments_review`.`comment`, `mi_comments_review`.`like_count`, `mi_comments_review`.`dislike_count`, `mi_comments_review`.`date`, `mi_review`.`title` as `review_title`, `mi_review`.`slug` as `review_slug`, `mi_clinic`.`slug` as `clinic_slug` from `mi_comments_review` left join `mi_review` on `mi_review`.`id` = `mi_comments_review`.`post_id` left join `mi_clinic` on `mi_clinic`.`id` = `mi_review`.`clinic_id` where `mi_comments_review`.`user_id` = 1098 order by `mi_comments_review`.`date` desc limit 4

720μs/app/Http/Controllers/Frontend/UserController.php:90lv_misooda_dev

Metadata
Bindings	0. 1098
Backtrace	14. /app/Http/Controllers/Frontend/UserController.php:90 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_user_follow`.*, `mi_user`.`name` as `user_name`, `mi_user`.`username` as `username`, `mi_user`.`profile_image` from `mi_user_follow` left join `mi_user` on `mi_user`.`id` = `mi_user_follow`.`user_id` where `mi_user_follow`.`post_type` = 'user' and `mi_user_follow`.`post_id` = 1098 order by `mi_user_follow`.`created_at` desc limit 4

2.48ms/app/Http/Controllers/Frontend/UserController.php:98lv_misooda_dev

Metadata
Bindings	0. user 1. 1098
Backtrace	14. /app/Http/Controllers/Frontend/UserController.php:98 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_user_follow`.*, `mi_user`.`name` as `user_name`, `mi_user`.`username` as `username`, `mi_user`.`profile_image`, `mi_clinic`.`slug` as `clinic_slug`, `mi_clinic`.`name` as `clinic_name`, `mi_clinic`.`logo` as `clinic_logo` from `mi_user_follow` left join `mi_clinic` on `mi_user_follow`.`post_type` = 'clinic' and `mi_user_follow`.`post_id` = `mi_clinic`.`id` left join `mi_user` on `mi_user_follow`.`post_type` = 'user' and `mi_user_follow`.`post_id` = `mi_user`.`id` where `mi_user_follow`.`user_id` = 1098 order by `mi_user_follow`.`created_at` desc limit 4

820μs/app/Http/Controllers/Frontend/UserController.php:111lv_misooda_dev

Metadata
Bindings	0. clinic 1. user 2. 1098
Backtrace	14. /app/Http/Controllers/Frontend/UserController.php:111 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_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` = 'ja' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

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

Metadata
Bindings	0. ja 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\Review: 1
App\Model\UserFollow: 2
App\Model\User: 1
App\Model\Language: 18

web: null
api: null

_token: HmAPFh0vnKI9xQ6nYGUcw7UolqigknC0Omsh085l
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://dev.misooda.com/ja/k-beautys" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/ja/profile/bokkgg_s

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 => "misooda=9MG4xG0BFQXEaD10zR9V7wt5TRsAgRJCKEOUVxoI; _fbp=fb.1.1762531631687.399043686515097058; XSRF-TOKEN=eyJpdiI6ImtObm1FNm1iblBFeXN2MitUUmFPR2c9PSIsInZhbHVlIjoiYlN3QUtnaEZoZDFaKzlhSFJXcWVlZ1QxclFFcmdNaklFZExLc25valhVc05QcE9ZaFwvMFF1TW95RlM2KzFkZWUiLCJtYWMiOiIzNTA2YWY5Mjk3ZWFiZjUzNmMxOTEwOWU2MzNkZWJjZTE3YTJlMWQ0MGQ2MDk0M2NjNzA1ODlmZmJkNTc4ZDk1In0%3D ◀misooda=9MG4xG0BFQXEaD10zR9V7wt5TRsAgRJCKEOUVxoI; _fbp=fb.1.1762531631687.399043686515097058; XSRF-TOKEN=eyJpdiI6ImtObm1FNm1iblBFeXN2MitUUmFPR2c9PSIsInZhbHVlIjo ▶"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-42g69 (squid/6.13)"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.3.227.172"
  ]
  "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" => "misooda=9MG4xG0BFQXEaD10zR9V7wt5TRsAgRJCKEOUVxoI; _fbp=fb.1.1762531631687.399043686515097058; XSRF-TOKEN=eyJpdiI6ImtObm1FNm1iblBFeXN2MitUUmFPR2c9PSIsInZhbHVlIjoiYlN3QUtnaEZoZDFaKzlhSFJXcWVlZ1QxclFFcmdNaklFZExLc25valhVc05QcE9ZaFwvMFF1TW95RlM2KzFkZWUiLCJtYWMiOiIzNTA2YWY5Mjk3ZWFiZjUzNmMxOTEwOWU2MzNkZWJjZTE3YTJlMWQ0MGQ2MDk0M2NjNzA1ODlmZmJkNTc4ZDk1In0%3D ◀misooda=9MG4xG0BFQXEaD10zR9V7wt5TRsAgRJCKEOUVxoI; _fbp=fb.1.1762531631687.399043686515097058; XSRF-TOKEN=eyJpdiI6ImtObm1FNm1iblBFeXN2MitUUmFPR2c9PSIsInZhbHVlIjo ▶"
  "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-42g69 (squid/6.13)"
  "HTTP_X_FORWARDED_FOR" => "10.3.227.172"
  "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.31"
  "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" => "24745"
  "REDIRECT_URL" => "/ja/profile/bokkgg_s"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/ja/profile/bokkgg_s"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1762531637.426
  "REQUEST_TIME" => 1762531637
]

request_cookies

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

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 07 Nov 2025 16:07:17 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJCTzJZVFwvanIzbjh5Wlgwa0NrUHB3PT0iLCJ2YWx1ZSI6IlY2UnUwWEg2cTVyalZub2Q4Zys0MlU1ZFJRUUEwYlhROHp6RFU5NGNRK0tpOWlYVFNwdVJLcVdzd2pSRitBOUQiLCJtYWMiOiJjN2ViZWRhNGE4MDJjOTk0NmU0YmU0NGQwZDQ5OTk1YTFmNTk4YTI0MDkyOGYyZTRjNzExNGVjZTVkZGIzNDVjIn0%3D; expires=Fri, 07-Nov-2025 18:07:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlJCTzJZVFwvanIzbjh5Wlgwa0NrUHB3PT0iLCJ2YWx1ZSI6IlY2UnUwWEg2cTVyalZub2Q4Zys0MlU1ZFJRUUEwYlhROHp6RFU5NGNRK0tpOWlYVFNwdVJLcVdzd2pSRitBOUQiLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJCTzJZVFwvanIzbjh5Wlgwa0NrUHB3PT0iLCJ2YWx1ZSI6IlY2UnUwWEg2cTVyalZub2Q4Zys0MlU1ZFJRUUEwYlhROHp6RFU5NGNRK0tpOWlYVFNwdVJLcVdzd2pSRitBOUQiLCJtYWMiOiJjN2ViZWRhNGE4MDJjOTk0NmU0YmU0NGQwZDQ5OTk1YTFmNTk4YTI0MDkyOGYyZTRjNzExNGVjZTVkZGIzNDVjIn0%3D; expires=Fri, 07-Nov-2025 18:07:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlJCTzJZVFwvanIzbjh5Wlgwa0NrUHB3PT0iLCJ2YWx1ZSI6IlY2UnUwWEg2cTVyalZub2Q4Zys0MlU1ZFJRUUEwYlhROHp6RFU5NGNRK0tpOWlYVFNwdVJLcVdzd2pSRitBOUQiLCJtY ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "HmAPFh0vnKI9xQ6nYGUcw7UolqigknC0Omsh085l"
  "PHPDEBUGBAR_STACK_DATA" => []
  "_previous" => array:1 [▶
    "url" => "http://dev.misooda.com/ja/k-beautys"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

1 x Application (74.9%)	80.57ms
1 x Booting (24.96%)	26.85ms