SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981014 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981014 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503815,93480,666486,432484,656560,851250,295914,381134,986529,896001,818334,598490,497596,130440,40699,253535,136235,694331,472897,63880,844326,54199,825440,653053,967272,409464,1046444,252975,952838,189411,539524,107815,5486,42387,191842,692954,561776,198140,411025,410063,374203,35189,919704,208720,1024296,702269,727398,439503,441783,477355,446816,538612,36181,797739,799699,933991,760873,91153,269325,344133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]