Strength Training

001

SET
NAMES 'utf8' COLLATE 'utf8_general_ci'

execution time: 0.100 ms (8.58%)
affected rows: 0
backtrace
to the top
close all

file	function	line
/var/www/vhosts/sciactioncanada.ca/httpdocs/assets/zebra/Zebra_Database.php	query()	2925
/var/www/vhosts/sciactioncanada.ca/httpdocs/config.php	set_charset()	26
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php	require_once()	2

002

SELECT
*
FROM
pages
WHERE
pageURL = 'module1/strength-training.php'

execution time: 0.343 ms (29.43%)
returned rows: 1
explain
backtrace
to the top
close all

pageId	pageTitle	pageNavTitle	pageNavSubtitle	pageNavIsHeader	pageSection	pageOrder	pageURL	pageMetaKeys	pageMetaDesc	pageQuiz
5	Strength Training	Strength Training		False	module1	5	module1/strength-training.php

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pages	ALL					10	100.00	Using where

file	function	line
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/php/modulelibrary.php	query()	4
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php	require()	3

003

SELECT
pageNavTitle, pageNavSubtitle, pageNavIsHeader, pageId, pageURL, pageQuiz, pageSection
FROM
pages
WHERE
pageSection = 'module1'
ORDER BY
pageOrder

execution time: 0.213 ms (18.30%)
returned rows: 6
explain
backtrace
to the top
close all

pageNavTitle	pageNavSubtitle	pageNavIsHeader	pageId	pageURL	pageSection
Module 1	The Guidelines	True	3	javascript:;	module1
Introduction		False	2	module1/introduction.php	module1
Aerobic Exercise		False	4	module1/aerobic-activity.php	module1
Strength Training		False	5	module1/strength-training.php	module1
Action Planning		False	8	module1/action-planning.php	module1
Get in Motion		False	6	module1/get-in-motion.php	module1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pages	ALL					10	100.00	Using where; Using filesort

file	function	line
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/php/modulelibrary.php	query()	22
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php	require()	3

004

SELECT
pageNavTitle, pageNavSubtitle, pageNavIsHeader, pageId, pageURL, pageQuiz, pageSection
FROM
pages
WHERE
pageSection = 'module2'
ORDER BY
pageOrder

execution time: 0.169 ms (14.51%)
returned rows: 4
explain
backtrace
to the top
close all

pageNavTitle	pageNavSubtitle	pageNavIsHeader	pageId	pageURL	pageSection
Module 2	Physical Activity Planning	True	9	javascript:;	module2
Research Evidence		False	12	module2/research-evidence.php	module2
Action Planning		False	13	module2/action-planning.php	module2
Coping Planning		False	14	module2/coping-planning.php	module2

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pages	ALL					10	100.00	Using where; Using filesort

file	function	line
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/php/modulelibrary.php	query()	22
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php	require()	3

005

SELECT
pageURL, pageTitle, pageId
FROM
pages
WHERE
pageSection = 'module1' AND pageOrder < '5' AND pageNavIsHeader = 'False'
ORDER BY
pageOrder DESC
LIMIT
1

execution time: 0.180 ms (15.45%)
returned rows: 1
explain
backtrace
to the top
close all

pageURL	pageTitle	pageId
module1/aerobic-activity.php	Aerobic Exercise	4

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pages	ALL					10	100.00	Using where; Using filesort

file	function	line
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/php/modulelibrary.php	query()	29
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php	require()	3

006

SELECT
pageURL, pageTitle, pageId
FROM
pages
WHERE
pageSection = 'module1' AND pageOrder > '5' AND pageNavIsHeader = 'False'
ORDER BY
pageOrder
LIMIT
1

execution time: 0.160 ms (13.73%)
returned rows: 1
explain
backtrace
to the top
close all

pageURL	pageTitle	pageId
module1/action-planning.php	Action Planning	8

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pages	ALL					10	100.00	Using where; Using filesort

file	function	line
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/php/modulelibrary.php	query()	35
/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php	require()	3

001	The "memcache" extension is available on you server - consider using memcache for caching query results. See the documentation for more information. to the top close all

001	$_POST array ( )

001	$_GET array ( )

001	$_SESSION array ( )

001	$_FILES array ( )

001

$_SERVER

array (
'PATH' => '/sbin:/usr/sbin:/bin:/usr/bin',
'PP_CUSTOM_PHP_INI' => '/var/www/vhosts/system/sciactioncanada.ca/etc/php.ini',
'PP_CUSTOM_PHP_CGI_INDEX' => '2',
'SCRIPT_NAME' => '/training/module1/strength-training.php',
'REQUEST_URI' => '/training/module1/strength-training',
'QUERY_STRING' => '',
'REQUEST_METHOD' => 'GET',
'SERVER_PROTOCOL' => 'HTTP/1.0',
'GATEWAY_INTERFACE' => 'CGI/1.1',
'REDIRECT_URL' => '/training/module1/strength-training',
'REMOTE_PORT' => '57856',
'SCRIPT_FILENAME' => '/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php',
'SERVER_ADMIN' => 'domain-admins@thedunhamgroup.com',
'DOCUMENT_ROOT' => '/var/www/vhosts/sciactioncanada.ca/httpdocs',
'REMOTE_ADDR' => '54.198.147.79',
'SERVER_PORT' => '80',
'SERVER_ADDR' => '64.34.159.65',
'SERVER_NAME' => 'sciactioncanada.ca',
'SERVER_SOFTWARE' => 'Apache',
'SERVER_SIGNATURE' => '<address>Apache Server at sciactioncanada.ca Port 80</address>
',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_USER_AGENT' => 'CCBot/2.0 (http://commoncrawl.org/faq/)',
'HTTP_ACCEPT_ENCODING' => 'x-gzip, gzip, deflate',
'HTTP_CONNECTION' => 'close',
'HTTP_X_ACCEL_INTERNAL' => '/internal-nginx-static-location',
'HTTP_X_FORWARDED_FOR' => '54.198.147.79',
'HTTP_X_REAL_IP' => '54.198.147.79',
'HTTP_HOST' => 'sciactioncanada.ca',
'REDIRECT_STATUS' => '200',
'REDIRECT_PP_CUSTOM_PHP_CGI_INDEX' => '2',
'REDIRECT_PP_CUSTOM_PHP_INI' => '/var/www/vhosts/system/sciactioncanada.ca/etc/php.ini',
'FCGI_ROLE' => 'RESPONDER',
'PHP_SELF' => '/training/module1/strength-training.php',
'REQUEST_TIME_FLOAT' => 1498423415.06429,
'REQUEST_TIME' => 1498423415,
)

6 / 0