SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681160 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681160 [ RunTime:0.003651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246089,1026028,147695,784487,271565,321995,324577,792240,717674,204557,335960,973135,210022,320774,246605,344665,1047985,955467,301425,95909,416140,172913,873245,654732,398814,149489,874040,604779,504459,1048515,401556,994600,700087,1758,634082,940834,442001,575241,512782,538740,205184,898427,851852,590952,389714,560319,743971,277705,1037909,42511,601247,9198,719582,631041,725011,504162,182586,760013,370583,598825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]