SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410804 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410804 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57707,266890,143911,161078,788770,758740,772131,278921,441705,938036,963151,970037,964475,210391,553216,352747,404305,953854,735810,189718,204122,947091,745425,447586,238492,175228,344681,679130,392975,608080,782942,40114,433169,556715,578035,666493,932729,319507,473424,142022,659738,384771,829130,629333,291226,428265,732933,865306,431207,157764,707078,323954,378436,1021078,574056,507583,123475,386539,458136,718430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]