View difference between Paste ID: M9tceDWP and HcZ4NhMn

--- http://localhost:4000/api/v1/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]]
 
-SELECT DISTINCT "mv_stat_declarations".* FROM "mv_stat_declarations" WHERE ("mv_stat_declarations"."legal_entity_id" = 3228) AND "mv_stat_declarations"."declaration_status_code" = $1  [["declaration_status_code", "ACTIVE"]]
+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]]
- SELECT "mv_stat_patient_personalities".* FROM "mv_stat_patient_personalities" WHERE "mv_stat_patient_personalities"."id" IN ($1, $2, $3, $4, $5)  [["id", 11395822], ["id", 11395824], ["id", 11464974], ["id", 11464976], ["id", 11464994]]
+
 View::MvStatistic::Level1::Patient Load (0.4ms)
-SELECT "mv_stat_employees_parties".* FROM "mv_stat_employees_parties" WHERE "mv_stat_employees_parties"."Id" IN ($1, $2)  [["Id", 180499], ["Id", 181286]]
+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]]
 
-SELECT MAX(receptions.patient_id) as patient_id, COUNT(DISTINCT receptions.patient_id) as counter FROM "receptions" WHERE ("receptions"."ehealth_status" = 1) AND "receptions"."asserted_date" BETWEEN $1 AND $2 AND "receptions"."patient_id" IN ($3, $4, $5, $6, $7) GROUP BY date(asserted_date), patient_id  [["asserted_date", "2024-01-01 00:00:00"], ["asserted_date", "2024-02-02 23:59:59.999999"], ["patient_id", 11395822], ["patient_id", 11395824], ["patient_id", 11464974], ["patient_id", 11464976], ["patient_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]]
-SELECT "mv_stat_imt_diseases".* FROM "mv_stat_imt_diseases" WHERE "mv_stat_imt_diseases"."asserted_date" BETWEEN $1 AND $2 AND "mv_stat_imt_diseases"."patient_id" IN ($3, $4, $5, $6, $7)  [["asserted_date", "2024-01-01 00:00:00"], ["asserted_date", "2024-02-02 23:59:59.999999"], ["patient_id", 11395822], ["patient_id", 11395824], ["patient_id", 11464974], ["patient_id", 11464976], ["patient_id", 11464994]]
+
 View::MvStatistic::Level0::Reception Load (2.3ms)
-SELECT "mv_stat_conditions".* FROM "mv_stat_conditions" WHERE "mv_stat_conditions"."asserted_date" BETWEEN $1 AND $2 AND "mv_stat_conditions"."patient_id" IN ($3, $4, $5, $6, $7)  [["asserted_date", "2024-01-01 00:00:00"], ["asserted_date", "2024-02-02 23:59:59.999999"], ["patient_id", 11395822], ["patient_id", 11395824], ["patient_id", 11464974], ["patient_id", 11464976], ["patient_id", 11464994]]
+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)