SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 911203 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911203 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131088,996012,629997,613838,276613,333166,134625,72661,773370,828686,200835,480082,811913,1043301,249659,227053,447342,400173,900117,568565,401399,80038,707866,29780,820350,599607,640210,985889,151130,26054,784942,256629,578331,425242,1002566,569668,117215,162543,322440,675300,186265,519420,34327,651736,732916,666515,704335,426547,302679,373214,912420,826809,207344,736104,361832,781480,153733,606121,576717,283126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]