SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328166 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328166 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283600,823148,181366,205461,532272,184018,872042,999523,950605,573126,226161,923580,528011,1035386,137694,363534,950182,108062,45378,663167,848330,88654,942371,170736,153124,964647,198146,1043491,82004,684296,83388,949022,561308,4125,665359,493846,827155,704454,923135,6112,661484,599355,486345,818207,772691,402947,161629,485340,650700,357012,594471,416623,242048,600386,309586,319009,1025469,1031132,27978,930269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]