Strength Training

001

SET
NAMES 'utf8' COLLATE 'utf8_general_ci'

execution time: 0.067 ms (7.07%)
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()	30
/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.217 ms (22.89%)
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.192 ms (20.27%)
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.166 ms (17.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.159 ms (16.78%)
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.147 ms (15.49%)
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' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin',
'PP_CUSTOM_PHP_INI' => '/var/www/vhosts/system/sciactioncanada.ca/etc/php.ini',
'PP_CUSTOM_PHP_CGI_INDEX' => 'plesk-php56-fastcgi',
'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' => '57754',
'SCRIPT_FILENAME' => '/var/www/vhosts/sciactioncanada.ca/httpdocs/training/module1/strength-training.php',
'SERVER_ADMIN' => 'root@localhost',
'CONTEXT_DOCUMENT_ROOT' => '/var/www/vhosts/sciactioncanada.ca/httpdocs',
'CONTEXT_PREFIX' => '',
'REQUEST_SCHEME' => 'http',
'DOCUMENT_ROOT' => '/var/www/vhosts/sciactioncanada.ca/httpdocs',
'REMOTE_ADDR' => '35.172.217.40',
'SERVER_PORT' => '80',
'SERVER_ADDR' => '10.0.1.168',
'SERVER_NAME' => 'sciactioncanada.ca',
'SERVER_SOFTWARE' => 'Apache',
'SERVER_SIGNATURE' => '',
'HTTP_ACCEPT_ENCODING' => 'gzip',
'HTTP_IF_MODIFIED_SINCE' => 'Tue, 15 Oct 2019 13:19:48 UTC',
'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'HTTP_CONNECTION' => 'close',
'HTTP_X_ACCEL_INTERNAL' => '/internal-nginx-static-location',
'HTTP_X_REAL_IP' => '35.172.217.40',
'HTTP_HOST' => 'sciactioncanada.ca',
'PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
'UNIQUE_ID' => 'XerZ5J-LEOD5doXD5dssWgAAAY0',
'REDIRECT_STATUS' => '200',
'REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins',
'REDIRECT_UNIQUE_ID' => 'XerZ5J-LEOD5doXD5dssWgAAAY0',
'FCGI_ROLE' => 'RESPONDER',
'PHP_SELF' => '/training/module1/strength-training.php',
'REQUEST_TIME_FLOAT' => 1575672292.004904,
'REQUEST_TIME' => 1575672292,
)

6 / 0