SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013991 LIMIT 1 [ RunTime:0.000750s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013991 [ RunTime:0.002622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114766,975601,683609,754533,799580,39588,94004,506251,219877,151074,830084,426703,246793,617803,463270,394971,734772,622079,292745,985522,62660,914129,97257,508408,817276,905918,590878,645222,318932,601239,510707,318991,681273,906383,701933,277730,853340,125275,945195,299913,966752,584848,930859,338772,708889,704289,187356,821232,976675,294490,627598,437008,644833,986188,924951,965241,312982,85643,284095,81126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.011221s ]