Search Music Library

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerworks
- actionsearch
- named(empty)
- pass(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerworks
  actionsearch
  plugin(null)
- template/music-library/search
====

Sql Logs

default

Total Time: 1 ms
Total Queries: 29 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS `count` FROM `lomusic_live`.`users` AS `User` WHERE 1 = 1	1	1	0
SELECT `Redirect`.`redirect` FROM `lomusic_live`.`redirects` AS `Redirect` WHERE `Redirect`.`url` LIKE 'music-library/search' LIMIT 1	0	0	0
SELECT `StringType`.`id`, `StringType`.`type` FROM `lomusic_live`.`string_types` AS `StringType` WHERE 1 = 1	3	3	1	maybe slow
SELECT `ChorusType`.`id`, `ChorusType`.`type` FROM `lomusic_live`.`chorus_types` AS `ChorusType` WHERE 1 = 1	5	5	0
SELECT `AccompanimentType`.`id`, `AccompanimentType`.`type` FROM `lomusic_live`.`accompaniment_types` AS `AccompanimentType` WHERE 1 = 1	5	5	0
SELECT `YouthConcert`.`id`, `YouthConcert`.`name` FROM `lomusic_live`.`youth_concerts` AS `YouthConcert` WHERE 1 = 1	5	5	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` IS NULL ORDER BY `Page`.`top_order` ASC	7	7	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 1 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 4 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 15 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 5 ORDER BY `Page`.`top_order` ASC	3	3	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 14 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 12 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 11 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 6 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 3 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 8 ORDER BY `Page`.`top_order` ASC	3	3	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 9 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 10 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`top_show` = '1' AND `Page`.`parent_id` = 13 ORDER BY `Page`.`top_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` IS NULL ORDER BY `Page`.`bottom_order` ASC	5	5	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 1 ORDER BY `Page`.`bottom_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 3 ORDER BY `Page`.`bottom_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 4 ORDER BY `Page`.`bottom_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 5 ORDER BY `Page`.`bottom_order` ASC	3	3	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 11 ORDER BY `Page`.`bottom_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 12 ORDER BY `Page`.`bottom_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 14 ORDER BY `Page`.`bottom_order` ASC	0	0	0
SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`parent_id`, `Page`.`route`, `Page`.`class`, `Page`.`new_window` FROM `lomusic_live`.`pages` AS `Page` WHERE `Page`.`bottom_show` = '1' AND `Page`.`parent_id` = 6 ORDER BY `Page`.`bottom_order` ASC	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 5.81 MB

Message	Memory use
Component initialization	1.58 MB
Controller action start	2.73 MB
Controller render start	3.27 MB
View render complete	4.27 MB

Timers

Total Request Time: 330 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	107.88
Event: Controller.initialize	23.51
Event: Controller.startup	0.74
Controller action	4.77
Event: Controller.beforeRender	138.89
» Processing toolbar data	123.03
Rendering View	26.30
» Event: View.beforeRender	0.02
» Rendering APP/View/Works/search.ctp	23.29
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	2.02
» » Rendering APP/View/Elements/menu.ctp	0.51
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- relationOptions(array)
  =Exactly
  >=At Least
  <=Up To
- amounts(array)
  11
  22
  33
  44
  55
- strings(array)
  1No Strings
  2Normal Strings
  3Single Strings
- chorusTypes(array)
  1Mixed Chorus
  2Female Chorus
  3Male Chorus
  4Children's Chorus
  5Double Chorus
- accompanimentTypes(array)
  1Large Orchestra
  2Medium Orchestra
  3Small Orchestra
  4String Orchestra
  5No Strings
- youthConcerts(array)
  1Stories Told With Music
  2Descriptive Music
  3Introduction to Instruments
  4Explanations of Music
  5Other
- title_for_layoutSearch Music Library
- $request->data(empty)
- $this->validationErrors(array)
  Session(empty)
  Work(empty)
  User(empty)
  Redirect(empty)
  Instrument(empty)
  StringType(empty)
  ChorusType(empty)
  AccompanimentType(empty)
  YouthConcert(empty)
  Page(empty)
  Revision(empty)
- Loaded Helpers(array)
  0MenuBuilder
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5Form
  6Html
  7Session
  8HtmlToolbar
====

Environment

App Constants

No application environment available.

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.6.40
Context Document Root	/home/lomusic/public_html
Context Prefix
Document Root	/home/lomusic/public_html
Gateway Interface	CGI/1.1
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Encoding	br,gzip
Http Accept Language	en-US,en;q=0.5
Http Connection	Keep-Alive
Http Host	www.latinorchestralmusic.com
Http If Modified Since	Wed, 13 Nov 2019 02:45:19 UTC
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Path	/bin:/usr/bin
Query String
Redirect Redirect Script Uri	http://www.latinorchestralmusic.com/music-library/search
Redirect Redirect Script Url	/music-library/search
Redirect Redirect Status	200
Redirect Redirect Unique Id	Xi2LwBQXzuyqjin2XI0LxgAAAM0
Redirect Script Uri	http://www.latinorchestralmusic.com/music-library/search
Redirect Script Url	/music-library/search
Redirect Status	200
Redirect Unique Id	Xi2LwBQXzuyqjin2XI0LxgAAAM0
Redirect Url	/app/webroot/music-library/search
Remote Addr	3.227.2.246
Remote Port	54144
Request Method	GET
Request Scheme	http
Request Uri	/music-library/search
Script Filename	/home/lomusic/public_html/app/webroot/index.php
Script Name	/app/webroot/index.php
Script Uri	http://www.latinorchestralmusic.com/music-library/search
Script Url	/music-library/search
Server Addr	69.16.242.22
Server Admin	webmaster@latinorchestralmusic.com
Server Name	www.latinorchestralmusic.com
Server Port	80
Server Protocol	HTTP/1.1
Server Signature
Server Software	Apache
Tz	America/Chicago
Unique Id	Xi2LwBQXzuyqjin2XI0LxgAAAM0
Php Self	/app/webroot/index.php
Request Time Float	1580043200.2713
Request Time	1580043200
Argc	0

====

Include
+
Included Files

Include Paths
- 0/home/lomusic/public_html/lib
- 2/opt/cpanel/ea-php56/root/usr/share/pear
- 3-> /home/lomusic/public_html/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/CookieComponent.php
  1CORE/Controller/Component/RequestHandlerComponent.php
  2CORE/Controller/Component/SessionComponent.php
  3CORE/Controller/Component/PaginatorComponent.php
  4CORE/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/Session/DatabaseSession.php
  2CORE/Model/Datasource/Session/CakeSessionHandlerInterface.php
  3CORE/Model/Datasource/Database/Mysql.php
  4CORE/Model/Datasource/DboSource.php
  5CORE/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/ModelBehavior.php
  3CORE/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
  6CORE/Utility/Folder.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/WorksController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/UserSession.php
  1APP/Model/AppModel.php
  2APP/Model/Work.php
  3APP/Model/User.php
  4APP/Model/Redirect.php
  5APP/Model/Instrument.php
  6APP/Model/StringType.php
  7APP/Model/ChorusType.php
  8APP/Model/AccompanimentType.php
  9APP/Model/YouthConcert.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
  Linkable(array)
  Behavior(array)
  0Linkable/Model/Behavior/LinkableBehavior.php
  Search(array)
  Component(array)
  0Search/Controller/Component/PrgComponent.php
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  Upload(array)
  Behavior(array)
  0Upload/Model/Behavior/UploadBehavior.php
====

Search Music Library

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 1 ms Total Queries: 29 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 1 ms
Total Queries: 29 queries