chronic_diseases/patients SQL

Started GET "/api/v1/chronic_diseases/patients" for ::1 at 2024-02-15 09:49:20 +0200

MainApplication::Dbo::LegalEntity Load (0.7ms)
SELECT "dbo"."LegalEntities".* FROM "dbo"."LegalEntities" WHERE "dbo"."LegalEntities"."Id" = 3228 LIMIT 1

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

View::MvStatistic::Level1::Patient Load (0.6ms)
SELECT "mv_stat_lvl_1_patients".* FROM "mv_stat_lvl_1_patients" WHERE "mv_stat_lvl_1_patients"."id" IN (11395822, 11395824, 11464974, 11464976, 11464994)

View::MvStatistic::Level0::Employee Load (0.5ms)
SELECT "mv_stat_lvl_0_employees".* FROM "mv_stat_lvl_0_employees" WHERE "mv_stat_lvl_0_employees"."id" IN (180499, 181286)

View::MvStatistic::Level0::Reception Load (2.1ms)
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 '2024-01-01 00:00:00' AND '2024-02-15 23:59:59.999999' AND "mv_stat_lvl_0_receptions"."patient_id" IN (11395822, 11395824, 11464974, 11464976, 11464994) GROUP BY date(mv_stat_lvl_0_receptions.asserted_date), mv_stat_lvl_0_receptions.patient_id

View::MvStatistic::Level2::ImtIndex Load (0.5ms)
SELECT "mv_stat_lvl_2_imt_indices".* FROM "mv_stat_lvl_2_imt_indices" WHERE "mv_stat_lvl_2_imt_indices"."asserted_date" BETWEEN '2024-01-01 00:00:00' AND '2024-01-01 00:00:00' AND "mv_stat_lvl_2_imt_indices"."patient_id" IN (11395822, 11395824, 11464974, 11464976, 11464994)

View::MvStatistic::Level1::ReceptionCondition Load (0.6ms)
SELECT "mv_stat_lvl_1_reception_conditions".* FROM "mv_stat_lvl_1_reception_conditions" WHERE "mv_stat_lvl_1_reception_conditions"."asserted_date" BETWEEN '2024-01-01 00:00:00' AND '2024-02-15 23:59:59.999999' AND "mv_stat_lvl_1_reception_conditions"."patient_id" IN (11395822, 11395824, 11464974, 11464976, 11464994)

Completed 200 OK in 31ms (Views: 0.5ms | ActiveRecord: 5.8ms | Allocations: 8496)