Started GET "/hostgroups/46-xms-live/edit" for 127.0.0.1 at Wed Feb 20 13:16:26 +0100 2013
  Processing by HostgroupsController#edit as HTML
  Parameters: {"id"=>"46-xms-live"}
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 5 LIMIT 1
Setting current user thread-local variable to taylan
  Setting Load (0.4ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'authorize_login_delegation' ORDER BY LOWER(settings.name) LIMIT 1
  CACHE (0.0ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'authorize_login_delegation' ORDER BY LOWER(settings.name) LIMIT 1
  Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'idle_timeout' ORDER BY LOWER(settings.name) LIMIT 1
  SQL (0.4ms)  SELECT COUNT(*) FROM `taxonomies` WHERE `taxonomies`.`type` = 'Location'
  Location Load (0.2ms)  SELECT `taxonomies`.* FROM `taxonomies` WHERE `taxonomies`.`type` = 'Location' AND `taxonomies`.`id` = 1 ORDER BY type, name LIMIT 1
Setting current location thread-local variable to US SNN SV6
  SQL (0.2ms)  SELECT id FROM `taxonomies` WHERE `taxonomies`.`type` = 'Location' LIMIT 1
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 46 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) LIMIT 1
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT * FROM `hostgroups` INNER JOIN `user_hostgroups` ON `hostgroups`.id = `user_hostgroups`.hostgroup_id WHERE (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) AND (`user_hostgroups`.user_id = 5 )
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.4ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.2ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (19) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (62) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (34) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 38) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (26) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (30) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (70) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 8) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14, 53) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (14) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (68) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  CACHE (0.0ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` IN (7, 11) AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) ORDER BY (case when hostgroups.ancestry is null then 0 else 1 end), hostgroups.ancestry
  Environment Load (0.4ms)  SELECT `environments`.* FROM `environments` WHERE (environments.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Environment' AND taxonomy_id in (1) ) ) ORDER BY environments.name
  SmartProxy Load (0.2ms)  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` = 'Puppet CA' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) ) ORDER BY LOWER(smart_proxies.name)
  CACHE (0.0ms)  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` = 'Puppet CA' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) ) ORDER BY LOWER(smart_proxies.name)
  SmartProxy Load (0.4ms)  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` = 'Puppet' AND (smart_proxies.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'SmartProxy' AND taxonomy_id in (1) ) ) ORDER BY LOWER(smart_proxies.name)
  Environment Load (0.2ms)  SELECT `environments`.* FROM `environments` WHERE `environments`.`id` = 1 AND (environments.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Environment' AND taxonomy_id in (1) ) ) ORDER BY environments.name LIMIT 1
  Puppetclass Load (0.2ms)  SELECT `puppetclasses`.* FROM `puppetclasses` INNER JOIN `hostgroup_classes` ON `puppetclasses`.id = `hostgroup_classes`.puppetclass_id WHERE ((`hostgroup_classes`.hostgroup_id = 46)) ORDER BY puppetclasses.name
Rendered puppetclasses/_selectedClasses.html.erb (0.0ms)
  Hostgroup Load (0.3ms)  SELECT `hostgroups`.* FROM `hostgroups` WHERE `hostgroups`.`id` = 19 AND (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) ) LIMIT 1
Rendered puppetclasses/_class_selection.html.erb (8.2ms)
Rendered hostgroups/_form.html.erb (1454.9ms)
Rendered hostgroups/edit.html.erb within layouts/application (1457.7ms)
not found: Couldn't find Hostgroup with ID=19 [WHERE (1=1) AND (hostgroups.id in (SELECT taxable_id from taxable_taxonomies WHERE taxable_type = 'Hostgroup' AND taxonomy_id in (1) ) )]
Rendered home/_topbar.rhtml (3.4ms)
Rendered common/404.rhtml within layouts/application (9.9ms)
Completed 404 Not Found in 1628ms (Views: 11.1ms | ActiveRecord: 6.4ms)