SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52110 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52110 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907499,296989,454237,597786,653799,596322,758159,103375,15607,240601,660420,829674,499094,600562,657831,460943,933096,397898,866179,800254,1007189,124507,558502,258837,1001969,615399,2311,561149,839382,761220,687692,248191,79220,1029949,563801,78444,695699,864866,337872,477439,187682,109762,734140,184560,5194,1003678,187519,444911,982754,764484,172828,41618,163850,647348,752031,1026867,3190,649229,195060,877131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]