SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670860 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670860 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494968,220797,407244,271483,257132,573511,952859,637992,1047861,1004585,72789,687548,299914,521737,1035067,216629,537267,922365,679921,1045663,106746,625324,288429,472535,757606,468865,576023,428789,121986,112081,511310,855901,422038,541845,574330,485487,704750,554582,895749,773548,575507,19329,561207,955441,738472,182972,622811,338937,150108,853542,665385,931792,98500,843078,929978,215355,816576,659389,949085,775485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]