SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447668 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447668 [ RunTime:0.002657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507908,370162,992846,154046,309864,415996,799758,843411,889429,477273,765858,624078,439346,293064,135558,81343,775545,142607,795034,235416,694313,314992,625183,865138,749621,631265,419224,383890,16895,227152,180184,1046766,588350,690247,986666,271197,102788,110687,470218,149822,921229,792074,983257,710961,933598,528439,987028,82305,651820,415890,278397,679636,303740,399252,957948,1024087,205540,851956,458980,293602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]