SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001977s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426088 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426088 [ RunTime:0.005015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565023,417996,463260,434655,462118,1046527,657045,152979,118589,461195,640200,931512,773740,304563,347734,322285,769159,3379,864415,470149,383689,275849,46857,551648,977869,319928,234482,599180,686402,1043774,361484,833452,167078,278970,198291,282342,12982,612698,767597,598530,877672,271081,76061,877315,488226,927798,511503,285190,273750,699707,284040,293371,902518,456008,259924,976635,993053,366354,829528,288792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002356s ]