[0] +0 s: Start
[0.001] +0.001 s: *** MYSQL select: SELECT * FROM `parameters` WHERE (code ='hours-regular') [numrows:1] {keys:parameters} ***
[0.002] +0.001 s: *** MYSQL select: SELECT * FROM `parameters` WHERE (code ='max_inactivity_limit') [numrows:1] {keys:parameters} ***
[0.002] +0.001 s: *** MYSQL select: SELECT * FROM `parameters` WHERE (code ='hours-regular') [numrows:1] {keys:parameters} ***
[0.003] +0.001 s: *** MYSQL select: SELECT * FROM `seo_pages_tvs` WHERE (code = 'application') [numrows:0] {keys:seo_pages_tvs} ***
[0.004] +0.001 s: *** MYSQL select: SELECT * FROM `seo_pages_tvs` WHERE (code = 'index') [numrows:1] {keys:seo_pages_tvs} ***
[0.005] +0.001 s: *** MYSQL select: SELECT * FROM `parameters` WHERE (code ='signup_fee_cdn') [numrows:1] {keys:parameters} ***
[0.006] +0.001 s: *** MYSQL select: SELECT * FROM `parameters` WHERE (code ='website-active') [numrows:1] {keys:parameters} ***
[0.007] +0.001 s: *** MYSQL select: SELECT * FROM `agreement_history` WHERE (type LIKE '%signup%'
AND origin = 'CAN'
AND id > '0' AND inspection IN ('B', 'Y')) ORDER BY inspection LIMIT 1 [numrows:1] {keys:agreement_history} ***
[0.009] +0.002 s: *** MYSQL select: SELECT tbl_code, tbl_value FROM `misc_tables` WHERE (tbl_group = 'generation' AND tbl_active = 'Y') ORDER BY tbl_order [numrows:11] {keys:misc_tables} ***
[0.01] +0.001 s: *** MYSQL select: SELECT * FROM `provstate` WHERE (country = 'CAN') ORDER BY provstate [numrows:13] {keys:provstate} ***
[0.011] +0.001 s: *** MYSQL select: SELECT * FROM `provstate` WHERE (country = 'CAN') ORDER BY provstate [numrows:13] {keys:provstate} ***
[0.012] +0.001 s: *** MYSQL select: SELECT * FROM `provstate` WHERE (country = 'CAN') ORDER BY provstate [numrows:13] {keys:provstate} ***
[0.013] +0.001 s: *** MYSQL select: SELECT * FROM `provstate` WHERE (country = 'CAN') ORDER BY provstate [numrows:13] {keys:provstate} ***
[0.014] +0.001 s: *** MYSQL select: SELECT tbl_code, tbl_value FROM `misc_tables` WHERE (tbl_group = 'opt_hear' AND tbl_active = 'Y' AND tbl_addit1 like '%CAN%') ORDER BY tbl_order [numrows:20] {keys:misc_tables} ***
[0.014] +0 s: country = can
[0.014] +0 s: country2 = usa
[0.014] +0 s: COUNTRY = CAN
[0.014] +0 s: COUNTRY2 = USA
[0.014] +0 s: Country = Canadian
[0.014] +0 s: Country2 = USA
[0.014] +0 s: country_name = Canada
[0.014] +0 s: country_name2 = USA
[0.016] +0.002 s: *** MYSQL select: SELECT DISTINCT parent FROM `seo_pages_tvs` WHERE (CONCAT('|', menu, '|') LIKE '%|pub|%'
AND security <= '0'
AND active = 'Y'
AND parent <> 0) [numrows:0] {keys:seo_pages_tvs} ***
[0.017] +0.001 s: *** MYSQL select: SELECT * FROM `seo_pages_tvs` WHERE (CONCAT('|', menu, '|') LIKE '%|pub|%'
AND security <= '0'
AND active = 'Y'
AND parent = '0') ORDER BY `order` [numrows:6] {keys:seo_pages_tvs} ***
[0.017] +0 s: Menu: SELECT * FROM `seo_pages_tvs` WHERE (CONCAT('|', menu, '|') LIKE '%|pub|%'
AND security <= '0'
AND active = 'Y'
AND parent = '0') ORDER BY `order`
[0.018] +0 s: End
Current Date and Time: 2024-11-02 17:13:46
Cookie:Array
(
)

Session:Array
(
[sess] => stdClass Object
(
[CANsite] => 1
[isCanadian] => 1
[errsess_page] => page:application[/application.html?site=USA]
[signup_option] => 2
)

)

POST:Array
(
[src] =>
[site] =>
)

GET:Array
(
[src] => application
[site] => USA
)

SERVER:Array
(
[USER] => www-data
[HOME] => /var/www
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[HTTP_X_AMZN_TRACE_ID] => Root=1-672687fa-0974365d799119f71da354af
[HTTP_HOST] => dev.tenantverification.ca
[HTTP_X_FORWARDED_PORT] => 443
[HTTP_X_FORWARDED_PROTO] => https
[HTTP_X_FORWARDED_FOR] => 13.58.199.182
[TVSDOMAIN] => tenantverification
[TVSTLD] => .ca
[SCRIPT_FILENAME] => /var/www/tenantverification/index.php
[REDIRECT_STATUS] => 200
[SERVER_NAME] => centos
[SERVER_PORT] => 80
[SERVER_ADDR] => 10.128.0.6
[REMOTE_PORT] => 27238
[REMOTE_ADDR] => 13.58.199.182
[SERVER_SOFTWARE] => nginx/1.18.0
[GATEWAY_INTERFACE] => CGI/1.1
[REQUEST_SCHEME] => http
[SERVER_PROTOCOL] => HTTP/1.1
[DOCUMENT_ROOT] => /var/www/tenantverification
[DOCUMENT_URI] => /index.php
[REQUEST_URI] => /application.html?site=USA
[SCRIPT_NAME] => /index.php
[CONTENT_LENGTH] =>
[CONTENT_TYPE] =>
[REQUEST_METHOD] => GET
[QUERY_STRING] => src=application&site=USA
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /index.php
[REQUEST_TIME_FLOAT] => 1730578426.4297
[REQUEST_TIME] => 1730578426
)

DBE->USER: