SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003649s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301241 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301241 [ RunTime:0.002548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677273,751892,110321,814065,320088,693905,285135,119409,933259,266285,783987,688452,30310,903297,471835,1008968,135469,885893,195800,966025,302273,885476,22487,562700,348467,548032,884451,1015901,306183,419511,98311,548751,767887,580211,766043,630628,481510,50465,158811,95884,164746,819099,650585,601340,659189,603582,159848,594353,997925,1043381,265187,778236,101635,70997,977626,586079,381929,816749,289730,369602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]