SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334571 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334571 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171018,880869,224179,785997,610297,476140,661585,962546,274732,833214,23765,870027,177789,582895,772178,191946,169887,422620,576953,411985,1016304,601747,894496,269776,670784,153288,592999,144888,152885,756099,140789,229238,530270,913088,751711,78213,762856,498904,965093,234130,1028431,357289,654812,201249,959284,1046987,673853,216168,335647,943722,1012573,896053,514916,20928,752813,192726,416472,248915,330591,565854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000874s ]