SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 635403 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 635403 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456613,196235,574440,1028117,230206,59695,154847,296671,183813,277899,138297,117400,380053,525048,672911,151743,265045,396278,851550,389300,184642,914752,838247,1039325,986231,748860,643855,652410,779610,646774,509742,996978,433656,675963,305799,1011352,57184,649340,697271,959557,224011,697558,21034,656233,86566,966184,806628,353597,358742,518891,600127,887240,834179,582388,348848,116194,744948,966045,311109,611567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 635403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 635403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]