SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022109 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022109 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330113,181380,514104,832941,348125,266185,549450,542864,871966,534190,39313,830239,433904,54191,989418,221554,140412,74919,270049,215397,606886,110739,818999,867110,324760,598387,693157,349120,395281,965708,401778,52450,497735,686249,598647,800680,913887,898907,744982,336715,80164,637494,2584,198374,443975,964886,189270,972565,658065,786638,273411,870917,987917,876387,1019192,154018,83896,857610,415986,948245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]