SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197431 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197431 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563681,65492,641033,707383,726228,631771,278374,127173,532618,392718,8181,1021200,593330,1008013,297711,835190,969840,331161,246823,1037857,550240,96629,475396,368104,716789,940372,993430,457791,159360,262032,121292,805391,734420,478074,650905,240321,909704,1036742,344850,651632,198503,147839,387487,429456,861208,547542,766037,413744,174996,144701,151815,573593,1009763,139012,819567,558412,857659,722972,732204,143622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]