SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403920 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403920 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155251,206715,29964,192703,858842,875176,663854,94860,175870,575014,123576,589276,113537,173941,608092,726664,701823,581946,760691,1030504,825540,405789,914884,272928,405599,35524,129898,839140,316208,455524,755519,420279,394915,15788,853815,780581,754104,966984,984647,250268,669219,450975,847304,97846,424388,381828,207780,32696,46267,405904,286336,397091,3973,563321,556216,1037416,777866,653727,656505,102111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]