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
  time1570184209
  timeout10
- _Tokena:5:{s:3:"key";s:40:"302973077dba6de83ffac05f03721d1c9681a528";s:7:"expires";i:1550702209;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
  key302973077dba6de83ffac05f03721d1c9681a528
  expires1550702209
  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	2	maybe slow
SHOW FULL COLUMNS FROM `lessons`	12	12	1	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	1	maybe slow
SHOW FULL COLUMNS FROM `question_rules`	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `email_responses`	8	8	3	maybe slow
SHOW FULL COLUMNS FROM `lessons_users`	11	11	2	maybe slow
SHOW FULL COLUMNS FROM `couples`	17	17	1	maybe slow
SHOW FULL COLUMNS FROM `churches`	26	26	1
SHOW FULL COLUMNS FROM `profiles`	19	19	3	maybe slow
SHOW FULL COLUMNS FROM `details`	10	10	3	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	2	maybe slow
SHOW FULL COLUMNS FROM `cart_orders`	23	23	2	maybe slow
SHOW FULL COLUMNS FROM `cart_shipping_addresses`	12	12	2	maybe slow
SHOW FULL COLUMNS FROM `cart_captures`	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `carts_items`	20	20	3	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	1	maybe slow
SHOW FULL COLUMNS FROM `cart_discounts_carts`	3	3	2	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	1	maybe slow
SHOW FULL COLUMNS FROM `categories`	13	13	1	maybe slow
SHOW FULL COLUMNS FROM `categorized`	7	7	2	maybe slow
SHOW FULL COLUMNS FROM `tags`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `tagged`	7	7	1	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	2	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	2	maybe slow
SHOW FULL COLUMNS FROM `seo_titles`	5	5	2	maybe slow
SHOW FULL COLUMNS FROM `seo_canonicals`	6	6	2	maybe slow
SHOW FULL COLUMNS FROM `seo_status_codes`	7	7	2	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.65 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: 2587 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	1313.91
Component initialization and startup	126.57
Controller action	110.45
Render Controller Action	418.44
» Rendering View	394.93
» » Rendering APP/views/gift_certificates/index.ctp	321.35
» » » Rendering APP/views/elements/gift_certificates/header.ctp	0.97
» » Rendering APP/views/layouts/default.ctp	72.07
» » » Rendering APP/views/elements/layouts/additional_info.ctp	3.74
» » » Rendering APP/views/elements/layouts/church_admin.ctp	0.21
» » » Rendering APP/views/elements/layouts/reftagger.ctp	0.11
» » » Rendering APP/views/elements/layouts/google_analytics.ctp	0.10

====

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 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

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: