SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536018 LIMIT 1 [ RunTime:0.001028s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536018 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23414,50848,677953,798593,223986,273273,469238,1010589,982452,344935,321967,82,392517,866080,258297,686515,937342,419333,276287,531618,566239,691983,1046502,402475,35722,931880,545868,141337,355796,976847,942969,650298,502671,242238,851340,790020,412224,546313,96375,206491,522623,782296,514471,91554,478528,237728,596585,764575,164054,70653,994255,983007,939756,375499,7149,493321,887121,449098,908786,38378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]