SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582481 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582481 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352679,402058,186887,534639,908356,52720,848686,466645,885609,679477,697168,907805,352165,995890,511936,507167,469309,506242,703248,151957,593729,557195,414617,986361,476592,675531,468952,269085,762272,920687,743336,257406,732286,503600,745726,398846,239434,670677,982030,695139,649210,684770,324023,391022,1047652,828342,627819,794018,690821,392375,962139,613138,528643,409708,1015358,663711,53199,620914,300703,976907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]