SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427945 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427945 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195232,353376,228275,862195,821797,1039360,225725,513542,215025,919734,672998,6135,104390,55548,260054,133857,277051,584479,22433,713756,843935,642144,131825,799404,325735,416923,556478,825148,737188,170457,120106,21161,932159,856541,676404,944762,729194,340998,200775,540000,353896,699796,882618,644447,355062,41109,702858,193232,645260,818169,1009228,350858,754585,983894,1006968,658443,218046,605223,119852,851508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]