SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043843 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043843 [ RunTime:0.003267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112182,433761,250335,708916,774236,537519,234129,770072,451601,465316,843961,910523,930598,595512,867505,1009496,851261,997286,599939,904981,229512,842049,568762,462224,46856,419340,751413,91858,775544,76777,1035915,888792,45796,799048,285521,964572,395490,273081,405193,363442,329586,433923,926378,330944,302876,887093,424183,363155,1006204,200004,443692,921264,682218,846106,913359,760655,579419,729388,616972,718433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001024s ]