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 | 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 | 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 | 1 | 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 | 1 | |
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 DISTINCT `EntityAttribute`.`value` FROM `nysprofiles_preview`.`entity_nursing_home_attributes` AS `EntityAttribute` WHERE `attribute` LIKE 'Regional Office' ORDER BY `value` ASC | 7 | 7 | 26 | maybe slow |
SELECT DISTINCT EntityType.county_fips, county_name FROM `nysprofiles_preview`.`entity_nursing_homes` AS `EntityType` WHERE county_fips is not null AND county_name is not null ORDER BY `EntityType`.`county_name` ASC | 61 | 61 | 4 | maybe slow |
SELECT `Entity`.`entity_id`, `Entity`.`type`, `Entity`.`created`, `Entity`.`modified`, `EntityType`.`entity_id`, `EntityType`.`mpn_id`, `EntityType`.`local_id`, `EntityType`.`certification`, `EntityType`.`name`, `EntityType`.`aka`, `EntityType`.`address`, `EntityType`.`city`, `EntityType`.`state`, `EntityType`.`state_fips`, `EntityType`.`zipcode`, `EntityType`.`county_name`, `EntityType`.`county_fips`, `EntityType`.`phone_number`, `EntityType`.`operator_name`, `EntityType`.`operator_address`, `EntityType`.`operator_city`, `EntityType`.`operator_state`, `EntityType`.`operator_zip`, `EntityType`.`ownership`, `EntityType`.`aa_mf`, `EntityType`.`aa_cc`, `EntityType`.`aa_sf`, `EntityType`.`aa_ih`, `EntityType`.`geo_lat`, `EntityType`.`geo_long`, `EntityType`.`opened_date`, `EntityType`.`closed_date`, `EntityType`.`created`, `EntityType`.`modified` FROM `nysprofiles_preview`.`entities` AS `Entity` LEFT JOIN `nysprofiles_preview`.`entity_nursing_homes` AS `EntityType` ON (`EntityType`.`entity_id` = `Entity`.`entity_id`) WHERE `Entity`.`entity_id` = 150770 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `EntityValue`.`measure_id`, `EntityValue`.`entity_id`, `EntityValue`.`date_start`, `EntityValue`.`date_end`, `EntityValue`.`source_id`, `EntityValue`.`is_comparator`, `EntityValue`.`is_private`, `EntityValue`.`value`, `EntityValue`.`unit`, `EntityValue`.`numerator`, `EntityValue`.`denominator`, `EntityValue`.`letter_grade`, `EntityValue`.`gpa`, `EntityValue`.`star_rating`, `EntityValue`.`sig_var_state`, `EntityValue`.`sig_var_nation`, `EntityValue`.`sig_change`, `EntityValue`.`std_dev_from_state`, `EntityValue`.`std_dev_from_nation`, `EntityValue`.`std_dev`, `EntityValue`.`lower_ci`, `EntityValue`.`upper_ci`, `EntityValue`.`percentile_nation`, `EntityValue`.`percentile_state`, `EntityValue`.`rank_place_nation`, `EntityValue`.`rank_denominator_nation`, `EntityValue`.`rank_place_state`, `EntityValue`.`rank_denominator_state`, `EntityValue`.`created`, `EntityValue`.`modified`, `EntityValue`.`batch_id` FROM `nysprofiles_preview`.`entity_values` AS `EntityValue` WHERE `EntityValue`.`entity_id` = (150770) | 221 | 221 | 6 | |
SELECT `Entity`.`entity_id`, `Entity`.`type`, `Entity`.`created`, `Entity`.`modified` FROM `nysprofiles_preview`.`entities` AS `Entity` WHERE `Entity`.`entity_id` = 150770 LIMIT 1 | 1 | 1 | 1 | |
SELECT `EntityValue`.`measure_id`, `EntityValue`.`entity_id`, `EntityValue`.`date_start`, `EntityValue`.`date_end`, `EntityValue`.`source_id`, `EntityValue`.`is_comparator`, `EntityValue`.`is_private`, `EntityValue`.`value`, `EntityValue`.`unit`, `EntityValue`.`numerator`, `EntityValue`.`denominator`, `EntityValue`.`letter_grade`, `EntityValue`.`gpa`, `EntityValue`.`star_rating`, `EntityValue`.`sig_var_state`, `EntityValue`.`sig_var_nation`, `EntityValue`.`sig_change`, `EntityValue`.`std_dev_from_state`, `EntityValue`.`std_dev_from_nation`, `EntityValue`.`std_dev`, `EntityValue`.`lower_ci`, `EntityValue`.`upper_ci`, `EntityValue`.`percentile_nation`, `EntityValue`.`percentile_state`, `EntityValue`.`rank_place_nation`, `EntityValue`.`rank_denominator_nation`, `EntityValue`.`rank_place_state`, `EntityValue`.`rank_denominator_state`, `EntityValue`.`created`, `EntityValue`.`modified`, `EntityValue`.`batch_id` FROM `nysprofiles_preview`.`entity_values` AS `EntityValue` WHERE `EntityValue`.`entity_id` = (150770) | 221 | 221 | 5 | |
SELECT `EntityNursingHome`.`entity_id`, `EntityNursingHome`.`mpn_id`, `EntityNursingHome`.`local_id`, `EntityNursingHome`.`certification`, `EntityNursingHome`.`name`, `EntityNursingHome`.`aka`, `EntityNursingHome`.`address`, `EntityNursingHome`.`city`, `EntityNursingHome`.`state`, `EntityNursingHome`.`state_fips`, `EntityNursingHome`.`zipcode`, `EntityNursingHome`.`county_name`, `EntityNursingHome`.`county_fips`, `EntityNursingHome`.`phone_number`, `EntityNursingHome`.`operator_name`, `EntityNursingHome`.`operator_address`, `EntityNursingHome`.`operator_city`, `EntityNursingHome`.`operator_state`, `EntityNursingHome`.`operator_zip`, `EntityNursingHome`.`ownership`, `EntityNursingHome`.`aa_mf`, `EntityNursingHome`.`aa_cc`, `EntityNursingHome`.`aa_sf`, `EntityNursingHome`.`aa_ih`, `EntityNursingHome`.`geo_lat`, `EntityNursingHome`.`geo_long`, `EntityNursingHome`.`opened_date`, `EntityNursingHome`.`closed_date`, `EntityNursingHome`.`created`, `EntityNursingHome`.`modified` FROM `nysprofiles_preview`.`entity_nursing_homes` AS `EntityNursingHome` WHERE `entity_id` = 150770 LIMIT 1 | 1 | 1 | 2 | maybe slow |