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\/2022\/", "QUERY_STRING": "module=publicity&year=2022", "REQUEST_METHOD": "GET", "SERVER_PROTOCOL": "HTTP\/1.1", "GATEWAY_INTERFACE": "CGI\/1.1", "REDIRECT_QUERY_STRING": "module=publicity&year=2022", "REDIRECT_URL": "\/publicity\/2022\/", "REMOTE_PORT": "61272", "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:f3f1:a13d:18dd:280b", "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": "8625033d3088b185e7a170dea0a45d4e", "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_X_PROXY_IP": "10.20.6.1", "HTTP_HTTPS": "1", "HTTP_X_FORWARDED_PROTO": "https", "HTTP_X_FORWARDED_FOR": "2600:1f28:365:80b0:f3f1:a13d:18dd:280b", "HTTP_X_REAL_IP": "2600:1f28:365:80b0:f3f1:a13d:18dd:280b", "HTTP_HOST": "www.cssterchova.sk", "proxy-nokeepalive": "1", "filter-errordocs": "", "proxy-initial-not-pooled": "1", "UNIQUE_ID": "aa6At8ADDzJLdHhB6BBwMwAAABY", "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": "aa6At8ADDzJLdHhB6BBwMwAAABY", "REDIRECT_GEOIP_COUNTRY_CODE": "US", "REDIRECT_HTTPS": "on", "FCGI_ROLE": "RESPONDER", "PHP_SELF": "\/index.php", "REQUEST_TIME_FLOAT": 1773043896.0544950962066650390625, "REQUEST_TIME": 1773043896, "argv": [ "module=publicity&year=2022" ], "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 = \"24b26534be1225bfce6f390d3b28e5cd\"", "#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\"" ] }

REQUEST [close]
{ "module": "publicity", "year": "2022" }

SQL [close]
Query #0, internal ID #1, 0.00042479:
#0: CREATE DATABASE IF NOT EXISTS cssterchova DEFAULT CHARACTER SET = "utf8" DEFAULT COLLATE "utf8_slovak_ci"

---

Query #1, internal ID #2, 0.00053777:
#1: SET NAMES 'utf8'

---

Query #2, internal ID #3, 0.00029191:
#2: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="cssterchova" AND TABLE_TYPE="BASE TABLE"

---

Query #3, internal ID #4, 0.00026396:
#3: SELECT count(ip) as total FROM blacklist WHERE ip = "2130706433"

---

Query #4, internal ID #5, 0.00014142:
#4: DELETE FROM sessions WHERE timeout < UNIX_TIMESTAMP()

---

Query #5, internal ID #6, 0.00134118:
#5: SELECT * FROM user_accounts WHERE accesslevel >7

---

Query #6, internal ID #7, 0.00032015:
#6: SELECT * FROM sessions WHERE session = "24b26534be1225bfce6f390d3b28e5cd"

---

Query #7, internal ID #8, 0.00016866:
#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

---