SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535108 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535108 [ RunTime:0.002557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442288,824035,422114,1034479,379437,358702,554238,92312,445566,1021399,853401,685108,993073,909512,782996,116328,315078,952543,670220,817692,813135,32365,450126,286160,95778,413090,688261,429067,1040598,680157,502527,770096,319585,154029,41042,882994,59211,155441,606203,523038,478929,564978,161942,498665,608262,405063,1043078,426928,110104,771377,31403,424765,471958,978211,751055,348185,82278,274690,223729,207146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001300s ]