Academic | Cambridgeindia.org

The future of publishing since 1584

Music

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

Cake Params
- plugin(null)
- controlleracademic
- actiontextbooks2
- named(empty)
- pass(empty)
- slugMusic
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0slug
- options(empty)
- defaults(array)
  controlleracademic
  actiontextbooks2
  plugin(null)
- template/academic/textbooks/:slug
====

Sql Logs

default

Total Time: 17 ms
Total Queries: 5 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `sub_category`.`id`, `sub_category`.`code`, `sub_category`.`name`, `sub_category`.`category_id`, `sub_category`.`parent_url` FROM `cambri_live`.`sub_categories` AS `sub_category` WHERE `sub_category`.`category_id` = 1 ORDER BY `sub_category`.`name` ASC LIMIT 37	37	37	1
SELECT Distinct(sub_categories.name) FROM sub_categories inner join Book on sub_categories.code = Book.Subject_code_1 where sub_categories.category_id = 1 and Book.textbook_flag = "Textbook" order by sub_categories.name ASC;	17	17	15	maybe slow
SELECT `sub_category`.`id`, `sub_category`.`code`, `sub_category`.`name`, `sub_category`.`category_id`, `sub_category`.`parent_url` FROM `cambri_live`.`sub_categories` AS `sub_category` WHERE `sub_category`.`category_id` = 1 ORDER BY `sub_category`.`name` ASC LIMIT 37	37	37	1
SELECT `sub_category`.`id`, `sub_category`.`code`, `sub_category`.`name`, `sub_category`.`category_id`, `sub_category`.`parent_url` FROM `cambri_live`.`sub_categories` AS `sub_category` WHERE `sub_category`.`name` = 'Music' LIMIT 1	1	1	0
SELECT `Subject`.`id`, `Subject`.`code`, `Subject`.`name`, `Subject`.`sub_categories_code` FROM `cambri_live`.`subjects` AS `Subject` WHERE 1 = 1 LIMIT 15	15	15	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 9.98 MB

Message	Memory use
Component initialization	3.52 MB
Controller action start	5.55 MB
Controller render start	5.73 MB
View render complete	6.55 MB

Timers

Total Request Time: 296 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	78.45
Event: Controller.initialize	50.86
Event: Controller.startup	1.03
Controller action	6.70
Event: Controller.beforeRender	53.96
» Processing toolbar data	53.65
Rendering View	8.13
» Event: View.beforeRender	0.12
» Rendering APP/View/Academic/list.ctp	0.61
» Event: View.afterRender	0.09
» Event: View.beforeLayout	0.07
» Rendering APP/View/Layouts/default.ctp	4.94
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- TextbooksTextbooks
- subjects(array)
  0(array)
  Subject(array)
  id1
  code1UX
  nameCambridge University publications
  sub_categories_code1U
  1(array)
  Subject(array)
  id2
  code1XX
  nameGeneral
  sub_categories_code1X
  2(array)
  Subject(array)
  id3
  code211
  nameWestern art
  sub_categories_code21
  3(array)
  Subject(array)
  id4
  code212
  nameNon-western art
  sub_categories_code21
  4(array)
  Subject(array)
  id5
  code213
  nameArchitecture
  sub_categories_code21
  5(array)
  Subject(array)
  id6
  code214
  namePhotography
  sub_categories_code21
  6(array)
  Subject(array)
  id7
  code215
  nameApplied arts
  sub_categories_code21
  7(array)
  Subject(array)
  id8
  code21X
  nameArt (general)
  sub_categories_code21
  8(array)
  Subject(array)
  id9
  code221
  nameMusic criticism
  sub_categories_code22
  9(array)
  Subject(array)
  id10
  code222
  nameMusic performance
  sub_categories_code22
  10(array)
  Subject(array)
  id11
  code223
  nameEthnomusicology
  sub_categories_code22
  11(array)
  Subject(array)
  id12
  code224
  nameOpera
  sub_categories_code22
  12(array)
  Subject(array)
  id13
  code225
  nameDance
  sub_categories_code22
  13(array)
  Subject(array)
  id14
  code226
  nameMedieval and Renaissance music
  sub_categories_code22
  14(array)
  Subject(array)
  id15
  code227
  nameSeventeenth-century music
  sub_categories_code22
- sub_category(array)
  sub_category(array)
  id4
  code22
  nameMusic
  category_id1
  parent_url(null)
- sub_categories(array)
  0(array)
  sub_category(array)
  id25
  code62
  nameAmerican history
  category_id1
  parent_url(null)
  1(array)
  sub_category(array)
  id8
  code32
  nameAmerican literature
  category_id1
  parent_url(null)
  2(array)
  sub_category(array)
  id16
  code52
  nameAnthropology
  category_id1
  parent_url(null)
  3(array)
  sub_category(array)
  id17
  code53
  nameArchaeology
  category_id1
  parent_url(null)
  4(array)
  sub_category(array)
  id3
  code21
  nameArt
  category_id1
  parent_url(null)
  5(array)
  sub_category(array)
  id35
  code76
  nameAstronomy
  category_id1
  parent_url(null)
  6(array)
  sub_category(array)
  id24
  code61
  nameBritish history
  category_id1
  parent_url(null)
  7(array)
  sub_category(array)
  id1
  code1U
  nameCambridge University publications
  category_id1
  parent_url(null)
  8(array)
  sub_category(array)
  id33
  code74
  nameChemistry
  category_id1
  parent_url(null)
  9(array)
  sub_category(array)
  id6
  code24
  nameClassical studies
  category_id1
  parent_url(null)
  10(array)
  sub_category(array)
  id31
  code72
  nameComputer science
  category_id1
  parent_url(null)
  11(array)
  sub_category(array)
  id10
  code34
  nameDrama and theatre
  category_id1
  parent_url(null)
  12(array)
  sub_category(array)
  id34
  code75
  nameEarth and environmental science
  category_id1
  parent_url(null)
  13(array)
  sub_category(array)
  id20
  code56
  nameEconomics
  category_id1
  parent_url(null)
  14(array)
  sub_category(array)
  id23
  code59
  nameEducation
  category_id1
  parent_url(null)
  15(array)
  sub_category(array)
  id36
  code78
  nameEngineering
  category_id1
  parent_url(null)
  16(array)
  sub_category(array)
  id7
  code31
  nameEnglish literature
  category_id1
  parent_url(null)
  17(array)
  sub_category(array)
  id9
  code33
  nameEuropean and world literature
  category_id1
  parent_url(null)
  18(array)
  sub_category(array)
  id26
  code63
  nameEuropean history
  category_id1
  parent_url(null)
  19(array)
  sub_category(array)
  id5
  code23
  nameFilm media and sport
  category_id1
  parent_url(null)
  20(array)
  sub_category(array)
  id2
  code1X
  nameGeneral
  category_id1
  parent_url(null)
  21(array)
  sub_category(array)
  id37
  code79
  nameGeneral science
  category_id1
  parent_url(null)
  22(array)
  sub_category(array)
  id21
  code57
  nameGeography
  category_id1
  parent_url(null)
  23(array)
  sub_category(array)
  id28
  code65
  nameHistory - cross discipline
  category_id1
  parent_url(null)
  24(array)
  sub_category(array)
  id27
  code64
  nameHistory - other areas
  category_id1
  parent_url(null)
  25(array)
  sub_category(array)
  id11
  code35
  nameLanguage and linguistics
  category_id1
  parent_url(null)
  26(array)
  sub_category(array)
  id22
  code58
  nameLaw
  category_id1
  parent_url(null)
  27(array)
  sub_category(array)
  id38
  code81
  nameLife sciences
  category_id1
  parent_url(null)
  28(array)
  sub_category(array)
  id14
  code50
  nameManagement
  category_id1
  parent_url(null)
  29(array)
  sub_category(array)
  id30
  code71
  nameMathematics
  category_id1
  parent_url(null)
  30(array)
  sub_category(array)
  id39
  code91
  nameMedicine
  category_id1
  parent_url(null)
  31(array)
  sub_category(array)
  id4
  code22
  nameMusic
  category_id1
  parent_url(null)
  32(array)
  sub_category(array)
  id12
  code41
  namePhilosophy
  category_id1
  parent_url(null)
  33(array)
  sub_category(array)
  id32
  code73
  namePhysics
  category_id1
  parent_url(null)
  34(array)
  sub_category(array)
  id19
  code55
  namePolitics
  category_id1
  parent_url(null)
  35(array)
  sub_category(array)
  id18
  code54
  namePsychology
  category_id1
  parent_url(null)
  36(array)
  sub_category(array)
  id13
  code42
  nameReligion
  category_id1
  parent_url(null)
- subjects_for_textbooks(array)
  0(array)
  sub_categories(array)
  nameAstronomy
  1(array)
  sub_categories(array)
  nameComputer science
  2(array)
  sub_categories(array)
  nameEconomics
  3(array)
  sub_categories(array)
  nameEducation
  4(array)
  sub_categories(array)
  nameEngineering
  5(array)
  sub_categories(array)
  nameEnglish literature
  6(array)
  sub_categories(array)
  nameHistory - cross discipline
  7(array)
  sub_categories(array)
  nameHistory - other areas
  8(array)
  sub_categories(array)
  nameLanguage and linguistics
  9(array)
  sub_categories(array)
  nameLife sciences
  10(array)
  sub_categories(array)
  nameManagement
  11(array)
  sub_categories(array)
  nameMathematics
  12(array)
  sub_categories(array)
  nameMedicine
  13(array)
  sub_categories(array)
  namePhilosophy
  14(array)
  sub_categories(array)
  namePhysics
  15(array)
  sub_categories(array)
  namePsychology
  16(array)
  sub_categories(array)
  nameSociology
- count37
- $request->data(empty)
- $this->validationErrors(array)
  sub_category(empty)
  Subject(empty)
- Loaded Helpers(array)
  0Number
  1SimpleGraph
  2DebugTimer
  3Toolbar
  4Html
  5HtmlToolbar
  6Form
====

Environment

App Constants

No application environment available.

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.6.38
Context Document Root	/home/cambri/public_html
Context Prefix
Document Root	/home/cambri/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	gzip
Http Accept Language	en-US,en;q=0.5
Http Connection	Keep-Alive
Http Host	www.cambridgeindia.org
Http If Modified Since	Mon, 18 Feb 2019 10:32:52 CST
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Path	/bin:/usr/bin
Query String
Redirect Redirect Status	200
Redirect Redirect Unique Id	XL-HjYG3JvlEWDsrJEhqMQAAACc
Redirect Status	200
Redirect Unique Id	XL-HjYG3JvlEWDsrJEhqMQAAACc
Redirect Url	/app/webroot/academic/textbooks/Music
Remote Addr	54.226.73.255
Remote Port	40278
Request Method	GET
Request Scheme	http
Request Uri	/academic/textbooks/Music
Script Filename	/home/cambri/public_html/app/webroot/index.php
Script Name	/app/webroot/index.php
Server Addr	166.62.85.161
Server Admin	webmaster@cambridgeindia.org
Server Name	www.cambridgeindia.org
Server Port	80
Server Protocol	HTTP/1.1
Server Signature
Server Software	Apache
Unique Id	XL-HjYG3JvlEWDsrJEhqMQAAACc
Php Self	/app/webroot/index.php
Request Time Float	1556072333.5
Request Time	1556072333
Argc	0

====

Include
+
Included Files

Include Paths
- 0/home/cambri/public_html/lib
- 2/usr/lib/php
- 3/usr/local/lib/php
- 4-> /home/cambri/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/EmailComponent.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/AcademicController.php
  Model(array)
  0APP/Model/sub_category.php
  1APP/Model/AppModel.php
  2APP/Model/Subject.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
====

Music

About

Contacts

CSR Policy

default

Total Time: 17 ms
Total Queries: 5 queries

Query Explain:

Memory

Timers

Music

CSR Policy

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 17 ms Total Queries: 5 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 17 ms
Total Queries: 5 queries