SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533360 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533360 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420064,57199,320508,576483,670390,253065,258817,380661,771797,387196,259496,617504,576127,485140,517705,747431,884554,794770,921349,1033678,21849,302193,722458,44620,249196,914814,824577,484694,242153,109070,389991,870923,432187,211650,772325,165793,812160,523338,773557,519247,931214,589240,1019721,703211,511263,123354,224833,238204,954522,673115,105002,102514,901040,170899,346531,521906,860967,727220,837887,562039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001691s ]