SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419618 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419618 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844071,288007,478499,198295,373577,497553,406958,300955,945786,174776,867172,632404,39583,132104,749666,466960,126692,470659,456230,225213,442471,604480,1018245,77014,779238,793695,723626,837579,528074,120740,302362,900639,914571,2894,145421,93219,621082,274038,162137,162681,242549,474361,739460,4481,314669,502397,789612,790809,606298,493732,201422,918284,751013,63907,771220,735481,956089,422367,337520,237683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]