SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005455 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005455 [ RunTime:0.003651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802626,311508,982786,888871,939287,1016373,346060,334668,493558,896403,279896,639790,858790,872350,849337,890189,718225,66749,126021,573268,366502,2185,814764,1030161,218381,748546,318165,806848,263011,344547,428006,115622,1045566,570965,477763,245786,597475,889498,355769,46414,989910,698074,726244,17733,12362,711851,905336,1040161,855050,236599,603617,309398,964973,960998,188564,792186,326807,223385,108421,120626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]