Hello World

/regsaware/default/index

Promotional Banner goes here!

RegsAware

Chemical Industry Regulatory Intelligence

Sign up now!

Welcome to RegsAware!

Promotional Copy

  1. Selling Point 1
  2. Selling Point 2
ajax:
False
application:
regsaware
args:
cid:
None
client:
216.73.216.152
controller:
default
cookies:
env:
CONTEXT_DOCUMENT_ROOT:
/home/w2p/public_html
CONTEXT_PREFIX:
DOCUMENT_ROOT:
/home/w2p/public_html
GATEWAY_INTERFACE:
CGI/1.1
HTTP_ACCEPT:
*/*
HTTP_ACCEPT_ENCODING:
gzip, br, zstd, deflate
HTTP_HOST:
regsaware.com
HTTP_USER_AGENT:
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
PATH_INFO:
/
PATH_TRANSLATED:
/home/w2p/etc/web2py/wsgihandler.py/
QUERY_STRING:
REMOTE_ADDR:
216.73.216.152
REMOTE_PORT:
53564
REQUEST_METHOD:
GET
REQUEST_SCHEME:
https
REQUEST_URI:
/
SCRIPT_FILENAME:
/home/w2p/etc/web2py/wsgihandler.py
SCRIPT_NAME:
SCRIPT_URI:
https://regsaware.com/
SCRIPT_URL:
/
SERVER_ADDR:
178.79.174.242
SERVER_ADMIN:
[no address given]
SERVER_NAME:
regsaware.com
SERVER_PORT:
443
SERVER_PROTOCOL:
HTTP/1.1
SERVER_SIGNATURE:
SERVER_SOFTWARE:
Apache
SSL_TLS_SNI:
regsaware.com
apache.version:
2
4
41
apache_version:
2
4
41
app_folders:
{'/home/w2p/etc/web2py/applications/librarian', '/home/w2p/etc/web2py/applications/regsaware', '/home/w2p/etc/web2py/applications/admin', '/home/w2p/etc/web2py/applications/welcome', '/home/w2p/etc/web2py/applications/tbroker', '/home/w2p/etc/web2py/applications/broker'}
applications_parent:
/home/w2p/etc/web2py
context_document_root:
/home/w2p/public_html
context_prefix:
db_sessions:
set()
debugging:
False
document_root:
/home/w2p/public_html
domain_application:
regsaware
domain_controller:
None
domain_function:
None
gateway_interface:
CGI/1.1
gluon_parent:
/home/w2p/etc/web2py
http_accept:
*/*
http_accept_encoding:
gzip, br, zstd, deflate
http_host:
regsaware.com
http_user_agent:
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
is_jython:
False
is_py2:
False
is_pypy:
False
is_source:
True
local_hosts:
127.0.0.1
::1
thermite.chemreg.net
librarian.chemreg.net
::ffff:127.0.0.1
127.0.1.1
178.79.174.242
mod_wsgi.application_group:
w2p.chemreg.net|
mod_wsgi.callable_object:
application
mod_wsgi.daemon_connects:
1
mod_wsgi.daemon_restarts:
0
mod_wsgi.daemon_start:
1770670624766329
mod_wsgi.enable_sendfile:
0
mod_wsgi.handler_script:
mod_wsgi.ignore_activity:
0
mod_wsgi.listener_host:
mod_wsgi.listener_port:
443
mod_wsgi.path_info:
/
mod_wsgi.process_group:
w2p
mod_wsgi.queue_start:
1770670624766155
mod_wsgi.request_handler:
wsgi-script
mod_wsgi.request_id:
+HeaYcqIscw
mod_wsgi.request_start:
1770670624765944
mod_wsgi.script_name:
mod_wsgi.script_reloading:
1
mod_wsgi.script_start:
1770670624766494
mod_wsgi.thread_id:
3
mod_wsgi.thread_requests:
229
mod_wsgi.total_requests:
560
mod_wsgi.version:
4
6
8
mod_wsgi_application_group:
w2p.chemreg.net|
mod_wsgi_callable_object:
application
mod_wsgi_daemon_connects:
1
mod_wsgi_daemon_restarts:
0
mod_wsgi_daemon_start:
1770670624766329
mod_wsgi_enable_sendfile:
0
mod_wsgi_handler_script:
mod_wsgi_ignore_activity:
0
mod_wsgi_listener_host:
mod_wsgi_listener_port:
443
mod_wsgi_path_info:
/
mod_wsgi_process_group:
w2p
mod_wsgi_queue_start:
1770670624766155
mod_wsgi_request_handler:
wsgi-script
mod_wsgi_request_id:
+HeaYcqIscw
mod_wsgi_request_start:
1770670624765944
mod_wsgi_script_name:
mod_wsgi_script_reloading:
1
mod_wsgi_script_start:
1770670624766494
mod_wsgi_thread_id:
3
mod_wsgi_thread_requests:
229
mod_wsgi_total_requests:
560
mod_wsgi_version:
4
6
8
path_info:
/
path_translated:
/home/w2p/etc/web2py/wsgihandler.py/
query_string:
remote_addr:
216.73.216.152
remote_port:
53564
request_method:
GET
request_scheme:
https
request_uri:
/regsaware/default/index
script_filename:
/home/w2p/etc/web2py/wsgihandler.py
script_name:
script_uri:
https://regsaware.com/
script_url:
/
server_addr:
178.79.174.242
server_admin:
[no address given]
server_name:
regsaware.com
server_port:
443
server_protocol:
HTTP/1.1
server_signature:
server_software:
Apache
ssl_tls_sni:
regsaware.com
web2py_original_uri:
/
web2py_path:
/home/w2p/etc/web2py
web2py_runtime_handler:
True
web2py_version:
2.24.1-stable+timestamp.2023.03.23.05.07.17
wsgi.errors:
<_io.TextIOWrapper name='<wsgi.errors>' encoding='utf-8'>
wsgi.file_wrapper:
<class 'mod_wsgi.FileWrapper'>
wsgi.input:
<mod_wsgi.Input object at 0x7fb2b2342ea0>
wsgi.input_terminated:
True
wsgi.multiprocess:
True
wsgi.multithread:
True
wsgi.run_once:
False
wsgi.url_scheme:
https
wsgi.version:
1
0
wsgi_errors:
<_io.TextIOWrapper name='<wsgi.errors>' encoding='utf-8'>
wsgi_file_wrapper:
<class 'mod_wsgi.FileWrapper'>
wsgi_input:
<mod_wsgi.Input object at 0x7fb2b2342ea0>
wsgi_input_terminated:
True
wsgi_multiprocess:
True
wsgi_multithread:
True
wsgi_run_once:
False
wsgi_url_scheme:
https
wsgi_version:
1
0
extension:
html
folder:
/home/w2p/etc/web2py/applications/regsaware
function:
index
get_vars:
global_settings:
app_folders:
{'/home/w2p/etc/web2py/applications/librarian', '/home/w2p/etc/web2py/applications/regsaware', '/home/w2p/etc/web2py/applications/admin', '/home/w2p/etc/web2py/applications/welcome', '/home/w2p/etc/web2py/applications/tbroker', '/home/w2p/etc/web2py/applications/broker'}
applications_parent:
/home/w2p/etc/web2py
db_sessions:
set()
debugging:
False
gluon_parent:
/home/w2p/etc/web2py
is_jython:
False
is_py2:
False
is_pypy:
False
is_source:
True
local_hosts:
127.0.0.1
::1
thermite.chemreg.net
librarian.chemreg.net
::ffff:127.0.0.1
127.0.1.1
178.79.174.242
web2py_runtime_handler:
True
web2py_version:
2.24.1-stable+timestamp.2023.03.23.05.07.17
is_https:
True
is_local:
False
is_restful:
False
is_scheduler:
False
is_shell:
False
method:
GET
now:
datetime.datetime(2026, 2, 9, 20, 57, 4, 766681)
post_vars:
url:
/
utcnow:
datetime.datetime(2026, 2, 9, 20, 57, 4, 766686)
vars:
wsgi:
<gluon.main.LazyWSGI object at 0x7fb2b2f7f0d0>
Back to top
body:
<_io.StringIO object at 0x7fb2b2b88f70>
cookies:
session_id_regsaware:
216.73.216.152-b584f5fa-792e-4d0e-b7f6-18f23e7c0fb3
comment:
domain:
expires:
httponly:
max-age:
path:
/
samesite:
secure:
version:
delimiters:
{{
}}
files:
/regsaware/static/js/jquery.js
/regsaware/static/css/calendar.css
/regsaware/static/js/calendar.js
/regsaware/static/js/web2py.js
flash:
Hello World
form_label_separator:
formstyle:
bootstrap4_inline
generic_patterns:
*
google_analytics_id:
None
headers:
X-Powered-By:
web2py
menu:
Home
False
/
Features
False
/features
FAQ
False
/faq
Plans
False
/plans
Team
False
/team
About
False
/about
System
False
#
Design
False
/admin/design/regsaware
Controller
False
/admin/edit/regsaware/controllers/default.py
View
False
/admin/edit/regsaware/views/default/index.html
DB Model
False
/admin/edit/regsaware/models/db.py
Menu Model
False
/admin/edit/regsaware/models/menu.py
Config.ini
False
/admin/edit/regsaware/private/appconfig.ini
Layout
False
/admin/edit/regsaware/views/layout.html
Stylesheet
False
/admin/edit/regsaware/static/css/web2py-bootstrap3.css
Database
False
/appadmin
Errors
False
/admin/errors/regsaware
About
False
/admin/about/regsaware
meta:
author:
Philip Kilner <phil@xfr.co.uk>
description:
Regulatory Alerts
generator:
Web2py Web Framework
keywords:
<map object at 0x7fb2b2f7fca0>
models_to_run:
^\w+\.py$
^default/\w+\.py$
^default/index/\w+\.py$
postprocessing:
session_client:
216.73.216.152
session_cookie_compression_level:
None
session_cookie_expires:
None
session_data_name:
session_data_regsaware
session_file:
None
session_filename:
/home/w2p/etc/web2py/applications/regsaware/sessions/216.73.216.152-b584f5fa-792e-4d0e-b7f6-18f23e7c0fb3
session_hash:
af8c96c5e9a768088deb3555c108286d
session_id:
216.73.216.152-b584f5fa-792e-4d0e-b7f6-18f23e7c0fb3
session_id_name:
session_id_regsaware
session_masterapp:
regsaware
session_new:
True
session_storage_type:
file
show_toolbar:
True
status:
200
view:
default/index.html
Back to top
postgres://******@localhost/regsaware2023:
defined:
acc_notification
acc_search
acc_search_assigment
acc_search_portfolio
acc_search_scope
acc_subscription
acc_subscription_alert
account
auth_cas
auth_event
auth_group
auth_membership
auth_permission
auth_user
dist_frequency
invoice
reg_document
regulation
search_distribution
search_portfolio
search_portfolio_term
search_portfolio_term_hit
search_scope
search_scope_subtopic
search_scope_territory
search_scope_topic
search_team
search_team_member
signup
subscription
subtopic
tariff
territory
topic
lazy:
[no lazy tables]
Back to top
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0;
0.17ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0;
0.16ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0;
0.17ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0;
0.16ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 12) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 29) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 82) LIMIT 1 OFFSET 0;
0.69ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0;
0.28ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0;
0.17ms
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic";
0.44ms
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic";
0.23ms
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country";
0.32ms
SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL);
11.29ms
SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0;
12.68ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0;
0.21ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0;
0.20ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0;
0.43ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0;
0.20ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0;
0.18ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 108) LIMIT 1 OFFSET 0;
0.38ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0;
0.27ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0;
0.19ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0;
0.18ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0;
0.17ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0;
0.17ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0;
0.15ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0;
0.18ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0;
0.17ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0;
0.18ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0;
0.20ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0;
0.17ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 12) LIMIT 1 OFFSET 0;
0.15ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 29) LIMIT 1 OFFSET 0;
0.17ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 82) LIMIT 1 OFFSET 0;
0.17ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 51) LIMIT 1 OFFSET 0;
0.17ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 60) LIMIT 1 OFFSET 0;
0.15ms
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic";
0.75ms
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic";
0.34ms
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country";
0.39ms
SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL);
14.19ms
SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0;
14.91ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0;
1.01ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0;
0.33ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0;
0.21ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0;
0.20ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 108) LIMIT 1 OFFSET 0;
0.24ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0;
0.17ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0;
0.18ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0;
0.17ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0;
0.21ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0;
0.17ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0;
0.15ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0;
0.18ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0;
0.20ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0;
0.21ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0;
0.16ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 43) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 12) LIMIT 1 OFFSET 0;
0.14ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 29) LIMIT 1 OFFSET 0;
0.52ms
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic";
9.56ms
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic";
1.52ms
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country";
2.03ms
SELECT COUNT(*) FROM "regulation" WHERE ("regulation"."id" IS NOT NULL);
762.45ms
SELECT "regulation"."source_id", "regulation"."source_topic", "regulation"."source_subtopic", "regulation"."source_country", "regulation"."source_title", "regulation"."source_year", "regulation"."accessed_date", "regulation"."pdf", "regulation"."private", "regulation"."id" FROM "regulation" WHERE ("regulation"."id" IS NOT NULL) ORDER BY "regulation"."private", "regulation"."id" DESC, "regulation"."id" LIMIT 20 OFFSET 0;
15.77ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 6) LIMIT 1 OFFSET 0;
0.79ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 1) LIMIT 1 OFFSET 0;
0.35ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 21) LIMIT 1 OFFSET 0;
0.39ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 1) LIMIT 1 OFFSET 0;
0.57ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 14) LIMIT 1 OFFSET 0;
0.21ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 122) LIMIT 1 OFFSET 0;
0.24ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 3) LIMIT 1 OFFSET 0;
0.24ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 9) LIMIT 1 OFFSET 0;
0.16ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 108) LIMIT 1 OFFSET 0;
0.19ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 52) LIMIT 1 OFFSET 0;
0.17ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 38) LIMIT 1 OFFSET 0;
0.15ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 11) LIMIT 1 OFFSET 0;
0.17ms
SELECT "country"."id", "country"."source_country", "country"."notes", "country"."private" FROM "country" WHERE ("country"."id" = 107) LIMIT 1 OFFSET 0;
0.15ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 36) LIMIT 1 OFFSET 0;
0.40ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 18) LIMIT 1 OFFSET 0;
0.17ms
SELECT "topic"."id", "topic"."source_topic", "topic"."notes", "topic"."private" FROM "topic" WHERE ("topic"."id" = 2) LIMIT 1 OFFSET 0;
0.19ms
SELECT "subtopic"."id", "subtopic"."source_subtopic", "subtopic"."notes", "subtopic"."private" FROM "subtopic" WHERE ("subtopic"."id" = 15) LIMIT 1 OFFSET 0;
0.16ms
SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic";
10.33ms
SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic";
1.81ms
SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country";
1.83ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-02-09 10:46:21','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0',NULL)RETURNING "id";
11.10ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-02-09 10:46:21','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0',NULL)RETURNING "id";
10.23ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-02-09 10:46:21','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0',NULL)RETURNING "id";
0.37ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/14-55_gmsds.pdf','2026-02-09 10:46:21','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";
0.29ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/2-125_gmsds.pdf','2026-02-09 10:46:37','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0&c4=Morrisons+thick+bleach')RETURNING "id";
0.33ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/14-55_gmsds.pdf','2026-02-09 10:46:42','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";
0.44ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/gmsds-july19-272.pdf','2026-02-09 10:47:16','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";
1.92ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/2-124_gmsds.pdf','2026-02-09 10:47:17','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";
11.06ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES (NULL,'2026-02-09 13:07:54','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36',NULL)RETURNING "id";
1.74ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/14-11_gmsds.pdf','2026-02-09 13:07:54','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";
0.80ms
INSERT INTO "search_hit"("hit_uri","hit_timestamp","user_agent","search_uri") VALUES ('https://chemreg.net/regulations/14-1_gmsds.pdf','2026-02-09 13:11:03','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0')RETURNING "id";
0.41ms
Back to top