SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:13:56
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 10  Lock_time: 0  Rows_sent: 1191307  Rows_examined: 1191307
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:14:07
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 9  Lock_time: 0  Rows_sent: 258841  Rows_examined: 258841
SELECT /*!40001 SQL_NO_CACHE */ * FROM `sessions`;
# Time: 091112 18:14:44
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 6  Lock_time: 0  Rows_sent: 603732  Rows_examined: 603732
use sensire_s;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:14:56
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 12  Lock_time: 0  Rows_sent: 1068438  Rows_examined: 1068438
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:16:18
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 17  Lock_time: 0  Rows_sent: 1822689  Rows_examined: 1822689
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:16:28
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 10  Lock_time: 0  Rows_sent: 1113903  Rows_examined: 1113903
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:17:37
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 19  Lock_time: 0  Rows_sent: 1631168  Rows_examined: 1631168
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:17:49
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 11  Lock_time: 0  Rows_sent: 951103  Rows_examined: 951103
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:19:31
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 7  Lock_time: 0  Rows_sent: 747129  Rows_examined: 747129
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:19:49
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 17  Lock_time: 0  Rows_sent: 1904679  Rows_examined: 1904679
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:21:34
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 59  Lock_time: 0  Rows_sent: 5013829  Rows_examined: 5013829
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:21:54
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 20  Lock_time: 0  Rows_sent: 1634467  Rows_examined: 1634467
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:22:58
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 5  Lock_time: 0  Rows_sent: 634683  Rows_examined: 634683
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:23:58
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 5  Lock_time: 0  Rows_sent: 444697  Rows_examined: 444697
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:24:34
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 7  Lock_time: 0  Rows_sent: 669623  Rows_examined: 669623
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:26:18
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 27  Lock_time: 0  Rows_sent: 2727395  Rows_examined: 2727395
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:26:28
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 10  Lock_time: 0  Rows_sent: 859164  Rows_examined: 859164
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:27:50
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 29  Lock_time: 0  Rows_sent: 2607634  Rows_examined: 2607634
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 18:27:59
# User@Host: admin[admin] @ db1 [10.0.0.1]
# Query_time: 9  Lock_time: 0  Rows_sent: 766241  Rows_examined: 766241
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 18:30:39
# User@Host: user_1[user_1] @ rails1 [10.0.1.3]
# Query_time: 6  Lock_time: 0  Rows_sent: 0  Rows_examined: 1648536
SELECT * FROM `clients` WHERE (1=1 
                              AND clients.valid_from < '2009-12-05' AND (clients.valid_to IS NULL or clients.valid_to > '2009-11-20')
                               AND clients.index > 0
                              ) AND (clients.deleted_at IS NULL);
# Time: 091112 20:15:16
# User@Host: user_2[user_2] @ rails1 [10.0.1.3]
# Query_time: 7  Lock_time: 0  Rows_sent: 796074  Rows_examined: 796074
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 20:15:29
# User@Host: user_2[user_2] @ rails1 [10.0.1.3]
# Query_time: 12  Lock_time: 0  Rows_sent: 1191307  Rows_examined: 1191307
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 20:15:45
# User@Host: user_2[user_2] @ rails1 [10.0.1.3]
# Query_time: 12  Lock_time: 0  Rows_sent: 259350  Rows_examined: 259350
SELECT /*!40001 SQL_NO_CACHE */ * FROM `sessions`;
# Time: 091112 20:18:50
# User@Host: user_1[user_1] @ rails1 [10.0.1.3]
# Query_time: 28  Lock_time: 0  Rows_sent: 2727404  Rows_examined: 2727404
use zuwe_p;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `clients`;
# Time: 091112 20:19:18
# User@Host: user_1[user_1] @ rails1 [10.0.1.3]
# Query_time: 28  Lock_time: 0  Rows_sent: 859164  Rows_examined: 859164
SELECT /*!40001 SQL_NO_CACHE */ * FROM `events`;
# Time: 091112 20:19:40
# User@Host: user_1[user_1] @ db1 [10.1.1.178]
# Query_time: 6  Lock_time: 0  Rows_sent: 33  Rows_examined: 1648542
SELECT * FROM `clients` WHERE (valid_to IS NULL OR valid_to > '2009-12-12') AND ((`clients`.`deleted` = 1) AND (clients.deleted_at IS NULL));