SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584943 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584943 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368162,89427,956632,616568,261291,736913,536166,444959,528728,300307,355480,580545,412861,752753,168332,744960,936303,545961,1043674,895481,140456,118075,173045,514137,614090,838309,477870,46048,865084,723773,282734,282000,62003,170366,525809,690822,819684,928482,563092,42328,541208,367559,671981,787671,440946,415503,861032,389801,199260,63010,20025,1027236,89809,697660,654024,1014915,194237,656115,995477,773603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]