SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522414 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522414 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676519,614578,467139,41007,506766,987087,426245,399236,109622,927590,10860,823922,434703,965203,636980,305380,240085,577726,366668,211031,557980,26179,482946,662183,518301,105118,267415,191344,546800,759558,286407,436496,379980,746066,197733,887179,774012,290820,646670,282232,767723,841761,572471,421392,210435,560108,81811,873880,567242,218568,750967,287868,161744,66650,1018037,633484,911123,816626,995309,497014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]