Utilities

Home
>
Browse all schemes
>
Utilities

No codes available. Go back

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent88bca574344702e18e30d50b7832825f
  time1746722539
  countdown10
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschemes
- actiondetails
- named(empty)
- pass(array)
  07
- langen
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- nameI18nRoute
- keys(array)
  0lang
  1controller
  2action
- options(array)
  __promote(true)
  langen
- defaults(array)
  plugin(null)
- template/:lang/:controller/:action/*
====

Sql Logs

default

Total Time: 2 ms
Total Queries: 8 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `CmsPages`.`id`, `CmsPages`.`url`, `CmsPages`.`title`, `CmsPages`.`content`, `CmsPages`.`additional_content`, `CmsPages`.`created`, `CmsPages`.`modified`, `CmsPages`.`draft`, `CmsPages`.`empty_action`, `CmsPages`.`instance_id`, `CmsPages`.`in_navigation`, `CmsPages`.`nav_position`, `CmsPages`.`is_homepage`, `CmsPages`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPages` WHERE 1 = 1 ORDER BY `url` DESC	6	6	0
SELECT `Instance`.`id`, `Instance`.`name`, `Instance`.`domain`, `Instance`.`reservation_time`, `Instance`.`slogan` FROM `chainrefferdevra_cakeapp`.`instances` AS `Instance` WHERE `Instance`.`domain` = 'chainreffer.dev.rakdesign.com' LIMIT 1	1	1	0
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`instance_id`, `CmsPage`.`in_navigation`, `CmsPage`.`nav_position`, `CmsPage`.`is_homepage`, `CmsPage`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPage` WHERE `CmsPage`.`in_navigation`=1 AND `CmsPage`.`instance_id`=1 ORDER BY `CmsPage`.`nav_position` ASC	2	2	0
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`instance_id`, `CmsPage`.`in_navigation`, `CmsPage`.`nav_position`, `CmsPage`.`is_homepage`, `CmsPage`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPage` WHERE `CmsPage`.`footer`=1 AND `CmsPage`.`instance_id`=1 ORDER BY `CmsPage`.`nav_position` ASC	3	3	0
SELECT COUNT(*) AS `count` FROM `chainrefferdevra_cakeapp`.`schemes` AS `Scheme` WHERE `Scheme`.`id` = 7	1	1	0
SELECT `Chain`.`name`, `Code`.`created`, `Chain`.`image`, `Chain`.`description`, `Chain`.`id`, `Chain`.`instructions`, `Code`.`code_parent_id`, count(`Code`.`chain_id`) as CodesCount FROM `chainrefferdevra_cakeapp`.`codes` AS `Code` LEFT JOIN `chainrefferdevra_cakeapp`.`chains` AS `Chain` ON (`Code`.`chain_id` = `Chain`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`users` AS `OwnerUser` ON (`Code`.`owner_user_id` = `OwnerUser`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`codes` AS `CodeReferal` ON (`Code`.`code_referal_id` = `CodeReferal`.`id`) LEFT JOIN `chainrefferdevra_cakeapp`.`users` AS `SemaforUser` ON (`Code`.`semafor_user_id` = `SemaforUser`.`id`) WHERE `Chain`.`scheme_id` = 7 AND `Chain`.`instance_id` = 1 AND `Code`.`is_validated` = '1' AND `Code`.`complain` IS NULL AND `Code`.`semafor_user_id` IS NULL AND `Code`.`completed` = '0' GROUP BY `Code`.`chain_id`	0	0	2	maybe slow
SELECT `Scheme`.`id`, `Scheme`.`name`, `Scheme`.`instance_id`, `Scheme`.`recomended`, `Scheme`.`created`, `Instance`.`id`, `Instance`.`name`, `Instance`.`domain`, `Instance`.`reservation_time`, `Instance`.`slogan` FROM `chainrefferdevra_cakeapp`.`schemes` AS `Scheme` LEFT JOIN `chainrefferdevra_cakeapp`.`instances` AS `Instance` ON (`Scheme`.`instance_id` = `Instance`.`id`) WHERE `Scheme`.`id` = 7 LIMIT 1	1	1	0
SELECT `CmsPage`.`id`, `CmsPage`.`url`, `CmsPage`.`title`, `CmsPage`.`content`, `CmsPage`.`additional_content`, `CmsPage`.`created`, `CmsPage`.`modified`, `CmsPage`.`draft`, `CmsPage`.`empty_action`, `CmsPage`.`instance_id`, `CmsPage`.`in_navigation`, `CmsPage`.`nav_position`, `CmsPage`.`is_homepage`, `CmsPage`.`footer` FROM `chainrefferdevra_cakeapp`.`cms_pages` AS `CmsPage` WHERE `url` = 'en/schemes/details/7' LIMIT 1	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 8.03 MB

Message	Memory use
Component initialization	4.49 MB
Controller action start	5.24 MB
Controller render start	5.68 MB
View render complete	7.18 MB

Timers

Total Request Time: 73 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	34.72
Event: Controller.initialize	2.69
Event: Controller.startup	0.63
Controller action	7.53
Event: Controller.beforeRender	2.07
» Processing toolbar data	1.86
Rendering View	3.98
» Event: View.beforeRender	0.01
» Rendering APP/View/Schemes/details.ctp	0.23
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.01
» Rendering APP/View/Themed/App/Layouts/bootstrap.ctp	2.70
» » Rendering APP/View/Themed/App/Elements/head.ctp	0.87
» » » Rendering ROOT/plugins/Summernote/View/Elements/summernote.ctp	0.08
» » Rendering APP/View/Elements/page_header_not_logged.ctp	1.00
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- scheme(empty)
- name(array)
  Scheme(array)
  id7
  nameUtilities
  instance_id1
  recomended(true)
  created2024-02-27 15:23:31
  Instance(array)
  id1
  nameRakDesign ChainReferrer 1.0
  domainchainreffer.dev.rakdesign.com
  reservation_time3600
  sloganthe smarter way to sign up
- uploadsId860ff7308ba0dcac7431204f29f24fbc
- isUser(false)
- isAdmin(false)
- isSuperAdmin(false)
- footMenu(array)
  0(array)
  CmsPage(array)
  id5
  urlcontact
  titleContact
  content<div class="row"><div class="col-sm-6"><h3>Chain Refer</h3><p>The Business Centre<br>61 Wellfield Road<br>Roath<br>Cardiff<br>CF24 3DG</p></div><div class="col-sm-6"><h3>Contact details</h3><p>If you have some questions, please contact us!</p><p>phone: 234324234<br>email: email@example.com</p></div></div>
  additional_content<p>Chain Refer</p><p>The smarter way to sign up</p>
  created16-08-2017 09:19:16
  modified12-06-2023 20:21:54
  draft(null)
  empty_action(null)
  instance_id1
  in_navigation(false)
  nav_position0
  is_homepage(false)
  footer(true)
  1(array)
  CmsPage(array)
  id6
  urlprivacy-policy
  titlePrivacy policy
  content<p>Affiliate Networks</p><p>When you click through to a retailer's website from Chain Refer, your browser redirects via an Affiliate Network which stores a cookie on your computer. The cookie stores tracking information so that your visit to that retailer, via our Site is recorded. Any subsequent purchases you then make will result in the retailer reading this information.</p><p>The retailer will then send us information about your purchase, at which point we can then validate your transaction and in turn recommend your referral code to other members of our community. We recommend that you enable cookies in your browsers to make full use of the Site in order to ensure that any purchases on third party sites are recorded.<br></p><p>By continuing to use our Site you agree to third parties such as Affiliate Networks and retailers featured on our Site to using cookies for the purpose of tracking and validating your transactions.<br></p><p>Retailer Cookies<br></p><p>Retailers may place cookies on your device when you transact with them. Those cookies will be governed by the retailer’s own policies. We are not responsible for retailers’ or other third parties’ acts and omissions (including in relation to their cookie and privacy policies).</p>
  additional_content
  created16-08-2017 09:39:08
  modified12-06-2023 21:32:55
  draft(null)
  empty_action(null)
  instance_id1
  in_navigation(false)
  nav_position2
  is_homepage(false)
  footer(true)
  2(array)
  CmsPage(array)
  id7
  urlterms
  titleTerms of use
  content<p>Lorem isyusamdk</p>
  additional_content
  created16-08-2017 09:41:51
  modified16-08-2017 09:41:51
  draft(null)
  empty_action(null)
  instance_id1
  in_navigation(false)
  nav_position3
  is_homepage(false)
  footer(true)
- mainMenu(array)
  0(array)
  CmsPage(array)
  id1
  urlabout-us
  titleAbout Us
  content<table border="0" cellpadding="0" cellspacing="0" width="504" style="width: 378pt;"><tbody><tr height="280" style="height:210.0pt"> <td height="280" class="xl65" width="504" style="height:210.0pt;width:378pt">Chain refer was created to give people like you enhanced rewards by sharing referrals among its members.<br> <br>We are giving you the opportunity to enhance your sign up bonuses with little to no additional effort. What's not to like, right? Exactly, we thought the same too which is why Chain Refer was created.<br> <br> We are confident that you, and every other member of Chain Refer, will have a positive experience which is why we take pride in displaying our TrustPilot score.<br> <br> If you do want to find out more or have any comments that you'd like to share then we would love for you to get in contact with us via the contact us page or drop us an email at **emailaddress@tobeincluded.com**</td></tr></tbody></table>
  additional_content<p><span style="color: rgb(34, 34, 34); font-family: Consolas, "Lucida Console", "Courier New", monospace; font-size: 12px; white-space: pre-wrap;">The smarter way to sign up</span><br></p>
  created22-07-2016 07:09:23
  modified02-01-2024 15:04:55
  draft(null)
  empty_action(null)
  instance_id1
  in_navigation(true)
  nav_position1
  is_homepage(false)
  footer(false)
  1(array)
  CmsPage(array)
  id2
  urlfaq
  titleFAQ
  content<h5><span style="font-size: 13px;"><b>How does it work?</b></span> <br class="Apple-interchange-newline"></h5><h5><span style="font-size: 13px;">You love enjoying discounts, credits or a great bonus when you make a purchase or subscribe to a service. Once you have utilised a code to make a purchase or subscription your referral code will be given to other members of the community that want to sign up for that product or service. In doing so existing members will benefit from their referral code being used and new members will benefit from the benefits of using a referal code as well as their referal code being passed on to other new members wanting to sign up to the same great product or service</span></h5><h5><br></h5><p><b>Does it cost?</b></p><p>No! This service is completely free and will not cost you a penny</p><p><b>Why should I use Chain Refer?</b></p><p>By using Chain Refer your referral code will be passed on to our community of users and you stand to reap the benefits from all the referral bonuses that you will get when members of our community use your referral codes</p>
  additional_content<p><span style="color: rgb(34, 34, 34); font-family: Consolas, "Lucida Console", "Courier New", monospace; font-size: 12px; white-space: pre-wrap;">the smarter way to sign up</span><br></p>
  created22-07-2016 07:28:54
  modified12-06-2023 21:05:49
  draft(null)
  empty_action(null)
  instance_id1
  in_navigation(true)
  nav_position2
  is_homepage(false)
  footer(false)
- auth(null)
- chainInstance(array)
  Instance(array)
  id1
  nameRakDesign ChainReferrer 1.0
  domainchainreffer.dev.rakdesign.com
  reservation_time3600
  sloganthe smarter way to sign up
- domainchainreffer.dev.rakdesign.com
- backurl/
- $request->data(empty)
- $this->validationErrors(array)
  CmsPages(empty)
  Instance(empty)
  CmsPage(empty)
  Attempt(empty)
  Scheme(empty)
  Code(empty)
  Chain(empty)
  OwnerUser(empty)
  CodeReferal(empty)
  SemaforUser(empty)
- Loaded Helpers(array)
  0Session
  1Html
  2Form
  3Paginator
  4Dotpay
  5Js
  6Thumbnail
  7I18n
  8MinifyHtml
  9Minify
  10Cms
  11DataTable
  12Number
  13SimpleGraph
  14DebugTimer
  15Toolbar
  16HtmlToolbar
====

Environment

App Constants

Constant	Value
CONFIG	/home/devchainreffe/public_html/app/Config/
DEFAULT_LANGUAGE	en

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.3.33
Path	/usr/local/bin:/usr/bin:/bin
Tz	Europe/London
Redirect Handler	application/x-httpd-ea-php73
Redirect Status	200
Unique Id	aBymq28pog2CUaI4eOdQVAAAAAM
Script Url	/en/schemes/details/7
Script Uri	https://chainreffer.dev.rakdesign.com/en/schemes/details/7
Https	on
Ssl Tls Sni	chainreffer.dev.rakdesign.com
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Http Host	chainreffer.dev.rakdesign.com
Http X Https	1
Server Signature
Server Software	Apache
Server Name	chainreffer.dev.rakdesign.com
Server Addr	136.243.69.149
Server Port	443
Remote Addr	3.145.80.205
Document Root	/home/devchainreffe/public_html
Request Scheme	https
Context Prefix	/cgi-sys
Context Document Root	/usr/local/cpanel/cgi-sys/
Server Admin	webmaster@chainreffer.dev.rakdesign.com
Script Filename	/home/devchainreffe/public_html/app/webroot/index.php
Remote Port	49579
Redirect Url	/app/webroot/index.php
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/en/schemes/details/7
Script Name	/app/webroot/index.php
Orig Script Filename	/usr/local/cpanel/cgi-sys/ea-php73
Orig Path Info	/app/webroot/index.php
Orig Path Translated	/home/devchainreffe/public_html/app/webroot/index.php
Orig Script Name	/cgi-sys/ea-php73
Php Self	/app/webroot/index.php
Request Time Float	1746708139.5723
Request Time	1746708139

====

Include
+
Included Files

Include Paths
- 0/home/devchainreffe/public_html/lib
- 2/opt/alt/php73/usr/share/pear
- 3-> /home/devchainreffe/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/CookieComponent.php
  2CORE/Controller/Component/AuthComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/PaginatorComponent.php
  5CORE/Controller/Component/Auth/FormAuthenticate.php
  6CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.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/CakeObject.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/CakeText.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
  4APP/Config/dotpay.php
  Controller(array)
  0APP/Controller/SchemesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Instance.php
  2APP/Model/CmsPage.php
  3APP/Model/Scheme.php
  4APP/Model/Code.php
  5APP/Model/Chain.php
  6APP/Model/User.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  Attempt(array)
  Component(array)
  0Attempt/Controller/Component/AttemptComponent.php
  Model(array)
  0Attempt/Model/Attempt.php
  Cms(array)
  Other(array)
  0Cms/Lib/CmsRoutes.php
  Component(array)
  0Cms/Controller/Component/CmsComponent.php
  DataTable(array)
  Component(array)
  0DataTable/Controller/Component/DataTableComponent.php
  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
  Dotpay(array)
  Component(array)
  0Dotpay/Controller/Component/DotpayComponent.php
  Other(array)
  0Dotpay/Lib/Dotpay.php
  I18n(array)
  Plugin(array)
  0I18n/Lib/Routing/Route/I18nRoute.php
  Config(array)
  0I18n/Config/routes.php
  Minify(array)
  Config(array)
  0Minify/Config/routes.php
====

the smarter way to sign up

Utilities

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 2 ms Total Queries: 8 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 2 ms
Total Queries: 8 queries