Kepler : Dealerships

test Store #123 Quick Lane: Yes

Ring All Service 1: 1111111111	Ring All Service 2: 2222222222	Towing (general):
Roadside Assistance: ()	Address: test Map it	Service Hours: Monday: 12:00 AM - 12:00 AM Tuesday: 12:00 AM - 12:00 AM Wednesday: 12:00 AM - 12:00 AM Thursday: 12:00 AM - 12:00 AM Friday: 12:00 AM - 12:00 AM Saturday: 12:00 AM - 12:00 AM Sunday: 12:00 AM - 12:00 AM
Parts (Retail):	Parts (Wholesale):	Return Call Service: 4444444444
Accessories:	Body Shop:	Recall Website:
Email:	Complaint/Compliment Email:
Towing (Opt):

Website: test

General Manager: None Available
General Manager 2: None Available
Service Manager: None Available
Service Manager 2: None Available
In-Store Service Director: None Available
Service Director: None Available

Directions:
test

Notes: test

Advisors

Name	Direct Dial	Ring All	Notes
No advisors configured.

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)

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent310a60b52be367e715dd13f47afea70b
  time1745945368
  countdown10
====
Request
+
Request

Cake Params
- plugin(null)
- controllerdealerships
- actionservice
- named(empty)
- pass(array)
  047
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(empty)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 0 ms
Total Queries: 9 queries

Query	Affected	Num. rows
SELECT COUNT(*) AS `count` FROM `pdf`.`dealerships` AS `Dealership` WHERE `Dealership`.`id` = 47	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` = 47 AND `title` LIKE '%Advisor%'	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` = 47 AND `title` = 'General Manager'	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` = 47 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` = 47 AND `title` = 'Service Manager'	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` = 47 AND `title` = 'Service 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` = 47 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` = 47 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` = 47 LIMIT 1	1	1

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 8.67 MB

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

Timers

Total Request Time: 67 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	22.18
Event: Controller.initialize	0.05
Event: Controller.startup	0.40
Controller action	13.73
Event: Controller.beforeRender	5.99
» Processing toolbar data	5.88
Rendering View	2.33
» Event: View.beforeRender	0.04
» Rendering APP/View/Dealerships/service.ctp	0.58
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.81
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- dealership(array)
  Dealership(array)
  id47
  nametest
  store_number123
  ring_all_sales_new12312312344
  ring_all_sales_used
  ring_all_service_11111111111
  ring_all_service_22222222222
  ring_all_service_33333333333
  ring_all_service_1_opt(null)
  ring_all_service_2_opt(null)
  ring_all_service_3_opt(null)
  sales_operator
  sales_operator_opt(null)
  sales_operator2(null)
  sales_operator_opt2(null)
  showroom
  parts_retail
  parts_wholesale
  towing
  towing_opt
  roadside
  roadside_opt
  roadside2(null)
  roadside_opt2(null)
  roadside3(null)
  roadside_opt3(null)
  body_shop
  body_shop_opt(null)
  service_email(null)
  complaint_compliment(null)
  accessories
  addresstest
  google_mapshttp://url.com
  return_call_sales
  return_call_service4444444444
  return_call_service_25555555555
  return_call_service_36666666666
  return_call_service_opt(null)
  return_call_service_2_opt(null)
  return_call_service_3_opt(null)
  websitetest
  directionstest
  quick_laneYes
  mon_from_sc12:00 AM
  mon_to_sc12:00 AM
  tues_from_sc12:00 AM
  tues_to_sc12:00 AM
  wed_from_sc12:00 AM
  wed_to_sc12:00 AM
  thurs_from_sc12:00 AM
  thurs_to_sc12:00 AM
  fri_from_sc12:00 AM
  fri_to_sc12:00 AM
  sat_from_sc12:00 AM
  sat_to_sc12:00 AM
  sun_from_sc12:00 AM
  sun_to_sc12:00 AM
  mon_from_sl12:00 AM
  mon_to_sl12:00 AM
  tues_from_sl12:00 AM
  tues_to_sl12:00 AM
  wed_from_sl12:00 AM
  wed_to_sl12:00 AM
  thurs_from_sl12:00 AM
  thurs_to_sl12:00 AM
  fri_from_sl12:00 AM
  fri_to_sl12:00 AM
  sat_from_sl12:00 AM
  sat_to_sl12:00 AM
  sun_from_sl12:00 AM
  sun_to_sl12:00 AM
  notestest
- sdNone Available
- isdNone Available
- special5
- special4
- special3
- special2
- special1
- service_manager2None Available
- service_managerNone Available
- general_manager2None Available
- general_managerNone Available
- advisors<tr><td colspan='3'>No advisors configured.</td></tr>
- $request->data(empty)
- $this->validationErrors(array)
  Dealership(empty)
  Employee(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Time
  3Text
  4Session
  5Number
  6SimpleGraph
  7DebugTimer
  8Toolbar
  9HtmlToolbar
====

Environment

App Constants

No application environment available.

CakePHP Constants

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/

PHP Environment

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/47
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/dealerships/service/47
Remote Port	37622
Server Admin	root@localhost
Document Root	/home/hallauto.script1.com/public_html
Remote Addr	18.220.97.0
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=atsgr3hqdu9rsg2r4spk1ncti2
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/47
Script Url	/dealerships/service/47
Redirect Status	200
Redirect Script Uri	http://hallauto.script1.com/dealerships/service/47
Redirect Script Url	/dealerships/service/47
Redirect Redirect Status	200
Redirect Redirect Script Uri	http://hallauto.script1.com/dealerships/service/47
Redirect Redirect Script Url	/dealerships/service/47
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1745930968.89
Request Time	1745930968

====

Include
+
Included Files

Include Paths
- 0/home/hallauto.script1.com/public_html/lib
- 2/usr/share/pear
- 3/usr/share/php
- 4-> /home/hallauto.script1.com/public_html/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/AuthComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/DealershipsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Dealership.php
  1APP/Model/AppModel.php
  2APP/Model/Employee.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

test Store #123Quick Lane: Yes

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

test Store #123 Quick Lane: Yes

Total Time: 0 ms
Total Queries: 9 queries