SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 830748 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 830748 [ RunTime:0.001436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405393,121077,19110,1020678,457709,151067,752396,239134,1012016,435688,238489,22556,748758,472484,36689,735787,89397,775122,848487,887478,1001116,1014408,197599,84192,638443,626905,474630,651167,867326,694381,1003127,452750,834667,466245,628949,582712,111872,635674,84426,366412,934878,132719,479785,302433,783278,188479,74604,443596,883947,828715,569423,702087,122970,692109,245872,711083,873296,358001,440591,703441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 830748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 830748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]