SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039472 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039472 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401051,715,1010552,538948,965591,463883,940648,647576,873555,57824,253307,16731,273771,130931,953830,105481,410522,693496,969317,934384,153326,83342,854402,269260,695193,689012,709822,409517,906143,725523,856386,43728,791551,508337,660118,166985,134081,153688,135082,55892,218652,521309,37669,140784,617119,566476,788526,985863,530032,442304,608757,295806,850700,572736,159373,803715,667585,532958,110551,342927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039472 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039472 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]