SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405713 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405713 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730961,547415,97325,959082,901115,633205,216765,1007970,296187,1003501,28719,905089,177852,329740,973942,64126,404929,932902,298919,769588,849725,225266,1038692,491711,883803,719829,1511,86201,494138,761729,56878,43107,413005,580086,945611,571978,1019605,116765,892831,30400,186009,472937,496521,574265,774326,473193,868957,508632,967552,514422,841008,843793,290900,65800,621344,143421,432633,987101,1019945,954123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]