INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES (NULL,'2025-05-27 01:58:36',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.92ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES (NULL,'2025-05-27 01:58:36',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.32ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 01:58:36','https://chemreg.net/regulations/gmsds-july19-28.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 1.04ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20','2025-05-27 01:59:14','https://chemreg.net/regulations/22-20_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 4.24ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 01:59:44','https://chemreg.net/regulations/17-65_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.39ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 01:59:44','https://chemreg.net/regulations/2-125_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.52ms | SELECT "relay_log"."id", "relay_log"."normalised_filename", "relay_log"."file_uid", "relay_log"."process_status", "regulation"."id", "relay_log"."posted", "relay_log"."post_status_code", "relay_log"."first_seen", "relay_log"."last_seen", "relay_log"."plone_created", "relay_log"."plone_first_modified", "relay_log"."metadata_updated", "relay_log"."metadata_status_code", "relay_log"."pages_processed", "relay_log"."page_count", "relay_log"."html_conversion", "relay_log"."html_conversion_returncode", "relay_log"."html_ping_code", "relay_log"."published" FROM "relay_log", "regulation" WHERE ("relay_log"."regulation_id" = "regulation"."id") ORDER BY "relay_log"."id" DESC; | 462.03ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES (NULL,'2025-05-27 06:13:27',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 11.82ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES (NULL,'2025-05-27 06:13:28',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.46ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES (NULL,'2025-05-27 08:31:33',NULL,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.49ms | INSERT INTO "search_hit"("search_uri","hit_timestamp","hit_uri","user_agent") VALUES ('https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 08:31:35','https://chemreg.net/regulations/14-55_gmsds.pdf','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36')RETURNING "id"; | 0.38ms | SELECT "relay_log"."id", "relay_log"."normalised_filename", "relay_log"."file_uid", "relay_log"."process_status", "regulation"."id", "relay_log"."posted", "relay_log"."post_status_code", "relay_log"."first_seen", "relay_log"."last_seen", "relay_log"."plone_created", "relay_log"."plone_first_modified", "relay_log"."metadata_updated", "relay_log"."metadata_status_code", "relay_log"."pages_processed", "relay_log"."page_count", "relay_log"."html_conversion", "relay_log"."html_conversion_returncode", "relay_log"."html_ping_code", "relay_log"."published" FROM "relay_log", "regulation" WHERE ("relay_log"."regulation_id" = "regulation"."id") ORDER BY "relay_log"."id" DESC; | 39.94ms | SELECT "regulation"."id", "regulation"."source_id", "regulation"."file_uid", "regulation"."pdf" FROM "regulation" WHERE ("regulation"."pdf" IS NOT NULL) ORDER BY "regulation"."id" DESC; | 20.83ms | SELECT "regulation"."id", "regulation"."source_id", "regulation"."file_uid", "regulation"."pdf" FROM "regulation" WHERE (("regulation"."pdf" IS NOT NULL) AND ("regulation"."file_uid" IS NOT NULL)) ORDER BY "regulation"."id" DESC; | 13.88ms | SELECT "regulation"."id", "regulation"."source_id", "regulation"."file_uid", "regulation"."pdf" FROM "regulation" WHERE (("regulation"."pdf" IS NOT NULL) AND ("regulation"."file_uid" IS NULL)) ORDER BY "regulation"."id" DESC; | 10.23ms | SELECT "relay_log"."id" FROM "relay_log", "regulation" WHERE ("relay_log"."regulation_id" = "regulation"."id"); | 5.84ms |
|