Forum

info@freezylist.com

In order to maintain a friendly and collaborative environment, please adhere to the following rules:

Do not post links to external

web addresses

Maintain professional

communication

Communication should relate

to real estate

See terms & conditions

Forum List

Create New Topic

#	Topic	Views	replies	Date / Time
1	New Topis	4067	0	26 November 2019

Messages Timeline Exceptions Views7 Route Queries4 Mails Auth Gate Session Request

43.73ms2MBGET forums

Booting (16.02ms)
Application (37.24ms)

7 templates were rendered

frontend.forum.index (resources/views/frontend/forum/index.blade.php)1blade
Params
0
forums
pagination::default (resources/views/vendor/pagination/default.blade.php)2blade
Params
0
paginator
1
elements
frontend.layouts.app (resources/views/frontend/layouts/app.blade.php)10blade
Params
0
obLevel
1
__env
2
app
3
errors
4
forums
5
logged_in_user
6
__currentLoopData
7
forum
8
index
9
loop
includes.partials.logged-in-as (resources/views/includes/partials/logged-in-as.blade.php)10blade
Params
0
obLevel
1
__env
2
app
3
errors
4
forums
5
logged_in_user
6
__currentLoopData
7
forum
8
index
9
loop
frontend.includes.header (resources/views/frontend/includes/header.blade.php)10blade
Params
0
obLevel
1
__env
2
app
3
errors
4
forums
5
logged_in_user
6
__currentLoopData
7
forum
8
index
9
loop
includes.partials.messages (resources/views/includes/partials/messages.blade.php)10blade
Params
0
obLevel
1
__env
2
app
3
errors
4
forums
5
logged_in_user
6
__currentLoopData
7
forum
8
index
9
loop
frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)10blade
Params
0
obLevel
1
__env
2
app
3
errors
4
forums
5
logged_in_user
6
__currentLoopData
7
forum
8
index
9
loop

Params
0	`forums`

Params
0	`paginator`
1	`elements`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`forums`
5	`logged_in_user`
6	`__currentLoopData`
7	`forum`
8	`index`
9	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`forums`
5	`logged_in_user`
6	`__currentLoopData`
7	`forum`
8	`index`
9	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`forums`
5	`logged_in_user`
6	`__currentLoopData`
7	`forum`
8	`index`
9	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`forums`
5	`logged_in_user`
6	`__currentLoopData`
7	`forum`
8	`index`
9	`loop`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`forums`
5	`logged_in_user`
6	`__currentLoopData`
7	`forum`
8	`index`
9	`loop`

uri: GET forums
middleware: web
as: frontend.forums.index
controller: App\Http\Controllers\Frontend\ForumController@index
namespace: App\Http\Controllers\Frontend
prefix: null
where
file: app/Http/Controllers/Frontend/ForumController.php:16-21

4 statements were executed16.52ms

select count(*) as aggregate from `forums` where `forums`.`deleted_at` is null6.07ms/app/Http/Controllers/Frontend/ForumController.php:18freezylist
Metadata
Backtrace
13. /app/Http/Controllers/Frontend/ForumController.php:18
21. /app/Http/Middleware/LocaleMiddleware.php:57
66. /public/index.php:52
- EXPLAIN #1: `forums` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table forums
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 1
filtered 100
Extra Using where

Metadata
Backtrace	13. /app/Http/Controllers/Frontend/ForumController.php:18 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

Metadata
id	1
select_type	SIMPLE
table	forums
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	1
filtered	100
Extra	Using where

select * from `forums` where `forums`.`deleted_at` is null order by `created_at` desc limit 4 offset 0480μs/app/Http/Controllers/Frontend/ForumController.php:18freezylist

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	13. /app/Http/Controllers/Frontend/ForumController.php:18 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `forums` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table forums
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 1
filtered 100
Extra Using where; Using filesort
select SUM(views) as total,forum_id from `forum_views` where `forum_views`.`forum_id` in ('1') group by `forum_id`6.82ms/app/Http/Controllers/Frontend/ForumController.php:18freezylist
Metadata
Bindings
0. 1
Backtrace
19. /app/Http/Controllers/Frontend/ForumController.php:18
27. /app/Http/Middleware/LocaleMiddleware.php:57
72. /public/index.php:52
- EXPLAIN #1: `forum_views` (SIMPLE)22681
Metadata
id 1
select_type SIMPLE
table forum_views
partitions null
type ALL
possible_keys forum_id
key null
key_len null
ref null
rows 2268
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	forums
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	1
filtered	100
Extra	Using where; Using filesort

Metadata
id	1
select_type	SIMPLE
table	forum_views
partitions	null
type	ALL
possible_keys	forum_id
key	null
key_len	null
ref	null
rows	2268
filtered	100
Extra	Using where

select * from `forum_replies` where `forum_replies`.`forum_id` in ('1') and `forum_replies`.`deleted_at` is null3.15ms/app/Http/Controllers/Frontend/ForumController.php:18freezylist

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/ForumController.php:18 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `forum_replies` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table forum_replies
partitions null
type ref
possible_keys forum_replies_forum_id_foreign
key forum_replies_forum_id_foreign
key_len 4
ref const
rows 1
filtered 100
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	forum_replies
partitions	null
type	ref
possible_keys	forum_replies_forum_id_foreign
key	forum_replies_forum_id_foreign
key_len	4
ref	const
rows	1
filtered	100
Extra	Using where

web: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

_token: cX9pcjGqSZZKhfwQhlBKvmb8LzhQgzowxwewRofM
_previous: array:1 [ "url" => "https://freezylist.lusites.xyz/forums" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:17 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 =>...
request_server: array:40 [ "USER" => "freezylist" "HOME" => "/home/freezylist" "HTTP_PRIORITY" => "u=0, i" "...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /forums
session_attributes: array:3 [ "_token" => "cX9pcjGqSZZKhfwQhlBKvmb8LzhQgzowxwewRofM" "_previous" => array:1 [ "u...