SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311188 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311188 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300081,592932,226270,161112,753900,708588,116864,992232,940199,365862,1067,380374,207735,236520,487755,975163,367297,829716,320443,826298,964481,1034635,803601,764933,97859,651827,889125,396035,986773,758739,351557,101212,926479,157073,291948,951434,562127,562173,116448,236711,862707,86932,980407,426356,414034,709930,327308,585484,141160,970977,449901,954528,747931,711795,380186,824010,847752,845962,937409,108125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]