SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002662s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399891 LIMIT 1 [ RunTime:0.001094s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399891 [ RunTime:0.004937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379886,861866,195260,689678,27231,494957,535483,1007838,185521,1013677,197387,493260,659844,282045,266315,229399,106621,312564,202775,115459,57114,1040170,586916,399445,703285,43424,461587,909621,308061,806924,422314,463749,306825,697680,853324,271543,505194,492030,504703,225548,469521,710854,319941,966183,655607,810038,482886,28352,19418,431390,813550,124077,56856,649788,447625,262540,513648,932148,749356,396417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001667s ]