SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 848213 LIMIT 1 [ RunTime:0.001803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 848213 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485432,478758,265788,729198,339434,606262,46456,733043,439961,90992,674623,893894,934132,287585,301170,1024577,385139,716484,33745,492539,626263,720062,933384,801690,175479,644991,287353,838304,24105,446733,122109,582885,346630,19846,517143,914416,207291,809443,32229,397769,644310,204754,736011,527268,187948,952350,48856,105010,311455,868271,117521,107268,190102,1025410,546237,277374,986273,456041,358069,842672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 848213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 848213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]