# User@Host: observium[observium] @ localhost [] # Query_time: 0.003876 Lock_time: 0.000048 Rows_sent: 0 Rows_examined: **2836** SET timestamp=1441208020; SELECT `device_id` FROM `ports` WHERE `deleted` = '0' AND `ifPhysAddress` = '001ec9943fdd' LIMIT 1;

ALTER TABLE `observium`.`ports` ADD INDEX `ports_ifPhysAddress` USING BTREE(`ifPhysAddress`, `deleted`);

OPTIMIZE TABLE `observium`.`ports`;

Same query, now using index. ;)

Thanks!