SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3150 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3150 [ RunTime:0.004141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634489,786874,651182,462968,566741,563738,957171,273251,108103,459653,78543,367160,964398,479599,474846,37978,946441,863034,725399,674408,606884,393530,300261,394883,592965,233489,655962,819322,369680,34620,775446,535458,646276,765482,469792,779011,70953,458240,1037295,460890,223903,214931,204864,158720,1019670,469020,884599,717941,132560,349970,599885,1014972,109728,440870,154747,68106,592559,620114,758321,812466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]