SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281728 LIMIT 1 [ RunTime:0.000970s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281728 [ RunTime:0.003291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543237,617504,595856,1020836,721419,1047932,1003922,1046485,630988,577304,50464,285033,441257,907110,937507,263391,552479,932508,428326,888893,864093,988199,439507,636859,60425,634714,238340,71739,967097,586912,847245,506500,574824,756477,406110,748960,979765,838357,48843,775732,745852,976300,211534,386658,77448,223067,965754,146381,251387,536427,605872,470897,790666,509258,177623,256127,593391,424823,88988,535245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]