SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2983 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2983 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837938,670604,603642,937262,11230,147478,919782,1018835,273647,45054,374230,455289,394699,667070,443365,147488,715173,537120,814586,519037,601830,103761,949942,235353,36111,127180,829744,651767,841615,598219,170185,1026080,588229,1023455,697664,209867,182596,758588,1006583,314694,61731,281100,109448,149067,903477,286365,818756,956796,1044595,574848,932969,391137,93,731565,385092,6931,716130,594330,743001,1001225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]