SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475128 LIMIT 1 [ RunTime:0.001177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475128 [ RunTime:0.003671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178586,863055,799083,584343,1044462,587474,953710,751067,115937,736345,1025603,311337,199129,585232,472269,623329,1033390,748492,623514,106489,155462,780970,377629,469769,467954,556583,401758,324891,16071,415406,920108,129485,606161,210434,181983,850521,265486,162221,53767,833469,952404,442841,238580,305229,586456,41209,178171,977714,632703,551372,72415,861137,750673,231460,250807,338873,3911,593110,702693,844299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]