SERVER [
close]:
{
"GDFONTPATH": ".:\/usr\/X11R6\/lib\/X11\/fonts\/TrueType:\/usr\/X11R6\/lib\/X11\/fonts\/truetype:\/usr\/X11R6\/lib\/X11\/fonts\/TTF:\/usr\/share\/fonts\/TrueType:\/usr\/share\/fonts\/truetype:\/usr\/openwin\/lib\/X11\/fonts\/TrueType:\/usr\/X11R6\/lib\/X11\/fonts\/Type1:\/usr\/lib\/X11\/fonts\/Type1:\/usr\/openwin\/lib\/X11\/fonts\/Type1",
"USER": "uid2034720",
"HOME": "\/tmp",
"SCRIPT_NAME": "\/index.php",
"REQUEST_URI": "\/publicity\/2021\/",
"QUERY_STRING": "module=publicity&year=2021",
"REQUEST_METHOD": "GET",
"SERVER_PROTOCOL": "HTTP\/1.1",
"GATEWAY_INTERFACE": "CGI\/1.1",
"REDIRECT_QUERY_STRING": "module=publicity&year=2021",
"REDIRECT_URL": "\/publicity\/2021\/",
"REMOTE_PORT": "51412",
"SCRIPT_FILENAME": "\/data\/a\/6\/a6c68c47-a2c2-44d8-a7bf-63cd789721d4\/cssterchova.sk\/web\/index.php",
"SERVER_ADMIN": "admin@websupport.sk",
"CONTEXT_DOCUMENT_ROOT": "\/data\/a\/6\/a6c68c47-a2c2-44d8-a7bf-63cd789721d4\/cssterchova.sk\/web\/",
"CONTEXT_PREFIX": "",
"REQUEST_SCHEME": "https",
"DOCUMENT_ROOT": "\/data\/a\/6\/a6c68c47-a2c2-44d8-a7bf-63cd789721d4\/cssterchova.sk\/web\/",
"REMOTE_ADDR": "2600:1f28:365:80b0:1810:feb6:58fa:a031",
"SERVER_PORT": "443",
"SERVER_ADDR": "10.31.19.16",
"SERVER_NAME": "www.cssterchova.sk",
"SERVER_SOFTWARE": "Apache",
"SERVER_SIGNATURE": "",
"PATH": "\/usr\/local\/sbin:\/usr\/local\/bin:\/usr\/sbin:\/usr\/bin:\/sbin:\/bin",
"HTTP_MAX_FORWARDS": "7",
"HTTP_X_PHP_REQUESTID": "cf23a854d9e5949b4fe543474f75ca83",
"HTTP_X_PHP_UPSTREAM": "r1-u19-php85-fpm16",
"HTTP_WS_GEO_COUNTRY": "US",
"HTTP_ACCEPT_ENCODING": "zstd, br, gzip",
"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_IF_MODIFIED_SINCE": "Sun, 18 Jan 2026 20:09:24 GMT",
"HTTP_X_PROXY_IP": "10.20.6.1",
"HTTP_HTTPS": "1",
"HTTP_X_FORWARDED_PROTO": "https",
"HTTP_X_FORWARDED_FOR": "2600:1f28:365:80b0:1810:feb6:58fa:a031",
"HTTP_X_REAL_IP": "2600:1f28:365:80b0:1810:feb6:58fa:a031",
"HTTP_HOST": "www.cssterchova.sk",
"proxy-nokeepalive": "1",
"filter-errordocs": "",
"proxy-initial-not-pooled": "1",
"UNIQUE_ID": "agDDeDHnpAj-hszyXb_RHQAAADA",
"GEOIP_COUNTRY_CODE": "US",
"HTTPS": "on",
"REDIRECT_STATUS": "200",
"REDIRECT_filter-errordocs": "",
"REDIRECT_proxy-initial-not-pooled": "1",
"REDIRECT_PHP_ADMIN_VALUES": ";max_execution_time=600;memory_limit=512M;upload_max_filesize=256M;post_max_size=512M",
"REDIRECT_PHP_VALUES": "memcache.prefix_static_key=cVeq06odyCRQ3fjt;memcache.session_prefix_static_key=cVeq06odyCRQ3fjt;mysql.default_socket=\/tmp\/mysql80.sock;mysqli.default_socket=\/tmp\/mysql80.sock;pdo_mysql.default_socket=\/tmp\/mysql80.sock;sys_temp_dir=\/data\/a\/6\/a6c68c47-a2c2-44d8-a7bf-63cd789721d4\/.tmp;upload_tmp_dir=\/data\/a\/6\/a6c68c47-a2c2-44d8-a7bf-63cd789721d4\/.tmp\/upload",
"REDIRECT_UNIQUE_ID": "agDDeDHnpAj-hszyXb_RHQAAADA",
"REDIRECT_GEOIP_COUNTRY_CODE": "US",
"REDIRECT_HTTPS": "on",
"FCGI_ROLE": "RESPONDER",
"PHP_SELF": "\/index.php",
"REQUEST_TIME_FLOAT": 1778434936.2993719577789306640625,
"REQUEST_TIME": 1778434936,
"argv": [
"module=publicity&year=2021"
],
"argc": 1
}
SESSION [
close]:
{
"language": "sk",
"queries": [
"#0: CREATE DATABASE IF NOT EXISTS cssterchova DEFAULT CHARACTER SET = \"utf8\" DEFAULT COLLATE \"utf8_slovak_ci\"",
"#1: SET NAMES 'utf8'",
"#2: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=\"cssterchova\" AND TABLE_TYPE=\"BASE TABLE\"",
"#3: SELECT count(ip) as total FROM blacklist WHERE ip = \"2130706433\"",
"#4: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"#5: SELECT * FROM user_accounts WHERE accesslevel >7",
"#6: SELECT * FROM sessions WHERE session = \"c66b3eaefb4fdb68cdea14338bfda257\"",
"#7: SELECT title, symbol, intro, created FROM documents\r\n\tLEFT JOIN (SELECT ratings.key, COUNT(ratings.ip) as rating_count, SUM(ratings.rating) as rating_value,\r\n\t(SUM(ratings.rating) DIV COUNT(ratings.ip)) as rating FROM ratings GROUP BY `key`) as ratings\r\n\tON documents.id = ratings.key WHERE published = 1 AND (symbol LIKE \"blog-%\") AND symbol NOT LIKE \"%-__\" ORDER BY created DESC LIMIT 0, 8",
"#8: DELETE FROM redirections WHERE timeout < UNIX_TIMESTAMP()",
"#9: SELECT * FROM redirections WHERE oldurl = \"covid-3\""
]
}
SQL [
close]
Query #0, internal ID #1,
0.00044545:
#0: CREATE DATABASE IF NOT EXISTS cssterchova DEFAULT CHARACTER SET = "utf8" DEFAULT COLLATE "utf8_slovak_ci"
Query #1, internal ID #2,
0.00022384:
#1: SET NAMES 'utf8'
Query #2, internal ID #3,
0.00019580:
#2: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="cssterchova" AND TABLE_TYPE="BASE TABLE"
Query #3, internal ID #4,
0.00027611:
#3: SELECT count(ip) as total FROM blacklist WHERE ip = "2130706433"
Query #4, internal ID #5,
0.00014363:
#4: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()
Query #5, internal ID #6,
0.00077119:
#5: SELECT * FROM user_accounts WHERE accesslevel >7
Query #6, internal ID #7,
0.00015696:
#6: SELECT * FROM sessions WHERE session = "c66b3eaefb4fdb68cdea14338bfda257"
Query #7, internal ID #8,
0.00013518:
#7: SELECT title, symbol, intro, created FROM documents
LEFT JOIN (SELECT ratings.key, COUNT(ratings.ip) as rating_count, SUM(ratings.rating) as rating_value,
(SUM(ratings.rating) DIV COUNT(ratings.ip)) as rating FROM ratings GROUP BY `key`) as ratings
ON documents.id = ratings.key WHERE published = 1 AND (symbol LIKE "blog-%") AND symbol NOT LIKE "%-__" ORDER BY created DESC LIMIT 0, 8
