SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685703 LIMIT 1 [ RunTime:0.001491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685703 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987300,461470,688155,338093,135753,846305,834504,774326,947392,53284,776846,298423,383785,331333,881259,466170,307171,244928,676983,103911,840689,467758,562527,842908,864956,560702,326757,617907,1021780,374507,129444,385972,983662,341305,335458,757282,825690,63896,991886,961670,732269,37446,203228,921094,198313,492522,718643,381475,280289,624298,298108,850843,431216,217803,98164,538918,424726,570881,820783,861219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]