hostgroup debug.txt - Foreman

Bug #13004 » hostgroup debug.txt

Chris Pisano, 01/13/2016 09:20 AM

 -01-13 08:16:32 [app] [D] Cache read: https://atxentlfor-d01.advisory.com/hosts/process_hostgroup?
 -01-13 08:16:32 [app] [I]
+       |
        | Started POST "/hosts/process_hostgroup" for 10.10.153.104 at 2016-01-13 08:16:32 -0600
 -01-13 08:16:32 [app] [I] Processing by HostsController#process_hostgroup as */*
 -01-13 08:16:32 [app] [I]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"6CX3PeBY+sfx8Vp091r+p/59sMPYTMUkv/OPSnC9OcU=", "host"=>{"name"=>"foremanbug", "organization_id"=>"3", "location_id"=>"4", "hostgroup_id"=>"92", "compute_resource_id"=>"", "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "interfaces_attributes"=>{"0"=>{"_destroy"=>"0", "type"=>"Nic::Managed", "mac"=>"", "identifier"=>"", "name"=>"foremanbug", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "managed"=>"1", "primary"=>"1", "provision"=>"1", "execution"=>"1", "virtual"=>"0", "tag"=>"", "attached_to"=>""}, "new_interfaces"=>{"_destroy"=>"1", "type"=>"Nic::Managed", "mac"=>"", "identifier"=>"", "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "managed"=>"1", "primary"=>"0", "provision"=>"0", "execution"=>"0", "virtual"=>"0", "tag"=>"", "attached_to"=>""}}, "architecture_id"=>"", "provision_method"=>"build", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"33-Users", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "fakepassword"=>"[FILTERED]"}
 -01-13 08:16:32 [sql] [D]   User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 33]]
 -01-13 08:16:32 [app] [D] Setting current user thread-local variable to pisanoc
 -01-13 08:16:32 [app] [D] Cache read: authorize_login_delegation
 -01-13 08:16:32 [app] [D] Cache read: authorize_login_delegation
 -01-13 08:16:32 [app] [D] Cache read: idle_timeout
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
 -01-13 08:16:32 [app] [D] Setting current organization thread-local variable to none
 -01-13 08:16:32 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
 -01-13 08:16:32 [app] [D] Setting current location thread-local variable to none
 -01-13 08:16:32 [sql] [D]   AuthSource Load (0.6ms)  SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 5 LIMIT 1
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT 1
 -01-13 08:16:32 [sql] [D]   Organization Load (0.6ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" = 3 ORDER BY title LIMIT 1
 -01-13 08:16:32 [sql] [D]   Location Load (0.5ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" = 4 ORDER BY title LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = '92' ORDER BY hostgroups.title LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY hostgroups.title LIMIT 1  [["id", "92"]]
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.7ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (architecture_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Architecture Load (0.5ms)  SELECT "architectures".* FROM "architectures" WHERE "architectures"."id" = 1 LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (1.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (operatingsystem_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Operatingsystem Load (0.6ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 5 ORDER BY title LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.7ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (environment_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Environment Load (0.5ms)  SELECT "environments".* FROM "environments" WHERE "environments"."id" = 3 ORDER BY environments.name LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.7ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (domain_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Domain Load (0.5ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.7ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (subnet_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Subnet Load (0.6ms)  SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = 7 ORDER BY vlanid LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (compute_profile_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   ComputeProfile Load (0.5ms)  SELECT "compute_profiles".* FROM "compute_profiles" WHERE "compute_profiles"."id" = 1 ORDER BY compute_profiles.name LIMIT 1
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (realm_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Realm Load (0.5ms)  SELECT "realms".* FROM "realms" WHERE "realms"."id" IS NULL ORDER BY realms.name LIMIT 1
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = '92' ORDER BY hostgroups.title LIMIT 1
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY hostgroups.title LIMIT 1  [["id", "92"]]
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (puppet_proxy_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.8ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (puppet_ca_proxy_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (environment_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (compute_profile_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (realm_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   User Load (0.6ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1  [["id", 33]]
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = 92 ORDER BY hostgroups.title LIMIT 1
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (domain_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (operatingsystem_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (architecture_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.7ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (medium_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (ptable_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (subnet_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [app] [I]   Rendered hosts/_progress.html.erb (0.2ms)
 -01-13 08:16:32 [app] [D] Setting current organization thread-local variable to ent
 -01-13 08:16:32 [app] [D] Setting current location thread-local variable to austin
 -01-13 08:16:32 [sql] [D]   Taxonomy Load (0.5ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   Taxonomy Load (0.5ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]    (0.9ms)  SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "smart_proxies"."id" IN (5, 6, 3, 4) AND "features"."name" IN ('Puppet')
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.8ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
 -01-13 08:16:32 [sql] [D]   Organization Load (0.6ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') ORDER BY title
 -01-13 08:16:32 [sql] [D]   Location Load (0.5ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.9ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (85, 82, 81, 83, 94, 58, 84, 80, 90, 89, 50, 56, 53, 57, 51, 92, 97, 65, 86, 52, 96, 91) AND (1=1) ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'ComputeResource' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'ComputeResource' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'ComputeResource' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'ComputeResource' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   ComputeResource Load (0.5ms)  SELECT "compute_resources".* FROM "compute_resources" WHERE "compute_resources"."id" IN (1) AND (1=1) ORDER BY compute_resources.name
 -01-13 08:16:32 [sql] [D]    (0.7ms)  SELECT COUNT(DISTINCT "compute_profiles"."id") FROM "compute_profiles" LEFT OUTER JOIN "compute_attributes" ON "compute_attributes"."compute_profile_id" = "compute_profiles"."id" WHERE (compute_attributes.id > 0)
 -01-13 08:16:32 [sql] [D]   SQL (0.8ms)  SELECT "compute_profiles"."id" AS t0_r0, "compute_profiles"."name" AS t0_r1, "compute_profiles"."created_at" AS t0_r2, "compute_profiles"."updated_at" AS t0_r3, "compute_attributes"."id" AS t1_r0, "compute_attributes"."compute_profile_id" AS t1_r1, "compute_attributes"."compute_resource_id" AS t1_r2, "compute_attributes"."name" AS t1_r3, "compute_attributes"."vm_attrs" AS t1_r4, "compute_attributes"."created_at" AS t1_r5, "compute_attributes"."updated_at" AS t1_r6 FROM "compute_profiles" LEFT OUTER JOIN "compute_attributes" ON "compute_attributes"."compute_profile_id" = "compute_profiles"."id" WHERE (compute_attributes.id > 0) ORDER BY compute_profiles.name
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   Environment Load (0.5ms)  SELECT "environments".* FROM "environments" WHERE "environments"."id" IN (6, 3) AND (1=1) ORDER BY name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]    (0.8ms)  SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet CA') AND "smart_proxies"."id" IN (5, 6, 3, 4) AND (1=1)
 -01-13 08:16:32 [sql] [D]   SmartProxy Load (0.8ms)  SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet CA') AND "smart_proxies"."id" IN (5, 6, 3, 4) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]    (0.7ms)  SELECT COUNT(*) FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet') AND "smart_proxies"."id" IN (5, 6, 3, 4) AND (1=1)
 -01-13 08:16:32 [sql] [D]   SmartProxy Load (0.7ms)  SELECT "smart_proxies".* FROM "smart_proxies" INNER JOIN "features_smart_proxies" ON "features_smart_proxies"."smart_proxy_id" = "smart_proxies"."id" INNER JOIN "features" ON "features"."id" = "features_smart_proxies"."feature_id" WHERE "features"."name" IN ('Puppet') AND "smart_proxies"."id" IN (5, 6, 3, 4) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Realm' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Realm' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Realm' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Realm' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "realms" WHERE "realms"."id" IN (NULL)
 -01-13 08:16:32 [sql] [D]    (0.5ms)  SELECT COUNT(*) FROM "config_groups"
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.8ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   ConfigGroup Load (0.7ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   ConfigGroup Load (0.7ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]    (0.7ms)  SELECT "puppetclasses".id FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 25 ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   Puppetclass Load (0.7ms)  SELECT "puppetclasses".* FROM "puppetclasses" INNER JOIN "config_group_classes" ON "puppetclasses"."id" = "config_group_classes"."puppetclass_id" WHERE "config_group_classes"."config_group_id" = 25 ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Environment' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "environments".* FROM "environments" WHERE "environments"."id" = 3 ORDER BY environments.name LIMIT 1
 -01-13 08:16:32 [sql] [D]   Puppetclass Load (1.1ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 ORDER BY puppetclasses.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (37.1ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   ConfigGroup Load (0.6ms)  SELECT "config_groups".* FROM "config_groups" ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   ConfigGroupClass Load (1.0ms)  SELECT "config_group_classes".* FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (20, 26, 21, 24, 4, 22, 18, 17, 9, 25, 13, 6, 23, 19, 16, 15)
 -01-13 08:16:32 [sql] [D]   Puppetclass Load (0.8ms)  SELECT "puppetclasses".* FROM "puppetclasses" WHERE "puppetclasses"."id" IN (523, 525, 517, 521, 505, 519, 506, 518, 504, 522, 508, 501, 520, 502, 454, 503) ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (21.6ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (19.3ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (19.1ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.8ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.5ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.3ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.6ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (19.3ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.6ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.1ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.3ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (19.5ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.5ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.1ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 LIMIT 1  [["id", 50]]
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".* FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_group.html.erb (18.1ms)
 -01-13 08:16:32 [app] [I]   Rendered config_groups/_config_groups_selection.html.erb (538.5ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   Hostgroup Load (1.1ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]    (0.8ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]    (0.7ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]    (0.4ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25)
 -01-13 08:16:32 [app] [I]   Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]    (0.4ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25, 25)
 -01-13 08:16:32 [sql] [D]    (0.4ms)  SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (50, 92)
 -01-13 08:16:32 [sql] [D]   HostgroupClass Load (0.4ms)  SELECT "hostgroup_classes".* FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" = 92
 -01-13 08:16:32 [sql] [D]   Puppetclass Load (0.8ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) ORDER BY puppetclasses.name
 -01-13 08:16:32 [app] [I]   Rendered puppetclasses/_classes_in_groups.html.erb (0.0ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25, 25)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (50, 92)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25, 25)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (50, 92)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25, 25)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (50, 92)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) ORDER BY puppetclasses.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (50, 92)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) ORDER BY puppetclasses.name
 -01-13 08:16:32 [app] [I]   Rendered puppetclasses/_classes.html.erb (12.1ms)
 -01-13 08:16:32 [app] [I]   Rendered puppetclasses/_class_selection.html.erb (656.2ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (1) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (1) AND (1=1)
 -01-13 08:16:32 [sql] [D]   Domain Load (0.5ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" IN (1) AND (1=1) ORDER BY name
 -01-13 08:16:32 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]    (0.3ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (11, 9, 10, 7, 5, 8) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (11, 9, 10, 7, 5, 8) AND (1=1)
 -01-13 08:16:32 [sql] [D]   Subnet Load (0.6ms)  SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" IN (11, 9, 10, 7, 5, 8) AND (1=1) ORDER BY name
 -01-13 08:16:32 [app] [I]   Rendered nic/_base_form.html.erb (31.5ms)
 -01-13 08:16:32 [app] [I]   Rendered nic/_virtual_form.html.erb (1.2ms)
 -01-13 08:16:32 [app] [I]   Rendered nic/_provider_specific_form.html.erb (0.2ms)
 -01-13 08:16:32 [app] [I]   Rendered nic/manageds/_managed.html.erb (35.3ms)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (1) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Domain' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "domains" WHERE "domains"."id" IN (1) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" IN (1) AND (1=1) ORDER BY name
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (11, 9, 10, 7, 5, 8) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" WHERE "subnets"."id" IN (11, 9, 10, 7, 5, 8) AND (1=1)
 -01-13 08:16:32 [sql] [D]   CACHE (0.0ms)  SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" IN (11, 9, 10, 7, 5, 8) AND (1=1) ORDER BY name
 -01-13 08:16:33 [app] [I]   Rendered nic/_base_form.html.erb (26.5ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/_virtual_form.html.erb (1.2ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/_provider_specific_form.html.erb (0.2ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/manageds/_managed.html.erb (30.1ms)
 -01-13 08:16:33 [app] [I]   Rendered hosts/_interfaces.html.erb (67.7ms)
 -01-13 08:16:33 [sql] [D]   Architecture Load (0.7ms)  SELECT "architectures".* FROM "architectures"
 -01-13 08:16:33 [sql] [D]   Operatingsystem Load (0.8ms)  SELECT "operatingsystems".* FROM "operatingsystems" INNER JOIN "architectures_operatingsystems" ON "operatingsystems"."id" = "architectures_operatingsystems"."operatingsystem_id" WHERE "architectures_operatingsystems"."architecture_id" = 1 ORDER BY title
 -01-13 08:16:33 [app] [I]   Rendered common/os_selection/_architecture.html.erb (6.3ms)
 -01-13 08:16:33 [sql] [D]    (0.8ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]    (0.8ms)  SELECT COUNT(*) FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 5 AND "media"."id" IN (NULL) AND (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Medium' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   Medium Load (0.6ms)  SELECT "media".* FROM "media" INNER JOIN "media_operatingsystems" ON "media"."id" = "media_operatingsystems"."medium_id" WHERE "media_operatingsystems"."operatingsystem_id" = 5 AND "media"."id" IN (NULL) AND (1=1) ORDER BY media.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Ptable' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Ptable' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Ptable' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Ptable' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   Ptable Load (1.1ms)  SELECT "templates".* FROM "templates" INNER JOIN "operatingsystems_ptables" ON "templates"."id" = "operatingsystems_ptables"."ptable_id" WHERE "templates"."id" IN (NULL) AND "templates"."type" IN ('Ptable') AND "operatingsystems_ptables"."operatingsystem_id" = 5 ORDER BY templates.name
 -01-13 08:16:33 [app] [I]   Rendered common/os_selection/_operatingsystem.html.erb (47.7ms)
 -01-13 08:16:33 [app] [I]   Rendered hosts/_operating_system.html.erb (61.6ms)
 -01-13 08:16:33 [app] [I]   Rendered hosts/_unattended.html.erb (62.0ms)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50, 92) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 50 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "config_groups".id FROM "config_groups" INNER JOIN "host_config_groups" ON "config_groups"."id" = "host_config_groups"."config_group_id" WHERE "host_config_groups"."host_id" = 92 AND "host_config_groups"."host_type" = 'Hostgroup' ORDER BY config_groups.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "config_group_classes" WHERE "config_group_classes"."config_group_id" IN (25)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT puppetclass_id FROM "hostgroup_classes" WHERE "hostgroup_classes"."hostgroup_id" IN (50, 92)
 -01-13 08:16:33 [sql] [D]    (0.7ms)  SELECT DISTINCT puppetclasses.id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522)
 -01-13 08:16:33 [sql] [D]    (0.6ms)  SELECT DISTINCT puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."type" IN ('VariableLookupKey') AND "lookup_keys"."puppetclass_id" IN (522)
 -01-13 08:16:33 [sql] [D]    (0.6ms)  SELECT DISTINCT environment_classes.puppetclass_id FROM "lookup_keys" INNER JOIN "environment_classes" ON "environment_classes"."puppetclass_lookup_key_id" = "lookup_keys"."id" WHERE "lookup_keys"."type" IN ('PuppetclassLookupKey') AND "environment_classes"."puppetclass_id" IN (522)
 -01-13 08:16:33 [sql] [D]   Puppetclass Load (0.6ms)  SELECT DISTINCT "puppetclasses".* FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 3 AND "puppetclasses"."id" IN (522) AND "puppetclasses"."id" IN (NULL) ORDER BY puppetclasses.name
 -01-13 08:16:33 [app] [I]   Rendered puppetclasses/_class_parameters.html.erb (0.0ms)
 -01-13 08:16:33 [app] [I]   Rendered puppetclasses/_classes_parameters.html.erb (19.0ms)
 -01-13 08:16:33 [app] [I]   Rendered common_parameters/_puppetclass_parameter.html.erb (2.8ms)
 -01-13 08:16:33 [app] [I]   Rendered common_parameters/_puppetclasses_parameters.html.erb (4.6ms)
 -01-13 08:16:33 [sql] [D]   CommonParameter Load (0.6ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('CommonParameter') ORDER BY parameters.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" = 3 ORDER BY title LIMIT 1
 -01-13 08:16:33 [sql] [D]   Taxonomy Load (0.5ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."id" IN (NULL) ORDER BY (case when taxonomies.ancestry is null then 0 else 1 end), taxonomies.ancestry
 -01-13 08:16:33 [sql] [D]   OrganizationParameter Load (0.5ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OrganizationParameter') AND "parameters"."reference_id" = 3 ORDER BY parameters.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" = 4 ORDER BY title LIMIT 1
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."id" IN (NULL) ORDER BY (case when taxonomies.ancestry is null then 0 else 1 end), taxonomies.ancestry
 -01-13 08:16:33 [sql] [D]   LocationParameter Load (0.6ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('LocationParameter') AND "parameters"."reference_id" = 4 ORDER BY parameters.name
 -01-13 08:16:33 [sql] [D]   DomainParameter Load (0.5ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('DomainParameter') AND "parameters"."reference_id" = 1 ORDER BY parameters.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "operatingsystems".* FROM "operatingsystems" WHERE "operatingsystems"."id" = 5 ORDER BY title LIMIT 1
 -01-13 08:16:33 [sql] [D]   OsParameter Load (0.9ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('OsParameter') AND "parameters"."reference_id" = 5 ORDER BY parameters.name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Hostgroup' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   GroupParameter Load (0.5ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 50 ORDER BY parameters.name
 -01-13 08:16:33 [sql] [D]   GroupParameter Load (0.6ms)  SELECT "parameters".* FROM "parameters" WHERE "parameters"."type" IN ('GroupParameter') AND "parameters"."reference_id" = 92 ORDER BY parameters.name
 -01-13 08:16:33 [app] [I]   Rendered common_parameters/_inherited_parameters.html.erb (1.4ms)
 -01-13 08:16:33 [app] [I]   Rendered common_parameters/_parameter.html.erb (1.6ms)
 -01-13 08:16:33 [app] [I]   Rendered common_parameters/_parameters.html.erb (3.7ms)
 -01-13 08:16:33 [sql] [D]    (0.4ms)  SELECT auth_sources.id FROM "auth_sources" WHERE "auth_sources"."type" IN ('AuthSourceHidden')
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]    (0.6ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'User' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'User' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]    (0.4ms)  SELECT id FROM "users" WHERE "users"."admin" = 't'
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'User' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'User' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "users" WHERE "users"."admin" = 't'
 -01-13 08:16:33 [sql] [D]   User Load (155.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" IN (46, 53, 1, 2, 19, 32, 52, 3, 55, 56, 57, 58, 35, 30, 48, 40, 38, 36, 20, 54, 39, 33, 37, 53) AND ("users"."auth_source_id" NOT IN (2)) ORDER BY firstname
 -01-13 08:16:33 [sql] [D]   Usergroup Load (0.9ms)  SELECT "usergroups".* FROM "usergroups" ORDER BY usergroups.name
 -01-13 08:16:33 [sql] [D]   Model Load (0.4ms)  SELECT "models".* FROM "models" ORDER BY models.name
 -01-13 08:16:33 [app] [D] Setting current location thread-local variable to none
 -01-13 08:16:33 [app] [D] Setting current organization thread-local variable to none
 -01-13 08:16:33 [app] [I]   Rendered hosts/_form.html.erb (1127.9ms)
 -01-13 08:16:33 [app] [I] Completed 200 OK in 1200ms (Views: 917.4ms | ActiveRecord: 229.2ms)
 -01-13 08:16:33 [app] [D] Cache read: https://atxentlfor-d01.advisory.com/hosts/interfaces?
 -01-13 08:16:33 [app] [I]
+       |
        | Started POST "/hosts/interfaces" for 10.10.153.104 at 2016-01-13 08:16:33 -0600
 -01-13 08:16:33 [app] [I] Processing by HostsController#interfaces as */*
 -01-13 08:16:33 [app] [I]   Parameters: {"utf8"=>"✓", "authenticity_token"=>"6CX3PeBY+sfx8Vp091r+p/59sMPYTMUkv/OPSnC9OcU=", "host"=>{"name"=>"foremanbug", "organization_id"=>"3", "location_id"=>"4", "hostgroup_id"=>"92", "compute_resource_id"=>"", "config_group_ids"=>[""], "puppetclass_ids"=>[""], "managed"=>"true", "progress_report_id"=>"[FILTERED]", "type"=>"Host::Managed", "interfaces_attributes"=>{"0"=>{"_destroy"=>"0", "type"=>"Nic::Managed", "mac"=>"", "identifier"=>"", "name"=>"foremanbug", "domain_id"=>"1", "subnet_id"=>"7", "ip"=>"", "managed"=>"1", "primary"=>"1", "provision"=>"1", "execution"=>"1", "virtual"=>"0", "tag"=>"", "attached_to"=>""}, "new_interfaces"=>{"_destroy"=>"1", "type"=>"Nic::Managed", "mac"=>"", "identifier"=>"", "name"=>"", "domain_id"=>"", "subnet_id"=>"", "ip"=>"", "managed"=>"1", "primary"=>"0", "provision"=>"0", "execution"=>"0", "virtual"=>"0", "tag"=>"", "attached_to"=>""}}, "architecture_id"=>"1", "operatingsystem_id"=>"5", "provision_method"=>"build", "build"=>"1", "disk"=>"", "root_pass"=>"[FILTERED]", "is_owned_by"=>"33-Users", "enabled"=>"1", "model_id"=>"", "comment"=>"", "overwrite"=>"false"}, "fakepassword"=>"[FILTERED]"}
 -01-13 08:16:33 [sql] [D]   User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 33]]
 -01-13 08:16:33 [app] [D] Setting current user thread-local variable to pisanoc
 -01-13 08:16:33 [app] [D] Cache read: authorize_login_delegation
 -01-13 08:16:33 [app] [D] Cache read: authorize_login_delegation
 -01-13 08:16:33 [app] [D] Cache read: idle_timeout
 -01-13 08:16:33 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
 -01-13 08:16:33 [app] [D] Setting current organization thread-local variable to none
 -01-13 08:16:33 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
 -01-13 08:16:33 [app] [D] Setting current location thread-local variable to none
 -01-13 08:16:33 [sql] [D]   AuthSource Load (0.5ms)  SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 5 LIMIT 1
 -01-13 08:16:33 [sql] [D]    (0.3ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
 -01-13 08:16:33 [sql] [D]    (0.4ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT 1
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."title" = '92' ORDER BY hostgroups.title LIMIT 1
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" = $1 ORDER BY hostgroups.title LIMIT 1  [["id", "92"]]
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.6ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (puppet_proxy_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (puppet_ca_proxy_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (environment_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (compute_profile_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   Hostgroup Load (0.5ms)  SELECT "hostgroups".* FROM "hostgroups" WHERE "hostgroups"."id" IN (50) AND (realm_id is not NULL) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
 -01-13 08:16:33 [sql] [D]   User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY firstname LIMIT 1  [["id", 33]]
 -01-13 08:16:33 [sql] [D]   Domain Load (0.4ms)  SELECT "domains".* FROM "domains" WHERE "domains"."id" = 1 ORDER BY domains.name LIMIT 1
 -01-13 08:16:33 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "domains" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "domains" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   Domain Load (0.4ms)  SELECT "domains".* FROM "domains" WHERE (1=1) ORDER BY name
 -01-13 08:16:33 [sql] [D]    (0.3ms)  SELECT COUNT(*) FROM "subnets" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   Subnet Load (0.5ms)  SELECT "subnets".* FROM "subnets" WHERE (1=1) ORDER BY name
 -01-13 08:16:33 [app] [I]   Rendered nic/_base_form.html.erb (18.2ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/_virtual_form.html.erb (1.4ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/_provider_specific_form.html.erb (0.2ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/manageds/_managed.html.erb (22.2ms)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "domains" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "domains" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "domains".* FROM "domains" WHERE (1=1) ORDER BY name
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT COUNT(*) FROM "subnets" WHERE (1=1)
 -01-13 08:16:33 [sql] [D]   CACHE (0.0ms)  SELECT "subnets".* FROM "subnets" WHERE (1=1) ORDER BY name
 -01-13 08:16:33 [app] [I]   Rendered nic/_base_form.html.erb (12.8ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/_virtual_form.html.erb (1.3ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/_provider_specific_form.html.erb (0.2ms)
 -01-13 08:16:33 [app] [I]   Rendered nic/manageds/_managed.html.erb (16.5ms)
 -01-13 08:16:33 [app] [I]   Rendered hosts/_interfaces.html.erb (41.2ms)
 -01-13 08:16:33 [app] [I]   Rendered hosts/_interfaces_tab.html.erb (41.9ms)
 -01-13 08:16:33 [app] [I] Completed 200 OK in 73ms (Views: 40.7ms | ActiveRecord: 8.3ms)
 -01-13 08:16:33 [app] [D] Cache read: https://atxentlfor-d01.advisory.com/subnets/freeip?
 -01-13 08:16:33 [app] [I]
+       |
        | Started POST "/subnets/freeip" for 10.10.153.104 at 2016-01-13 08:16:33 -0600
 -01-13 08:16:34 [app] [I] Processing by SubnetsController#freeip as JSON
 -01-13 08:16:34 [app] [I]   Parameters: {"subnet_id"=>"7", "host_mac"=>"", "organization_id"=>"3", "location_id"=>"4", "taken_ips"=>["", ""]}
 -01-13 08:16:34 [sql] [D]   User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT 1  [["id", 33]]
 -01-13 08:16:34 [app] [D] Setting current user thread-local variable to pisanoc
 -01-13 08:16:34 [app] [D] Cache read: authorize_login_delegation
 -01-13 08:16:34 [app] [D] Cache read: authorize_login_delegation
 -01-13 08:16:34 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization')
 -01-13 08:16:34 [app] [D] Setting current organization thread-local variable to none
 -01-13 08:16:34 [sql] [D]    (0.4ms)  SELECT COUNT(*) FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location')
 -01-13 08:16:34 [app] [D] Setting current location thread-local variable to none
 -01-13 08:16:34 [sql] [D]   AuthSource Load (0.5ms)  SELECT "auth_sources".* FROM "auth_sources" WHERE "auth_sources"."id" = 5 LIMIT 1
 -01-13 08:16:34 [sql] [D]    (0.3ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') LIMIT 1
 -01-13 08:16:34 [sql] [D]    (0.4ms)  SELECT id FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') LIMIT 1
 -01-13 08:16:34 [sql] [D]   Organization Load (0.4ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."title" = '3' ORDER BY title LIMIT 1
 -01-13 08:16:34 [sql] [D]   Organization Load (0.6ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" = $1 ORDER BY title LIMIT 1  [["id", "3"]]
 -01-13 08:16:34 [sql] [D]   Location Load (0.4ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."title" = '4' ORDER BY title LIMIT 1
 -01-13 08:16:34 [sql] [D]   Location Load (0.6ms)  SELECT "taxonomies".* FROM "taxonomies" WHERE "taxonomies"."type" IN ('Location') AND "taxonomies"."id" = $1 ORDER BY title LIMIT 1  [["id", "4"]]
 -01-13 08:16:34 [app] [D] Setting current organization thread-local variable to ent
 -01-13 08:16:34 [app] [D] Setting current location thread-local variable to austin
 -01-13 08:16:34 [sql] [D]   Taxonomy Load (0.5ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:34 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:34 [sql] [D]    (0.3ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'Subnet' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT subnets.id FROM "subnets"
 -01-13 08:16:34 [sql] [D]   Subnet Load (0.7ms)  SELECT "subnets".* FROM "subnets" WHERE "subnets"."id" = $1 ORDER BY vlanid LIMIT 1  [["id", 7]]
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:34 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:34 [sql] [D]   Taxonomy Load (0.4ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:34 [sql] [D]    (0.5ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 4 or taxonomies.ancestry like '4/%' or taxonomies.ancestry = '4') ORDER BY title
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (4)
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT id FROM "taxonomies" WHERE (taxonomies.id = 3 or taxonomies.ancestry like '3/%' or taxonomies.ancestry = '3') ORDER BY title
 -01-13 08:16:34 [sql] [D]   CACHE (0.0ms)  SELECT DISTINCT taxable_id FROM "taxable_taxonomies" WHERE "taxable_taxonomies"."taxable_type" = 'SmartProxy' AND "taxable_taxonomies"."taxonomy_id" IN (3)
 -01-13 08:16:34 [sql] [D]   SmartProxy Load (0.4ms)  SELECT "smart_proxies".* FROM "smart_proxies" WHERE "smart_proxies"."id" = 3 ORDER BY smart_proxies.name LIMIT 1
 -01-13 08:16:34 [sql] [D] Asking https://atxentwapp-d01.advisory.com:8443 for free IP
 -01-13 08:16:34 [app] [D] Cache read: proxy_request_timeout
 -01-13 08:16:34 [app] [D] Cache read: ssl_certificate
 -01-13 08:16:34 [app] [D] Cache read: ssl_ca_file
 -01-13 08:16:34 [app] [D] Cache read: ssl_priv_key

(2-2/3)

Project

General

Profile

Bug #13004 » hostgroup debug.txt