Misooda

an_dre22 Lv1

รีวิว

คุณยังไม่มีรีวิว

Messages Timeline Exceptions Views11 Route Queries13 Models19 Mails Auth Gate Session Request

7.2.34198ms8MBGET {lang}/profile/{user}/reviews

Booting (58.91ms)
Application (139ms)
1 x Application (70.04%)
138.58ms
1 x Booting (29.77%)
58.91ms

11 templates were rendered

frontend.user.user_reviews (resources/views/frontend/user/user_reviews.blade.php)17blade


ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews
header

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews
header
footer

partials.shortcode.banner_list (resources/views/partials/shortcode/banner_list.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
reviews
header
footer
group
showImg
limit
list
showTitle
showExcerpt

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews
header
footer

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews
header
footer

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews
header
footer

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


obLevel
__env
app
cl
lang
errors
ac
conf
langs
subAc1
subAc2
subMenu
subFull
me
user
subActive
reviewCount
wishCount
commentCount
followingCount
followCount
followed
reviews
header
footer

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

13 statements were executed37.95ms

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

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

Metadata
Bindings	0. th
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	13. /app/Http/Controllers/FrontendController.php:33 14. /app/Http/Controllers/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` desc1.6ms/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` desc5.62ms/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` = 'th' limit 14.44msmiddleware::lang:27lv_misooda_dev

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

select * from `mi_user` where `username` = 'an_dre22' limit 15.02ms/app/Http/Controllers/Frontend/UserController.php:306lv_misooda_dev

Metadata
Bindings	0. an_dre22
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:119 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` = 12761.54ms/app/Http/Controllers/Frontend/UserController.php:278lv_misooda_dev

Metadata
Bindings	0. 1276
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:278 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:119 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` = 12761.64ms/app/Http/Controllers/Frontend/UserController.php:280lv_misooda_dev

Metadata
Bindings	0. 1276
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:280 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:119 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` = 12763.51ms/app/Http/Controllers/Frontend/UserController.php:282lv_misooda_dev

Metadata
Bindings	0. 1276
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:282 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:119 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` = 1276480μs/app/Http/Controllers/Frontend/UserController.php:286lv_misooda_dev

Metadata
Bindings	0. 1276
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:286 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:119 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` = 1276430μs/app/Http/Controllers/Frontend/UserController.php:289lv_misooda_dev

Metadata
Bindings	0. user 1. 1276
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:289 16. /app/Http/Controllers/Frontend/UserController.php:319 17. /app/Http/Controllers/Frontend/UserController.php:119 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` = 1276 limit 1380μs/app/Http/Controllers/Frontend/UserController.php:293lv_misooda_dev

Metadata
Bindings	0. user 1. 1276
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:119 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_review_req` left join `mi_clinic` as `mi_c` on `mi_c`.`id` = `mi_review_req`.`clinic_id` left join `mi_review` on `mi_review`.`id` = `mi_review_req`.`review_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_review_req`.`user_id` = 1276

9.56ms/app/Http/Controllers/Frontend/UserController.php:136lv_misooda_dev

Metadata
Bindings	0. before 1. after 2. 1276
Backtrace	15. /app/Http/Controllers/Frontend/UserController.php:136 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_banner`.`id`, `mi_banner`.`group_code`, `mi_banner`.`order_no`, `mi_banner`.`created_at`, `mi_banner`.`updated_at`, IFNULL(`mi_trans`.`title`,`mi_banner`.`title`) as `title`, IFNULL(`mi_trans`.`excerpt`,`mi_banner`.`excerpt`) as `excerpt`, IFNULL(`mi_trans`.`link`,`mi_banner`.`link`) as `link`, IFNULL(`mi_trans`.`image`,`mi_banner`.`image`) as `image` from `mi_banner` left join `mi_banner_trans` as `mi_trans` on `mi_trans`.`banner_id` = `mi_banner`.`id` and `mi_trans`.`lang_id` = 'th' where `group_code` = 'banner-footer-dark' order by `mi_banner`.`order_no` desc

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

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

web: null
api: null

_token: FMniqyXFSnpTG2AQSWF7Jgv5ZlLuOhiQ7p9KuzQ1
PHPDEBUGBAR_STACK_DATA: []

path_info

/th/profile/an_dre22/reviews

status_code

status_text

OK

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:10 [▶
  "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"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.3.59.54"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
]

request_server

  0 of 0   
array:35 [▶
  "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_VIA" => "1.1 squid-proxy-5b5d847c96-csctg (squid/6.10)"
  "HTTP_X_FORWARDED_FOR" => "10.3.59.54"
  "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.254"
  "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" => "19191"
  "REDIRECT_URL" => "/th/profile/an_dre22/reviews"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/th/profile/an_dre22/reviews"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1750548723.322
  "REQUEST_TIME" => 1750548723
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 21 Jun 2025 23:32:03 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkphTzlDek5uZjZJMnNxK1wvSkJpNUd3PT0iLCJ2YWx1ZSI6IlczWGczXC9hXC8wMzZCalhVUklSZDM1Y01USWFhOHpMXC9Uc2Vwd3FiS0VQMVJPRVpkejM5aHZ5UVRWRVFWNVNIaDQiLCJtYWMiOiI2ODE1OWIyNjZiZjc0MDJlZTRkYTlhNDIwYTBjZGFhOWVjZjYwMzUyNjJiNGE1N2MwM2VjMzE0ODAyNzQ5YzYzIn0%3D; expires=Sun, 22-Jun-2025 01:32:03 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkphTzlDek5uZjZJMnNxK1wvSkJpNUd3PT0iLCJ2YWx1ZSI6IlczWGczXC9hXC8wMzZCalhVUklSZDM1Y01USWFhOHpMXC9Uc2Vwd3FiS0VQMVJPRVpkejM5aHZ5UVRWRVFWNVNIaDQiL ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkphTzlDek5uZjZJMnNxK1wvSkJpNUd3PT0iLCJ2YWx1ZSI6IlczWGczXC9hXC8wMzZCalhVUklSZDM1Y01USWFhOHpMXC9Uc2Vwd3FiS0VQMVJPRVpkejM5aHZ5UVRWRVFWNVNIaDQiLCJtYWMiOiI2ODE1OWIyNjZiZjc0MDJlZTRkYTlhNDIwYTBjZGFhOWVjZjYwMzUyNjJiNGE1N2MwM2VjMzE0ODAyNzQ5YzYzIn0%3D; expires=Sun, 22-Jun-2025 01:32:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkphTzlDek5uZjZJMnNxK1wvSkJpNUd3PT0iLCJ2YWx1ZSI6IlczWGczXC9hXC8wMzZCalhVUklSZDM1Y01USWFhOHpMXC9Uc2Vwd3FiS0VQMVJPRVpkejM5aHZ5UVRWRVFWNVNIaDQiL ▶"
  ]
]

session_attributes

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