SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40670 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40670 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198399,38344,639877,548554,251546,106713,157875,953601,123991,887472,298231,870305,396019,953164,495101,93006,477197,822394,556074,320188,953307,199888,534030,687904,255360,955923,351028,262134,946588,147134,114894,1034348,551577,68334,292966,287149,964642,652653,926248,516525,86864,971603,522935,525167,911516,432422,679525,802170,8723,661653,76738,916856,667626,740227,378297,502170,967908,222377,266780,42696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]