AV Costar Sales Map

Messages Timeline Exceptions Views12 Route Queries3 Models20 Mails Gate Session Request

7.4.33114ms7MBGET sales-map

Booting (65.26ms)
Application (48.54ms)
1 x Booting (57.27%)
65.26ms
1 x Application (42.6%)
48.54ms

12 templates were rendered

themes.avc1.salesmap (resources/views/themes/avc1/salesmap.blade.php)3blade
Params
0
iternational_reps
1
regions_id
2
all_regions
themes.avc1.partials.salesform (resources/views/themes/avc1/partials/salesform.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
iternational_reps
6
regions_id
7
all_regions
8
__currentLoopData
9
region
10
loop
11
title
12
rep
themes.avc1.layout.master (resources/views/themes/avc1/layout/master.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
iternational_reps
6
regions_id
7
all_regions
8
__currentLoopData
9
region
10
loop
11
title
12
rep
themes.avc1.partials.header (resources/views/themes/avc1/partials/header.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
iternational_reps
6
regions_id
7
all_regions
8
__currentLoopData
9
region
10
loop
11
title
12
rep
menuheader (resources/views/menuheader.blade.php)2blade
Params
0
items
1
options
themes.avc1.partials.footer (resources/views/themes/avc1/partials/footer.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
iternational_reps
6
regions_id
7
all_regions
8
__currentLoopData
9
region
10
loop
11
title
12
rep
menufooter (resources/views/menufooter.blade.php)2blade
Params
0
items
1
options
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
items
6
options
7
__currentLoopData
8
item
9
loop
10
originalItem
11
isActive
12
styles
13
icon
14
alerts
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
items
6
options
7
__currentLoopData
8
item
9
loop
10
originalItem
11
isActive
12
styles
13
icon
14
alerts
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
items
6
options
7
__currentLoopData
8
item
9
loop
10
originalItem
11
isActive
12
styles
13
icon
14
alerts
voyager::menu.default (vendor/tcg/voyager/resources/views/menu/default.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
items
6
options
7
__currentLoopData
8
item
9
loop
10
originalItem
11
isActive
12
styles
13
icon
14
alerts
themes.avc1.partials.rocket-menu (resources/views/themes/avc1/partials/rocket-menu.blade.php)13blade
Params
0
obLevel
1
__env
2
app
3
smallsliders
4
errors
5
iternational_reps
6
regions_id
7
all_regions
8
__currentLoopData
9
region
10
loop
11
title
12
rep

Params
0	`iternational_reps`
1	`regions_id`
2	`all_regions`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`iternational_reps`
6	`regions_id`
7	`all_regions`
8	`__currentLoopData`
9	`region`
10	`loop`
11	`title`
12	`rep`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`iternational_reps`
6	`regions_id`
7	`all_regions`
8	`__currentLoopData`
9	`region`
10	`loop`
11	`title`
12	`rep`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`iternational_reps`
6	`regions_id`
7	`all_regions`
8	`__currentLoopData`
9	`region`
10	`loop`
11	`title`
12	`rep`

Params
0	`items`
1	`options`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`iternational_reps`
6	`regions_id`
7	`all_regions`
8	`__currentLoopData`
9	`region`
10	`loop`
11	`title`
12	`rep`

Params
0	`items`
1	`options`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`items`
6	`options`
7	`__currentLoopData`
8	`item`
9	`loop`
10	`originalItem`
11	`isActive`
12	`styles`
13	`icon`
14	`alerts`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`items`
6	`options`
7	`__currentLoopData`
8	`item`
9	`loop`
10	`originalItem`
11	`isActive`
12	`styles`
13	`icon`
14	`alerts`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`items`
6	`options`
7	`__currentLoopData`
8	`item`
9	`loop`
10	`originalItem`
11	`isActive`
12	`styles`
13	`icon`
14	`alerts`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`items`
6	`options`
7	`__currentLoopData`
8	`item`
9	`loop`
10	`originalItem`
11	`isActive`
12	`styles`
13	`icon`
14	`alerts`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`smallsliders`
4	`errors`
5	`iternational_reps`
6	`regions_id`
7	`all_regions`
8	`__currentLoopData`
9	`region`
10	`loop`
11	`title`
12	`rep`

uri: GET sales-map
middleware: web
controller: App\Http\Controllers\ContactController@map
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/ContactController.php:22-56

3 statements were executed9.51ms

select `representatives`.`id`, `reptypes`.`order`, `reptypes`.`name` as `rep_name`, `representatives`.`id`, `representatives`.`name`, `representatives`.`last_name`, `representatives`.`rep_type`, `representatives`.`territory`, `representatives`.`company`, `representatives`.`phone`, `representatives`.`email`, `representatives`.`website`, group_concat(regions.title) as regions, group_concat(regions.id) as regions_id from `representatives` left join `representative_region` on `representative_region`.`representative_id` = `representatives`.`id` left join `regions` on `representative_region`.`region_id` = `regions`.`id` left join `reptypes` on `representatives`.`rep_type` = `reptypes`.`id` where `status` = 'International' group by `representatives`.`id` order by `reptypes`.`order` asc

5ms/app/Http/Controllers/ContactController.php:30avc_staging_db

Metadata
Bindings	0. International
Backtrace	12. /app/Http/Controllers/ContactController.php:30 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681

select * from `regions`

2.15ms/app/Http/Controllers/ContactController.php:32avc_staging_db

Metadata
Backtrace	12. /app/Http/Controllers/ContactController.php:32 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:681

select * from `settings` order by `order` asc

2.36ms/vendor/tcg/voyager/src/Voyager.php:238avc_staging_db

Metadata
Backtrace	14. /vendor/tcg/voyager/src/Voyager.php:238 15. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 16. /vendor/tcg/voyager/src/Helpers/helpers.php:6 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 20. /vendor/laravel/framework/src/Illuminate/View/View.php:143

TCG\Voyager\Models\Setting: 20

_token: xtKSkPsfbBZ1ClrLHvkeFj0ypZZ8Kau0O73CkBqE
_previous: array:1 [ "url" => "https://avcstaging.arecontvisioncostar.com/sales-map" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/sales-map

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:24 [▶
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.149.29.120"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "cf-ray" => array:1 [▶
    0 => "931648d9af21e990-SJC"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.149.29.120, 172.69.22.71"
  ]
  "x-server-addr" => array:1 [▶
    0 => "159.65.79.202"
  ]
  "host" => array:1 [▶
    0 => "avcstaging.arecontvisioncostar.com"
  ]
]

request_server

  0 of 0   
array:55 [▶
  "USER" => "avcstaging"
  "HOME" => "/home/avcstaging"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/sales-map"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/sales-map"
  "REMOTE_PORT" => "46066"
  "SCRIPT_FILENAME" => "/home/avcstaging/webapps/app-avcstaging/public/index.php"
  "SERVER_ADMIN" => "you@example.com"
  "CONTEXT_DOCUMENT_ROOT" => "/home/avcstaging/webapps/app-avcstaging/public/"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "http"
  "DOCUMENT_ROOT" => "/home/avcstaging/webapps/app-avcstaging/public/"
  "REMOTE_ADDR" => "172.69.22.71"
  "SERVER_PORT" => "80"
  "SERVER_ADDR" => "127.0.0.1"
  "SERVER_NAME" => "avcstaging.arecontvisioncostar.com"
  "SERVER_SOFTWARE" => "Apache/2.4.62 (Unix) OpenSSL/1.0.2g"
  "SERVER_SIGNATURE" => ""
  "LD_LIBRARY_PATH" => "/RunCloud/Packages/apache2-rc/lib"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_CF_CONNECTING_IP" => "3.149.29.120"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_CF_RAY" => "931648d9af21e990-SJC"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_CONNECTION" => "close"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "3.149.29.120, 172.69.22.71"
  "HTTP_X_SERVER_ADDR" => "159.65.79.202"
  "HTTP_HOST" => "avcstaging.arecontvisioncostar.com"
  "HTTPS" => "on"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_HTTPS" => "on"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744833791.0623
  "REQUEST_TIME" => 1744833791
]

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 => "Wed, 16 Apr 2025 20:03:11 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => -1
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVtYjhVbGlYMml3YzdKcWxPUXhWMFE9PSIsInZhbHVlIjoiZXUxRXVhaUF1bEVaSXN1Ym1RVVpVWDVTNlJiQ0MxeUREb3ZjcDY4VlwvNkk2cDFPRFEyY2xXVkRBbVFGNHNSRzNBWnFGdWNBR2N3a2hFMm1xd20rRElTWjdoZFRxb3NVZUN0dXYxQzBidHNVcUpUSXhqSVBwS1JTcDRPaTRuMEw1IiwibWFjIjoiOGUwYjI1MTdiYTBkYTFlZjBkZDMxYTkyMDNiN2QxN2MzNGVlOTkzMWY3MTk5ZGY0MDg2YmE0YWRlOTliNzI0YSJ9; expires=Wed, 16-Apr-2025 22:03:11 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVtYjhVbGlYMml3YzdKcWxPUXhWMFE9PSIsInZhbHVlIjoiZXUxRXVhaUF1bEVaSXN1Ym1RVVpVWDVTNlJiQ0MxeUREb3ZjcDY4VlwvNkk2cDFPRFEyY2xXVkRBbVFGNHNSRzNBWnFGd ▶"
    1 => "avcostar_session=eyJpdiI6IlU2ZHczNGRRRnhIaDhGb2ljVjYxTmc9PSIsInZhbHVlIjoiSnlJRlZcLzNSN3JHbVFTdFhMbFl0V282RG5mOW11TWptOFFURFkzUFVXK0ZiaFwvWHphTTZ5WFdTTnJnTWJnUkEyNXdFMDJ0ejg1K0t0Tkx1bFlZckZ5WWZmaGQ4c2RSUUdodTAyZm9zaGlYZzdDMWU0azNROXRpd2ZZcnpaYkFKdCIsIm1hYyI6IjYwY2IwMGU2YmMwMmRjMGI3ZDc5MTg0OGU1NTRiM2M3OThkOWYyMGM3YjgwZTk3MDhjMzg3NDk0M2Q5NTFjM2QifQ%3D%3D; expires=Wed, 16-Apr-2025 22:03:11 GMT; Max-Age=7200; path=/; httponly ◀avcostar_session=eyJpdiI6IlU2ZHczNGRRRnhIaDhGb2ljVjYxTmc9PSIsInZhbHVlIjoiSnlJRlZcLzNSN3JHbVFTdFhMbFl0V282RG5mOW11TWptOFFURFkzUFVXK0ZiaFwvWHphTTZ5WFdTTnJnTWJnUkE ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVtYjhVbGlYMml3YzdKcWxPUXhWMFE9PSIsInZhbHVlIjoiZXUxRXVhaUF1bEVaSXN1Ym1RVVpVWDVTNlJiQ0MxeUREb3ZjcDY4VlwvNkk2cDFPRFEyY2xXVkRBbVFGNHNSRzNBWnFGdWNBR2N3a2hFMm1xd20rRElTWjdoZFRxb3NVZUN0dXYxQzBidHNVcUpUSXhqSVBwS1JTcDRPaTRuMEw1IiwibWFjIjoiOGUwYjI1MTdiYTBkYTFlZjBkZDMxYTkyMDNiN2QxN2MzNGVlOTkzMWY3MTk5ZGY0MDg2YmE0YWRlOTliNzI0YSJ9; expires=Wed, 16-Apr-2025 22:03:11 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVtYjhVbGlYMml3YzdKcWxPUXhWMFE9PSIsInZhbHVlIjoiZXUxRXVhaUF1bEVaSXN1Ym1RVVpVWDVTNlJiQ0MxeUREb3ZjcDY4VlwvNkk2cDFPRFEyY2xXVkRBbVFGNHNSRzNBWnFGd ▶"
    1 => "avcostar_session=eyJpdiI6IlU2ZHczNGRRRnhIaDhGb2ljVjYxTmc9PSIsInZhbHVlIjoiSnlJRlZcLzNSN3JHbVFTdFhMbFl0V282RG5mOW11TWptOFFURFkzUFVXK0ZiaFwvWHphTTZ5WFdTTnJnTWJnUkEyNXdFMDJ0ejg1K0t0Tkx1bFlZckZ5WWZmaGQ4c2RSUUdodTAyZm9zaGlYZzdDMWU0azNROXRpd2ZZcnpaYkFKdCIsIm1hYyI6IjYwY2IwMGU2YmMwMmRjMGI3ZDc5MTg0OGU1NTRiM2M3OThkOWYyMGM3YjgwZTk3MDhjMzg3NDk0M2Q5NTFjM2QifQ%3D%3D; expires=Wed, 16-Apr-2025 22:03:11 GMT; path=/; httponly ◀avcostar_session=eyJpdiI6IlU2ZHczNGRRRnhIaDhGb2ljVjYxTmc9PSIsInZhbHVlIjoiSnlJRlZcLzNSN3JHbVFTdFhMbFl0V282RG5mOW11TWptOFFURFkzUFVXK0ZiaFwvWHphTTZ5WFdTTnJnTWJnUkE ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "xtKSkPsfbBZ1ClrLHvkeFj0ypZZ8Kau0O73CkBqE"
  "_previous" => array:1 [▶
    "url" => "https://avcstaging.arecontvisioncostar.com/sales-map"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Select State or Province

Dynamic Search

Middle East & Asia-Pacific

Khaled Shehata

Steve Issa

Jamyson Haug

Europe

Khaled Shehata

Lorena Lemus

Tristram Borgmann

Latin America

Ivan Martinez

Lorena Lemus

John Bujarski

What's Next?

1 x Booting (57.27%)	65.26ms
1 x Application (42.6%)	48.54ms