SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98142 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98142 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74679,580127,455777,639331,977181,87999,722576,308474,729733,806203,371914,131221,1002498,699834,1006850,987430,671268,948320,964013,609428,109222,965919,744150,308435,452926,458765,896677,467502,475269,751620,65497,237087,797887,746201,615696,700211,678743,632987,69521,359748,398925,452923,793431,752872,553011,451569,38597,927832,383708,709442,847255,421728,201601,68996,285218,117179,781325,890980,492897,209471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]