SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119211 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119211 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046261,1032860,561262,880178,589820,728072,414210,11652,591845,796823,580078,336656,197762,910030,589085,974466,15511,760913,50288,218340,711734,810757,18297,458361,643943,426707,386604,48750,418808,443068,555385,677285,629704,393190,496045,160269,366609,196604,879082,283947,411771,663129,567468,144262,209564,940574,65074,918858,276815,748063,1039566,185621,537758,617880,165439,191429,350358,158525,26447,219281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]