SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545131 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545131 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312866,940565,704220,881622,904972,719207,660418,400563,869852,987641,545313,535953,48508,536749,536321,493232,964365,613797,675451,1000322,239452,964029,1027004,311684,149719,950423,574769,594606,856599,756362,58265,957419,158813,1045197,903188,814353,757415,34839,566638,915240,426713,283708,664132,844390,344415,793232,143167,438101,1010385,10104,667201,734482,720598,460715,598099,629234,289705,717170,179798,303847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]