MariaDB [(none)]> show full processlist; +---------+----------+-----------------+----------+---------+--------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +---------+----------+-----------------+----------+---------+--------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 2164963 | librenms | 127.0.0.1:40564 | librenms | Query | 212953 | Updating | UPDATE pollers SET last_polled=NOW(), devices='691', time_taken='1046' WHERE poller_name='ictlibrenmslp01' | 0.000 | | 2165614 | librenms | localhost | librenms | Execute | 213938 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165623 | librenms | localhost | librenms | Execute | 213938 | Updating | update `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? | 0.000 | | 2165631 | librenms | localhost | librenms | Execute | 213939 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165634 | librenms | localhost | librenms | Execute | 213937 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165641 | librenms | localhost | librenms | Execute | 213938 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2165644 | librenms | localhost | librenms | Execute | 213938 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165664 | librenms | localhost | librenms | Execute | 213937 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165697 | librenms | localhost | librenms | Execute | 213935 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165704 | librenms | localhost | librenms | Execute | 213934 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165719 | librenms | localhost | librenms | Execute | 213932 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2165722 | librenms | localhost | librenms | Execute | 213932 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165726 | librenms | localhost | librenms | Execute | 213932 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165753 | librenms | localhost | librenms | Execute | 213929 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2165759 | librenms | localhost | librenms | Execute | 213928 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165760 | librenms | localhost | librenms | Execute | 213929 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165788 | librenms | localhost | librenms | Execute | 213931 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2165812 | librenms | localhost | librenms | Execute | 213926 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165819 | librenms | localhost | librenms | Execute | 213925 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165845 | librenms | localhost | librenms | Execute | 213925 | Updating | UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? | 0.000 | | 2165846 | librenms | localhost | librenms | Execute | 213922 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2165849 | librenms | localhost | librenms | Execute | 213923 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165860 | librenms | localhost | librenms | Execute | 213921 | Updating | UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? | 0.000 | | 2165865 | librenms | localhost | librenms | Execute | 213922 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2165884 | librenms | localhost | librenms | Execute | 213920 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165899 | librenms | localhost | librenms | Execute | 213921 | Updating | UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? | 0.000 | | 2165902 | librenms | localhost | librenms | Execute | 213919 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165916 | librenms | localhost | librenms | Execute | 213918 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2165931 | librenms | localhost | librenms | Execute | 213916 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2165972 | librenms | localhost | librenms | Execute | 213912 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166010 | librenms | localhost | librenms | Execute | 213908 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2166029 | librenms | localhost | librenms | Execute | 213909 | Updating | UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? | 0.000 | | 2166061 | librenms | localhost | librenms | Execute | 213904 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166098 | librenms | localhost | librenms | Execute | 213903 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2166099 | librenms | localhost | librenms | Execute | 213900 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166189 | librenms | localhost | librenms | Execute | 213892 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166191 | librenms | localhost | librenms | Execute | 213890 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166208 | librenms | localhost | librenms | Execute | 213889 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166257 | librenms | localhost | librenms | Execute | 213883 | Updating | UPDATE `cef_switching` set `drop`=?,`punt`=?,`punt2host`=?,`drop_prev`=?,`punt_prev`=?,`punt2host_prev`=?,`updated`=?,`updated_prev`=? WHERE `device_id` = ? AND `entPhysicalIndex` = ? AND `afi` = ? AND `cef_index` = ? | 0.000 | | 2166258 | librenms | localhost | librenms | Execute | 213887 | Updating | UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? | 0.000 | | 2166271 | librenms | localhost | librenms | Execute | 213884 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166274 | librenms | localhost | librenms | Execute | 213883 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166302 | librenms | localhost | librenms | Execute | 213881 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166304 | librenms | localhost | librenms | Execute | 213881 | Updating | UPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166312 | librenms | localhost | librenms | Execute | 213879 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166323 | librenms | localhost | librenms | Execute | 213878 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2166552 | librenms | localhost | librenms | Execute | 213849 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167790 | librenms | localhost | librenms | Execute | 213665 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167792 | librenms | localhost | librenms | Execute | 213656 | Updating | update `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? | 0.000 | | 2167793 | librenms | localhost | librenms | Execute | 213670 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167794 | librenms | localhost | librenms | Execute | 213667 | Updating | update `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? | 0.000 | | 2167796 | librenms | localhost | librenms | Execute | 213643 | Updating | update `hrSystem` set `hrSystemNumUsers` = ?, `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167797 | librenms | localhost | librenms | Execute | 213612 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167798 | librenms | localhost | librenms | Execute | 213619 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167801 | librenms | localhost | librenms | Execute | 213585 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167802 | librenms | localhost | librenms | Execute | 213619 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167803 | librenms | localhost | librenms | Execute | 213665 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167804 | librenms | localhost | librenms | Execute | 213629 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167807 | librenms | localhost | librenms | Execute | 213603 | Updating | update `access_points` set `interference` = ? where `accesspoint_id` = ? | 0.000 | | 2167808 | librenms | localhost | librenms | Execute | 213642 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167811 | librenms | localhost | librenms | Execute | 213633 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167812 | librenms | localhost | librenms | Execute | 213625 | Updating | update `hrSystem` set `hrSystemNumUsers` = ?, `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167813 | librenms | localhost | librenms | Execute | 213617 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167814 | librenms | localhost | librenms | Execute | 213631 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167815 | librenms | localhost | librenms | Execute | 213630 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167816 | librenms | localhost | librenms | Execute | 213608 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167817 | librenms | localhost | librenms | Execute | 213662 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167818 | librenms | localhost | librenms | Execute | 213638 | Updating | UPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? | 0.000 | | 2167819 | librenms | localhost | librenms | Execute | 213622 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167820 | librenms | localhost | librenms | Execute | 213644 | Updating | update `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? | 0.000 | | 2167821 | librenms | localhost | librenms | Execute | 213673 | Updating | update `hrSystem` set `hrSystemNumUsers` = ?, `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167829 | librenms | localhost | librenms | Execute | 213660 | Updating | update `hrSystem` set `hrSystemNumUsers` = ?, `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167832 | librenms | localhost | librenms | Execute | 213647 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167861 | librenms | localhost | librenms | Execute | 213679 | Updating | update `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? | 0.000 | | 2167984 | librenms | localhost | librenms | Execute | 213673 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167988 | librenms | localhost | librenms | Execute | 213673 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167992 | librenms | localhost | librenms | Execute | 213672 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167996 | librenms | localhost | librenms | Execute | 213673 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2167999 | librenms | localhost | librenms | Execute | 213673 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2168002 | librenms | localhost | librenms | Execute | 213672 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2168005 | librenms | localhost | librenms | Execute | 213675 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2168006 | librenms | localhost | librenms | Execute | 213675 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2168007 | librenms | localhost | librenms | Execute | 213669 | Updating | UPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? | 0.000 | | 2168009 | librenms | localhost | librenms | Execute | 213680 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168010 | librenms | localhost | librenms | Execute | 213680 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168011 | librenms | localhost | librenms | Execute | 213680 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168012 | librenms | localhost | librenms | Execute | 213680 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168014 | librenms | localhost | librenms | Execute | 213679 | Updating | UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? | 0.000 | | 2168017 | librenms | localhost | librenms | Execute | 213680 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168021 | librenms | localhost | librenms | Execute | 213679 | Updating | UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? | 0.000 | | 2168022 | librenms | localhost | librenms | Execute | 213679 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168023 | librenms | localhost | librenms | Execute | 213679 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168030 | librenms | localhost | librenms | Execute | 213678 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2168032 | librenms | localhost | librenms | Execute | 213679 | Update | insert into `eventlog` (`reference`, `type`, `datetime`, `severity`, `message`, `username`, `device_id`) values (?, ?, ?, ?, ?, ?, ?) | 0.000 | | 2168171 | librenms | localhost | librenms | Execute | 213640 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2168433 | librenms | localhost | librenms | Execute | 213580 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2168709 | librenms | localhost | librenms | Execute | 213520 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2168961 | librenms | localhost | librenms | Execute | 213460 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2169202 | librenms | localhost | librenms | Execute | 213401 | Update | insert into `cache` (`key`, `value`, `expiration`) values (?, ?, ?) on duplicate key update `key` = values(`key`), `value` = values(`value`), `expiration` = values(`expiration`) | 0.000 | | 2169212 | librenms | localhost | librenms | Execute | 213400 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2169213 | librenms | localhost | librenms | Execute | 213400 | Update | insert into `cache` (`key`, `value`, `expiration`) values (?, ?, ?) on duplicate key update `key` = values(`key`), `value` = values(`value`), `expiration` = values(`expiration`) | 0.000 | | 2169218 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169219 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169220 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169221 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169222 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169223 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169224 | librenms | localhost | librenms | Execute | 213397 | Updating | update `devices` set `last_ping` = ? where `device_id` = ? | 0.000 | | 2169225 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `ip` = ?, `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169226 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169227 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169228 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169229 | librenms | localhost | librenms | Execute | 213396 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169230 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169231 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169232 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169233 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169234 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169235 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169236 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169238 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169239 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169241 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169242 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169245 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169246 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169247 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169249 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169250 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169252 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169253 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `ip` = ?, `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169254 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169255 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169256 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169257 | librenms | localhost | librenms | Execute | 213397 | Updating | update `devices` set `last_ping` = ? where `device_id` = ? | 0.000 | | 2169258 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169259 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169260 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169261 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169262 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169263 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169264 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169265 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169266 | librenms | localhost | librenms | Execute | 213398 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169476 | librenms | localhost | librenms | Execute | 213346 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169477 | librenms | localhost | librenms | Execute | 213346 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169478 | librenms | localhost | librenms | Execute | 213346 | Updating | update `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? | 0.000 | | 2169521 | librenms | localhost | librenms | Execute | 213340 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2170422 | librenms | localhost | librenms | Execute | 213100 | Update | insert into `cache` (`key`, `value`, `expiration`) values (?, ?, ?) on duplicate key update `key` = values(`key`), `value` = values(`value`), `expiration` = values(`expiration`) | 0.000 | | 2178425 | librenms | localhost | librenms | Execute | 212680 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 2183415 | librenms | localhost | librenms | Execute | 212380 | Update | insert into `cache_locks` (`key`, `owner`, `expiration`) values (?, ?, ?) | 0.000 | | 6907649 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +---------+----------+-----------------+----------+---------+--------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ 152 rows in set (0.001 sec)