Kepler : Dealerships

Hall Mazda Virginia Beach Store #57 Quick Lane: No

Ring All Service 1: 57199	Ring All Service 2:	Towing (general): 7578971796
Roadside Assistance: 8008661998 3 years OR 36K miles (Mazda Roadside)	Address: 4372 Holland Road Virginia Beach, VA 23452 Map it	Service Hours: Monday: 7:30 AM - 6:00 PM Tuesday: 7:30 AM - 6:00 PM Wednesday: 7:30 AM - 6:00 PM Thursday: 7:30 AM - 6:00 PM Friday: 7:30 AM - 6:00 PM Saturday: 8:00 AM - 5:00 PM Sunday: Closed - Closed
Parts (Retail): 57299	Parts (Wholesale):	Return Call Service: 7576443761
Accessories:	Body Shop: Open New Window	Recall Website: Visit Website
Email: 57199@mileone.com	Complaint/Compliment Email:
Towing (Opt): A&W Towing

Website: https://www.hallmazda.com/promotions/service/index.htm

General Manager: Richard Barrera
General Manager 2: None Available
Service Manager: Kamal Maasry (EXT:57101)
Service Manager 2: Steven Dotson (EXT 57101)
In-Store Service Director: None Available
Service Director: None Available

Directions:
From I-264:
1. Take the Independence Boulevard exit # 17A (towards Princess Anne Rd.)
2. Get all the way over into the left lane and go through two lights
3. Hall Mazda VB is located immediately on the left across from Wawa, in an orange and green building.

Notes: *Sales Department Open last 2 Sundays of the Month*

SERVICE ASSISTANT: MEGAN

Shuttle Hours:Monday thru Friday 8am-4pm Operates within a 10 mile radius

Pickup & Delivery - No Cost Pick Up & Delivery appointments available Mon-Fri within a 25-mile radius of the dealership. Please note this option will require us to communicate with you directly to coordinate the pickup and other details to ensure a smooth experience.

Advisors

Name	Direct Dial	Ring All	Notes
JoLynn Dye	EXT:57123
Joel Kudsk	EXT:57153

List All Dealerships (Agent)

List All Dealerships (Admin)

Login	Return to Dashboard (Admin Login Required)	Add A New User	Logout	Add Employee
List All Employees	Add Employee	List All Dealerships (Agent)	Add a Dealership	List All Dealerships (Admin)

Query	Affected	Num. rows
SELECT COUNT(*) AS `count` FROM `pdf`.`dealerships` AS `Dealership` WHERE `Dealership`.`id` = 12	1	1
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` LIKE '%Advisor%'	2	2
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` = 'General Manager'	1	1
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` = 'General Manager 2'	0	0
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` = 'Service Manager'	1	1
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` = 'Service Manager 2'	1	1
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` = 'In-Store Service Director'	0	0
SELECT `Employee`.`id`, `Employee`.`dealership_id`, `Employee`.`name`, `Employee`.`main`, `Employee`.`direct`, `Employee`.`cell`, `Employee`.`ring_all`, `Employee`.`title`, `Employee`.`specialty`, `Employee`.`email`, `Employee`.`notes` FROM `pdf`.`employees` AS `Employee` WHERE `dealership_id` = 12 AND `title` = 'Service Director'	0	0
SELECT `Dealership`.`id`, `Dealership`.`name`, `Dealership`.`store_number`, `Dealership`.`ring_all_sales_new`, `Dealership`.`ring_all_sales_used`, `Dealership`.`ring_all_service_1`, `Dealership`.`ring_all_service_2`, `Dealership`.`ring_all_service_3`, `Dealership`.`ring_all_service_1_opt`, `Dealership`.`ring_all_service_2_opt`, `Dealership`.`ring_all_service_3_opt`, `Dealership`.`sales_operator`, `Dealership`.`sales_operator_opt`, `Dealership`.`sales_operator2`, `Dealership`.`sales_operator_opt2`, `Dealership`.`showroom`, `Dealership`.`parts_retail`, `Dealership`.`parts_wholesale`, `Dealership`.`towing`, `Dealership`.`towing_opt`, `Dealership`.`roadside`, `Dealership`.`roadside_opt`, `Dealership`.`roadside2`, `Dealership`.`roadside_opt2`, `Dealership`.`roadside3`, `Dealership`.`roadside_opt3`, `Dealership`.`body_shop`, `Dealership`.`body_shop_opt`, `Dealership`.`service_email`, `Dealership`.`complaint_compliment`, `Dealership`.`accessories`, `Dealership`.`address`, `Dealership`.`google_maps`, `Dealership`.`return_call_sales`, `Dealership`.`return_call_service`, `Dealership`.`return_call_service_2`, `Dealership`.`return_call_service_3`, `Dealership`.`return_call_service_opt`, `Dealership`.`return_call_service_2_opt`, `Dealership`.`return_call_service_3_opt`, `Dealership`.`website`, `Dealership`.`directions`, `Dealership`.`quick_lane`, `Dealership`.`mon_from_sc`, `Dealership`.`mon_to_sc`, `Dealership`.`tues_from_sc`, `Dealership`.`tues_to_sc`, `Dealership`.`wed_from_sc`, `Dealership`.`wed_to_sc`, `Dealership`.`thurs_from_sc`, `Dealership`.`thurs_to_sc`, `Dealership`.`fri_from_sc`, `Dealership`.`fri_to_sc`, `Dealership`.`sat_from_sc`, `Dealership`.`sat_to_sc`, `Dealership`.`sun_from_sc`, `Dealership`.`sun_to_sc`, `Dealership`.`mon_from_sl`, `Dealership`.`mon_to_sl`, `Dealership`.`tues_from_sl`, `Dealership`.`tues_to_sl`, `Dealership`.`wed_from_sl`, `Dealership`.`wed_to_sl`, `Dealership`.`thurs_from_sl`, `Dealership`.`thurs_to_sl`, `Dealership`.`fri_from_sl`, `Dealership`.`fri_to_sl`, `Dealership`.`sat_from_sl`, `Dealership`.`sat_to_sl`, `Dealership`.`sun_from_sl`, `Dealership`.`sun_to_sl`, `Dealership`.`notes` FROM `pdf`.`dealerships` AS `Dealership` WHERE `Dealership`.`id` = 12 LIMIT 1	1	1

Message	Memory use
Component initialization	3.36 MB
Controller action start	3.67 MB
Controller render start	5.62 MB
View render complete	7.20 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	23.51
Event: Controller.initialize	0.05
Event: Controller.startup	0.41
Controller action	14.72
Event: Controller.beforeRender	3.77
» Processing toolbar data	3.67
Rendering View	2.44
» Event: View.beforeRender	0.04
» Rendering APP/View/Dealerships/service.ctp	0.62
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	0.82
Event: View.afterLayout	0.00

Constant	Value
APP	/home/hallauto.script1.com/public_html/app/
APP_DIR	app
APPLIBS	/home/hallauto.script1.com/public_html/app/Lib/
CACHE	/home/hallauto.script1.com/public_html/app/tmp/cache/
CAKE	/home/hallauto.script1.com/public_html/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/hallauto.script1.com/public_html/lib
CORE_PATH	/home/hallauto.script1.com/public_html/lib/
CAKE_VERSION	2.4.7
CSS	/home/hallauto.script1.com/public_html/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://hallauto.script1.com
IMAGES	/home/hallauto.script1.com/public_html/app/webroot/img/
IMAGES_URL	img/
JS	/home/hallauto.script1.com/public_html/app/webroot/js/
JS_URL	js/
LOGS	/home/hallauto.script1.com/public_html/app/tmp/logs/
ROOT	/home/hallauto.script1.com/public_html
TESTS	/home/hallauto.script1.com/public_html/app/Test/
TMP	/home/hallauto.script1.com/public_html/app/tmp/
VENDORS	/home/hallauto.script1.com/public_html/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/hallauto.script1.com/public_html/app/webroot/

Hall Mazda Virginia Beach Store #57 Quick Lane: No

Advisors

default

Total Time: 0 ms
Total Queries: 9 queries

Query Explain:

Memory

Timers

Environment Variable	Value
Php Version	5.6.40
Phprc	/home/hallauto.script1.com/fcgi-bin/../etc/php5
Script Filename	/home/hallauto.script1.com/public_html/app/webroot/index.php
Path	/sbin:/usr/sbin:/bin:/usr/bin
Pwd	/home/hallauto.script1.com/fcgi-bin
Shlvl	0
Php Fcgi Max Requests	99999
Http Connection	close
Script Name	/app/webroot/index.php
Request Uri	/dealerships/service/12
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/dealerships/service/12
Remote Port	8002
Server Admin	root@localhost
Document Root	/home/hallauto.script1.com/public_html
Remote Addr	3.142.142.113
Server Port	80
Server Addr	107.170.96.177
Server Name	hallauto.script1.com
Server Software	Apache/2.2.15
Server Signature
Http Host	hallauto.script1.com
Http Accept Encoding	gzip, br, zstd, deflate
Http Cookie	CAKEPHP=fk6m2mhoa0b43lap0b9k9k09e3
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Script Uri	http://hallauto.script1.com/dealerships/service/12
Script Url	/dealerships/service/12
Redirect Status	200
Redirect Script Uri	http://hallauto.script1.com/dealerships/service/12
Redirect Script Url	/dealerships/service/12
Redirect Redirect Status	200
Redirect Redirect Script Uri	http://hallauto.script1.com/dealerships/service/12
Redirect Redirect Script Url	/dealerships/service/12
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1745929960.7005
Request Time	1745929960

Hall Mazda Virginia Beach Store #57Quick Lane: No

Advisors

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 0 ms Total Queries: 9 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Hall Mazda Virginia Beach Store #57 Quick Lane: No

Total Time: 0 ms
Total Queries: 9 queries