SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473800 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473800 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265984,887699,418444,1008482,1016741,125889,161066,214742,392419,357168,401188,281585,347743,42728,229950,395810,573453,929661,708773,787272,674142,263765,563712,961646,902183,54304,570503,922416,122749,109191,878591,953503,483993,821892,227008,564557,283583,386488,546254,512156,852624,200782,137554,753169,3197,491048,953259,84974,693482,177874,605287,760413,986897,573468,496566,696086,717923,11090,357166,821147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]