SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591843 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591843 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108617,389988,742134,161182,246012,365171,370143,981491,572804,594777,919428,577,962072,683557,743965,1034530,512096,299792,639742,195568,487278,297652,605894,528498,654194,884451,489817,747729,625852,872257,28182,378911,657620,977568,294825,552853,232591,605939,766832,671754,87265,570066,87353,1002266,262643,748202,1041029,111673,23252,762853,634987,548083,290453,850650,856727,509210,642945,28863,848864,200958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001854s ]