SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401632 LIMIT 1 [ RunTime:0.000953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401632 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347027,836605,929871,1019094,603399,678322,160051,51239,916389,107810,838231,159475,579965,88696,442297,812632,933282,516960,485152,118637,442980,504303,351870,805090,637384,969839,764081,612709,976979,991085,966688,628041,147254,696524,567253,485951,944777,448102,951654,843298,78136,282039,709766,943593,991606,1023877,280361,136967,145463,655649,728312,1038057,739723,1033126,258175,91154,886511,215740,590976,846233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401632 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401632 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]