SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 714580 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 714580 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940422,823149,436278,28424,14942,477946,686614,347420,557635,580675,518243,564129,209029,89775,904802,882878,439007,387284,707165,506841,950274,239203,400351,749737,966792,376797,397224,966576,918046,462406,350313,130690,736891,251363,24863,814382,978768,557816,971269,315752,467202,929593,462298,395853,158267,186816,67095,439619,549438,120491,770240,548971,798485,625933,184231,905943,678147,203685,663146,491541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 714580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 714580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]