Kepler : Dealerships

Test Dealership Store #123 Quick Lane: Yes

Ring All Service 1:	Ring All Service 2:	Towing (general):
Roadside Assistance: ()	Address: my address 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:
Accessories:	Body Shop:	Recall Website: Visit Website
Email:	Complaint/Compliment Email:
Towing (Opt):

Website: http://yahoo.com

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:

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
  time1745944510
  countdown10
====
Request
+
Request

Cake Params
- plugin(null)
- controllerdealerships
- actionservice
- named(empty)
- pass(array)
  061
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` = 61	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` = 61 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` = 61 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` = 61 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` = 61 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` = 61 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` = 61 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` = 61 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` = 61 LIMIT 1	1	1

Query Explain:

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

====

Timer

Memory

Peak Memory Use 8.63 MB

Message	Memory use
Component initialization	3.35 MB
Controller action start	3.66 MB
Controller render start	5.60 MB
View render complete	7.19 MB

Timers

Total Request Time: 78 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	27.94
Event: Controller.initialize	0.05
Event: Controller.startup	0.60
Controller action	20.33
Event: Controller.beforeRender	5.72
» Processing toolbar data	5.60
Rendering View	2.25
» Event: View.beforeRender	0.04
» Rendering APP/View/Dealerships/service.ctp	0.60
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.78
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- dealership(array)
  Dealership(array)
  id61
  nameTest Dealership
  store_number123
  ring_all_sales_new1111111121
  ring_all_sales_used
  ring_all_service_1
  ring_all_service_2
  ring_all_service_3
  ring_all_service_1_opt
  ring_all_service_2_opt
  ring_all_service_3_opt
  sales_operator
  sales_operator_opt
  sales_operator2
  sales_operator_opt2
  showroomhttp://google.com
  parts_retail
  parts_wholesale
  towing
  towing_opt
  roadside
  roadside_opt
  roadside2
  roadside_opt2
  roadside3
  roadside_opt3
  body_shop
  body_shop_opt
  service_email
  complaint_compliment
  accessories
  addressmy address
  google_mapshttp://maps.google.com
  return_call_sales
  return_call_service
  return_call_service_2
  return_call_service_3
  return_call_service_opt
  return_call_service_2_opt
  return_call_service_3_opt
  websitehttp://yahoo.com
  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
  notes
- 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/61
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/dealerships/service/61
Remote Port	38399
Server Admin	root@localhost
Document Root	/home/hallauto.script1.com/public_html
Remote Addr	3.15.238.90
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 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/61
Script Url	/dealerships/service/61
Redirect Status	200
Redirect Script Uri	http://hallauto.script1.com/dealerships/service/61
Redirect Script Url	/dealerships/service/61
Redirect Redirect Status	200
Redirect Redirect Script Uri	http://hallauto.script1.com/dealerships/service/61
Redirect Redirect Script Url	/dealerships/service/61
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1745930110.0226
Request Time	1745930110

====

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 Dealership 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 Dealership Store #123 Quick Lane: Yes

Total Time: 0 ms
Total Queries: 9 queries