| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Config`.`id`, `Config`.`namespace`, `Config`.`config_key`, `Config`.`config_value`, `Config`.`description`, `Config`.`is_public`, `Config`.`created`, `Config`.`modified` FROM `nysprofiles_preview`.`configurations` AS `Config` WHERE `Config`.`namespace` = 'app' AND `Config`.`config_key` = 'forceSSL' LIMIT 1 | 0 | 0 | 2 | maybe slow |
| SELECT `Config`.`id`, `Config`.`namespace`, `Config`.`config_key`, `Config`.`config_value`, `Config`.`description`, `Config`.`is_public`, `Config`.`created`, `Config`.`modified` FROM `nysprofiles_preview`.`configurations` AS `Config` WHERE `Config`.`namespace` = 'app' AND `Config`.`config_key` = 'maintenance' LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`elevate_id`, `User`.`username`, `User`.`password`, `User`.`token`, `User`.`token_expires`, `User`.`is_deleted`, `User`.`auth_type`, `User`.`invalid_logins`, `User`.`dn`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`first_name`, `Profile`.`last_name`, `Profile`.`created`, `Profile`.`modified`, (CONCAT(`Profile`.`first_name`, " ", `Profile`.`last_name`)) AS `Profile__full_name` FROM `nysprofiles_preview`.`users` AS `User` LEFT JOIN `nysprofiles_preview`.`groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `nysprofiles_preview`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Config`.`id`, `Config`.`namespace`, `Config`.`config_key`, `Config`.`config_value`, `Config`.`description`, `Config`.`is_public`, `Config`.`created`, `Config`.`modified` FROM `nysprofiles_preview`.`configurations` AS `Config` WHERE `Config`.`namespace` = 'app' AND `Config`.`config_key` = 'forceSSL' LIMIT 1 | 0 | 0 | 5 | maybe slow |
| SELECT `Config`.`id`, `Config`.`namespace`, `Config`.`config_key`, `Config`.`config_value`, `Config`.`description`, `Config`.`is_public`, `Config`.`created`, `Config`.`modified` FROM `nysprofiles_preview`.`configurations` AS `Config` WHERE `Config`.`namespace` = 'app' AND `Config`.`config_key` = 'maintenance' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `User`.`id`, `User`.`group_id`, `User`.`elevate_id`, `User`.`username`, `User`.`password`, `User`.`token`, `User`.`token_expires`, `User`.`is_deleted`, `User`.`auth_type`, `User`.`invalid_logins`, `User`.`dn`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified`, `Profile`.`id`, `Profile`.`user_id`, `Profile`.`first_name`, `Profile`.`last_name`, `Profile`.`created`, `Profile`.`modified`, (CONCAT(`Profile`.`first_name`, " ", `Profile`.`last_name`)) AS `Profile__full_name` FROM `nysprofiles_preview`.`users` AS `User` LEFT JOIN `nysprofiles_preview`.`groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) LEFT JOIN `nysprofiles_preview`.`profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE 1 = 1 LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT DISTINCT `EntityAttribute`.`value` FROM `nysprofiles_preview`.`entity_hospital_attributes` AS `EntityAttribute` WHERE `attribute` LIKE 'Regional Office' ORDER BY `value` ASC | 7 | 7 | 8 | maybe slow |
| SELECT DISTINCT EntityType.county_fips, county_name FROM `nysprofiles_preview`.`entity_hospitals` AS `EntityType` WHERE county_fips is not null AND county_name is not null ORDER BY `EntityType`.`county_name` ASC | 58 | 58 | 3 | maybe slow |
| SELECT DATE_FORMAT(Enforcement.period_start,'%M %e, %Y') as period_start, DATE_FORMAT(Enforcement.period_end,'%M %e, %Y') as period_end FROM `nysprofiles_preview`.`enforcements` AS `Enforcement` WHERE `Enforcement`.`entity_type` = 'hospital' LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT DISTINCT `Enforcement`.`entity_id` FROM `nysprofiles_preview`.`enforcements` AS `Enforcement` WHERE entity_type = 'hospital' | 23 | 23 | 2 | maybe slow |
| SELECT `EntityHospital`.`entity_id`, `EntityHospital`.`name`, `EntityHospital`.`aka`, `EntityHospital`.`city` FROM `nysprofiles_preview`.`entity_hospitals` AS `EntityHospital` WHERE `EntityHospital`.`entity_id` IN (103027, 103087, 102953, 103061, 102974, 102933, 102937, 103082, 102970, 106809, 103014, 103024, 103084, 102973, 102916, 103062, 103045, 103069, 103008, 102990, 102906, 102935, 102941) AND `EntityHospital`.`closed_date` IS NULL ORDER BY IF(`EntityHospital`.`aka` IS NULL,`EntityHospital`.`name`,`EntityHospital`.`aka`) ASC | 23 | 23 | 2 | maybe slow |
| SELECT `Attributes`.`attribute_id`, `Attributes`.`entity_id`, `Attributes`.`attribute`, `Attributes`.`value`, `Attributes`.`created`, `Attributes`.`modified`, `Attributes`.`source` FROM `nysprofiles_preview`.`entity_hospital_attributes` AS `Attributes` WHERE `Attributes`.`entity_id` IN (102974, 103024, 103062, 102973, 103014, 102970, 103008, 103027, 106809, 102937, 102953, 102916, 102933, 102941, 102990, 103069, 103045, 103084, 102906, 102935, 103087, 103061, 103082) | 1341 | 1341 | 25 | |
| SELECT `EntityClinic`.`entity_id`, `EntityClinic`.`entity_hospital_id`, `EntityClinic`.`local_id`, `EntityClinic`.`type`, `EntityClinic`.`name`, `EntityClinic`.`aka`, `EntityClinic`.`address`, `EntityClinic`.`city`, `EntityClinic`.`state`, `EntityClinic`.`state_fips`, `EntityClinic`.`zipcode`, `EntityClinic`.`county_name`, `EntityClinic`.`county_fips`, `EntityClinic`.`phone_number`, `EntityClinic`.`closed_date`, `EntityClinic`.`created`, `EntityClinic`.`modified` FROM `nysprofiles_preview`.`entity_clinics` AS `EntityClinic` WHERE `EntityClinic`.`entity_hospital_id` IN (102974, 103024, 103062, 102973, 103014, 102970, 103008, 103027, 106809, 102937, 102953, 102916, 102933, 102941, 102990, 103069, 103045, 103084, 102906, 102935, 103087, 103061, 103082) ORDER BY `EntityClinic`.`name` ASC | 355 | 355 | 10 | |
