SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982014 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982014 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65348,578618,1033003,891845,920435,753865,270343,356239,711818,487983,518738,323143,983255,856866,679092,338372,927007,169014,902212,397780,435373,80033,95729,832807,163785,253062,595414,541479,902587,247898,117629,997984,809921,208724,941505,886470,603344,839587,483037,507934,192379,772316,403748,160845,367229,213998,282960,899544,76794,668934,180116,184016,799740,798606,315831,941138,350999,565003,242963,425203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]