Skip to content

Instantly share code, notes, and snippets.

@TimSimmons

TimSimmons/log.sql

Created March 25, 2015 15:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TimSimmons/e308f470e7b0a2439153 to your computer and use it in GitHub Desktop.
Save TimSimmons/e308f470e7b0a2439153 to your computer and use it in GitHub Desktop.
Download ZIP
axfr log
Raw
log.sql
# Time: 150325 15:18:19
SELECT domains.id, domains.version, domains.created_at, domains.updated_at, domains.deleted, domains.deleted_at, domains.tenant_id, domains.name, domains.email, domains.description, domains.type, domains.transferred_at, domains.ttl, domains.serial, domains.refresh, domains.retry, domains.expire, domains.minimum, domains.status, domains.parent_domain_id, domains.action, domains.pool_id, domains.reverse_name
FROM domains
WHERE domains.name = 'cloddnstest.com.' AND domains.pool_id = '794ccc2cd75144feb57f8894c9f5c842' AND domains.deleted = '0'
LIMIT 2;
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description, recordsets.reverse_name
FROM recordsets
WHERE recordsets.type = 'SOA' AND recordsets.domain_id = 'b3854322bf9b4596ac7b819646a4fcb8' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;
SELECT count(recordsets.id) AS count_1
FROM recordsets INNER JOIN domains ON recordsets.domain_id = domains.id
WHERE domains.deleted = '0' AND recordsets.type = 'SOA' AND recordsets.domain_id = 'b3854322bf9b4596ac7b819646a4fcb8';
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '37fd58fcf87d4791876c08143c4afb19' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT recordsets.id, recordsets.version, recordsets.created_at, recordsets.updated_at, recordsets.tenant_id, recordsets.domain_id, recordsets.name, recordsets.type, recordsets.ttl, recordsets.description, recordsets.reverse_name
FROM recordsets
WHERE recordsets.type != 'SOA' AND recordsets.domain_id = 'b3854322bf9b4596ac7b819646a4fcb8' ORDER BY recordsets.created_at ASC, recordsets.id ASC, recordsets.created_at ASC;
# Time: 150325 15:18:23
SELECT count(recordsets.id) AS count_1
FROM recordsets INNER JOIN domains ON recordsets.domain_id = domains.id
WHERE domains.deleted = '0' AND recordsets.type != 'SOA' AND recordsets.domain_id = 'b3854322bf9b4596ac7b819646a4fcb8';
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '3d76b433ea0c4f3895559ec300f47141' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '4116ff814e7a4985a281404eb5ca31aa' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '44e2a764639146fc81380cc0806f3db1' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '67a04a4964a84bf899206139c173f5aa' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '90e24cf08f184001ba4a27a4e9fe441c' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '9ba17e0c83bf4b34a59b08cae1fec187' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = 'c903d39d7ba9442eab1ce74e3097ec8f' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = 'cd9769e6aec245f2a2c770291e602cdc' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = 'd8f8a08aeb5a42df91506ff58de2a07e' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = 'f89d4dde4de346f187ff79fc0443923b' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '025b6ebea48b425ab725be0b1f6ec205' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '0c30e6fac53a41edb45b6d6baad5a6f6' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '31087174e5bc4af3a5503908aed65161' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '32c7ee6fa5554a27b790a73fce8d9b3d' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '62dfe92e601344f7b883c40ba2df638c' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '653fb1cb3d4b49009b7c5aceb6274359' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '6dcbb1f172d74f6fb2d5d78a271338c5' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = 'a851a327d3c244c38926bb519e656363' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = 'e3c3988b7b7a443bb7cc8d175d3e0772' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '08a19fbb2d9a4733b5108171100620ee' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '10fe33b611564ce78dc4ef4fc95253cc' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '364dd3edd0f64fefa20301f6835002d3' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
WHERE records.recordset_id = '520f2570e54245f68412763459260d26' ORDER BY records.created_at ASC, records.id ASC, records.created_at ASC;
SELECT records.id, records.version, records.created_at, records.updated_at, records.tenant_id, records.domain_id, records.recordset_id, records.data, records.description, records.hash, records.managed, records.managed_extra, records.managed_plugin_type, records.managed_plugin_name, records.managed_resource_type, records.managed_resource_region, records.managed_resource_id, records.managed_tenant_id, records.status, records.action, records.serial
FROM records
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment