SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545413 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545413 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443319,918045,619134,978401,758721,147155,263803,270793,499819,465236,83242,573981,548882,937071,752465,40418,173171,468185,627490,505908,517070,682355,699160,703811,199028,139009,150729,658300,170737,229294,167465,943955,561740,811547,888187,326248,584331,554614,806544,428957,212002,602098,447744,311599,926720,12700,456439,505969,880747,954510,992107,556893,577880,782301,156715,313317,779301,141487,349538,821963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]