Kepler : Dealerships

Hall Mazda Virginia Beach Store #57 Quick Lane: No

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.

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

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.

List All Dealerships

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	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `pdf`.`dealerships` AS `Dealership` WHERE `Dealership`.`id` = 12	1	1	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	0

Message	Memory use
Component initialization	3.36 MB
Controller action start	3.67 MB
Controller render start	5.51 MB
View render complete	7.09 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	24.76
Event: Controller.initialize	0.05
Event: Controller.startup	0.41
Controller action	13.19
Event: Controller.beforeRender	5.92
» Processing toolbar data	5.82
Rendering View	2.12
» Event: View.beforeRender	0.04
» Rendering APP/View/Dealerships/sales.ctp	0.49
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.78
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

default

Total Time: 0 ms
Total Queries: 2 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/sales/12
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/dealerships/sales/12
Remote Port	41159
Server Admin	root@localhost
Document Root	/home/hallauto.script1.com/public_html
Remote Addr	18.218.196.220
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=968tob6ue0varulcrvps0agk80
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/sales/12
Script Url	/dealerships/sales/12
Redirect Status	200
Redirect Script Uri	http://hallauto.script1.com/dealerships/sales/12
Redirect Script Url	/dealerships/sales/12
Redirect Redirect Status	200
Redirect Redirect Script Uri	http://hallauto.script1.com/dealerships/sales/12
Redirect Redirect Script Url	/dealerships/sales/12
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1745931362.4229
Request Time	1745931362

Hall Mazda Virginia Beach Store #57Quick Lane: No

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 0 ms Total Queries: 2 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: 2 queries