SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528084 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528084 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302812,127913,925947,1400,148939,223628,21274,613317,895222,138598,544001,164866,349758,350353,734398,12279,496050,645277,396670,753813,513190,831560,1037618,907408,1025328,1022613,55007,184494,704666,963529,80322,435218,238764,365211,867347,282865,1027484,756461,468740,200305,487197,211188,542542,927792,358383,871328,450460,405796,617381,740208,379858,758015,814051,424193,247800,386087,968293,197783,836745,1048895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]