JAVIS

Messages1 Timeline Exceptions Views5 Route Queries2 Models2 Mails Auth Gate Session Request

8.2.2790.69ms3MBGET serviceareas

warninglog[08:33:12] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...

Booting (60.48ms)
Application (30.19ms)
1 x Booting (66.69%)
60.48ms
1 x Application (33.29%)
30.19ms

5 templates were rendered

webfront.serviceareas (resources/views/webfront/serviceareas.blade.php)5blade
Params
0
data
1
p
2
serv
3
main_menu
4
sub_menu
admin.layouts.web_footer (resources/views/admin/layouts/web_footer.blade.php)14blade
Params
0
__env
1
app
2
navs
3
side
4
side_txt
5
errors
6
data
7
p
8
serv
9
main_menu
10
sub_menu
11
itemsChunks
12
itemsChunk
13
item
admin.layouts.web_common_scripts (resources/views/admin/layouts/web_common_scripts.blade.php)14blade
Params
0
__env
1
app
2
navs
3
side
4
side_txt
5
errors
6
data
7
p
8
serv
9
main_menu
10
sub_menu
11
itemsChunks
12
itemsChunk
13
item
admin.layouts.web_header (resources/views/admin/layouts/web_header.blade.php)14blade
Params
0
__env
1
app
2
navs
3
side
4
side_txt
5
errors
6
data
7
p
8
serv
9
main_menu
10
sub_menu
11
itemsChunks
12
itemsChunk
13
item
admin.layouts.web_common_styles (resources/views/admin/layouts/web_common_styles.blade.php)14blade
Params
0
__env
1
app
2
navs
3
side
4
side_txt
5
errors
6
data
7
p
8
serv
9
main_menu
10
sub_menu
11
itemsChunks
12
itemsChunk
13
item

Params
0	`data`
1	`p`
2	`serv`
3	`main_menu`
4	`sub_menu`

Params
0	`__env`
1	`app`
2	`navs`
3	`side`
4	`side_txt`
5	`errors`
6	`data`
7	`p`
8	`serv`
9	`main_menu`
10	`sub_menu`
11	`itemsChunks`
12	`itemsChunk`
13	`item`

Params
0	`__env`
1	`app`
2	`navs`
3	`side`
4	`side_txt`
5	`errors`
6	`data`
7	`p`
8	`serv`
9	`main_menu`
10	`sub_menu`
11	`itemsChunks`
12	`itemsChunk`
13	`item`

Params
0	`__env`
1	`app`
2	`navs`
3	`side`
4	`side_txt`
5	`errors`
6	`data`
7	`p`
8	`serv`
9	`main_menu`
10	`sub_menu`
11	`itemsChunks`
12	`itemsChunk`
13	`item`

Params
0	`__env`
1	`app`
2	`navs`
3	`side`
4	`side_txt`
5	`errors`
6	`data`
7	`p`
8	`serv`
9	`main_menu`
10	`sub_menu`
11	`itemsChunks`
12	`itemsChunk`
13	`item`

uri: GET serviceareas
middleware: web
controller: App\Http\Controllers\Web\FrontPageController@serviceareaspage
namespace: App\Http\Controllers\Web
prefix
where
as: serviceareas
file: app/Http/Controllers/Web/FrontPageController.php:217-226

2 statements were executed1.99ms

select * from `landingpagecms` limit 11.51ms/app/Http/Controllers/Web/FrontPageController.php:219javisapp

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 `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	18. /app/Http/Controllers/Web/FrontPageController.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

- EXPLAIN # 1: `landingpagecms` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table landingpagecms
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 1
filtered 100
Extra null

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

select * from `settings` where `name` = 'app_name' limit 1480μs/app/Helpers/helpers.php:1282javisapp

Metadata
Bindings	0. app_name
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/Helpers/helpers.php:1282 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 21. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

- EXPLAIN # 1: `settings` (SIMPLE)1261
Metadata
id 1
select_type SIMPLE
table settings
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 126
filtered 10
Extra Using where

Metadata
id	1
select_type	SIMPLE
table	settings
partitions	null
type	ALL
possible_keys	null
key	null
key_len	null
ref	null
rows	126
filtered	10
Extra	Using where

App\Models\Setting: 1
App\Models\Cms\FrontPage: 1

web: null
api: null
sanctum: null

_token: gexdJWmRZUGClCYskdFfd1zxwkFNNLTYLqdsVvb0
_previous: array:1 [ "url" => "https://javisapp.com/serviceareas" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/serviceareas

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:19 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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-forwarded-for" => array:1 [▶
    0 => "18.220.136.182"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.220.136.182"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "javisapp.com"
  ]
  "host" => array:1 [▶
    0 => "javisapp.com"
  ]
]

request_server

  0 of 0   
array:58 [▼
  "USER" => "javisapp"
  "HOME" => "/home/javisapp"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "close"
  "HTTP_X_FORWARDED_FOR" => "18.220.136.182"
  "HTTP_X_REAL_IP" => "18.220.136.182"
  "HTTP_X_FORWARDED_HOST" => "javisapp.com"
  "PHP_VALUE" => """
    \n
    error_log=/home/javisapp/logs/php/error.log;\n
    memory_limit=512M;\n
    max_execution_time=60;\n
    max_input_time=60;\n
    max_input_vars=10000;\n
    post_max_size=64M;\n
    upload_max_filesize=64M;\n
    date.timezone=UTC;\n
    display_errors=off;
    """
  "HTTPS" => "on"
  "MGT" => "1"
  "GEOIP_LONGITUDE" => "-71.1028"
  "GEOIP_LATITUDE" => "42.3646"
  "GEOIP_CITY_CONTINENT_CODE" => "NA"
  "GEOIP_POSTAL_CODE" => "02139"
  "GEOIP_CITY" => "Cambridge"
  "GEOIP_REGION" => "MA"
  "GEOIP_CITY_COUNTRY_NAME" => "United States"
  "GEOIP_CITY_COUNTRY_CODE3" => "USA"
  "GEOIP_CITY_COUNTRY_CODE" => "US"
  "GEOIP_COUNTRY_NAME" => "United States"
  "GEOIP_COUNTRY_CODE3" => "USA"
  "GEOIP_COUNTRY_CODE" => "US"
  "REDIRECT_STATUS" => "200"
  "HTTP_HOST" => "javisapp.com"
  "SERVER_NAME" => "javisapp.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "127.0.0.1"
  "REMOTE_PORT" => ""
  "REMOTE_ADDR" => "18.220.136.182"
  "SERVER_SOFTWARE" => "nginx/1.26.3"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "DOCUMENT_ROOT" => "/home/javisapp/htdocs/javisapp.com/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/serviceareas"
  "SCRIPT_NAME" => "/index.php"
  "SCRIPT_FILENAME" => "/home/javisapp/htdocs/javisapp.com/public/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746520392.5423
  "REQUEST_TIME" => 1746520392
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 08:33:12 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => -1
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjByYk5MWFlJTU04WGIzYnRwU2cwbHc9PSIsInZhbHVlIjoiZDEyUFhoTmdsQ2VUMW4yVDk5UTZtZnFwWUhhcGVDbDdJNXZuVUMzTGJtU2ZOczZwOTNzVlIxOVdMbUNUTnBKeldhVHppZkE2NGMzckhpN0tZVHpFZ01lTStuTzMreDlMVERHN0J0MjJ5K3JZdXU3MlRSczVOcmdVelM0ek5iTi8iLCJtYWMiOiJkNTlkYmY0MmNjOTgyMjIxY2RkYWRkZWU4MDBiYjUwYjlkYWMwZDM5YTdmMGVmNGU0NTNlZDBiOGEyNTRjNWVjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 10:33:12 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjByYk5MWFlJTU04WGIzYnRwU2cwbHc9PSIsInZhbHVlIjoiZDEyUFhoTmdsQ2VUMW4yVDk5UTZtZnFwWUhhcGVDbDdJNXZuVUMzTGJtU2ZOczZwOTNzVlIxOVdMbUNUTnBKeldhVHppZ ▶"
    1 => "tagxi_session=eyJpdiI6Ijh5Qy9tT00rd1FlOXphYWRQOUJXZUE9PSIsInZhbHVlIjoiY21ISnR2UzM3Mk5wZ3g3dURKV1czcVgzRTVzTjlhVUJCbVp1ZU14N2tPRjRoSEtwdnJKbFgvdkZKWjFLMys0TGE5RHFzOWM3cFNYTUw5ZWRoNnF4WmN6a1dXT3cwMFlrRkJQN0pBMEtkSkhGaStsOVN1eHNucERQY2h4R1RBTzYiLCJtYWMiOiIwN2Q4YjA4ZDNiZGI5OTdlZDI0NzhhMDkzMzFhNDI5YmNkYjJmOTg3MTQwMjc3NmFkMDZmZDc5NDA2ZDRlZjlmIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 10:33:12 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀tagxi_session=eyJpdiI6Ijh5Qy9tT00rd1FlOXphYWRQOUJXZUE9PSIsInZhbHVlIjoiY21ISnR2UzM3Mk5wZ3g3dURKV1czcVgzRTVzTjlhVUJCbVp1ZU14N2tPRjRoSEtwdnJKbFgvdkZKWjFLMys0TGE5RH ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjByYk5MWFlJTU04WGIzYnRwU2cwbHc9PSIsInZhbHVlIjoiZDEyUFhoTmdsQ2VUMW4yVDk5UTZtZnFwWUhhcGVDbDdJNXZuVUMzTGJtU2ZOczZwOTNzVlIxOVdMbUNUTnBKeldhVHppZkE2NGMzckhpN0tZVHpFZ01lTStuTzMreDlMVERHN0J0MjJ5K3JZdXU3MlRSczVOcmdVelM0ek5iTi8iLCJtYWMiOiJkNTlkYmY0MmNjOTgyMjIxY2RkYWRkZWU4MDBiYjUwYjlkYWMwZDM5YTdmMGVmNGU0NTNlZDBiOGEyNTRjNWVjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 10:33:12 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjByYk5MWFlJTU04WGIzYnRwU2cwbHc9PSIsInZhbHVlIjoiZDEyUFhoTmdsQ2VUMW4yVDk5UTZtZnFwWUhhcGVDbDdJNXZuVUMzTGJtU2ZOczZwOTNzVlIxOVdMbUNUTnBKeldhVHppZ ▶"
    1 => "tagxi_session=eyJpdiI6Ijh5Qy9tT00rd1FlOXphYWRQOUJXZUE9PSIsInZhbHVlIjoiY21ISnR2UzM3Mk5wZ3g3dURKV1czcVgzRTVzTjlhVUJCbVp1ZU14N2tPRjRoSEtwdnJKbFgvdkZKWjFLMys0TGE5RHFzOWM3cFNYTUw5ZWRoNnF4WmN6a1dXT3cwMFlrRkJQN0pBMEtkSkhGaStsOVN1eHNucERQY2h4R1RBTzYiLCJtYWMiOiIwN2Q4YjA4ZDNiZGI5OTdlZDI0NzhhMDkzMzFhNDI5YmNkYjJmOTg3MTQwMjc3NmFkMDZmZDc5NDA2ZDRlZjlmIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 10:33:12 GMT; path=/; httponly ◀tagxi_session=eyJpdiI6Ijh5Qy9tT00rd1FlOXphYWRQOUJXZUE9PSIsInZhbHVlIjoiY21ISnR2UzM3Mk5wZ3g3dURKV1czcVgzRTVzTjlhVUJCbVp1ZU14N2tPRjRoSEtwdnJKbFgvdkZKWjFLMys0TGE5RH ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "gexdJWmRZUGClCYskdFfd1zxwkFNNLTYLqdsVvb0"
  "_previous" => array:1 [▶
    "url" => "https://javisapp.com/serviceareas"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Booting (66.69%)	60.48ms
1 x Application (33.29%)	30.19ms

Our Service Locations