Debug
User
{
  id: 4,
  name: org_admin1,
  org_id: 1,
  full_name: OrgAdmin_SubOrg,
  email: ,
  roles: [
    org_admin
  ],
  orgs: [
    2
  ],
  lang: en,
  active: y,
  ldap: ,
  type: user,
  dashboard_id: 1,
  access_token: [
    ,
    565c65e8f2b6096d9f32ec64586d2eb72beeade13097b47b1259c4bea1cc
  ],
  edited_by: Administrator,
  edited_date: 2019-11-04 10:15:27,
  db_table: users,
  db_prefix: ,
  db_id_column: id,
  org_list: 2,
  org_parents: 1
}
Meta
{
  access_token: 565c65e8f2b6096d9f32ec64586d2eb72beeade13097b47b1259c4bea1cc,
  action: collection,
  baseurl: http:\/\/xxx.xxx.xxx.xxx\/open-audit\/,
  collection: summaries,
  current: y,
  debug: false,
  filtered: 13,
  format: screen,
  group: 0,
  groupby: ,
  header: HTTP\/1.1 200 OK,
  id: null,
  ids: 0,
  include: v_summaries_collection,
  limit: 1000,
  offset: 0,
  properties: *,
  query_string: ,
  request_method: GET,
  sort: name,
  sub_resource: ,
  sub_resource_id: 0,
  total: 13,
  timestamp: 2019-11-05 08:22:42,
  timezone: UTC -0500,
  version: 1,
  filter: [
    
  ],
  received_data: [
    
  ],
  query_parameters: [
    
  ],
  heading: Summaries,
  links: {
    self: http:\/\/xxx.xxx.xxx.xxx\/open-audit\/index.php\/summaries,
    first: http:\/\/xxx.xxx.xxx.xxx\/open-audit\/index.php\/summaries,
    last: http:\/\/xxx.xxx.xxx.xxx\/open-audit\/index.php\/summaries,
    next: http:\/\/xxx.xxx.xxx.xxx\/open-audit\/index.php\/summaries,
    prev: http:\/\/xxx.xxx.xxx.xxx\/open-audit\/index.php\/summaries
  },
  data_order: [
    summaries.id,
    summaries.name,
    summaries.org_id,
    summaries.menu_category,
    summaries.menu_display,
    summaries.table,
    summaries.column,
    summaries.extra_columns,
    summaries.edited_by,
    summaries.edited_date,
    org_name,
    count,
    link_execute,
    orgs.id
  ]
}
SQL Queries
Query: SET SESSION sql_mode=""
Time: 0.00014305114746094

Query: SELECT * FROM (`oa_user_sessions`) WHERE `session_id` =  'dd79ed1f334513e4879ff96711a3c9cc' AND `user_agent` =  'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb'
Time: 0.00037193298339844

Query: UPDATE `oa_user_sessions` SET `last_activity` = 1572960159, `user_data` = 'a:4:{s:7:\"user_id\";s:1:\"4\";s:10:\"user_debug\";s:0:\"\";s:15:\"flash:new:error\";s:0:\"\";s:15:\"flash:old:error\";s:0:\"\";}' WHERE `session_id` =  'dd79ed1f334513e4879ff96711a3c9cc'
Time: 0.00032997131347656

Query: UPDATE `oa_user_sessions` SET `last_activity` = 1572960159, `user_data` = 'a:3:{s:7:\"user_id\";s:1:\"4\";s:10:\"user_debug\";s:0:\"\";s:15:\"flash:old:error\";s:0:\"\";}' WHERE `session_id` =  'dd79ed1f334513e4879ff96711a3c9cc'
Time: 0.0002598762512207

Query: SHOW TABLES FROM `openaudit`
Time: 0.0017681121826172

Query: /* m_configuration::load */ SELECT name, value FROM `configuration`
Time: 0.00066995620727539

Query: /* m_configuration::load */ SELECT NOW() as `timestamp`
Time: 0.00017189979553223

Query: /* m_configuration::load */ SELECT TIME_FORMAT(TIMEDIFF(NOW(),CONVERT_TZ(NOW(),@@session.time_zone,'+00:00')),'%H%i') AS `tz`
Time: 0.0001981258392334

Query: /* m_configuration::load */ SELECT count(*) as device_count FROM system
Time: 0.00024199485778809

Query: SHOW COLUMNS FROM `users`
Time: 0.013885974884033

Query: /* M_users::validate */ SELECT * FROM users WHERE users.id = 4
Time: 0.00033307075500488

Query: UPDATE `oa_user_sessions` SET `last_activity` = 1572960159, `user_data` = 'a:4:{s:7:\"user_id\";s:1:\"4\";s:10:\"user_debug\";s:0:\"\";s:15:\"flash:old:error\";s:0:\"\";s:12:\"access_token\";a:2:{i:0;s:0:\"\";i:1;s:60:\"565c65e8f2b6096d9f32ec64586d2eb72beeade13097b47b1259c4bea1cc\";}}' WHERE `session_id` =  'dd79ed1f334513e4879ff96711a3c9cc'
Time: 0.00034880638122559

Query: /* m_users::get_orgs */ SELECT orgs FROM users WHERE id = '4'
Time: 0.00027108192443848

Query: /* M_users::get_orgs */ SELECT * FROM orgs
Time: 0.00024700164794922

Query: /* M_users::get_parent_orgs */ SELECT a.id AS id FROM orgs a, orgs b WHERE b.id = '1' AND a.id = b.parent_id
Time: 0.00026416778564453

Query: /* m_roles::collection */ SELECT * FROM `roles`
Time: 0.00030398368835449

Query: /* m_users::get_user_permission */ SELECT roles FROM users WHERE id = 4
Time: 0.00023889541625977

Query: /* m_roles::collection */ SELECT * FROM `roles`
Time: 0.00026416778564453

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `attributes`
Time: 0.00029993057250977

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `connections`
Time: 0.0002291202545166

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `credentials`
Time: 0.0002140998840332

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `system`
Time: 0.00023484230041504

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `discoveries`
Time: 0.00021004676818848

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `fields`
Time: 0.00020098686218262

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `groups`
Time: 0.00022697448730469

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `licenses`
Time: 0.00021100044250488

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `locations`
Time: 0.00024700164794922

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `networks`
Time: 0.00022792816162109

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `orgs`
Time: 0.00019693374633789

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `queries`
Time: 0.00024104118347168

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `scripts`
Time: 0.00022602081298828

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `summaries`
Time: 0.00021696090698242

Query: /* m_summaries::read_sub_resource */ SELECT COUNT(*) AS `count` FROM `users`
Time: 0.00020289421081543

Query: /* MY_Model::collection_sql */ SELECT COUNT(*) as `count` FROM `summaries` WHERE org_id IN (2)
Time: 0.00026392936706543

Query: /* m_summaries::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (2) OR orgs.id IN (1)) ORDER BY name LIMIT 1000
Time: 0.012403011322021

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT windows.active_directory_ou) AS `count` FROM system LEFT JOIN windows ON (system.id = windows.system_id and windows.current = 'y') WHERE system.org_id IN (2)
Time: 0.00059604644775391

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT class) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00037288665771484

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT status) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00036287307739258

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT type) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00037288665771484

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT dns_domain) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00036287307739258

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT form_factor) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00034999847412109

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT manufacturer) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00034284591674805

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT os_family) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00034904479980469

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT os_name) AS `count` FROM system WHERE `org_id` IN (2)
Time: 0.00034999847412109

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT server.type) AS `count` FROM system LEFT JOIN server ON (system.id = server.system_id and server.current = 'y') WHERE system.org_id IN (2)
Time: 0.00039792060852051

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT service.name) AS `count` FROM system LEFT JOIN service ON (system.id = service.system_id and service.current = 'y') WHERE system.org_id IN (2)
Time: 0.00166916847229

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT software.name) AS `count` FROM system LEFT JOIN software ON (system.id = software.system_id and software.current = 'y') WHERE system.org_id IN (2)
Time: 0.00199294090271

Query: /* m_summaries::collection */ SELECT COUNT(DISTINCT software_key.name) AS `count` FROM system LEFT JOIN software_key ON (system.id = software_key.system_id and software_key.current = 'y') WHERE system.org_id IN (2)
Time: 0.00044393539428711

Query: SHOW COLUMNS FROM `summaries`
Time: 0.012306928634644

Query: /* M_collection::collection_total */ /* m_collection::collection_total */ SELECT COUNT(*) as `count` FROM `summaries` WHERE org_id IN (2)
Time: 0.00025391578674316

Query: /* m_queries::collection */ SELECT queries.*, orgs.name AS `org_name` FROM queries LEFT JOIN orgs ON (queries.org_id = orgs.id) WHERE queries.org_id IN (2) GROUP BY queries.id
Time: 0.00043106079101562

Query: /* m_collection::collection */ SELECT id, name FROM orgs
Time: 0.00022602081298828

Query: /* m_collection::collection */ SELECT id, name FROM locations
Time: 0.00022101402282715

Query: /* MY_Model::collection_sql */ SELECT COUNT(*) as `count` FROM `summaries` WHERE org_id IN (2)
Time: 0.00023484230041504

Query: /* m_collection::collection */ SELECT summaries.*, orgs.name AS `org_name` FROM `summaries` LEFT JOIN orgs ON (`summaries`.org_id = orgs.id) WHERE (orgs.id IN (2) OR orgs.id IN (1)) ORDER BY name LIMIT 1000
Time: 0.012248039245605

Query: /* m_collection::collection */ SELECT id, name FROM orgs
Time: 0.00023698806762695

Query: /* m_collection::collection */ SELECT id, name FROM locations
Time: 0.00021600723266602

Query: /* m_collection::collection */ SELECT dashboards.*, orgs.name AS `org_name` FROM `dashboards` LEFT JOIN orgs ON (`dashboards`.org_id = orgs.id) WHERE orgs.id IN (2)
Time: 0.00031590461730957

Query: /* m_attributes::collection */ SELECT attributes.*, orgs.name AS `org_name` FROM `attributes` LEFT JOIN orgs ON (`attributes`.org_id = orgs.id) WHERE (orgs.id IN (2) OR orgs.id IN (1)) ORDER BY `resource`, `type`, `name`
Time: 0.0018689632415771