SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401292 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401292 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725392,722878,990225,819787,743981,239684,392700,367849,898098,960994,63785,771715,603309,51806,470727,757356,198721,31303,834343,487733,40864,178241,252759,790885,158070,773481,710337,956196,947212,1026559,984412,113969,62088,511540,748558,489105,316045,24066,956614,189079,337529,184862,121586,765755,956013,337926,110689,330851,258848,705664,69180,957861,785791,823616,304010,1022086,204287,775741,910277,40426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]