SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382627 LIMIT 1 [ RunTime:0.001568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382627 [ RunTime:0.003036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897701,562330,1040873,341865,743553,383652,37595,183506,199300,1034280,109428,393202,970677,692396,111438,181012,12864,923502,825775,816530,1003889,809921,673279,981391,391946,143998,697310,858805,774706,363691,461059,957822,280174,204156,881816,125700,490928,1027829,589055,190580,1043167,701659,275154,505706,1032819,298827,854965,849287,35110,384854,851273,85886,763845,174036,414496,967109,678075,813664,1044130,928740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]