SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30514 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30514 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263435,409813,1036363,622191,1026716,238039,272986,717945,838091,150562,934086,549322,756125,1010096,596756,835313,235524,986836,644860,399192,295188,916401,125290,916559,701046,1041957,814449,67314,493430,675912,742225,314565,491784,94818,638257,260260,837912,711492,563788,416085,314279,884732,622637,588114,170352,105120,137612,667444,466771,894906,535322,369015,9148,889491,852933,359084,587135,912297,76325,916770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]