SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043457 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043457 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763175,959279,239675,792178,565155,571729,402045,720471,422472,820258,377110,463926,806406,1039201,799498,622986,381037,538803,786195,742775,794097,960549,272511,168752,189163,1000705,436852,861501,96059,963110,349060,217637,92276,217036,594108,76418,359492,195521,34025,687962,935481,567967,640305,690172,558389,85683,847975,552017,756196,1038279,982079,354981,177510,324885,218799,981849,66496,954249,204469,636043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]