SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320110 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320110 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15458,335994,686783,617930,107680,29451,835830,932846,374132,388537,483924,1012957,472460,585055,780158,26879,536367,939655,317434,806926,917588,935116,855329,784977,830036,285288,852298,137955,1033247,146892,90517,78530,883014,439237,405227,314187,514863,447933,265464,576804,992296,966322,659320,251450,135283,595169,115697,824279,369101,768182,161875,836549,417654,181405,964231,1005900,27483,351008,126555,880349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]