SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501729 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501729 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522184,837405,419470,854960,424693,26428,1016279,248475,172170,455411,47014,467868,709211,510221,304196,480727,75822,88385,475798,879117,500447,269335,513380,668957,127226,78368,556281,962032,718186,243477,1048271,306847,42507,503073,401920,638305,808873,710094,1037393,261039,83130,507522,397107,775008,450872,246944,93074,16250,34926,868753,198175,46308,867192,562992,369342,294525,1014826,334494,767196,852351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]