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` = 431928 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431928 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711447,491662,220764,561920,323009,852304,663088,704490,145225,270812,107434,339043,822286,398411,54448,515808,119285,968142,120029,355709,502130,422382,957342,246288,386837,771185,786946,377895,971489,144140,1043153,236001,307490,275884,673840,704219,898513,832353,105302,965400,617815,518279,511858,843260,398230,398408,140780,947663,800301,871866,899826,253011,764235,4635,481390,773654,1007863,225957,582036,304215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]