SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20120 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20120 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563605,210262,302827,473914,106286,697990,329014,584215,613421,883765,650653,1010368,702575,527334,294659,929683,504091,676303,204134,1032697,377106,960803,67861,162249,182609,875475,146480,1011797,734541,1032384,174651,345642,1005728,179802,707754,381465,361133,801888,127306,422079,993365,668958,329087,428597,630328,312600,657869,978887,756185,770404,987024,385775,502352,713779,843632,162956,891015,850834,608273,916385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]