Preparing for Partnership: Gift Certificates

Your Gift Certificates

Preparing for Partnership

Perhaps there is no better gift to give to an engaged couple than the gift of pre-marital counseling, a gift that will last a lifetime! If you purchase three certificates, you will receive one free. Also note that you can purchase a Suggested Resource Package that will provide the couple with the major resources that are recommended in the course.

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent551c4c7e5cff021d0d75be6d75c532c5
  time1559818591
  timeout10
- _Tokena:5:{s:3:"key";s:40:"c34fae281ed15ecd84dbfa33cd98d9228fd967bd";s:7:"expires";i:1540336591;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
- controllergift_certificates
- actionindex
- named(empty)
- pass(empty)
- plugin(null)
- url
  exthtml
  url/gift_certificates
- form(empty)
- isJson(false)
- _Token
  keyc34fae281ed15ecd84dbfa33cd98d9228fd967bd
  expires1540336591
  allowedControllers(empty)
  allowedActions(empty)
  disabledFields(empty)
- isAjax(false)
- paging
  Course
  page1
  current1
  count1
  prevPage(false)
  nextPage(false)
  pageCount1
  defaults
  limit20
  step1
  recursive-1
  conditions
  Course.active(true)
  options
  page1
  limit20
  recursive-1
  conditions
  Course.active(true)
$_GET
- url/gift_certificates
Cookie
- 0(empty)
Current Route
- keys
  0controller
- options(empty)
- defaults
  actionindex
  plugin(null)
- template/:controller
- _greedy(false)
- _compiledRoute#^/(?:([^/]+))[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

Sql Log

+ –

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	4	maybe slow
SHOW FULL COLUMNS FROM `lessons`	12	12	1	maybe slow
SHOW FULL COLUMNS FROM `lesson_questions`	12	12	2	maybe slow
SHOW FULL COLUMNS FROM `pages`	27	27	15	maybe slow
SHOW FULL COLUMNS FROM `page_contents`	16	16	3	maybe slow
SHOW FULL COLUMNS FROM `question_answers`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `question_rules`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `email_responses`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `lessons_users`	11	11	3	maybe slow
SHOW FULL COLUMNS FROM `couples`	17	17	3	maybe slow
SHOW FULL COLUMNS FROM `churches`	26	26	3	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	1	maybe slow
SHOW FULL COLUMNS FROM `gift_certificates`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `media`	18	18	1	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	2	maybe slow
SHOW FULL COLUMNS FROM `cart_orders`	23	23	3	maybe slow
SHOW FULL COLUMNS FROM `cart_shipping_addresses`	12	12	2	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	1	maybe slow
SHOW FULL COLUMNS FROM `cart_discounts`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `cart_discounts_carts`	3	3	13	maybe slow
SELECT COUNT(*) AS `count` FROM `courses` AS `Course` WHERE `Course`.`active` = 1	1	1	0
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 `Course`.`active` = 1 LIMIT 20	1	1	0
SHOW FULL COLUMNS FROM `items`	16	16	3	maybe slow
SHOW FULL COLUMNS FROM `categories`	13	13	2	maybe slow
SHOW FULL COLUMNS FROM `categorized`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `tagged`	7	7	2	maybe slow
SELECT `ResourcePackage`.`id`, `ResourcePackage`.`media_id`, `ResourcePackage`.`name`, `ResourcePackage`.`slug`, `ResourcePackage`.`description`, `ResourcePackage`.`price`, `ResourcePackage`.`sku`, `ResourcePackage`.`views`, `ResourcePackage`.`active`, `ResourcePackage`.`sale_start`, `ResourcePackage`.`sale_end`, `ResourcePackage`.`info_url`, `ResourcePackage`.`created`, `ResourcePackage`.`modified`, `ResourcePackage`.`units`, `ResourcePackage`.`scope`, `Photo`.`id`, `Photo`.`user_id`, `Photo`.`foreign_key`, `Photo`.`model`, `Photo`.`title`, `Photo`.`slug`, `Photo`.`description`, `Photo`.`path`, `Photo`.`filename`, `Photo`.`filesize`, `Photo`.`hash`, `Photo`.`mime_type`, `Photo`.`views`, `Photo`.`downloads`, `Photo`.`created`, `Photo`.`modified`, `Photo`.`type`, `Photo`.`url` FROM `items` AS `ResourcePackage` LEFT JOIN `media` AS `Photo` ON (`Photo`.`foreign_key` = `ResourcePackage`.`id`) WHERE `ResourcePackage`.`scope` = 'resource_package'	0	0	0
SHOW FULL COLUMNS FROM `seo_meta_tags`	7	7	3	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
SHOW FULL COLUMNS FROM `seo_uris`	5	5	2	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` = '/gift_certificates' 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 16.69 MB

Message	Memory use
Component intitailization	8.61 MB
Controller action start	10.05 MB
Controller render start	11.46 MB
View render complete	15.08 MB

Timers

Total Request Time: 2414 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	1093.78
Component initialization and startup	165.33
Controller action	115.77
Render Controller Action	322.17
» Rendering View	304.37
» » Rendering APP/views/gift_certificates/index.ctp	144.28
» » » Rendering APP/views/elements/gift_certificates/header.ctp	1.00
» » Rendering APP/views/layouts/default.ctp	159.01
» » » Rendering APP/views/elements/layouts/additional_info.ctp	10.52
» » » Rendering APP/views/elements/layouts/church_admin.ctp	0.72
» » » Rendering APP/views/elements/layouts/reftagger.ctp	0.27
» » » Rendering APP/views/elements/layouts/google_analytics.ctp	0.24

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- controllerGiftCertificates
- actionindex
- resourcePackages(empty)
- giftCertificates
  0
  Course
  id4e64e114-d280-46a5-a76f-5684e44f6001
  user_idsystem
  titlePreparing for Partnership Course
  slugpreparing_for_partnership_course_gift_coupon
  description
  lesson_count13
  price89.00
  active1
  created2011-09-05 14:47:48
  modified2011-09-05 14:47:48
- $this->data(empty)
- $this->validationErrors(empty)
- Loaded Helpers
  0cart
  1simpleGraph
  2htmlToolbar
  3toolbar
  4mediaImage
  5lessons
  6paginator
  7number
  8text
  9time
  10seo
  11jqueryEngine
  12js
  13ajax
  14jquery
  15form
  16javascript
  17html
  18session
  19phpPdf
====
Debug Kit Plugins.git
+ –

Git status

Current branch: develop

Last commits info:

commit bbe86dacf4f98fe1a92abbdb44a5b1cd9048562f

Merge: da252f6 797c893

Author: www-data

Date: Wed May 18 20:02:21 2016 +0000

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

commit 797c893679acb06f844c016fa8b990624b984b51

Merge: 9d5a80d 100fb88

Author: Yevgeny Tomenko

Date: Wed May 18 23:02:57 2016 +0300

Merge branch 'master' into develop

commit 100fb88dd5ce452c57b37276c472d02f10c74fd6

Author: Yevgeny Tomenko

Date: Wed May 18 22:59:39 2016 +0300

optimize lessons runner

====

Preparing for Partnership

Your Gift Certificates

Preparing for Partnership Course Gift Certificate $89.00

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: