SQL chronic_diseases/patients

MainApplication::Dbo::LegalEntity Load (1.8ms)  SELECT "dbo"."LegalEntities".* FROM "dbo"."LegalEntities" WHERE "dbo"."LegalEntities"."Id" = $1 LIMIT $2  [["Id", 3228], ["LIMIT", 1]]

View::MvStatistic::Level0::Declaration Load (1.0ms)
SELECT DISTINCT "mv_stat_lvl_0_declarations".* FROM "mv_stat_lvl_0_declarations" INNER JOIN "mv_stat_lvl_1_patients" ON "mv_stat_lvl_1_patients"."id" = "mv_stat_lvl_0_declarations"."patient_id" WHERE "mv_stat_lvl_0_declarations"."legal_entity_id" = $1 AND "mv_stat_lvl_0_declarations"."legal_entity_id" = $2  [["legal_entity_id", 3228], ["legal_entity_id", 3228]]

View::MvStatistic::Level1::Patient Load (0.4ms)
SELECT "mv_stat_lvl_1_patients".* FROM "mv_stat_lvl_1_patients" WHERE "mv_stat_lvl_1_patients"."id" IN ($1, $2, $3, $4, $5)  [["id", 11395822], ["id", 11395824], ["id", 11464974], ["id", 11464976], ["id", 11464994]]

View::MvStatistic::Level0::Employee Load (1.1ms)
SELECT "mv_stat_lvl_0_employees".* FROM "mv_stat_lvl_0_employees" WHERE "mv_stat_lvl_0_employees"."id" IN ($1, $2)  [["id", 180499], ["id", 181286]]

View::MvStatistic::Level0::Reception Load (2.3ms)
SELECT mv_stat_lvl_0_receptions.patient_id as patient_id, COUNT(DISTINCT mv_stat_lvl_0_receptions.patient_id) as counter FROM "mv_stat_lvl_0_receptions" WHERE "mv_stat_lvl_0_receptions"."asserted_date" BETWEEN $1 AND $2 AND "mv_stat_lvl_0_receptions"."patient_id" IN ($3, $4, $5, $6, $7) GROUP BY date(mv_stat_lvl_0_receptions.asserted_date), mv_stat_lvl_0_receptions.patient_id  [["asserted_date", "2024-01-01 00:00:00"], ["asserted_date", "2024-02-12 23:59:59.999999"], ["patient_id", 11395822], ["patient_id", 11395824], ["patient_id", 11464974], ["patient_id", 11464976], ["patient_id", 11464994]]

View::MvStatistic::Level2::ImtIndex Load (1.0ms)
SELECT "mv_stat_lvl_2_imt_indices".* FROM "mv_stat_lvl_2_imt_indices" WHERE "mv_stat_lvl_2_imt_indices"."asserted_date" BETWEEN $1 AND $2 AND "mv_stat_lvl_2_imt_indices"."patient_id" IN ($3, $4, $5, $6, $7)  [["asserted_date", "2024-01-01 00:00:00"], ["asserted_date", "2024-02-12 23:59:59.999999"], ["patient_id", 11395822], ["patient_id", 11395824], ["patient_id", 11464974], ["patient_id", 11464976], ["patient_id", 11464994]]

View::MvStatistic::Level1::EhrCondition Load (0.9ms)
SELECT "mv_stat_lvl_1_ehr_conditions".* FROM "mv_stat_lvl_1_ehr_conditions" WHERE "mv_stat_lvl_1_ehr_conditions"."asserted_date" BETWEEN $1 AND $2 AND "mv_stat_lvl_1_ehr_conditions"."patient_id" IN ($3, $4, $5, $6, $7)  [["asserted_date", "2024-01-01 00:00:00"], ["asserted_date", "2024-02-12 23:59:59.999999"], ["patient_id", 11395822], ["patient_id", 11395824], ["patient_id", 11464974], ["patient_id", 11464976], ["patient_id", 11464994]]

Completed 200 OK in 46ms (Views: 0.3ms | ActiveRecord: 14.9ms | Allocations: 11765)