SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201909 LIMIT 1 [ RunTime:0.000534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201909 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660209,631501,210264,327315,68149,857737,563143,209122,446621,456102,141213,269148,728857,442010,271081,178598,766702,986846,231862,594441,269084,623231,914834,600862,294291,857726,683200,1042972,617058,402455,431704,305646,647104,826253,827479,774991,469347,443608,856674,604775,39444,1031420,882567,512781,358417,524031,181042,987374,850683,797175,531262,328119,840912,695062,1025774,894956,479295,978146,301967,291167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]