SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250433 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250433 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018056,778847,361703,964864,52067,5065,726916,497182,646342,521804,379030,947549,764033,188163,744088,335863,615284,653041,828126,1013309,416364,283377,288931,818568,153770,139224,418384,537930,251449,25880,941411,847405,270975,562150,360145,1036729,236627,61030,741935,1034468,670272,316401,266576,943087,146390,173932,501598,139314,444355,591314,649867,361824,544300,236413,916958,399625,1878,750102,976643,242748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]