SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201010 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201010 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360914,852512,969597,263865,22240,963006,982805,802369,678453,295052,975677,124339,550255,162154,856544,973856,106161,328902,491055,462515,103271,1048287,248412,364418,974461,367764,265907,440270,929420,60522,1038452,957933,711039,461025,54901,256165,506716,528660,745745,819754,337925,930944,504517,409845,162170,93930,816301,630103,80543,124841,694429,445640,475414,901107,386898,341396,184027,1047183,464154,690656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]