Messages Timeline Exceptions Views1 Route Queries14 Models371 Livewire0 Mails Gate Session Request

Request history8.1.291.56s4MBGET discussions/{slug}

Booting (697ms)time
Application (867ms)time
1 x Application (55.42%)
867ms
1 x Booting (44.57%)
697ms

1 templates were rendered

1x web.v2.discussion.showshow.blade.php#?blade

uri: GET discussions/{slug}
middleware: web
controller: App\Http\Controllers\DiscussionController@show
namespace: App\Http\Controllers
prefix
where
as: web.discussion.show
file: app/Http/Controllers/DiscussionController.php:159-229

14 statements were executed (2 duplicates)Show only duplicates686ms

DiscussionController.php#165mydatabase3.02msselect * from `questions` where `slug` = 'diabetes-2' and `questions`.`deleted_at` is null limit 1

Bindings	0: diabetes-2
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	app/Http/Controllers/DiscussionController.php:165 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#179mydatabase770μsselect * from `questions` where `slug` = 'diabetes-2' and `questions`.`deleted_at` is null limit 1

Bindings	0: diabetes-2
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	app/Http/Controllers/DiscussionController.php:179 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#192mydatabase5ms

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, extra as `extra` from information_schema.columns where table_schema = 'mydatabase' and table_name = 'questions' order by ordinal_position asc

Backtrace

app/Http/Controllers/DiscussionController.php:192
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#192mydatabase5.93msupdate `questions` set `views` = 235, `questions`.`updated_at` = '2025-05-18 07:14:58' where `id` = 32

Bindings	0: 235 1: 2025-05-18 07:14:58 2: 32
Backtrace	app/Http/Controllers/DiscussionController.php:192 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#200mydatabase1.44ms

select * from `answers` where `answers`.`question_id` = 32 and `answers`.`question_id` is not null and `answers`.`deleted_at` is null

Bindings	0: 32
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	app/Http/Controllers/DiscussionController.php:200 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#201mydatabase1.68ms

select `tags`.*, `answer_tag`.`answer_id` as `pivot_answer_id`, `answer_tag`.`tag_id` as `pivot_tag_id`, `answer_tag`.`created_at` as `pivot_created_at`, `answer_tag`.`updated_at` as `pivot_updated_at` from `tags` inner join `answer_tag` on `tags`.`id` = `answer_tag`.`tag_id` where `answer_tag`.`answer_id` = 34

Bindings	0: 34
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	app/Http/Controllers/DiscussionController.php:201 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#209mydatabase1.71msselect * from `categories` where `type` = 'healthpedia' and `parent_id` <> 0 and `categories`.`deleted_at` is null

Bindings	0: healthpedia 1: 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	app/Http/Controllers/DiscussionController.php:209 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#210mydatabase606ms

select * from `posts` where `status` = 1 and `publish_date` <= '2025-05-18 07:14:58' and `content_type` = 'article' and `posts`.`deleted_at` is null order by RAND() limit 7

Bindings	0: 1 1: 2025-05-18 07:14:58 2: article
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
Backtrace	app/Http/Controllers/DiscussionController.php:210 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#211mydatabase1.21ms

select * from `posts` where `status` = 1 and `publish_date` <= '2025-05-18 07:14:59' and `content_type` = 'article' and `posts`.`deleted_at` is null order by `id` desc limit 4

Bindings	0: 1 1: 2025-05-18 07:14:59 2: article
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	app/Http/Controllers/DiscussionController.php:211 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#214mydatabase42.03ms

select * from `posts` where `status` = 1 and `publish_date` <= '2025-05-18 07:14:59' and `content_type` = 'article' and exists (select * from `tags` inner join `post_tag` on `tags`.`id` = `post_tag`.`tag_id` where `posts`.`id` = `post_tag`.`post_id` and `tags`.`id` in (740, 15)) and `posts`.`deleted_at` is null order by RAND() limit 5

Bindings	0: 1 1: 2025-05-18 07:14:59 2: article 3: 740 4: 15
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
Backtrace	app/Http/Controllers/DiscussionController.php:214 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

DiscussionController.php#225mydatabase6.98msselect * from `questions` where `status` = 'published' and `questions`.`deleted_at` is null order by `id` desc

Bindings	0: published
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	app/Http/Controllers/DiscussionController.php:225 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

show.blade.php#110mydatabase1.56msselect * from `categories` where `categories`.`id` = 19 and `categories`.`deleted_at` is null limit 1

Bindings	0: 19
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	view::web.v2.discussion.show:110 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

show.blade.php#177mydatabase7.47ms

select * from `answers` where `answers`.`question_id` = 32 and `answers`.`question_id` is not null and `answers`.`deleted_at` is null order by `id` desc limit 1

Bindings	0: 32
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	view::web.v2.discussion.show:177 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

show.blade.php#189mydatabase1.42msselect * from `users` where `doctor_id` = '6386ea1c69178456d00f41a4' limit 1

Bindings	0: 6386ea1c69178456d00f41a4
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	view::web.v2.discussion.show:189 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:22 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

App\Question: 308Question.php#?
App\Models\Admin\Category: 42Category.php#?
App\Models\Admin\Post: 16Post.php#?
App\Answer: 2Answer.php#?
App\Models\Admin\Tag: 2Tag.php#?
App\User: 1User.php#?

locale: id
_token: 7a9uxpyAJpSU60iV4dvQwOA4lQ8lpBKlisYKFtH4
discussion: diabetes-2
_previous: array:1 [ "url" => "https://ai-care-dict.atmatech.id/discussions/diabetes-2" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/discussions/diabetes-2

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:19 [▼
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.219.128.212"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.219.128.212"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-scheme" => array:1 [▶
    0 => "https"
  ]
  "host" => array:1 [▶
    0 => "ai-care-dict.atmatech.id"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 00:14:59 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVLQlNOYXRzclo0d2ZraGJGeSt5bEE9PSIsInZhbHVlIjoiMVV6TUh0SENOc3JrV2VvdjgwbHl5M01ZeGtZdkVVbnBoMi9LYkRERXZhOGd2dHZQTVM4UjFROTJjaFRTN0k1b3h3YjBOd3dtb1ZVMFFwNHJZOVh4ck5YMnJDdzFKWEdNMWJtTURuUnB6K05sUTJhbThRenFWVUNkcnpwNTZad3EiLCJtYWMiOiI3OTNmMmE5ZWNhOWM4MThmN2IyNDU2MTE2YzI2MGY2OTFmOTRlZDBkYzIwMDBlMTU0YTg0ODFhOGY0ZTY3YTc1IiwidGFnIjoiIn0%3D; expires=Sun, 18 May 2025 02:14:59 GMT; Max-Age=7200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImVLQlNOYXRzclo0d2ZraGJGeSt5bEE9PSIsInZhbHVlIjoiMVV6TUh0SENOc3JrV2VvdjgwbHl5M01ZeGtZdkVVbnBoMi9LYkRERXZhOGd2dHZQTVM4UjFROTJjaFRTN0k1b3h3YjBOd ▶"
    1 => "laravel_session=eyJpdiI6Ik9SekFucmRSWlAvSEpZMnhhSzUwaWc9PSIsInZhbHVlIjoib0hhcDJtYkpNd2JLUHplcFozWGFkNk05U0FmeHRiTlZOR2w3UzR0R3lTeEVSYjVObU1nMG16NC9nNFpzNFRYZ2F6TlhkVXVJZFUvb0hhK3g2NUo1TnJZV2NlRVN1U2ZvOVRxL1NqMGt4cUdvajRHS045amE0RU1KcGpSQVFYRS8iLCJtYWMiOiJlZDdkNTI5YWI0NWZiMWNiMmUxNTNlN2QyNWU4MjgzNTAxNzBlZDc0NDU0YjFmNzk3ZmY1ZGM1MmI1MWZkMjk2IiwidGFnIjoiIn0%3D; expires=Sun, 18 May 2025 02:14:59 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6Ik9SekFucmRSWlAvSEpZMnhhSzUwaWc9PSIsInZhbHVlIjoib0hhcDJtYkpNd2JLUHplcFozWGFkNk05U0FmeHRiTlZOR2w3UzR0R3lTeEVSYjVObU1nMG16NC9nNFpzNFRYZ2F6 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVLQlNOYXRzclo0d2ZraGJGeSt5bEE9PSIsInZhbHVlIjoiMVV6TUh0SENOc3JrV2VvdjgwbHl5M01ZeGtZdkVVbnBoMi9LYkRERXZhOGd2dHZQTVM4UjFROTJjaFRTN0k1b3h3YjBOd3dtb1ZVMFFwNHJZOVh4ck5YMnJDdzFKWEdNMWJtTURuUnB6K05sUTJhbThRenFWVUNkcnpwNTZad3EiLCJtYWMiOiI3OTNmMmE5ZWNhOWM4MThmN2IyNDU2MTE2YzI2MGY2OTFmOTRlZDBkYzIwMDBlMTU0YTg0ODFhOGY0ZTY3YTc1IiwidGFnIjoiIn0%3D; expires=Sun, 18-May-2025 02:14:59 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImVLQlNOYXRzclo0d2ZraGJGeSt5bEE9PSIsInZhbHVlIjoiMVV6TUh0SENOc3JrV2VvdjgwbHl5M01ZeGtZdkVVbnBoMi9LYkRERXZhOGd2dHZQTVM4UjFROTJjaFRTN0k1b3h3YjBOd ▶"
    1 => "laravel_session=eyJpdiI6Ik9SekFucmRSWlAvSEpZMnhhSzUwaWc9PSIsInZhbHVlIjoib0hhcDJtYkpNd2JLUHplcFozWGFkNk05U0FmeHRiTlZOR2w3UzR0R3lTeEVSYjVObU1nMG16NC9nNFpzNFRYZ2F6TlhkVXVJZFUvb0hhK3g2NUo1TnJZV2NlRVN1U2ZvOVRxL1NqMGt4cUdvajRHS045amE0RU1KcGpSQVFYRS8iLCJtYWMiOiJlZDdkNTI5YWI0NWZiMWNiMmUxNTNlN2QyNWU4MjgzNTAxNzBlZDc0NDU0YjFmNzk3ZmY1ZGM1MmI1MWZkMjk2IiwidGFnIjoiIn0%3D; expires=Sun, 18-May-2025 02:14:59 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ik9SekFucmRSWlAvSEpZMnhhSzUwaWc9PSIsInZhbHVlIjoib0hhcDJtYkpNd2JLUHplcFozWGFkNk05U0FmeHRiTlZOR2w3UzR0R3lTeEVSYjVObU1nMG16NC9nNFpzNFRYZ2F6 ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "locale" => "id"
  "_token" => "7a9uxpyAJpSU60iV4dvQwOA4lQ8lpBKlisYKFtH4"
  "discussion" => "diabetes-2"
  "_previous" => array:1 [▶
    "url" => "https://ai-care-dict.atmatech.id/discussions/diabetes-2"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-18 07:14:59	GET	/discussions/diabetes-2	1 14 371

Tanya Dokter

Pertanyaan Anda

Diabetes

1 x Application (55.42%)	867ms
1 x Booting (44.57%)	697ms