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": "\/volne-pracovne-miesta.html",
"QUERY_STRING": "module=document&name=volne-pracovne-miesta",
"REQUEST_METHOD": "GET",
"SERVER_PROTOCOL": "HTTP\/1.1",
"GATEWAY_INTERFACE": "CGI\/1.1",
"REDIRECT_QUERY_STRING": "module=document&name=volne-pracovne-miesta",
"REDIRECT_URL": "\/volne-pracovne-miesta.html",
"REMOTE_PORT": "52796",
"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:6eb8:983:6276:9418",
"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": "a6170d6bb62e5d65a2933be0d66a9340",
"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_WS_CLIENT_PORT": "42634",
"HTTP_X_PROXY_IP": "10.20.6.1",
"HTTP_HTTPS": "1",
"HTTP_X_FORWARDED_PROTO": "https",
"HTTP_X_FORWARDED_FOR": "2600:1f28:365:80b0:6eb8:983:6276:9418",
"HTTP_X_REAL_IP": "2600:1f28:365:80b0:6eb8:983:6276:9418",
"HTTP_HOST": "www.cssterchova.sk",
"proxy-nokeepalive": "1",
"filter-errordocs": "",
"proxy-initial-not-pooled": "1",
"UNIQUE_ID": "ap1cOiYxKp7lmj77iBa5OAAAAHE",
"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": "ap1cOiYxKp7lmj77iBa5OAAAAHE",
"REDIRECT_GEOIP_COUNTRY_CODE": "US",
"REDIRECT_HTTPS": "on",
"FCGI_ROLE": "RESPONDER",
"PHP_SELF": "\/index.php",
"REQUEST_TIME_FLOAT": 1788697659.2213690280914306640625,
"REQUEST_TIME": 1788697659,
"argv": [
"module=document&name=volne-pracovne-miesta"
],
"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: DELETE FROM redirections WHERE timeout < UNIX_TIMESTAMP()",
"#4: SELECT * FROM redirections WHERE oldurl = \"volne-pracovne-miesta\"",
"#5: SELECT count(ip) as total FROM blacklist WHERE ip = \"2130706433\"",
"#6: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"#7: SELECT * FROM user_accounts WHERE accesslevel >7",
"#8: SELECT * FROM sessions WHERE session = \"4dfbefb59c4c1af7092ca2e100f1610e\"",
"#9: SELECT count(ip) as total FROM blacklist WHERE ip = \"2130706433\"",
"#10: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()",
"#11: SELECT * FROM user_accounts WHERE accesslevel >7",
"#12: SELECT * FROM sessions WHERE session = \"4dfbefb59c4c1af7092ca2e100f1610e\"",
"#13: 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",
"#14: DELETE FROM redirections WHERE timeout < UNIX_TIMESTAMP()",
"#15: SELECT * FROM redirections WHERE oldurl = \"covid-3\""
],
"search_query": null
}
SQL [
close]
Query #0, internal ID #1,
0.00068522:
#0: CREATE DATABASE IF NOT EXISTS cssterchova DEFAULT CHARACTER SET = "utf8" DEFAULT COLLATE "utf8_slovak_ci"
Query #1, internal ID #2,
0.00072842:
#1: SET NAMES 'utf8'
Query #2, internal ID #3,
0.00011761:
#2: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="cssterchova" AND TABLE_TYPE="BASE TABLE"
Query #3, internal ID #4,
0.00037353:
#3: DELETE FROM redirections WHERE timeout < UNIX_TIMESTAMP()
Query #4, internal ID #5,
0.00030169:
#4: SELECT * FROM redirections WHERE oldurl = "volne-pracovne-miesta"
Query #5, internal ID #6,
0.00035058:
#5: SELECT count(ip) as total FROM blacklist WHERE ip = "2130706433"
Query #6, internal ID #7,
0.00012066:
#6: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()
Query #7, internal ID #8,
0.00014673:
#7: SELECT * FROM user_accounts WHERE accesslevel >7
Query #8, internal ID #9,
0.00011219:
#8: SELECT * FROM sessions WHERE session = "4dfbefb59c4c1af7092ca2e100f1610e"
Query #9, internal ID #10,
0.00013909:
#9: SELECT count(ip) as total FROM blacklist WHERE ip = "2130706433"
Query #10, internal ID #11,
0.00012489:
#10: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()
Query #11, internal ID #12,
0.00089667:
#11: SELECT * FROM user_accounts WHERE accesslevel >7
Query #12, internal ID #13,
0.00014836:
#12: SELECT * FROM sessions WHERE session = "4dfbefb59c4c1af7092ca2e100f1610e"
Query #13, internal ID #14,
0.00011517:
#13: 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
