SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339447 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339447 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014842,1038934,336378,493993,211754,131804,609531,714018,206707,710583,996882,885747,128692,965923,807154,540982,613981,119174,34270,343891,189545,257055,5389,239014,882115,676793,207185,177994,223125,126669,572113,128199,842381,1015114,485487,265590,1001033,427904,827213,121619,942194,69693,1044304,620023,296270,703448,917522,846544,820144,458819,296755,690757,35306,708630,220504,782058,878173,521955,368904,128514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]