SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113113 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113113 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541238,605970,573804,824002,880512,154747,930804,513221,38387,945839,168970,209007,1037975,682846,561762,906944,406613,1002671,589043,1010243,441983,504208,159032,1002798,998404,742891,488194,286253,557365,420180,463775,137936,604865,714137,914562,228033,133525,562710,561596,491086,89335,554178,883404,610352,468729,784502,333744,861174,145337,15039,253466,748966,902915,1010249,203211,670049,1025571,466109,245940,272368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]