SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422778 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422778 [ RunTime:0.004399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830848,462340,190723,855623,6352,985673,295791,572743,323538,801482,482205,930790,203606,1048792,956714,964188,152752,1020268,807568,200983,334607,248433,593428,871185,94130,575428,623489,613355,954707,586643,211460,793193,613903,726954,81160,578415,231739,712671,746104,446548,167480,297881,542433,306666,36778,54091,185507,488238,838842,91156,152105,349637,768003,730996,505275,177910,443452,67722,869939,45891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]