SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439531 LIMIT 1 [ RunTime:0.002390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439531 [ RunTime:0.014858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245131,223713,740574,851353,971241,141722,492220,112669,774078,138647,469162,448911,1043736,31505,690827,764371,930557,183277,717561,891706,787122,654040,699050,41804,851900,758878,450465,1009153,29168,335179,885287,1018304,45460,20725,840813,430135,317356,960764,728795,731674,262118,228661,866221,350449,90402,398361,281522,536108,172980,913449,327882,33069,905215,497076,263016,751641,140629,948948,914389,502217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001004s ]