search

pdestefanis / ACT

2 stars 0 forks source link

Slow query at http://act-in.idg-rti.org/act_in/stats/assignUnits #63

Closed pdestefanis closed 12 years ago

pdestefanis commented 12 years ago

The queries below (almost 800) are triggered when loading this screen. The delay is becoming noticeable. Can we implement this with JOINs? ("this" seems to be kit location, and kit status)

56 Connect act_in@localhost on 56 Init DB act_in 56 Query SHOW TABLES FROM act_in 56 Query SHOW FULL COLUMNS FROM aros 56 Query SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci' 56 Query SHOW FULL COLUMNS FROM acos 56 Query SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci' 56 Query SHOW FULL COLUMNS FROM aros_acos 56 Query SHOW FULL COLUMNS FROM stats 56 Query SHOW FULL COLUMNS FROM units 56 Query SHOW FULL COLUMNS FROM batches 56 Query SHOW FULL COLUMNS FROM items 56 Query SHOW FULL COLUMNS FROM alerts 56 Query SHOW FULL COLUMNS FROM users 56 Query SHOW FULL COLUMNS FROM roles 56 Query SHOW FULL COLUMNS FROM phones 56 Query SHOW FULL COLUMNS FROM locations 56 Query SHOW FULL COLUMNS FROM patients 56 Query SHOW FULL COLUMNS FROM messagereceiveds 56 Query SHOW FULL COLUMNS FROM approvals 56 Query SHOW FULL COLUMNS FROM approvals_stats 56 Query SHOW FULL COLUMNS FROM messagesents 56 Query SHOW FULL COLUMNS FROM user_roles 56 Query SHOW FULL COLUMNS FROM units_items 56 Query SHOW FULL COLUMNS FROM statuses 56 Query SELECT Aro.id, Aro.parent_id, Aro.model, Aro.foreign_key, Aro.alias FROM aros AS Aro LEFT JOIN aros AS Aro0 ON (Aro.lft <= Aro0.lft AND Aro.rght >= Aro0.rght) WHERE Aro0.model = 'User' AND Aro0.foreign_key = 1 ORDER BY Aro.lft DESC 56 Query SELECT Aco.id, Aco.parent_id, Aco.model, Aco.foreign_key, Aco.alias FROM acos AS Aco LEFT JOIN acos AS Aco0 ON (Aco0.alias = 'controllers') LEFT JOIN acos AS Aco1 ON (Aco1.lft > Aco0.lft AND Aco1.rght < Aco0.rght AND Aco1.alias = 'Stats' AND Aco0.id = Aco1.parent_id) LEFT JOIN acos AS Aco2 ON (Aco2.lft > Aco1.lft AND Aco2.rght < Aco1.rght AND Aco2.alias = 'assignUnits' AND Aco1.id = Aco2.parent_id) WHERE ((Aco.lft <= Aco0.lft AND Aco.rght >= Aco0.rght) OR (Aco.lft <= Aco2.lft AND Aco.rght >= Aco2.rght)) ORDER BY Aco.lft DESC 56 Query SELECT Permission.id, Permission.aro_id, Permission.aco_id, Permission._create, Permission._read, Permission._update, Permission._delete, Aro.id, Aro.parent_id, Aro.model, Aro.foreign_key, Aro.alias, Aro.lft, Aro.rght, Aco.id, Aco.parent_id, Aco.model, Aco.foreign_key, Aco.alias, Aco.lft, Aco.rght FROM aros_acos AS Permission LEFT JOIN aros AS Aro ON (Permission.aro_id = Aro.id) LEFT JOIN acos AS Aco ON (Permission.aco_id = Aco.id) WHERE Permission.aro_id = 3 AND Permission.aco_id IN (3401, 3285, 2993) ORDER BY Aco.lft desc 56 Query SELECT Permission.id, Permission.aro_id, Permission.aco_id, Permission._create, Permission._read, Permission._update, Permission._delete, Aro.id, Aro.parent_id, Aro.model, Aro.foreign_key, Aro.alias, Aro.lft, Aro.rght, Aco.id, Aco.parent_id, Aco.model, Aco.foreign_key, Aco.alias, Aco.lft, Aco.rght FROM aros_acos AS Permission LEFT JOIN aros AS Aro ON (Permission.aro_id = Aro.id) LEFT JOIN acos AS Aco ON (Permission.aco_id = Aco.id) WHERE Permission.aro_id = 1 AND Permission.aco_id IN (3401, 3285, 2993) ORDER BY Aco.lft desc 56 Query SELECT min(created) created from stats st WHERE unit_id=708 56 Query SELECT Stat.id, Stat.status_id FROM stats AS Stat WHERE patient_id =1 AND Stat.created <= '2012-10-18 12:00:39' ORDER BY Stat.created DESC 56 Query SELECT Stat.id, Stat.unit_id FROM stats AS Stat WHERE ((Stat.status_id = 3) OR (Stat.patient_id is not null)) ORDER BY Stat.created DESC 56 Query SELECT Unit.id, Unit.code FROM units AS Unit WHERE Unit.id not in (709,81,74,79) AND Unit.deleted = '' ORDER BY Unit.id desc 56 Query SELECT Unit.id, Unit.code FROM units AS Unit WHERE Unit.id not in (709,81,74,79) AND Unit.deleted = '' ORDER BY Unit.id desc 56 Query SELECT Location.id, Location.name FROM locations AS Location WHERE deleted = 0 AND Location.id IN (45,26,38,66,65,49,48,19,24,57,25,59,61,10,5,16,17,1,6,14,3,9,36,35,39,46,47,41,23,42,43,30,28,64,56,29,62,33,34,52,53,67,40,22,37,58,11,50,55,15,27,60,18,21,20,31,32,44,63,54,68,51) ORDER BY Location.name ASC 56 Query SELECT Patient.id, Patient.number FROM patients AS Patient WHERE consent = 1 ORDER BY Patient.created DESC 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=708 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=707 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=706 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=705 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=704 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=703 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=702 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=701 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=700 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=699 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=698 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=697 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=696 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=695 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=694 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=693 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=692 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=691 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=690 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=689 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=688 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=687 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=686 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=685 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=684 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=683 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=682 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=681 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=680 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=679 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=678 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=677 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=676 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=675 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=674 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=673 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=672 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=671 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=670 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=669 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=668 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=667 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=666 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=665 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=664 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=663 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=662 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=661 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=660 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=659 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=658 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=657 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=656 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=655 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=654 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=653 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=652 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=651 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=650 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=649 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=648 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=647 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=646 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=645 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=644 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=643 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=642 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=641 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=640 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=639 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=638 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=637 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=636 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=635 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=634 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=633 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=632 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=631 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=630 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=629 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=628 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=627 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=626 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=625 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=624 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=623 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=622 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=621 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=620 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=619 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=618 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=617 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=616 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=615 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=614 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=613 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=612 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=611 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=610 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=609 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=608 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=607 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=606 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=605 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=604 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=603 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=602 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=601 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=600 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=599 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=598 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=597 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=596 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=595 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=594 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=593 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=592 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=591 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=590 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=589 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=588 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=587 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=586 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=585 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=584 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=583 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=582 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=581 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=580 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=579 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=578 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=577 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=576 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=575 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=574 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=573 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=572 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=571 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=570 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=569 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=568 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=567 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=566 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=565 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=564 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=563 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=562 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=561 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=560 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=559 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=558 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=557 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=556 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=555 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=554 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=553 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=552 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=551 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=550 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=549 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=548 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=547 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=546 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=545 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=544 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=543 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=542 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=541 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=540 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=539 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=538 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=537 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=536 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=535 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=534 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=533 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=532 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=531 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=530 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=529 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=528 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=527 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=526 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=525 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=524 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=523 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=522 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=521 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=520 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=519 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=518 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=517 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=516 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=515 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=514 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=513 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=512 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=511 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=510 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=509 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=508 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=507 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=506 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=505 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=504 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=503 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=502 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=501 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=500 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=499 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=498 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=497 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=496 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=495 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=494 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=493 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=492 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=491 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=490 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=489 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=488 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=487 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=486 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=485 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=484 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=483 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=482 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=481 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=480 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=479 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=478 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=477 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=476 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=475 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=474 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=473 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=472 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=471 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=470 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=469 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=468 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=467 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=466 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=465 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=464 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=463 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=462 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=461 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=460 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=459 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=458 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=457 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=456 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=455 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=454 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=453 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=452 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=451 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=450 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=449 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=448 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=447 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=446 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=445 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=444 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=443 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=442 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=441 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=440 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=439 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=438 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=437 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=436 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=435 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=434 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=433 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=432 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=431 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=430 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=429 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=428 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=427 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=426 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=425 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=424 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=423 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=422 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=421 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=420 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=419 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=418 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=417 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=416 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=415 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=414 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=413 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=412 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=411 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=410 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=409 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=408 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=407 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=406 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=405 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=404 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=403 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=402 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=401 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=400 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=399 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=398 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=397 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=396 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=395 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=394 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=393 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=392 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=391 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=390 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=389 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=388 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=387 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=386 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=385 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=384 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=383 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=382 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=381 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=380 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=379 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=378 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=377 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=376 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=375 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=374 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=373 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=372 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=371 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=370 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=369 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=368 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=367 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=366 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=365 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=364 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=363 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=362 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=361 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=360 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=359 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=358 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=357 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=356 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=355 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=354 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=353 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=352 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=351 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=350 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=349 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=348 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=347 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=346 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=345 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=344 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=343 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=342 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=341 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=340 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=339 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=338 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=337 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=336 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=335 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=334 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=333 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=332 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=331 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=330 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=329 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=328 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=327 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=326 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=325 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=324 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=323 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=322 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=321 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=320 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=319 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=318 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=317 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=316 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=315 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=314 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=313 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=312 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=311 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=309 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=308 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=307 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=306 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=305 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=304 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=303 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=302 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=301 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=300 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=299 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=298 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=297 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=296 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=295 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=294 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=293 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=292 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=291 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=289 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=287 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=286 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=285 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=284 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=283 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=282 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=281 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=280 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=279 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=278 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=277 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=276 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=275 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=274 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=273 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=272 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=271 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=270 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=269 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=268 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=267 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=266 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=265 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=264 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=263 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=262 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=261 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=260 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=259 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=258 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=257 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=256 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=255 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=254 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=253 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=252 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=251 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=250 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=249 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=248 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=247 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=246 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=245 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=244 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=243 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=242 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=241 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=240 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=239 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=238 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=237 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=236 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=235 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=234 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=233 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=232 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=231 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=230 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=229 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=228 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=227 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=226 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=225 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=224 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=223 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=222 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=221 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=220 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=219 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=218 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=217 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=216 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=215 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=214 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=213 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=212 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=211 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=210 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=209 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=208 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=207 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=206 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=205 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=204 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=203 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=202 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=201 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=200 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=199 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=198 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=197 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=196 56 Query SELECT created, patient_id, location_id, status_id from stats st WHERE unit_id=195 56 Qu

lachko commented 12 years ago

This slowness actually comes from the stats/index page. Queries can be lowered in half if we remove access checks for links on the listing. For example check that user has access to view phone before displaying link to phone. I can just display this link instead of checking for access - in this case if user doesn't have access they will be redirected. There is one more reason for the amount of queries but it is mainly from access checks

lachko commented 12 years ago

With some modifications I lowered the queries to ~500 but if further we remove access checks we get 119 queries and the page loads for ~2.5 seconds

pdestefanis commented 12 years ago

Good enough. If this becomes an issue we will first move it to a faster server