SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428064 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428064 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005858,318240,197411,983960,117231,744816,395849,853614,1037305,176616,73148,789295,413558,56807,664246,465567,493284,965610,4412,921115,936469,298608,436993,982500,361736,276346,924935,324542,270864,610420,212888,32254,48212,112802,722049,792546,194757,359478,1038759,284624,450193,671396,369807,809348,1026192,133044,563064,691445,700495,3312,13275,763400,33300,100008,644594,771708,381897,1043676,674747,90899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]