SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427117 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427117 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186218,228728,545953,635577,667394,756622,452576,786858,334467,265669,300236,293272,886761,317683,65827,624817,429011,283444,769,532341,542095,260340,689370,485094,591170,508420,855307,545686,734210,948904,526715,316098,669361,575269,668479,630289,464458,618812,204070,240187,537648,526080,840014,39162,571321,911951,799557,626636,787189,877347,391575,328984,407380,317225,639329,436242,387444,331296,549798,189955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]