SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28988 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28988 [ RunTime:0.003989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459688,879070,228494,805013,394916,780363,643011,462037,438816,244417,755436,1015501,513921,27256,438289,915310,349419,691939,913938,190040,509857,304751,990359,324943,339596,227571,981144,232622,693340,238599,613084,246450,1013244,2812,434629,451004,175405,732612,144842,721151,675573,1017354,947425,360184,862595,940065,835475,164231,45223,102707,401441,498909,454034,402797,902313,720001,277413,79789,715688,9735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]