Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 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';
Add Comment
Please, Sign In to add comment