Preparing for Partnership: Carts

Cart

Your cart is empty

Please select your payment method

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent551c4c7e5cff021d0d75be6d75c532c5
  time1580293997
  timeout10
- _Tokena:5:{s:3:"key";s:40:"d2e9775510491214832baf9222cdd707c18bfd90";s:7:"expires";i:1560811997;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}
- Cart
  Cart
  namedefault
  total0
  currencyUSD
  CartItem(empty)
====
Request
+ –
Request

Cake Params
- controllercarts
- actionview
- plugincart
- named(empty)
- pass(empty)
- url
  exthtml
  url/cart/carts/view
- form(empty)
- isJson(false)
- _Token
  keyd2e9775510491214832baf9222cdd707c18bfd90
  expires1560811997
  allowedControllers(empty)
  allowedActions(empty)
  disabledFields(empty)
- isAjax(false)
$_GET
- url/cart/carts/view
Cookie
- 0(empty)
Current Route
- keys
  0plugin
  1controller
  2action
- options
  pluginpaypal|mail_queue|shop|seo|debug_kit|search|lessons|utils|users|debug_kit_plugins|jw_player|config|templates|categories|tags|rake|cart|cms|migrations|tiny_mce|media|asset_compress|jquery
- defaults
  plugin(null)
  actionindex
- template/:plugin/:controller/:action/*
- _greedy(true)
- _compiledRoute#^(?:/(paypal|mail_queue|shop|seo|debug_kit|search|lessons|utils|users|debug_kit_plugins|jw_player|config|templates|categories|tags|rake|cart|cms|migrations|tiny_mce|media|asset_compress|jquery))/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `courses`	10	10	2	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
SHOW FULL COLUMNS FROM `users`	21	21	3	maybe slow
SHOW FULL COLUMNS FROM `lessons`	12	12	3	maybe slow
SHOW FULL COLUMNS FROM `lesson_questions`	12	12	1	maybe slow
SHOW FULL COLUMNS FROM `pages`	27	27	1
SHOW FULL COLUMNS FROM `page_contents`	16	16	1	maybe slow
SHOW FULL COLUMNS FROM `question_answers`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `question_rules`	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `email_responses`	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `lessons_users`	11	11	2	maybe slow
SHOW FULL COLUMNS FROM `couples`	17	17	3	maybe slow
SHOW FULL COLUMNS FROM `churches`	26	26	4	maybe slow
SHOW FULL COLUMNS FROM `profiles`	19	19	3	maybe slow
SHOW FULL COLUMNS FROM `details`	10	10	2	maybe slow
SHOW FULL COLUMNS FROM `coupons`	14	14	3	maybe slow
SHOW FULL COLUMNS FROM `gift_certificates`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `media`	18	18	3	maybe slow
SELECT `Course`.`id`, `Course`.`user_id`, `Course`.`title`, `Course`.`slug`, `Course`.`description`, `Course`.`lesson_count`, `Course`.`price`, `Course`.`active`, `Course`.`created`, `Course`.`modified` FROM `courses` AS `Course` WHERE 1 = 1 LIMIT 1	1	1	0
SHOW FULL COLUMNS FROM `carts`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `cart_orders`	23	23	1
SHOW FULL COLUMNS FROM `cart_shipping_addresses`	12	12	3	maybe slow
SHOW FULL COLUMNS FROM `cart_captures`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `carts_items`	20	20	1	maybe slow
SHOW FULL COLUMNS FROM `cart_items_refunds`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `cart_refunds`	12	12	3	maybe slow
SHOW FULL COLUMNS FROM `cart_discounts`	9	9	2	maybe slow
SHOW FULL COLUMNS FROM `cart_discounts_carts`	3	3	2	maybe slow
SHOW FULL COLUMNS FROM `seo_meta_tags`	7	7	1	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
SHOW FULL COLUMNS FROM `seo_uris`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `seo_redirects`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `seo_titles`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `seo_canonicals`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `seo_status_codes`	7	7	1	maybe slow
SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/cart/carts/view' AND `SeoUri`.`is_approved` = 1	0	0	0
SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = 1	1	1	0
SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified` FROM `seo_meta_tags` AS `SeoMetaTag` WHERE `SeoMetaTag`.`seo_uri_id` = (1)	5	5	0

Query Explain:

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

====

Timer

+ –

Memory

Peak Memory Use 15.21 MB

Message	Memory use
Component intitailization	9.98 MB
Controller action start	10.11 MB
Controller render start	10.15 MB
View render complete	13.74 MB

Timers

Total Request Time: 2353 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	1669.93
Component initialization and startup	9.12
Controller action	0.23
Render Controller Action	169.70
» Rendering View	162.69
» » Rendering APP/views/plugins/cart/carts/view.ctp	127.19
» » » Rendering APP/views/plugins/cart/elements/carts/recap.ctp	1.66
» » Rendering APP/views/layouts/default.ctp	34.83
» » » Rendering APP/views/elements/layouts/additional_info.ctp	3.73
» » » Rendering APP/views/elements/layouts/church_admin.ctp	0.23
» » » Rendering APP/views/elements/layouts/reftagger.ctp	0.09
» » » Rendering APP/views/elements/layouts/google_analytics.ctp	0.08

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- controllerCarts
- actionview
- $this->data(empty)
- $this->validationErrors(empty)
- Loaded Helpers
  0cart
  1simpleGraph
  2htmlToolbar
  3toolbar
  4lessons
  5paginator
  6number
  7text
  8time
  9seo
  10jqueryEngine
  11js
  12ajax
  13jquery
  14form
  15javascript
  16html
  17session
  18phpPdf
====
Debug Kit Plugins.git
+ –

Git status

Current branch: develop

Last commits info:

commit a3f5e9660b4f9486e1412cc284d5d818453b185e

Author: www-data

Date: Wed Jan 9 10:07:40 2019 +0000

update local changes in live

commit 80acca1f017970c307ee109622b6a993c37c061d

Merge: bbe86da 002ad94

Author: www-data

Date: Wed Jan 9 10:01:15 2019 +0000

Merge branch 'develop' of git.cakedc.com:cakedc/pfp_app into develop

commit 002ad949d2852d6755c9535bdfd3c1cfa7279e48

Author: Yevgeny Tomenko

Date: Mon Nov 5 18:32:32 2018 +0300

add note

====

Preparing for Partnership

Cart

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables

Git status

Current branch: develop

Last commits info: