SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001963s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610423 LIMIT 1 [ RunTime:0.004143s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610423 [ RunTime:0.005736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670953,163910,276402,381476,312278,456169,244870,792800,37363,150051,376781,752566,873608,928809,699148,122129,590701,290017,81309,573666,122404,720812,421000,721981,618518,840345,50531,740362,557246,704803,927883,789787,560621,606007,4644,787378,864556,937739,145655,690047,85560,555793,405108,328663,561918,188836,165772,766730,334665,891853,270749,114235,61253,710688,543384,870056,772975,813460,407819,143550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001608s ]