SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340095 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340095 [ RunTime:0.003532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119358,646809,197071,813241,560111,107168,955744,390993,872001,165748,579841,170030,717784,686115,286285,16410,840849,407011,194849,989714,366886,809384,667921,908858,704967,723244,778233,949813,817078,614718,924661,525806,856452,1015250,911351,610025,287605,684579,287197,247062,542836,17062,498484,539977,645984,279393,414997,696056,1043785,281484,614696,91599,1018704,725401,972681,622497,280193,492116,558159,714419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]