PROSAGA码农传奇-MapInfo-优化我的项目的场景对象

<div class =“post-text”itemprop =“text”>
  
    我意识到我的代码运行缓慢的原因是realtimedevicedata表太大（大约120MB并且有50K记录）并且我尝试在选择没有记录之前订购此表。为避免这种情况，我将代码更改为从该表中获取前500条记录，然后对表进行排序。这打破了锁链。
  
  
    感谢所有想要帮助的人，抱歉时间松了。
祝你有美好的一天。
  
  
    SQL更改：
  
  
    老一：
  
   <pre>
 <code>
 $sql = "SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=$devId AND module_id=$modId ORDER BY timestamp desc limit 0,1";

</code>
 </pre>
  
    新的一个：
  
   <pre>
 <code>
 $sql = "SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=$devId AND K.module_id=$modId LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1";

</code>
 </pre>
  
    realtimedevicedata的证明是一个坏女孩：
  
   <pre>
 <code>
 0.02 secs : SELECT * FROM land WHERE user_id=2 AND id=1 UNION SELECT * FROM land WHERE user_id=1 AND id=1
0.11 secs : SELECT mapimage FROM landimages WHERE land_id=1 LIMIT 0,1
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=1 LIMIT 0,1
0.06 secs : SELECT id, name, description, geopos_id FROM sector WHERE land_id=1
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=2 LIMIT 0,1
0.03 secs : SELECT id,scenename,scenedescription,mapitem_id,geopos_id,deviceenum_id,serialNo FROM scenedevices WHERE sector_id=1
0.00 secs : SELECT * FROM mapitems WHERE id=1
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=47 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=6
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=11
0.00 secs : SELECT subid FROM devicedef WHERE module_id='11'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=1
0.15 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=1 AND module_id=11 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=11
0.00 secs : SELECT * FROM mapitems WHERE id=3
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=2 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=4
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=1
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=2
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=3
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='1'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
9.41 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=2 AND module_id=1 ORDER BY timestamp desc limit 0,1
0.01 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=1
0.02 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=1 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=1 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=1 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='2'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
6.84 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=2 AND module_id=2 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=2
0.01 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=2 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=2 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=2 AND specenum_id=18
0.02 secs : SELECT subid FROM devicedef WHERE module_id='3'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
4.44 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=2 AND module_id=3 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=3
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=3 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=3 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=3 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
9.27 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=2 AND module_id=10 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10
0.01 secs : SELECT * FROM mapitems WHERE id=5
0.01 secs : SELECT lat,lng FROM geoposition WHERE id=44 LIMIT 0,1
0.02 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=5
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=4
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='4'
0.02 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=4
0.01 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=4 AND module_id=4 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=4
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=4
0.00 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=4 AND module_id=10 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10
0.00 secs : SELECT * FROM mapitems WHERE id=6
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=45 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=31
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=4
0.00 secs : SELECT subid FROM devicedef WHERE module_id='4'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=5
0.00 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=5 AND module_id=4 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=4
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=3 LIMIT 0,1
0.00 secs : SELECT id,scenename,scenedescription,mapitem_id,geopos_id,deviceenum_id,serialNo FROM scenedevices WHERE sector_id=2
0.00 secs : SELECT * FROM mapitems WHERE id=4
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=3 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=29
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=1
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=2
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=9
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='1'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
4.34 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=3 AND module_id=1 ORDER BY timestamp desc limit 0,1
0.01 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=1
0.03 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=1 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=1 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=1 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='2'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
11.86 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=3 AND module_id=2 ORDER BY timestamp desc limit 0,1
0.02 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=2
0.05 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=2 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=2 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=2 AND specenum_id=18
0.04 secs : SELECT subid FROM devicedef WHERE module_id='9'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
4.25 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=3 AND module_id=9 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=9
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
2.71 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=3 AND module_id=10 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10
0.00 secs : SELECT * FROM mapitems WHERE id=7
0.05 secs : SELECT lat,lng FROM geoposition WHERE id=46 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=5
0.01 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=4
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='4'
0.01 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=6
0.00 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=6 AND module_id=4 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=4
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=6
0.00 secs : SELECT value, timestamp FROM realtimedevicedata WHERE scenedevice_id=6 AND module_id=10 ORDER BY timestamp desc limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10

</code>
 </pre>
  
    现在，她答应我成为一个好女孩:)
  
   <pre>
 <code>
 0.00 secs : SELECT * FROM land WHERE user_id=2 AND id=1 UNION SELECT * FROM land WHERE user_id=1 AND id=1
0.00 secs : SELECT mapimage FROM landimages WHERE land_id=1 LIMIT 0,1
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=1 LIMIT 0,1
0.00 secs : SELECT id, name, description, geopos_id FROM sector WHERE land_id=1
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=2 LIMIT 0,1
0.00 secs : SELECT id,scenename,scenedescription,mapitem_id,geopos_id,deviceenum_id,serialNo FROM scenedevices WHERE sector_id=1
0.00 secs : SELECT * FROM mapitems WHERE id=1
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=47 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=6
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=11
0.00 secs : SELECT subid FROM devicedef WHERE module_id='11'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=1
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=1 AND K.module_id=11 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=11
0.00 secs : SELECT * FROM mapitems WHERE id=3
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=2 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=4
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=1
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=2
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=3
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='1'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=2 AND K.module_id=1 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=1
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=1 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=1 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=1 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='2'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=2 AND K.module_id=2 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=2
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=2 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=2 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=2 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='3'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=2 AND K.module_id=3 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=3
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=3 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=3 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=2 AND module_id=3 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=2
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=2 AND K.module_id=10 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10
0.00 secs : SELECT * FROM mapitems WHERE id=5
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=44 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=5
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=4
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='4'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=4
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=4 AND K.module_id=4 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=4
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=4
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=4 AND K.module_id=10 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10
0.00 secs : SELECT * FROM mapitems WHERE id=6
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=45 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=31
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=4
0.00 secs : SELECT subid FROM devicedef WHERE module_id='4'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=5
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=5 AND K.module_id=4 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=4
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=3 LIMIT 0,1
0.00 secs : SELECT id,scenename,scenedescription,mapitem_id,geopos_id,deviceenum_id,serialNo FROM scenedevices WHERE sector_id=2
0.00 secs : SELECT * FROM mapitems WHERE id=4
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=3 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=29
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=1
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=2
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=9
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='1'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=3 AND K.module_id=1 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=1
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=1 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=1 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=1 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='2'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=3 AND K.module_id=2 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=2
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=2 AND specenum_id=14
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=2 AND specenum_id=15
0.00 secs : SELECT specvalue FROM deviceprefs WHERE scenedevice_id=3 AND module_id=2 AND specenum_id=18
0.00 secs : SELECT subid FROM devicedef WHERE module_id='9'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=3 AND K.module_id=9 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=9
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=3
0.20 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=3 AND K.module_id=10 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10
0.00 secs : SELECT * FROM mapitems WHERE id=7
0.00 secs : SELECT lat,lng FROM geoposition WHERE id=46 LIMIT 0,1
0.00 secs : SELECT module_id FROM devicedef WHERE deviceenum_id=5
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=4
0.00 secs : SELECT id, moduleenum_id, unit FROM module WHERE id=10
0.00 secs : SELECT subid FROM devicedef WHERE module_id='4'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=6
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=6 AND K.module_id=4 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=4
0.00 secs : SELECT subid FROM devicedef WHERE module_id='10'
0.00 secs : SELECT pending_state, desired_state, current_state FROM deviceprefs WHERE scenedevice_id=6
0.00 secs : SELECT value, timestamp FROM (SELECT DISTINCT scenedevice_id, value, timestamp FROM realtimedevicedata AS K WHERE K.scenedevice_id=6 AND K.module_id=10 LIMIT 0,100) AS M ORDER BY M.timestamp desc Limit 0,1
0.00 secs : SELECT `specenum_id`, `editable`, `default` FROM module_specs WHERE module_id=10

</code>
 </pre>
</DIV>