SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 373901 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 373901 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701972,638164,381615,1038763,196632,646169,287942,19249,731316,1042120,853997,631411,544911,171448,953901,255534,899279,558867,921112,397998,855546,702896,553405,124993,14585,1018176,169318,1043962,544065,186702,872494,354138,455007,2921,548959,896944,731039,727780,682668,760100,999800,778301,1039944,727644,828812,765810,263607,24794,270365,568518,46516,760403,641694,204000,96584,177428,770816,879901,8469,1005711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 373901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 373901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]