# Query_time: 109.325948  Lock_time: 0.000222 Rows_sent: 1  Rows_examined: 154065
SET timestamp=1332837927;
SELECT core_device_stats.value_num AS core_device_stats_value_num, core_device_stats.value_str AS core_device_stats_value_str, core_device_stats.id AS core_device_stats_id, core_device_stats.date AS core_device_stats_date, core_device_stats.timestamp AS core_device_stats_timestamp, core_device_stats.skey AS core_device_stats_skey, core_device_stats.device_id AS core_device_stats_device_id
FROM core_device_stats
WHERE core_device_stats.skey = 'temperature' AND core_device_stats.device_id = '8' ORDER BY core_device_stats.date DESC
 LIMIT 1;
# User@Host: domogik[domogik] @ localhost [127.0.0.1]
# Query_time: 107.872957  Lock_time: 0.000220 Rows_sent: 1  Rows_examined: 153858
SET timestamp=1332837927;
SELECT core_device_stats.value_num AS core_device_stats_value_num, core_device_stats.value_str AS core_device_stats_value_str, core_device_stats.id AS core_device_stats_id, core_device_stats.date AS core_device_stats_date, core_device_stats.timestamp AS core_device_stats_timestamp, core_device_stats.skey AS core_device_stats_skey, core_device_stats.device_id AS core_device_stats_device_id
FROM core_device_stats
WHERE core_device_stats.skey = 'temperature' AND core_device_stats.device_id = '9' ORDER BY core_device_stats.date DESC
 LIMIT 1;
# User@Host: domogik[domogik] @ localhost [127.0.0.1]
# Query_time: 109.326365  Lock_time: 0.000238 Rows_sent: 1  Rows_examined: 151169
SET timestamp=1332837927;
SELECT core_device_stats.value_num AS core_device_stats_value_num, core_device_stats.value_str AS core_device_stats_value_str, core_device_stats.id AS core_device_stats_id, core_device_stats.date AS core_device_stats_date, core_device_stats.timestamp AS core_device_stats_timestamp, core_device_stats.skey AS core_device_stats_skey, core_device_stats.device_id AS core_device_stats_device_id
FROM core_device_stats
WHERE core_device_stats.skey = 'iinst' AND core_device_stats.device_id = '13' ORDER BY core_device_stats.date DESC
 LIMIT 1;
# User@Host: domogik[domogik] @ localhost [127.0.0.1]
# Query_time: 108.910563  Lock_time: 0.000205 Rows_sent: 1  Rows_examined: 153975
SET timestamp=1332837927;
SELECT core_device_stats.value_num AS core_device_stats_value_num, core_device_stats.value_str AS core_device_stats_value_str, core_device_stats.id AS core_device_stats_id, core_device_stats.date AS core_device_stats_date, core_device_stats.timestamp AS core_device_stats_timestamp, core_device_stats.skey AS core_device_stats_skey, core_device_stats.device_id AS core_device_stats_device_id
FROM core_device_stats
WHERE core_device_stats.skey = 'temperature' AND core_device_stats.device_id = '5' ORDER BY core_device_stats.date DESC
 LIMIT 1;
# Time: 120327 10:45:44
# User@Host: domogik[domogik] @ localhost [127.0.0.1]
# Query_time: 16.135769  Lock_time: 0.000580 Rows_sent: 1  Rows_examined: 151171
SET timestamp=1332837944;
SELECT core_device_stats.value_num AS core_device_stats_value_num, core_device_stats.value_str AS core_device_stats_value_str, core_device_stats.id AS core_device_stats_id, core_device_stats.date AS core_device_stats_date, core_device_stats.timestamp AS core_device_stats_timestamp, core_device_stats.skey AS core_device_stats_skey, core_device_stats.device_id AS core_device_stats_device_id
FROM core_device_stats
WHERE core_device_stats.skey = 'iinst' AND core_device_stats.device_id = '13' ORDER BY core_device_stats.date DESC
 LIMIT 1;
# Time: 120327 10:45:47
# User@Host: domogik[domogik] @ localhost [127.0.0.1]
# Query_time: 19.462918  Lock_time: 0.000220 Rows_sent: 1  Rows_examined: 153975
SET timestamp=1332837947;
SELECT core_device_stats.value_num AS core_device_stats_value_num, core_device_stats.value_str AS core_device_stats_value_str, core_device_stats.id AS core_device_stats_id, core_device_stats.date AS core_device_stats_date, core_device_stats.timestamp AS core_device_stats_timestamp, core_device_stats.skey AS core_device_stats_skey, core_device_stats.device_id AS core_device_stats_device_id
FROM core_device_stats
WHERE core_device_stats.skey = 'temperature' AND core_device_stats.device_id = '5' ORDER BY core_device_stats.date DESC
 LIMIT 1;
# Time: 120327 10:46:17
# User@Host: domogik[domogik] @ localhost [127.0.0.1]
# Query_time: 0.000909  Lock_time: 0.000273 Rows_sent: 1  Rows_examined: 18
SET timestamp=1332837977;
SELECT core_device.id AS core_device_id, core_device.name AS core_device_name, core_device.description AS core_device_description, core_device.address AS core_device_address, core_device.reference AS core_device_reference, core_device.device_usage_id AS core_device_device_usage_id, core_device.device_type_id AS core_device_device_type_id
FROM core_device
WHERE core_device.address = 'teleinfo';