SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325053 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325053 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000868,1006703,950512,470661,208941,585808,486620,617109,1043166,691686,147180,815154,85217,316038,917152,48750,410064,1047880,198000,856623,1015151,90698,878686,395240,763782,469592,1040453,80418,812320,259574,669399,249107,949637,873498,518621,339756,617057,657011,444062,316552,484977,636201,357750,726381,945390,494695,994921,388853,137554,169023,318589,492806,940932,260593,766717,26153,362672,6033,571273,511591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]