SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510540 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510540 [ RunTime:0.005588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913530,778645,183995,46139,341474,759790,91496,192968,859025,822380,62978,509104,241151,288406,22300,1041847,645313,699533,604640,494396,777246,49073,88128,681642,382247,844118,441898,617327,574308,989166,1029491,354526,586078,678203,774129,70290,904824,254139,219253,351081,369438,329258,923125,405370,539470,679307,105578,825378,246534,123419,746593,174115,572819,709072,113876,195143,114378,633440,485294,219744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]