SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 830309 LIMIT 1 [ RunTime:0.001599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 830309 [ RunTime:0.002798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480679,334208,1008712,835116,11362,13449,310351,889673,726626,217640,852589,824713,562534,503508,932099,571488,262662,320587,58960,1041241,216674,455568,269412,280162,549864,945506,57888,1027536,153777,355190,408618,334985,160011,644760,237740,451568,693228,385025,253512,711391,453646,605286,693263,522504,241136,68428,181846,266177,607020,566222,843438,908860,347190,187928,216388,909710,154962,421123,321000,764842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 830309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 830309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000917s ]