SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280102 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280102 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495354,217329,279744,1440,265079,275101,751705,504837,393278,272502,336905,32573,85135,115551,195989,866287,121197,5871,551091,492261,738366,544613,874905,4631,519325,330166,269500,626352,222368,268360,47864,349790,821754,347074,902457,7817,1021799,842076,801219,295175,402888,905109,38810,442400,772695,390376,510237,344997,700364,510276,334758,772565,171238,739968,601429,965210,1038283,17115,732621,584932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]