INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36',NULL,'2025-05-27 01:58:36',NULL)RETURNING "id"; | 0.51ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 01:58:37','https://chemreg.net/regulations/gmsds-feb20-703.pdf')RETURNING "id"; | 0.83ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 01:58:38','https://chemreg.net/regulations/2-112_gmsds.pdf')RETURNING "id"; | 1.45ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20','2025-05-27 01:59:15','https://chemreg.net/regulations/2-225_gmsds.pdf')RETURNING "id"; | 5.27ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=20','2025-05-27 01:59:39','https://chemreg.net/regulations/2-228_gmsds.pdf')RETURNING "id"; | 2.73ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 01:59:43','https://chemreg.net/regulations/39-1_gmsds.pdf')RETURNING "id"; | 0.82ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','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-123_gmsds.pdf')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; | 1194.90ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36',NULL,'2025-05-27 06:13:28',NULL)RETURNING "id"; | 14.22ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36',NULL,'2025-05-27 06:13:28',NULL)RETURNING "id"; | 0.35ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 06:13:28','https://chemreg.net/regulations/gmsds-feb20-993.pdf')RETURNING "id"; | 1.18ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','https://chemreg.net/search#c6-operator=or&c7-operator=or&c8-operator=or&b_start=0','2025-05-27 06:13:32','https://chemreg.net/regulations/2-112_gmsds.pdf')RETURNING "id"; | 10.85ms | SELECT "regulation"."id", "regulation"."source_id", "regulation"."file_uid", "regulation"."pdf" FROM "regulation" WHERE ("regulation"."pdf" IS NOT NULL) ORDER BY "regulation"."id" DESC; | 47.21ms | 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; | 10.95ms | 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; | 7.51ms | SELECT "relay_log"."id" FROM "relay_log", "regulation" WHERE ("relay_log"."regulation_id" = "regulation"."id"); | 23.46ms | SELECT "topic"."id", "topic"."source_topic" FROM "topic" WHERE ("topic"."id" IS NOT NULL) ORDER BY "topic"."id", "topic"."source_topic"; | 29.56ms | SELECT "subtopic"."id", "subtopic"."source_subtopic" FROM "subtopic" WHERE ("subtopic"."id" IS NOT NULL) ORDER BY "subtopic"."id", "subtopic"."source_subtopic"; | 1.59ms | SELECT "country"."id", "country"."source_country" FROM "country" WHERE ("country"."id" IS NOT NULL) ORDER BY "country"."id", "country"."source_country"; | 3.90ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36',NULL,'2025-05-27 08:31:33',NULL)RETURNING "id"; | 5.59ms | INSERT INTO "search_hit"("user_agent","search_uri","hit_timestamp","hit_uri") VALUES ('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','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/2-127_gmsds.pdf')RETURNING "id"; | 0.45ms | 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; | 220.18ms |
|