SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405712 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405712 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327534,783207,148942,413281,128516,830322,751444,474971,151112,543139,740798,255048,891377,29944,425731,273934,400386,720858,434057,539231,350222,554854,584481,709178,5017,355381,409532,467625,335369,792379,713813,929103,429444,851226,692971,599883,154143,296468,157464,682817,941568,823592,1004713,774219,349572,496225,460620,312840,540200,835393,957398,610258,952354,344715,416928,903410,270419,620278,976682,944550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]