SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580828 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580828 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355735,877294,345538,699441,440786,559681,1039428,858633,327725,614908,20196,27555,348308,960123,33653,437110,282538,385743,746554,669833,563555,1004406,324755,22585,725694,294578,791564,929618,589220,538678,257471,143529,881049,612751,566993,190595,93450,762415,256376,522654,337315,670102,1009122,331901,174235,77043,918819,1014047,736595,868792,227099,737887,55515,677733,913578,201931,625173,225292,238001,1043305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]