SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031307 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031307 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634000,119111,932402,312334,438009,917953,797326,781114,370679,246741,381289,928831,622930,516248,830271,824909,616981,174332,67193,537707,5757,73474,394474,861157,693993,409245,1010895,268479,98864,503470,335453,43959,364304,986476,335204,484495,314359,222002,545,587563,275414,570267,192520,336389,896083,157070,772513,166637,639412,376045,658626,880602,1041002,1022384,100379,815073,585330,234859,773923,780869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]