SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546853 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546853 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968266,243911,493365,548950,294239,687796,147119,65529,919619,347793,438114,1010597,262172,753344,806129,695233,202501,64983,351461,417639,261805,1029503,788540,136961,88661,727552,978288,976853,338398,488015,618857,517000,456882,940938,946214,235821,813948,606748,872857,682393,422523,478130,704689,24090,799991,496225,1030098,40484,221625,727858,452798,255421,710929,991470,797041,914126,295918,589031,235243,144666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]