SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398685 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398685 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998484,67061,912054,555270,261928,559725,914434,469957,775940,957843,255370,848879,801231,528299,80504,253069,988420,54689,318406,783548,694746,539515,571866,339806,58437,562734,427333,455447,17384,838482,757781,958881,412855,599821,505904,483226,1007536,16408,118841,1025939,598013,121045,380625,169448,421562,408276,114388,434234,991579,497876,117746,402228,177264,951506,286301,366717,159146,257973,497159,950540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]